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.
50 rows where new_confirmed_cases = 18
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, city, county, fips, zipcode, x, y, deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78 | 78 | 2020-05-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 217 | 18 | 0 | 0 |
983 | 983 | 2022-11-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4308 | 18 | 8 | 0 |
1303 | 1303 | 2020-12-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 404 | 18 | 0 | 0 |
1305 | 1305 | 2020-12-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 422 | 18 | 0 | 0 |
1686 | 1686 | 2021-12-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1040 | 18 | 2 | 0 |
4911 | 4911 | 2022-05-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1132 | 18 | 20 | 0 |
5036 | 5036 | 2022-09-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1820 | 18 | 22 | 0 |
5792 | 5792 | 2021-12-31 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1661 | 18 | 30 | 0 |
6830 | 6830 | 2022-01-12 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 585 | 18 | 1 | 0 |
6836 | 6836 | 2022-01-18 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 624 | 18 | 1 | 0 |
7982 | 7982 | 2022-05-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1281 | 18 | 13 | 0 |
8530 | 8530 | 2021-01-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2460 | 18 | 7 | 0 |
9514 | 9514 | 2020-12-14 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1745 | 18 | 0 | 0 |
9543 | 9543 | 2021-01-12 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1960 | 18 | 1 | 0 |
10534 | 10534 | 2020-12-08 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 556 | 18 | 1 | 0 |
10542 | 10542 | 2020-12-16 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 738 | 18 | 1 | 0 |
10543 | 10543 | 2020-12-17 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 756 | 18 | 1 | 0 |
11536 | 11536 | 2020-11-14 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 385 | 18 | 1 | 0 |
11990 | 11990 | 2022-02-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1871 | 18 | 8 | 0 |
12141 | 12141 | 2022-07-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2200 | 18 | 8 | 0 |
12580 | 12580 | 2020-12-02 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 394 | 18 | 1 | 1 |
13633 | 13633 | 2020-12-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 223 | 18 | 1 | 0 |
15639 | 15639 | 2020-11-13 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1184 | 18 | 0 | 0 |
16102 | 16102 | 2022-02-19 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4274 | 18 | 7 | 0 |
18347 | 18347 | 2022-08-31 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2092 | 18 | 1 | 0 |
18693 | 18693 | 2020-10-20 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 1422 | 18 | 4 | 0 |
19694 | 19694 | 2020-09-25 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 142 | 18 | 1 | 0 |
19701 | 19701 | 2020-10-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 160 | 18 | 1 | 0 |
20192 | 20192 | 2022-02-05 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2990 | 18 | 21 | 0 |
22856 | 22856 | 2020-12-18 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 1846 | 18 | 1 | 0 |
23761 | 23761 | 2020-08-19 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 81 | 18 | 0 | 0 |
24390 | 24390 | 2022-05-10 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 2367 | 18 | 1 | 0 |
25969 | 25969 | 2021-01-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1673 | 18 | 5 | 0 |
25986 | 25986 | 2021-02-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1829 | 18 | 8 | 1 |
26469 | 26469 | 2022-06-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2999 | 18 | 9 | 0 |
26847 | 26847 | 2020-08-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 41 | 18 | 0 | 0 |
26960 | 26960 | 2020-12-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 392 | 18 | 0 | 0 |
27366 | 27366 | 2022-01-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2657 | 18 | 5 | 0 |
27686 | 27686 | 2022-12-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4143 | 18 | 5 | 0 |
30032 | 30032 | 2020-12-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 441 | 18 | 0 | 0 |
30597 | 30597 | 2022-06-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1496 | 18 | 21 | 0 |
31070 | 31070 | 2020-12-24 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 335 | 18 | 1 | 0 |
31901 | 31901 | 2020-06-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 49 | 18 | 0 | 0 |
32594 | 32594 | 2022-05-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2895 | 18 | 28 | 0 |
32600 | 32600 | 2022-05-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2944 | 18 | 28 | 0 |
34186 | 34186 | 2021-01-31 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1727 | 18 | 2 | 0 |
35162 | 35162 | 2020-12-12 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 703 | 18 | 0 | 0 |
35166 | 35166 | 2020-12-16 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 810 | 18 | 0 | 0 |
35178 | 35178 | 2020-12-28 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 1126 | 18 | 0 | 0 |
35759 | 35759 | 2022-08-01 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 4742 | 18 | 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 );