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.
217 rows where new_deaths = 1 sorted by code
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, code, county, fips, zipcode, x, y, confirmed_cases, new_confirmed_cases, date (date)
name 31 ✖
- California Institution for Men 26
- California Health Care Facility 19
- Correctional Training Facility 19
- San Quentin State Prison 16
- Richard J. Donovan Correctional Facility 15
- California Medical Facility 13
- California Men's Colony 13
- California State Prison, Los Angeles 11
- Chuckawalla Valley State Prison 9
- Avenal State Prison 8
- California State Prison, Corcoran 8
- California State Prison, Solano 7
- Mule Creek State Prison 7
- Salinas Valley State Prison 6
- California Substance Abuse Treatment Facility and State Prison, Corcoran 5
- Kern Valley State Prison 5
- North Kern State Prison 5
- Calipatria State Prison 3
- Pleasant Valley State Prison 3
- California City Correctional Facility 2
- California Correctional Institution 2
- California State Prison, Sacramento 2
- Folsom State Prison 2
- High Desert State Prison 2
- Valley State Prison 2
- Wasco State Prison 2
- California Institution for Women 1
- California Rehabilitation Center 1
- California State Prison, Centinela 1
- Central California Women's Facility 1
- Ironwood State Prison 1
Link | rowid | date | code ▼ | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103 | 103 | 2020-06-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 928 | 0 | 1 | 1 |
106 | 106 | 2020-06-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 932 | 1 | 2 | 1 |
109 | 109 | 2020-06-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 3 | 3 | 1 |
126 | 126 | 2020-07-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 956 | 2 | 4 | 1 |
137 | 137 | 2020-07-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1161 | 58 | 5 | 1 |
201 | 201 | 2020-09-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2662 | 0 | 6 | 1 |
205 | 205 | 2020-09-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2831 | 35 | 7 | 1 |
235 | 235 | 2020-10-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 2 | 8 | 1 |
1331 | 1331 | 2021-01-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 924 | 13 | 1 | 1 |
1336 | 1336 | 2021-01-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 933 | 0 | 2 | 1 |
16711 | 16711 | 2020-12-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 719 | 82 | 1 | 1 |
16718 | 16718 | 2021-01-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 754 | 3 | 2 | 1 |
17049 | 17049 | 2021-12-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1170 | 0 | 3 | 1 |
3370 | 3370 | 2020-12-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1217 | 1 | 1 | 1 |
3381 | 3381 | 2021-01-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1257 | 5 | 4 | 1 |
17807 | 17807 | 2021-03-09 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 803 | 0 | 1 | 1 |
10530 | 10530 | 2020-12-04 | CEN | California State Prison, Centinela | Imperial | Imperial | 25 | 92251 | -115.7744787 | 32.7956026 | 393 | 7 | 1 | 1 |
4273 | 4273 | 2020-08-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 1 |
4383 | 4383 | 2020-12-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 52 | 1 | 2 | 1 |
4390 | 4390 | 2020-12-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 188 | 4 | 3 | 1 |
4396 | 4396 | 2020-12-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 347 | 1 | 4 | 1 |
4401 | 4401 | 2020-12-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 441 | 34 | 5 | 1 |
4403 | 4403 | 2021-01-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 506 | 3 | 6 | 1 |
4404 | 4404 | 2021-01-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 510 | 4 | 7 | 1 |
4411 | 4411 | 2021-01-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 554 | 0 | 10 | 1 |
4415 | 4415 | 2021-01-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 566 | 2 | 11 | 1 |
4417 | 4417 | 2021-01-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 567 | 0 | 12 | 1 |
4427 | 4427 | 2021-01-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 595 | 2 | 13 | 1 |
4430 | 4430 | 2021-01-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 603 | 0 | 14 | 1 |
4435 | 4435 | 2021-02-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 614 | 2 | 15 | 1 |
4440 | 4440 | 2021-02-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 615 | 0 | 18 | 1 |
4528 | 4528 | 2021-05-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 632 | 0 | 19 | 1 |
4797 | 4797 | 2022-01-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 877 | 11 | 20 | 1 |
4914 | 4914 | 2022-05-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1190 | 13 | 21 | 1 |
4916 | 4916 | 2022-05-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1218 | 27 | 22 | 1 |
5065 | 5065 | 2022-10-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1846 | 0 | 23 | 1 |
5171 | 5171 | 2020-04-19 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 67 | 3 | 1 | 1 |
5189 | 5189 | 2020-05-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 375 | 42 | 4 | 1 |
5191 | 5191 | 2020-05-09 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 396 | 0 | 5 | 1 |
5200 | 5200 | 2020-05-18 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 614 | 4 | 6 | 1 |
5205 | 5205 | 2020-05-23 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 634 | 0 | 7 | 1 |
5213 | 5213 | 2020-05-31 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 690 | 13 | 10 | 1 |
5215 | 5215 | 2020-06-02 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 707 | 14 | 11 | 1 |
5216 | 5216 | 2020-06-03 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 714 | 7 | 12 | 1 |
5223 | 5223 | 2020-06-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 796 | 5 | 13 | 1 |
5227 | 5227 | 2020-06-14 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 831 | 0 | 14 | 1 |
5228 | 5228 | 2020-06-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 835 | 4 | 15 | 1 |
5230 | 5230 | 2020-06-17 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 844 | 4 | 16 | 1 |
5249 | 5249 | 2020-07-06 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 944 | 22 | 17 | 1 |
5257 | 5257 | 2020-07-14 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1044 | 46 | 18 | 1 |
5258 | 5258 | 2020-07-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1045 | 1 | 19 | 1 |
5287 | 5287 | 2020-08-13 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1107 | 0 | 20 | 1 |
5296 | 5296 | 2020-08-22 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1110 | 0 | 21 | 1 |
5307 | 5307 | 2020-09-02 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1121 | 2 | 22 | 1 |
5312 | 5312 | 2020-09-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1124 | 0 | 23 | 1 |
5331 | 5331 | 2020-09-26 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1291 | 2 | 24 | 1 |
5350 | 5350 | 2020-10-15 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1423 | 1 | 25 | 1 |
5361 | 5361 | 2020-10-26 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1434 | 0 | 26 | 1 |
5366 | 5366 | 2020-10-31 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1435 | 0 | 27 | 1 |
5459 | 5459 | 2021-02-01 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1536 | 0 | 28 | 1 |
5475 | 5475 | 2021-02-17 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1539 | 0 | 29 | 1 |
5525 | 5525 | 2021-04-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1542 | 0 | 30 | 1 |
6248 | 6248 | 2020-06-09 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 163 | 0 | 1 | 1 |
8370 | 8370 | 2020-08-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 233 | 8 | 1 | 1 |
8384 | 8384 | 2020-09-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 271 | 0 | 2 | 1 |
8435 | 8435 | 2020-10-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 1 |
8492 | 8492 | 2020-12-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 623 | 4 | 4 | 1 |
8519 | 8519 | 2021-01-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2272 | 2 | 5 | 1 |
8520 | 8520 | 2021-01-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2277 | 5 | 6 | 1 |
8527 | 8527 | 2021-01-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2442 | 0 | 7 | 1 |
8535 | 8535 | 2021-01-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2478 | 0 | 8 | 1 |
8536 | 8536 | 2021-01-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2478 | 0 | 9 | 1 |
8538 | 8538 | 2021-02-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2484 | 5 | 10 | 1 |
8544 | 8544 | 2021-02-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2486 | 0 | 11 | 1 |
8554 | 8554 | 2021-02-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2486 | 0 | 12 | 1 |
8650 | 8650 | 2021-05-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 1 |
7481 | 7481 | 2021-01-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 461 | 5 | 1 | 1 |
7485 | 7485 | 2021-01-06 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 556 | 14 | 2 | 1 |
7486 | 7486 | 2021-01-07 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 563 | 7 | 3 | 1 |
7487 | 7487 | 2021-01-08 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 582 | 19 | 4 | 1 |
7489 | 7489 | 2021-01-10 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 586 | 1 | 5 | 1 |
7492 | 7492 | 2021-01-13 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 678 | 16 | 6 | 1 |
7493 | 7493 | 2021-01-14 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 681 | 3 | 7 | 1 |
7504 | 7504 | 2021-01-25 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 694 | 0 | 8 | 1 |
7515 | 7515 | 2021-02-05 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 712 | 2 | 9 | 1 |
7521 | 7521 | 2021-02-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 713 | 1 | 10 | 1 |
7532 | 7532 | 2021-02-22 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 713 | 0 | 11 | 1 |
7614 | 7614 | 2021-05-15 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 713 | 0 | 12 | 1 |
7894 | 7894 | 2022-02-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1080 | 1 | 13 | 1 |
11406 | 11406 | 2020-07-07 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 158 | 1 | 1 | 1 |
11570 | 11570 | 2020-12-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 527 | 2 | 2 | 1 |
11572 | 11572 | 2020-12-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 527 | 0 | 3 | 1 |
11577 | 11577 | 2020-12-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 640 | 0 | 4 | 1 |
11601 | 11601 | 2021-01-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 921 | 0 | 5 | 1 |
11648 | 11648 | 2021-03-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1092 | 0 | 6 | 1 |
11819 | 11819 | 2021-08-24 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1115 | 1 | 7 | 1 |
11983 | 11983 | 2022-02-04 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1834 | 7 | 8 | 1 |
9535 | 9535 | 2021-01-04 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 1926 | 14 | 1 | 1 |
19658 | 19658 | 2020-08-20 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 70 | 27 | 1 | 1 |
19749 | 19749 | 2020-11-19 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 696 | 21 | 2 | 1 |
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 );