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 = "California Correctional Institution" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, date (date)
new_confirmed_cases 33 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4104 | 4104 | 2022-12-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 0 | 4 | 0 |
4103 | 4103 | 2022-12-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 0 | 4 | 0 |
4102 | 4102 | 2022-12-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 3 | 4 | 0 |
4101 | 4101 | 2022-12-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1821 | 1 | 4 | 0 |
4100 | 4100 | 2022-12-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4099 | 4099 | 2022-12-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4098 | 4098 | 2022-12-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4097 | 4097 | 2022-12-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4096 | 4096 | 2022-12-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4095 | 4095 | 2022-12-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4094 | 4094 | 2022-12-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
4093 | 4093 | 2022-12-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 1 | 4 | 0 |
4092 | 4092 | 2022-12-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1819 | 0 | 4 | 0 |
4091 | 4091 | 2022-12-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1819 | 0 | 4 | 0 |
4090 | 4090 | 2022-12-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1819 | 1 | 4 | 0 |
4089 | 4089 | 2022-12-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4088 | 4088 | 2022-12-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4087 | 4087 | 2022-12-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4086 | 4086 | 2022-12-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4085 | 4085 | 2022-12-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4084 | 4084 | 2022-12-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4083 | 4083 | 2022-12-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4082 | 4082 | 2022-12-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4081 | 4081 | 2022-12-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4080 | 4080 | 2022-12-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4079 | 4079 | 2022-12-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4078 | 4078 | 2022-12-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4077 | 4077 | 2022-12-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4076 | 4076 | 2022-12-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
4075 | 4075 | 2022-12-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 1 | 4 | 0 |
4074 | 4074 | 2022-11-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1817 | 0 | 4 | 0 |
4073 | 4073 | 2022-11-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1817 | 0 | 4 | 0 |
4072 | 4072 | 2022-11-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1817 | 1 | 4 | 0 |
4071 | 4071 | 2022-11-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4070 | 4070 | 2022-11-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4069 | 4069 | 2022-11-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4068 | 4068 | 2022-11-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4067 | 4067 | 2022-11-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4066 | 4066 | 2022-11-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4065 | 4065 | 2022-11-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4064 | 4064 | 2022-11-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4063 | 4063 | 2022-11-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4062 | 4062 | 2022-11-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4061 | 4061 | 2022-11-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 0 | 4 | 0 |
4060 | 4060 | 2022-11-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1816 | 1 | 4 | 0 |
4059 | 4059 | 2022-11-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1815 | 1 | 4 | 0 |
4058 | 4058 | 2022-11-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1814 | 1 | 4 | 0 |
4057 | 4057 | 2022-11-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1813 | 1 | 4 | 0 |
4056 | 4056 | 2022-11-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1812 | 1 | 4 | 0 |
4055 | 4055 | 2022-11-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1811 | 1 | 4 | 0 |
4054 | 4054 | 2022-11-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1810 | 0 | 4 | 0 |
4053 | 4053 | 2022-11-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1810 | 0 | 4 | 0 |
4052 | 4052 | 2022-11-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1810 | 3 | 4 | 0 |
4051 | 4051 | 2022-11-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1807 | 0 | 4 | 0 |
4050 | 4050 | 2022-11-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1807 | 0 | 4 | 0 |
4049 | 4049 | 2022-11-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1807 | 1 | 4 | 0 |
4048 | 4048 | 2022-11-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1806 | 1 | 4 | 0 |
4047 | 4047 | 2022-11-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1805 | 0 | 4 | 0 |
4046 | 4046 | 2022-11-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1805 | 0 | 4 | 0 |
4045 | 4045 | 2022-11-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1805 | 1 | 4 | 0 |
4044 | 4044 | 2022-10-31 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4043 | 4043 | 2022-10-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4042 | 4042 | 2022-10-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4041 | 4041 | 2022-10-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4040 | 4040 | 2022-10-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4039 | 4039 | 2022-10-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4038 | 4038 | 2022-10-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4037 | 4037 | 2022-10-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4036 | 4036 | 2022-10-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4035 | 4035 | 2022-10-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4034 | 4034 | 2022-10-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4033 | 4033 | 2022-10-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4032 | 4032 | 2022-10-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4031 | 4031 | 2022-10-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4030 | 4030 | 2022-10-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4029 | 4029 | 2022-10-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 0 | 4 | 0 |
4028 | 4028 | 2022-10-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1804 | 1 | 4 | 0 |
4027 | 4027 | 2022-10-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1803 | 2 | 4 | 0 |
4026 | 4026 | 2022-10-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1801 | 1 | 4 | 0 |
4025 | 4025 | 2022-10-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1800 | 0 | 4 | 0 |
4024 | 4024 | 2022-10-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1800 | 1 | 4 | 0 |
4023 | 4023 | 2022-10-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1799 | 1 | 4 | 0 |
4022 | 4022 | 2022-10-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1798 | 0 | 4 | 0 |
4021 | 4021 | 2022-10-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1798 | 0 | 4 | 0 |
4020 | 4020 | 2022-10-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1798 | 0 | 4 | 0 |
4019 | 4019 | 2022-10-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1798 | 1 | 4 | 0 |
4018 | 4018 | 2022-10-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1797 | 1 | 4 | 0 |
4017 | 4017 | 2022-10-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1796 | 1 | 4 | 0 |
4016 | 4016 | 2022-10-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1795 | 0 | 4 | 0 |
4015 | 4015 | 2022-10-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1795 | 0 | 4 | 0 |
4014 | 4014 | 2022-10-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1795 | 0 | 4 | 0 |
4013 | 4013 | 2022-09-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1795 | 0 | 4 | 0 |
4012 | 4012 | 2022-09-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1795 | 0 | 4 | 0 |
4011 | 4011 | 2022-09-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1795 | 2 | 4 | 0 |
4010 | 4010 | 2022-09-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1793 | 1 | 4 | 0 |
4009 | 4009 | 2022-09-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1792 | 1 | 4 | 0 |
4008 | 4008 | 2022-09-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1791 | 0 | 4 | 0 |
4007 | 4007 | 2022-09-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1791 | 1 | 4 | 0 |
4006 | 4006 | 2022-09-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1790 | 0 | 4 | 0 |
4005 | 4005 | 2022-09-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1790 | 1 | 4 | 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 );