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
776,631 rows sorted by patients_deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1052 | 1052 | 2022-01-15 | 70000031 | 070000031-camden-postacute-care-inc | CAMDEN POSTACUTE CARE, INC. | Santa Clara | 56 | 50 | 0 | 0 | 85 | ||||
1055 | 1055 | 2022-01-15 | 220001002 | 220001002-channing-house | CHANNING HOUSE | Santa Clara | 15 | 1 | 0 | 0 | 85 | <11 | |||
1056 | 1056 | 2022-01-15 | 70001089 | 070001089-children-s-healthcare-organization-of-northern-california-pediatric-hospi | CHILDREN'S HEALTHCARE ORGANIZATION OF NORTHERN CALIFORNIA - PEDIATRIC HOSPI | Santa Clara | 33 | 1 | 0 | 0 | 85 | <11 | |||
1057 | 1057 | 2022-01-15 | 220001048 | 220001048-children-s-healthcare-organization-of-northern-california-saratoga-pediat | CHILDREN'S HEALTHCARE ORGANIZATION OF NORTHERN CALIFORNIA - SARATOGA PEDIAT | Santa Clara | 29 | 1 | 0 | 0 | 85 | <11 | |||
1060 | 1060 | 2022-01-15 | 70000085 | 070000085-dycora-transitional-health-san-jose | DYCORA TRANSITIONAL HEALTH - SAN JOSE | Santa Clara | 30 | 47 | 0 | 0 | 85 | ||||
1061 | 1061 | 2022-01-15 | 70000050 | 070000050-empress-care-center-llc | EMPRESS CARE CENTER, LLC | Santa Clara | 12 | 1 | 0 | 0 | 85 | <11 | |||
1064 | 1064 | 2022-01-15 | 70000046 | 070000046-greenhills-manor | GREENHILLS MANOR | Santa Clara | 15 | 1 | 0 | 0 | 85 | <11 | |||
1071 | 1071 | 2022-01-15 | 220001076 | 220001076-manorcare-health-services-sunnyvale | MANORCARE HEALTH SERVICES (SUNNYVALE) | Santa Clara | 15 | 1 | 0 | 0 | 85 | <11 | |||
1076 | 1076 | 2022-01-15 | 70000868 | 070000868-o-connor-hospital-dp-snf | O'CONNOR HOSPITAL DP/SNF | Santa Clara | 13 | 1 | 0 | 0 | 85 | <11 | |||
1079 | 1079 | 2022-01-15 | 70000082 | 070000082-plum-tree-care-center | PLUM TREE CARE CENTER | Santa Clara | 28 | 52 | 0 | 0 | 85 | ||||
1085 | 1085 | 2022-01-15 | 70000026 | 070000026-stonebrook-health-and-rehabilitation | STONEBROOK HEALTH AND REHABILITATION | Santa Clara | 30 | 43 | 0 | 0 | 85 | ||||
1090 | 1090 | 2022-01-15 | 220001032 | 220001032-the-terraces-at-los-altos-health-facility | THE TERRACES AT LOS ALTOS HEALTH FACILITY | Santa Clara | 13 | 1 | 0 | 0 | 85 | <11 | |||
1096 | 1096 | 2022-01-15 | 220001058 | 220001058-villa-siena | VILLA SIENA | Santa Clara | 13 | 0 | 0 | 0 | 85 | ||||
1120 | 1120 | 2022-01-15 | 230000043 | 230000043-shasta-view-estates | SHASTA VIEW ESTATES | Siskiyou | 25 | 1 | 1 | 0 | 93 | <11 | <11 | ||
1127 | 1127 | 2022-01-15 | 110000074 | 110000074-springs-road-healthcare | SPRINGS ROAD HEALTHCARE | Solano | 13 | 0 | 0 | 0 | 95 | ||||
1130 | 1130 | 2022-01-15 | 10000026 | 010000026-apple-valley-post-acute-rehab | APPLE VALLEY POST-ACUTE REHAB | Sonoma | 38 | 15 | 0 | 0 | 97 | ||||
1131 | 1131 | 2022-01-15 | 10001140 | 010001140-arbol-residences-of-santa-rosa | ARBOL RESIDENCES OF SANTA ROSA | Sonoma | 15 | 1 | 0 | 0 | 97 | <11 | |||
1136 | 1136 | 2022-01-15 | 110000702 | 110000702-healdsburg-district-hospital-d-p-snf | HEALDSBURG DISTRICT HOSPITAL D/P SNF | Sonoma | 12 | 0 | 0 | 0 | 97 | ||||
1145 | 1145 | 2022-01-15 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 12 | 0 | 0 | 0 | 97 | ||||
1147 | 1147 | 2022-01-15 | 110000233 | 110000233-valley-of-the-moon-post-acute | VALLEY OF THE MOON POST ACUTE | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
1162 | 1162 | 2022-01-15 | 30000016 | 030000016-north-starr-postacute-care | NORTH STARR POSTACUTE CARE | Stanislaus | 87 | 70 | 0 | 0 | 99 | ||||
1179 | 1179 | 2022-01-15 | 120001451 | 120001451-kaweah-health-medical-center-d-p-snf | KAWEAH HEALTH MEDICAL CENTER D/P SNF | Tulare | 54 | 1 | 0 | 0 | 107 | <11 | |||
1180 | 1180 | 2022-01-15 | 120001449 | 120001449-kaweah-health-skilled-nursing-center | KAWEAH HEALTH SKILLED NURSING CENTER | Tulare | 55 | 21 | 1 | 0 | 107 | <11 | |||
1195 | 1195 | 2022-01-15 | 630014616 | 630014616-adventist-health-sonora-d-p-snf-unit-7 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 7) | Tuolumne | 11 | 1 | 0 | 0 | 109 | <11 | |||
1197 | 1197 | 2022-01-15 | 50001383 | 050001383-alta-camarillo-healthcare-center | ALTA CAMARILLO HEALTHCARE CENTER | Ventura | 28 | 1 | 0 | 0 | 111 | <11 | |||
1200 | 1200 | 2022-01-15 | 50000050 | 050000050-glenwood-care-center | GLENWOOD CARE CENTER | Ventura | 52 | 49 | 0 | 0 | 111 | ||||
1204 | 1204 | 2022-01-15 | 630011658 | 630011658-oakview-skilled-nursing | OAKVIEW SKILLED NURSING | Ventura | 69 | 1 | 0 | 0 | 111 | <11 | |||
1206 | 1206 | 2022-01-15 | 50000141 | 050000141-ojai-valley-community-skilled-nursing-facility | OJAI VALLEY COMMUNITY SKILLED NURSING FACILITY | Ventura | 18 | 1 | 0 | 0 | 111 | <11 | |||
1211 | 1211 | 2022-01-15 | 50000248 | 050000248-st-johns-pleasant-valley-hospital-d-p-snf | ST JOHNS PLEASANT VALLEY HOSPITAL D/P SNF | Ventura | 78 | 1 | 0 | 0 | 111 | <11 | |||
1221 | 1221 | 2022-01-15 | 100001676 | 100001676-university-retirement-community-at-davis | UNIVERSITY RETIREMENT COMMUNITY AT DAVIS | Yolo | 18 | 1 | 0 | 0 | 113 | <11 | |||
1224 | 1224 | 2022-01-14 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 45 | 38 | 0 | 0 | 1 | ||||
1226 | 1226 | 2022-01-14 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1227 | 1227 | 2022-01-14 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
1228 | 1228 | 2022-01-14 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1229 | 1229 | 2022-01-14 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1230 | 1230 | 2022-01-14 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1232 | 1232 | 2022-01-14 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1236 | 1236 | 2022-01-14 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
1237 | 1237 | 2022-01-14 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1240 | 1240 | 2022-01-14 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 14 | 1 | 0 | 0 | 1 | <11 | |||
1243 | 1243 | 2022-01-14 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 32 | 25 | 0 | 0 | 1 | ||||
1255 | 1255 | 2022-01-14 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
1257 | 1257 | 2022-01-14 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
1259 | 1259 | 2022-01-14 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1260 | 1260 | 2022-01-14 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 1 | 14 | 0 | 0 | 1 | <11 | |||
1262 | 1262 | 2022-01-14 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
1263 | 1263 | 2022-01-14 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 43 | 52 | 0 | 0 | 1 | ||||
1268 | 1268 | 2022-01-14 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
1270 | 1270 | 2022-01-14 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
1279 | 1279 | 2022-01-14 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1281 | 1281 | 2022-01-14 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 14 | 0 | 0 | 0 | 1 | ||||
1282 | 1282 | 2022-01-14 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1287 | 1287 | 2022-01-14 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
1291 | 1291 | 2022-01-14 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1312 | 1312 | 2022-01-14 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 34 | 1 | 0 | 0 | 13 | <11 | |||
1316 | 1316 | 2022-01-14 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 11 | 1 | 0 | 0 | 13 | <11 | |||
1317 | 1317 | 2022-01-14 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 18 | 30 | 0 | 0 | 13 | ||||
1323 | 1323 | 2022-01-14 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 20 | 40 | 0 | 0 | 13 | ||||
1326 | 1326 | 2022-01-14 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 19 | 21 | 0 | 0 | 13 | ||||
1328 | 1328 | 2022-01-14 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
1334 | 1334 | 2022-01-14 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 36 | 1 | 0 | 0 | 13 | <11 | |||
1336 | 1336 | 2022-01-14 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 36 | 1 | 0 | 0 | 13 | <11 | |||
1342 | 1342 | 2022-01-14 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 40 | 1 | 0 | 0 | 15 | <11 | |||
1343 | 1343 | 2022-01-14 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 34 | 1 | 0 | 0 | 17 | <11 | |||
1345 | 1345 | 2022-01-14 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
1350 | 1350 | 2022-01-14 | 40000798 | 040000798-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP SNF | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
1372 | 1372 | 2022-01-14 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 107 | 1 | 0 | 0 | 19 | <11 | |||
1377 | 1377 | 2022-01-14 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 38 | 1 | 0 | 0 | 19 | <11 | |||
1379 | 1379 | 2022-01-14 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 88 | 12 | 0 | 0 | 19 | ||||
1382 | 1382 | 2022-01-14 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 1 | 0 | 0 | 23 | <11 | |||
1385 | 1385 | 2022-01-14 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
1387 | 1387 | 2022-01-14 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 19 | 1 | 0 | 0 | 23 | <11 | |||
1390 | 1390 | 2022-01-14 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 39 | 27 | 0 | 0 | 25 | ||||
1393 | 1393 | 2022-01-14 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 27 | 1 | 0 | 0 | 29 | <11 | |||
1394 | 1394 | 2022-01-14 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 46 | 0 | 0 | 0 | 29 | ||||
1396 | 1396 | 2022-01-14 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 73 | 31 | 0 | 0 | 29 | ||||
1402 | 1402 | 2022-01-14 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 13 | 0 | 0 | 0 | 29 | ||||
1414 | 1414 | 2022-01-14 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 53 | 30 | 0 | 0 | 31 | ||||
1425 | 1425 | 2022-01-14 | 950000101 | 950000101-alhambra-healthcare-wellness-centre-lp | ALHAMBRA HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
1426 | 1426 | 2022-01-14 | 930000793 | 930000793-alhambra-hospital-medical-center-d-p-snf | ALHAMBRA HOSPITAL MEDICAL CENTER D/P SNF | Los Angeles | 11 | 1 | 1 | 0 | 37 | <11 | <11 | ||
1427 | 1427 | 2022-01-14 | 920000001 | 920000001-all-saints-healthcare | ALL SAINTS HEALTHCARE | Los Angeles | 70 | 1 | 0 | 0 | 37 | <11 | |||
1451 | 1451 | 2022-01-14 | 910000014 | 910000014-berkley-east-healthcare-center | BERKLEY EAST HEALTHCARE CENTER | Los Angeles | 98 | 20 | 0 | 0 | 37 | ||||
1456 | 1456 | 2022-01-14 | 910000073 | 910000073-brentwood-health-care-center | BRENTWOOD HEALTH CARE CENTER | Los Angeles | 29 | 1 | 0 | 0 | 37 | <11 | |||
1475 | 1475 | 2022-01-14 | 930000669 | 930000669-catalina-island-medical-center-d-p-snf | CATALINA ISLAND MEDICAL CENTER D/P SNF | Los Angeles | 14 | 0 | 0 | 0 | 37 | ||||
1506 | 1506 | 2022-01-14 | 910000316 | 910000316-country-villa-terrace-nursing-center | COUNTRY VILLA TERRACE NURSING CENTER | Los Angeles | 52 | 33 | 1 | 0 | 37 | <11 | |||
1521 | 1521 | 2022-01-14 | 930000685 | 930000685-east-los-angeles-doctors-hospital-d-p-snf | EAST LOS ANGELES DOCTORS HOSPITAL D/P SNF | Los Angeles | 32 | 1 | 0 | 0 | 37 | <11 | |||
1523 | 1523 | 2022-01-14 | 940000043 | 940000043-edgewater-skilled-nursing-center | EDGEWATER SKILLED NURSING CENTER | Los Angeles | 46 | 17 | 0 | 0 | 37 | ||||
1530 | 1530 | 2022-01-14 | 930000865 | 930000865-encino-hospital-medical-center | ENCINO HOSPITAL MEDICAL CENTER | Los Angeles | 31 | 0 | 0 | 0 | 37 | ||||
1532 | 1532 | 2022-01-14 | 910000038 | 910000038-fireside-health-care-center | FIRESIDE HEALTH CARE CENTER | Los Angeles | 46 | 47 | 0 | 0 | 37 | ||||
1537 | 1537 | 2022-01-14 | 970000062 | 970000062-garden-crest-rehabilitation-center | GARDEN CREST REHABILITATION CENTER | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
1574 | 1574 | 2022-01-14 | 930000575 | 930000575-hollywood-presbyterian-medical-center-d-p-snf | HOLLYWOOD PRESBYTERIAN MEDICAL CENTER D/P SNF | Los Angeles | 33 | 1 | 0 | 0 | 37 | <11 | |||
1597 | 1597 | 2022-01-14 | 940000026 | 940000026-la-paz-geropsychiatric-center | LA PAZ GEROPSYCHIATRIC CENTER | Los Angeles | 39 | 14 | 0 | 0 | 37 | ||||
1598 | 1598 | 2022-01-14 | 920000059 | 920000059-lake-balboa-care-center | LAKE BALBOA CARE CENTER | Los Angeles | 21 | 14 | 0 | 0 | 37 | ||||
1601 | 1601 | 2022-01-14 | 950000066 | 950000066-landmark-medical-center | LANDMARK MEDICAL CENTER | Los Angeles | 69 | 97 | 0 | 0 | 37 | ||||
1603 | 1603 | 2022-01-14 | 950000068 | 950000068-laurel-park-behavioral-health-center | LAUREL PARK BEHAVIORAL HEALTH CENTER | Los Angeles | 21 | 1 | 0 | 0 | 37 | <11 | |||
1605 | 1605 | 2022-01-14 | 970000186 | 970000186-legacy-healthcare-center | LEGACY HEALTHCARE CENTER | Los Angeles | 43 | 58 | 0 | 0 | 37 | ||||
1614 | 1614 | 2022-01-14 | 940000101 | 940000101-long-beach-post-acute | LONG BEACH POST ACUTE | Los Angeles | 13 | 0 | 0 | 0 | 37 | ||||
1616 | 1616 | 2022-01-14 | 930001558 | 930001558-los-angeles-community-hospital-d-p-snf | LOS ANGELES COMMUNITY HOSPITAL D/P SNF | Los Angeles | 30 | 1 | 0 | 0 | 37 | <11 | |||
1618 | 1618 | 2022-01-14 | 910000035 | 910000035-lotus-care-center | LOTUS CARE CENTER | Los Angeles | 1 | 20 | 0 | 0 | 37 | <11 | |||
1626 | 1626 | 2022-01-14 | 910000060 | 910000060-marycrest-manor | MARYCREST MANOR | Los Angeles | 50 | 11 | 0 | 0 | 37 |
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 );