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,224 rows where "date" is on date 2020-04-27 sorted by staff_confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
768184 | 768184 | 2020-04-27 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
768185 | 768185 | 2020-04-27 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
768186 | 768186 | 2020-04-27 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
768187 | 768187 | 2020-04-27 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
768188 | 768188 | 2020-04-27 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768189 | 768189 | 2020-04-27 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768190 | 768190 | 2020-04-27 | 630013160 | 630013160-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP/SNF | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768191 | 768191 | 2020-04-27 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768192 | 768192 | 2020-04-27 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768193 | 768193 | 2020-04-27 | 40000043 | 040000043-dycora-transitional-health-community-care | DYCORA TRANSITIONAL HEALTH - COMMUNITY CARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768194 | 768194 | 2020-04-27 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768195 | 768195 | 2020-04-27 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 0 | 1 | 0 | 0 | 19 | <11 | |||
768197 | 768197 | 2020-04-27 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768198 | 768198 | 2020-04-27 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768200 | 768200 | 2020-04-27 | 40000012 | 040000012-evergreen-care-center | EVERGREEN CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768201 | 768201 | 2020-04-27 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768202 | 768202 | 2020-04-27 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768203 | 768203 | 2020-04-27 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768204 | 768204 | 2020-04-27 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768205 | 768205 | 2020-04-27 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768206 | 768206 | 2020-04-27 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768207 | 768207 | 2020-04-27 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768208 | 768208 | 2020-04-27 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768209 | 768209 | 2020-04-27 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768210 | 768210 | 2020-04-27 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768211 | 768211 | 2020-04-27 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768212 | 768212 | 2020-04-27 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768213 | 768213 | 2020-04-27 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768214 | 768214 | 2020-04-27 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768216 | 768216 | 2020-04-27 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768217 | 768217 | 2020-04-27 | 40000069 | 040000069-valley-healthcare-center | VALLEY HEALTHCARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768218 | 768218 | 2020-04-27 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768219 | 768219 | 2020-04-27 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
768220 | 768220 | 2020-04-27 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 0 | 0 | 0 | 0 | 21 | ||||
768221 | 768221 | 2020-04-27 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
768222 | 768222 | 2020-04-27 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
768223 | 768223 | 2020-04-27 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
768224 | 768224 | 2020-04-27 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
768225 | 768225 | 2020-04-27 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
768226 | 768226 | 2020-04-27 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
768227 | 768227 | 2020-04-27 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 0 | 0 | 0 | 0 | 25 | ||||
768230 | 768230 | 2020-04-27 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
768231 | 768231 | 2020-04-27 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
768232 | 768232 | 2020-04-27 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768234 | 768234 | 2020-04-27 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768235 | 768235 | 2020-04-27 | 120000399 | 120000399-delano-regional-medical-center-d-p-snf | DELANO REGIONAL MEDICAL CENTER D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768237 | 768237 | 2020-04-27 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768238 | 768238 | 2020-04-27 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768239 | 768239 | 2020-04-27 | 120000695 | 120000695-kern-valley-healthcare-district-d-p-snf | KERN VALLEY HEALTHCARE DISTRICT D/P SNF | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768241 | 768241 | 2020-04-27 | 120000365 | 120000365-parkview-julian-convalescent | PARKVIEW JULIAN CONVALESCENT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768242 | 768242 | 2020-04-27 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768243 | 768243 | 2020-04-27 | 120000369 | 120000369-rosewood-health-facility | ROSEWOOD HEALTH FACILITY | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768246 | 768246 | 2020-04-27 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768247 | 768247 | 2020-04-27 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768248 | 768248 | 2020-04-27 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768249 | 768249 | 2020-04-27 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768250 | 768250 | 2020-04-27 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 0 | 0 | 0 | 0 | 29 | ||||
768251 | 768251 | 2020-04-27 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 0 | 0 | 0 | 0 | 31 | ||||
768252 | 768252 | 2020-04-27 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 0 | 0 | 0 | 0 | 31 | ||||
768253 | 768253 | 2020-04-27 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 0 | 0 | 0 | 0 | 31 | ||||
768254 | 768254 | 2020-04-27 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 0 | 0 | 0 | 0 | 33 | ||||
768255 | 768255 | 2020-04-27 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
768256 | 768256 | 2020-04-27 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
768257 | 768257 | 2020-04-27 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 0 | 0 | 0 | 0 | 35 | ||||
768266 | 768266 | 2020-04-27 | 920000001 | 920000001-all-saints-healthcare | ALL SAINTS HEALTHCARE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768267 | 768267 | 2020-04-27 | 970000123 | 970000123-angels-nursing-health-center | ANGELS NURSING HEALTH CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768271 | 768271 | 2020-04-27 | 950000012 | 950000012-arbor-glen-care-center | ARBOR GLEN CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768272 | 768272 | 2020-04-27 | 950000045 | 950000045-arcadia-care-center | ARCADIA CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768273 | 768273 | 2020-04-27 | 940000093 | 940000093-artesia-christian-home-inc | ARTESIA CHRISTIAN HOME INC. | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768275 | 768275 | 2020-04-27 | 950000039 | 950000039-atherton-baptist-home-sam-b-west | ATHERTON BAPTIST HOME-SAM B. WEST | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768276 | 768276 | 2020-04-27 | 940000007 | 940000007-atlantic-memorial-healthcare-center | ATLANTIC MEMORIAL HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768278 | 768278 | 2020-04-27 | 940000051 | 940000051-avalon-villa-care-center | AVALON VILLA CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768281 | 768281 | 2020-04-27 | 940000097 | 940000097-beachside-post-acute | BEACHSIDE POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768287 | 768287 | 2020-04-27 | 940000013 | 940000013-bellflower-post-acute | BELLFLOWER POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768288 | 768288 | 2020-04-27 | 910000014 | 910000014-berkley-east-convalescent-hospital | BERKLEY EAST CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768290 | 768290 | 2020-04-27 | 910000013 | 910000013-berkley-west-convalescent-hospital | BERKLEY WEST CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768291 | 768291 | 2020-04-27 | 910000322 | 910000322-beverly-west-healthcare | BEVERLY WEST HEALTHCARE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768295 | 768295 | 2020-04-27 | 940000012 | 940000012-briarcrest-nursing-center | BRIARCREST NURSING CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768299 | 768299 | 2020-04-27 | 950000030 | 950000030-broadway-healthcare-center | BROADWAY HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768300 | 768300 | 2020-04-27 | 920000021 | 920000021-broadway-manor-care-center | BROADWAY MANOR CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768301 | 768301 | 2020-04-27 | 920000310 | 920000310-brookdale-northridge | BROOKDALE NORTHRIDGE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768302 | 768302 | 2020-04-27 | 950000277 | 950000277-brookdale-san-dimas | BROOKDALE SAN DIMAS | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768312 | 768312 | 2020-04-27 | 950000052 | 950000052-casa-bonita-convalescent-hospital | CASA BONITA CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768313 | 768313 | 2020-04-27 | 920000090 | 920000090-casitas-care-center | CASITAS CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768314 | 768314 | 2020-04-27 | 930000669 | 930000669-catalina-island-medical-center-d-p-snf | CATALINA ISLAND MEDICAL CENTER D/P SNF | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768315 | 768315 | 2020-04-27 | 940000031 | 940000031-catered-manor-nursing-center | CATERED MANOR NURSING CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768318 | 768318 | 2020-04-27 | 920000014 | 920000014-chandler-convalescent-hospital | CHANDLER CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768320 | 768320 | 2020-04-27 | 950000033 | 950000033-chino-valley-health-care-center | CHINO VALLEY HEALTH CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768321 | 768321 | 2020-04-27 | 950000088 | 950000088-clara-baldwin-stocker-home | CLARA BALDWIN STOCKER HOME | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768322 | 768322 | 2020-04-27 | 950000002 | 950000002-claremont-care-center | CLAREMONT CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768323 | 768323 | 2020-04-27 | 950000053 | 950000053-claremont-manor-care-center | CLAREMONT MANOR CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768324 | 768324 | 2020-04-27 | 910000024 | 910000024-clear-view-convalescent-center | CLEAR VIEW CONVALESCENT CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768330 | 768330 | 2020-04-27 | 950000022 | 950000022-community-care-center | COMMUNITY CARE CENTER | Los Angeles | 0 | 1 | 0 | 0 | 37 | <11 | |||
768332 | 768332 | 2020-04-27 | 950000040 | 950000040-country-oaks-care-center | COUNTRY OAKS CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768335 | 768335 | 2020-04-27 | 950000042 | 950000042-country-villa-claremont-healthcare-center | COUNTRY VILLA CLAREMONT HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768349 | 768349 | 2020-04-27 | 910000314 | 910000314-crenshaw-nursing-home | CRENSHAW NURSING HOME | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768351 | 768351 | 2020-04-27 | 910000033 | 910000033-del-amo-gardens-care-center | DEL AMO GARDENS CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768352 | 768352 | 2020-04-27 | 950000056 | 950000056-del-mar-convalescent-hospital | DEL MAR CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768353 | 768353 | 2020-04-27 | 170001860 | 170001860-department-of-state-hospitals-metropolitan | DEPARTMENT OF STATE HOSPITALS - METROPOLITAN | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
768354 | 768354 | 2020-04-27 | 920000051 | 920000051-desert-canyon-post-acute-llc | DESERT CANYON POST ACUTE, LLC | Los Angeles | 0 | 0 | 0 | 0 | 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 );