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-09-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
139426 | 139426 | 2021-09-23 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139427 | 139427 | 2021-09-23 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139428 | 139428 | 2021-09-23 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139429 | 139429 | 2021-09-23 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
139431 | 139431 | 2021-09-23 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139435 | 139435 | 2021-09-23 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139458 | 139458 | 2021-09-23 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139467 | 139467 | 2021-09-23 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139480 | 139480 | 2021-09-23 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139481 | 139481 | 2021-09-23 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
139486 | 139486 | 2021-09-23 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
139540 | 139540 | 2021-09-23 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 21 | 0 | 0 | 0 | 13 | ||||
139544 | 139544 | 2021-09-23 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
139549 | 139549 | 2021-09-23 | 40000798 | 040000798-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP SNF | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
139581 | 139581 | 2021-09-23 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
139584 | 139584 | 2021-09-23 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
139593 | 139593 | 2021-09-23 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 36 | 0 | 0 | 0 | 29 | ||||
139601 | 139601 | 2021-09-23 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 13 | 0 | 0 | 0 | 29 | ||||
139625 | 139625 | 2021-09-23 | 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 | ||
139674 | 139674 | 2021-09-23 | 930000669 | 930000669-catalina-island-medical-center-d-p-snf | CATALINA ISLAND MEDICAL CENTER D/P SNF | Los Angeles | 13 | 0 | 0 | 0 | 37 | ||||
139729 | 139729 | 2021-09-23 | 930000865 | 930000865-encino-hospital-medical-center | ENCINO HOSPITAL MEDICAL CENTER | Los Angeles | 19 | 0 | 0 | 0 | 37 | ||||
139736 | 139736 | 2021-09-23 | 970000062 | 970000062-garden-crest-rehabilitation-center | GARDEN CREST REHABILITATION CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
139813 | 139813 | 2021-09-23 | 940000101 | 940000101-long-beach-post-acute | LONG BEACH POST ACUTE | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
139919 | 139919 | 2021-09-23 | 930001552 | 930001552-sherman-oaks-hospital | SHERMAN OAKS HOSPITAL | Los Angeles | 21 | 0 | 0 | 0 | 37 | ||||
139927 | 139927 | 2021-09-23 | 930000802 | 930000802-southern-california-hospital | SOUTHERN CALIFORNIA HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
139958 | 139958 | 2021-09-23 | 920000312 | 920000312-totally-kids-specialty-healthcare-sun-valley | TOTALLY KIDS SPECIALTY HEALTHCARE-SUN VALLEY | Los Angeles | 20 | 0 | 0 | 0 | 37 | ||||
140011 | 140011 | 2021-09-23 | 10001005 | 010001005-aldersly-skilled-nursing-facility | ALDERSLY SKILLED NURSING FACILITY | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
140025 | 140025 | 2021-09-23 | 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 | |||
140031 | 140031 | 2021-09-23 | 40000225 | 040000225-anberry-nursing-and-rehabilitation-center | ANBERRY NURSING AND REHABILITATION CENTER | Merced | 24 | 0 | 0 | 0 | 47 | ||||
140036 | 140036 | 2021-09-23 | 40000027 | 040000027-la-sierra-care-center | LA SIERRA CARE CENTER | Merced | 19 | 0 | 0 | 0 | 47 | ||||
140043 | 140043 | 2021-09-23 | 70000019 | 070000019-ave-maria-convalescent-hospital | AVE MARIA CONVALESCENT HOSPITAL | Monterey | 1 | 0 | 0 | 0 | 53 | <11 | |||
140046 | 140046 | 2021-09-23 | 70000034 | 070000034-carmel-valley-manor | CARMEL VALLEY MANOR | Monterey | 1 | 0 | 0 | 0 | 53 | <11 | |||
140051 | 140051 | 2021-09-23 | 70000066 | 070000066-katherine-healthcare | KATHERINE HEALTHCARE | Monterey | 1 | 0 | 0 | 0 | 53 | <11 | |||
140081 | 140081 | 2021-09-23 | 60001568 | 060001568-chapman-global-medical-center-d-p-snf | CHAPMAN GLOBAL MEDICAL CENTER D/P SNF | Orange | 16 | 0 | 0 | 0 | 59 | ||||
140095 | 140095 | 2021-09-23 | 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 | |||
140113 | 140113 | 2021-09-23 | 630019714 | 630019714-orchards-skilled-nursing | ORCHARDS SKILLED NURSING | Orange | 1 | 0 | 0 | 0 | 59 | <11 | |||
140140 | 140140 | 2021-09-23 | 60001201 | 060001201-west-anaheim-medical-center-d-p-snf | WEST ANAHEIM MEDICAL CENTER D/P SNF | Orange | 21 | 0 | 0 | 0 | 59 | ||||
140152 | 140152 | 2021-09-23 | 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 | |||
140198 | 140198 | 2021-09-23 | 630021719 | 630021719-temecula-healthcare-center | TEMECULA HEALTHCARE CENTER | Riverside | 1 | 0 | 0 | 0 | 65 | <11 | |||
140333 | 140333 | 2021-09-23 | 80000752 | 080000752-grossmont-gardens | GROSSMONT GARDENS | San Diego | 1 | 0 | 0 | 0 | 73 | <11 | |||
140337 | 140337 | 2021-09-23 | 90000064 | 090000064-hillcrest-manor-sanitarium | HILLCREST MANOR SANITARIUM | San Diego | 14 | 0 | 0 | 0 | 73 | ||||
140349 | 140349 | 2021-09-23 | 630016417 | 630016417-meadowbrook-village-christian-retirement-community | MEADOWBROOK VILLAGE CHRISTIAN RETIREMENT COMMUNITY | San Diego | 11 | 0 | 0 | 0 | 73 | ||||
140351 | 140351 | 2021-09-23 | 90000005 | 090000005-monte-vista-lodge | MONTE VISTA LODGE | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
140370 | 140370 | 2021-09-23 | 80000835 | 080000835-the-dorothy-and-joseph-goldberg-healthcare-center | THE DOROTHY AND JOSEPH GOLDBERG HEALTHCARE CENTER | San Diego | 18 | 0 | 0 | 0 | 73 | ||||
140387 | 140387 | 2021-09-23 | 80000100 | 080000100-white-sands-of-la-jolla | WHITE SANDS OF LA JOLLA | San Diego | 1 | 0 | 0 | 0 | 73 | <11 | |||
140392 | 140392 | 2021-09-23 | 220000056 | 220000056-hayes-convalescent-hospital | HAYES CONVALESCENT HOSPITAL | San Francisco | 1 | 0 | 0 | 0 | 75 | <11 | |||
140456 | 140456 | 2021-09-23 | 220000085 | 220000085-the-sequoias | THE SEQUOIAS | San Mateo | 1 | 0 | 0 | 0 | 81 | <11 | |||
140458 | 140458 | 2021-09-23 | 50000064 | 050000064-atterdag-care-center | ATTERDAG CARE CENTER | Santa Barbara | 16 | 0 | 0 | 0 | 83 | ||||
140518 | 140518 | 2021-09-23 | 220001058 | 220001058-villa-siena | VILLA SIENA | Santa Clara | 11 | 0 | 0 | 0 | 85 | ||||
140541 | 140541 | 2021-09-23 | 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 | |||
140544 | 140544 | 2021-09-23 | 110000077 | 110000077-greenfield-care-center-of-fairfield | GREENFIELD CARE CENTER OF FAIRFIELD | Solano | 1 | 0 | 0 | 0 | 95 | <11 | |||
140549 | 140549 | 2021-09-23 | 110000074 | 110000074-springs-road-healthcare | SPRINGS ROAD HEALTHCARE | Solano | 1 | 0 | 0 | 0 | 95 | <11 | |||
140558 | 140558 | 2021-09-23 | 110000702 | 110000702-healdsburg-district-hospital-d-p-snf | HEALDSBURG DISTRICT HOSPITAL D/P SNF | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
140567 | 140567 | 2021-09-23 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
139425 | 139425 | 2021-09-23 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
139432 | 139432 | 2021-09-23 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 14 | 1 | 0 | 1 | 1 | <11 | <11 | ||
139434 | 139434 | 2021-09-23 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
139436 | 139436 | 2021-09-23 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
139439 | 139439 | 2021-09-23 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
139443 | 139443 | 2021-09-23 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 20 | 1 | <11 | <11 | ||
139454 | 139454 | 2021-09-23 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 11 | 1 | 0 | 0 | 1 | <11 | |||
139456 | 139456 | 2021-09-23 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
139457 | 139457 | 2021-09-23 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 19 | 1 | 0 | 0 | 1 | <11 | |||
139460 | 139460 | 2021-09-23 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 20 | 1 | 0 | 1 | 1 | <11 | <11 | ||
139461 | 139461 | 2021-09-23 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
139469 | 139469 | 2021-09-23 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
139478 | 139478 | 2021-09-23 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
139490 | 139490 | 2021-09-23 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
139498 | 139498 | 2021-09-23 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 29 | 1 | 0 | 1 | 7 | <11 | <11 | ||
139499 | 139499 | 2021-09-23 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 19 | 1 | 0 | 0 | 7 | <11 | |||
139511 | 139511 | 2021-09-23 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 21 | 1 | 0 | 0 | 13 | <11 | |||
139515 | 139515 | 2021-09-23 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 11 | 1 | 0 | 0 | 13 | <11 | |||
139521 | 139521 | 2021-09-23 | 140000106 | 140000106-martinez-convalescent-hospital | MARTINEZ CONVALESCENT HOSPITAL | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
139524 | 139524 | 2021-09-23 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
139527 | 139527 | 2021-09-23 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
139530 | 139530 | 2021-09-23 | 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 |
139531 | 139531 | 2021-09-23 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
139532 | 139532 | 2021-09-23 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
139533 | 139533 | 2021-09-23 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 23 | 1 | 0 | 0 | 13 | <11 | |||
139535 | 139535 | 2021-09-23 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 17 | 1 | 0 | 0 | 13 | <11 | |||
139541 | 139541 | 2021-09-23 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 40 | 1 | 0 | 0 | 15 | <11 | |||
139542 | 139542 | 2021-09-23 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 27 | 1 | 0 | 0 | 17 | <11 | |||
139550 | 139550 | 2021-09-23 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
139571 | 139571 | 2021-09-23 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 89 | 1 | 0 | 0 | 19 | <11 | |||
139576 | 139576 | 2021-09-23 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 21 | 1 | 0 | 0 | 19 | <11 | |||
139578 | 139578 | 2021-09-23 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 64 | 1 | 0 | 0 | 19 | <11 | |||
139582 | 139582 | 2021-09-23 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 0 | 1 | 23 | <11 | <11 | <11 | |
139585 | 139585 | 2021-09-23 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 1 | 1 | 23 | <11 | <11 | <11 | <11 |
139586 | 139586 | 2021-09-23 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 0 | 0 | 23 | <11 | <11 | ||
139592 | 139592 | 2021-09-23 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 13 | 1 | 0 | 0 | 29 | <11 | |||
139626 | 139626 | 2021-09-23 | 920000001 | 920000001-all-saints-healthcare | ALL SAINTS HEALTHCARE | Los Angeles | 45 | 1 | 0 | 0 | 37 | <11 | |||
139630 | 139630 | 2021-09-23 | 970000091 | 970000091-ararat-convalescent-hospital | ARARAT CONVALESCENT HOSPITAL | Los Angeles | 25 | 1 | 0 | 1 | 37 | <11 | <11 | ||
139634 | 139634 | 2021-09-23 | 940000093 | 940000093-artesia-christian-home-inc | ARTESIA CHRISTIAN HOME INC. | Los Angeles | 22 | 1 | 0 | 1 | 37 | <11 | <11 | ||
139652 | 139652 | 2021-09-23 | 910000013 | 910000013-berkley-west-healthcare-center | BERKLEY WEST HEALTHCARE CENTER | Los Angeles | 18 | 1 | 0 | 1 | 37 | <11 | <11 | ||
139655 | 139655 | 2021-09-23 | 910000073 | 910000073-brentwood-health-care-center | BRENTWOOD HEALTH CARE CENTER | Los Angeles | 22 | 1 | 0 | 0 | 37 | <11 | |||
139684 | 139684 | 2021-09-23 | 950000053 | 950000053-claremont-manor-care-center | CLAREMONT MANOR CARE CENTER | Los Angeles | 20 | 1 | 0 | 1 | 37 | <11 | <11 | ||
139720 | 139720 | 2021-09-23 | 930000685 | 930000685-east-los-angeles-doctors-hospital-d-p-snf | EAST LOS ANGELES DOCTORS HOSPITAL D/P SNF | Los Angeles | 24 | 1 | 0 | 0 | 37 | <11 | |||
139722 | 139722 | 2021-09-23 | 940000043 | 940000043-edgewater-skilled-nursing-center | EDGEWATER SKILLED NURSING CENTER | Los Angeles | 26 | 1 | 0 | 0 | 37 | <11 | |||
139724 | 139724 | 2021-09-23 | 960001457 | 960001457-el-encanto-healthcare-and-habilitation-center | EL ENCANTO HEALTHCARE AND HABILITATION CENTER | Los Angeles | 22 | 1 | 0 | 1 | 37 | <11 | <11 | ||
139727 | 139727 | 2021-09-23 | 950000236 | 950000236-emanate-health-hospice | EMANATE HEALTH HOSPICE | Los Angeles | 14 | 1 | 0 | 0 | 37 | <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 );