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,026 rows where name = "Valley State Prison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34784 | 34784 | 2022-09-21 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2221 | 0 | 2 | 0 |
34783 | 34783 | 2022-09-20 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2221 | 0 | 2 | 0 |
34782 | 34782 | 2022-09-19 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2221 | 3 | 2 | 0 |
34781 | 34781 | 2022-09-18 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2218 | 1 | 2 | 0 |
34780 | 34780 | 2022-09-17 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 0 | 2 | 0 |
34779 | 34779 | 2022-09-16 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 0 | 2 | 0 |
34778 | 34778 | 2022-09-15 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 0 | 2 | 0 |
34777 | 34777 | 2022-09-14 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 0 | 2 | 0 |
34776 | 34776 | 2022-09-13 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 0 | 2 | 0 |
34775 | 34775 | 2022-09-12 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 0 | 2 | 0 |
34774 | 34774 | 2022-09-11 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2217 | 4 | 2 | 0 |
34773 | 34773 | 2022-09-10 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2213 | 0 | 2 | 0 |
34772 | 34772 | 2022-09-09 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2213 | 0 | 2 | 0 |
34771 | 34771 | 2022-09-08 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2213 | 1 | 2 | 0 |
34770 | 34770 | 2022-09-07 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2212 | 1 | 2 | 0 |
34769 | 34769 | 2022-09-06 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2211 | 2 | 2 | 0 |
34768 | 34768 | 2022-09-05 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2209 | 0 | 2 | 0 |
34767 | 34767 | 2022-09-04 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2209 | 7 | 2 | 0 |
34766 | 34766 | 2022-09-03 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2202 | 0 | 2 | 0 |
34765 | 34765 | 2022-09-02 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2202 | 1 | 2 | 0 |
34764 | 34764 | 2022-09-01 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2201 | 2 | 2 | 0 |
34763 | 34763 | 2022-08-31 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2199 | 0 | 2 | 0 |
34762 | 34762 | 2022-08-30 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2199 | 4 | 2 | 0 |
34761 | 34761 | 2022-08-29 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2195 | 2 | 2 | 0 |
34760 | 34760 | 2022-08-28 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2193 | 6 | 2 | 0 |
34759 | 34759 | 2022-08-27 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2187 | 0 | 2 | 0 |
34758 | 34758 | 2022-08-26 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2187 | 0 | 2 | 0 |
34757 | 34757 | 2022-08-25 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2187 | 5 | 2 | 0 |
34756 | 34756 | 2022-08-24 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2182 | 0 | 2 | 0 |
34755 | 34755 | 2022-08-23 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2182 | 4 | 2 | 0 |
34754 | 34754 | 2022-08-22 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2178 | 3 | 2 | 0 |
34753 | 34753 | 2022-08-21 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2175 | 2 | 2 | 0 |
34752 | 34752 | 2022-08-20 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2173 | 0 | 2 | 0 |
34751 | 34751 | 2022-08-19 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2173 | 0 | 2 | 0 |
34750 | 34750 | 2022-08-18 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2173 | 1 | 2 | 0 |
34749 | 34749 | 2022-08-17 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2172 | 5 | 2 | 0 |
34748 | 34748 | 2022-08-16 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2167 | 0 | 2 | 0 |
34747 | 34747 | 2022-08-15 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2167 | 6 | 2 | 0 |
34746 | 34746 | 2022-08-14 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2161 | 1 | 2 | 0 |
34745 | 34745 | 2022-08-13 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2160 | 2 | 2 | 0 |
34744 | 34744 | 2022-08-12 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2158 | 2 | 2 | 0 |
34743 | 34743 | 2022-08-11 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2156 | 2 | 2 | 0 |
34742 | 34742 | 2022-08-10 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2154 | 1 | 2 | 0 |
34741 | 34741 | 2022-08-09 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2153 | 11 | 2 | 0 |
34740 | 34740 | 2022-08-08 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2142 | 1 | 2 | 0 |
34739 | 34739 | 2022-08-07 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2141 | 9 | 2 | 0 |
34738 | 34738 | 2022-08-06 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2132 | 0 | 2 | 0 |
34737 | 34737 | 2022-08-05 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2132 | 0 | 2 | 0 |
34736 | 34736 | 2022-08-04 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2132 | 2 | 2 | 0 |
34735 | 34735 | 2022-08-03 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2130 | 10 | 2 | 0 |
34734 | 34734 | 2022-08-02 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2120 | 12 | 2 | 0 |
34733 | 34733 | 2022-08-01 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2108 | 19 | 2 | 0 |
34732 | 34732 | 2022-07-31 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2089 | 5 | 2 | 0 |
34731 | 34731 | 2022-07-30 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2084 | 0 | 2 | 0 |
34730 | 34730 | 2022-07-29 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2084 | 6 | 2 | 0 |
34729 | 34729 | 2022-07-28 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2078 | 2 | 2 | 0 |
34728 | 34728 | 2022-07-27 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2076 | 1 | 2 | 0 |
34727 | 34727 | 2022-07-26 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2075 | 5 | 2 | 0 |
34726 | 34726 | 2022-07-25 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2070 | 7 | 2 | 0 |
34725 | 34725 | 2022-07-24 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2063 | 27 | 2 | 0 |
34724 | 34724 | 2022-07-23 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2036 | 7 | 2 | 0 |
34723 | 34723 | 2022-07-22 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2029 | 1 | 2 | 0 |
34722 | 34722 | 2022-07-21 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2028 | 6 | 2 | 0 |
34721 | 34721 | 2022-07-20 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2022 | 1 | 2 | 0 |
34720 | 34720 | 2022-07-19 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2021 | 4 | 2 | 0 |
34719 | 34719 | 2022-07-18 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2017 | 3 | 2 | 0 |
34718 | 34718 | 2022-07-17 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2014 | 1 | 2 | 0 |
34717 | 34717 | 2022-07-16 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2013 | 3 | 2 | 0 |
34716 | 34716 | 2022-07-15 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2010 | 5 | 2 | 0 |
34715 | 34715 | 2022-07-14 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2005 | 0 | 2 | 0 |
34714 | 34714 | 2022-07-13 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2005 | 6 | 2 | 0 |
34713 | 34713 | 2022-07-12 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1999 | 2 | 2 | 0 |
34712 | 34712 | 2022-07-11 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1997 | 6 | 2 | 0 |
34711 | 34711 | 2022-07-10 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1991 | 0 | 2 | 0 |
34710 | 34710 | 2022-07-09 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1991 | 0 | 2 | 0 |
34709 | 34709 | 2022-07-08 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1991 | 3 | 2 | 0 |
34708 | 34708 | 2022-07-07 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1988 | 5 | 2 | 0 |
34707 | 34707 | 2022-07-06 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1983 | 3 | 2 | 0 |
34706 | 34706 | 2022-07-05 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1980 | 5 | 2 | 0 |
34705 | 34705 | 2022-07-04 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1975 | 1 | 2 | 0 |
34704 | 34704 | 2022-07-03 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1974 | 0 | 2 | 0 |
34703 | 34703 | 2022-07-02 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1974 | 3 | 2 | 0 |
34702 | 34702 | 2022-07-01 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1971 | 0 | 2 | 0 |
34701 | 34701 | 2022-06-30 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1971 | 0 | 2 | 0 |
34700 | 34700 | 2022-06-29 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1971 | 0 | 2 | 0 |
34699 | 34699 | 2022-06-28 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1971 | 4 | 2 | 0 |
34698 | 34698 | 2022-06-27 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1967 | 0 | 2 | 0 |
34697 | 34697 | 2022-06-26 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1967 | 0 | 2 | 0 |
34696 | 34696 | 2022-06-25 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1967 | 1 | 2 | 0 |
34695 | 34695 | 2022-06-24 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1966 | 1 | 2 | 0 |
34694 | 34694 | 2022-06-23 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1965 | 0 | 2 | 0 |
34693 | 34693 | 2022-06-22 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1965 | 6 | 2 | 0 |
34692 | 34692 | 2022-06-21 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1959 | 0 | 2 | 0 |
34691 | 34691 | 2022-06-20 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1959 | 0 | 2 | 0 |
34690 | 34690 | 2022-06-19 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1959 | 0 | 2 | 0 |
34689 | 34689 | 2022-06-18 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1959 | 2 | 2 | 0 |
34688 | 34688 | 2022-06-17 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1957 | 0 | 2 | 0 |
34687 | 34687 | 2022-06-16 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1957 | 1 | 2 | 0 |
34686 | 34686 | 2022-06-15 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1956 | 1 | 2 | 0 |
34685 | 34685 | 2022-06-14 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1955 | 0 | 2 | 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 );