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.
841 rows where deaths = 28 and new_deaths = 0
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, city, fips, zipcode, x, new_confirmed_cases, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5460 | 5460 | 2021-02-02 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1537 | 1 | 28 | 0 |
5461 | 5461 | 2021-02-03 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 1 | 28 | 0 |
5462 | 5462 | 2021-02-04 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5463 | 5463 | 2021-02-05 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5464 | 5464 | 2021-02-06 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5465 | 5465 | 2021-02-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5466 | 5466 | 2021-02-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5467 | 5467 | 2021-02-09 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5468 | 5468 | 2021-02-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5469 | 5469 | 2021-02-11 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5470 | 5470 | 2021-02-12 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1538 | 0 | 28 | 0 |
5471 | 5471 | 2021-02-13 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1539 | 1 | 28 | 0 |
5472 | 5472 | 2021-02-14 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1539 | 0 | 28 | 0 |
5473 | 5473 | 2021-02-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1539 | 0 | 28 | 0 |
5474 | 5474 | 2021-02-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1539 | 0 | 28 | 0 |
32007 | 32007 | 2020-09-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32008 | 32008 | 2020-09-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32009 | 32009 | 2020-09-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32010 | 32010 | 2020-09-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32011 | 32011 | 2020-09-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32012 | 32012 | 2020-10-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32013 | 32013 | 2020-10-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32014 | 32014 | 2020-10-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32015 | 32015 | 2020-10-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32016 | 32016 | 2020-10-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32017 | 32017 | 2020-10-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32018 | 32018 | 2020-10-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32019 | 32019 | 2020-10-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32020 | 32020 | 2020-10-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32021 | 32021 | 2020-10-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32022 | 32022 | 2020-10-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32023 | 32023 | 2020-10-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32024 | 32024 | 2020-10-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2238 | 0 | 28 | 0 |
32025 | 32025 | 2020-10-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 1 | 28 | 0 |
32026 | 32026 | 2020-10-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32027 | 32027 | 2020-10-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32028 | 32028 | 2020-10-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32029 | 32029 | 2020-10-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32030 | 32030 | 2020-10-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32031 | 32031 | 2020-10-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32032 | 32032 | 2020-10-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32033 | 32033 | 2020-10-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32034 | 32034 | 2020-10-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32035 | 32035 | 2020-10-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32036 | 32036 | 2020-10-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32037 | 32037 | 2020-10-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32038 | 32038 | 2020-10-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32039 | 32039 | 2020-10-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32040 | 32040 | 2020-10-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32041 | 32041 | 2020-10-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32042 | 32042 | 2020-10-31 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32043 | 32043 | 2020-11-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32044 | 32044 | 2020-11-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32045 | 32045 | 2020-11-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32046 | 32046 | 2020-11-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32047 | 32047 | 2020-11-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32048 | 32048 | 2020-11-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32049 | 32049 | 2020-11-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32050 | 32050 | 2020-11-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32051 | 32051 | 2020-11-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32052 | 32052 | 2020-11-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32053 | 32053 | 2020-11-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32054 | 32054 | 2020-11-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32055 | 32055 | 2020-11-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32056 | 32056 | 2020-11-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32057 | 32057 | 2020-11-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32058 | 32058 | 2020-11-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32059 | 32059 | 2020-11-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32060 | 32060 | 2020-11-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32061 | 32061 | 2020-11-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32062 | 32062 | 2020-11-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32063 | 32063 | 2020-11-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32064 | 32064 | 2020-11-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32065 | 32065 | 2020-11-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32066 | 32066 | 2020-11-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32067 | 32067 | 2020-11-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32068 | 32068 | 2020-11-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32069 | 32069 | 2020-11-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32070 | 32070 | 2020-11-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32071 | 32071 | 2020-11-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32072 | 32072 | 2020-11-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32073 | 32073 | 2020-12-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32074 | 32074 | 2020-12-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32075 | 32075 | 2020-12-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32076 | 32076 | 2020-12-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32077 | 32077 | 2020-12-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32078 | 32078 | 2020-12-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32079 | 32079 | 2020-12-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32080 | 32080 | 2020-12-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2239 | 0 | 28 | 0 |
32081 | 32081 | 2020-12-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2242 | 3 | 28 | 0 |
32082 | 32082 | 2020-12-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2242 | 0 | 28 | 0 |
32083 | 32083 | 2020-12-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2242 | 0 | 28 | 0 |
32084 | 32084 | 2020-12-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2242 | 0 | 28 | 0 |
32085 | 32085 | 2020-12-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2242 | 0 | 28 | 0 |
32086 | 32086 | 2020-12-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2243 | 1 | 28 | 0 |
32087 | 32087 | 2020-12-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2243 | 0 | 28 | 0 |
32088 | 32088 | 2020-12-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2243 | 0 | 28 | 0 |
32089 | 32089 | 2020-12-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2243 | 0 | 28 | 0 |
32090 | 32090 | 2020-12-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2244 | 1 | 28 | 0 |
32091 | 32091 | 2020-12-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2245 | 1 | 28 | 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 );