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.
41 rows where name = "California State Prison, Corcoran" and new_confirmed_cases = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11371 | 11371 | 2020-06-02 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 7 | 2 | 0 | 0 |
11380 | 11380 | 2020-06-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 98 | 2 | 0 | 0 |
11427 | 11427 | 2020-07-28 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 181 | 2 | 1 | 0 |
11434 | 11434 | 2020-08-04 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 203 | 2 | 1 | 0 |
11461 | 11461 | 2020-08-31 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 354 | 2 | 1 | 0 |
11543 | 11543 | 2020-11-21 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 420 | 2 | 1 | 0 |
11551 | 11551 | 2020-11-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 435 | 2 | 1 | 0 |
11570 | 11570 | 2020-12-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 527 | 2 | 2 | 1 |
11594 | 11594 | 2021-01-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 814 | 2 | 4 | 0 |
11629 | 11629 | 2021-02-15 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1080 | 2 | 5 | 0 |
11631 | 11631 | 2021-02-17 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1088 | 2 | 5 | 0 |
11679 | 11679 | 2021-04-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1096 | 2 | 6 | 0 |
11759 | 11759 | 2021-06-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1105 | 2 | 6 | 0 |
11822 | 11822 | 2021-08-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1117 | 2 | 7 | 0 |
11934 | 11934 | 2021-12-17 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1356 | 2 | 7 | 0 |
11944 | 11944 | 2021-12-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1373 | 2 | 7 | 0 |
11950 | 11950 | 2022-01-02 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1388 | 2 | 7 | 0 |
11975 | 11975 | 2022-01-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1782 | 2 | 7 | 0 |
11977 | 11977 | 2022-01-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1795 | 2 | 7 | 0 |
11985 | 11985 | 2022-02-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1836 | 2 | 8 | 0 |
11988 | 11988 | 2022-02-09 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1850 | 2 | 8 | 0 |
11996 | 11996 | 2022-02-17 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1886 | 2 | 8 | 0 |
12001 | 12001 | 2022-02-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1929 | 2 | 8 | 0 |
12012 | 12012 | 2022-03-05 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1981 | 2 | 8 | 0 |
12027 | 12027 | 2022-03-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2115 | 2 | 8 | 0 |
12132 | 12132 | 2022-07-03 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2127 | 2 | 8 | 0 |
12134 | 12134 | 2022-07-05 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2130 | 2 | 8 | 0 |
12137 | 12137 | 2022-07-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2142 | 2 | 8 | 0 |
12145 | 12145 | 2022-07-16 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2222 | 2 | 8 | 0 |
12166 | 12166 | 2022-08-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2391 | 2 | 8 | 0 |
12168 | 12168 | 2022-08-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2400 | 2 | 8 | 0 |
12171 | 12171 | 2022-08-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2402 | 2 | 8 | 0 |
12181 | 12181 | 2022-08-21 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2406 | 2 | 8 | 0 |
12192 | 12192 | 2022-09-01 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2409 | 2 | 8 | 0 |
12203 | 12203 | 2022-09-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2413 | 2 | 8 | 0 |
12264 | 12264 | 2022-11-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2438 | 2 | 8 | 0 |
12268 | 12268 | 2022-11-16 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2447 | 2 | 8 | 0 |
12279 | 12279 | 2022-11-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2502 | 2 | 8 | 0 |
12295 | 12295 | 2022-12-13 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2589 | 2 | 8 | 0 |
12301 | 12301 | 2022-12-19 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2602 | 2 | 8 | 0 |
12304 | 12304 | 2022-12-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2606 | 2 | 8 | 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 );