home / la-times

Menu
  • GraphQL API

cdph-skilled-nursing-totals

Table actions
  • GraphQL API for cdph-skilled-nursing-totals

California's Department of Public Health is releasing totals tracking the cumulative number of cases and deaths at the state's skilled nursing facilities.

In some circumstances the true total of cases is obscured. The lowest number in the range is entered into the record in the staff or patients field and an accompanying note field includes the set of possible values.

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.
staff_active_cases
The number of active coronavirus case among staff at that time.
patients_active_cases
The number of active coronavirus case amoung patients at that time.
staff_confirmed_cases
The cumulative number of confirmed coronavirus case among staff at that time.
patients_confirmed_cases
The cumulative number of confirmed coronavirus case among patients at that time.
staff_deaths
The cumulative number of deaths case among staff at that time.
patients_deaths
The cumulative number of deaths case among patients at that time.
staff_deaths_note
In cases where the staff_deaths are obscured, this explains the range of possible values.
source_url
The URL to the state data release.

591 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: staff_deaths_note, date (date)

Link rowid ▼ date staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_deaths patients_deaths staff_deaths_note
1 1 2022-01-14 3201 10869 69485 72360 242 9484  
2 2 2022-01-13 2829 10455 68469 71525 242 9474  
3 3 2022-01-12 2528 10146 67547 70852 242 9463  
4 4 2022-01-11 2020 9673 66578 70139 242 9452  
5 5 2022-01-10 1912 9141 65776 69708 242 9445  
6 6 2022-01-09 1762 8514 65014 69370 242 9441  
7 7 2022-01-08 1777 7919 64325 69034 242 9434  
8 8 2022-01-07 1663 7287 63574 68532 242 9423  
9 9 2022-01-06 1369 6419 62568 68063 242 9418  
10 10 2022-01-05 1210 5655 61690 67688 253 9415  
11 11 2022-01-04 988 4734 60668 67268 253 9403  
12 12 2022-01-03 897 4203 60074 67066 253 9395  
13 13 2022-01-02 809 3747 59622 66995 253 9396  
14 14 2022-01-01 840 3341 59188 66860 256 9394  
15 15 2021-12-31 720 2820 58638 66642 254 9390  
16 16 2021-12-30 616 2255 58036 66428 253 9389  
17 17 2021-12-29 478 1672 57423 66269 253 9389  
18 18 2021-12-28 373 1194 56927 66144 252 9387  
19 19 2021-12-27 271 940 56657 66049 252 9382  
20 20 2021-12-26 304 816 56522 66009 252 9382  
21 21 2021-12-25 236 734 56428 65962 252 9381  
22 22 2021-12-24 245 638 56309 65922 252 9380  
23 23 2021-12-23 178 523 56171 65856 252 9380  
24 24 2021-12-22 188 434 56061 65820 252 9380  
25 25 2021-12-21 154 357 55960 65773 252 9379  
26 26 2021-12-20 120 318 55897 65750 252 9379  
27 27 2021-12-19 115 306 55875 65741 252 9377  
28 28 2021-12-18 146 291 55847 65736 252 9377  
29 29 2021-12-17 140 284 55818 65725 252 9377  
30 30 2021-12-16 158 273 55781 65715 252 9375  
31 31 2021-12-15 183 275 55751 65701 252 9374  
32 32 2021-12-14 175 282 55733 65674 285 9373  
33 33 2021-12-13 202 288 55717 65653 252 9370  
34 34 2021-12-12 165 287 55706 65644 252 9369  
35 35 2021-12-11 190 293 55694 65631 252 9369  
36 36 2021-12-10 205 284 55671 65619 252 9369  
37 37 2021-12-09 223 275 55648 65604 252 9369  
38 38 2021-12-08 209 273 55627 65583 252 9367  
39 39 2021-12-07 232 276 55603 65565 252 9363  
40 40 2021-12-06 240 267 55579 65541 251 9362  
41 41 2021-12-05 221 276 55569 65529 251 9361  
42 42 2021-12-04 230 272 55556 65515 251 9361  
43 43 2021-12-03 255 271 55534 65490 251 9361  
44 44 2021-12-02 223 264 55508 65449 251 9355  
45 45 2021-12-01 207 237 55476 65430 251 9355  
46 46 2021-11-30 194 217 55451 65395 251 9353  
47 47 2021-11-29 244 206 55429 65378 251 9351  
48 48 2021-11-28 202 202 55419 65333 251 9350  
49 49 2021-11-27 187 196 55401 65320 251 9350  
50 50 2021-11-26 202 201 55387 65294 251 9349  
51 51 2021-11-25 186 215 55373 65276 251 9349  
52 52 2021-11-24 206 221 55354 65250 251 9348  
53 53 2021-11-23 189 218 55327 65225 251 9346  
54 54 2021-11-22 196 219 55311 65207 251 9343  
55 55 2021-11-21 176 204 52351 61458 240 8737  
56 56 2021-11-20 174 206 51933 60934 238 8646  
57 57 2021-11-19 240 201 55257 65152 250 9311  
58 58 2021-11-18 108 203 61147 71507 298 10252  
59 59 2021-11-17 118 228 55237 65115 250 9338  
60 60 2021-11-16 222 250 55232 65107 250 9337  
61 61 2021-11-15 238 270 55221 65104 250 9336  
62 62 2021-11-14 247 292 55215 65102 250 9334  
63 63 2021-11-13 219 295 55203 65097 250 9333  
64 64 2021-11-12 254 301 55184 65072 250 9330  
65 65 2021-11-11 259 306 55156 65048 250 9328  
66 66 2021-11-10 254 311 55131 65023 250 9322  
67 67 2021-11-09 328 308 55107 65009 250 9322  
68 68 2021-11-08 299 313 55091 65000 250 9321  
69 69 2021-11-07 327 318 55079 64991 250 9320  
70 70 2021-11-06 304 326 55070 64962 250 9317  
71 71 2021-11-05 427 345 55055 64946 250 9316  
72 72 2021-11-04 421 346 55033 64906 250 9314  
73 73 2021-11-03 428 354 55009 64861 250 9313  
74 74 2021-11-02 357 354 54982 64801 250 9309  
75 75 2021-11-01 400 339 54951 64768 250 9305  
76 76 2021-10-31 409 327 54923 64750 250 9302  
77 77 2021-10-28 40 270 54821 64607 250 9290  
78 78 2021-10-27 365 290 54818 64607 250 9290  
79 79 2021-10-26 338 285 54798 64555 250 9288  
80 80 2021-10-25 348 278 54777 64538 250 9286  
81 81 2021-10-24 289 274 54760 64505 250 9285  
82 82 2021-10-23 302 271 54743 64468 250 9284  
83 83 2021-10-22 289 254 54709 64421 250 9279  
84 84 2021-10-21 290 266 54686 64373 249 9276  
85 85 2021-10-20 303 265 54654 64333 249 9274  
86 86 2021-10-19 270 265 54627 64286 249 9273  
87 87 2021-10-18 290 269 54611 64251 249 9271  
88 88 2021-10-17 235 276 54595 64220 249 9267  
89 89 2021-10-16 244 279 54583 64202 249 9265  
90 90 2021-10-15 247 279 54570 64160 249 9264  
91 91 2021-10-14 220 288 54551 64131 249 9262  
92 92 2021-10-13 304 296 54528 64105 249 9261  
93 93 2021-10-12 267 309 54513 64081 249 9259  
94 94 2021-10-11 306 321 54499 64063 249 9257  
95 95 2021-10-10 278 328 54486 64052 249 9257  
96 96 2021-10-09 299 322 54472 64029 249 9256  
97 97 2021-10-08 287 328 54455 63988 249 9254  
98 98 2021-10-07 281 340 54420 63974 249 9253  
99 99 2021-10-06 288 339 54389 63948 249 9253  
100 100 2021-10-05 260 337 54362 63925 249 9252  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cdph-skilled-nursing-totals" (
   [date] TEXT,
   [staff_active_cases] INTEGER,
   [patients_active_cases] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT
);
Powered by Datasette · Queries took 15.931ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README