Table # Values
licensed_facility_listing_01 1 oshpd_id: 306430529
perm_id:
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Community Clinic
dba_address1: 1898 THE ALAMEDA
dba_city: SAN JOSE
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34086760
longitude: -121.92246650

licensed_facility_listing_06 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

licensed_facility_listing_07 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

licensed_facility_listing_08 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

licensed_facility_listing_09 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34086760
longitude: -121.92246650

licensed_facility_listing_10 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 THE ALAMEDA
dba_city: SAN JOSE
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34086760
longitude: -121.92246650

licensed_facility_listing_15 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

licensed_facility_listing_16 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

licensed_facility_listing_17 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

licensed_facility_listing_18 1 oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 THE ALAMEDA
dba_city: SAN JOSE
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds:
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 0.00000000
longitude: 0.00000000

licensed_healthcare_facility_listing 7 period: current
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 THE ALAMEDA
dba_city: SAN JOSE
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34086760
longitude: -121.92246650

period: 2020-12-31
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

period: 2021-12-31
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

period: 2022-12-31
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

period: 2021-06-30
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

period: 2022-06-30
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000

period: 2023-06-30
oshpd_id: 306430529
facility_name: ROOTS COMMUNITY HEALTH CENTER
license_num: 550004774
facility_level_desc: Parent Facility
dba_address1: 1898 The Alameda
dba_city: San Jose
dba_zip_code: 95126
county_code: 43
county_name: Santa Clara
er_service_level_desc: Not Applicable
total_number_beds: None
facility_status_desc: Open
facility_status_date: 2020-04-16
license_type_desc: Clinic
license_category_desc: Community Clinic
latitude: 37.34074000
longitude: -121.92289000