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-10-15 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
558915 | 558915 | 2020-10-15 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 12 | 17 | 0 | 1 | 1 | <11 | |||
558920 | 558920 | 2020-10-15 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558927 | 558927 | 2020-10-15 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558929 | 558929 | 2020-10-15 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558932 | 558932 | 2020-10-15 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 21 | 53 | 1 | 1 | 1 | <11 | <11 | ||
558935 | 558935 | 2020-10-15 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 18 | 32 | 0 | 1 | 1 | <11 | |||
558936 | 558936 | 2020-10-15 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 30 | 33 | 0 | 1 | 1 | <11 | |||
558938 | 558938 | 2020-10-15 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 23 | 44 | 0 | 1 | 1 | <11 | |||
558940 | 558940 | 2020-10-15 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 15 | 11 | 0 | 0 | 1 | ||||
558941 | 558941 | 2020-10-15 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 46 | 45 | 0 | 1 | 1 | <11 | |||
558942 | 558942 | 2020-10-15 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558945 | 558945 | 2020-10-15 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558946 | 558946 | 2020-10-15 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 19 | 18 | 0 | 1 | 1 | <11 | |||
558952 | 558952 | 2020-10-15 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558953 | 558953 | 2020-10-15 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 31 | 50 | 0 | 0 | 1 | ||||
558954 | 558954 | 2020-10-15 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 20 | 20 | 0 | 12 | 1 | ||||
558955 | 558955 | 2020-10-15 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 23 | 35 | 0 | 1 | 1 | <11 | |||
558961 | 558961 | 2020-10-15 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 20 | 101 | 1 | 12 | 1 | <11 | |||
558963 | 558963 | 2020-10-15 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 42 | 49 | 1 | 12 | 1 | <11 | |||
558964 | 558964 | 2020-10-15 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 16 | 25 | 0 | 1 | 1 | <11 | |||
558966 | 558966 | 2020-10-15 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 17 | 29 | 0 | 1 | 1 | <11 | |||
558968 | 558968 | 2020-10-15 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 12 | 24 | 0 | 1 | 1 | <11 | |||
558970 | 558970 | 2020-10-15 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558971 | 558971 | 2020-10-15 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558972 | 558972 | 2020-10-15 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558973 | 558973 | 2020-10-15 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 31 | 49 | 0 | 19 | 1 | ||||
558977 | 558977 | 2020-10-15 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
558979 | 558979 | 2020-10-15 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 27 | 48 | 0 | 1 | 1 | <11 | |||
558982 | 558982 | 2020-10-15 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 21 | 22 | 0 | 0 | 1 | ||||
558984 | 558984 | 2020-10-15 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 34 | 59 | 0 | 1 | 1 | <11 | |||
558985 | 558985 | 2020-10-15 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 18 | 36 | 0 | 1 | 1 | <11 | |||
558986 | 558986 | 2020-10-15 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 34 | 30 | 0 | 1 | 1 | <11 | |||
558987 | 558987 | 2020-10-15 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 22 | 51 | 0 | 16 | 5 | ||||
558988 | 558988 | 2020-10-15 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 29 | 36 | 0 | 1 | 7 | <11 | |||
558989 | 558989 | 2020-10-15 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 15 | 1 | 0 | 1 | 7 | <11 | <11 | ||
558993 | 558993 | 2020-10-15 | 230000036 | 230000036-riverside-convalescent-hospital | RIVERSIDE CONVALESCENT HOSPITAL | Butte | 27 | 48 | 0 | 1 | 7 | <11 | |||
558996 | 558996 | 2020-10-15 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 29 | 42 | 0 | 1 | 7 | <11 | |||
558997 | 558997 | 2020-10-15 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 17 | 50 | 0 | 1 | 9 | <11 | |||
558999 | 558999 | 2020-10-15 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 41 | 29 | 0 | 1 | 11 | <11 | |||
559001 | 559001 | 2020-10-15 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 29 | 56 | 0 | 1 | 13 | <11 | |||
559005 | 559005 | 2020-10-15 | 140000564 | 140000564-diamond-ridge-healthcare-center | DIAMOND RIDGE HEALTHCARE CENTER | Contra Costa | 16 | 22 | 0 | 1 | 13 | <11 | |||
559008 | 559008 | 2020-10-15 | 140000102 | 140000102-legacy-post-acute-care | LEGACY POST ACUTE CARE | Contra Costa | 12 | 13 | 0 | 1 | 13 | <11 | |||
559011 | 559011 | 2020-10-15 | 140001126 | 140001126-manorcare-health-services-tice-valley | MANORCARE HEALTH SERVICES - TICE VALLEY | Contra Costa | 39 | 93 | 0 | 17 | 13 | ||||
559014 | 559014 | 2020-10-15 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 36 | 40 | 0 | 1 | 13 | <11 | |||
559016 | 559016 | 2020-10-15 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 0 | 1 | 0 | 0 | 13 | <11 | |||
559017 | 559017 | 2020-10-15 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
559019 | 559019 | 2020-10-15 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
559022 | 559022 | 2020-10-15 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 1 | 13 | <11 | |||
559035 | 559035 | 2020-10-15 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
559038 | 559038 | 2020-10-15 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 23 | 31 | 0 | 1 | 19 | <11 | |||
559039 | 559039 | 2020-10-15 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 19 | 15 | 0 | 1 | 19 | <11 | |||
559042 | 559042 | 2020-10-15 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 14 | 1 | 0 | 0 | 19 | <11 | |||
559045 | 559045 | 2020-10-15 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 39 | 118 | 1 | 33 | 19 | <11 | |||
559047 | 559047 | 2020-10-15 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 13 | 30 | 0 | 12 | 19 | ||||
559048 | 559048 | 2020-10-15 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 26 | 28 | 0 | 1 | 19 | <11 | |||
559049 | 559049 | 2020-10-15 | 40000077 | 040000077-dycora-transitional-health-sanger | DYCORA TRANSITIONAL HEALTH - SANGER | Fresno | 13 | 11 | 0 | 1 | 19 | <11 | |||
559054 | 559054 | 2020-10-15 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
559055 | 559055 | 2020-10-15 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 18 | 14 | 0 | 1 | 19 | <11 | |||
559056 | 559056 | 2020-10-15 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 25 | 28 | 0 | 1 | 19 | <11 | |||
559059 | 559059 | 2020-10-15 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
559060 | 559060 | 2020-10-15 | 40000069 | 040000069-orchard-post-acute | ORCHARD POST ACUTE | Fresno | 26 | 32 | 0 | 1 | 19 | <11 | |||
559061 | 559061 | 2020-10-15 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 35 | 38 | 0 | 1 | 19 | <11 | |||
559062 | 559062 | 2020-10-15 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 29 | 1 | 0 | 0 | 19 | <11 | |||
559064 | 559064 | 2020-10-15 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 25 | 16 | 0 | 1 | 19 | <11 | |||
559065 | 559065 | 2020-10-15 | 40000037 | 040000037-sierra-vista-healthcare | SIERRA VISTA HEALTHCARE | Fresno | 45 | 52 | 0 | 1 | 19 | <11 | |||
559068 | 559068 | 2020-10-15 | 40000064 | 040000064-twilight-haven | TWILIGHT HAVEN | Fresno | 29 | 34 | 0 | 1 | 19 | <11 | |||
559070 | 559070 | 2020-10-15 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 17 | 1 | 0 | 0 | 19 | <11 | |||
559072 | 559072 | 2020-10-15 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
559074 | 559074 | 2020-10-15 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
559075 | 559075 | 2020-10-15 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
559078 | 559078 | 2020-10-15 | 90000092 | 090000092-el-centro-post-acute-care | EL CENTRO POST-ACUTE CARE | Imperial | 40 | 48 | 0 | 17 | 25 | ||||
559079 | 559079 | 2020-10-15 | 90000015 | 090000015-imperial-heights-healthcare-wellness-centre-llc | IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC | Imperial | 37 | 27 | 1 | 1 | 25 | <11 | <11 | ||
559080 | 559080 | 2020-10-15 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 35 | 27 | 0 | 0 | 25 | ||||
559081 | 559081 | 2020-10-15 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 19 | 47 | 0 | 12 | 27 | ||||
559085 | 559085 | 2020-10-15 | 120001395 | 120001395-brookdale-riverwalk-snf-ca | BROOKDALE RIVERWALK SNF (CA) | Kern | 24 | 14 | 0 | 1 | 29 | <11 | |||
559086 | 559086 | 2020-10-15 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 20 | 1 | 0 | 0 | 29 | <11 | |||
559087 | 559087 | 2020-10-15 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 14 | 1 | 0 | 0 | 29 | <11 | |||
559088 | 559088 | 2020-10-15 | 630017642 | 630017642-kern-river-transitional-care | KERN RIVER TRANSITIONAL CARE | Kern | 21 | 17 | 0 | 0 | 29 | ||||
559090 | 559090 | 2020-10-15 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 71 | 104 | 0 | 19 | 29 | ||||
559091 | 559091 | 2020-10-15 | 120000365 | 120000365-parkview-julian-healthcare-center | PARKVIEW JULIAN HEALTHCARE CENTER | Kern | 21 | 1 | 0 | 1 | 29 | <11 | <11 | ||
559094 | 559094 | 2020-10-15 | 120000322 | 120000322-san-joaquin-nursing-center | SAN JOAQUIN NURSING CENTER | Kern | 21 | 1 | 0 | 0 | 29 | <11 | |||
559095 | 559095 | 2020-10-15 | 120000375 | 120000375-shafter-nursing-care | SHAFTER NURSING CARE | Kern | 51 | 74 | 0 | 1 | 29 | <11 | |||
559096 | 559096 | 2020-10-15 | 120000320 | 120000320-the-orchards-post-acute | THE ORCHARDS POST-ACUTE | Kern | 29 | 26 | 0 | 1 | 29 | <11 | |||
559097 | 559097 | 2020-10-15 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 82 | 94 | 0 | 1 | 29 | <11 | |||
559098 | 559098 | 2020-10-15 | 120000355 | 120000355-valley-convalescent-hospital | VALLEY CONVALESCENT HOSPITAL | Kern | 33 | 52 | 0 | 1 | 29 | <11 | |||
559100 | 559100 | 2020-10-15 | 120000373 | 120000373-windsor-post-acute-center-of-arvin | WINDSOR POST-ACUTE CENTER OF ARVIN | Kern | 29 | 58 | 0 | 1 | 29 | <11 | |||
559101 | 559101 | 2020-10-15 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 39 | 66 | 0 | 1 | 29 | <11 | |||
559102 | 559102 | 2020-10-15 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 77 | 90 | 0 | 23 | 31 | ||||
559105 | 559105 | 2020-10-15 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 22 | 37 | 0 | 1 | 33 | <11 | |||
559107 | 559107 | 2020-10-15 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 13 | 44 | 0 | 1 | 33 | <11 | |||
559109 | 559109 | 2020-10-15 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 43 | 36 | 0 | 15 | 37 | ||||
559110 | 559110 | 2020-10-15 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 40 | 58 | 1 | 21 | 37 | <11 | |||
559112 | 559112 | 2020-10-15 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 13 | 1 | 1 | 0 | 37 | <11 | <11 | ||
559113 | 559113 | 2020-10-15 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 41 | 107 | 0 | 26 | 37 | ||||
559114 | 559114 | 2020-10-15 | 970000003 | 970000003-alexandria-care-center | ALEXANDRIA CARE CENTER | Los Angeles | 38 | 51 | 0 | 24 | 37 | ||||
559115 | 559115 | 2020-10-15 | 950000101 | 950000101-alhambra-healthcare-wellness-centre-lp | ALHAMBRA HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 14 | 12 | 0 | 1 | 37 | <11 | |||
559118 | 559118 | 2020-10-15 | 970000129 | 970000129-alvarado-care-center | ALVARADO CARE CENTER | Los Angeles | 14 | 36 | 1 | 1 | 37 | <11 | <11 | ||
559120 | 559120 | 2020-10-15 | 920000280 | 920000280-antelope-valley-care-center | ANTELOPE VALLEY CARE CENTER | Los Angeles | 41 | 27 | 0 | 1 | 37 | <11 | |||
559121 | 559121 | 2020-10-15 | 970000091 | 970000091-ararat-convalescent-hospital | ARARAT CONVALESCENT HOSPITAL | Los Angeles | 19 | 1 | 0 | 1 | 37 | <11 | <11 | ||
559122 | 559122 | 2020-10-15 | 920000292 | 920000292-ararat-nursing-facility | ARARAT NURSING FACILITY | Los Angeles | 80 | 90 | 1 | 20 | 37 | <11 |
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 );