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.
1,178 rows where deaths = 8 and new_deaths = 0
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, city, county, fips, x, y, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
238 | 238 | 2020-11-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2983 | 12 | 8 | 0 |
239 | 239 | 2020-11-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2984 | 1 | 8 | 0 |
240 | 240 | 2020-11-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2984 | 0 | 8 | 0 |
241 | 241 | 2020-11-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2986 | 2 | 8 | 0 |
242 | 242 | 2020-11-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 5 | 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 |
246 | 246 | 2020-11-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2994 | 3 | 8 | 0 |
247 | 247 | 2020-11-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2994 | 0 | 8 | 0 |
248 | 248 | 2020-11-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2995 | 1 | 8 | 0 |
249 | 249 | 2020-11-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 1 | 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 |
253 | 253 | 2020-11-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2999 | 3 | 8 | 0 |
254 | 254 | 2020-11-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3001 | 2 | 8 | 0 |
255 | 255 | 2020-11-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 1 | 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 |
259 | 259 | 2020-11-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3005 | 3 | 8 | 0 |
260 | 260 | 2020-11-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3005 | 0 | 8 | 0 |
261 | 261 | 2020-11-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 1 | 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 |
267 | 267 | 2020-12-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3007 | 1 | 8 | 0 |
268 | 268 | 2020-12-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3012 | 5 | 8 | 0 |
269 | 269 | 2020-12-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3012 | 0 | 8 | 0 |
270 | 270 | 2020-12-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3013 | 1 | 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 |
273 | 273 | 2020-12-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3014 | 1 | 8 | 0 |
274 | 274 | 2020-12-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3014 | 0 | 8 | 0 |
275 | 275 | 2020-12-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3015 | 1 | 8 | 0 |
276 | 276 | 2020-12-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 1 | 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 |
280 | 280 | 2020-12-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3038 | 22 | 8 | 0 |
281 | 281 | 2020-12-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3038 | 0 | 8 | 0 |
282 | 282 | 2020-12-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3040 | 2 | 8 | 0 |
283 | 283 | 2020-12-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3067 | 27 | 8 | 0 |
284 | 284 | 2020-12-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 2 | 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 |
287 | 287 | 2020-12-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3094 | 25 | 8 | 0 |
288 | 288 | 2020-12-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3094 | 0 | 8 | 0 |
289 | 289 | 2020-12-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 1 | 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 |
294 | 294 | 2020-12-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3104 | 9 | 8 | 0 |
295 | 295 | 2020-12-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3104 | 0 | 8 | 0 |
296 | 296 | 2020-12-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3105 | 1 | 8 | 0 |
297 | 297 | 2020-12-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 5 | 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 |
302 | 302 | 2021-01-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3114 | 4 | 8 | 0 |
303 | 303 | 2021-01-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3114 | 0 | 8 | 0 |
304 | 304 | 2021-01-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3115 | 1 | 8 | 0 |
305 | 305 | 2021-01-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3115 | 0 | 8 | 0 |
306 | 306 | 2021-01-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3116 | 1 | 8 | 0 |
307 | 307 | 2021-01-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3116 | 0 | 8 | 0 |
308 | 308 | 2021-01-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3117 | 1 | 8 | 0 |
309 | 309 | 2021-01-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 6 | 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 |
315 | 315 | 2021-01-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3125 | 2 | 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 |
319 | 319 | 2021-01-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3126 | 1 | 8 | 0 |
320 | 320 | 2021-01-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3127 | 1 | 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 |
323 | 323 | 2021-01-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3129 | 2 | 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 |
327 | 327 | 2021-01-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3130 | 1 | 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 |
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 );