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.
97 rows where new_confirmed_cases = 12
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, city, county, zipcode, deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
156 | 156 | 2020-08-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1601 | 12 | 5 | 0 |
199 | 199 | 2020-09-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2657 | 12 | 5 | 0 |
238 | 238 | 2020-11-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2983 | 12 | 8 | 0 |
1295 | 1295 | 2020-12-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 138 | 12 | 0 | 0 |
1321 | 1321 | 2020-12-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 826 | 12 | 0 | 0 |
1700 | 1700 | 2022-01-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1100 | 12 | 2 | 0 |
1908 | 1908 | 2022-08-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1735 | 12 | 2 | 0 |
2195 | 2195 | 2020-07-30 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 587 | 12 | 0 | 0 |
2781 | 2781 | 2022-03-08 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2196 | 12 | 0 | 0 |
3373 | 3373 | 2020-12-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1236 | 12 | 1 | 0 |
3387 | 3387 | 2021-01-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1281 | 12 | 4 | 0 |
4783 | 4783 | 2022-01-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 804 | 12 | 19 | 0 |
4942 | 4942 | 2022-06-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1332 | 12 | 22 | 0 |
5232 | 5232 | 2020-06-19 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 857 | 12 | 16 | 0 |
5278 | 5278 | 2020-08-04 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1085 | 12 | 19 | 0 |
5839 | 5839 | 2022-02-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2668 | 12 | 30 | 0 |
6028 | 6028 | 2022-08-24 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3283 | 12 | 30 | 0 |
7478 | 7478 | 2020-12-30 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 417 | 12 | 0 | 0 |
7856 | 7856 | 2022-01-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 803 | 12 | 12 | 0 |
8018 | 8018 | 2022-06-23 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1351 | 12 | 13 | 0 |
8158 | 8158 | 2022-11-10 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1825 | 12 | 13 | 0 |
8915 | 8915 | 2022-02-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3077 | 12 | 13 | 0 |
8925 | 8925 | 2022-02-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3194 | 12 | 13 | 0 |
9012 | 9012 | 2022-05-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3293 | 12 | 13 | 0 |
9326 | 9326 | 2020-06-09 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 14 | 12 | 0 | 0 |
9374 | 9374 | 2020-07-27 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 381 | 12 | 0 | 0 |
9410 | 9410 | 2020-09-01 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 613 | 12 | 0 | 0 |
9446 | 9446 | 2020-10-07 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1511 | 12 | 0 | 0 |
9465 | 9465 | 2020-10-26 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1658 | 12 | 0 | 0 |
9522 | 9522 | 2020-12-22 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1822 | 12 | 0 | 0 |
9892 | 9892 | 2021-12-27 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2086 | 12 | 1 | 0 |
9917 | 9917 | 2022-01-21 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2626 | 12 | 1 | 0 |
10054 | 10054 | 2022-06-07 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3017 | 12 | 1 | 0 |
10071 | 10071 | 2022-06-24 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3109 | 12 | 1 | 0 |
10135 | 10135 | 2022-08-27 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3335 | 12 | 1 | 0 |
10147 | 10147 | 2022-09-08 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3352 | 12 | 1 | 0 |
10227 | 10227 | 2022-11-27 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3389 | 12 | 1 | 0 |
10247 | 10247 | 2022-12-17 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3621 | 12 | 1 | 0 |
10254 | 10254 | 2022-12-24 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3712 | 12 | 1 | 0 |
11560 | 11560 | 2020-12-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 485 | 12 | 1 | 0 |
11623 | 11623 | 2021-02-09 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1078 | 12 | 5 | 0 |
11888 | 11888 | 2021-11-01 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1282 | 12 | 7 | 0 |
12019 | 12019 | 2022-03-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2087 | 12 | 8 | 0 |
12144 | 12144 | 2022-07-15 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2220 | 12 | 8 | 0 |
12147 | 12147 | 2022-07-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2243 | 12 | 8 | 0 |
12355 | 12355 | 2020-04-21 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 75 | 12 | 0 | 0 |
12994 | 12994 | 2022-01-20 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1810 | 12 | 14 | 0 |
13626 | 13626 | 2020-12-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 193 | 12 | 1 | 0 |
14023 | 14023 | 2022-01-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 486 | 12 | 2 | 0 |
14031 | 14031 | 2022-01-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 572 | 12 | 2 | 0 |
15199 | 15199 | 2022-06-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1997 | 12 | 7 | 0 |
15565 | 15565 | 2020-08-31 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 74 | 12 | 0 | 0 |
15989 | 15989 | 2021-10-29 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3094 | 12 | 7 | 0 |
16088 | 16088 | 2022-02-05 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3959 | 12 | 7 | 0 |
18046 | 18046 | 2021-11-03 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 909 | 12 | 1 | 0 |
18121 | 18121 | 2022-01-17 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 1040 | 12 | 1 | 0 |
18539 | 18539 | 2020-05-19 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 76 | 12 | 0 | 0 |
20379 | 20379 | 2022-08-11 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3468 | 12 | 21 | 0 |
22852 | 22852 | 2020-12-14 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 1699 | 12 | 1 | 0 |
22859 | 22859 | 2020-12-21 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 1862 | 12 | 1 | 0 |
22860 | 22860 | 2020-12-22 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 1874 | 12 | 1 | 0 |
23890 | 23890 | 2020-12-26 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 708 | 12 | 1 | 0 |
24281 | 24281 | 2022-01-21 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 1871 | 12 | 1 | 0 |
24294 | 24294 | 2022-02-03 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 2045 | 12 | 1 | 0 |
24495 | 24495 | 2022-08-23 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 2828 | 12 | 1 | 0 |
25639 | 25639 | 2022-12-19 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1395 | 12 | 7 | 0 |
25954 | 25954 | 2021-01-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1564 | 12 | 4 | 0 |
26324 | 26324 | 2022-01-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2040 | 12 | 9 | 0 |
26964 | 26964 | 2020-12-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 441 | 12 | 0 | 0 |
27380 | 27380 | 2022-02-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2782 | 12 | 5 | 0 |
27509 | 27509 | 2022-06-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2905 | 12 | 5 | 0 |
27962 | 27962 | 2020-11-24 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 35 | 12 | 0 | 0 |
28398 | 28398 | 2022-02-03 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 404 | 12 | 0 | 0 |
28497 | 28497 | 2022-05-13 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 569 | 12 | 0 | 0 |
28544 | 28544 | 2022-06-29 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 761 | 12 | 0 | 0 |
28552 | 28552 | 2022-07-07 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 807 | 12 | 0 | 0 |
29583 | 29583 | 2022-07-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2671 | 12 | 3 | 0 |
30043 | 30043 | 2020-12-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 811 | 12 | 1 | 0 |
30442 | 30442 | 2022-01-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1282 | 12 | 19 | 0 |
30617 | 30617 | 2022-07-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1596 | 12 | 21 | 0 |
31468 | 31468 | 2022-01-26 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 807 | 12 | 6 | 0 |
31664 | 31664 | 2022-08-10 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1074 | 12 | 6 | 0 |
31685 | 31685 | 2022-08-31 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1172 | 12 | 6 | 0 |
31948 | 31948 | 2020-07-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2214 | 12 | 20 | 0 |
32482 | 32482 | 2022-01-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2502 | 12 | 28 | 0 |
32496 | 32496 | 2022-01-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2761 | 12 | 28 | 0 |
32597 | 32597 | 2022-05-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2915 | 12 | 28 | 0 |
33128 | 33128 | 2020-12-30 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1124 | 12 | 0 | 0 |
33504 | 33504 | 2022-01-10 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1773 | 12 | 0 | 0 |
33507 | 33507 | 2022-01-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1847 | 12 | 0 | 0 |
33691 | 33691 | 2022-07-16 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3021 | 12 | 0 | 0 |
33854 | 33854 | 2022-12-26 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3378 | 12 | 0 | 0 |
34153 | 34153 | 2020-12-29 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1474 | 12 | 1 | 0 |
34734 | 34734 | 2022-08-02 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2120 | 12 | 2 | 0 |
35584 | 35584 | 2022-02-07 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 4034 | 12 | 2 | 0 |
35886 | 35886 | 2022-12-06 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 4989 | 12 | 2 | 0 |
35889 | 35889 | 2022-12-09 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5024 | 12 | 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 );