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,224 rows where "date" is on date 2021-09-18 sorted by patients_deaths_note 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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145539 | 145539 | 2021-09-18 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 45 | 85 | 0 | 1 | 1 | <11 | |||
145545 | 145545 | 2021-09-18 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 16 | 22 | 0 | 1 | 1 | <11 | |||
145547 | 145547 | 2021-09-18 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 14 | 1 | 0 | 1 | 1 | <11 | <11 | ||
145548 | 145548 | 2021-09-18 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 60 | 137 | 0 | 1 | 1 | <11 | |||
145552 | 145552 | 2021-09-18 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 1 | 20 | 0 | 1 | 1 | <11 | <11 | ||
145553 | 145553 | 2021-09-18 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 19 | 29 | 0 | 1 | 1 | <11 | |||
145555 | 145555 | 2021-09-18 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 41 | 17 | 0 | 1 | 1 | <11 | |||
145556 | 145556 | 2021-09-18 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 48 | 102 | 1 | 1 | 1 | <11 | <11 | ||
145559 | 145559 | 2021-09-18 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 27 | 36 | 0 | 1 | 1 | <11 | |||
145560 | 145560 | 2021-09-18 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 41 | 39 | 0 | 1 | 1 | <11 | |||
145561 | 145561 | 2021-09-18 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 26 | 55 | 0 | 1 | 1 | <11 | |||
145562 | 145562 | 2021-09-18 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 31 | 64 | 0 | 1 | 1 | <11 | |||
145563 | 145563 | 2021-09-18 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 13 | 48 | 0 | 1 | 1 | <11 | |||
145565 | 145565 | 2021-09-18 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 51 | 45 | 0 | 1 | 1 | <11 | |||
145566 | 145566 | 2021-09-18 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 34 | 28 | 0 | 1 | 1 | <11 | |||
145567 | 145567 | 2021-09-18 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 50 | 59 | 1 | 1 | 1 | <11 | <11 | ||
145570 | 145570 | 2021-09-18 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 66 | 21 | 1 | 1 | 1 | <11 | <11 | ||
145575 | 145575 | 2021-09-18 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 20 | 1 | 0 | 1 | 1 | <11 | <11 | ||
145579 | 145579 | 2021-09-18 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 37 | 48 | 0 | 1 | 1 | <11 | |||
145580 | 145580 | 2021-09-18 | 20000101 | 020000101-niles-canyon-post-acute | NILES CANYON POST ACUTE | Alameda | 22 | 36 | 0 | 1 | 1 | <11 | |||
145581 | 145581 | 2021-09-18 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 56 | 88 | 0 | 1 | 1 | <11 | |||
145583 | 145583 | 2021-09-18 | 630014635 | 630014635-park-bridge-rehabilitation-and-wellness-center | PARK BRIDGE REHABILITATION AND WELLNESS CENTER | Alameda | 59 | 91 | 0 | 1 | 1 | <11 | |||
145586 | 145586 | 2021-09-18 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 20 | 23 | 0 | 1 | 1 | <11 | |||
145588 | 145588 | 2021-09-18 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 27 | 32 | 0 | 1 | 1 | <11 | |||
145589 | 145589 | 2021-09-18 | 20000276 | 020000276-redwood-convalescent-hospital-inc | REDWOOD CONVALESCENT HOSPITAL, INC. | Alameda | 14 | 24 | 0 | 1 | 1 | <11 | |||
145590 | 145590 | 2021-09-18 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 23 | 30 | 0 | 1 | 1 | <11 | |||
145591 | 145591 | 2021-09-18 | 20000077 | 020000077-san-leandro-healthcare-center | SAN LEANDRO HEALTHCARE CENTER | Alameda | 30 | 32 | 0 | 1 | 1 | <11 | |||
145592 | 145592 | 2021-09-18 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 16 | 29 | 0 | 1 | 1 | <11 | |||
145594 | 145594 | 2021-09-18 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 12 | 33 | 0 | 1 | 1 | <11 | |||
145598 | 145598 | 2021-09-18 | 630014957 | 630014957-stratford-villa-post-acute | STRATFORD VILLA POST-ACUTE | Alameda | 15 | 26 | 0 | 1 | 1 | <11 | |||
145599 | 145599 | 2021-09-18 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 27 | 37 | 0 | 1 | 1 | <11 | |||
145600 | 145600 | 2021-09-18 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 40 | 54 | 0 | 1 | 1 | <11 | |||
145602 | 145602 | 2021-09-18 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 26 | 32 | 0 | 1 | 1 | <11 | |||
145603 | 145603 | 2021-09-18 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 40 | 59 | 0 | 1 | 1 | <11 | |||
145604 | 145604 | 2021-09-18 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 38 | 34 | 0 | 1 | 1 | <11 | |||
145606 | 145606 | 2021-09-18 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 75 | 94 | 0 | 1 | 1 | <11 | |||
145607 | 145607 | 2021-09-18 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 38 | 57 | 0 | 1 | 1 | <11 | |||
145608 | 145608 | 2021-09-18 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 54 | 87 | 0 | 1 | 1 | <11 | |||
145609 | 145609 | 2021-09-18 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 29 | 37 | 0 | 1 | 1 | <11 | |||
145610 | 145610 | 2021-09-18 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 67 | 87 | 0 | 1 | 1 | <11 | |||
145613 | 145613 | 2021-09-18 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 28 | 1 | 0 | 1 | 7 | <11 | <11 | ||
145616 | 145616 | 2021-09-18 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 77 | 112 | 0 | 1 | 7 | <11 | |||
145618 | 145618 | 2021-09-18 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 1 | 23 | 0 | 1 | 7 | <11 | <11 | ||
145619 | 145619 | 2021-09-18 | 230000025 | 230000025-windsor-chico-care-center | WINDSOR CHICO CARE CENTER | Butte | 24 | 44 | 0 | 1 | 7 | <11 | |||
145620 | 145620 | 2021-09-18 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 42 | 72 | 0 | 1 | 7 | <11 | |||
145621 | 145621 | 2021-09-18 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 27 | 61 | 0 | 1 | 9 | <11 | |||
145622 | 145622 | 2021-09-18 | 230000424 | 230000424-colusa-medical-center-snf | COLUSA MEDICAL CENTER - SNF | Colusa | 20 | 26 | 0 | 1 | 11 | <11 | |||
145623 | 145623 | 2021-09-18 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 59 | 32 | 0 | 1 | 11 | <11 | |||
145624 | 145624 | 2021-09-18 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 18 | 11 | 0 | 1 | 13 | <11 | |||
145625 | 145625 | 2021-09-18 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 48 | 66 | 0 | 1 | 13 | <11 | |||
145627 | 145627 | 2021-09-18 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 16 | 12 | 0 | 1 | 13 | <11 | |||
145628 | 145628 | 2021-09-18 | 140000003 | 140000003-delta-view-post-acute | DELTA VIEW POST ACUTE | Contra Costa | 30 | 57 | 0 | 1 | 13 | <11 | |||
145629 | 145629 | 2021-09-18 | 140000564 | 140000564-diamond-ridge-healthcare-center | DIAMOND RIDGE HEALTHCARE CENTER | Contra Costa | 19 | 22 | 0 | 1 | 13 | <11 | |||
145632 | 145632 | 2021-09-18 | 140000102 | 140000102-legacy-post-acute-care | LEGACY POST ACUTE CARE | Contra Costa | 49 | 77 | 0 | 1 | 13 | <11 | |||
145633 | 145633 | 2021-09-18 | 140000105 | 140000105-lone-tree-post-acute | LONE TREE POST ACUTE | Contra Costa | 23 | 44 | 0 | 1 | 13 | <11 | |||
145634 | 145634 | 2021-09-18 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 25 | 61 | 0 | 1 | 13 | <11 | |||
145636 | 145636 | 2021-09-18 | 140000106 | 140000106-martinez-convalescent-hospital | MARTINEZ CONVALESCENT HOSPITAL | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
145638 | 145638 | 2021-09-18 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 42 | 40 | 0 | 1 | 13 | <11 | |||
145639 | 145639 | 2021-09-18 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 1 | 1 | 1 | 1 | 13 | <11 | <11 | <11 | <11 |
145641 | 145641 | 2021-09-18 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 29 | 48 | 0 | 1 | 13 | <11 | |||
145644 | 145644 | 2021-09-18 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 44 | 63 | 0 | 1 | 13 | <11 | |||
145645 | 145645 | 2021-09-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 |
145646 | 145646 | 2021-09-18 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
145647 | 145647 | 2021-09-18 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
145649 | 145649 | 2021-09-18 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 1 | 26 | 0 | 1 | 13 | <11 | <11 | ||
145652 | 145652 | 2021-09-18 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 29 | 17 | 0 | 1 | 13 | <11 | |||
145653 | 145653 | 2021-09-18 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 16 | 61 | 0 | 1 | 13 | <11 | |||
145661 | 145661 | 2021-09-18 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 81 | 93 | 0 | 1 | 17 | <11 | |||
145662 | 145662 | 2021-09-18 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 29 | 35 | 0 | 1 | 19 | <11 | |||
145663 | 145663 | 2021-09-18 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 91 | 27 | 0 | 1 | 19 | <11 | |||
145665 | 145665 | 2021-09-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 |
145666 | 145666 | 2021-09-18 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 55 | 24 | 0 | 1 | 19 | <11 | |||
145667 | 145667 | 2021-09-18 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 21 | 28 | 0 | 1 | 19 | <11 | |||
145668 | 145668 | 2021-09-18 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 28 | 41 | 0 | 1 | 19 | <11 | |||
145672 | 145672 | 2021-09-18 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 36 | 34 | 0 | 1 | 19 | <11 | |||
145673 | 145673 | 2021-09-18 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 56 | 64 | 0 | 1 | 19 | <11 | |||
145674 | 145674 | 2021-09-18 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 25 | 22 | 0 | 1 | 19 | <11 | |||
145675 | 145675 | 2021-09-18 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 19 | 18 | 0 | 1 | 19 | <11 | |||
145676 | 145676 | 2021-09-18 | 40000043 | 040000043-fresno-nursing-center | FRESNO NURSING CENTER | Fresno | 48 | 53 | 0 | 1 | 19 | <11 | |||
145677 | 145677 | 2021-09-18 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 59 | 80 | 0 | 1 | 19 | <11 | |||
145678 | 145678 | 2021-09-18 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 38 | 51 | 0 | 1 | 19 | <11 | |||
145679 | 145679 | 2021-09-18 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 33 | 32 | 1 | 1 | 19 | <11 | <11 | ||
145681 | 145681 | 2021-09-18 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 36 | 40 | 0 | 1 | 19 | <11 | |||
145682 | 145682 | 2021-09-18 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 51 | 40 | 0 | 1 | 19 | <11 | |||
145684 | 145684 | 2021-09-18 | 40000069 | 040000069-orchard-post-acute | ORCHARD POST ACUTE | Fresno | 44 | 69 | 0 | 1 | 19 | <11 | |||
145687 | 145687 | 2021-09-18 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 21 | 12 | 0 | 1 | 19 | <11 | |||
145689 | 145689 | 2021-09-18 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 76 | 93 | 0 | 1 | 19 | <11 | |||
145690 | 145690 | 2021-09-18 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 38 | 31 | 0 | 1 | 19 | <11 | |||
145692 | 145692 | 2021-09-18 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 43 | 34 | 0 | 1 | 19 | <11 | |||
145695 | 145695 | 2021-09-18 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 43 | 43 | 0 | 1 | 21 | <11 | |||
145697 | 145697 | 2021-09-18 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 0 | 1 | 23 | <11 | <11 | <11 | |
145698 | 145698 | 2021-09-18 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 33 | 59 | 0 | 1 | 23 | <11 | |||
145700 | 145700 | 2021-09-18 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 1 | 1 | 23 | <11 | <11 | <11 | <11 |
145703 | 145703 | 2021-09-18 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 51 | 28 | 1 | 1 | 25 | <11 | <11 | ||
145706 | 145706 | 2021-09-18 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 18 | 12 | 0 | 1 | 27 | <11 | |||
145709 | 145709 | 2021-09-18 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 52 | 37 | 0 | 1 | 29 | <11 | |||
145712 | 145712 | 2021-09-18 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 88 | 71 | 0 | 1 | 29 | <11 | |||
145713 | 145713 | 2021-09-18 | 120000695 | 120000695-kern-valley-healthcare-district-d-p-snf | KERN VALLEY HEALTHCARE DISTRICT D/P SNF | Kern | 23 | 25 | 0 | 1 | 29 | <11 | |||
145715 | 145715 | 2021-09-18 | 120000365 | 120000365-parkview-julian-healthcare-center | PARKVIEW JULIAN HEALTHCARE CENTER | Kern | 80 | 105 | 0 | 1 | 29 | <11 | |||
145717 | 145717 | 2021-09-18 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 59 | 54 | 0 | 1 | 29 | <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 );