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.
2,052 rows where fips = 67 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, y, deaths, new_deaths, date (date)
Link | rowid | date ▼ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13339 | 13339 | 2020-03-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | ||
21547 | 21547 | 2020-03-10 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | ||
13340 | 13340 | 2020-03-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21548 | 21548 | 2020-03-11 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13341 | 13341 | 2020-03-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21549 | 21549 | 2020-03-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13342 | 13342 | 2020-03-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21550 | 21550 | 2020-03-13 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13343 | 13343 | 2020-03-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21551 | 21551 | 2020-03-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13344 | 13344 | 2020-03-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21552 | 21552 | 2020-03-15 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13345 | 13345 | 2020-03-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21553 | 21553 | 2020-03-16 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13346 | 13346 | 2020-03-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21554 | 21554 | 2020-03-17 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13347 | 13347 | 2020-03-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21555 | 21555 | 2020-03-18 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13348 | 13348 | 2020-03-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21556 | 21556 | 2020-03-19 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13349 | 13349 | 2020-03-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21557 | 21557 | 2020-03-20 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13350 | 13350 | 2020-03-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21558 | 21558 | 2020-03-21 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13351 | 13351 | 2020-03-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21559 | 21559 | 2020-03-22 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13352 | 13352 | 2020-03-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21560 | 21560 | 2020-03-23 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13353 | 13353 | 2020-03-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21561 | 21561 | 2020-03-24 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13354 | 13354 | 2020-03-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21562 | 21562 | 2020-03-25 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13355 | 13355 | 2020-03-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21563 | 21563 | 2020-03-26 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13356 | 13356 | 2020-03-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21564 | 21564 | 2020-03-27 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13357 | 13357 | 2020-03-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21565 | 21565 | 2020-03-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13358 | 13358 | 2020-03-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21566 | 21566 | 2020-03-29 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13359 | 13359 | 2020-03-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21567 | 21567 | 2020-03-30 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13360 | 13360 | 2020-03-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21568 | 21568 | 2020-03-31 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13361 | 13361 | 2020-04-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21569 | 21569 | 2020-04-01 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13362 | 13362 | 2020-04-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21570 | 21570 | 2020-04-02 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13363 | 13363 | 2020-04-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21571 | 21571 | 2020-04-03 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13364 | 13364 | 2020-04-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21572 | 21572 | 2020-04-04 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13365 | 13365 | 2020-04-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21573 | 21573 | 2020-04-05 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13366 | 13366 | 2020-04-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21574 | 21574 | 2020-04-06 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13367 | 13367 | 2020-04-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21575 | 21575 | 2020-04-07 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13368 | 13368 | 2020-04-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21576 | 21576 | 2020-04-08 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13369 | 13369 | 2020-04-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21577 | 21577 | 2020-04-09 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13370 | 13370 | 2020-04-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21578 | 21578 | 2020-04-10 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13371 | 13371 | 2020-04-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21579 | 21579 | 2020-04-11 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13372 | 13372 | 2020-04-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21580 | 21580 | 2020-04-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13373 | 13373 | 2020-04-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21581 | 21581 | 2020-04-13 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13374 | 13374 | 2020-04-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21582 | 21582 | 2020-04-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13375 | 13375 | 2020-04-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21583 | 21583 | 2020-04-15 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13376 | 13376 | 2020-04-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21584 | 21584 | 2020-04-16 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13377 | 13377 | 2020-04-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21585 | 21585 | 2020-04-17 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13378 | 13378 | 2020-04-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21586 | 21586 | 2020-04-18 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13379 | 13379 | 2020-04-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21587 | 21587 | 2020-04-19 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13380 | 13380 | 2020-04-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21588 | 21588 | 2020-04-20 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13381 | 13381 | 2020-04-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21589 | 21589 | 2020-04-21 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13382 | 13382 | 2020-04-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21590 | 21590 | 2020-04-22 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13383 | 13383 | 2020-04-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21591 | 21591 | 2020-04-23 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13384 | 13384 | 2020-04-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21592 | 21592 | 2020-04-24 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13385 | 13385 | 2020-04-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21593 | 21593 | 2020-04-25 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13386 | 13386 | 2020-04-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21594 | 21594 | 2020-04-26 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13387 | 13387 | 2020-04-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21595 | 21595 | 2020-04-27 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 0 |
13388 | 13388 | 2020-04-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
21596 | 21596 | 2020-04-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | 0 | 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 );