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

67,543 rows sorted by date descending

View and edit SQL

Link rowid date ▲ id name county fips staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths patients_deaths staff_deaths_note patients_deaths_note
1 2020-07-02 140000321 ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 1 0 0 0 1   10 or fewer 0 0    
2 2020-07-02 20000043 ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
3 2020-07-02 630011864 ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
4 2020-07-02 140000686 ALAMEDA HOSPITAL D/P SNF Alameda 1 0 0 0 0     0 0    
5 2020-07-02 630013891 ALL SAINT'S MAUBERT Alameda 1 0 0 0 0     0 0    
6 2020-07-02 20000070 ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 1 0 0 1 0 10 or fewer   0 0    
7 2020-07-02 20000010 ASHBY CARE CENTER Alameda 1 0 0 0 0     0 0    
8 2020-07-02 20000015 BANCROFT HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
9 2020-07-02 20000135 BAY AREA HEALTHCARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
10 2020-07-02 20000026 BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 1 0 0 1 0 10 or fewer   0 0    
11 2020-07-02 20000060 BAYPOINT HEALTHCARE CENTER Alameda 1 0 0 0 0     0 0    
12 2020-07-02 630011713 BAYWOOD COURT HEALTH CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
13 2020-07-02 20001250 BELLAKEN SKILLED NURSING CENTER Alameda 1 0 0 0 0     0 0    
14 2020-07-02 20000028 BERKELEY PINES SKILLED NURSING CENTER Alameda 1 0 0 0 1   10 or fewer 0 0    
15 2020-07-02 20000029 BETHESDA HOME Alameda 1 0 0 0 0     0 0    
16 2020-07-02 20000048 CHAPARRAL HOUSE Alameda 1 0 0 0 1   10 or fewer 0 0    
17 2020-07-02 630015174 CREEKVIEW SKILLED NURSING Alameda 1 0 1 1 1 10 or fewer 10 or fewer 0 0    
18 2020-07-02 20000053 CRESTWOOD MANOR - FREMONT Alameda 1 0 0 1 0 10 or fewer   0 0    
19 2020-07-02 20000129 CRESTWOOD TREATMENT CENTER Alameda 1 0 0 0 0     0 0    
20 2020-07-02 20000087 CROWN BAY NURSING & REHABILITATION CENTER Alameda 1 0 0 0 0     0 0    
21 2020-07-02 20000133 DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 1 0 15 11 32     0 1   10 or fewer
22 2020-07-02 20000116 EAST BAY POST-ACUTE Alameda 1 0 0 25 33     0 16    
23 2020-07-02 20000128 ELMWOOD CARE CENTER Alameda 1 0 0 0 1   10 or fewer 0 1   10 or fewer
24 2020-07-02 20000093 EXCELL HEALTH CARE CENTER Alameda 1 0 0 23 43     0 1   10 or fewer
25 2020-07-02 20000132 FREMONT HEALTHCARE CENTER Alameda 1 0 0 1 38 10 or fewer   0 1   10 or fewer
26 2020-07-02 20000124 FRUITVALE HEALTHCARE CENTER Alameda 1 1 1 1 1 10 or fewer 10 or fewer 0 0    
27 2020-07-02 20000125 GARFIELD NEUROBEHAVIORAL CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
28 2020-07-02 20000037 GATEWAY CARE & REHABILITATION CENTER Alameda 1 0 0 31 48     0 19    
29 2020-07-02 20000123 HAYWARD CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
30 2020-07-02 20000039 HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 1 0 1 1 0 10 or fewer   1 0 10 or fewer  
31 2020-07-02 20000047 HAYWARD HILLS HEALTH CARE CENTER Alameda 1 0 0 0 0     0 0    
32 2020-07-02 20000101 HILLSIDE SENIOR CARE Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
33 2020-07-02 20000111 JONES CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
34 2020-07-02 20000042 KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 1 0 1 1 11 10 or fewer   0 0    
35 2020-07-02 20000112 KYAKAMEENA CARE CENTER Alameda 1 0 0 0 0     0 0    
36 2020-07-02 20000110 LAKE MERRITT HEALTHCARE CENTER LLC Alameda 1 0 0 1 0 10 or fewer   0 0    
37 2020-07-02 20000114 LAKE PARK RETIREMENT RESIDENCE Alameda 1 0 0 0 0     0 0    
38 2020-07-02 20000104 MARINA GARDEN NURSING CENTER Alameda 1 0 0 0 0     0 0    
39 2020-07-02 20000040 MASONIC HOME Alameda 1 0 0 1 0 10 or fewer   0 0    
40 2020-07-02 20000099 MCCLURE POST ACUTE Alameda 1 0 0 0 0     0 0    
41 2020-07-02 20000079 MEDICAL HILL HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
42 2020-07-02 20000100 MERCY RETIREMENT & CARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
43 2020-07-02 630014957 MOCHO PARK CARE CENTER Alameda 1 0 0 0 0     0 0    
44 2020-07-02 20000808 MORTON BAKAR CENTER Alameda 1 0 0 0 0     0 0    
45 2020-07-02 20000115 OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
46 2020-07-02 20000880 OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 1 0 0 0 0     0 0    
47 2020-07-02 630014635 PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
48 2020-07-02 20000094 PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
49 2020-07-02 20000090 PARKVIEW HEALTHCARE CENTER Alameda 1 0 0 19 54     0 1   10 or fewer
50 2020-07-02 20000091 PIEDMONT GARDENS HEALTH FACILITY Alameda 1 0 0 0 0     0 0    
51 2020-07-02 140000086 PLEASANTON NURSING AND REHABILITATION CENTER Alameda 1 0 0 0 0     0 0    
52 2020-07-02 20000054 PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 1 0 0 0 0     0 0    
53 2020-07-02 20000276 REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 1 0 1 1 17 10 or fewer   0 1   10 or fewer
54 2020-07-02 20000119 REDWOOD HEALTHCARE CENTER LLC Alameda 1 0 0 15 29     0 1   10 or fewer
55 2020-07-02 20000077 SAN LEANDRO HEALTHCARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
56 2020-07-02 140001291 SILVER OAK MANOR Alameda 1 0 0 0 0     0 0    
57 2020-07-02 20000005 ST ANTHONY CARE CENTER Alameda 1 0 0 0 0     0 0    
58 2020-07-02 20000074 ST CHRISTOPHER CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
59 2020-07-02 20000076 ST FRANCIS HEALTHCARE CENTER Alameda 1 0 0 0 0     0 0    
60 2020-07-02 20000068 ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 1 0 0 0 0     0 0    
61 2020-07-02 20000064 ST PAULS TOWERS Alameda 1 0 0 0 0     0 0    
62 2020-07-02 20000274 THE REHABILITATION CENTER OF OAKLAND Alameda 1 0 0 0 1   10 or fewer 0 0    
63 2020-07-02 140000122 THE VINEYARDS HEALTHCARE CENTER Alameda 1 0 1 1 0 10 or fewer   0 0    
64 2020-07-02 140000626 VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 1 0 0 0 0     0 0    
65 2020-07-02 20000066 VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
66 2020-07-02 20000019 VISTA POST ACUTE Alameda 1 0 1 23 48     0 1   10 or fewer
67 2020-07-02 20000275 WASHINGTON CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
68 2020-07-02 20000065 WE CARE SKILLED NURSING FACILITY Alameda 1 0 0 1 0 10 or fewer   0 0    
69 2020-07-02 20000020 WINDSOR COUNTRY DRIVE CARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
70 2020-07-02 20000103 WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 1 0 0 1 0 10 or fewer   0 0    
71 2020-07-02 20000277 WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
72 2020-07-02 20000036 WINDSOR PARK CARE CENTER OF FREMONT Alameda 1 0 0 0 1   10 or fewer 0 0    
73 2020-07-02 20000071 WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 1 0 0 19 25     0 1   10 or fewer
74 2020-07-02 30000074 KIT CARSON NURSING & REHABILITATION CENTER Amador 5 0 0 0 0     0 0    
75 2020-07-02 230000255 ARBOR POST ACUTE Butte 7 0 0 0 0     0 0    
76 2020-07-02 230000546 CALIFORNIA PARK REHABILITATION HOSPITAL Butte 7 0 0 0 0     0 0    
77 2020-07-02 230000802 COUNTRY CREST POST ACUTE Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
78 2020-07-02 230000327 ORCHARD HOSPITAL D/P SNF Butte 7 0 0 0 0     0 0    
79 2020-07-02 230000221 OROVILLE HOSPITAL POST-ACUTE CENTER Butte 7 0 0 1 0 10 or fewer   0 0    
80 2020-07-02 230000036 RIVERSIDE CONVALESCENT HOSPITAL Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
81 2020-07-02 230000037 SHADOWBROOK POST ACUTE Butte 7 0 0 0 0     0 0    
82 2020-07-02 230000025 WINDSOR CHICO CARE CENTER Butte 7 0 0 0 0     0 0    
83 2020-07-02 230000029 WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 7 0 0 0 0     0 0    
84 2020-07-02 30000012 AVALON HEALTH CARE - SAN ANDREAS Calaveras 9 0 0 0 0     0 0    
85 2020-07-02 230000424 COLUSA MEDICAL CENTER - SNF Colusa 11 0 0 0 0     0 0    
86 2020-07-02 230000283 VALLEY WEST POST ACUTE Colusa 11 0 0 0 0     0 0    
87 2020-07-02 140000574 ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
88 2020-07-02 140000003 ANTIOCH CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
89 2020-07-02 140000023 BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 13 0 0 1 0 10 or fewer   0 0    
90 2020-07-02 140000138 CREEKSIDE HEALTHCARE CENTER Contra Costa 13 0 0 0 0     0 0    
91 2020-07-02 140000130 DANVILLE POST-ACUTE REHAB Contra Costa 13 0 0 0 0     0 0    
92 2020-07-02 140000564 DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 13 1 0 1 1 10 or fewer 10 or fewer 0 0    
93 2020-07-02 140000038 GREENRIDGE SENIOR CARE Contra Costa 13 0 0 0 0     0 0    
94 2020-07-02 140000051 LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 13 0 0 0 0     0 0    
95 2020-07-02 140000102 LEGACY NURSING AND REHABILITATION CENTER Contra Costa 13 0 0 1 0 10 or fewer   0 0    
96 2020-07-02 140000105 LONE TREE CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
97 2020-07-02 140001126 MANOR CARE HEALTH SERVICES-TICE VALLEY Contra Costa 13 1 0 24 75     0 1   10 or fewer
98 2020-07-02 140000745 MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 13 0 0 0 0     0 0    
99 2020-07-02 140000106 MARTINEZ CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
100 2020-07-02 140000081 MORAGA POST ACUTE Contra Costa 13 0 0 1 11 10 or fewer   0 0    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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