la_times_cdph_skilled_nursing_totals

⚠️ 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_totals

137 rows sorted by date descending

View and edit SQL

Suggested facets: staff_deaths_note, source_url, date (date)

Link rowid date ▲ staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_deaths patients_deaths staff_deaths_note source_url
1 2020-09-21 28 1068 19047 25479 149 4375   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
2 2020-09-20 28 1077 19009 25444 148 4368   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
3 2020-09-19 32 967 18958 25396 147 4357   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
4 2020-09-18 28 918 18883 25338 147 4345   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
5 2020-09-17 29 1067 18784 25234 147 4340   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
6 2020-09-16 38 1094 18739 25184 146 4326   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
7 2020-09-15 32 1234 18691 25132 146 4308   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
8 2020-09-14 39 1275 18647 25099 146 4296   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
9 2020-09-13 32 1367 18593 25044 144 4288   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
10 2020-09-12 36 1153 18538 24939 143 4282   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
11 2020-09-11 42 1251 18465 24867 143 4271   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
12 2020-09-10 32 1410 18406 24756 142 4257   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
13 2020-09-09 30 1469 18366 24757 142 4244   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
14 2020-09-08 32 1499 18332 24731 141 4221   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
15 2020-09-07 49 1607 18295 24678 141 4210   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
16 2020-09-06 41 1578 18251 24618 141 4200   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
17 2020-09-05 52 1598 18155 24426 141 4183   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
18 2020-09-04 43 1563 18031 24314 141 4168   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
19 2020-09-03 44 1674 17955 24206 139 4151   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
20 2020-09-02 51 1838 17874 24123 139 4123   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
21 2020-09-01 57 1835 17831 24061 139 4104   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
22 2020-08-31 44 2019 17788 23986 139 4078   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
23 2020-08-30 49 2006 17727 23904 139 4065   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
24 2020-08-29 57 2010 17632 23816 139 4048   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
25 2020-08-28 53 2025 17498 23670 141 4028   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
26 2020-08-27 64 2131 17381 23541 139 4000   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
27 2020-08-26 68 2151 17280 23402 141 3976   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
28 2020-08-25 70 2448 17205 23326 140 3958   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
29 2020-08-24 62 2545 17134 23242 140 3933   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
30 2020-08-23 60 2458 17043 23111 140 3918   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
31 2020-08-22 83 2543 16921 22975 140 3891   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
32 2020-08-21 86 2714 16756 22854 140 3862   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
33 2020-08-20 51 2419 16631 22571 140 3826   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
34 2020-08-19 63 2713 16510 22423 140 3797   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
35 2020-08-18 63 2621 16385 22307 140 3770   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
36 2020-08-17 58 2599 16280 22236 141 3729   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
37 2020-08-16 63 2708 16211 22053 132 3710   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
38 2020-08-15 63 2712 16072 21868 132 3689   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
39 2020-08-14 63 2806 15898 21716 130 3666   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
40 2020-08-13 62 2756 15731 21470 130 3636   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
41 2020-08-12 61 2855 15573 21272 129 3601   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
42 2020-08-11 66 2899 15457 21050 129 3569   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
43 2020-08-10 50 2976 15311 20867 129 3541   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
44 2020-08-09 48 2822 15186 20707 129 3507   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
45 2020-08-08 65 2848 15067 20546 129 3491   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
46 2020-08-07 76 2902 14919 20359 126 3463   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
47 2020-08-06 108 2856 14769 20116 124 3439   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
48 2020-08-05 100 2813 14612 19913 122 3415   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
49 2020-08-04 78 2910 14513 19772 121 3381   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
50 2020-08-03 74 2991 14374 19639 121 3355   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
51 2020-08-02 73 3000 14275 19519 121 3332   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
52 2020-08-01 100 2874 14112 19248 121 3306   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
53 2020-07-31 120 2825 13914 19023 121 3274   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
54 2020-07-30 83 2854 13467 18553 120 3214   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
55 2020-07-29 83 2854 13567 18553 120 3214   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
56 2020-07-28 83 2851 13322 18432 120 3184   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
57 2020-07-27 95 3059 13109 18265 120 3143   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
58 2020-07-26 78 2648 12981 18088 119 3118   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
59 2020-07-25 101 2649 12790 17847 117 3096   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
60 2020-07-24 101 2848 12607 17641 116 3063   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
61 2020-07-23 101 2719 12413 17452 116 3039   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
62 2020-07-22 95 2673 12202 17162 113 3013   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
63 2020-07-21 73 2473 12029 16908 104 2980   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
64 2020-07-20 84 2569 11875 16762 104 2953   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
65 2020-07-19 82 2536 11705 16615 104 2937   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
66 2020-07-18 82 2420 11487 16365 104 2921   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
67 2020-07-17 74 2318 11293 16206 103 2898   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
68 2020-07-16 56 2268 11093 16033 102 2870   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
69 2020-07-15 56 2421 10952 15898 101 2843   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
70 2020-07-14 75 2314 10784 15678 101 2804   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
71 2020-07-13 52 2382 10593 15578 99 2775   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
72 2020-07-12 53 2361 10457 15400 99 2753   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
73 2020-07-11 54 2030 10262 15267 99 2723   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
74 2020-07-10 70 2294 10043 15039 98 2697   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
75 2020-07-09 55 2145 9908 14886 98 2667   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
76 2020-07-08 75 2253 9765 14750 97 2646   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
77 2020-07-07 74 2278 9641 14646 97 2618   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
78 2020-07-06 67 2335 9499 14515 95 2591   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
79 2020-07-03 55 2030 9156 14074 93 2541   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
80 2020-07-02 53 1994 9047 13923 93 2524   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
81 2020-07-01 52 2155 8900 13694 92 2496   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
82 2020-06-30 59 2148 9739 13538 92 2480   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
83 2020-06-29 63 2296 8570 13403 91 2460   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
84 2020-06-28 58 2093 8409 13190 91 2433   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
85 2020-06-27 68 2107 8080 12666 86 2341   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
86 2020-06-26 40 2131 7975 12632 86 2339   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
87 2020-06-25 49 2051 7922 12592 90 2334   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
88 2020-06-24 84 2068 7865 12566 91 2350   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
89 2020-06-23 52 2004 7739 12400 91 2321   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
90 2020-06-22 49 2300 7655 12282 89 2299   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
91 2020-06-21 51 2183 7554 12173 87 2278   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
92 2020-06-20 56 2149 7301 11947 86 2228   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
93 2020-06-19 56 2149 7301 11947 86 2228   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
94 2020-06-18 59 2192 7136 11677 86 2191   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
95 2020-06-17 50 1953 7055 11529 85 2176   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
96 2020-06-16 34 1972 6943 11431 82 2154   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
97 2020-06-15 59 2063 6854 11349 82 2131   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
98 2020-06-14 36 2053 6796 11249 72 2113   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
99 2020-06-13 66 2185 6706 11146 68 2096   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
100 2020-06-12 58 2207 6624 11070 67 2080   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_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,
   [source_url] TEXT
);
Powered by Datasette · Query took 22.601ms · 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_totals