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 2020-09-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
605488 | 605488 | 2020-09-07 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 35 | 40 | 0 | 1 | 13 | <11 | |||
605489 | 605489 | 2020-09-07 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
605490 | 605490 | 2020-09-07 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 0 | 1 | 0 | 0 | 13 | <11 | |||
605491 | 605491 | 2020-09-07 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 18 | 28 | 0 | 1 | 13 | <11 | |||
605492 | 605492 | 2020-09-07 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
605493 | 605493 | 2020-09-07 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
605494 | 605494 | 2020-09-07 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
605495 | 605495 | 2020-09-07 | 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 |
605496 | 605496 | 2020-09-07 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 1 | 13 | <11 | |||
605497 | 605497 | 2020-09-07 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
605498 | 605498 | 2020-09-07 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
605499 | 605499 | 2020-09-07 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
605500 | 605500 | 2020-09-07 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
605501 | 605501 | 2020-09-07 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
605502 | 605502 | 2020-09-07 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
605503 | 605503 | 2020-09-07 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
605504 | 605504 | 2020-09-07 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
605505 | 605505 | 2020-09-07 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
605506 | 605506 | 2020-09-07 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
605507 | 605507 | 2020-09-07 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
605508 | 605508 | 2020-09-07 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
605509 | 605509 | 2020-09-07 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
605510 | 605510 | 2020-09-07 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
605511 | 605511 | 2020-09-07 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
605512 | 605512 | 2020-09-07 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 23 | 31 | 0 | 1 | 19 | <11 | |||
605513 | 605513 | 2020-09-07 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 18 | 15 | 0 | 1 | 19 | <11 | |||
605514 | 605514 | 2020-09-07 | 40000798 | 040000798-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
605515 | 605515 | 2020-09-07 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 1 | 1 | 1 | 1 | 19 | <11 | <11 | <11 | <11 |
605516 | 605516 | 2020-09-07 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
605517 | 605517 | 2020-09-07 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
605518 | 605518 | 2020-09-07 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
605519 | 605519 | 2020-09-07 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 38 | 118 | 1 | 33 | 19 | <11 | |||
605520 | 605520 | 2020-09-07 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 1 | 20 | 0 | 1 | 19 | <11 | <11 | ||
605521 | 605521 | 2020-09-07 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 13 | 30 | 0 | 12 | 19 | ||||
605522 | 605522 | 2020-09-07 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 25 | 28 | 0 | 1 | 19 | <11 | |||
605523 | 605523 | 2020-09-07 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 12 | 11 | 0 | 1 | 19 | <11 | |||
605524 | 605524 | 2020-09-07 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 1 | 1 | 0 | 1 | 19 | <11 | <11 | <11 | |
605525 | 605525 | 2020-09-07 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
605526 | 605526 | 2020-09-07 | 40000043 | 040000043-fresno-nursing-center | FRESNO NURSING CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
605527 | 605527 | 2020-09-07 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 1 | 11 | 0 | 0 | 19 | <11 | |||
605528 | 605528 | 2020-09-07 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
605529 | 605529 | 2020-09-07 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 18 | 14 | 0 | 1 | 19 | <11 | |||
605530 | 605530 | 2020-09-07 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 24 | 28 | 0 | 1 | 19 | <11 | |||
605531 | 605531 | 2020-09-07 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
605532 | 605532 | 2020-09-07 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
605533 | 605533 | 2020-09-07 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
605534 | 605534 | 2020-09-07 | 40000069 | 040000069-orchard-post-acute | ORCHARD POST ACUTE | Fresno | 25 | 32 | 0 | 1 | 19 | <11 | |||
605535 | 605535 | 2020-09-07 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 29 | 36 | 0 | 1 | 19 | <11 | |||
605536 | 605536 | 2020-09-07 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 26 | 1 | 0 | 0 | 19 | <11 | |||
605537 | 605537 | 2020-09-07 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
605538 | 605538 | 2020-09-07 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 23 | 16 | 0 | 1 | 19 | <11 | |||
605539 | 605539 | 2020-09-07 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 35 | 42 | 0 | 1 | 19 | <11 | |||
605540 | 605540 | 2020-09-07 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
605541 | 605541 | 2020-09-07 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
605542 | 605542 | 2020-09-07 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 29 | 34 | 0 | 1 | 19 | <11 | |||
605543 | 605543 | 2020-09-07 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
605544 | 605544 | 2020-09-07 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
605545 | 605545 | 2020-09-07 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 1 | 0 | 0 | 0 | 21 | <11 | |||
605546 | 605546 | 2020-09-07 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
605547 | 605547 | 2020-09-07 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
605548 | 605548 | 2020-09-07 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
605549 | 605549 | 2020-09-07 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
605550 | 605550 | 2020-09-07 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 1 | 1 | 23 | <11 | <11 | <11 | <11 |
605551 | 605551 | 2020-09-07 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
605552 | 605552 | 2020-09-07 | 90000092 | 090000092-el-centro-post-acute-care | EL CENTRO POST-ACUTE CARE | Imperial | 32 | 46 | 0 | 17 | 25 | ||||
605553 | 605553 | 2020-09-07 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 36 | 27 | 1 | 1 | 25 | <11 | <11 | ||
605554 | 605554 | 2020-09-07 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 33 | 26 | 0 | 0 | 25 | ||||
605555 | 605555 | 2020-09-07 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 19 | 47 | 0 | 12 | 27 | ||||
605556 | 605556 | 2020-09-07 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
605557 | 605557 | 2020-09-07 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
605558 | 605558 | 2020-09-07 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
605559 | 605559 | 2020-09-07 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 23 | 14 | 0 | 1 | 29 | <11 | |||
605560 | 605560 | 2020-09-07 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 19 | 1 | 0 | 0 | 29 | <11 | |||
605561 | 605561 | 2020-09-07 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 12 | 1 | 0 | 0 | 29 | <11 | |||
605562 | 605562 | 2020-09-07 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 21 | 17 | 0 | 0 | 29 | ||||
605563 | 605563 | 2020-09-07 | 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 | |
605564 | 605564 | 2020-09-07 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 66 | 104 | 0 | 19 | 29 | ||||
605565 | 605565 | 2020-09-07 | 120000365 | 120000365-parkview-julian-healthcare-center | PARKVIEW JULIAN HEALTHCARE CENTER | Kern | 21 | 1 | 0 | 1 | 29 | <11 | <11 | ||
605566 | 605566 | 2020-09-07 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
605567 | 605567 | 2020-09-07 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | ||
605568 | 605568 | 2020-09-07 | 120000322 | 120000322-san-joaquin-nursing-center | SAN JOAQUIN NURSING CENTER | Kern | 13 | 1 | 0 | 0 | 29 | <11 | |||
605569 | 605569 | 2020-09-07 | 120000375 | 120000375-shafter-nursing-care | SHAFTER NURSING CARE | Kern | 41 | 62 | 0 | 1 | 29 | <11 | |||
605570 | 605570 | 2020-09-07 | 120000320 | 120000320-the-orchards-post-acute | THE ORCHARDS POST-ACUTE | Kern | 29 | 26 | 0 | 1 | 29 | <11 | |||
605571 | 605571 | 2020-09-07 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 82 | 78 | 0 | 1 | 29 | <11 | |||
605572 | 605572 | 2020-09-07 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 32 | 52 | 0 | 1 | 29 | <11 | |||
605573 | 605573 | 2020-09-07 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
605574 | 605574 | 2020-09-07 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 25 | 57 | 0 | 1 | 29 | <11 | |||
605575 | 605575 | 2020-09-07 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 37 | 65 | 0 | 1 | 29 | <11 | |||
605576 | 605576 | 2020-09-07 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 75 | 89 | 0 | 23 | 31 | ||||
605577 | 605577 | 2020-09-07 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 1 | 0 | 0 | 0 | 31 | <11 | |||
605578 | 605578 | 2020-09-07 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 1 | 1 | 0 | 0 | 31 | <11 | <11 | ||
605579 | 605579 | 2020-09-07 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 1 | 16 | 0 | 1 | 33 | <11 | <11 | ||
605580 | 605580 | 2020-09-07 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 1 | 0 | 0 | 0 | 33 | <11 | |||
605581 | 605581 | 2020-09-07 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
605582 | 605582 | 2020-09-07 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 0 | 0 | 0 | 0 | 35 | ||||
605583 | 605583 | 2020-09-07 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 42 | 36 | 0 | 15 | 37 | ||||
605584 | 605584 | 2020-09-07 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 37 | 54 | 1 | 21 | 37 | <11 | |||
605585 | 605585 | 2020-09-07 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
605586 | 605586 | 2020-09-07 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
605587 | 605587 | 2020-09-07 | 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 );