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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
550453 | 550453 | 2020-10-22 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 36 | 40 | 0 | 1 | 13 | <11 | |||
550454 | 550454 | 2020-10-22 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
550455 | 550455 | 2020-10-22 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
550456 | 550456 | 2020-10-22 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
550457 | 550457 | 2020-10-22 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550458 | 550458 | 2020-10-22 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
550459 | 550459 | 2020-10-22 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
550460 | 550460 | 2020-10-22 | 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 |
550461 | 550461 | 2020-10-22 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 1 | 13 | <11 | |||
550462 | 550462 | 2020-10-22 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550463 | 550463 | 2020-10-22 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550464 | 550464 | 2020-10-22 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
550465 | 550465 | 2020-10-22 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550466 | 550466 | 2020-10-22 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
550467 | 550467 | 2020-10-22 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550468 | 550468 | 2020-10-22 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550469 | 550469 | 2020-10-22 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 1 | 19 | 0 | 0 | 13 | <11 | |||
550470 | 550470 | 2020-10-22 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
550471 | 550471 | 2020-10-22 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 1 | 0 | 0 | 0 | 15 | <11 | |||
550472 | 550472 | 2020-10-22 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
550473 | 550473 | 2020-10-22 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
550474 | 550474 | 2020-10-22 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
550475 | 550475 | 2020-10-22 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
550476 | 550476 | 2020-10-22 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
550477 | 550477 | 2020-10-22 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 23 | 31 | 0 | 1 | 19 | <11 | |||
550478 | 550478 | 2020-10-22 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 20 | 15 | 0 | 1 | 19 | <11 | |||
550479 | 550479 | 2020-10-22 | 40000798 | 040000798-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
550480 | 550480 | 2020-10-22 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
550481 | 550481 | 2020-10-22 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 14 | 1 | 0 | 0 | 19 | <11 | |||
550482 | 550482 | 2020-10-22 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
550483 | 550483 | 2020-10-22 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
550484 | 550484 | 2020-10-22 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 39 | 118 | 1 | 33 | 19 | <11 | |||
550485 | 550485 | 2020-10-22 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 1 | 20 | 0 | 1 | 19 | <11 | <11 | ||
550486 | 550486 | 2020-10-22 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 13 | 30 | 0 | 12 | 19 | ||||
550487 | 550487 | 2020-10-22 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 26 | 28 | 0 | 1 | 19 | <11 | |||
550488 | 550488 | 2020-10-22 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 13 | 11 | 0 | 1 | 19 | <11 | |||
550489 | 550489 | 2020-10-22 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 1 | 1 | 0 | 1 | 19 | <11 | <11 | <11 | |
550490 | 550490 | 2020-10-22 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
550491 | 550491 | 2020-10-22 | 40000043 | 040000043-fresno-nursing-center | FRESNO NURSING CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
550492 | 550492 | 2020-10-22 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 1 | 12 | 0 | 0 | 19 | <11 | |||
550493 | 550493 | 2020-10-22 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
550494 | 550494 | 2020-10-22 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 18 | 14 | 0 | 1 | 19 | <11 | |||
550495 | 550495 | 2020-10-22 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 25 | 28 | 0 | 1 | 19 | <11 | |||
550496 | 550496 | 2020-10-22 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
550497 | 550497 | 2020-10-22 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
550498 | 550498 | 2020-10-22 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
550499 | 550499 | 2020-10-22 | 40000069 | 040000069-orchard-post-acute | ORCHARD POST ACUTE | Fresno | 26 | 32 | 0 | 1 | 19 | <11 | |||
550500 | 550500 | 2020-10-22 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 38 | 38 | 0 | 1 | 19 | <11 | |||
550501 | 550501 | 2020-10-22 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 29 | 1 | 0 | 0 | 19 | <11 | |||
550502 | 550502 | 2020-10-22 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
550503 | 550503 | 2020-10-22 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 25 | 16 | 0 | 1 | 19 | <11 | |||
550504 | 550504 | 2020-10-22 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 45 | 52 | 0 | 1 | 19 | <11 | |||
550505 | 550505 | 2020-10-22 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
550506 | 550506 | 2020-10-22 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
550507 | 550507 | 2020-10-22 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 29 | 34 | 0 | 1 | 19 | <11 | |||
550508 | 550508 | 2020-10-22 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
550509 | 550509 | 2020-10-22 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 17 | 1 | 0 | 0 | 19 | <11 | |||
550510 | 550510 | 2020-10-22 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 1 | 0 | 0 | 0 | 21 | <11 | |||
550511 | 550511 | 2020-10-22 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
550512 | 550512 | 2020-10-22 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
550513 | 550513 | 2020-10-22 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
550514 | 550514 | 2020-10-22 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
550515 | 550515 | 2020-10-22 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 1 | 1 | 23 | <11 | <11 | <11 | <11 |
550516 | 550516 | 2020-10-22 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
550517 | 550517 | 2020-10-22 | 90000092 | 090000092-el-centro-post-acute-care | EL CENTRO POST-ACUTE CARE | Imperial | 40 | 51 | 0 | 17 | 25 | ||||
550518 | 550518 | 2020-10-22 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 37 | 27 | 1 | 1 | 25 | <11 | <11 | ||
550519 | 550519 | 2020-10-22 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 35 | 27 | 0 | 0 | 25 | ||||
550520 | 550520 | 2020-10-22 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 19 | 47 | 0 | 12 | 27 | ||||
550521 | 550521 | 2020-10-22 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 1 | 1 | 0 | 0 | 27 | <11 | <11 | ||
550522 | 550522 | 2020-10-22 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
550523 | 550523 | 2020-10-22 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
550524 | 550524 | 2020-10-22 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 24 | 14 | 0 | 1 | 29 | <11 | |||
550525 | 550525 | 2020-10-22 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 24 | 1 | 0 | 0 | 29 | <11 | |||
550526 | 550526 | 2020-10-22 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 16 | 1 | 0 | 0 | 29 | <11 | |||
550527 | 550527 | 2020-10-22 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 21 | 17 | 0 | 0 | 29 | ||||
550528 | 550528 | 2020-10-22 | 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 | |
550529 | 550529 | 2020-10-22 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 71 | 104 | 0 | 19 | 29 | ||||
550530 | 550530 | 2020-10-22 | 120000365 | 120000365-parkview-julian-healthcare-center | PARKVIEW JULIAN HEALTHCARE CENTER | Kern | 22 | 1 | 0 | 1 | 29 | <11 | <11 | ||
550531 | 550531 | 2020-10-22 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
550532 | 550532 | 2020-10-22 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | ||
550533 | 550533 | 2020-10-22 | 120000322 | 120000322-san-joaquin-nursing-center | SAN JOAQUIN NURSING CENTER | Kern | 21 | 1 | 0 | 0 | 29 | <11 | |||
550534 | 550534 | 2020-10-22 | 120000375 | 120000375-shafter-nursing-care | SHAFTER NURSING CARE | Kern | 51 | 74 | 0 | 1 | 29 | <11 | |||
550535 | 550535 | 2020-10-22 | 120000320 | 120000320-the-orchards-post-acute | THE ORCHARDS POST-ACUTE | Kern | 29 | 26 | 0 | 1 | 29 | <11 | |||
550536 | 550536 | 2020-10-22 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 85 | 94 | 0 | 1 | 29 | <11 | |||
550537 | 550537 | 2020-10-22 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 33 | 52 | 0 | 1 | 29 | <11 | |||
550538 | 550538 | 2020-10-22 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
550539 | 550539 | 2020-10-22 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 29 | 58 | 0 | 1 | 29 | <11 | |||
550540 | 550540 | 2020-10-22 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 39 | 66 | 0 | 1 | 29 | <11 | |||
550541 | 550541 | 2020-10-22 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 77 | 90 | 0 | 23 | 31 | ||||
550542 | 550542 | 2020-10-22 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 1 | 0 | 0 | 0 | 31 | <11 | |||
550543 | 550543 | 2020-10-22 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 1 | 1 | 0 | 0 | 31 | <11 | <11 | ||
550544 | 550544 | 2020-10-22 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 22 | 37 | 0 | 1 | 33 | <11 | |||
550545 | 550545 | 2020-10-22 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 1 | 0 | 0 | 0 | 33 | <11 | |||
550546 | 550546 | 2020-10-22 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 17 | 47 | 0 | 1 | 33 | <11 | |||
550547 | 550547 | 2020-10-22 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 1 | 0 | 0 | 0 | 35 | <11 | |||
550548 | 550548 | 2020-10-22 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 43 | 36 | 0 | 15 | 37 | ||||
550549 | 550549 | 2020-10-22 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 40 | 58 | 1 | 21 | 37 | <11 | |||
550550 | 550550 | 2020-10-22 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
550551 | 550551 | 2020-10-22 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 13 | 1 | 1 | 0 | 37 | <11 | <11 | ||
550552 | 550552 | 2020-10-22 | 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 );