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.
408 rows where new_confirmed_cases = 5
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: city, county, zipcode, deaths, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121 | 121 | 2020-07-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 951 | 5 | 3 | 0 |
165 | 165 | 2020-08-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1757 | 5 | 5 | 0 |
200 | 200 | 2020-09-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2662 | 5 | 5 | 0 |
242 | 242 | 2020-11-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 5 | 8 | 0 |
268 | 268 | 2020-12-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3012 | 5 | 8 | 0 |
297 | 297 | 2020-12-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 5 | 8 | 0 |
697 | 697 | 2022-02-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3959 | 5 | 8 | 0 |
856 | 856 | 2022-07-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4075 | 5 | 8 | 0 |
862 | 862 | 2022-07-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4095 | 5 | 8 | 0 |
903 | 903 | 2022-08-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4162 | 5 | 8 | 0 |
905 | 905 | 2022-08-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4168 | 5 | 8 | 0 |
912 | 912 | 2022-09-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4180 | 5 | 8 | 0 |
917 | 917 | 2022-09-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4189 | 5 | 8 | 0 |
994 | 994 | 2022-11-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4335 | 5 | 8 | 0 |
1294 | 1294 | 2020-12-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 126 | 5 | 0 | 0 |
1693 | 1693 | 2022-01-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1070 | 5 | 2 | 0 |
1862 | 1862 | 2022-06-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1696 | 5 | 2 | 0 |
1901 | 1901 | 2022-08-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1717 | 5 | 2 | 0 |
2006 | 2006 | 2022-11-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1803 | 5 | 2 | 0 |
2007 | 2007 | 2022-11-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1808 | 5 | 2 | 0 |
2321 | 2321 | 2020-12-03 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 713 | 5 | 0 | 0 |
2360 | 2360 | 2021-01-11 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1261 | 5 | 0 | 0 |
2411 | 2411 | 2021-03-03 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1397 | 5 | 0 | 0 |
2735 | 2735 | 2022-01-21 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1558 | 5 | 0 | 0 |
2742 | 2742 | 2022-01-28 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1723 | 5 | 0 | 0 |
2754 | 2754 | 2022-02-09 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1935 | 5 | 0 | 0 |
2757 | 2757 | 2022-02-12 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1957 | 5 | 0 | 0 |
2777 | 2777 | 2022-03-04 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2175 | 5 | 0 | 0 |
2940 | 2940 | 2022-08-14 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2512 | 5 | 0 | 0 |
2963 | 2963 | 2022-09-06 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2589 | 5 | 0 | 0 |
3190 | 3190 | 2020-06-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 115 | 5 | 0 | 0 |
3207 | 3207 | 2020-07-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 309 | 5 | 0 | 0 |
3263 | 3263 | 2020-09-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 807 | 5 | 0 | 0 |
3356 | 3356 | 2020-12-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1047 | 5 | 0 | 0 |
3374 | 3374 | 2020-12-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1241 | 5 | 3 | 2 |
3381 | 3381 | 2021-01-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1257 | 5 | 4 | 1 |
3912 | 3912 | 2022-06-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1671 | 5 | 4 | 0 |
3920 | 3920 | 2022-06-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1698 | 5 | 4 | 0 |
3990 | 3990 | 2022-09-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1773 | 5 | 4 | 0 |
3992 | 3992 | 2022-09-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1778 | 5 | 4 | 0 |
4412 | 4412 | 2021-01-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 559 | 5 | 10 | 0 |
4414 | 4414 | 2021-01-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 564 | 5 | 10 | 0 |
4421 | 4421 | 2021-01-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 588 | 5 | 12 | 0 |
4426 | 4426 | 2021-01-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 593 | 5 | 12 | 0 |
4897 | 4897 | 2022-05-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 940 | 5 | 20 | 0 |
4898 | 4898 | 2022-05-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 945 | 5 | 20 | 0 |
4918 | 4918 | 2022-06-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1223 | 5 | 22 | 0 |
4932 | 4932 | 2022-06-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1290 | 5 | 22 | 0 |
5002 | 5002 | 2022-08-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1404 | 5 | 22 | 0 |
5015 | 5015 | 2022-09-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1732 | 5 | 22 | 0 |
5017 | 5017 | 2022-09-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1739 | 5 | 22 | 0 |
5019 | 5019 | 2022-09-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1754 | 5 | 22 | 0 |
5043 | 5043 | 2022-10-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1831 | 5 | 22 | 0 |
5127 | 5127 | 2022-12-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1906 | 5 | 23 | 0 |
5156 | 5156 | 2020-04-04 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 13 | 5 | 0 | 0 |
5160 | 5160 | 2020-04-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 25 | 5 | 0 | 0 |
5162 | 5162 | 2020-04-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 37 | 5 | 0 | 0 |
5165 | 5165 | 2020-04-13 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 50 | 5 | 0 | 0 |
5168 | 5168 | 2020-04-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 59 | 5 | 0 | 0 |
5177 | 5177 | 2020-04-25 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 105 | 5 | 1 | 0 |
5198 | 5198 | 2020-05-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 607 | 5 | 5 | 0 |
5212 | 5212 | 2020-05-30 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 677 | 5 | 9 | 0 |
5223 | 5223 | 2020-06-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 796 | 5 | 13 | 1 |
5229 | 5229 | 2020-06-16 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 840 | 5 | 15 | 0 |
5233 | 5233 | 2020-06-20 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 862 | 5 | 16 | 0 |
5263 | 5263 | 2020-07-20 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1054 | 5 | 19 | 0 |
5264 | 5264 | 2020-07-21 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1059 | 5 | 19 | 0 |
5378 | 5378 | 2020-11-12 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1442 | 5 | 27 | 0 |
5758 | 5758 | 2021-11-27 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 1562 | 5 | 30 | 0 |
5823 | 5823 | 2022-01-31 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2584 | 5 | 30 | 0 |
5830 | 5830 | 2022-02-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2631 | 5 | 30 | 0 |
5979 | 5979 | 2022-07-06 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2761 | 5 | 30 | 0 |
6014 | 6014 | 2022-08-10 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2935 | 5 | 30 | 0 |
6042 | 6042 | 2022-09-07 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3486 | 5 | 30 | 0 |
6068 | 6068 | 2022-10-03 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3790 | 5 | 30 | 0 |
6221 | 6221 | 2020-05-13 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 52 | 5 | 0 | 0 |
6433 | 6433 | 2020-12-11 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 406 | 5 | 1 | 0 |
6472 | 6472 | 2021-01-19 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 454 | 5 | 1 | 0 |
6821 | 6821 | 2022-01-03 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 517 | 5 | 1 | 0 |
6998 | 6998 | 2022-06-29 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 667 | 5 | 1 | 0 |
7091 | 7091 | 2022-09-30 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 941 | 5 | 1 | 0 |
7095 | 7095 | 2022-10-04 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 962 | 5 | 1 | 0 |
7102 | 7102 | 2022-10-11 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 998 | 5 | 1 | 0 |
7481 | 7481 | 2021-01-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 461 | 5 | 1 | 1 |
7862 | 7862 | 2022-01-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 836 | 5 | 12 | 0 |
7863 | 7863 | 2022-01-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 841 | 5 | 12 | 0 |
7864 | 7864 | 2022-01-20 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 846 | 5 | 12 | 0 |
7880 | 7880 | 2022-02-05 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 956 | 5 | 12 | 0 |
7893 | 7893 | 2022-02-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1079 | 5 | 12 | 0 |
8007 | 8007 | 2022-06-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1317 | 5 | 13 | 0 |
8010 | 8010 | 2022-06-15 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1326 | 5 | 13 | 0 |
8023 | 8023 | 2022-06-28 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1356 | 5 | 13 | 0 |
8025 | 8025 | 2022-06-30 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1368 | 5 | 13 | 0 |
8061 | 8061 | 2022-08-05 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1531 | 5 | 13 | 0 |
8075 | 8075 | 2022-08-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1557 | 5 | 13 | 0 |
8146 | 8146 | 2022-10-29 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1681 | 5 | 13 | 0 |
8150 | 8150 | 2022-11-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1717 | 5 | 13 | 0 |
8152 | 8152 | 2022-11-04 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1725 | 5 | 13 | 0 |
8258 | 8258 | 2020-04-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 8 | 5 | 0 | 0 |
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 |
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 );