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.
29 rows where deaths = 19 and name = "California Institution for Men"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5258 | 5258 | 2020-07-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1045 | 1 | 19 | 1 |
5259 | 5259 | 2020-07-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1047 | 2 | 19 | 0 |
5260 | 5260 | 2020-07-17 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1049 | 2 | 19 | 0 |
5261 | 5261 | 2020-07-18 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1049 | 0 | 19 | 0 |
5262 | 5262 | 2020-07-19 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1049 | 0 | 19 | 0 |
5263 | 5263 | 2020-07-20 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1054 | 5 | 19 | 0 |
5264 | 5264 | 2020-07-21 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1059 | 5 | 19 | 0 |
5265 | 5265 | 2020-07-22 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1060 | 1 | 19 | 0 |
5266 | 5266 | 2020-07-23 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1063 | 3 | 19 | 0 |
5267 | 5267 | 2020-07-24 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1063 | 0 | 19 | 0 |
5268 | 5268 | 2020-07-25 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1065 | 2 | 19 | 0 |
5269 | 5269 | 2020-07-26 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1065 | 0 | 19 | 0 |
5270 | 5270 | 2020-07-27 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1068 | 3 | 19 | 0 |
5271 | 5271 | 2020-07-28 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1072 | 4 | 19 | 0 |
5272 | 5272 | 2020-07-29 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1072 | 0 | 19 | 0 |
5273 | 5273 | 2020-07-30 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1073 | 1 | 19 | 0 |
5274 | 5274 | 2020-07-31 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1073 | 0 | 19 | 0 |
5275 | 5275 | 2020-08-01 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1073 | 0 | 19 | 0 |
5276 | 5276 | 2020-08-02 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1073 | 0 | 19 | 0 |
5277 | 5277 | 2020-08-03 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1073 | 0 | 19 | 0 |
5278 | 5278 | 2020-08-04 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1085 | 12 | 19 | 0 |
5279 | 5279 | 2020-08-05 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1085 | 0 | 19 | 0 |
5280 | 5280 | 2020-08-06 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1098 | 13 | 19 | 0 |
5281 | 5281 | 2020-08-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1098 | 0 | 19 | 0 |
5282 | 5282 | 2020-08-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1098 | 0 | 19 | 0 |
5283 | 5283 | 2020-08-09 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1098 | 0 | 19 | 0 |
5284 | 5284 | 2020-08-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1106 | 8 | 19 | 0 |
5285 | 5285 | 2020-08-11 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1106 | 0 | 19 | 0 |
5286 | 5286 | 2020-08-12 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1107 | 1 | 19 | 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 );