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.
660 rows where deaths = 9 and name = "Mule Creek State Prison"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26017 | 26017 | 2021-03-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1854 | 0 | 9 | 1 |
26018 | 26018 | 2021-03-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1854 | 0 | 9 | 0 |
26019 | 26019 | 2021-03-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1854 | 0 | 9 | 0 |
26020 | 26020 | 2021-03-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1854 | 0 | 9 | 0 |
26021 | 26021 | 2021-03-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1855 | 1 | 9 | 0 |
26022 | 26022 | 2021-03-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 1 | 9 | 0 |
26023 | 26023 | 2021-03-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26024 | 26024 | 2021-03-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26025 | 26025 | 2021-03-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26026 | 26026 | 2021-03-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26027 | 26027 | 2021-03-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26028 | 26028 | 2021-03-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26029 | 26029 | 2021-03-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26030 | 26030 | 2021-03-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26031 | 26031 | 2021-03-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26032 | 26032 | 2021-03-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26033 | 26033 | 2021-03-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26034 | 26034 | 2021-03-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26035 | 26035 | 2021-03-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26036 | 26036 | 2021-03-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26037 | 26037 | 2021-03-31 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26038 | 26038 | 2021-04-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26039 | 26039 | 2021-04-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26040 | 26040 | 2021-04-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26041 | 26041 | 2021-04-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26042 | 26042 | 2021-04-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26043 | 26043 | 2021-04-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26044 | 26044 | 2021-04-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26045 | 26045 | 2021-04-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26046 | 26046 | 2021-04-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26047 | 26047 | 2021-04-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26048 | 26048 | 2021-04-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26049 | 26049 | 2021-04-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26050 | 26050 | 2021-04-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26051 | 26051 | 2021-04-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26052 | 26052 | 2021-04-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26053 | 26053 | 2021-04-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26054 | 26054 | 2021-04-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26055 | 26055 | 2021-04-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26056 | 26056 | 2021-04-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26057 | 26057 | 2021-04-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26058 | 26058 | 2021-04-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 0 | 9 | 0 |
26059 | 26059 | 2021-04-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 1 | 9 | 0 |
26060 | 26060 | 2021-04-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26061 | 26061 | 2021-04-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26062 | 26062 | 2021-04-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26063 | 26063 | 2021-04-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26064 | 26064 | 2021-04-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26065 | 26065 | 2021-04-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26066 | 26066 | 2021-04-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26067 | 26067 | 2021-04-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26068 | 26068 | 2021-05-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26069 | 26069 | 2021-05-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26070 | 26070 | 2021-05-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26071 | 26071 | 2021-05-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26072 | 26072 | 2021-05-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26073 | 26073 | 2021-05-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26074 | 26074 | 2021-05-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26075 | 26075 | 2021-05-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26076 | 26076 | 2021-05-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26077 | 26077 | 2021-05-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26078 | 26078 | 2021-05-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26079 | 26079 | 2021-05-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26080 | 26080 | 2021-05-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26081 | 26081 | 2021-05-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26082 | 26082 | 2021-05-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26083 | 26083 | 2021-05-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26084 | 26084 | 2021-05-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26085 | 26085 | 2021-05-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26086 | 26086 | 2021-05-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26087 | 26087 | 2021-05-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26088 | 26088 | 2021-05-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26089 | 26089 | 2021-05-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26090 | 26090 | 2021-05-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26091 | 26091 | 2021-05-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 0 | 9 | 0 |
26092 | 26092 | 2021-05-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1858 | 1 | 9 | 0 |
26093 | 26093 | 2021-05-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1861 | 3 | 9 | 0 |
26094 | 26094 | 2021-05-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1861 | 0 | 9 | 0 |
26095 | 26095 | 2021-05-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1861 | 0 | 9 | 0 |
26096 | 26096 | 2021-05-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1861 | 0 | 9 | 0 |
26097 | 26097 | 2021-05-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1861 | 0 | 9 | 0 |
26098 | 26098 | 2021-05-31 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1861 | 0 | 9 | 0 |
26099 | 26099 | 2021-06-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1862 | 1 | 9 | 0 |
26100 | 26100 | 2021-06-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1863 | 1 | 9 | 0 |
26101 | 26101 | 2021-06-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1863 | 0 | 9 | 0 |
26102 | 26102 | 2021-06-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1870 | 7 | 9 | 0 |
26103 | 26103 | 2021-06-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1870 | 0 | 9 | 0 |
26104 | 26104 | 2021-06-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1870 | 0 | 9 | 0 |
26105 | 26105 | 2021-06-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1870 | 0 | 9 | 0 |
26106 | 26106 | 2021-06-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1878 | 8 | 9 | 0 |
26107 | 26107 | 2021-06-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1878 | 0 | 9 | 0 |
26108 | 26108 | 2021-06-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1878 | 0 | 9 | 0 |
26109 | 26109 | 2021-06-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1879 | 1 | 9 | 0 |
26110 | 26110 | 2021-06-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1879 | 0 | 9 | 0 |
26111 | 26111 | 2021-06-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1879 | 0 | 9 | 0 |
26112 | 26112 | 2021-06-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1879 | 0 | 9 | 0 |
26113 | 26113 | 2021-06-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1879 | 0 | 9 | 0 |
26114 | 26114 | 2021-06-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1880 | 1 | 9 | 0 |
26115 | 26115 | 2021-06-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1880 | 0 | 9 | 0 |
26116 | 26116 | 2021-06-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1881 | 1 | 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 );