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-05-17 sorted by slug 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
743822 | 743822 | 2020-05-17 | 970000194 | 970000194-brighton-care-center | BRIGHTON CARE CENTER | Los Angeles | 53 | 77 | 0 | 16 | 37 | ||||
744037 | 744037 | 2020-05-17 | 970000188 | 970000188-pasadena-care-center-llc | PASADENA CARE CENTER, LLC | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743968 | 743968 | 2020-05-17 | 970000186 | 970000186-legacy-healthcare-center | LEGACY HEALTHCARE CENTER | Los Angeles | 1 | 11 | 0 | 0 | 37 | <11 | |||
744039 | 744039 | 2020-05-17 | 970000184 | 970000184-pasadena-park-healthcare-and-wellness-center | PASADENA PARK HEALTHCARE AND WELLNESS CENTER | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | <11 | |
744007 | 744007 | 2020-05-17 | 970000182 | 970000182-monterey-park-convalescent-hospital | MONTEREY PARK CONVALESCENT HOSPITAL | Los Angeles | 0 | 1 | 0 | 0 | 37 | <11 | |||
744002 | 744002 | 2020-05-17 | 970000180 | 970000180-monte-vista-grove-homes | MONTE VISTA GROVE HOMES | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744139 | 744139 | 2020-05-17 | 970000178 | 970000178-villa-gardens-health-care-unit | VILLA GARDENS HEALTH CARE UNIT | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744123 | 744123 | 2020-05-17 | 970000176 | 970000176-two-palms-nursing-center-inc | TWO PALMS NURSING CENTER, INC. | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743897 | 743897 | 2020-05-17 | 970000174 | 970000174-foothill-heights-care-center | FOOTHILL HEIGHTS CARE CENTER | Los Angeles | 1 | 19 | 0 | 1 | 37 | <11 | <11 | ||
743930 | 743930 | 2020-05-17 | 970000169 | 970000169-heritage-manor | HERITAGE MANOR | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744067 | 744067 | 2020-05-17 | 970000167 | 970000167-saint-vincent-healthcare | SAINT VINCENT HEALTHCARE | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
744057 | 744057 | 2020-05-17 | 970000165 | 970000165-rose-garden-healthcare-center | ROSE GARDEN HEALTHCARE CENTER | Los Angeles | 32 | 26 | 0 | 1 | 37 | <11 | |||
743834 | 743834 | 2020-05-17 | 970000163 | 970000163-camellia-gardens-care-center | CAMELLIA GARDENS CARE CENTER | Los Angeles | 1 | 1 | 1 | 1 | 37 | <11 | <11 | <11 | <11 |
744038 | 744038 | 2020-05-17 | 970000161 | 970000161-pasadena-grove-health-center | PASADENA GROVE HEALTH CENTER | Los Angeles | 24 | 41 | 0 | 1 | 37 | <11 | |||
743935 | 743935 | 2020-05-17 | 970000156 | 970000156-hollenbeck-palms | HOLLENBECK PALMS | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744105 | 744105 | 2020-05-17 | 970000149 | 970000149-temple-park-convalescent-hospital | TEMPLE PARK CONVALESCENT HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744152 | 744152 | 2020-05-17 | 970000147 | 970000147-westlake-convalescent-hospital | WESTLAKE CONVALESCENT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744023 | 744023 | 2020-05-17 | 970000145 | 970000145-olympia-convalescent-hospital | OLYMPIA CONVALESCENT HOSPITAL | Los Angeles | 18 | 61 | 0 | 14 | 37 | ||||
743996 | 743996 | 2020-05-17 | 970000143 | 970000143-mid-wilshire-health-care-center | MID-WILSHIRE HEALTH CARE CENTER | Los Angeles | 11 | 39 | 0 | 11 | 37 | ||||
743986 | 743986 | 2020-05-17 | 970000141 | 970000141-maple-healthcare-center | MAPLE HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743962 | 743962 | 2020-05-17 | 970000139 | 970000139-lakeview-terrace | LAKEVIEW TERRACE | Los Angeles | 1 | 25 | 0 | 1 | 37 | <11 | <11 | ||
743866 | 743866 | 2020-05-17 | 970000137 | 970000137-country-villa-rehabilitation-center | COUNTRY VILLA REHABILITATION CENTER | Los Angeles | 1 | 16 | 0 | 1 | 37 | <11 | <11 | ||
744124 | 744124 | 2020-05-17 | 970000135 | 970000135-university-park-healthcare-center | UNIVERSITY PARK HEALTHCARE CENTER | Los Angeles | 0 | 1 | 0 | 0 | 37 | <11 | |||
743920 | 743920 | 2020-05-17 | 970000133 | 970000133-grand-park-convalescent-hospital | GRAND PARK CONVALESCENT HOSPITAL | Los Angeles | 31 | 61 | 0 | 24 | 37 | ||||
743832 | 743832 | 2020-05-17 | 970000131 | 970000131-california-post-acute | CALIFORNIA POST ACUTE | Los Angeles | 1 | 14 | 0 | 1 | 37 | <11 | <11 | ||
743791 | 743791 | 2020-05-17 | 970000129 | 970000129-alvarado-care-center | ALVARADO CARE CENTER | Los Angeles | 0 | 1 | 0 | 1 | 37 | <11 | <11 | ||
743830 | 743830 | 2020-05-17 | 970000127 | 970000127-burlington-convalescent-hospital | BURLINGTON CONVALESCENT HOSPITAL | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
743818 | 743818 | 2020-05-17 | 970000125 | 970000125-bonnie-brae-skilled-nursing | BONNIE BRAE SKILLED NURSING | Los Angeles | 15 | 17 | 0 | 1 | 37 | <11 | |||
743792 | 743792 | 2020-05-17 | 970000123 | 970000123-angels-nursing-health-center | ANGELS NURSING HEALTH CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743786 | 743786 | 2020-05-17 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 36 | 89 | 0 | 21 | 37 | ||||
743933 | 743933 | 2020-05-17 | 970000117 | 970000117-highland-park-skilled-nursing-wellness-centre | HIGHLAND PARK SKILLED NURSING & WELLNESS CENTRE | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
743939 | 743939 | 2020-05-17 | 970000115 | 970000115-huntington-healthcare-center | HUNTINGTON HEALTHCARE CENTER | Los Angeles | 18 | 22 | 0 | 14 | 37 | ||||
743953 | 743953 | 2020-05-17 | 970000111 | 970000111-kei-ai-los-angeles-healthcare-center | KEI-AI LOS ANGELES HEALTHCARE CENTER | Los Angeles | 25 | 62 | 0 | 17 | 37 | ||||
744005 | 744005 | 2020-05-17 | 970000109 | 970000109-montecito-heights-healthcare-wellness-centre-lp | MONTECITO HEIGHTS HEALTHCARE & WELLNESS CENTRE, LP. | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
744168 | 744168 | 2020-05-17 | 970000107 | 970000107-york-healthcare-wellness-centre | YORK HEALTHCARE & WELLNESS CENTRE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744163 | 744163 | 2020-05-17 | 970000105 | 970000105-windsor-manor | WINDSOR MANOR | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744142 | 744142 | 2020-05-17 | 970000103 | 970000103-virgil-rehabilitation-and-skilled-nursing-center | VIRGIL REHABILITATION AND SKILLED NURSING CENTER | Los Angeles | 19 | 21 | 0 | 13 | 37 | ||||
744089 | 744089 | 2020-05-17 | 970000099 | 970000099-solheim-senior-community | SOLHEIM SENIOR COMMUNITY | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744087 | 744087 | 2020-05-17 | 970000097 | 970000097-skyline-healthcare-center-los-angeles | SKYLINE HEALTHCARE CENTER-LOS ANGELES | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
743794 | 743794 | 2020-05-17 | 970000091 | 970000091-ararat-convalescent-hospital | ARARAT CONVALESCENT HOSPITAL | Los Angeles | 16 | 1 | 0 | 1 | 37 | <11 | <11 | ||
743852 | 743852 | 2020-05-17 | 970000089 | 970000089-college-vista-post-acute | COLLEGE VISTA POST-ACUTE | Los Angeles | 1 | 0 | 0 | 1 | 37 | <11 | <11 | ||
743906 | 743906 | 2020-05-17 | 970000085 | 970000085-glendale-healthcare-center | GLENDALE HEALTHCARE CENTER | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | <11 | |
743862 | 743862 | 2020-05-17 | 970000083 | 970000083-country-villa-los-feliz-nursing-center | COUNTRY VILLA LOS FELIZ NURSING CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743969 | 743969 | 2020-05-17 | 970000081 | 970000081-leisure-glen-post-acute-care-center | LEISURE GLEN POST ACUTE CARE CENTER | Los Angeles | 19 | 20 | 0 | 1 | 37 | <11 | |||
744090 | 744090 | 2020-05-17 | 970000077 | 970000077-south-pasadena-care-center | SOUTH PASADENA CARE CENTER | Los Angeles | 29 | 79 | 0 | 14 | 37 | ||||
743941 | 743941 | 2020-05-17 | 970000075 | 970000075-huntington-post-acute | HUNTINGTON POST ACUTE | Los Angeles | 20 | 60 | 0 | 1 | 37 | <11 | |||
743946 | 743946 | 2020-05-17 | 970000070 | 970000070-infinity-care-of-east-los-angeles | INFINITY CARE OF EAST LOS ANGELES | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743903 | 743903 | 2020-05-17 | 970000068 | 970000068-gem-transitional-care-center | GEM TRANSITIONAL CARE CENTER | Los Angeles | 15 | 46 | 0 | 1 | 37 | <11 | |||
744106 | 744106 | 2020-05-17 | 970000066 | 970000066-the-californian-pasadena-convalescent-hospital | THE CALIFORNIAN - PASADENA CONVALESCENT HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743985 | 743985 | 2020-05-17 | 970000064 | 970000064-manchester-manor-cvlt-hospital | MANCHESTER MANOR CVLT HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743900 | 743900 | 2020-05-17 | 970000062 | 970000062-garden-crest-rehabilitation-center | GARDEN CREST REHABILITATION CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744030 | 744030 | 2020-05-17 | 970000058 | 970000058-palazzo-post-acute | PALAZZO POST ACUTE | Los Angeles | 12 | 20 | 1 | 0 | 37 | <11 | |||
744151 | 744151 | 2020-05-17 | 970000054 | 970000054-western-convalescent-hospital | WESTERN CONVALESCENT HOSPITAL | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
744093 | 744093 | 2020-05-17 | 970000052 | 970000052-st-andrews-healthcare | ST. ANDREWS HEALTHCARE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744131 | 744131 | 2020-05-17 | 970000050 | 970000050-vernon-healthcare-center | VERNON HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744100 | 744100 | 2020-05-17 | 970000046 | 970000046-sunray-healthcare-center | SUNRAY HEALTHCARE CENTER | Los Angeles | 14 | 31 | 0 | 13 | 37 | ||||
744094 | 744094 | 2020-05-17 | 970000043 | 970000043-st-john-of-god-retirement-and-care-center | ST. JOHN OF GOD RETIREMENT AND CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743936 | 743936 | 2020-05-17 | 970000039 | 970000039-hollywood-premier-healthcare-center | HOLLYWOOD PREMIER HEALTHCARE CENTER | Los Angeles | 0 | 12 | 0 | 0 | 37 | ||||
743896 | 743896 | 2020-05-17 | 970000037 | 970000037-flower-villa-inc | FLOWER VILLA, INC. | Los Angeles | 14 | 17 | 1 | 1 | 37 | <11 | <11 | ||
743861 | 743861 | 2020-05-17 | 970000035 | 970000035-country-villa-east-nursing-center | COUNTRY VILLA EAST NURSING CENTER | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
743956 | 743956 | 2020-05-17 | 970000029 | 970000029-kingsley-manor-care-center | KINGSLEY MANOR CARE CENTER | Los Angeles | 20 | 19 | 0 | 1 | 37 | <11 | |||
743957 | 743957 | 2020-05-17 | 970000021 | 970000021-la-brea-rehabilitation-center | LA BREA REHABILITATION CENTER | Los Angeles | 13 | 1 | 0 | 1 | 37 | <11 | <11 | ||
744099 | 744099 | 2020-05-17 | 970000017 | 970000017-sunnyview-care-center | SUNNYVIEW CARE CENTER | Los Angeles | 0 | 1 | 0 | 1 | 37 | <11 | <11 | ||
743898 | 743898 | 2020-05-17 | 970000015 | 970000015-fountain-view-subacute-and-nursing-center | FOUNTAIN VIEW SUBACUTE AND NURSING CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744135 | 744135 | 2020-05-17 | 970000009 | 970000009-view-park-convalescent-center | VIEW PARK CONVALESCENT CENTER | Los Angeles | 13 | 22 | 0 | 1 | 37 | <11 | |||
743821 | 743821 | 2020-05-17 | 970000005 | 970000005-brier-oak-on-sunset | BRIER OAK ON SUNSET | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743787 | 743787 | 2020-05-17 | 970000003 | 970000003-alexandria-care-center | ALEXANDRIA CARE CENTER | Los Angeles | 24 | 39 | 0 | 17 | 37 | ||||
743785 | 743785 | 2020-05-17 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743888 | 743888 | 2020-05-17 | 960001457 | 960001457-el-encanto-healthcare-and-habilitation-center | EL ENCANTO HEALTHCARE AND HABILITATION CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744078 | 744078 | 2020-05-17 | 950000279 | 950000279-santa-teresita-manor | SANTA TERESITA MANOR | Los Angeles | 12 | 16 | 0 | 1 | 37 | <11 | |||
744080 | 744080 | 2020-05-17 | 950000277 | 950000277-serento-casa | SERENTO CASA | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744062 | 744062 | 2020-05-17 | 950000260 | 950000260-royal-oaks-manor-bradbury-oaks | ROYAL OAKS MANOR - BRADBURY OAKS | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743909 | 743909 | 2020-05-17 | 950000256 | 950000256-glendora-canyon-transitional-care-unit | GLENDORA CANYON TRANSITIONAL CARE UNIT | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743990 | 743990 | 2020-05-17 | 950000249 | 950000249-mayflower-care-center | MAYFLOWER CARE CENTER | Los Angeles | 0 | 1 | 0 | 0 | 37 | <11 | |||
743891 | 743891 | 2020-05-17 | 950000236 | 950000236-emanate-health-hospice | EMANATE HEALTH HOSPICE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744104 | 744104 | 2020-05-17 | 950000107 | 950000107-temple-city-healthcare | TEMPLE CITY HEALTHCARE | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
744101 | 744101 | 2020-05-17 | 950000105 | 950000105-sunset-manor-convalescent-hospital | SUNSET MANOR CONVALESCENT HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744061 | 744061 | 2020-05-17 | 950000104 | 950000104-royal-gardens-healthcare | ROYAL GARDENS HEALTHCARE | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
743885 | 743885 | 2020-05-17 | 950000103 | 950000103-eastland-subacute-and-rehabilitation-center | EASTLAND SUBACUTE AND REHABILITATION CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743788 | 743788 | 2020-05-17 | 950000101 | 950000101-alhambra-healthcare-wellness-centre-lp | ALHAMBRA HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
743951 | 743951 | 2020-05-17 | 950000100 | 950000100-ivy-creek-healthcare-wellness-centre | IVY CREEK HEALTHCARE & WELLNESS CENTRE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744167 | 744167 | 2020-05-17 | 950000092 | 950000092-woods-health-services | WOODS HEALTH SERVICES | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743846 | 743846 | 2020-05-17 | 950000088 | 950000088-clara-baldwin-stocker-home | CLARA BALDWIN STOCKER HOME | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
744071 | 744071 | 2020-05-17 | 950000085 | 950000085-santa-anita-convalescent-hospital | SANTA ANITA CONVALESCENT HOSPITAL | Los Angeles | 20 | 48 | 0 | 14 | 37 | ||||
744042 | 744042 | 2020-05-17 | 950000084 | 950000084-pilgrim-place-health-services-center | PILGRIM PLACE HEALTH SERVICES CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744040 | 744040 | 2020-05-17 | 950000083 | 950000083-penn-mar-therapeutic-center | PENN MAR THERAPEUTIC CENTER | Los Angeles | 1 | 15 | 0 | 0 | 37 | <11 | |||
744034 | 744034 | 2020-05-17 | 950000081 | 950000081-park-avenue-healthcare-wellness-center | PARK AVENUE HEALTHCARE & WELLNESS CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743948 | 743948 | 2020-05-17 | 950000079 | 950000079-inland-valley-care-and-rehabilitation-center | INLAND VALLEY CARE AND REHABILITATION CENTER | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
744011 | 744011 | 2020-05-17 | 950000078 | 950000078-mount-san-antonio-gardens | MOUNT SAN ANTONIO GARDENS | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
744133 | 744133 | 2020-05-17 | 950000077 | 950000077-victoria-care-center | VICTORIA CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744006 | 744006 | 2020-05-17 | 950000076 | 950000076-monterey-healthcare-wellness-centre-lp | MONTEREY HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744001 | 744001 | 2020-05-17 | 950000073 | 950000073-monrovia-post-acute | MONROVIA POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
743966 | 743966 | 2020-05-17 | 950000068 | 950000068-laurel-park-behavioral-health-center | LAUREL PARK BEHAVIORAL HEALTH CENTER | Los Angeles | 0 | 1 | 0 | 0 | 37 | <11 | |||
743964 | 743964 | 2020-05-17 | 950000066 | 950000066-landmark-medical-center | LANDMARK MEDICAL CENTER | Los Angeles | 11 | 1 | 0 | 0 | 37 | <11 | |||
744111 | 744111 | 2020-05-17 | 950000063 | 950000063-the-gardens-of-el-monte | THE GARDENS OF EL MONTE | Los Angeles | 1 | 14 | 0 | 1 | 37 | <11 | <11 | ||
743938 | 743938 | 2020-05-17 | 950000062 | 950000062-huntington-drive-health-and-rehabilitation-center | HUNTINGTON DRIVE HEALTH AND REHABILITATION CENTER | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
744097 | 744097 | 2020-05-17 | 950000061 | 950000061-sunny-village-care-center | SUNNY VILLAGE CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
744064 | 744064 | 2020-05-17 | 950000060 | 950000060-royal-terrace-health-care | ROYAL TERRACE HEALTH CARE | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
743923 | 743923 | 2020-05-17 | 950000058 | 950000058-green-acres-healthcare-center | GREEN ACRES HEALTHCARE CENTER | Los Angeles | 13 | 1 | 0 | 0 | 37 | <11 | |||
744043 | 744043 | 2020-05-17 | 950000057 | 950000057-pine-grove-healthcare-wellness-centre-lp | PINE GROVE HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 0 | 0 | 0 | 0 | 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 );