← All datasets

# curated.facility_hospitals
facility_hospitals (108 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 108/108 | e.g.: 75; 96; 13
- attrs->>'ADDRNO' | string | 108/105 | e.g.: 6447; 01300; 02800
- attrs->>'ADDRNOS' | string | 108/1 | values:  
- attrs->>'ADMIN' | number | 108/2 | values: 2; 1
- attrs->>'CITY' | string | 108/15 | e.g.: HOUSTON;  ; PASADENA
- attrs->>'HCAD' | string | 108/73 | e.g.:  ; 1179360010002; 0021170000001
- attrs->>'NAME' | string | 108/106 | e.g.: METHODIST HOSPITAL; SAN JACINTO METHODIST HOSPITAL; HEALTH BRIDGE CHILDREN'S HOSPITAL
- attrs->>'PREFIX' | string | 108/5 | values:  ; S; N; W; E
- attrs->>'STNAME' | string | 108/79 | e.g.: MAIN; FANNIN; MEDICAL CENTER
- attrs->>'STTYPE' | string | 108/9 | values:  ; DR; BLVD; RD; ST; AVE; WAY; LN; PKWY
- attrs->>'SUFFIX' | string | 108/4 | values:  ; W; E; N
- attrs->>'ZIP' | string | 108/53 | e.g.: 77030; 77090; 77004
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.