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.
5,525 rows where deaths = 1 and new_deaths = 0
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, city, fips, zipcode, y, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
1332 | 1332 | 2021-01-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 924 | 0 | 1 | 0 |
1333 | 1333 | 2021-01-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 924 | 0 | 1 | 0 |
1334 | 1334 | 2021-01-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 932 | 8 | 1 | 0 |
1335 | 1335 | 2021-01-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 933 | 1 | 1 | 0 |
3371 | 3371 | 2020-12-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1221 | 4 | 1 | 0 |
3372 | 3372 | 2020-12-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1224 | 3 | 1 | 0 |
3373 | 3373 | 2020-12-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1236 | 12 | 1 | 0 |
4274 | 4274 | 2020-08-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4275 | 4275 | 2020-08-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4276 | 4276 | 2020-08-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4277 | 4277 | 2020-08-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4278 | 4278 | 2020-08-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4279 | 4279 | 2020-08-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4280 | 4280 | 2020-09-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4281 | 4281 | 2020-09-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 1 | 1 | 0 |
4282 | 4282 | 2020-09-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4283 | 4283 | 2020-09-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4284 | 4284 | 2020-09-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4285 | 4285 | 2020-09-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4286 | 4286 | 2020-09-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4287 | 4287 | 2020-09-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4288 | 4288 | 2020-09-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4289 | 4289 | 2020-09-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4290 | 4290 | 2020-09-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4291 | 4291 | 2020-09-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4292 | 4292 | 2020-09-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4293 | 4293 | 2020-09-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4294 | 4294 | 2020-09-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4295 | 4295 | 2020-09-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4296 | 4296 | 2020-09-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4297 | 4297 | 2020-09-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4298 | 4298 | 2020-09-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4299 | 4299 | 2020-09-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4300 | 4300 | 2020-09-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4301 | 4301 | 2020-09-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4302 | 4302 | 2020-09-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4303 | 4303 | 2020-09-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4304 | 4304 | 2020-09-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4305 | 4305 | 2020-09-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4306 | 4306 | 2020-09-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4307 | 4307 | 2020-09-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4308 | 4308 | 2020-09-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4309 | 4309 | 2020-09-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4310 | 4310 | 2020-10-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4311 | 4311 | 2020-10-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4312 | 4312 | 2020-10-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4313 | 4313 | 2020-10-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4314 | 4314 | 2020-10-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4315 | 4315 | 2020-10-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4316 | 4316 | 2020-10-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4317 | 4317 | 2020-10-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4318 | 4318 | 2020-10-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4319 | 4319 | 2020-10-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4320 | 4320 | 2020-10-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4321 | 4321 | 2020-10-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4322 | 4322 | 2020-10-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4323 | 4323 | 2020-10-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4324 | 4324 | 2020-10-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4325 | 4325 | 2020-10-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 8 | 1 | 1 | 0 |
4326 | 4326 | 2020-10-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 8 | 0 | 1 | 0 |
4327 | 4327 | 2020-10-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 1 | 1 | 0 |
4328 | 4328 | 2020-10-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4329 | 4329 | 2020-10-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4330 | 4330 | 2020-10-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4331 | 4331 | 2020-10-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4332 | 4332 | 2020-10-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4333 | 4333 | 2020-10-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4334 | 4334 | 2020-10-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 0 | 1 | 0 |
4335 | 4335 | 2020-10-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 1 | 1 | 0 |
4336 | 4336 | 2020-10-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4337 | 4337 | 2020-10-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4338 | 4338 | 2020-10-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4339 | 4339 | 2020-10-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4340 | 4340 | 2020-10-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4341 | 4341 | 2020-11-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4342 | 4342 | 2020-11-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4343 | 4343 | 2020-11-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4344 | 4344 | 2020-11-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4345 | 4345 | 2020-11-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4346 | 4346 | 2020-11-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4347 | 4347 | 2020-11-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4348 | 4348 | 2020-11-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4349 | 4349 | 2020-11-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4350 | 4350 | 2020-11-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4351 | 4351 | 2020-11-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4352 | 4352 | 2020-11-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 0 | 1 | 0 |
4353 | 4353 | 2020-11-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 11 | 1 | 1 | 0 |
4354 | 4354 | 2020-11-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 11 | 0 | 1 | 0 |
4355 | 4355 | 2020-11-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 12 | 1 | 1 | 0 |
4356 | 4356 | 2020-11-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 14 | 2 | 1 | 0 |
4357 | 4357 | 2020-11-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 17 | 3 | 1 | 0 |
4358 | 4358 | 2020-11-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 18 | 1 | 1 | 0 |
4359 | 4359 | 2020-11-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 20 | 2 | 1 | 0 |
4360 | 4360 | 2020-11-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 22 | 2 | 1 | 0 |
4361 | 4361 | 2020-11-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 22 | 0 | 1 | 0 |
4362 | 4362 | 2020-11-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 22 | 0 | 1 | 0 |
4363 | 4363 | 2020-11-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 23 | 1 | 1 | 0 |
4364 | 4364 | 2020-11-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 23 | 0 | 1 | 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 );