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-06-25 sorted by patients_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
695891 | 695891 | 2020-06-25 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695893 | 695893 | 2020-06-25 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695894 | 695894 | 2020-06-25 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695895 | 695895 | 2020-06-25 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695896 | 695896 | 2020-06-25 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695897 | 695897 | 2020-06-25 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695898 | 695898 | 2020-06-25 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695900 | 695900 | 2020-06-25 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695901 | 695901 | 2020-06-25 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695902 | 695902 | 2020-06-25 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695903 | 695903 | 2020-06-25 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695904 | 695904 | 2020-06-25 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695905 | 695905 | 2020-06-25 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695908 | 695908 | 2020-06-25 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695909 | 695909 | 2020-06-25 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695910 | 695910 | 2020-06-25 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695916 | 695916 | 2020-06-25 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695917 | 695917 | 2020-06-25 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695918 | 695918 | 2020-06-25 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695919 | 695919 | 2020-06-25 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 0 | 1 | 0 | 1 | <11 | <11 | ||
695920 | 695920 | 2020-06-25 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695921 | 695921 | 2020-06-25 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695923 | 695923 | 2020-06-25 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695924 | 695924 | 2020-06-25 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695925 | 695925 | 2020-06-25 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695926 | 695926 | 2020-06-25 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695927 | 695927 | 2020-06-25 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695928 | 695928 | 2020-06-25 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695929 | 695929 | 2020-06-25 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695931 | 695931 | 2020-06-25 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695933 | 695933 | 2020-06-25 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695934 | 695934 | 2020-06-25 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695935 | 695935 | 2020-06-25 | 630014635 | 630014635-park-bridge-rehabilitation-and-wellness-center | PARK BRIDGE REHABILITATION AND WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695936 | 695936 | 2020-06-25 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695938 | 695938 | 2020-06-25 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695939 | 695939 | 2020-06-25 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695940 | 695940 | 2020-06-25 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695944 | 695944 | 2020-06-25 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695945 | 695945 | 2020-06-25 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695946 | 695946 | 2020-06-25 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695947 | 695947 | 2020-06-25 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695948 | 695948 | 2020-06-25 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695950 | 695950 | 2020-06-25 | 630014957 | 630014957-stratford-villa-post-acute | STRATFORD VILLA POST-ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695952 | 695952 | 2020-06-25 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695953 | 695953 | 2020-06-25 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
695956 | 695956 | 2020-06-25 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695957 | 695957 | 2020-06-25 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695958 | 695958 | 2020-06-25 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695959 | 695959 | 2020-06-25 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695960 | 695960 | 2020-06-25 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
695963 | 695963 | 2020-06-25 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 0 | 0 | 0 | 0 | 5 | ||||
695964 | 695964 | 2020-06-25 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
695965 | 695965 | 2020-06-25 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 0 | 0 | 0 | 0 | 7 | ||||
695967 | 695967 | 2020-06-25 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
695968 | 695968 | 2020-06-25 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 1 | 0 | 0 | 0 | 7 | <11 | |||
695970 | 695970 | 2020-06-25 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
695971 | 695971 | 2020-06-25 | 230000025 | 230000025-windsor-chico-care-center | WINDSOR CHICO CARE CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
695972 | 695972 | 2020-06-25 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
695973 | 695973 | 2020-06-25 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 0 | 0 | 0 | 0 | 9 | ||||
695974 | 695974 | 2020-06-25 | 230000424 | 230000424-colusa-medical-center-snf | COLUSA MEDICAL CENTER - SNF | Colusa | 0 | 0 | 0 | 0 | 11 | ||||
695975 | 695975 | 2020-06-25 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 0 | 0 | 0 | 0 | 11 | ||||
695976 | 695976 | 2020-06-25 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695977 | 695977 | 2020-06-25 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
695978 | 695978 | 2020-06-25 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695979 | 695979 | 2020-06-25 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695980 | 695980 | 2020-06-25 | 140000003 | 140000003-delta-view-post-acute | DELTA VIEW POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695982 | 695982 | 2020-06-25 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695983 | 695983 | 2020-06-25 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695984 | 695984 | 2020-06-25 | 140000102 | 140000102-legacy-post-acute-care | LEGACY POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
695985 | 695985 | 2020-06-25 | 140000105 | 140000105-lone-tree-post-acute | LONE TREE POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695986 | 695986 | 2020-06-25 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695993 | 695993 | 2020-06-25 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695994 | 695994 | 2020-06-25 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695996 | 695996 | 2020-06-25 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695998 | 695998 | 2020-06-25 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
695999 | 695999 | 2020-06-25 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
696000 | 696000 | 2020-06-25 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
696002 | 696002 | 2020-06-25 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
696003 | 696003 | 2020-06-25 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
696004 | 696004 | 2020-06-25 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
696005 | 696005 | 2020-06-25 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
696006 | 696006 | 2020-06-25 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
696007 | 696007 | 2020-06-25 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
696008 | 696008 | 2020-06-25 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
696010 | 696010 | 2020-06-25 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
696011 | 696011 | 2020-06-25 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
696012 | 696012 | 2020-06-25 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
696013 | 696013 | 2020-06-25 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
696018 | 696018 | 2020-06-25 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
696019 | 696019 | 2020-06-25 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696020 | 696020 | 2020-06-25 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696023 | 696023 | 2020-06-25 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696024 | 696024 | 2020-06-25 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696025 | 696025 | 2020-06-25 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696027 | 696027 | 2020-06-25 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696028 | 696028 | 2020-06-25 | 40000043 | 040000043-fresno-nursing-center | FRESNO NURSING CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
696029 | 696029 | 2020-06-25 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
696030 | 696030 | 2020-06-25 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
696032 | 696032 | 2020-06-25 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 0 | 0 | 0 | 0 | 19 | ||||
696033 | 696033 | 2020-06-25 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 0 | 0 | 0 | 0 | 19 |
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 );