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.
1,376 rows where new_confirmed_cases = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, fips, zipcode, y, new_deaths, date (date)
name 35 ✖
- Wasco State Prison 65
- California Health Care Facility 63
- Kern Valley State Prison 61
- North Kern State Prison 58
- Ironwood State Prison 52
- Mule Creek State Prison 52
- Salinas Valley State Prison 52
- California Correctional Institution 49
- California Medical Facility 47
- Avenal State Prison 44
- California State Prison, Los Angeles 44
- Valley State Prison 44
- California Institution for Men 43
- California State Prison, Corcoran 41
- California State Prison, Sacramento 41
- Central California Women's Facility 41
- Folsom State Prison 41
- California State Prison, Centinela 40
- San Quentin State Prison 40
- California Correctional Center 38
- California Institution for Women 36
- California Rehabilitation Center 35
- High Desert State Prison 35
- California Substance Abuse Treatment Facility and State Prison, Corcoran 34
- Sierra Conservation Center 34
- Calipatria State Prison 32
- Correctional Training Facility 32
- California State Prison, Solano 30
- Pelican Bay State Prison 30
- Richard J. Donovan Correctional Facility 26
- California City Correctional Facility 24
- Pleasant Valley State Prison 23
- California Men's Colony 20
- Chuckawalla Valley State Prison 19
- Deuel Vocational Institute 10
city 26 ✖
- Delano 119
- Chowchilla 85
- Soledad 84
- Represa 82
- Chino 79
- Vacaville 77
- Corcoran 75
- Susanville 73
- Blythe 71
- Wasco 65
- Stockton 63
- Ione 52
- Tehachapi 49
- Avenal 44
- Lancaster 44
- Imperial 40
- San Quentin 40
- Norco 35
- Jamestown 34
- Calipatria 32
- Crescent City 30
- San Diego 26
- California City 24
- Coalinga 23
- San Luis Obispo 20
- Tracy 10
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27701 | 27701 | 2022-12-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4261 | 2 | 5 | 0 |
28727 | 28727 | 2022-12-29 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 921 | 2 | 0 | 0 |
5128 | 5128 | 2022-12-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1908 | 2 | 23 | 0 |
8206 | 8206 | 2022-12-28 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1980 | 2 | 13 | 0 |
9232 | 9232 | 2022-12-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3719 | 2 | 13 | 0 |
28726 | 28726 | 2022-12-28 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 919 | 2 | 0 | 0 |
7179 | 7179 | 2022-12-27 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 1060 | 2 | 1 | 0 |
11283 | 11283 | 2022-12-27 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 1190 | 2 | 1 | 0 |
13335 | 13335 | 2022-12-27 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2308 | 2 | 15 | 0 |
22569 | 22569 | 2022-12-27 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2907 | 2 | 2 | 0 |
26673 | 26673 | 2022-12-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3348 | 2 | 9 | 0 |
30777 | 30777 | 2022-12-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1745 | 2 | 21 | 0 |
18464 | 18464 | 2022-12-26 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2367 | 2 | 1 | 0 |
33853 | 33853 | 2022-12-25 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3366 | 2 | 0 | 0 |
9227 | 9227 | 2022-12-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3714 | 2 | 13 | 0 |
23591 | 23591 | 2022-12-23 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 2294 | 2 | 2 | 0 |
26669 | 26669 | 2022-12-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3341 | 2 | 9 | 0 |
5122 | 5122 | 2022-12-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1896 | 2 | 23 | 0 |
12304 | 12304 | 2022-12-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2606 | 2 | 8 | 0 |
22564 | 22564 | 2022-12-22 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2905 | 2 | 2 | 0 |
7173 | 7173 | 2022-12-21 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 1056 | 2 | 1 | 0 |
18459 | 18459 | 2022-12-21 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2339 | 2 | 1 | 0 |
8198 | 8198 | 2022-12-20 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1964 | 2 | 13 | 0 |
24614 | 24614 | 2022-12-20 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 3144 | 2 | 1 | 0 |
32822 | 32822 | 2022-12-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 2 | 28 | 0 |
6145 | 6145 | 2022-12-19 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3864 | 2 | 30 | 0 |
8197 | 8197 | 2022-12-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1962 | 2 | 13 | 0 |
12301 | 12301 | 2022-12-19 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2602 | 2 | 8 | 0 |
14353 | 14353 | 2022-12-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 999 | 2 | 2 | 0 |
15379 | 15379 | 2022-12-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2055 | 2 | 7 | 0 |
5118 | 5118 | 2022-12-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1884 | 2 | 23 | 0 |
18456 | 18456 | 2022-12-18 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2327 | 2 | 1 | 0 |
5116 | 5116 | 2022-12-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1878 | 2 | 23 | 0 |
26662 | 26662 | 2022-12-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3326 | 2 | 9 | 0 |
33844 | 33844 | 2022-12-16 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3346 | 2 | 0 | 0 |
18453 | 18453 | 2022-12-15 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2321 | 2 | 1 | 0 |
15374 | 15374 | 2022-12-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2052 | 2 | 7 | 0 |
25634 | 25634 | 2022-12-14 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1361 | 2 | 7 | 0 |
26660 | 26660 | 2022-12-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3324 | 2 | 9 | 0 |
8191 | 8191 | 2022-12-13 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1948 | 2 | 13 | 0 |
12295 | 12295 | 2022-12-13 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2589 | 2 | 8 | 0 |
32815 | 32815 | 2022-12-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 2 | 28 | 0 |
33841 | 33841 | 2022-12-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3341 | 2 | 0 | 0 |
5112 | 5112 | 2022-12-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1872 | 2 | 23 | 0 |
11268 | 11268 | 2022-12-12 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 1186 | 2 | 1 | 0 |
13320 | 13320 | 2022-12-12 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2266 | 2 | 15 | 0 |
18450 | 18450 | 2022-12-12 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2313 | 2 | 1 | 0 |
32814 | 32814 | 2022-12-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3234 | 2 | 28 | 0 |
33840 | 33840 | 2022-12-12 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3339 | 2 | 0 | 0 |
5111 | 5111 | 2022-12-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1870 | 2 | 23 | 0 |
8189 | 8189 | 2022-12-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1946 | 2 | 13 | 0 |
13319 | 13319 | 2022-12-11 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2264 | 2 | 15 | 0 |
23579 | 23579 | 2022-12-11 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 2285 | 2 | 2 | 0 |
14344 | 14344 | 2022-12-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 988 | 2 | 2 | 0 |
22552 | 22552 | 2022-12-10 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2888 | 2 | 2 | 0 |
25630 | 25630 | 2022-12-10 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1347 | 2 | 7 | 0 |
7161 | 7161 | 2022-12-09 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 1049 | 2 | 1 | 0 |
10239 | 10239 | 2022-12-09 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3541 | 2 | 1 | 0 |
18447 | 18447 | 2022-12-09 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2309 | 2 | 1 | 0 |
31785 | 31785 | 2022-12-09 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1268 | 2 | 6 | 0 |
26654 | 26654 | 2022-12-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3318 | 2 | 9 | 0 |
14341 | 14341 | 2022-12-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 985 | 2 | 2 | 0 |
31783 | 31783 | 2022-12-07 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1265 | 2 | 6 | 0 |
33835 | 33835 | 2022-12-07 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3293 | 2 | 0 | 0 |
35887 | 35887 | 2022-12-07 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 4991 | 2 | 2 | 0 |
13314 | 13314 | 2022-12-06 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2250 | 2 | 15 | 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 |
34860 | 34860 | 2022-12-06 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 2245 | 2 | 2 | 0 |
10235 | 10235 | 2022-12-05 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3490 | 2 | 1 | 0 |
14339 | 14339 | 2022-12-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 983 | 2 | 2 | 0 |
24599 | 24599 | 2022-12-05 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 3137 | 2 | 1 | 0 |
33833 | 33833 | 2022-12-05 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 3288 | 2 | 0 | 0 |
7156 | 7156 | 2022-12-04 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 1037 | 2 | 1 | 0 |
14338 | 14338 | 2022-12-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 981 | 2 | 2 | 0 |
24598 | 24598 | 2022-12-04 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 3135 | 2 | 1 | 0 |
25624 | 25624 | 2022-12-04 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1331 | 2 | 7 | 0 |
8181 | 8181 | 2022-12-03 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1931 | 2 | 13 | 0 |
14337 | 14337 | 2022-12-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 979 | 2 | 2 | 0 |
22544 | 22544 | 2022-12-02 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2881 | 2 | 2 | 0 |
7153 | 7153 | 2022-12-01 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 1033 | 2 | 1 | 0 |
25621 | 25621 | 2022-12-01 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1328 | 2 | 7 | 0 |
13308 | 13308 | 2022-11-30 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2223 | 2 | 15 | 0 |
14334 | 14334 | 2022-11-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 975 | 2 | 2 | 0 |
31776 | 31776 | 2022-11-30 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1252 | 2 | 6 | 0 |
32802 | 32802 | 2022-11-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3229 | 2 | 28 | 0 |
6125 | 6125 | 2022-11-29 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3852 | 2 | 30 | 0 |
8177 | 8177 | 2022-11-29 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1928 | 2 | 13 | 0 |
10229 | 10229 | 2022-11-29 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3407 | 2 | 1 | 0 |
11255 | 11255 | 2022-11-29 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 1168 | 2 | 1 | 0 |
13307 | 13307 | 2022-11-29 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2221 | 2 | 15 | 0 |
18437 | 18437 | 2022-11-29 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2280 | 2 | 1 | 0 |
26645 | 26645 | 2022-11-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 2 | 9 | 0 |
18436 | 18436 | 2022-11-28 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2278 | 2 | 1 | 0 |
24592 | 24592 | 2022-11-28 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 3127 | 2 | 1 | 0 |
25618 | 25618 | 2022-11-28 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1316 | 2 | 7 | 0 |
31774 | 31774 | 2022-11-28 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1250 | 2 | 6 | 0 |
12279 | 12279 | 2022-11-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2502 | 2 | 8 | 0 |
18435 | 18435 | 2022-11-27 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2276 | 2 | 1 | 0 |
8174 | 8174 | 2022-11-26 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1922 | 2 | 13 | 0 |
18434 | 18434 | 2022-11-26 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 2274 | 2 | 1 | 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 );