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.
24 rows where name = "Folsom State Prison" and new_confirmed_cases = 3
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21687 | 21687 | 2020-07-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 7 | 3 | 0 | 0 |
21702 | 21702 | 2020-08-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 129 | 3 | 0 | 0 |
21740 | 21740 | 2020-09-19 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1086 | 3 | 0 | 0 |
21758 | 21758 | 2020-10-07 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1332 | 3 | 1 | 0 |
21760 | 21760 | 2020-10-09 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1336 | 3 | 1 | 0 |
21763 | 21763 | 2020-10-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1339 | 3 | 1 | 0 |
21806 | 21806 | 2020-11-24 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1351 | 3 | 2 | 0 |
21871 | 21871 | 2021-01-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1366 | 3 | 2 | 0 |
21873 | 21873 | 2021-01-30 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1369 | 3 | 2 | 0 |
22236 | 22236 | 2022-01-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2387 | 3 | 2 | 0 |
22246 | 22246 | 2022-02-07 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2499 | 3 | 2 | 0 |
22247 | 22247 | 2022-02-08 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2502 | 3 | 2 | 0 |
22362 | 22362 | 2022-06-03 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2675 | 3 | 2 | 0 |
22368 | 22368 | 2022-06-09 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2684 | 3 | 2 | 0 |
22386 | 22386 | 2022-06-27 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2728 | 3 | 2 | 0 |
22392 | 22392 | 2022-07-03 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2733 | 3 | 2 | 0 |
22403 | 22403 | 2022-07-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2753 | 3 | 2 | 0 |
22443 | 22443 | 2022-08-23 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2806 | 3 | 2 | 0 |
22454 | 22454 | 2022-09-03 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2823 | 3 | 2 | 0 |
22457 | 22457 | 2022-09-06 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2828 | 3 | 2 | 0 |
22504 | 22504 | 2022-10-23 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2860 | 3 | 2 | 0 |
22509 | 22509 | 2022-10-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2870 | 3 | 2 | 0 |
22543 | 22543 | 2022-12-01 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2879 | 3 | 2 | 0 |
22551 | 22551 | 2022-12-09 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2886 | 3 | 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 );