home / la-times

Menu
  • GraphQL API

cdcr-state-totals

Table actions
  • GraphQL API for cdcr-state-totals

The total number of cases amoung inmates at prisons run by the California Department of Corrections and Rehabiliation.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

date
The date when the data were collected in ISO 8601 format.
confirmed_cases
The cumulative number of confirmed coronavirus case at that time.
new_confirmed_cases
The net change in confirmed cases over the previous date.

1,026 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date confirmed_cases new_confirmed_cases
1 1 2020-03-10 0 0
2 2 2020-03-11 0 0
3 3 2020-03-12 0 0
4 4 2020-03-13 0 0
5 5 2020-03-14 0 0
6 6 2020-03-15 0 0
7 7 2020-03-16 0 0
8 8 2020-03-17 0 0
9 9 2020-03-18 0 0
10 10 2020-03-19 0 0
11 11 2020-03-20 1 1
12 12 2020-03-21 1 0
13 13 2020-03-22 1 0
14 14 2020-03-23 1 0
15 15 2020-03-24 1 0
16 16 2020-03-25 1 0
17 17 2020-03-26 3 2
18 18 2020-03-27 5 2
19 19 2020-03-28 5 0
20 20 2020-03-29 5 0
21 21 2020-03-30 10 5
22 22 2020-03-31 11 1
23 23 2020-04-01 13 2
24 24 2020-04-02 16 3
25 25 2020-04-03 19 3
26 26 2020-04-04 24 5
27 27 2020-04-05 28 4
28 28 2020-04-06 32 4
29 29 2020-04-07 36 4
30 30 2020-04-08 41 5
31 31 2020-04-09 50 9
32 32 2020-04-10 57 7
33 33 2020-04-11 62 5
34 34 2020-04-12 66 4
35 35 2020-04-13 74 8
36 36 2020-04-14 75 1
37 37 2020-04-15 84 9
38 38 2020-04-16 117 33
39 39 2020-04-17 122 5
40 40 2020-04-18 128 6
41 41 2020-04-19 137 9
42 42 2020-04-20 141 4
43 43 2020-04-21 155 14
44 44 2020-04-22 167 12
45 45 2020-04-23 175 8
46 46 2020-04-24 192 17
47 47 2020-04-25 197 5
48 48 2020-04-26 201 4
49 49 2020-04-27 215 14
50 50 2020-04-28 230 15
51 51 2020-04-29 244 14
52 52 2020-04-30 253 9
53 53 2020-05-01 387 134
54 54 2020-05-02 393 6
55 55 2020-05-03 394 1
56 56 2020-05-04 396 2
57 57 2020-05-05 460 64
58 58 2020-05-06 467 7
59 59 2020-05-07 512 45
60 60 2020-05-08 568 56
61 61 2020-05-09 570 2
62 62 2020-05-10 570 0
63 63 2020-05-11 578 8
64 64 2020-05-12 585 7
65 65 2020-05-13 658 73
66 66 2020-05-14 777 119
67 67 2020-05-15 889 112
68 68 2020-05-16 900 11
69 69 2020-05-17 907 7
70 70 2020-05-18 969 62
71 71 2020-05-19 1004 35
72 72 2020-05-20 1026 22
73 73 2020-05-21 1186 160
74 74 2020-05-22 1220 34
75 75 2020-05-23 1221 1
76 76 2020-05-24 1226 5
77 77 2020-05-25 1231 5
78 78 2020-05-26 1294 63
79 79 2020-05-27 1594 300
80 80 2020-05-28 1800 206
81 81 2020-05-29 2376 576
82 82 2020-05-30 2382 6
83 83 2020-05-31 2400 18
84 84 2020-06-01 2431 31
85 85 2020-06-02 2863 432
86 86 2020-06-03 2885 22
87 87 2020-06-04 2936 51
88 88 2020-06-05 2988 52
89 89 2020-06-06 3039 51
90 90 2020-06-07 3040 1
91 91 2020-06-08 3061 21
92 92 2020-06-09 3141 80
93 93 2020-06-10 3193 52
94 94 2020-06-11 3217 24
95 95 2020-06-12 3250 33
96 96 2020-06-13 3279 29
97 97 2020-06-14 3279 0
98 98 2020-06-15 3459 180
99 99 2020-06-16 3644 185
100 100 2020-06-17 3683 39

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cdcr-state-totals" (
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [new_confirmed_cases] INTEGER
);
Powered by Datasette · Queries took 11.157ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README