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 date descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
517432 | 517432 | 2020-11-18 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 36 | 40 | 0 | 1 | 13 | <11 | |||
517433 | 517433 | 2020-11-18 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
517434 | 517434 | 2020-11-18 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
517435 | 517435 | 2020-11-18 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 19 | 29 | 0 | 1 | 13 | <11 | |||
517436 | 517436 | 2020-11-18 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
517437 | 517437 | 2020-11-18 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
517438 | 517438 | 2020-11-18 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
517439 | 517439 | 2020-11-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 |
517440 | 517440 | 2020-11-18 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 1 | 13 | <11 | |||
517441 | 517441 | 2020-11-18 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
517442 | 517442 | 2020-11-18 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
517443 | 517443 | 2020-11-18 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
517444 | 517444 | 2020-11-18 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
517445 | 517445 | 2020-11-18 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
517446 | 517446 | 2020-11-18 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
517447 | 517447 | 2020-11-18 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
517448 | 517448 | 2020-11-18 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 1 | 19 | 0 | 0 | 13 | <11 | |||
517449 | 517449 | 2020-11-18 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
517450 | 517450 | 2020-11-18 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 1 | 0 | 0 | 0 | 15 | <11 | |||
517451 | 517451 | 2020-11-18 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
517452 | 517452 | 2020-11-18 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
517453 | 517453 | 2020-11-18 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
517454 | 517454 | 2020-11-18 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
517455 | 517455 | 2020-11-18 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
517456 | 517456 | 2020-11-18 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 24 | 31 | 0 | 1 | 19 | <11 | |||
517457 | 517457 | 2020-11-18 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 27 | 15 | 0 | 1 | 19 | <11 | |||
517458 | 517458 | 2020-11-18 | 40000798 | 040000798-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
517459 | 517459 | 2020-11-18 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
517460 | 517460 | 2020-11-18 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 17 | 1 | 0 | 0 | 19 | <11 | |||
517461 | 517461 | 2020-11-18 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
517462 | 517462 | 2020-11-18 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
517463 | 517463 | 2020-11-18 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 40 | 120 | 1 | 33 | 19 | <11 | |||
517464 | 517464 | 2020-11-18 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 1 | 20 | 0 | 1 | 19 | <11 | <11 | ||
517465 | 517465 | 2020-11-18 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 14 | 30 | 0 | 12 | 19 | ||||
517466 | 517466 | 2020-11-18 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 26 | 29 | 0 | 1 | 19 | <11 | |||
517467 | 517467 | 2020-11-18 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 15 | 11 | 0 | 1 | 19 | <11 | |||
517468 | 517468 | 2020-11-18 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 1 | 1 | 0 | 1 | 19 | <11 | <11 | <11 | |
517469 | 517469 | 2020-11-18 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 16 | 18 | 0 | 1 | 19 | <11 | |||
517470 | 517470 | 2020-11-18 | 40000043 | 040000043-fresno-nursing-center | FRESNO NURSING CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
517471 | 517471 | 2020-11-18 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 1 | 12 | 0 | 0 | 19 | <11 | |||
517472 | 517472 | 2020-11-18 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 14 | 1 | 0 | 0 | 19 | <11 | |||
517473 | 517473 | 2020-11-18 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 19 | 14 | 0 | 1 | 19 | <11 | |||
517474 | 517474 | 2020-11-18 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 27 | 28 | 0 | 1 | 19 | <11 | |||
517475 | 517475 | 2020-11-18 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
517476 | 517476 | 2020-11-18 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
517477 | 517477 | 2020-11-18 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 13 | 1 | 0 | 0 | 19 | <11 | |||
517478 | 517478 | 2020-11-18 | 40000069 | 040000069-orchard-post-acute | ORCHARD POST ACUTE | Fresno | 30 | 32 | 0 | 1 | 19 | <11 | |||
517479 | 517479 | 2020-11-18 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 43 | 39 | 0 | 1 | 19 | <11 | |||
517480 | 517480 | 2020-11-18 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 30 | 1 | 0 | 0 | 19 | <11 | |||
517481 | 517481 | 2020-11-18 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
517482 | 517482 | 2020-11-18 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 25 | 16 | 0 | 1 | 19 | <11 | |||
517483 | 517483 | 2020-11-18 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 53 | 76 | 0 | 1 | 19 | <11 | |||
517484 | 517484 | 2020-11-18 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
517485 | 517485 | 2020-11-18 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
517486 | 517486 | 2020-11-18 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 29 | 34 | 0 | 1 | 19 | <11 | |||
517487 | 517487 | 2020-11-18 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 13 | 1 | 0 | 0 | 19 | <11 | |||
517488 | 517488 | 2020-11-18 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 41 | 88 | 0 | 1 | 19 | <11 | |||
517489 | 517489 | 2020-11-18 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 1 | 0 | 0 | 0 | 21 | <11 | |||
517490 | 517490 | 2020-11-18 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
517491 | 517491 | 2020-11-18 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
517492 | 517492 | 2020-11-18 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
517493 | 517493 | 2020-11-18 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
517494 | 517494 | 2020-11-18 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 1 | 1 | 23 | <11 | <11 | <11 | <11 |
517495 | 517495 | 2020-11-18 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
517496 | 517496 | 2020-11-18 | 90000092 | 090000092-el-centro-post-acute-care | EL CENTRO POST-ACUTE CARE | Imperial | 43 | 53 | 0 | 17 | 25 | ||||
517497 | 517497 | 2020-11-18 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 38 | 27 | 1 | 1 | 25 | <11 | <11 | ||
517498 | 517498 | 2020-11-18 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 35 | 27 | 0 | 0 | 25 | ||||
517499 | 517499 | 2020-11-18 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 19 | 47 | 0 | 12 | 27 | ||||
517500 | 517500 | 2020-11-18 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 1 | 1 | 0 | 0 | 27 | <11 | <11 | ||
517501 | 517501 | 2020-11-18 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
517502 | 517502 | 2020-11-18 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
517503 | 517503 | 2020-11-18 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 30 | 14 | 0 | 1 | 29 | <11 | |||
517504 | 517504 | 2020-11-18 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 25 | 13 | 0 | 0 | 29 | ||||
517505 | 517505 | 2020-11-18 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 17 | 1 | 0 | 0 | 29 | <11 | |||
517506 | 517506 | 2020-11-18 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 24 | 33 | 0 | 0 | 29 | ||||
517507 | 517507 | 2020-11-18 | 120000695 | 120000695-kern-valley-healthcare-district-d-p-snf | KERN VALLEY HEALTHCARE DISTRICT D/P SNF | Kern | 1 | 1 | 0 | 1 | 29 | <11 | <11 | <11 | |
517508 | 517508 | 2020-11-18 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 71 | 104 | 0 | 19 | 29 | ||||
517509 | 517509 | 2020-11-18 | 120000365 | 120000365-parkview-julian-healthcare-center | PARKVIEW JULIAN HEALTHCARE CENTER | Kern | 26 | 1 | 0 | 1 | 29 | <11 | <11 | ||
517510 | 517510 | 2020-11-18 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
517511 | 517511 | 2020-11-18 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | ||
517512 | 517512 | 2020-11-18 | 120000322 | 120000322-san-joaquin-nursing-center | SAN JOAQUIN NURSING CENTER | Kern | 22 | 1 | 0 | 0 | 29 | <11 | |||
517513 | 517513 | 2020-11-18 | 120000375 | 120000375-shafter-nursing-care | SHAFTER NURSING CARE | Kern | 53 | 74 | 0 | 1 | 29 | <11 | |||
517514 | 517514 | 2020-11-18 | 120000320 | 120000320-the-orchards-post-acute | THE ORCHARDS POST-ACUTE | Kern | 32 | 26 | 0 | 1 | 29 | <11 | |||
517515 | 517515 | 2020-11-18 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 85 | 95 | 0 | 1 | 29 | <11 | |||
517516 | 517516 | 2020-11-18 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 33 | 52 | 0 | 1 | 29 | <11 | |||
517517 | 517517 | 2020-11-18 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
517518 | 517518 | 2020-11-18 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 30 | 58 | 0 | 1 | 29 | <11 | |||
517519 | 517519 | 2020-11-18 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 41 | 66 | 0 | 1 | 29 | <11 | |||
517520 | 517520 | 2020-11-18 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 79 | 90 | 0 | 23 | 31 | ||||
517521 | 517521 | 2020-11-18 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 11 | 1 | 0 | 0 | 31 | <11 | |||
517522 | 517522 | 2020-11-18 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 1 | 1 | 0 | 0 | 31 | <11 | <11 | ||
517523 | 517523 | 2020-11-18 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 22 | 37 | 0 | 1 | 33 | <11 | |||
517524 | 517524 | 2020-11-18 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 1 | 0 | 0 | 0 | 33 | <11 | |||
517525 | 517525 | 2020-11-18 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 17 | 48 | 0 | 1 | 33 | <11 | |||
517526 | 517526 | 2020-11-18 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 1 | 0 | 0 | 0 | 35 | <11 | |||
517527 | 517527 | 2020-11-18 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 45 | 37 | 0 | 15 | 37 | ||||
517528 | 517528 | 2020-11-18 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 44 | 67 | 1 | 21 | 37 | <11 | |||
517529 | 517529 | 2020-11-18 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 16 | 1 | 0 | 0 | 37 | <11 | |||
517530 | 517530 | 2020-11-18 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 15 | 12 | 1 | 0 | 37 | <11 | |||
517531 | 517531 | 2020-11-18 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 41 | 107 | 0 | 26 | 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 );