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

58 rows sorted by date descending

View and edit SQL

Suggested facets: staff_active_cases, staff_deaths_note, source_url, date (date)

Link rowid date ▲ 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 source_url
1 2020-07-02 53 1994 9047 13923     93 2524     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
2 2020-07-01 52 2155 8900 13694     92 2496     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
3 2020-06-30 59 2148 9739 13538     92 2480     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
4 2020-06-29 63 2296 8570 13403     91 2460     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
5 2020-06-28 58 2093 8409 13190     91 2433     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
6 2020-06-27 68 2107 8080 12666     86 2341     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
7 2020-06-26 40 2131 2990 12632     86 2339     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
8 2020-06-25 49 2051 7922 12592     90 2334     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
9 2020-06-24 84 2068 7865 12566     91 2350     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
10 2020-06-23 52 2004 7739 12400     91 2321     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
11 2020-06-22 49 2300 7655 12282     89 2299     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
12 2020-06-21 51 2183 7554 12173     87 2278     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
13 2020-06-20 56 2149 7301 11947     86 2228     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
14 2020-06-19 56 2149 7301 11947     86 2228     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
15 2020-06-18 59 2192 7136 11677     86 2191     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
16 2020-06-17 50 1953 7055 11529     85 2176     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
17 2020-06-16 34 1972 6943 11431     82 2154     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
18 2020-06-15 59 2063 6854 11349     82 2131     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
19 2020-06-14 36 2053 6796 11249     72 2113     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
20 2020-06-13 66 2185 6706 11146     68 2096     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
21 2020-06-12 58 2207 6624 11070     67 2080     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
22 2020-06-11 54 2378 6584 11010     67 2068     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
23 2020-06-10 60 2659 6499 10841     67 2041     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
24 2020-06-09 60 2157 6381 10716     64 2003     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
25 2020-06-08 74 2639 6265 10579     62 1985     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
26 2020-06-07 64 2635 6204 10480     60 1972     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-115.aspx
27 2020-06-06 66 2612 6099 10308     57 1958     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-115.aspx
28 2020-06-05 66 2701 5981 10151     56 1933     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
29 2020-06-04 78 2697 5895 10012     55 1908     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
30 2020-06-03 69 2644 5825 9903     54 1874     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
31 2020-06-02 61 2662 5746 9749     52 1835     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
32 2020-06-01 47 2676 5702 9718     49 1807     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
33 2020-05-29 64 2930 5490 9273     45 1735     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
34 2020-05-28 0 0 5429 9209     64 1701     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
35 2020-05-27 0 0 5245 9028     61 1632     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
36 2020-05-22 0 0 0 7908     0 1434     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
37 2020-05-21 0 0 0 7908     0 1434     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
38 2020-05-20 0 0 0 7908     0 1434     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
39 2020-05-18 0 0 2886 4856     26 848     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
40 2020-05-15 0 0 2886 4856     26 848     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
41 2020-05-14 0 0 3492 5971     21 1150     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
42 2020-05-12 0 0 3658 6250     23 1058     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
43 2020-05-11 0 0 3684 6025     19 977     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
44 2020-05-10 0 0 3684 6025     19 977     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
45 2020-05-09 0 0 3665 6060     18 1020     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
46 2020-05-08 0 0 3682 6045     19 1033     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
47 2020-05-07 0 0 3545 5709     19 979     https://web.archive.org/web/20200508055458/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
48 2020-05-06 0 0 3349 5604     17 929     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
49 2020-05-05 0 0 3091 4909     15 748     https://web.archive.org/save/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
50 2020-05-04 0 0 3299 4782     15 733     https://web.archive.org/web/20200505050408/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
51 2020-05-02 0 0 2723 4569     11 644     https://web.archive.org/web/20200503030616/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
52 2020-05-01 0 0 2775 4189     1 658 10 or fewer   https://web.archive.org/save/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
53 2020-04-30 0 0 2697 4711     11 663     https://web.archive.org/save/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
54 2020-04-29 0 0 2594 3923     19 618     https://web.archive.org/save/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
55 2020-04-28 0 0 2323 3515     1 578 10 or fewer   https://web.archive.org/save/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
56 2020-04-25 0 0 2329 3441     1 545 10 or fewer   https://web.archive.org/web/20200427163603/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
57 2020-04-24 0 0 2099 3141     1 486 10 or fewer   https://web.archive.org/web/20200425013213/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
58 2020-04-19 0 0 1279 1721     0 0     https://web.archive.org/web/20200419200914/https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx

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_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT,
   [source_url] TEXT
);
Powered by Datasette · Query took 23.293ms · 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