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.
776,631 rows sorted by slug
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123448 | 123448 | 2021-10-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
124671 | 124671 | 2021-10-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
125894 | 125894 | 2021-10-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
127117 | 127117 | 2021-10-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
128340 | 128340 | 2021-10-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
129563 | 129563 | 2021-10-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
130786 | 130786 | 2021-10-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
132009 | 132009 | 2021-09-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
133232 | 133232 | 2021-09-29 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
134455 | 134455 | 2021-09-28 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
135678 | 135678 | 2021-09-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
136901 | 136901 | 2021-09-26 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
138124 | 138124 | 2021-09-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
139347 | 139347 | 2021-09-24 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
140570 | 140570 | 2021-09-23 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
141793 | 141793 | 2021-09-22 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
143016 | 143016 | 2021-09-21 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
144239 | 144239 | 2021-09-20 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
145462 | 145462 | 2021-09-19 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
146686 | 146686 | 2021-09-18 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
147909 | 147909 | 2021-09-17 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
149132 | 149132 | 2021-09-16 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
150355 | 150355 | 2021-09-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
151578 | 151578 | 2021-09-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
152801 | 152801 | 2021-09-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
154024 | 154024 | 2021-09-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
155247 | 155247 | 2021-09-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
156470 | 156470 | 2021-09-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
157693 | 157693 | 2021-09-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
158916 | 158916 | 2021-09-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
160139 | 160139 | 2021-09-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
161362 | 161362 | 2021-09-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
162585 | 162585 | 2021-09-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
163808 | 163808 | 2021-09-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
165031 | 165031 | 2021-09-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
166254 | 166254 | 2021-09-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
167477 | 167477 | 2021-09-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
168700 | 168700 | 2021-08-31 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
169923 | 169923 | 2021-08-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
171146 | 171146 | 2021-08-29 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
172369 | 172369 | 2021-08-28 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
173592 | 173592 | 2021-08-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
174815 | 174815 | 2021-08-26 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
176038 | 176038 | 2021-08-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
177261 | 177261 | 2021-08-24 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
178484 | 178484 | 2021-08-23 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
179707 | 179707 | 2021-08-22 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
180930 | 180930 | 2021-08-21 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
182153 | 182153 | 2021-08-20 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
183376 | 183376 | 2021-08-19 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
184599 | 184599 | 2021-08-18 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
185822 | 185822 | 2021-08-17 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
187045 | 187045 | 2021-08-16 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
188268 | 188268 | 2021-08-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
189491 | 189491 | 2021-08-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
190714 | 190714 | 2021-08-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
191937 | 191937 | 2021-08-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
193160 | 193160 | 2021-08-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
194383 | 194383 | 2021-08-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
195606 | 195606 | 2021-08-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
196829 | 196829 | 2021-08-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
198052 | 198052 | 2021-08-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
199275 | 199275 | 2021-08-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
200498 | 200498 | 2021-08-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
201721 | 201721 | 2021-08-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
202944 | 202944 | 2021-08-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
204167 | 204167 | 2021-08-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
205390 | 205390 | 2021-08-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
206613 | 206613 | 2021-07-31 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
207836 | 207836 | 2021-07-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
209059 | 209059 | 2021-07-29 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
210282 | 210282 | 2021-07-28 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
211505 | 211505 | 2021-07-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
212728 | 212728 | 2021-07-26 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
213951 | 213951 | 2021-07-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
215174 | 215174 | 2021-07-24 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
216397 | 216397 | 2021-07-23 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
217620 | 217620 | 2021-07-22 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
218843 | 218843 | 2021-07-21 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
220066 | 220066 | 2021-07-20 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
221289 | 221289 | 2021-07-19 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
222512 | 222512 | 2021-07-18 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
223735 | 223735 | 2021-07-17 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
224958 | 224958 | 2021-07-16 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
226181 | 226181 | 2021-07-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
227404 | 227404 | 2021-07-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
228627 | 228627 | 2021-07-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
229850 | 229850 | 2021-07-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
231073 | 231073 | 2021-07-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
232296 | 232296 | 2021-07-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
233519 | 233519 | 2021-07-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
234742 | 234742 | 2021-07-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
235965 | 235965 | 2021-07-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
237188 | 237188 | 2021-07-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
238411 | 238411 | 2021-07-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
239634 | 239634 | 2021-07-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
240857 | 240857 | 2021-07-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
242080 | 242080 | 2021-07-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
243303 | 243303 | 2021-07-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
244526 | 244526 | 2021-06-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <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 );