la_times_cdph_skilled_nursing_facilities

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

164,159 rows sorted by date descending

View and edit SQL

Link rowid date ▲ county id name staff_deaths patients_deaths staff_confirmed_cases patients_confirmed_cases slug fips staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths_note patients_deaths_note
1 2020-09-21 Alameda 140000321 ALAMEDA COUNTY MEDICAL CENTER D/P SNF 0 0 1 1 140000321-alameda-county-medical-center-d-p-snf 1 10 or fewer 10 or fewer    
2 2020-09-21 Alameda 20000043 ALAMEDA HEALTHCARE & WELLNESS CENTER 0 1 12 17 020000043-alameda-healthcare-wellness-center 1       10 or fewer
3 2020-09-21 Alameda 630011864 ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT 0 0 1 1 630011864-alameda-hospital-southshore-convalescent 1 10 or fewer 10 or fewer    
4 2020-09-21 Alameda 140000686 ALAMEDA HOSPITAL D/P SNF 0 0 1 0 140000686-alameda-hospital-d-p-snf 1 10 or fewer      
5 2020-09-21 Alameda 630013891 ALL SAINT'S MAUBERT 0 0 1 0 630013891-all-saint-s-maubert 1 10 or fewer      
6 2020-09-21 Alameda 20000070 ALL SAINTS SUBACUTE & TRANSITIONAL CARE 0 0 1 0 020000070-all-saints-subacute-transitional-care 1 10 or fewer      
7 2020-09-21 Alameda 20000010 ASHBY CARE CENTER 0 0 0 0 020000010-ashby-care-center 1        
8 2020-09-21 Alameda 20000015 BANCROFT HEALTHCARE CENTER 0 0 1 0 020000015-bancroft-healthcare-center 1 10 or fewer      
9 2020-09-21 Alameda 20000135 BAY AREA HEALTHCARE CENTER 0 0 1 1 020000135-bay-area-healthcare-center 1 10 or fewer 10 or fewer    
10 2020-09-21 Alameda 20000026 BAY VIEW REHABILITATION HOSPITAL, LLC 0 0 1 1 020000026-bay-view-rehabilitation-hospital-llc 1 10 or fewer 10 or fewer    
11 2020-09-21 Alameda 20000060 BAYPOINT HEALTHCARE CENTER 0 0 1 0 020000060-baypoint-healthcare-center 1 10 or fewer      
12 2020-09-21 Alameda 630011713 BAYWOOD COURT HEALTH CENTER 0 0 1 0 630011713-baywood-court-health-center 1 10 or fewer      
13 2020-09-21 Alameda 20001250 BELLAKEN SKILLED NURSING CENTER 0 0 0 0 020001250-bellaken-skilled-nursing-center 1        
14 2020-09-21 Alameda 20000028 BERKELEY PINES SKILLED NURSING CENTER 0 1 1 18 020000028-berkeley-pines-skilled-nursing-center 1 10 or fewer     10 or fewer
15 2020-09-21 Alameda 20000029 BETHESDA HOME 0 0 0 0 020000029-bethesda-home 1        
16 2020-09-21 Alameda 20000048 CHAPARRAL HOUSE 0 0 1 1 020000048-chaparral-house 1 10 or fewer 10 or fewer    
17 2020-09-21 Alameda 630015174 CREEKVIEW SKILLED NURSING 0 0 1 1 630015174-creekview-skilled-nursing 1 10 or fewer 10 or fewer    
18 2020-09-21 Alameda 20000053 CRESTWOOD MANOR - FREMONT 1 1 21 53 020000053-crestwood-manor-fremont 1     10 or fewer 10 or fewer
19 2020-09-21 Alameda 20000129 CRESTWOOD TREATMENT CENTER 0 0 1 25 020000129-crestwood-treatment-center 1 10 or fewer      
20 2020-09-21 Alameda 20000087 CROWN BAY NURSING & REHABILITATION CENTER 0 0 1 0 020000087-crown-bay-nursing-rehabilitation-center 1 10 or fewer      
21 2020-09-21 Alameda 20000133 DRIFTWOOD HEALTHCARE CENTER - HAYWARD 0 1 18 32 020000133-driftwood-healthcare-center-hayward 1       10 or fewer
22 2020-09-21 Alameda 20000116 EAST BAY POST-ACUTE 0 1 30 33 020000116-east-bay-post-acute 1       10 or fewer
23 2020-09-21 Alameda 20000128 ELMWOOD CARE CENTER 0 1 1 1 020000128-elmwood-care-center 1 10 or fewer 10 or fewer   10 or fewer
24 2020-09-21 Alameda 20000093 EXCELL HEALTH CARE CENTER 0 1 23 44 020000093-excell-health-care-center 1       10 or fewer
25 2020-09-21 Alameda 20000132 FREMONT HEALTHCARE CENTER 0 1 1 38 020000132-fremont-healthcare-center 1 10 or fewer     10 or fewer
26 2020-09-21 Alameda 20000124 FRUITVALE HEALTHCARE CENTER 0 0 15 11 020000124-fruitvale-healthcare-center 1        
27 2020-09-21 Alameda 20000125 GARFIELD NEUROBEHAVIORAL CENTER 0 1 46 45 020000125-garfield-neurobehavioral-center 1       10 or fewer
28 2020-09-21 Alameda 20000037 GATEWAY CARE & REHABILITATION CENTER 0 19 31 49 020000037-gateway-care-rehabilitation-center 1        
29 2020-09-21 Alameda 20000123 HAYWARD CONVALESCENT HOSPITAL 0 0 0 0 020000123-hayward-convalescent-hospital 1        
30 2020-09-21 Alameda 20000039 HAYWARD HEALTHCARE & WELLNESS CENTER 1 0 1 1 020000039-hayward-healthcare-wellness-center 1 10 or fewer 10 or fewer 10 or fewer  
31 2020-09-21 Alameda 20000047 HAYWARD HILLS HEALTH CARE CENTER 0 0 1 0 020000047-hayward-hills-health-care-center 1 10 or fewer      
32 2020-09-21 Alameda 20000101 HILLSIDE SENIOR CARE 0 1 1 1 020000101-hillside-senior-care 1 10 or fewer 10 or fewer   10 or fewer
33 2020-09-21 Alameda 20000111 JONES CONVALESCENT HOSPITAL 0 0 0 0 020000111-jones-convalescent-hospital 1        
34 2020-09-21 Alameda 20000042 KAISER PERMANENTE POST-ACUTE CARE CENTER 0 1 17 18 020000042-kaiser-permanente-post-acute-care-center 1       10 or fewer
35 2020-09-21 Alameda 20000112 KYAKAMEENA CARE CENTER 0 0 1 0 020000112-kyakameena-care-center 1 10 or fewer      
36 2020-09-21 Alameda 20000110 LAKE MERRITT HEALTHCARE CENTER LLC 0 0 1 0 020000110-lake-merritt-healthcare-center-llc 1 10 or fewer      
37 2020-09-21 Alameda 20000114 LAKE PARK RETIREMENT RESIDENCE 0 0 0 0 020000114-lake-park-retirement-residence 1        
38 2020-09-21 Alameda 20000104 MARINA GARDEN NURSING CENTER 0 0 1 1 020000104-marina-garden-nursing-center 1 10 or fewer 10 or fewer    
39 2020-09-21 Alameda 20000040 MASONIC HOME 0 0 1 0 020000040-masonic-home 1 10 or fewer      
40 2020-09-21 Alameda 20000099 MCCLURE POST ACUTE 0 0 0 0 020000099-mcclure-post-acute 1        
41 2020-09-21 Alameda 20000079 MEDICAL HILL HEALTHCARE CENTER 0 0 31 50 020000079-medical-hill-healthcare-center 1        
42 2020-09-21 Alameda 20000100 MERCY RETIREMENT & CARE CENTER 0 12 20 20 020000100-mercy-retirement-care-center 1        
43 2020-09-21 Alameda 630014957 MOCHO PARK CARE CENTER 0 0 1 1 630014957-mocho-park-care-center 1 10 or fewer 10 or fewer    
44 2020-09-21 Alameda 20000808 MORTON BAKAR CENTER 0 1 23 52 020000808-morton-bakar-center 1       10 or fewer
45 2020-09-21 Alameda 20000115 OAKLAND HEALTHCARE & WELLNESS CENTER 0 0 1 1 020000115-oakland-healthcare-wellness-center 1 10 or fewer 10 or fewer    
46 2020-09-21 Alameda 20000880 OAKLAND HEIGHTS NURSING AND REHABILITATION 0 0 1 0 020000880-oakland-heights-nursing-and-rehabilitation 1 10 or fewer      
47 2020-09-21 Alameda 630014635 PARK BRIDGE REHABILITATION AND WELLNESS CENTER 0 0 1 1 630014635-park-bridge-rehabilitation-and-wellness-center 1 10 or fewer 10 or fewer    
48 2020-09-21 Alameda 20000094 PARK CENTRAL CARE AND REHABILITATION CENTER 0 0 1 0 020000094-park-central-care-and-rehabilitation-center 1 10 or fewer      
49 2020-09-21 Alameda 20000090 PARKVIEW HEALTHCARE CENTER 1 1 20 101 020000090-parkview-healthcare-center 1     10 or fewer 10 or fewer
50 2020-09-21 Alameda 20000091 PIEDMONT GARDENS HEALTH FACILITY 0 0 1 0 020000091-piedmont-gardens-health-facility 1 10 or fewer      
51 2020-09-21 Alameda 140000086 PLEASANTON NURSING AND REHABILITATION CENTER 1 11 41 48 140000086-pleasanton-nursing-and-rehabilitation-center 1     10 or fewer  
52 2020-09-21 Alameda 20000054 PRINCETON MANOR HEALTHCARE CENTER, LLC 0 1 16 25 020000054-princeton-manor-healthcare-center-llc 1       10 or fewer
53 2020-09-21 Alameda 20000276 REDWOOD CONVALESCENT HOSPITAL, INC. 0 1 1 21 020000276-redwood-convalescent-hospital-inc 1 10 or fewer     10 or fewer
54 2020-09-21 Alameda 20000119 REDWOOD HEALTHCARE CENTER LLC 0 1 17 29 020000119-redwood-healthcare-center-llc 1       10 or fewer
55 2020-09-21 Alameda 20000077 SAN LEANDRO HEALTHCARE CENTER 0 1 1 11 020000077-san-leandro-healthcare-center 1 10 or fewer     10 or fewer
56 2020-09-21 Alameda 140001291 SILVER OAK MANOR 0 0 1 0 140001291-silver-oak-manor 1 10 or fewer      
57 2020-09-21 Alameda 20000005 ST ANTHONY CARE CENTER 0 0 1 0 020000005-st-anthony-care-center 1 10 or fewer      
58 2020-09-21 Alameda 20000074 ST CHRISTOPHER CONVALESCENT HOSPITAL 0 1 12 24 020000074-st-christopher-convalescent-hospital 1       10 or fewer
59 2020-09-21 Alameda 20000076 ST FRANCIS HEALTHCARE CENTER 0 0 0 0 020000076-st-francis-healthcare-center 1        
60 2020-09-21 Alameda 20000068 ST JOHN KRONSTADT CONVALESCENT CENTER 0 0 0 0 020000068-st-john-kronstadt-convalescent-center 1        
61 2020-09-21 Alameda 20000064 ST PAULS TOWERS 0 0 0 0 020000064-st-pauls-towers 1        
62 2020-09-21 Alameda 20000274 THE REHABILITATION CENTER OF OAKLAND 0 1 1 24 020000274-the-rehabilitation-center-of-oakland 1 10 or fewer     10 or fewer
63 2020-09-21 Alameda 140000122 THE VINEYARDS HEALTHCARE CENTER 0 0 1 0 140000122-the-vineyards-healthcare-center 1 10 or fewer      
64 2020-09-21 Alameda 140000626 VALLEY MEMORIAL HOSPITAL D/P SNF 0 0 0 0 140000626-valley-memorial-hospital-d-p-snf 1        
65 2020-09-21 Alameda 20000066 VALLEY POINTE NURSING & REHABILITATION CENTER 0 0 1 1 020000066-valley-pointe-nursing-rehabilitation-center 1 10 or fewer 10 or fewer    
66 2020-09-21 Alameda 20000019 VISTA POST ACUTE 0 1 27 48 020000019-vista-post-acute 1       10 or fewer
67 2020-09-21 Alameda 20000275 WASHINGTON CENTER 0 0 1 0 020000275-washington-center 1 10 or fewer      
68 2020-09-21 Alameda 20000065 WE CARE SKILLED NURSING FACILITY 0 0 1 0 020000065-we-care-skilled-nursing-facility 1 10 or fewer      
69 2020-09-21 Alameda 20000020 WINDSOR COUNTRY DRIVE CARE CENTER 0 0 18 19 020000020-windsor-country-drive-care-center 1        
70 2020-09-21 Alameda 20000103 WINDSOR GARDENS CARE CENTER OF HAYWARD 0 0 1 1 020000103-windsor-gardens-care-center-of-hayward 1 10 or fewer 10 or fewer    
71 2020-09-21 Alameda 20000277 WINDSOR HEALTHCARE CENTER OF OAKLAND 0 1 34 59 020000277-windsor-healthcare-center-of-oakland 1       10 or fewer
72 2020-09-21 Alameda 20000036 WINDSOR PARK CARE CENTER OF FREMONT 0 0 15 19 020000036-windsor-park-care-center-of-fremont 1        
73 2020-09-21 Alameda 20000071 WINDSOR POST-ACUTE CARE CENTER OF HAYWARD 0 1 31 30 020000071-windsor-post-acute-care-center-of-hayward 1       10 or fewer
74 2020-09-21 Amador 30000074 KIT CARSON NURSING & REHABILITATION CENTER 0 16 22 51 030000074-kit-carson-nursing-rehabilitation-center 5        
75 2020-09-21 Butte 230000255 ARBOR POST ACUTE 0 1 28 36 230000255-arbor-post-acute 7       10 or fewer
76 2020-09-21 Butte 230000546 CALIFORNIA PARK REHABILITATION HOSPITAL 0 1 15 1 230000546-california-park-rehabilitation-hospital 7   10 or fewer   10 or fewer
77 2020-09-21 Butte 230000802 COUNTRY CREST POST ACUTE 0 0 1 1 230000802-country-crest-post-acute 7 10 or fewer 10 or fewer    
78 2020-09-21 Butte 230000327 ORCHARD HOSPITAL D/P SNF 0 0 0 0 230000327-orchard-hospital-d-p-snf 7        
79 2020-09-21 Butte 230000221 OROVILLE HOSPITAL POST-ACUTE CENTER 0 0 1 0 230000221-oroville-hospital-post-acute-center 7 10 or fewer      
80 2020-09-21 Butte 230000036 RIVERSIDE CONVALESCENT HOSPITAL 0 1 26 48 230000036-riverside-convalescent-hospital 7       10 or fewer
81 2020-09-21 Butte 230000037 SHADOWBROOK POST ACUTE 0 0 0 0 230000037-shadowbrook-post-acute 7        
82 2020-09-21 Butte 230000025 WINDSOR CHICO CARE CENTER 0 1 1 11 230000025-windsor-chico-care-center 7 10 or fewer     10 or fewer
83 2020-09-21 Butte 230000029 WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER 0 1 29 38 230000029-windsor-chico-creek-care-and-rehabilitation-center 7       10 or fewer
84 2020-09-21 Calaveras 30000012 AVALON HEALTH CARE - SAN ANDREAS 0 1 16 45 030000012-avalon-health-care-san-andreas 9       10 or fewer
85 2020-09-21 Colusa 230000424 COLUSA MEDICAL CENTER - SNF 0 1 1 1 230000424-colusa-medical-center-snf 11 10 or fewer 10 or fewer   10 or fewer
86 2020-09-21 Colusa 230000283 VALLEY WEST POST ACUTE 0 1 41 29 230000283-valley-west-post-acute 11       10 or fewer
87 2020-09-21 Contra Costa 140000574 ALHAMBRA CONVALESCENT HOSPITAL 0 0 1 0 140000574-alhambra-convalescent-hospital 13 10 or fewer      
88 2020-09-21 Contra Costa 140000003 ANTIOCH CONVALESCENT HOSPITAL 0 0 1 0 140000003-antioch-convalescent-hospital 13 10 or fewer      
89 2020-09-21 Contra Costa 140000023 BAYBERRY SKILLED NURSING & HEALTHCARE CENTER 0 1 29 56 140000023-bayberry-skilled-nursing-healthcare-center 13       10 or fewer
90 2020-09-21 Contra Costa 140000138 CREEKSIDE HEALTHCARE CENTER 0 0 1 1 140000138-creekside-healthcare-center 13 10 or fewer 10 or fewer    
91 2020-09-21 Contra Costa 140000130 DANVILLE POST-ACUTE REHAB 0 0 1 0 140000130-danville-post-acute-rehab 13 10 or fewer      
92 2020-09-21 Contra Costa 140000564 DIAMOND RIDGE HEALTHCARE CENTER 0 1 16 22 140000564-diamond-ridge-healthcare-center 13       10 or fewer
93 2020-09-21 Contra Costa 140000038 GREENRIDGE SENIOR CARE 0 0 1 0 140000038-greenridge-senior-care 13 10 or fewer      
94 2020-09-21 Contra Costa 140000051 LA CASA VIA TRANSITIONAL CARE CENTER 0 0 1 0 140000051-la-casa-via-transitional-care-center 13 10 or fewer      
95 2020-09-21 Contra Costa 140000102 LEGACY NURSING AND REHABILITATION CENTER 0 1 12 13 140000102-legacy-nursing-and-rehabilitation-center 13       10 or fewer
96 2020-09-21 Contra Costa 140000105 LONE TREE CONVALESCENT HOSPITAL 0 0 1 0 140000105-lone-tree-convalescent-hospital 13 10 or fewer      
97 2020-09-21 Contra Costa 140001126 MANOR CARE HEALTH SERVICES-TICE VALLEY 0 17 39 92 140001126-manor-care-health-services-tice-valley 13        
98 2020-09-21 Contra Costa 140000745 MANORCARE HEALTH SERVICES - ROSSMOOR 0 0 1 1 140000745-manorcare-health-services-rossmoor 13 10 or fewer 10 or fewer    
99 2020-09-21 Contra Costa 140000106 MARTINEZ CONVALESCENT HOSPITAL 0 0 0 0 140000106-martinez-convalescent-hospital 13        
100 2020-09-21 Contra Costa 140000081 MORAGA POST ACUTE 0 0 1 11 140000081-moraga-post-acute 13 10 or fewer      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_skilled_nursing_facilities] (
   [date] TEXT,
   [county] TEXT,
   [id] INTEGER,
   [name] TEXT,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [slug] TEXT,
   [fips] INTEGER,
   [staff_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT
);
Powered by Datasette · Query took 2356.881ms · 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