la_times_cdph_skilled_nursing_facilities
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_skilled_nursing_facilities
1,223 rows where "date" is on date 2021-01-18 sorted by patients_confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
442732 | 442732 | 2021-01-18 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442733 | 442733 | 2021-01-18 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442734 | 442734 | 2021-01-18 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442735 | 442735 | 2021-01-18 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442737 | 442737 | 2021-01-18 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442741 | 442741 | 2021-01-18 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442763 | 442763 | 2021-01-18 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 14 | 0 | 0 | 0 | 1 | ||||
442764 | 442764 | 2021-01-18 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442773 | 442773 | 2021-01-18 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442775 | 442775 | 2021-01-18 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442786 | 442786 | 2021-01-18 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442787 | 442787 | 2021-01-18 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
442792 | 442792 | 2021-01-18 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
442821 | 442821 | 2021-01-18 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
442837 | 442837 | 2021-01-18 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 1 | 0 | 0 | 1 | 13 | <11 | <11 | ||
442838 | 442838 | 2021-01-18 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
442846 | 442846 | 2021-01-18 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 16 | 0 | 0 | 0 | 13 | ||||
442850 | 442850 | 2021-01-18 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
442887 | 442887 | 2021-01-18 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
442888 | 442888 | 2021-01-18 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
442890 | 442890 | 2021-01-18 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
442892 | 442892 | 2021-01-18 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
442899 | 442899 | 2021-01-18 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 25 | 0 | 0 | 0 | 29 | ||||
442907 | 442907 | 2021-01-18 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
442931 | 442931 | 2021-01-18 | 930000793 | 930000793-alhambra-hospital-medical-center-d-p-snf | ALHAMBRA HOSPITAL MEDICAL CENTER D/P SNF | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
442980 | 442980 | 2021-01-18 | 930000669 | 930000669-catalina-island-medical-center-d-p-snf | CATALINA ISLAND MEDICAL CENTER D/P SNF | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
443028 | 443028 | 2021-01-18 | 940000043 | 940000043-edgewater-skilled-nursing-center | EDGEWATER SKILLED NURSING CENTER | Los Angeles | 24 | 0 | 0 | 0 | 37 | ||||
443035 | 443035 | 2021-01-18 | 930000865 | 930000865-encino-hospital-medical-center | ENCINO HOSPITAL MEDICAL CENTER | Los Angeles | 15 | 0 | 0 | 0 | 37 | ||||
443042 | 443042 | 2021-01-18 | 970000062 | 970000062-garden-crest-rehabilitation-center | GARDEN CREST REHABILITATION CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
443119 | 443119 | 2021-01-18 | 940000101 | 940000101-long-beach-post-acute | LONG BEACH POST ACUTE | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
443225 | 443225 | 2021-01-18 | 930001552 | 930001552-sherman-oaks-hospital | SHERMAN OAKS HOSPITAL | Los Angeles | 20 | 0 | 0 | 0 | 37 | ||||
443233 | 443233 | 2021-01-18 | 930000802 | 930000802-southern-california-hospital | SOUTHERN CALIFORNIA HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
443264 | 443264 | 2021-01-18 | 920000312 | 920000312-totally-kids-specialty-healthcare-sun-valley | TOTALLY KIDS SPECIALTY HEALTHCARE-SUN VALLEY | Los Angeles | 18 | 0 | 0 | 0 | 37 | ||||
443288 | 443288 | 2021-01-18 | 930001561 | 930001561-west-covina-medical-center-d-p-snf | WEST COVINA MEDICAL CENTER D/P SNF | Los Angeles | 33 | 0 | 0 | 0 | 37 | ||||
443317 | 443317 | 2021-01-18 | 10001005 | 010001005-aldersly-skilled-nursing-facility | ALDERSLY SKILLED NURSING FACILITY | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
443328 | 443328 | 2021-01-18 | 10001007 | 010001007-the-redwoods-a-community-of-seniors | THE REDWOODS, A COMMUNITY OF SENIORS | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
443331 | 443331 | 2021-01-18 | 40000345 | 040000345-john-c-fremont-healthcare-district-d-p-snf | JOHN C. FREMONT HEALTHCARE DISTRICT D/P SNF | Mariposa | 1 | 0 | 0 | 0 | 43 | <11 | |||
443337 | 443337 | 2021-01-18 | 40000225 | 040000225-anberry-nursing-and-rehabilitation-center | ANBERRY NURSING AND REHABILITATION CENTER | Merced | 19 | 0 | 0 | 0 | 47 | ||||
443342 | 443342 | 2021-01-18 | 40000027 | 040000027-la-sierra-care-center | LA SIERRA CARE CENTER | Merced | 15 | 0 | 0 | 0 | 47 | ||||
443349 | 443349 | 2021-01-18 | 70000019 | 070000019-ave-maria-convalescent-hospital | AVE MARIA CONVALESCENT HOSPITAL | Monterey | 1 | 0 | 0 | 0 | 53 | <11 | |||
443352 | 443352 | 2021-01-18 | 70000034 | 070000034-carmel-valley-manor | CARMEL VALLEY MANOR | Monterey | 1 | 0 | 0 | 0 | 53 | <11 | |||
443355 | 443355 | 2021-01-18 | 630012059 | 630012059-forest-hill-manor-health-center | FOREST HILL MANOR HEALTH CENTER | Monterey | 0 | 0 | 0 | 0 | 53 | ||||
443357 | 443357 | 2021-01-18 | 70000066 | 070000066-katherine-healthcare | KATHERINE HEALTHCARE | Monterey | 1 | 0 | 0 | 0 | 53 | <11 | |||
443368 | 443368 | 2021-01-18 | 110000053 | 110000053-piner-s-nursing-home | PINER'S NURSING HOME | Napa | 1 | 0 | 0 | 0 | 55 | <11 | |||
443387 | 443387 | 2021-01-18 | 60001568 | 060001568-chapman-global-medical-center-d-p-snf | CHAPMAN GLOBAL MEDICAL CENTER D/P SNF | Orange | 15 | 0 | 0 | 0 | 59 | ||||
443401 | 443401 | 2021-01-18 | 60001698 | 060001698-healthbridge-children-s-hospital-orange-d-p-snf | HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE D/P SNF | Orange | 1 | 0 | 0 | 0 | 59 | <11 | |||
443412 | 443412 | 2021-01-18 | 60001680 | 060001680-mission-capistrano-healthcare-center | MISSION CAPISTRANO HEALTHCARE CENTER | Orange | 1 | 0 | 0 | 0 | 59 | <11 | |||
443446 | 443446 | 2021-01-18 | 60001201 | 060001201-west-anaheim-medical-center-d-p-snf | WEST ANAHEIM MEDICAL CENTER D/P SNF | Orange | 20 | 0 | 0 | 0 | 59 | ||||
443458 | 443458 | 2021-01-18 | 230000392 | 230000392-eastern-plumas-hospital-portola-campus-d-p-snf | EASTERN PLUMAS HOSPITAL-PORTOLA CAMPUS D/P SNF | Plumas | 1 | 0 | 0 | 0 | 63 | <11 | |||
443487 | 443487 | 2021-01-18 | 250000148 | 250000148-miravilla-care-center | MIRAVILLA CARE CENTER | Riverside | 1 | 0 | 0 | 0 | 65 | <11 | |||
443488 | 443488 | 2021-01-18 | 250000270 | 250000270-mission-care-center | MISSION CARE CENTER | Riverside | 22 | 0 | 0 | 0 | 65 | ||||
443592 | 443592 | 2021-01-18 | 240001393 | 240001393-redlands-community-hospital-d-p-snf | REDLANDS COMMUNITY HOSPITAL D/P SNF | San Bernardino | 11 | 0 | 0 | 0 | 71 | ||||
443622 | 443622 | 2021-01-18 | 80000073 | 080000073-carlsbad-by-the-sea | CARLSBAD BY THE SEA | San Diego | 1 | 0 | 0 | 0 | 73 | <11 | |||
443639 | 443639 | 2021-01-18 | 80000752 | 080000752-grossmont-gardens | GROSSMONT GARDENS | San Diego | 1 | 0 | 0 | 0 | 73 | <11 | |||
443643 | 443643 | 2021-01-18 | 90000064 | 090000064-hillcrest-manor-sanitarium | HILLCREST MANOR SANITARIUM | San Diego | 14 | 0 | 0 | 0 | 73 | ||||
443655 | 443655 | 2021-01-18 | 630016417 | 630016417-meadowbrook-village-christian-retirement-community | MEADOWBROOK VILLAGE CHRISTIAN RETIREMENT COMMUNITY | San Diego | 1 | 0 | 0 | 0 | 73 | <11 | |||
443657 | 443657 | 2021-01-18 | 90000005 | 090000005-monte-vista-lodge | MONTE VISTA LODGE | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
443676 | 443676 | 2021-01-18 | 80000835 | 080000835-the-dorothy-and-joseph-goldberg-healthcare-center | THE DOROTHY AND JOSEPH GOLDBERG HEALTHCARE CENTER | San Diego | 17 | 0 | 0 | 0 | 73 | ||||
443693 | 443693 | 2021-01-18 | 80000100 | 080000100-white-sands-of-la-jolla | WHITE SANDS OF LA JOLLA | San Diego | 1 | 0 | 0 | 0 | 73 | <11 | |||
443698 | 443698 | 2021-01-18 | 220000056 | 220000056-hayes-convalescent-hospital | HAYES CONVALESCENT HOSPITAL | San Francisco | 1 | 0 | 0 | 0 | 75 | <11 | |||
443759 | 443759 | 2021-01-18 | 220000218 | 220000218-san-mateo-medical-center-d-p-snf | SAN MATEO MEDICAL CENTER D/P SNF | San Mateo | 1 | 0 | 0 | 0 | 81 | <11 | |||
443762 | 443762 | 2021-01-18 | 220000085 | 220000085-the-sequoias | THE SEQUOIAS | San Mateo | 1 | 0 | 0 | 0 | 81 | <11 | |||
443764 | 443764 | 2021-01-18 | 50000064 | 050000064-atterdag-care-center | ATTERDAG CARE CENTER | Santa Barbara | 1 | 0 | 0 | 0 | 83 | <11 | |||
443824 | 443824 | 2021-01-18 | 220001058 | 220001058-villa-siena | VILLA SIENA | Santa Clara | 1 | 0 | 0 | 0 | 85 | <11 | |||
443845 | 443845 | 2021-01-18 | 230000504 | 230000504-vibra-hospital-of-northern-california-d-p-snf | VIBRA HOSPITAL OF NORTHERN CALIFORNIA D/P SNF | Shasta | 32 | 0 | 0 | 1 | 89 | <11 | |||
443847 | 443847 | 2021-01-18 | 230000330 | 230000330-eastern-plumas-hospital-loyalton-campus-d-p-snf | EASTERN PLUMAS HOSPITAL - LOYALTON CAMPUS D/P SNF | Sierra | 1 | 0 | 0 | 0 | 91 | <11 | |||
443850 | 443850 | 2021-01-18 | 110000077 | 110000077-greenfield-care-center-of-fairfield | GREENFIELD CARE CENTER OF FAIRFIELD | Solano | 1 | 0 | 0 | 0 | 95 | <11 | |||
443855 | 443855 | 2021-01-18 | 110000074 | 110000074-springs-road-healthcare | SPRINGS ROAD HEALTHCARE | Solano | 1 | 0 | 0 | 0 | 95 | <11 | |||
443856 | 443856 | 2021-01-18 | 110000467 | 110000467-vacaville-convalescent-and-rehabilitation-center | VACAVILLE CONVALESCENT AND REHABILITATION CENTER | Solano | 14 | 0 | 0 | 0 | 95 | ||||
443864 | 443864 | 2021-01-18 | 110000702 | 110000702-healdsburg-district-hospital-d-p-snf | HEALDSBURG DISTRICT HOSPITAL D/P SNF | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
443873 | 443873 | 2021-01-18 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
443901 | 443901 | 2021-01-18 | 230000027 | 230000027-brentwood-post-acute | BRENTWOOD POST ACUTE | Tehama | 1 | 0 | 0 | 0 | 103 | <11 | |||
443918 | 443918 | 2021-01-18 | 120001466 | 120001466-sierra-view-medical-center | SIERRA VIEW MEDICAL CENTER | Tulare | 1 | 0 | 0 | 1 | 107 | <11 | <11 | ||
442729 | 442729 | 2021-01-18 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442731 | 442731 | 2021-01-18 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442738 | 442738 | 2021-01-18 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
442740 | 442740 | 2021-01-18 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442742 | 442742 | 2021-01-18 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442745 | 442745 | 2021-01-18 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442749 | 442749 | 2021-01-18 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 12 | 1 | <11 | <11 | ||
442760 | 442760 | 2021-01-18 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442762 | 442762 | 2021-01-18 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
442765 | 442765 | 2021-01-18 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442766 | 442766 | 2021-01-18 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 17 | 1 | 0 | 1 | 1 | <11 | <11 | ||
442767 | 442767 | 2021-01-18 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442777 | 442777 | 2021-01-18 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
442784 | 442784 | 2021-01-18 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442796 | 442796 | 2021-01-18 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
442804 | 442804 | 2021-01-18 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 24 | 1 | 0 | 1 | 7 | <11 | <11 | ||
442805 | 442805 | 2021-01-18 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 11 | 1 | 0 | 0 | 7 | <11 | |||
442817 | 442817 | 2021-01-18 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 16 | 1 | 0 | 0 | 13 | <11 | |||
442827 | 442827 | 2021-01-18 | 140000106 | 140000106-martinez-convalescent-hospital | MARTINEZ CONVALESCENT HOSPITAL | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
442830 | 442830 | 2021-01-18 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
442831 | 442831 | 2021-01-18 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
442833 | 442833 | 2021-01-18 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
442836 | 442836 | 2021-01-18 | 140000885 | 140000885-san-ramon-regional-medical-center-d-p-snf | SAN RAMON REGIONAL MEDICAL CENTER D/P SNF | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
442839 | 442839 | 2021-01-18 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 19 | 1 | 0 | 0 | 13 | <11 | |||
442841 | 442841 | 2021-01-18 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 14 | 1 | 0 | 0 | 13 | <11 | |||
442847 | 442847 | 2021-01-18 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 15 | 1 | 0 | 0 | 15 | <11 | |||
442848 | 442848 | 2021-01-18 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 16 | 1 | 0 | 0 | 17 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_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 );