cdph-skilled-nursing-facilities
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- id
- The facility's unique identifier with the state.
- name
- The name of the skilled-nursing facility.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- staff_confirmed_cases
- The current number of confirmed coronavirus case amoung staff at that time.
- patients_confirmed_cases
- The current number of confirmed coronavirus case amoung patients at that time.
- staff_confirmed_cases_note
- In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
- patients_confirmed_cases_note
- In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
- staff_deaths
- The cumulative number of deaths case amoung staff at that time.
- patients_deaths
- The cumulative number of deaths case amoung patients at that time.
- staff_deaths_note
- In cases where the staff_deaths are obscured, this explains the range of possible values.
- patients_deaths_note
- In cases where the patients_deaths are obscured, this explains the range of possible values.
1,224 rows where "date" is on date 2020-04-23
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | id | slug | name | county | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | fips | staff_confirmed_cases_note | patients_confirmed_cases_note | staff_deaths_note | patients_deaths_note |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
773060 | 773060 | 2020-04-23 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 29 | 39 | 0 | 1 | 13 | <11 | |||
773061 | 773061 | 2020-04-23 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773062 | 773062 | 2020-04-23 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773063 | 773063 | 2020-04-23 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773064 | 773064 | 2020-04-23 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773065 | 773065 | 2020-04-23 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773066 | 773066 | 2020-04-23 | 140000885 | 140000885-san-ramon-regional-medical-center-d-p-snf | SAN RAMON REGIONAL MEDICAL CENTER D/P SNF | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773067 | 773067 | 2020-04-23 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773068 | 773068 | 2020-04-23 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773069 | 773069 | 2020-04-23 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773070 | 773070 | 2020-04-23 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773071 | 773071 | 2020-04-23 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773072 | 773072 | 2020-04-23 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773073 | 773073 | 2020-04-23 | 140000049 | 140000049-vintage-estates-of-richmond | VINTAGE ESTATES OF RICHMOND | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773074 | 773074 | 2020-04-23 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773075 | 773075 | 2020-04-23 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773076 | 773076 | 2020-04-23 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773077 | 773077 | 2020-04-23 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
773078 | 773078 | 2020-04-23 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
773079 | 773079 | 2020-04-23 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
773080 | 773080 | 2020-04-23 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
773081 | 773081 | 2020-04-23 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
773082 | 773082 | 2020-04-23 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
773083 | 773083 | 2020-04-23 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
773084 | 773084 | 2020-04-23 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773085 | 773085 | 2020-04-23 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773086 | 773086 | 2020-04-23 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773087 | 773087 | 2020-04-23 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773088 | 773088 | 2020-04-23 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773089 | 773089 | 2020-04-23 | 40000043 | 040000043-dycora-transitional-health-community-care | DYCORA TRANSITIONAL HEALTH - COMMUNITY CARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773090 | 773090 | 2020-04-23 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773091 | 773091 | 2020-04-23 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773092 | 773092 | 2020-04-23 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 0 | 1 | 0 | 0 | 19 | <11 | |||
773093 | 773093 | 2020-04-23 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773094 | 773094 | 2020-04-23 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773095 | 773095 | 2020-04-23 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773096 | 773096 | 2020-04-23 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773097 | 773097 | 2020-04-23 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773098 | 773098 | 2020-04-23 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773099 | 773099 | 2020-04-23 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773100 | 773100 | 2020-04-23 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773101 | 773101 | 2020-04-23 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773102 | 773102 | 2020-04-23 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773103 | 773103 | 2020-04-23 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773104 | 773104 | 2020-04-23 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773105 | 773105 | 2020-04-23 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773106 | 773106 | 2020-04-23 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773107 | 773107 | 2020-04-23 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773108 | 773108 | 2020-04-23 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773109 | 773109 | 2020-04-23 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773110 | 773110 | 2020-04-23 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773111 | 773111 | 2020-04-23 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773112 | 773112 | 2020-04-23 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773113 | 773113 | 2020-04-23 | 40000069 | 040000069-valley-healthcare-center | VALLEY HEALTHCARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773114 | 773114 | 2020-04-23 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773115 | 773115 | 2020-04-23 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
773116 | 773116 | 2020-04-23 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 0 | 0 | 0 | 0 | 21 | ||||
773117 | 773117 | 2020-04-23 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
773118 | 773118 | 2020-04-23 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
773119 | 773119 | 2020-04-23 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
773120 | 773120 | 2020-04-23 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
773121 | 773121 | 2020-04-23 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
773122 | 773122 | 2020-04-23 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
773123 | 773123 | 2020-04-23 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 0 | 0 | 0 | 0 | 25 | ||||
773124 | 773124 | 2020-04-23 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 0 | 0 | 0 | 0 | 25 | ||||
773125 | 773125 | 2020-04-23 | 90000092 | 090000092-valley-convalescent-center | VALLEY CONVALESCENT CENTER | Imperial | 1 | 0 | 0 | 0 | 25 | <11 | |||
773126 | 773126 | 2020-04-23 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
773127 | 773127 | 2020-04-23 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
773128 | 773128 | 2020-04-23 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773129 | 773129 | 2020-04-23 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
773130 | 773130 | 2020-04-23 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773131 | 773131 | 2020-04-23 | 120000399 | 120000399-delano-regional-medical-center-d-p-snf | DELANO REGIONAL MEDICAL CENTER D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773132 | 773132 | 2020-04-23 | 120000375 | 120000375-golden-living-center-shafter | GOLDEN LIVING CENTER - SHAFTER | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
773133 | 773133 | 2020-04-23 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773134 | 773134 | 2020-04-23 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773135 | 773135 | 2020-04-23 | 120000695 | 120000695-kern-valley-healthcare-district-d-p-snf | KERN VALLEY HEALTHCARE DISTRICT D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773136 | 773136 | 2020-04-23 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
773137 | 773137 | 2020-04-23 | 120000365 | 120000365-parkview-julian-convalescent | PARKVIEW JULIAN CONVALESCENT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773138 | 773138 | 2020-04-23 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773139 | 773139 | 2020-04-23 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773140 | 773140 | 2020-04-23 | 120000322 | 120000322-san-joaquin-nursing-center | SAN JOAQUIN NURSING CENTER | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
773141 | 773141 | 2020-04-23 | 120000320 | 120000320-the-orchards-post-acute | THE ORCHARDS POST-ACUTE | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | ||
773142 | 773142 | 2020-04-23 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773143 | 773143 | 2020-04-23 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773144 | 773144 | 2020-04-23 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773145 | 773145 | 2020-04-23 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773146 | 773146 | 2020-04-23 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 0 | 0 | 0 | 0 | 29 | ||||
773147 | 773147 | 2020-04-23 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 0 | 0 | 0 | 0 | 31 | ||||
773148 | 773148 | 2020-04-23 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 0 | 0 | 0 | 0 | 31 | ||||
773149 | 773149 | 2020-04-23 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 0 | 0 | 0 | 0 | 31 | ||||
773150 | 773150 | 2020-04-23 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 0 | 0 | 0 | 0 | 33 | ||||
773151 | 773151 | 2020-04-23 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
773152 | 773152 | 2020-04-23 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
773153 | 773153 | 2020-04-23 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 0 | 0 | 0 | 0 | 35 | ||||
773154 | 773154 | 2020-04-23 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 12 | 13 | 0 | 1 | 37 | <11 | |||
773155 | 773155 | 2020-04-23 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 32 | 12 | 0 | 13 | 37 | ||||
773156 | 773156 | 2020-04-23 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
773157 | 773157 | 2020-04-23 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 12 | 18 | 0 | 1 | 37 | <11 | |||
773158 | 773158 | 2020-04-23 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 1 | 29 | 0 | 1 | 37 | <11 | <11 | ||
773159 | 773159 | 2020-04-23 | 970000003 | 970000003-alexandria-care-center | ALEXANDRIA CARE CENTER | Los Angeles | 1 | 12 | 0 | 1 | 37 | <11 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-skilled-nursing-facilities" ( [date] TEXT, [id] INTEGER, [slug] TEXT, [name] TEXT, [county] TEXT, [staff_confirmed_cases] INTEGER, [patients_confirmed_cases] INTEGER, [staff_deaths] INTEGER, [patients_deaths] INTEGER, [fips] INTEGER, [staff_confirmed_cases_note] TEXT, [patients_confirmed_cases_note] TEXT, [staff_deaths_note] TEXT, [patients_deaths_note] TEXT );