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)
name 35 ✖
- 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
- Avenal State Prison 926
Link | rowid | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases ▼ | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
167 | 167 | 2020-08-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1758 | 0 | 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 |
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 |
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 |
201 | 201 | 2020-09-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2662 | 0 | 6 | 1 |
202 | 202 | 2020-09-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2662 | 0 | 6 | 0 |
209 | 209 | 2020-10-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2842 | 0 | 7 | 0 |
214 | 214 | 2020-10-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2937 | 0 | 7 | 0 |
216 | 216 | 2020-10-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2938 | 0 | 7 | 0 |
218 | 218 | 2020-10-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
219 | 219 | 2020-10-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
220 | 220 | 2020-10-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
221 | 221 | 2020-10-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
222 | 222 | 2020-10-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
223 | 223 | 2020-10-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
229 | 229 | 2020-10-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2953 | 0 | 7 | 0 |
230 | 230 | 2020-10-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2953 | 0 | 7 | 0 |
232 | 232 | 2020-10-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2968 | 0 | 7 | 0 |
233 | 233 | 2020-10-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2968 | 0 | 7 | 0 |
236 | 236 | 2020-10-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 0 | 8 | 0 |
237 | 237 | 2020-11-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 0 | 8 | 0 |
240 | 240 | 2020-11-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2984 | 0 | 8 | 0 |
243 | 243 | 2020-11-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 0 | 8 | 0 |
244 | 244 | 2020-11-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 0 | 8 | 0 |
245 | 245 | 2020-11-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 0 | 8 | 0 |
247 | 247 | 2020-11-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2994 | 0 | 8 | 0 |
250 | 250 | 2020-11-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 0 | 8 | 0 |
251 | 251 | 2020-11-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 0 | 8 | 0 |
252 | 252 | 2020-11-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 0 | 8 | 0 |
256 | 256 | 2020-11-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 0 | 8 | 0 |
257 | 257 | 2020-11-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 0 | 8 | 0 |
258 | 258 | 2020-11-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 0 | 8 | 0 |
260 | 260 | 2020-11-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3005 | 0 | 8 | 0 |
262 | 262 | 2020-11-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
263 | 263 | 2020-11-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
264 | 264 | 2020-11-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
265 | 265 | 2020-11-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
266 | 266 | 2020-11-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
269 | 269 | 2020-12-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3012 | 0 | 8 | 0 |
271 | 271 | 2020-12-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3013 | 0 | 8 | 0 |
272 | 272 | 2020-12-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3013 | 0 | 8 | 0 |
274 | 274 | 2020-12-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3014 | 0 | 8 | 0 |
277 | 277 | 2020-12-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 0 | 8 | 0 |
278 | 278 | 2020-12-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 0 | 8 | 0 |
279 | 279 | 2020-12-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 0 | 8 | 0 |
281 | 281 | 2020-12-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3038 | 0 | 8 | 0 |
285 | 285 | 2020-12-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 0 | 8 | 0 |
286 | 286 | 2020-12-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 0 | 8 | 0 |
288 | 288 | 2020-12-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3094 | 0 | 8 | 0 |
290 | 290 | 2020-12-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
291 | 291 | 2020-12-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
292 | 292 | 2020-12-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
293 | 293 | 2020-12-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
295 | 295 | 2020-12-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3104 | 0 | 8 | 0 |
298 | 298 | 2021-01-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 0 |
299 | 299 | 2021-01-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 0 |
300 | 300 | 2021-01-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 0 |
301 | 301 | 2021-01-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 0 |
303 | 303 | 2021-01-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3114 | 0 | 8 | 0 |
305 | 305 | 2021-01-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3115 | 0 | 8 | 0 |
307 | 307 | 2021-01-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3116 | 0 | 8 | 0 |
310 | 310 | 2021-01-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 0 | 8 | 0 |
311 | 311 | 2021-01-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 0 | 8 | 0 |
312 | 312 | 2021-01-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 0 | 8 | 0 |
313 | 313 | 2021-01-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 0 | 8 | 0 |
314 | 314 | 2021-01-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 0 | 8 | 0 |
316 | 316 | 2021-01-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3125 | 0 | 8 | 0 |
317 | 317 | 2021-01-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3125 | 0 | 8 | 0 |
318 | 318 | 2021-01-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3125 | 0 | 8 | 0 |
321 | 321 | 2021-01-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3127 | 0 | 8 | 0 |
322 | 322 | 2021-01-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3127 | 0 | 8 | 0 |
324 | 324 | 2021-01-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3129 | 0 | 8 | 0 |
325 | 325 | 2021-01-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3129 | 0 | 8 | 0 |
326 | 326 | 2021-01-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3129 | 0 | 8 | 0 |
328 | 328 | 2021-01-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
329 | 329 | 2021-02-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
330 | 330 | 2021-02-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
331 | 331 | 2021-02-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
332 | 332 | 2021-02-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
333 | 333 | 2021-02-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
334 | 334 | 2021-02-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
335 | 335 | 2021-02-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
336 | 336 | 2021-02-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
337 | 337 | 2021-02-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
338 | 338 | 2021-02-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
339 | 339 | 2021-02-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
340 | 340 | 2021-02-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
341 | 341 | 2021-02-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
342 | 342 | 2021-02-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
343 | 343 | 2021-02-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
344 | 344 | 2021-02-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
345 | 345 | 2021-02-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
346 | 346 | 2021-02-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
347 | 347 | 2021-02-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
348 | 348 | 2021-02-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
349 | 349 | 2021-02-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 0 |
350 | 350 | 2021-02-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 0 | 8 | 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 );