cdcr-prison-totals
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.
- code
- The unique identifier of the prison institution.
- name
- The name of the prison institution.
- city
- The city where the prison institution is located.
- county
- The county where the prison institution is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- zipcode
- The ZIP Code where the agency is located.
- x
- The longitude of the area's centroid.
- y
- The latitude of the area's centroid.
- 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.
- deaths
- The cumulative number of deaths at that time.
- new_deaths
- The net change in deaths over the previous date.
35,910 rows sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, city, zipcode, deaths, date (date)
new_confirmed_cases 186 ✖
- 0 26,750
- 1 3,337
- 2 1,376
- 3 788
- 4 554
- 5 408
- 6 287
- 7 200
- 8 178
- 9 159
- 10 127
- 11 117
- 12 97
- 13 94
- 14 72
- 16 64
- 17 62
- 15 59
- 19 54
- 18 50
- 22 48
- 21 41
- 20 39
- 23 39
- - 35
- 27 33
- 24 26
- 25 26
- 28 24
- 29 24
- 36 24
- 31 23
- 32 22
- 39 22
- 26 21
- 34 21
- 38 19
- 42 19
- 49 19
- 40 16
- 30 15
- 41 14
- 45 14
- 46 14
- 48 14
- 35 13
- 37 13
- 57 13
- 65 13
- 33 12
- 50 12
- 62 12
- 52 11
- 60 11
- 47 10
- 51 10
- 58 10
- 55 9
- 56 9
- 44 8
- 53 8
- 82 8
- 67 7
- 79 7
- 99 7
- 118 7
- 43 6
- 74 6
- 54 5
- 61 5
- 63 5
- 64 5
- 78 5
- 81 5
- 66 4
- 68 4
- 70 4
- 71 4
- 80 4
- 85 4
- 89 4
- 91 4
- 92 4
- 98 4
- 105 4
- 107 4
- 115 4
- 131 4
- 76 3
- 83 3
- 84 3
- 88 3
- 95 3
- 102 3
- 103 3
- 109 3
- 110 3
- 114 3
- 116 3
- 128 3
- 134 3
- 139 3
- 147 3
- 159 3
- 163 3
- 241 3
- 59 2
- 72 2
- 73 2
- 75 2
- 87 2
- 90 2
- 93 2
- 94 2
- 96 2
- 101 2
- 104 2
- 106 2
- 111 2
- 125 2
- 127 2
- 129 2
- 136 2
- 143 2
- 158 2
- 167 2
- 181 2
- 238 2
- 271 2
- 69 1
- 77 1
- 86 1
- 100 1
- 108 1
- 112 1
- 113 1
- 120 1
- 121 1
- 124 1
- 126 1
- 130 1
- 133 1
- 135 1
- 144 1
- 145 1
- 146 1
- 149 1
- 150 1
- 152 1
- 156 1
- 157 1
- 162 1
- 164 1
- 165 1
- 166 1
- 168 1
- 171 1
- 174 1
- 180 1
- 182 1
- 183 1
- 185 1
- 186 1
- 187 1
- 191 1
- 192 1
- 194 1
- 197 1
- 199 1
- 202 1
- 205 1
- 209 1
- 220 1
- 231 1
- 240 1
- 246 1
- 254 1
- 261 1
- 263 1
- 266 1
- 297 1
- 320 1
- 331 1
- 346 1
- 428 1
- 494 1
name 35 ✖
- Avenal State Prison 1,026
- California City Correctional Facility 1,026
- California Correctional Center 1,026
- California Correctional Institution 1,026
- California Health Care Facility 1,026
- California Institution for Men 1,026
- California Institution for Women 1,026
- California Medical Facility 1,026
- California Men's Colony 1,026
- California Rehabilitation Center 1,026
- California State Prison, Centinela 1,026
- California State Prison, Corcoran 1,026
- California State Prison, Los Angeles 1,026
- California State Prison, Sacramento 1,026
- California State Prison, Solano 1,026
- California Substance Abuse Treatment Facility and State Prison, Corcoran 1,026
- Calipatria State Prison 1,026
- Central California Women's Facility 1,026
- Chuckawalla Valley State Prison 1,026
- Correctional Training Facility 1,026
- Deuel Vocational Institute 1,026
- Folsom State Prison 1,026
- High Desert State Prison 1,026
- Ironwood State Prison 1,026
- Kern Valley State Prison 1,026
- Mule Creek State Prison 1,026
- North Kern State Prison 1,026
- Pelican Bay State Prison 1,026
- Pleasant Valley State Prison 1,026
- Richard J. Donovan Correctional Facility 1,026
- Salinas Valley State Prison 1,026
- San Quentin State Prison 1,026
- Sierra Conservation Center 1,026
- Valley State Prison 1,026
- Wasco State Prison 1,026
Link | rowid | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases ▼ | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 2020-03-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
3 | 3 | 2020-03-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
4 | 4 | 2020-03-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
5 | 5 | 2020-03-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
6 | 6 | 2020-03-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
7 | 7 | 2020-03-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
8 | 8 | 2020-03-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
9 | 9 | 2020-03-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
10 | 10 | 2020-03-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11 | 11 | 2020-03-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
12 | 12 | 2020-03-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
13 | 13 | 2020-03-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
14 | 14 | 2020-03-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
15 | 15 | 2020-03-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
16 | 16 | 2020-03-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
17 | 17 | 2020-03-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
18 | 18 | 2020-03-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
19 | 19 | 2020-03-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
20 | 20 | 2020-03-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
21 | 21 | 2020-03-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
22 | 22 | 2020-03-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
23 | 23 | 2020-04-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
24 | 24 | 2020-04-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
25 | 25 | 2020-04-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
26 | 26 | 2020-04-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
27 | 27 | 2020-04-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
28 | 28 | 2020-04-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
29 | 29 | 2020-04-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
30 | 30 | 2020-04-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
31 | 31 | 2020-04-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
32 | 32 | 2020-04-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
33 | 33 | 2020-04-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
34 | 34 | 2020-04-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
35 | 35 | 2020-04-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
36 | 36 | 2020-04-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
37 | 37 | 2020-04-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
38 | 38 | 2020-04-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
39 | 39 | 2020-04-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
40 | 40 | 2020-04-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
41 | 41 | 2020-04-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
42 | 42 | 2020-04-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
43 | 43 | 2020-04-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
44 | 44 | 2020-04-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
45 | 45 | 2020-04-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
46 | 46 | 2020-04-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
47 | 47 | 2020-04-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
48 | 48 | 2020-04-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
49 | 49 | 2020-04-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
50 | 50 | 2020-04-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
51 | 51 | 2020-04-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
52 | 52 | 2020-04-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
53 | 53 | 2020-05-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
54 | 54 | 2020-05-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
55 | 55 | 2020-05-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
56 | 56 | 2020-05-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
57 | 57 | 2020-05-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
58 | 58 | 2020-05-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
59 | 59 | 2020-05-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
60 | 60 | 2020-05-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
61 | 61 | 2020-05-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
62 | 62 | 2020-05-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
63 | 63 | 2020-05-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
64 | 64 | 2020-05-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
65 | 65 | 2020-05-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
66 | 66 | 2020-05-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
67 | 67 | 2020-05-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
68 | 68 | 2020-05-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
69 | 69 | 2020-05-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
75 | 75 | 2020-05-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 199 | 0 | 0 | 0 |
76 | 76 | 2020-05-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 199 | 0 | 0 | 0 |
77 | 77 | 2020-05-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 199 | 0 | 0 | 0 |
82 | 82 | 2020-05-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 600 | 0 | 0 | 0 |
83 | 83 | 2020-05-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 600 | 0 | 0 | 0 |
87 | 87 | 2020-06-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 840 | 0 | 0 | 0 |
90 | 90 | 2020-06-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 844 | 0 | 0 | 0 |
97 | 97 | 2020-06-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 916 | 0 | 0 | 0 |
103 | 103 | 2020-06-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 928 | 0 | 1 | 1 |
104 | 104 | 2020-06-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 928 | 0 | 1 | 0 |
110 | 110 | 2020-06-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 0 | 3 | 0 |
111 | 111 | 2020-06-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 0 | 3 | 0 |
112 | 112 | 2020-06-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 0 | 3 | 0 |
117 | 117 | 2020-07-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 0 | 3 | 0 |
118 | 118 | 2020-07-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 0 | 3 | 0 |
119 | 119 | 2020-07-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 0 | 3 | 0 |
124 | 124 | 2020-07-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 954 | 0 | 3 | 0 |
125 | 125 | 2020-07-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 954 | 0 | 3 | 0 |
128 | 128 | 2020-07-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 959 | 0 | 4 | 0 |
131 | 131 | 2020-07-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1066 | 0 | 4 | 0 |
132 | 132 | 2020-07-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1066 | 0 | 4 | 0 |
136 | 136 | 2020-07-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1103 | 0 | 4 | 0 |
138 | 138 | 2020-07-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1161 | 0 | 5 | 0 |
139 | 139 | 2020-07-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1161 | 0 | 5 | 0 |
143 | 143 | 2020-07-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1369 | 0 | 5 | 0 |
146 | 146 | 2020-08-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1417 | 0 | 5 | 0 |
150 | 150 | 2020-08-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1484 | 0 | 5 | 0 |
153 | 153 | 2020-08-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1507 | 0 | 5 | 0 |
157 | 157 | 2020-08-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1601 | 0 | 5 | 0 |
159 | 159 | 2020-08-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1602 | 0 | 5 | 0 |
160 | 160 | 2020-08-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1602 | 0 | 5 | 0 |
162 | 162 | 2020-08-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1604 | 0 | 5 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdcr-prison-totals" ( [date] TEXT, [code] TEXT, [name] TEXT, [city] TEXT, [county] TEXT, [fips] INTEGER, [zipcode] INTEGER, [x] FLOAT, [y] FLOAT, [confirmed_cases] INTEGER, [new_confirmed_cases] INTEGER, [deaths] INTEGER, [new_deaths] INTEGER );