cdcr-prison-totals

Table actions

The cases, resolutions and deaths among inmates at the individual prison facilities operated by the California Department of Corrections and Rehabilitation.

The data is currently limited to July 22, 2020, forward.

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 city

✎ View and edit SQL

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

Link rowid date code name city ▼ county fips zipcode x y confirmed_cases new_confirmed_cases deaths new_deaths
101 101 2020-06-18 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 927 4 0 0
102 102 2020-06-19 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 928 1 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
105 105 2020-06-22 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 931 3 1 0
106 106 2020-06-23 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 932 1 2 1
107 107 2020-06-24 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 933 1 2 0
108 108 2020-06-25 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 935 2 2 0
109 109 2020-06-26 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 938 3 3 1
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
113 113 2020-06-30 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 939 1 3 0
114 114 2020-07-01 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 940 1 3 0
115 115 2020-07-02 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 943 3 3 0
116 116 2020-07-03 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 945 2 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
120 120 2020-07-07 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 946 1 3 0
121 121 2020-07-08 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 951 5 3 0
122 122 2020-07-09 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 952 1 3 0
123 123 2020-07-10 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 954 2 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
126 126 2020-07-13 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 956 2 4 1
127 127 2020-07-14 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 959 3 4 0
128 128 2020-07-15 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 959 0 4 0
129 129 2020-07-16 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 961 2 4 0
130 130 2020-07-17 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1066 105 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
133 133 2020-07-20 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1094 28 4 0
134 134 2020-07-21 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1096 2 4 0
135 135 2020-07-22 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1103 7 4 0
136 136 2020-07-23 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1103 0 4 0
137 137 2020-07-24 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1161 58 5 1
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
140 140 2020-07-27 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1176 15 5 0
141 141 2020-07-28 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1367 191 5 0
142 142 2020-07-29 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1369 2 5 0
143 143 2020-07-30 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1369 0 5 0
144 144 2020-07-31 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1413 44 5 0
145 145 2020-08-01 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1417 4 5 0
146 146 2020-08-02 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1417 0 5 0
147 147 2020-08-03 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1419 2 5 0
148 148 2020-08-04 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1483 64 5 0
149 149 2020-08-05 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1484 1 5 0
150 150 2020-08-06 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1484 0 5 0
151 151 2020-08-07 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1506 22 5 0
152 152 2020-08-08 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1507 1 5 0
153 153 2020-08-09 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1507 0 5 0
154 154 2020-08-10 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1587 80 5 0
155 155 2020-08-11 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1589 2 5 0
156 156 2020-08-12 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1601 12 5 0
157 157 2020-08-13 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1601 0 5 0
158 158 2020-08-14 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1602 1 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
161 161 2020-08-17 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1604 2 5 0
162 162 2020-08-18 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1604 0 5 0
163 163 2020-08-19 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1605 1 5 0
164 164 2020-08-20 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1752 147 5 0
165 165 2020-08-21 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1757 5 5 0
166 166 2020-08-22 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1758 1 5 0
167 167 2020-08-23 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1758 0 5 0
168 168 2020-08-24 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1767 9 5 0
169 169 2020-08-25 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1769 2 5 0
170 170 2020-08-26 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1908 139 5 0
171 171 2020-08-27 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1909 1 5 0
172 172 2020-08-28 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1917 8 5 0
173 173 2020-08-29 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1917 0 5 0
174 174 2020-08-30 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1917 0 5 0
175 175 2020-08-31 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 1925 8 5 0
176 176 2020-09-01 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2089 164 5 0
177 177 2020-09-02 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2105 16 5 0
178 178 2020-09-03 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2172 67 5 0
179 179 2020-09-04 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2237 65 5 0
180 180 2020-09-05 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2238 1 5 0
181 181 2020-09-06 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2238 0 5 0
182 182 2020-09-07 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2238 0 5 0
183 183 2020-09-08 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2248 10 5 0
184 184 2020-09-09 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2267 19 5 0
185 185 2020-09-10 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2268 1 5 0
186 186 2020-09-11 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2278 10 5 0
187 187 2020-09-12 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2279 1 5 0
188 188 2020-09-13 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2280 1 5 0
189 189 2020-09-14 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2281 1 5 0
190 190 2020-09-15 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2289 8 5 0
191 191 2020-09-16 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2432 143 5 0
192 192 2020-09-17 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2443 11 5 0
193 193 2020-09-18 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2499 56 5 0
194 194 2020-09-19 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2499 0 5 0
195 195 2020-09-20 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2499 0 5 0
196 196 2020-09-21 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2530 31 5 0
197 197 2020-09-22 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2600 70 5 0
198 198 2020-09-23 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2645 45 5 0
199 199 2020-09-24 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2657 12 5 0
200 200 2020-09-25 ASP Avenal State Prison Avenal Kings 31 93204 -120.1211248 35.9705041 2662 5 5 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);