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 2021-05-01 sorted by patients_deaths_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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
316760 | 316760 | 2021-05-01 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 11 | 15 | 0 | 0 | 1 | ||||
316762 | 316762 | 2021-05-01 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316763 | 316763 | 2021-05-01 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316764 | 316764 | 2021-05-01 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316765 | 316765 | 2021-05-01 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316766 | 316766 | 2021-05-01 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316768 | 316768 | 2021-05-01 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316771 | 316771 | 2021-05-01 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 11 | 1 | 0 | 0 | 1 | <11 | |||
316772 | 316772 | 2021-05-01 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316773 | 316773 | 2021-05-01 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316776 | 316776 | 2021-05-01 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316779 | 316779 | 2021-05-01 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 19 | 25 | 0 | 0 | 1 | ||||
316780 | 316780 | 2021-05-01 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 20 | 1 | <11 | <11 | ||
316786 | 316786 | 2021-05-01 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 73 | 128 | 0 | 13 | 1 | ||||
316790 | 316790 | 2021-05-01 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 19 | 90 | 0 | 12 | 1 | ||||
316791 | 316791 | 2021-05-01 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 11 | 1 | 0 | 0 | 1 | <11 | |||
316793 | 316793 | 2021-05-01 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
316794 | 316794 | 2021-05-01 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
316795 | 316795 | 2021-05-01 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316796 | 316796 | 2021-05-01 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 1 | 14 | 0 | 0 | 1 | <11 | |||
316798 | 316798 | 2021-05-01 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316799 | 316799 | 2021-05-01 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 42 | 52 | 0 | 0 | 1 | ||||
316800 | 316800 | 2021-05-01 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 22 | 20 | 0 | 12 | 1 | ||||
316804 | 316804 | 2021-05-01 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316806 | 316806 | 2021-05-01 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316807 | 316807 | 2021-05-01 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 36 | 111 | 1 | 18 | 1 | <11 | |||
316808 | 316808 | 2021-05-01 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
316809 | 316809 | 2021-05-01 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 64 | 52 | 1 | 12 | 1 | <11 | |||
316815 | 316815 | 2021-05-01 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316817 | 316817 | 2021-05-01 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316818 | 316818 | 2021-05-01 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
316819 | 316819 | 2021-05-01 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 35 | 50 | 0 | 19 | 1 | ||||
316823 | 316823 | 2021-05-01 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
316827 | 316827 | 2021-05-01 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
316833 | 316833 | 2021-05-01 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 29 | 61 | 0 | 17 | 5 | ||||
316834 | 316834 | 2021-05-01 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 66 | 102 | 0 | 12 | 7 | ||||
316836 | 316836 | 2021-05-01 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 12 | 1 | 0 | 0 | 7 | <11 | |||
316837 | 316837 | 2021-05-01 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 37 | 48 | 0 | 13 | 7 | ||||
316839 | 316839 | 2021-05-01 | 230000036 | 230000036-riverside-convalescent-hospital | RIVERSIDE CONVALESCENT HOSPITAL | Butte | 71 | 87 | 0 | 13 | 7 | ||||
316848 | 316848 | 2021-05-01 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 18 | 1 | 0 | 0 | 13 | <11 | |||
316852 | 316852 | 2021-05-01 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
316853 | 316853 | 2021-05-01 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 1 | 30 | 0 | 0 | 13 | <11 | |||
316857 | 316857 | 2021-05-01 | 140001126 | 140001126-manorcare-health-services-tice-valley | MANORCARE HEALTH SERVICES - TICE VALLEY | Contra Costa | 49 | 116 | 0 | 21 | 13 | ||||
316859 | 316859 | 2021-05-01 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 17 | 38 | 0 | 0 | 13 | ||||
316862 | 316862 | 2021-05-01 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
316864 | 316864 | 2021-05-01 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
316865 | 316865 | 2021-05-01 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 51 | 104 | 1 | 36 | 13 | <11 | |||
316869 | 316869 | 2021-05-01 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
316870 | 316870 | 2021-05-01 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 19 | 1 | 0 | 0 | 13 | <11 | |||
316872 | 316872 | 2021-05-01 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 15 | 1 | 0 | 0 | 13 | <11 | |||
316873 | 316873 | 2021-05-01 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 29 | 37 | 0 | 11 | 13 | ||||
316876 | 316876 | 2021-05-01 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 63 | 144 | 1 | 15 | 13 | <11 | |||
316877 | 316877 | 2021-05-01 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 21 | 0 | 0 | 0 | 13 | ||||
316878 | 316878 | 2021-05-01 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 23 | 1 | 0 | 0 | 15 | <11 | |||
316879 | 316879 | 2021-05-01 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 23 | 1 | 0 | 0 | 17 | <11 | |||
316880 | 316880 | 2021-05-01 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 21 | 40 | 0 | 14 | 17 | ||||
316881 | 316881 | 2021-05-01 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
316882 | 316882 | 2021-05-01 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 91 | 64 | 0 | 18 | 17 | ||||
316886 | 316886 | 2021-05-01 | 40000798 | 040000798-coalinga-regional-medical-center-dp-snf | COALINGA REGIONAL MEDICAL CENTER DP SNF | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
316891 | 316891 | 2021-05-01 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 98 | 216 | 1 | 49 | 19 | <11 | |||
316892 | 316892 | 2021-05-01 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 32 | 64 | 0 | 14 | 19 | ||||
316893 | 316893 | 2021-05-01 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 20 | 33 | 0 | 12 | 19 | ||||
316902 | 316902 | 2021-05-01 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 50 | 46 | 0 | 11 | 19 | ||||
316905 | 316905 | 2021-05-01 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 71 | 81 | 0 | 18 | 19 | ||||
316907 | 316907 | 2021-05-01 | 40000063 | 040000063-pacific-gardens-nursing-and-rehabilitation-center | PACIFIC GARDENS NURSING AND REHABILITATION CENTER | Fresno | 149 | 177 | 0 | 23 | 19 | ||||
316908 | 316908 | 2021-05-01 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 72 | 1 | 0 | 0 | 19 | <11 | |||
316910 | 316910 | 2021-05-01 | 40000060 | 040000060-sierra-view-homes-inc | SIERRA VIEW HOMES INC. | Fresno | 29 | 27 | 0 | 17 | 19 | ||||
316913 | 316913 | 2021-05-01 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 18 | 1 | 0 | 0 | 19 | <11 | |||
316915 | 316915 | 2021-05-01 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 61 | 1 | 0 | 0 | 19 | <11 | |||
316916 | 316916 | 2021-05-01 | 40001040 | 040001040-willow-creek-healthcare-center | WILLOW CREEK HEALTHCARE CENTER | Fresno | 72 | 113 | 0 | 12 | 19 | ||||
316918 | 316918 | 2021-05-01 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
316921 | 316921 | 2021-05-01 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
316923 | 316923 | 2021-05-01 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
316924 | 316924 | 2021-05-01 | 90000092 | 090000092-el-centro-post-acute-care | EL CENTRO POST-ACUTE CARE | Imperial | 49 | 62 | 0 | 20 | 25 | ||||
316926 | 316926 | 2021-05-01 | 90000067 | 090000067-imperial-manor | IMPERIAL MANOR | Imperial | 38 | 27 | 0 | 0 | 25 | ||||
316927 | 316927 | 2021-05-01 | 240001854 | 240001854-bishop-care-center | BISHOP CARE CENTER | Inyo | 26 | 48 | 0 | 12 | 27 | ||||
316929 | 316929 | 2021-05-01 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 13 | 1 | 0 | 0 | 29 | <11 | |||
316930 | 316930 | 2021-05-01 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 33 | 0 | 0 | 0 | 29 | ||||
316932 | 316932 | 2021-05-01 | 120000638 | 120000638-delano-district-skilled-nursing-facility | DELANO DISTRICT SKILLED NURSING FACILITY | Kern | 62 | 28 | 0 | 0 | 29 | ||||
316933 | 316933 | 2021-05-01 | 120000331 | 120000331-height-street-skilled-care | HEIGHT STREET SKILLED CARE | Kern | 72 | 61 | 0 | 16 | 29 | ||||
316936 | 316936 | 2021-05-01 | 120000377 | 120000377-kingston-healthcare-center-llc | KINGSTON HEALTHCARE CENTER, LLC | Kern | 97 | 108 | 0 | 19 | 29 | ||||
316938 | 316938 | 2021-05-01 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 12 | 0 | 0 | 0 | 29 | ||||
316943 | 316943 | 2021-05-01 | 120000328 | 120000328-the-rehabilitation-center-of-bakersfield | THE REHABILITATION CENTER OF BAKERSFIELD | Kern | 124 | 152 | 0 | 15 | 29 | ||||
316947 | 316947 | 2021-05-01 | 120000379 | 120000379-windsor-post-acute-center-of-bakersfield | WINDSOR POST-ACUTE CENTER OF BAKERSFIELD | Kern | 64 | 74 | 0 | 14 | 29 | ||||
316948 | 316948 | 2021-05-01 | 40000042 | 040000042-hacienda-post-acute-inc | HACIENDA POST ACUTE, INC. | Kings | 111 | 94 | 0 | 24 | 31 | ||||
316950 | 316950 | 2021-05-01 | 40001366 | 040001366-kings-nursing-rehabilitation-center | KINGS NURSING & REHABILITATION CENTER | Kings | 31 | 26 | 0 | 0 | 31 | ||||
316951 | 316951 | 2021-05-01 | 110001255 | 110001255-lakeport-post-acute | LAKEPORT POST ACUTE | Lake | 24 | 41 | 0 | 11 | 33 | ||||
316955 | 316955 | 2021-05-01 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 81 | 45 | 0 | 16 | 37 | ||||
316956 | 316956 | 2021-05-01 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 55 | 96 | 1 | 26 | 37 | <11 | |||
316959 | 316959 | 2021-05-01 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 49 | 139 | 0 | 33 | 37 | ||||
316960 | 316960 | 2021-05-01 | 970000003 | 970000003-alexandria-care-center | ALEXANDRIA CARE CENTER | Los Angeles | 75 | 74 | 0 | 32 | 37 | ||||
316962 | 316962 | 2021-05-01 | 930000793 | 930000793-alhambra-hospital-medical-center-d-p-snf | ALHAMBRA HOSPITAL MEDICAL CENTER D/P SNF | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
316963 | 316963 | 2021-05-01 | 920000001 | 920000001-all-saints-healthcare | ALL SAINTS HEALTHCARE | Los Angeles | 43 | 1 | 0 | 0 | 37 | <11 | |||
316968 | 316968 | 2021-05-01 | 920000292 | 920000292-ararat-nursing-facility | ARARAT NURSING FACILITY | Los Angeles | 161 | 125 | 1 | 36 | 37 | <11 | |||
316969 | 316969 | 2021-05-01 | 950000012 | 950000012-arbor-glen-care-center | ARBOR GLEN CARE CENTER | Los Angeles | 52 | 92 | 0 | 12 | 37 | ||||
316972 | 316972 | 2021-05-01 | 920000002 | 920000002-astoria-nursing-and-rehab-center | ASTORIA NURSING AND REHAB CENTER | Los Angeles | 126 | 145 | 0 | 34 | 37 | ||||
316973 | 316973 | 2021-05-01 | 950000039 | 950000039-atherton-baptist-home-sam-b-west | ATHERTON BAPTIST HOME-SAM B. WEST | Los Angeles | 50 | 35 | 0 | 17 | 37 | ||||
316975 | 316975 | 2021-05-01 | 920000306 | 920000306-autumn-hills-health-care-center | AUTUMN HILLS HEALTH CARE CENTER | Los Angeles | 54 | 96 | 0 | 20 | 37 | ||||
316978 | 316978 | 2021-05-01 | 910000009 | 910000009-bay-crest-care-center | BAY CREST CARE CENTER | Los Angeles | 41 | 47 | 0 | 12 | 37 | ||||
316979 | 316979 | 2021-05-01 | 910000071 | 910000071-beachside-post-acute | BEACHSIDE POST ACUTE | Los Angeles | 64 | 71 | 0 | 16 | 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 );