| Tables |
| hospital_building_data | |
county_code - varchar(20)
perm_id - varchar(7)
facility_name - varchar(85)
city - varchar(19)
building_nbr - varchar(12)
building_name - varchar(87)
building_status - varchar(40)
spc_rating_ - varchar(12)
building_url - varchar(144)
height_ft - varchar(11)
stories - varchar(7)
building_code - varchar(35)
building_code_year - varchar(18)
year_completed - varchar(14)
ab_1882_notice - varchar(118)
latitude - decimal(12,8)
longitude - decimal(12,8)
count_num - varchar(5)
|
| hospital_buildings | |
county_code - varchar(20)
perm_id - varchar(5)
facility_name - varchar(85)
city - varchar(19)
building_nbr - varchar(9)
building_name - varchar(87)
building_status - varchar(40)
spc_rating - varchar(3)
building_url - varchar(144)
height_ft - varchar(6)
stories - varchar(2)
building_code - varchar(35)
building_code_year - varchar(4)
year_completed - varchar(4)
ab_1882_notice - varchar(118)
latitude - decimal(12,8)
longitude - decimal(12,8)
count - varchar(1)
|
|
|---|