cdph-skilled-nursing-facilities
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- id
- The facility's unique identifier with the state.
- name
- The name of the skilled-nursing facility.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- staff_confirmed_cases
- The current number of confirmed coronavirus case amoung staff at that time.
- patients_confirmed_cases
- The current number of confirmed coronavirus case amoung patients at that time.
- staff_confirmed_cases_note
- In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
- patients_confirmed_cases_note
- In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
- staff_deaths
- The cumulative number of deaths case amoung staff at that time.
- patients_deaths
- The cumulative number of deaths case amoung patients at that time.
- staff_deaths_note
- In cases where the staff_deaths are obscured, this explains the range of possible values.
- patients_deaths_note
- In cases where the patients_deaths are obscured, this explains the range of possible values.
1,223 rows where "date" is on date 2020-07-26 sorted by staff_confirmed_cases_note
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657977 | 657977 | 2020-07-26 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 0 | 1 | 0 | 0 | 1 | <11 | |||
657980 | 657980 | 2020-07-26 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
657983 | 657983 | 2020-07-26 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
657984 | 657984 | 2020-07-26 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
657988 | 657988 | 2020-07-26 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
657990 | 657990 | 2020-07-26 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
657992 | 657992 | 2020-07-26 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
657995 | 657995 | 2020-07-26 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 11 | 36 | 0 | 0 | 1 | ||||
657998 | 657998 | 2020-07-26 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 12 | 32 | 0 | 1 | 1 | <11 | |||
657999 | 657999 | 2020-07-26 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 25 | 33 | 0 | 1 | 1 | <11 | |||
658001 | 658001 | 2020-07-26 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 23 | 43 | 0 | 1 | 1 | <11 | |||
658005 | 658005 | 2020-07-26 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658007 | 658007 | 2020-07-26 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658008 | 658008 | 2020-07-26 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658012 | 658012 | 2020-07-26 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658013 | 658013 | 2020-07-26 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658015 | 658015 | 2020-07-26 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658021 | 658021 | 2020-07-26 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658024 | 658024 | 2020-07-26 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 20 | 61 | 1 | 1 | 1 | <11 | <11 | ||
658027 | 658027 | 2020-07-26 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658029 | 658029 | 2020-07-26 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 16 | 29 | 0 | 1 | 1 | <11 | |||
658033 | 658033 | 2020-07-26 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658034 | 658034 | 2020-07-26 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658035 | 658035 | 2020-07-26 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658036 | 658036 | 2020-07-26 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 31 | 48 | 0 | 19 | 1 | ||||
658040 | 658040 | 2020-07-26 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
658042 | 658042 | 2020-07-26 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 27 | 48 | 0 | 1 | 1 | <11 | |||
658045 | 658045 | 2020-07-26 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 14 | 1 | 0 | 0 | 1 | <11 | |||
658049 | 658049 | 2020-07-26 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 27 | 29 | 0 | 1 | 1 | <11 | |||
658051 | 658051 | 2020-07-26 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
658054 | 658054 | 2020-07-26 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
658057 | 658057 | 2020-07-26 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
658058 | 658058 | 2020-07-26 | 230000025 | 230000025-windsor-chico-care-center | WINDSOR CHICO CARE CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
658059 | 658059 | 2020-07-26 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 23 | 26 | 0 | 1 | 7 | <11 | |||
658060 | 658060 | 2020-07-26 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 0 | 0 | 0 | 0 | 9 | ||||
658062 | 658062 | 2020-07-26 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 38 | 28 | 0 | 1 | 11 | <11 | |||
658063 | 658063 | 2020-07-26 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658065 | 658065 | 2020-07-26 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658070 | 658070 | 2020-07-26 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658073 | 658073 | 2020-07-26 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658074 | 658074 | 2020-07-26 | 140001126 | 140001126-manorcare-health-services-tice-valley | MANORCARE HEALTH SERVICES - TICE VALLEY | Contra Costa | 38 | 92 | 0 | 13 | 13 | ||||
658077 | 658077 | 2020-07-26 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 32 | 40 | 0 | 1 | 13 | <11 | |||
658079 | 658079 | 2020-07-26 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 0 | 1 | 0 | 0 | 13 | <11 | |||
658081 | 658081 | 2020-07-26 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658082 | 658082 | 2020-07-26 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
658085 | 658085 | 2020-07-26 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658088 | 658088 | 2020-07-26 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 0 | 1 | 0 | 0 | 13 | <11 | |||
658089 | 658089 | 2020-07-26 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658092 | 658092 | 2020-07-26 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
658095 | 658095 | 2020-07-26 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
658097 | 658097 | 2020-07-26 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
658098 | 658098 | 2020-07-26 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
658108 | 658108 | 2020-07-26 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 36 | 117 | 1 | 33 | 19 | <11 | |||
658118 | 658118 | 2020-07-26 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 15 | 12 | 0 | 0 | 19 | ||||
658119 | 658119 | 2020-07-26 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 18 | 26 | 0 | 1 | 19 | <11 | |||
658123 | 658123 | 2020-07-26 | 40000069 | 040000069-orchard-post-acute | ORCHARD POST ACUTE | Fresno | 18 | 25 | 0 | 1 | 19 | <11 | |||
658124 | 658124 | 2020-07-26 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 22 | 15 | 0 | 0 | 19 | ||||
658125 | 658125 | 2020-07-26 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 13 | 1 | 0 | 0 | 19 | <11 | |||
658127 | 658127 | 2020-07-26 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 22 | 15 | 0 | 1 | 19 | <11 | |||
658131 | 658131 | 2020-07-26 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 27 | 34 | 0 | 1 | 19 | <11 | |||
658135 | 658135 | 2020-07-26 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
658136 | 658136 | 2020-07-26 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
658137 | 658137 | 2020-07-26 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
658138 | 658138 | 2020-07-26 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
658140 | 658140 | 2020-07-26 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
658141 | 658141 | 2020-07-26 | 90000092 | 090000092-el-centro-post-acute-care | EL CENTRO POST-ACUTE CARE | Imperial | 30 | 44 | 0 | 17 | 25 | ||||
658142 | 658142 | 2020-07-26 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 32 | 23 | 1 | 1 | 25 | <11 | <11 | ||
658143 | 658143 | 2020-07-26 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 32 | 1 | 0 | 0 | 25 | <11 | |||
658144 | 658144 | 2020-07-26 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
658145 | 658145 | 2020-07-26 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
658147 | 658147 | 2020-07-26 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
658151 | 658151 | 2020-07-26 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 16 | 0 | 0 | 0 | 29 | ||||
658152 | 658152 | 2020-07-26 | 120000695 | 120000695-kern-valley-healthcare-district-d-p-snf | KERN VALLEY HEALTHCARE DISTRICT D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
658153 | 658153 | 2020-07-26 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 57 | 104 | 0 | 19 | 29 | ||||
658154 | 658154 | 2020-07-26 | 120000365 | 120000365-parkview-julian-healthcare-center | PARKVIEW JULIAN HEALTHCARE CENTER | Kern | 13 | 1 | 0 | 1 | 29 | <11 | <11 | ||
658155 | 658155 | 2020-07-26 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
658156 | 658156 | 2020-07-26 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
658158 | 658158 | 2020-07-26 | 120000375 | 120000375-shafter-nursing-care | SHAFTER NURSING CARE | Kern | 20 | 44 | 0 | 1 | 29 | <11 | |||
658159 | 658159 | 2020-07-26 | 120000320 | 120000320-the-orchards-post-acute | THE ORCHARDS POST-ACUTE | Kern | 29 | 25 | 0 | 1 | 29 | <11 | |||
658160 | 658160 | 2020-07-26 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 70 | 53 | 0 | 1 | 29 | <11 | |||
658161 | 658161 | 2020-07-26 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 26 | 48 | 0 | 1 | 29 | <11 | |||
658162 | 658162 | 2020-07-26 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 0 | 0 | 0 | 0 | 29 | ||||
658164 | 658164 | 2020-07-26 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 34 | 63 | 0 | 1 | 29 | <11 | |||
658165 | 658165 | 2020-07-26 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 75 | 89 | 0 | 23 | 31 | ||||
658168 | 658168 | 2020-07-26 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 0 | 0 | 0 | 0 | 33 | ||||
658169 | 658169 | 2020-07-26 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
658170 | 658170 | 2020-07-26 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
658171 | 658171 | 2020-07-26 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 0 | 0 | 0 | 0 | 35 | ||||
658172 | 658172 | 2020-07-26 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 36 | 34 | 0 | 15 | 37 | ||||
658173 | 658173 | 2020-07-26 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 37 | 53 | 1 | 21 | 37 | <11 | |||
658176 | 658176 | 2020-07-26 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 39 | 107 | 0 | 24 | 37 | ||||
658177 | 658177 | 2020-07-26 | 970000003 | 970000003-alexandria-care-center | ALEXANDRIA CARE CENTER | Los Angeles | 37 | 49 | 0 | 24 | 37 | ||||
658178 | 658178 | 2020-07-26 | 950000101 | 950000101-alhambra-healthcare-wellness-centre-lp | ALHAMBRA HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 13 | 1 | 0 | 1 | 37 | <11 | <11 | ||
658181 | 658181 | 2020-07-26 | 970000129 | 970000129-alvarado-care-center | ALVARADO CARE CENTER | Los Angeles | 14 | 33 | 1 | 1 | 37 | <11 | <11 | ||
658183 | 658183 | 2020-07-26 | 920000280 | 920000280-antelope-valley-care-center | ANTELOPE VALLEY CARE CENTER | Los Angeles | 16 | 1 | 0 | 0 | 37 | <11 | |||
658184 | 658184 | 2020-07-26 | 970000091 | 970000091-ararat-convalescent-hospital | ARARAT CONVALESCENT HOSPITAL | Los Angeles | 16 | 1 | 0 | 1 | 37 | <11 | <11 | ||
658185 | 658185 | 2020-07-26 | 920000292 | 920000292-ararat-nursing-facility | ARARAT NURSING FACILITY | Los Angeles | 15 | 20 | 0 | 0 | 37 | ||||
658186 | 658186 | 2020-07-26 | 950000012 | 950000012-arbor-glen-care-center | ARBOR GLEN CARE CENTER | Los Angeles | 21 | 56 | 0 | 1 | 37 | <11 | |||
658188 | 658188 | 2020-07-26 | 940000093 | 940000093-artesia-christian-home-inc | ARTESIA CHRISTIAN HOME INC. | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
658189 | 658189 | 2020-07-26 | 920000002 | 920000002-astoria-nursing-and-rehab-center | ASTORIA NURSING AND REHAB CENTER | Los Angeles | 61 | 80 | 0 | 17 | 37 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "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 );