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-21 sorted by staff_confirmed_cases_note
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
775520 | 775520 | 2020-04-21 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
775521 | 775521 | 2020-04-21 | 140000049 | 140000049-vintage-estates-of-richmond | VINTAGE ESTATES OF RICHMOND | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
775522 | 775522 | 2020-04-21 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
775523 | 775523 | 2020-04-21 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
775524 | 775524 | 2020-04-21 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
775525 | 775525 | 2020-04-21 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
775526 | 775526 | 2020-04-21 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
775527 | 775527 | 2020-04-21 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
775528 | 775528 | 2020-04-21 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
775529 | 775529 | 2020-04-21 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
775530 | 775530 | 2020-04-21 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
775531 | 775531 | 2020-04-21 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
775532 | 775532 | 2020-04-21 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775533 | 775533 | 2020-04-21 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775534 | 775534 | 2020-04-21 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775535 | 775535 | 2020-04-21 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775536 | 775536 | 2020-04-21 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775537 | 775537 | 2020-04-21 | 40000043 | 040000043-dycora-transitional-health-community-care | DYCORA TRANSITIONAL HEALTH - COMMUNITY CARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775538 | 775538 | 2020-04-21 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775539 | 775539 | 2020-04-21 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775540 | 775540 | 2020-04-21 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 0 | 1 | 0 | 0 | 19 | <11 | |||
775541 | 775541 | 2020-04-21 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775542 | 775542 | 2020-04-21 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775543 | 775543 | 2020-04-21 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775544 | 775544 | 2020-04-21 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775545 | 775545 | 2020-04-21 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775546 | 775546 | 2020-04-21 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775547 | 775547 | 2020-04-21 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775548 | 775548 | 2020-04-21 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775549 | 775549 | 2020-04-21 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775550 | 775550 | 2020-04-21 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775551 | 775551 | 2020-04-21 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775552 | 775552 | 2020-04-21 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775553 | 775553 | 2020-04-21 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775554 | 775554 | 2020-04-21 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775555 | 775555 | 2020-04-21 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775556 | 775556 | 2020-04-21 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775557 | 775557 | 2020-04-21 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775558 | 775558 | 2020-04-21 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775559 | 775559 | 2020-04-21 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775560 | 775560 | 2020-04-21 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775561 | 775561 | 2020-04-21 | 40000069 | 040000069-valley-healthcare-center | VALLEY HEALTHCARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775562 | 775562 | 2020-04-21 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775563 | 775563 | 2020-04-21 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
775564 | 775564 | 2020-04-21 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 0 | 0 | 0 | 0 | 21 | ||||
775565 | 775565 | 2020-04-21 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
775566 | 775566 | 2020-04-21 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
775567 | 775567 | 2020-04-21 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
775568 | 775568 | 2020-04-21 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
775569 | 775569 | 2020-04-21 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
775570 | 775570 | 2020-04-21 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
775571 | 775571 | 2020-04-21 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 0 | 0 | 0 | 0 | 25 | ||||
775572 | 775572 | 2020-04-21 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 0 | 0 | 0 | 0 | 25 | ||||
775573 | 775573 | 2020-04-21 | 90000092 | 090000092-valley-convalescent-center | VALLEY CONVALESCENT CENTER | Imperial | 0 | 0 | 0 | 0 | 25 | ||||
775574 | 775574 | 2020-04-21 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
775575 | 775575 | 2020-04-21 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
775576 | 775576 | 2020-04-21 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775577 | 775577 | 2020-04-21 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775578 | 775578 | 2020-04-21 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775579 | 775579 | 2020-04-21 | 120000399 | 120000399-delano-regional-medical-center-d-p-snf | DELANO REGIONAL MEDICAL CENTER D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775581 | 775581 | 2020-04-21 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775582 | 775582 | 2020-04-21 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775583 | 775583 | 2020-04-21 | 120000695 | 120000695-kern-valley-healthcare-district-d-p-snf | KERN VALLEY HEALTHCARE DISTRICT D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775584 | 775584 | 2020-04-21 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775585 | 775585 | 2020-04-21 | 120000365 | 120000365-parkview-julian-convalescent | PARKVIEW JULIAN CONVALESCENT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775586 | 775586 | 2020-04-21 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775587 | 775587 | 2020-04-21 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775590 | 775590 | 2020-04-21 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775591 | 775591 | 2020-04-21 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775592 | 775592 | 2020-04-21 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775593 | 775593 | 2020-04-21 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775594 | 775594 | 2020-04-21 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 0 | 0 | 0 | 0 | 29 | ||||
775595 | 775595 | 2020-04-21 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 0 | 0 | 0 | 0 | 31 | ||||
775596 | 775596 | 2020-04-21 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 0 | 0 | 0 | 0 | 31 | ||||
775597 | 775597 | 2020-04-21 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 0 | 0 | 0 | 0 | 31 | ||||
775598 | 775598 | 2020-04-21 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 0 | 0 | 0 | 0 | 33 | ||||
775599 | 775599 | 2020-04-21 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
775600 | 775600 | 2020-04-21 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
775601 | 775601 | 2020-04-21 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 0 | 0 | 0 | 0 | 35 | ||||
775602 | 775602 | 2020-04-21 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775603 | 775603 | 2020-04-21 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 0 | 12 | 0 | 0 | 37 | ||||
775604 | 775604 | 2020-04-21 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775605 | 775605 | 2020-04-21 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 12 | 17 | 0 | 1 | 37 | <11 | |||
775610 | 775610 | 2020-04-21 | 920000001 | 920000001-all-saints-healthcare | ALL SAINTS HEALTHCARE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775611 | 775611 | 2020-04-21 | 970000123 | 970000123-angels-nursing-health-center | ANGELS NURSING HEALTH CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775613 | 775613 | 2020-04-21 | 970000091 | 970000091-ararat-convalescent-hospital | ARARAT CONVALESCENT HOSPITAL | Los Angeles | 15 | 1 | 0 | 1 | 37 | <11 | <11 | ||
775614 | 775614 | 2020-04-21 | 920000292 | 920000292-ararat-nursing-facility | ARARAT NURSING FACILITY | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775615 | 775615 | 2020-04-21 | 950000012 | 950000012-arbor-glen-care-center | ARBOR GLEN CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775616 | 775616 | 2020-04-21 | 950000045 | 950000045-arcadia-care-center | ARCADIA CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775617 | 775617 | 2020-04-21 | 940000093 | 940000093-artesia-christian-home-inc | ARTESIA CHRISTIAN HOME INC. | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775618 | 775618 | 2020-04-21 | 920000002 | 920000002-astoria-nursing-and-rehab-center | ASTORIA NURSING AND REHAB CENTER | Los Angeles | 0 | 1 | 0 | 0 | 37 | <11 | |||
775619 | 775619 | 2020-04-21 | 950000039 | 950000039-atherton-baptist-home-sam-b-west | ATHERTON BAPTIST HOME-SAM B. WEST | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775620 | 775620 | 2020-04-21 | 940000007 | 940000007-atlantic-memorial-healthcare-center | ATLANTIC MEMORIAL HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775622 | 775622 | 2020-04-21 | 940000051 | 940000051-avalon-villa-care-center | AVALON VILLA CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775625 | 775625 | 2020-04-21 | 940000097 | 940000097-beachside-post-acute | BEACHSIDE POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775630 | 775630 | 2020-04-21 | 940000011 | 940000011-bell-convalescent-hospital | BELL CONVALESCENT HOSPITAL | Los Angeles | 12 | 50 | 0 | 15 | 37 | ||||
775631 | 775631 | 2020-04-21 | 940000013 | 940000013-bellflower-post-acute | BELLFLOWER POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775632 | 775632 | 2020-04-21 | 910000014 | 910000014-berkley-east-convalescent-hospital | BERKLEY EAST CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775634 | 775634 | 2020-04-21 | 910000013 | 910000013-berkley-west-convalescent-hospital | BERKLEY WEST CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
775635 | 775635 | 2020-04-21 | 910000322 | 910000322-beverly-west-healthcare | BEVERLY WEST HEALTHCARE | Los Angeles | 0 | 0 | 0 | 0 | 37 |
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 );