| Tables |
| licensed_facility_listing_01 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(42)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_02 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
longitude - decimal(12,8)
latitude - decimal(12,8)
|
| licensed_facility_listing_03 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_04 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_05 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_06 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_07 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_08 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(22)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_09 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(31)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_10 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(42)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_11 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_12 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_13 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_14 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_15 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_16 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_17 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(22)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_facility_listing_18 | |
oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
| licensed_healthcare_facility_listing | |
period - varchar(10)
oshpd_id - char(9)
facility_name - varchar(127)
license_num - varchar(63)
facility_level_desc - varchar(63)
dba_address1 - varchar(63)
dba_city - varchar(63)
dba_zip_code - varchar(20)
county_code - varchar(20)
county_name - varchar(63)
er_service_level_desc - varchar(63)
total_number_beds - int
facility_status_desc - varchar(63)
facility_status_date - date
license_type_desc - varchar(63)
license_category_desc - varchar(63)
latitude - decimal(12,8)
longitude - decimal(12,8)
|
|
|---|