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.
86 rows where deaths = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, city, fips, zipcode, y, confirmed_cases, new_deaths
name 3 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5130 | 5130 | 2022-12-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1908 | 0 | 23 | 0 |
5129 | 5129 | 2022-12-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1908 | 0 | 23 | 0 |
5128 | 5128 | 2022-12-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1908 | 2 | 23 | 0 |
5127 | 5127 | 2022-12-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1906 | 5 | 23 | 0 |
5126 | 5126 | 2022-12-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1901 | 0 | 23 | 0 |
5125 | 5125 | 2022-12-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1901 | 1 | 23 | 0 |
5124 | 5124 | 2022-12-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1900 | 3 | 23 | 0 |
5123 | 5123 | 2022-12-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1897 | 1 | 23 | 0 |
5122 | 5122 | 2022-12-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1896 | 2 | 23 | 0 |
5121 | 5121 | 2022-12-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1894 | 0 | 23 | 0 |
5120 | 5120 | 2022-12-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1894 | 3 | 23 | 0 |
5119 | 5119 | 2022-12-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1891 | 7 | 23 | 0 |
5118 | 5118 | 2022-12-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1884 | 2 | 23 | 0 |
5117 | 5117 | 2022-12-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1882 | 4 | 23 | 0 |
5116 | 5116 | 2022-12-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1878 | 2 | 23 | 0 |
5115 | 5115 | 2022-12-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1876 | 0 | 23 | 0 |
5114 | 5114 | 2022-12-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1876 | 3 | 23 | 0 |
5113 | 5113 | 2022-12-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1873 | 1 | 23 | 0 |
5112 | 5112 | 2022-12-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1872 | 2 | 23 | 0 |
5111 | 5111 | 2022-12-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1870 | 2 | 23 | 0 |
5110 | 5110 | 2022-12-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1868 | 1 | 23 | 0 |
5109 | 5109 | 2022-12-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1867 | 1 | 23 | 0 |
5108 | 5108 | 2022-12-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1866 | 3 | 23 | 0 |
5107 | 5107 | 2022-12-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1863 | 0 | 23 | 0 |
5106 | 5106 | 2022-12-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1863 | 1 | 23 | 0 |
5105 | 5105 | 2022-12-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1862 | 1 | 23 | 0 |
5104 | 5104 | 2022-12-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1861 | 0 | 23 | 0 |
5103 | 5103 | 2022-12-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1861 | 0 | 23 | 0 |
5102 | 5102 | 2022-12-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1861 | 0 | 23 | 0 |
5101 | 5101 | 2022-12-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1861 | 0 | 23 | 0 |
5100 | 5100 | 2022-11-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1861 | 1 | 23 | 0 |
5099 | 5099 | 2022-11-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1860 | 1 | 23 | 0 |
5098 | 5098 | 2022-11-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1859 | 3 | 23 | 0 |
5097 | 5097 | 2022-11-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1856 | 1 | 23 | 0 |
5096 | 5096 | 2022-11-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1855 | 0 | 23 | 0 |
5095 | 5095 | 2022-11-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1855 | 0 | 23 | 0 |
5094 | 5094 | 2022-11-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1855 | 0 | 23 | 0 |
5093 | 5093 | 2022-11-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1855 | 0 | 23 | 0 |
5092 | 5092 | 2022-11-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1855 | 0 | 23 | 0 |
5091 | 5091 | 2022-11-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1855 | 1 | 23 | 0 |
5090 | 5090 | 2022-11-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1854 | 0 | 23 | 0 |
5089 | 5089 | 2022-11-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1854 | 3 | 23 | 0 |
5088 | 5088 | 2022-11-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1851 | 0 | 23 | 0 |
5087 | 5087 | 2022-11-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1851 | 0 | 23 | 0 |
5086 | 5086 | 2022-11-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1851 | 1 | 23 | 0 |
5085 | 5085 | 2022-11-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1850 | 1 | 23 | 0 |
5084 | 5084 | 2022-11-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1849 | 0 | 23 | 0 |
5083 | 5083 | 2022-11-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1849 | 0 | 23 | 0 |
5082 | 5082 | 2022-11-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1849 | 0 | 23 | 0 |
5081 | 5081 | 2022-11-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1849 | 0 | 23 | 0 |
5080 | 5080 | 2022-11-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1849 | 1 | 23 | 0 |
5079 | 5079 | 2022-11-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1848 | 0 | 23 | 0 |
5078 | 5078 | 2022-11-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1848 | 0 | 23 | 0 |
5077 | 5077 | 2022-11-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1848 | 1 | 23 | 0 |
5076 | 5076 | 2022-11-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1847 | 0 | 23 | 0 |
5075 | 5075 | 2022-11-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1847 | 0 | 23 | 0 |
5074 | 5074 | 2022-11-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1847 | 0 | 23 | 0 |
5073 | 5073 | 2022-11-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1847 | 0 | 23 | 0 |
5072 | 5072 | 2022-11-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1847 | 0 | 23 | 0 |
5071 | 5071 | 2022-11-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1847 | 1 | 23 | 0 |
5070 | 5070 | 2022-10-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 0 |
5069 | 5069 | 2022-10-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 0 |
5068 | 5068 | 2022-10-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 0 |
5067 | 5067 | 2022-10-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 0 |
5066 | 5066 | 2022-10-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 0 |
5065 | 5065 | 2022-10-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 1 |
5330 | 5330 | 2020-09-25 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1289 | 103 | 23 | 0 |
5329 | 5329 | 2020-09-24 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1186 | 3 | 23 | 0 |
5328 | 5328 | 2020-09-23 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1183 | 9 | 23 | 0 |
5327 | 5327 | 2020-09-22 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1174 | 9 | 23 | 0 |
5326 | 5326 | 2020-09-21 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1165 | 4 | 23 | 0 |
5325 | 5325 | 2020-09-20 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1161 | 0 | 23 | 0 |
5324 | 5324 | 2020-09-19 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1161 | 7 | 23 | 0 |
5323 | 5323 | 2020-09-18 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1154 | 2 | 23 | 0 |
5322 | 5322 | 2020-09-17 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1152 | 10 | 23 | 0 |
5321 | 5321 | 2020-09-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1142 | 3 | 23 | 0 |
5320 | 5320 | 2020-09-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1139 | 6 | 23 | 0 |
5319 | 5319 | 2020-09-14 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1133 | 0 | 23 | 0 |
5318 | 5318 | 2020-09-13 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1133 | 1 | 23 | 0 |
5317 | 5317 | 2020-09-12 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1132 | 1 | 23 | 0 |
5316 | 5316 | 2020-09-11 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1131 | 3 | 23 | 0 |
5315 | 5315 | 2020-09-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1128 | 1 | 23 | 0 |
5314 | 5314 | 2020-09-09 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1127 | 2 | 23 | 0 |
5313 | 5313 | 2020-09-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1125 | 1 | 23 | 0 |
5312 | 5312 | 2020-09-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1124 | 0 | 23 | 1 |
31953 | 31953 | 2020-08-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2224 | 1 | 23 | 1 |
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 );