Houston Open Data Explorer

← All datasets

# curated.facility_trauma_center
Trauma centers (56 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 56/56 | e.g.: 34; 18; 32
- attrs->>'ADDR' | string | 56/56 | e.g.: PO BOX 889; 1504 TAUB LOOP; 510 W TIDWELL RD
- attrs->>'BLOCKGRP' | string | 56/7 | values: 2; 1; 3; 4;  ; 6; 5
- attrs->>'CENSTRACT' | string | 56/51 | e.g.: 313100;  ; 555400
- attrs->>'CITY' | string | 56/31 | e.g.: HOUSTON; HUMBLE; CONROE
- attrs->>'COMPANY' | string | 56/56 | e.g.: BRAZOSPORT MEMORIAL HOSPITAL; MEMORIAL HERMANN NORTHWEST; TWELVE OAKS MEDICAL CTR
- attrs->>'COUNTY' | string | 56/14 | e.g.: HARRIS; BRAZORIA; COLORADO
- attrs->>'FAXNUM' | string | 56/19 | e.g.:  ; 4099385001; 4092966326
- attrs->>'LATITUDE' | string | 56/54 | e.g.:  ; 030.282944; 030.173779
- attrs->>'LevelClass' | string | 56/7 | values:  ; Level IV Trauma; Level III Trauma; Active Pursuit of Level IV Trauma; Level I Trauma; Active Pursuit of Level III Trauma; Active Pursuit of Level II Trauma
- attrs->>'LONGITUDE' | string | 56/54 | e.g.:  ; -096.343376; -095.556315
- attrs->>'PHONE' | string | 56/54 | e.g.:  ; 2814771000; 4099385000
- attrs->>'STATE' | string | 56/1 | values: TX
- attrs->>'ZIP10' | string | 56/55 | e.g.:  ; 77434-3202; 77074-4389
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.