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.
35,910 rows sorted by new_confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: city, county, x, y, deaths, new_deaths, date (date)
name 35 ✖
- Avenal State Prison 1,026
- California City Correctional Facility 1,026
- California Correctional Center 1,026
- California Correctional Institution 1,026
- California Health Care Facility 1,026
- California Institution for Men 1,026
- California Institution for Women 1,026
- California Medical Facility 1,026
- California Men's Colony 1,026
- California Rehabilitation Center 1,026
- California State Prison, Centinela 1,026
- California State Prison, Corcoran 1,026
- California State Prison, Los Angeles 1,026
- California State Prison, Sacramento 1,026
- California State Prison, Solano 1,026
- California Substance Abuse Treatment Facility and State Prison, Corcoran 1,026
- Calipatria State Prison 1,026
- Central California Women's Facility 1,026
- Chuckawalla Valley State Prison 1,026
- Correctional Training Facility 1,026
- Deuel Vocational Institute 1,026
- Folsom State Prison 1,026
- High Desert State Prison 1,026
- Ironwood State Prison 1,026
- Kern Valley State Prison 1,026
- Mule Creek State Prison 1,026
- North Kern State Prison 1,026
- Pelican Bay State Prison 1,026
- Pleasant Valley State Prison 1,026
- Richard J. Donovan Correctional Facility 1,026
- Salinas Valley State Prison 1,026
- San Quentin State Prison 1,026
- Sierra Conservation Center 1,026
- Valley State Prison 1,026
- Wasco State Prison 1,026
Link | rowid | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases ▲ | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2020-03-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | ||
1027 | 1027 | 2020-03-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | ||
2053 | 2053 | 2020-03-10 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 0 | 0 | ||
3079 | 3079 | 2020-03-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 0 | 0 | ||
4105 | 4105 | 2020-03-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | ||
5131 | 5131 | 2020-03-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 0 | 0 | ||
6157 | 6157 | 2020-03-10 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 0 | 0 | ||
7183 | 7183 | 2020-03-10 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | ||
8209 | 8209 | 2020-03-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 0 | 0 | ||
9235 | 9235 | 2020-03-10 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 0 | 0 | ||
10261 | 10261 | 2020-03-10 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 0 | 0 | ||
11287 | 11287 | 2020-03-10 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | ||
12313 | 12313 | 2020-03-10 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 0 | 0 | ||
13339 | 13339 | 2020-03-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | ||
14365 | 14365 | 2020-03-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | ||
15391 | 15391 | 2020-03-10 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | ||
16417 | 16417 | 2020-03-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | ||
17443 | 17443 | 2020-03-10 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 0 | 0 | ||
18469 | 18469 | 2020-03-10 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 0 | 0 | ||
19495 | 19495 | 2020-03-10 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 0 | 0 | ||
20521 | 20521 | 2020-03-10 | DVI | Deuel Vocational Institute | Tracy | San Joaquin | 77 | 95304 | -121.3299863 | 37.747725 | 0 | 0 | ||
21547 | 21547 | 2020-03-10 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 0 | 0 | ||
22573 | 22573 | 2020-03-10 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 0 | 0 | ||
23599 | 23599 | 2020-03-10 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 0 | 0 | ||
24625 | 24625 | 2020-03-10 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 0 | 0 | ||
25651 | 25651 | 2020-03-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | ||
26677 | 26677 | 2020-03-10 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 0 | 0 | ||
27703 | 27703 | 2020-03-10 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 0 | 0 | ||
28729 | 28729 | 2020-03-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 0 | 0 | ||
29755 | 29755 | 2020-03-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | ||
30781 | 30781 | 2020-03-10 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 0 | 0 | ||
31807 | 31807 | 2020-03-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | ||
32833 | 32833 | 2020-03-10 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | ||
33859 | 33859 | 2020-03-10 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 0 | 0 | ||
34885 | 34885 | 2020-03-10 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 0 | 0 | ||
28994 | 28994 | 2020-11-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 985 | 494 | 1 | 0 |
29002 | 29002 | 2020-12-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 1688 | 428 | 1 | 0 |
15650 | 15650 | 2020-11-24 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2063 | 346 | 1 | 0 |
33116 | 33116 | 2020-12-18 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 876 | 331 | 0 | 0 |
81 | 81 | 2020-05-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 600 | 320 | 0 | 0 |
31918 | 31918 | 2020-06-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 1506 | 297 | 1 | 0 |
12586 | 12586 | 2020-12-08 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 705 | 271 | 1 | 0 |
25925 | 25925 | 2020-12-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 888 | 271 | 1 | 0 |
12587 | 12587 | 2020-12-09 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 971 | 266 | 1 | 0 |
27347 | 27347 | 2022-01-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 1702 | 263 | 5 | 0 |
16079 | 16079 | 2022-01-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 3745 | 261 | 7 | 0 |
35558 | 35558 | 2022-01-12 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 2825 | 254 | 2 | 0 |
2341 | 2341 | 2020-12-23 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1123 | 246 | 0 | 0 |
18547 | 18547 | 2020-05-27 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 390 | 241 | 0 | 0 |
18549 | 18549 | 2020-05-29 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 794 | 241 | 0 | 0 |
35567 | 35567 | 2022-01-21 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 3622 | 241 | 2 | 0 |
15659 | 15659 | 2020-12-03 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2659 | 240 | 3 | 0 |
85 | 85 | 2020-06-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 839 | 238 | 0 | 0 |
33109 | 33109 | 2020-12-11 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 442 | 238 | 0 | 0 |
15618 | 15618 | 2020-10-23 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 581 | 231 | 0 | 0 |
31913 | 31913 | 2020-06-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 1011 | 220 | 0 | 0 |
24899 | 24899 | 2020-12-09 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 463 | 209 | 0 | 0 |
22220 | 22220 | 2022-01-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1990 | 205 | 2 | 0 |
15643 | 15643 | 2020-11-17 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1520 | 202 | 0 | 0 |
22845 | 22845 | 2020-12-07 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 1489 | 199 | 1 | 0 |
27356 | 27356 | 2022-01-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2311 | 197 | 5 | 0 |
30024 | 30024 | 2020-12-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 197 | 194 | 0 | 0 |
31912 | 31912 | 2020-06-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 791 | 192 | 0 | 0 |
141 | 141 | 2020-07-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1367 | 191 | 5 | 0 |
8511 | 8511 | 2021-01-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 1764 | 187 | 4 | 0 |
19149 | 19149 | 2022-01-19 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 2283 | 186 | 9 | 0 |
8510 | 8510 | 2021-01-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 1577 | 185 | 4 | 0 |
21735 | 21735 | 2020-09-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 886 | 183 | 0 | 0 |
15658 | 15658 | 2020-12-02 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2419 | 182 | 3 | 0 |
8509 | 8509 | 2021-01-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 1392 | 181 | 4 | 0 |
29010 | 29010 | 2020-12-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 1886 | 181 | 1 | 0 |
23886 | 23886 | 2020-12-22 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 576 | 180 | 1 | 0 |
19768 | 19768 | 2020-12-08 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 1429 | 174 | 4 | 0 |
18553 | 18553 | 2020-06-02 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 987 | 171 | 0 | 0 |
28982 | 28982 | 2020-11-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 364 | 168 | 1 | 0 |
9432 | 9432 | 2020-09-23 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1143 | 167 | 0 | 0 |
19763 | 19763 | 2020-12-03 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 1142 | 167 | 4 | 0 |
35566 | 35566 | 2022-01-20 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 3381 | 166 | 2 | 0 |
8512 | 8512 | 2021-01-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 1929 | 165 | 4 | 0 |
176 | 176 | 2020-09-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2089 | 164 | 5 | 0 |
12597 | 12597 | 2020-12-19 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1276 | 163 | 3 | 0 |
18548 | 18548 | 2020-05-28 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 553 | 163 | 0 | 0 |
24900 | 24900 | 2020-12-10 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 626 | 163 | 0 | 0 |
28995 | 28995 | 2020-12-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 1147 | 162 | 1 | 0 |
22825 | 22825 | 2020-11-17 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 500 | 159 | 1 | 1 |
31914 | 31914 | 2020-06-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 1170 | 159 | 1 | 1 |
31926 | 31926 | 2020-07-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 1972 | 159 | 9 | 1 |
22218 | 22218 | 2022-01-10 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 1706 | 158 | 2 | 0 |
23921 | 23921 | 2021-01-26 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 1271 | 158 | 1 | 0 |
35161 | 35161 | 2020-12-11 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 685 | 157 | 0 | 0 |
15651 | 15651 | 2020-11-25 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2219 | 156 | 1 | 0 |
15663 | 15663 | 2020-12-07 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 2814 | 152 | 6 | 0 |
27351 | 27351 | 2022-01-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 1999 | 150 | 5 | 0 |
31904 | 31904 | 2020-06-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 198 | 149 | 0 | 0 |
164 | 164 | 2020-08-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1752 | 147 | 5 | 0 |
19155 | 19155 | 2022-01-25 | CVSP | Chuckawalla Valley State Prison | Blythe | Riverside | 65 | 92225 | -114.9072763 | 33.5629667 | 2518 | 147 | 9 | 0 |
33521 | 33521 | 2022-01-27 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 2563 | 147 | 0 | 0 |
35573 | 35573 | 2022-01-27 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 3859 | 146 | 2 | 0 |
27358 | 27358 | 2022-01-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2464 | 145 | 5 | 0 |
31907 | 31907 | 2020-06-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 465 | 144 | 0 | 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 );