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.
45 rows where confirmed_cases = 2010
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, county, zipcode, y, new_confirmed_cases, deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9613 | 9613 | 2021-03-23 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 1 | 1 | 0 |
9614 | 9614 | 2021-03-24 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9615 | 9615 | 2021-03-25 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9616 | 9616 | 2021-03-26 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9617 | 9617 | 2021-03-27 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9618 | 9618 | 2021-03-28 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9619 | 9619 | 2021-03-29 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9620 | 9620 | 2021-03-30 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9621 | 9621 | 2021-03-31 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9622 | 9622 | 2021-04-01 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9623 | 9623 | 2021-04-02 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9624 | 9624 | 2021-04-03 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9625 | 9625 | 2021-04-04 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9626 | 9626 | 2021-04-05 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9627 | 9627 | 2021-04-06 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9628 | 9628 | 2021-04-07 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9629 | 9629 | 2021-04-08 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9630 | 9630 | 2021-04-09 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9631 | 9631 | 2021-04-10 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9632 | 9632 | 2021-04-11 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9633 | 9633 | 2021-04-12 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9634 | 9634 | 2021-04-13 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9635 | 9635 | 2021-04-14 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9636 | 9636 | 2021-04-15 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9637 | 9637 | 2021-04-16 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9638 | 9638 | 2021-04-17 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9639 | 9639 | 2021-04-18 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9640 | 9640 | 2021-04-19 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9641 | 9641 | 2021-04-20 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9642 | 9642 | 2021-04-21 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9643 | 9643 | 2021-04-22 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9644 | 9644 | 2021-04-23 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9645 | 9645 | 2021-04-24 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9646 | 9646 | 2021-04-25 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9647 | 9647 | 2021-04-26 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9648 | 9648 | 2021-04-27 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
9649 | 9649 | 2021-04-28 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2010 | 0 | 1 | 0 |
13199 | 13199 | 2022-08-13 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2010 | 1 | 15 | 0 |
13200 | 13200 | 2022-08-14 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2010 | 0 | 15 | 0 |
22222 | 22222 | 2022-01-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2010 | 5 | 2 | 0 |
29234 | 29234 | 2021-07-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2010 | 1 | 3 | 0 |
34716 | 34716 | 2022-07-15 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2010 | 5 | 2 | 0 |
35538 | 35538 | 2021-12-23 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 2010 | 40 | 2 | 0 |
35539 | 35539 | 2021-12-24 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 2010 | 0 | 2 | 0 |
35540 | 35540 | 2021-12-25 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 2010 | 0 | 2 | 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 );