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,285 rows where deaths = 3
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, city, fips, zipcode, x, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109 | 109 | 2020-06-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 3 | 3 | 1 |
110 | 110 | 2020-06-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 0 | 3 | 0 |
111 | 111 | 2020-06-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 0 | 3 | 0 |
112 | 112 | 2020-06-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 0 | 3 | 0 |
113 | 113 | 2020-06-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 939 | 1 | 3 | 0 |
114 | 114 | 2020-07-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 940 | 1 | 3 | 0 |
115 | 115 | 2020-07-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 943 | 3 | 3 | 0 |
116 | 116 | 2020-07-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 2 | 3 | 0 |
117 | 117 | 2020-07-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 0 | 3 | 0 |
118 | 118 | 2020-07-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 0 | 3 | 0 |
119 | 119 | 2020-07-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 0 | 3 | 0 |
120 | 120 | 2020-07-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 946 | 1 | 3 | 0 |
121 | 121 | 2020-07-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 951 | 5 | 3 | 0 |
122 | 122 | 2020-07-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 952 | 1 | 3 | 0 |
123 | 123 | 2020-07-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 954 | 2 | 3 | 0 |
124 | 124 | 2020-07-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 954 | 0 | 3 | 0 |
125 | 125 | 2020-07-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 954 | 0 | 3 | 0 |
3374 | 3374 | 2020-12-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1241 | 5 | 3 | 2 |
3375 | 3375 | 2020-12-31 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1243 | 2 | 3 | 0 |
3376 | 3376 | 2021-01-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1244 | 1 | 3 | 0 |
3377 | 3377 | 2021-01-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1244 | 0 | 3 | 0 |
3378 | 3378 | 2021-01-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1248 | 4 | 3 | 0 |
3379 | 3379 | 2021-01-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1250 | 2 | 3 | 0 |
3380 | 3380 | 2021-01-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1252 | 2 | 3 | 0 |
4390 | 4390 | 2020-12-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 188 | 4 | 3 | 1 |
4391 | 4391 | 2020-12-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 189 | 1 | 3 | 0 |
4392 | 4392 | 2020-12-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 191 | 2 | 3 | 0 |
4393 | 4393 | 2020-12-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 259 | 68 | 3 | 0 |
4394 | 4394 | 2020-12-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 338 | 79 | 3 | 0 |
4395 | 4395 | 2020-12-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 346 | 8 | 3 | 0 |
5188 | 5188 | 2020-05-06 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 333 | 3 | 3 | 2 |
7486 | 7486 | 2021-01-07 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 563 | 7 | 3 | 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 |
8436 | 8436 | 2020-10-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8437 | 8437 | 2020-10-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8438 | 8438 | 2020-10-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8439 | 8439 | 2020-10-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8440 | 8440 | 2020-10-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8441 | 8441 | 2020-10-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8442 | 8442 | 2020-10-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8443 | 8443 | 2020-10-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8444 | 8444 | 2020-10-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8445 | 8445 | 2020-11-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8446 | 8446 | 2020-11-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8447 | 8447 | 2020-11-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8448 | 8448 | 2020-11-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8449 | 8449 | 2020-11-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8450 | 8450 | 2020-11-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8451 | 8451 | 2020-11-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8452 | 8452 | 2020-11-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 302 | 0 | 3 | 0 |
8453 | 8453 | 2020-11-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 1 | 3 | 0 |
8454 | 8454 | 2020-11-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8455 | 8455 | 2020-11-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8456 | 8456 | 2020-11-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8457 | 8457 | 2020-11-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8458 | 8458 | 2020-11-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8459 | 8459 | 2020-11-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8460 | 8460 | 2020-11-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 303 | 0 | 3 | 0 |
8461 | 8461 | 2020-11-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 1 | 3 | 0 |
8462 | 8462 | 2020-11-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8463 | 8463 | 2020-11-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8464 | 8464 | 2020-11-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8465 | 8465 | 2020-11-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8466 | 8466 | 2020-11-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8467 | 8467 | 2020-11-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8468 | 8468 | 2020-11-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8469 | 8469 | 2020-11-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8470 | 8470 | 2020-11-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8471 | 8471 | 2020-11-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8472 | 8472 | 2020-11-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8473 | 8473 | 2020-11-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 304 | 0 | 3 | 0 |
8474 | 8474 | 2020-11-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 305 | 1 | 3 | 0 |
8475 | 8475 | 2020-12-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 315 | 10 | 3 | 0 |
8476 | 8476 | 2020-12-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 316 | 1 | 3 | 0 |
8477 | 8477 | 2020-12-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 316 | 0 | 3 | 0 |
8478 | 8478 | 2020-12-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 353 | 37 | 3 | 0 |
8479 | 8479 | 2020-12-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 353 | 0 | 3 | 0 |
8480 | 8480 | 2020-12-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 353 | 0 | 3 | 0 |
8481 | 8481 | 2020-12-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 364 | 11 | 3 | 0 |
8482 | 8482 | 2020-12-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 421 | 57 | 3 | 0 |
8483 | 8483 | 2020-12-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 425 | 4 | 3 | 0 |
8484 | 8484 | 2020-12-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 481 | 56 | 3 | 0 |
8485 | 8485 | 2020-12-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 485 | 4 | 3 | 0 |
8486 | 8486 | 2020-12-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 486 | 1 | 3 | 0 |
8487 | 8487 | 2020-12-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 486 | 0 | 3 | 0 |
8488 | 8488 | 2020-12-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 487 | 1 | 3 | 0 |
8489 | 8489 | 2020-12-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 586 | 99 | 3 | 0 |
8490 | 8490 | 2020-12-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 587 | 1 | 3 | 0 |
8491 | 8491 | 2020-12-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 619 | 32 | 3 | 0 |
11572 | 11572 | 2020-12-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 527 | 0 | 3 | 1 |
11573 | 11573 | 2020-12-21 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 528 | 1 | 3 | 0 |
11574 | 11574 | 2020-12-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 640 | 112 | 3 | 0 |
11575 | 11575 | 2020-12-23 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 640 | 0 | 3 | 0 |
11576 | 11576 | 2020-12-24 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 640 | 0 | 3 | 0 |
12592 | 12592 | 2020-12-14 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1096 | 27 | 3 | 1 |
12593 | 12593 | 2020-12-15 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1102 | 6 | 3 | 0 |
12594 | 12594 | 2020-12-16 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1105 | 3 | 3 | 0 |
12595 | 12595 | 2020-12-17 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1108 | 3 | 3 | 0 |
12596 | 12596 | 2020-12-18 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1113 | 5 | 3 | 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 |
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 );