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,446 rows where deaths = 9 sorted by city
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, code, city, county, fips, x, y, new_confirmed_cases, new_deaths, date (date)
name 10 ✖
- Chuckawalla Valley State Prison 752
- Mule Creek State Prison 660
- California Institution for Men 7
- Correctional Training Facility 7
- California Medical Facility 6
- California Health Care Facility 4
- San Quentin State Prison 4
- California State Prison, Los Angeles 3
- California Men's Colony 2
- Richard J. Donovan Correctional Facility 1
Link | rowid | date | code | name | city ▼ | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18743 | 18743 | 2020-12-09 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1796 | 0 | 9 | 1 |
18744 | 18744 | 2020-12-10 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1796 | 0 | 9 | 0 |
18745 | 18745 | 2020-12-11 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1796 | 0 | 9 | 0 |
18746 | 18746 | 2020-12-12 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1796 | 0 | 9 | 0 |
18747 | 18747 | 2020-12-13 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1796 | 0 | 9 | 0 |
18748 | 18748 | 2020-12-14 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1796 | 0 | 9 | 0 |
18749 | 18749 | 2020-12-15 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 2 | 9 | 0 |
18750 | 18750 | 2020-12-16 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18751 | 18751 | 2020-12-17 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18752 | 18752 | 2020-12-18 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18753 | 18753 | 2020-12-19 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18754 | 18754 | 2020-12-20 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18755 | 18755 | 2020-12-21 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18756 | 18756 | 2020-12-22 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18757 | 18757 | 2020-12-23 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18758 | 18758 | 2020-12-24 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18759 | 18759 | 2020-12-25 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18760 | 18760 | 2020-12-26 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18761 | 18761 | 2020-12-27 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18762 | 18762 | 2020-12-28 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18763 | 18763 | 2020-12-29 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18764 | 18764 | 2020-12-30 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18765 | 18765 | 2020-12-31 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18766 | 18766 | 2021-01-01 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18767 | 18767 | 2021-01-02 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18768 | 18768 | 2021-01-03 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18769 | 18769 | 2021-01-04 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18770 | 18770 | 2021-01-05 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18771 | 18771 | 2021-01-06 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18772 | 18772 | 2021-01-07 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18773 | 18773 | 2021-01-08 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18774 | 18774 | 2021-01-09 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18775 | 18775 | 2021-01-10 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18776 | 18776 | 2021-01-11 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18777 | 18777 | 2021-01-12 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18778 | 18778 | 2021-01-13 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18779 | 18779 | 2021-01-14 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18780 | 18780 | 2021-01-15 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18781 | 18781 | 2021-01-16 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18782 | 18782 | 2021-01-17 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18783 | 18783 | 2021-01-18 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18784 | 18784 | 2021-01-19 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18785 | 18785 | 2021-01-20 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18786 | 18786 | 2021-01-21 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18787 | 18787 | 2021-01-22 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18788 | 18788 | 2021-01-23 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18789 | 18789 | 2021-01-24 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18790 | 18790 | 2021-01-25 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18791 | 18791 | 2021-01-26 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18792 | 18792 | 2021-01-27 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18793 | 18793 | 2021-01-28 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18794 | 18794 | 2021-01-29 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18795 | 18795 | 2021-01-30 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18796 | 18796 | 2021-01-31 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18797 | 18797 | 2021-02-01 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1798 | 0 | 9 | 0 |
18798 | 18798 | 2021-02-02 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 1 | 9 | 0 |
18799 | 18799 | 2021-02-03 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18800 | 18800 | 2021-02-04 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18801 | 18801 | 2021-02-05 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18802 | 18802 | 2021-02-06 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18803 | 18803 | 2021-02-07 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18804 | 18804 | 2021-02-08 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18805 | 18805 | 2021-02-09 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18806 | 18806 | 2021-02-10 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18807 | 18807 | 2021-02-11 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1799 | 0 | 9 | 0 |
18808 | 18808 | 2021-02-12 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 1 | 9 | 0 |
18809 | 18809 | 2021-02-13 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18810 | 18810 | 2021-02-14 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18811 | 18811 | 2021-02-15 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18812 | 18812 | 2021-02-16 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18813 | 18813 | 2021-02-17 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18814 | 18814 | 2021-02-18 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18815 | 18815 | 2021-02-19 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18816 | 18816 | 2021-02-20 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18817 | 18817 | 2021-02-21 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18818 | 18818 | 2021-02-22 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18819 | 18819 | 2021-02-23 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18820 | 18820 | 2021-02-24 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1800 | 0 | 9 | 0 |
18821 | 18821 | 2021-02-25 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1801 | 1 | 9 | 0 |
18822 | 18822 | 2021-02-26 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1801 | 0 | 9 | 0 |
18823 | 18823 | 2021-02-27 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1801 | 0 | 9 | 0 |
18824 | 18824 | 2021-02-28 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1801 | 0 | 9 | 0 |
18825 | 18825 | 2021-03-01 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1801 | 0 | 9 | 0 |
18826 | 18826 | 2021-03-02 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 1 | 9 | 0 |
18827 | 18827 | 2021-03-03 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18828 | 18828 | 2021-03-04 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18829 | 18829 | 2021-03-05 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18830 | 18830 | 2021-03-06 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18831 | 18831 | 2021-03-07 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18832 | 18832 | 2021-03-08 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18833 | 18833 | 2021-03-09 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18834 | 18834 | 2021-03-10 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18835 | 18835 | 2021-03-11 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18836 | 18836 | 2021-03-12 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18837 | 18837 | 2021-03-13 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18838 | 18838 | 2021-03-14 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18839 | 18839 | 2021-03-15 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18840 | 18840 | 2021-03-16 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18841 | 18841 | 2021-03-17 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 0 |
18842 | 18842 | 2021-03-18 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1802 | 0 | 9 | 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 );