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

210 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-12-04 72 2646 26740 33717 161 5148   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
2 2020-12-03 81 2451 26268 33279 160 5123   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
3 2020-12-02 78 2325 25923 32857 160 5098   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
4 2020-11-30 70 2489 25486 32279 159 5059   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
5 2020-11-29 46 2324 25323 31949 158 5047   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
6 2020-11-28 55 2182 25100 31688 157 5034   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
7 2020-11-27 52 2024 24895 31420 157 5014   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
8 2020-11-26 83 1941 24629 31075 156 4996   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
9 2020-11-25 46 1806 24356 30842 156 4970   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
10 2020-11-24 53 1698 24209 30632 155 4954   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
11 2020-11-23 34 1778 24063 30494 155 4934   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
12 2020-11-22 46 1789 23950 30335 155 4921   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
13 2020-11-21 67 1495 23736 30082 155 4907   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
14 2020-11-20 58 1783 23440 29924 155 4892   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
15 2020-11-19 47 1543 23155 29614 155 4876   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
16 2020-11-18 35 1427 22943 29403 155 4861   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
17 2020-11-17 26 1368 22854 29327 155 4848   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
18 2020-11-16 27 1523 22719 29229 154 4836   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
19 2020-11-15 32 1233 22457 28851 154 4817   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
20 2020-11-14 32 1233 22457 28851 154 4817   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
21 2020-11-13 29 1232 22270 28722 154 4802   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
22 2020-11-12 21 1070 22035 28450 154 4793   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
23 2020-11-11 23 1052 21912 28308 154 4789   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
24 2020-11-10 23 1030 21833 28250 154 4779   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
25 2020-11-09 25 1001 21762 28192 154 4770   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
26 2020-11-08 19 998 21688 28143 154 4767   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
27 2020-11-07 24 981 21592 27986 154 4761   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
28 2020-11-06 16 837 21471 27884 154 4753   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
29 2020-11-05 15 726 21355 27721 154 4744   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
30 2020-11-04 13 641 21284 27599 154 4736   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
31 2020-11-03 11 689 21248 27545 154 4729   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
32 2020-11-02 13 681 21202 27511 154 4720   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
33 2020-11-01 17 613 21164 27480 153 4715   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
34 2020-10-31 24 641 21090 27443 153 4710   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
35 2020-10-30 17 696 21006 27411 153 4705   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
36 2020-10-29 11 757 20912 27339 153 4698   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
37 2020-10-28 5 680 20848 27292 153 4692   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
38 2020-10-27 11 716 20821 27259 153 4683   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
39 2020-10-26 15 737 20800 27220 153 4675   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
40 2020-10-25 9 703 20769 27189 153 4668   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
41 2020-10-24 13 663 20714 27141 153 4662   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
42 2020-10-23 8 786 20654 27111 152 4653   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
43 2020-10-22 15 759 20568 27019 151 4650   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
44 2020-10-21 18 726 20528 26960 151 4644   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
45 2020-10-20 12 658 20484 26937 151 4636   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
46 2020-10-19 13 790 20447 26916 152 4629   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
47 2020-10-18 16 720 20422 26866 152 4625   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
48 2020-10-17 14 702 20380 26829 152 4621   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
49 2020-10-16 12 643 20314 26799 152 4605   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
50 2020-10-15 8 673 20245 26721 152 4596   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
51 2020-10-14 5 563 20194 26647 152 4591   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
52 2020-10-13 6 722 20167 26603 152 4582   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
53 2020-10-12 7 701 20133 26577 152 4573   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
54 2020-10-11 2 682 20089 26547 152 4572   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
55 2020-10-10 5 747 20043 26502 152 4564   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
56 2020-10-09 6 767 19989 26456 152 4557   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
57 2020-10-08 12 748 19952 26421 152 4549   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
58 2020-10-07 15 773 19884 26350 152 4540   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
59 2020-10-06 9 817 19847 26313 151 4522   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
60 2020-10-05 10 846 19832 26291 151 4510   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
61 2020-10-04 8 869 19795 26248 151 4505   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
62 2020-10-03 14 901 19735 26209 150 4493   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
63 2020-10-02 17 920 19674 26168 150 4488   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
64 2020-10-01 21 949 19617 26104 149 4475   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
65 2020-09-30 19 929 19529 26037 149 4469   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
66 2020-09-29 22 981 19492 25991 149 4457   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
67 2020-09-28 22 1058 19459 25955 149 4439   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
68 2020-09-27 34 966 19416 25868 149 4429   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
69 2020-09-26 24 941 19358 25835 149 4418   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
70 2020-09-25 29 987 19290 25782 149 4412   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
71 2020-09-24 22 933 19185 25695 149 4401   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
72 2020-09-23 23 904 19119 25638 148 4393   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
73 2020-09-22 27 1000 19085 25569 149 4384   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
74 2020-09-21 28 1068 19047 25479 149 4375   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
75 2020-09-20 28 1077 19009 25444 148 4368   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
76 2020-09-19 32 967 18958 25396 147 4357   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
77 2020-09-18 28 918 18883 25338 147 4345   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
78 2020-09-17 29 1067 18784 25234 147 4340   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
79 2020-09-16 38 1094 18739 25184 146 4326   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
80 2020-09-15 32 1234 18691 25132 146 4308   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
81 2020-09-14 39 1275 18647 25099 146 4296   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
82 2020-09-13 32 1367 18593 25044 144 4288   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
83 2020-09-12 36 1153 18538 24939 143 4282   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
84 2020-09-11 42 1251 18465 24867 143 4271   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
85 2020-09-10 32 1410 18406 24756 142 4257   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
86 2020-09-09 30 1469 18366 24757 142 4244   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
87 2020-09-08 32 1499 18332 24731 141 4221   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
88 2020-09-07 49 1607 18295 24678 141 4210   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
89 2020-09-06 41 1578 18251 24618 141 4200   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
90 2020-09-05 52 1598 18155 24426 141 4183   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
91 2020-09-04 43 1563 18031 24314 141 4168   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
92 2020-09-03 44 1674 17955 24206 139 4151   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
93 2020-09-02 51 1838 17874 24123 139 4123   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
94 2020-09-01 57 1835 17831 24061 139 4104   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
95 2020-08-31 44 2019 17788 23986 139 4078   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
96 2020-08-30 49 2006 17727 23904 139 4065   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
97 2020-08-29 57 2010 17632 23816 139 4048   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
98 2020-08-28 53 2025 17498 23670 141 4028   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
99 2020-08-27 64 2131 17381 23541 139 4000   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
100 2020-08-26 68 2151 17280 23402 141 3976   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
);