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.
287 rows where new_confirmed_cases = 6
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: fips, zipcode, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309 | 309 | 2021-01-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3123 | 6 | 8 | 0 |
848 | 848 | 2022-07-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4062 | 6 | 8 | 0 |
855 | 855 | 2022-07-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4070 | 6 | 8 | 0 |
871 | 871 | 2022-07-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4134 | 6 | 8 | 0 |
875 | 875 | 2022-08-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4142 | 6 | 8 | 0 |
1328 | 1328 | 2021-01-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 908 | 6 | 0 | 0 |
1843 | 1843 | 2022-06-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1288 | 6 | 2 | 0 |
2188 | 2188 | 2020-07-23 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 523 | 6 | 0 | 0 |
2208 | 2208 | 2020-08-12 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 650 | 6 | 0 | 0 |
2361 | 2361 | 2021-01-12 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1267 | 6 | 0 | 0 |
2388 | 2388 | 2021-02-08 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1343 | 6 | 0 | 0 |
2916 | 2916 | 2022-07-21 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2260 | 6 | 0 | 0 |
2931 | 2931 | 2022-08-05 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2391 | 6 | 0 | 0 |
2937 | 2937 | 2022-08-11 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2504 | 6 | 0 | 0 |
3191 | 3191 | 2020-06-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 121 | 6 | 0 | 0 |
3242 | 3242 | 2020-08-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 790 | 6 | 0 | 0 |
3390 | 3390 | 2021-01-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1291 | 6 | 4 | 0 |
3397 | 3397 | 2021-01-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1348 | 6 | 4 | 0 |
3417 | 3417 | 2021-02-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1393 | 6 | 4 | 0 |
3752 | 3752 | 2022-01-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1461 | 6 | 4 | 0 |
3754 | 3754 | 2022-01-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1505 | 6 | 4 | 0 |
3764 | 3764 | 2022-01-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1585 | 6 | 4 | 0 |
3771 | 3771 | 2022-01-31 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1614 | 6 | 4 | 0 |
3957 | 3957 | 2022-08-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1745 | 6 | 4 | 0 |
4937 | 4937 | 2022-06-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1316 | 6 | 22 | 0 |
5056 | 5056 | 2022-10-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1845 | 6 | 22 | 0 |
5180 | 5180 | 2020-04-28 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 122 | 6 | 1 | 0 |
5201 | 5201 | 2020-05-19 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 620 | 6 | 6 | 0 |
5210 | 5210 | 2020-05-28 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 659 | 6 | 9 | 0 |
5217 | 5217 | 2020-06-04 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 720 | 6 | 12 | 0 |
5224 | 5224 | 2020-06-11 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 802 | 6 | 13 | 0 |
5320 | 5320 | 2020-09-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1139 | 6 | 23 | 0 |
5335 | 5335 | 2020-09-30 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1359 | 6 | 24 | 0 |
5809 | 5809 | 2022-01-17 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2381 | 6 | 30 | 0 |
5826 | 5826 | 2022-02-03 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2597 | 6 | 30 | 0 |
6012 | 6012 | 2022-08-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2924 | 6 | 30 | 0 |
6013 | 6013 | 2022-08-09 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2930 | 6 | 30 | 0 |
6022 | 6022 | 2022-08-18 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3116 | 6 | 30 | 0 |
6132 | 6132 | 2022-12-06 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3859 | 6 | 30 | 0 |
6289 | 6289 | 2020-07-20 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 194 | 6 | 1 | 0 |
6430 | 6430 | 2020-12-08 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 401 | 6 | 1 | 0 |
6825 | 6825 | 2022-01-07 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 536 | 6 | 1 | 0 |
6841 | 6841 | 2022-01-23 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 649 | 6 | 1 | 0 |
7003 | 7003 | 2022-07-04 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 756 | 6 | 1 | 0 |
7014 | 7014 | 2022-07-15 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 883 | 6 | 1 | 0 |
7087 | 7087 | 2022-09-26 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 908 | 6 | 1 | 0 |
7116 | 7116 | 2022-10-25 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 1026 | 6 | 1 | 0 |
7847 | 7847 | 2022-01-03 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 754 | 6 | 12 | 0 |
7858 | 7858 | 2022-01-14 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 819 | 6 | 12 | 0 |
7869 | 7869 | 2022-01-25 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 862 | 6 | 12 | 0 |
7870 | 7870 | 2022-01-26 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 868 | 6 | 12 | 0 |
8036 | 8036 | 2022-07-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1403 | 6 | 13 | 0 |
8054 | 8054 | 2022-07-29 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1507 | 6 | 13 | 0 |
8089 | 8089 | 2022-09-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1626 | 6 | 13 | 0 |
8160 | 8160 | 2022-11-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1841 | 6 | 13 | 0 |
8397 | 8397 | 2020-09-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 297 | 6 | 2 | 0 |
8496 | 8496 | 2020-12-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 685 | 6 | 4 | 0 |
8881 | 8881 | 2022-01-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2521 | 6 | 13 | 0 |
9020 | 9020 | 2022-05-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3341 | 6 | 13 | 0 |
9062 | 9062 | 2022-07-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3631 | 6 | 13 | 0 |
9073 | 9073 | 2022-07-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3659 | 6 | 13 | 0 |
9085 | 9085 | 2022-08-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3675 | 6 | 13 | 0 |
9389 | 9389 | 2020-08-11 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 408 | 6 | 0 | 0 |
9397 | 9397 | 2020-08-19 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 476 | 6 | 0 | 0 |
9409 | 9409 | 2020-08-31 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 601 | 6 | 0 | 0 |
9448 | 9448 | 2020-10-09 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1582 | 6 | 0 | 0 |
9472 | 9472 | 2020-11-02 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1665 | 6 | 0 | 0 |
9502 | 9502 | 2020-12-02 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1682 | 6 | 0 | 0 |
9515 | 9515 | 2020-12-15 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1751 | 6 | 0 | 0 |
9528 | 9528 | 2020-12-28 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1845 | 6 | 0 | 0 |
9536 | 9536 | 2021-01-05 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1932 | 6 | 1 | 0 |
9921 | 9921 | 2022-01-25 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2659 | 6 | 1 | 0 |
10096 | 10096 | 2022-07-19 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3118 | 6 | 1 | 0 |
10509 | 10509 | 2020-11-13 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 95 | 6 | 0 | 0 |
10517 | 10517 | 2020-11-21 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 139 | 6 | 0 | 0 |
10547 | 10547 | 2020-12-21 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 762 | 6 | 1 | 0 |
10554 | 10554 | 2020-12-28 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 800 | 6 | 1 | 0 |
10563 | 10563 | 2021-01-06 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 829 | 6 | 1 | 0 |
10591 | 10591 | 2021-02-03 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 855 | 6 | 1 | 0 |
10841 | 10841 | 2021-10-11 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 874 | 6 | 1 | 0 |
11093 | 11093 | 2022-06-20 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 1079 | 6 | 1 | 0 |
11128 | 11128 | 2022-07-25 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 1130 | 6 | 1 | 0 |
11630 | 11630 | 2021-02-16 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1086 | 6 | 5 | 0 |
11895 | 11895 | 2021-11-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1289 | 6 | 7 | 0 |
11937 | 11937 | 2021-12-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1362 | 6 | 7 | 0 |
11947 | 11947 | 2021-12-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1385 | 6 | 7 | 0 |
12159 | 12159 | 2022-07-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2363 | 6 | 8 | 0 |
12164 | 12164 | 2022-08-04 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2389 | 6 | 8 | 0 |
12282 | 12282 | 2022-11-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2534 | 6 | 8 | 0 |
12353 | 12353 | 2020-04-19 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 62 | 6 | 0 | 0 |
12361 | 12361 | 2020-04-27 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 89 | 6 | 0 | 0 |
12470 | 12470 | 2020-08-14 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 146 | 6 | 0 | 0 |
12593 | 12593 | 2020-12-15 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1102 | 6 | 3 | 0 |
12616 | 12616 | 2021-01-07 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1458 | 6 | 11 | 0 |
13002 | 13002 | 2022-01-28 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1864 | 6 | 14 | 0 |
13305 | 13305 | 2022-11-27 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 2215 | 6 | 15 | 0 |
13656 | 13656 | 2021-01-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 278 | 6 | 1 | 0 |
13990 | 13990 | 2021-12-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 324 | 6 | 1 | 0 |
13997 | 13997 | 2021-12-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 347 | 6 | 1 | 0 |
14013 | 14013 | 2022-01-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 399 | 6 | 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 );