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.
75 rows where city = "Corcoran" and new_confirmed_cases = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, x, y, 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 |
15560 | 15560 | 2020-08-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 61 | 2 | 0 | 0 |
15615 | 15615 | 2020-10-20 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 339 | 2 | 0 | 0 |
15621 | 15621 | 2020-10-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 583 | 2 | 0 | 0 |
15644 | 15644 | 2020-11-18 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1522 | 2 | 0 | 0 |
15653 | 15653 | 2020-11-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2221 | 2 | 2 | 0 |
15662 | 15662 | 2020-12-06 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2662 | 2 | 6 | 2 |
15673 | 15673 | 2020-12-17 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2928 | 2 | 6 | 0 |
15732 | 15732 | 2021-02-14 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3016 | 2 | 6 | 0 |
15873 | 15873 | 2021-07-05 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3021 | 2 | 7 | 0 |
15999 | 15999 | 2021-11-08 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3108 | 2 | 7 | 0 |
16013 | 16013 | 2021-11-22 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3124 | 2 | 7 | 0 |
16024 | 16024 | 2021-12-03 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3131 | 2 | 7 | 0 |
16057 | 16057 | 2022-01-05 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3135 | 2 | 7 | 0 |
16093 | 16093 | 2022-02-10 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4120 | 2 | 7 | 0 |
16095 | 16095 | 2022-02-12 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4128 | 2 | 7 | 0 |
16110 | 16110 | 2022-02-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4330 | 2 | 7 | 0 |
16111 | 16111 | 2022-02-28 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4332 | 2 | 7 | 0 |
16117 | 16117 | 2022-03-06 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4342 | 2 | 7 | 0 |
16143 | 16143 | 2022-04-01 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4377 | 2 | 7 | 0 |
16212 | 16212 | 2022-06-09 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4379 | 2 | 7 | 0 |
16249 | 16249 | 2022-07-16 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4395 | 2 | 7 | 0 |
16259 | 16259 | 2022-07-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4399 | 2 | 7 | 0 |
16285 | 16285 | 2022-08-21 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4420 | 2 | 7 | 0 |
16286 | 16286 | 2022-08-22 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4422 | 2 | 7 | 0 |
16297 | 16297 | 2022-09-02 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4486 | 2 | 7 | 0 |
16306 | 16306 | 2022-09-11 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4511 | 2 | 7 | 0 |
16307 | 16307 | 2022-09-12 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4513 | 2 | 7 | 0 |
16308 | 16308 | 2022-09-13 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4515 | 2 | 7 | 0 |
16312 | 16312 | 2022-09-17 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4525 | 2 | 7 | 0 |
16313 | 16313 | 2022-09-18 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4527 | 2 | 7 | 0 |
16336 | 16336 | 2022-10-11 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4555 | 2 | 7 | 0 |
16349 | 16349 | 2022-10-24 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4557 | 2 | 7 | 0 |
16351 | 16351 | 2022-10-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4562 | 2 | 7 | 0 |
16392 | 16392 | 2022-12-06 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4826 | 2 | 7 | 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 );