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.
788 rows where new_confirmed_cases = 3
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: city, county, zipcode, deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100 | 100 | 2020-06-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 923 | 3 | 0 | 0 |
105 | 105 | 2020-06-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 931 | 3 | 1 | 0 |
109 | 109 | 2020-06-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 938 | 3 | 3 | 1 |
115 | 115 | 2020-07-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 943 | 3 | 3 | 0 |
127 | 127 | 2020-07-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 959 | 3 | 4 | 0 |
227 | 227 | 2020-10-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2950 | 3 | 7 | 0 |
228 | 228 | 2020-10-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2953 | 3 | 7 | 0 |
246 | 246 | 2020-11-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2994 | 3 | 8 | 0 |
253 | 253 | 2020-11-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2999 | 3 | 8 | 0 |
259 | 259 | 2020-11-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3005 | 3 | 8 | 0 |
678 | 678 | 2022-01-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3331 | 3 | 8 | 0 |
700 | 700 | 2022-02-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3965 | 3 | 8 | 0 |
710 | 710 | 2022-02-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4013 | 3 | 8 | 0 |
728 | 728 | 2022-03-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4032 | 3 | 8 | 0 |
837 | 837 | 2022-06-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4044 | 3 | 8 | 0 |
838 | 838 | 2022-06-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4047 | 3 | 8 | 0 |
842 | 842 | 2022-06-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4054 | 3 | 8 | 0 |
863 | 863 | 2022-07-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4098 | 3 | 8 | 0 |
898 | 898 | 2022-08-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4150 | 3 | 8 | 0 |
900 | 900 | 2022-08-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4157 | 3 | 8 | 0 |
914 | 914 | 2022-09-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4184 | 3 | 8 | 0 |
924 | 924 | 2022-09-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 3 | 8 | 0 |
974 | 974 | 2022-11-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4211 | 3 | 8 | 0 |
1009 | 1009 | 2022-12-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4341 | 3 | 8 | 0 |
1288 | 1288 | 2020-11-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 12 | 3 | 0 | 0 |
1309 | 1309 | 2020-12-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 518 | 3 | 0 | 0 |
1357 | 1357 | 2021-02-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 997 | 3 | 2 | 0 |
1534 | 1534 | 2021-07-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1008 | 3 | 2 | 0 |
1684 | 1684 | 2021-12-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1019 | 3 | 2 | 0 |
1685 | 1685 | 2021-12-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1022 | 3 | 2 | 0 |
1694 | 1694 | 2022-01-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1073 | 3 | 2 | 0 |
1698 | 1698 | 2022-01-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1084 | 3 | 2 | 0 |
1840 | 1840 | 2022-06-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1158 | 3 | 2 | 0 |
1866 | 1866 | 2022-06-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1701 | 3 | 2 | 0 |
1903 | 1903 | 2022-08-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1721 | 3 | 2 | 0 |
1985 | 1985 | 2022-10-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1759 | 3 | 2 | 0 |
2008 | 2008 | 2022-11-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1811 | 3 | 2 | 0 |
2153 | 2153 | 2020-06-18 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 3 | 3 | 0 | 0 |
2159 | 2159 | 2020-06-24 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 214 | 3 | 0 | 0 |
2168 | 2168 | 2020-07-03 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 228 | 3 | 0 | 0 |
2178 | 2178 | 2020-07-13 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 450 | 3 | 0 | 0 |
2181 | 2181 | 2020-07-16 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 477 | 3 | 0 | 0 |
2312 | 2312 | 2020-11-24 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 697 | 3 | 0 | 0 |
2322 | 2322 | 2020-12-04 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 716 | 3 | 0 | 0 |
2325 | 2325 | 2020-12-07 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 719 | 3 | 0 | 0 |
2340 | 2340 | 2020-12-22 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 877 | 3 | 0 | 0 |
2345 | 2345 | 2020-12-27 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1128 | 3 | 0 | 0 |
2385 | 2385 | 2021-02-05 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1335 | 3 | 0 | 0 |
2389 | 2389 | 2021-02-09 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1346 | 3 | 0 | 0 |
2398 | 2398 | 2021-02-18 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1368 | 3 | 0 | 0 |
2410 | 2410 | 2021-03-02 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1392 | 3 | 0 | 0 |
2517 | 2517 | 2021-06-17 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1424 | 3 | 0 | 0 |
2518 | 2518 | 2021-06-18 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1427 | 3 | 0 | 0 |
2580 | 2580 | 2021-08-19 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1443 | 3 | 0 | 0 |
2721 | 2721 | 2022-01-07 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1470 | 3 | 0 | 0 |
2724 | 2724 | 2022-01-10 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1475 | 3 | 0 | 0 |
2747 | 2747 | 2022-02-02 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1847 | 3 | 0 | 0 |
2755 | 2755 | 2022-02-10 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1938 | 3 | 0 | 0 |
2768 | 2768 | 2022-02-23 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2089 | 3 | 0 | 0 |
2908 | 2908 | 2022-07-13 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2220 | 3 | 0 | 0 |
2911 | 2911 | 2022-07-16 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2237 | 3 | 0 | 0 |
2958 | 2958 | 2022-09-01 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2580 | 3 | 0 | 0 |
2962 | 2962 | 2022-09-05 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2584 | 3 | 0 | 0 |
3216 | 3216 | 2020-07-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 444 | 3 | 0 | 0 |
3221 | 3221 | 2020-07-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 552 | 3 | 0 | 0 |
3225 | 3225 | 2020-08-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 569 | 3 | 0 | 0 |
3261 | 3261 | 2020-09-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 801 | 3 | 0 | 0 |
3339 | 3339 | 2020-11-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 879 | 3 | 0 | 0 |
3343 | 3343 | 2020-11-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 883 | 3 | 0 | 0 |
3347 | 3347 | 2020-12-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 891 | 3 | 0 | 0 |
3355 | 3355 | 2020-12-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1042 | 3 | 0 | 0 |
3365 | 3365 | 2020-12-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1195 | 3 | 0 | 0 |
3368 | 3368 | 2020-12-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1215 | 3 | 0 | 0 |
3372 | 3372 | 2020-12-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1224 | 3 | 1 | 0 |
3388 | 3388 | 2021-01-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1284 | 3 | 4 | 0 |
3400 | 3400 | 2021-01-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1352 | 3 | 4 | 0 |
3560 | 3560 | 2021-07-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1408 | 3 | 4 | 0 |
3948 | 3948 | 2022-07-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1717 | 3 | 4 | 0 |
3982 | 3982 | 2022-08-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1760 | 3 | 4 | 0 |
3988 | 3988 | 2022-09-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1767 | 3 | 4 | 0 |
3996 | 3996 | 2022-09-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1782 | 3 | 4 | 0 |
4052 | 4052 | 2022-11-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1810 | 3 | 4 | 0 |
4102 | 4102 | 2022-12-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 3 | 4 | 0 |
4357 | 4357 | 2020-11-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 17 | 3 | 1 | 0 |
4388 | 4388 | 2020-12-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 183 | 3 | 2 | 0 |
4403 | 4403 | 2021-01-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 506 | 3 | 6 | 1 |
4409 | 4409 | 2021-01-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 554 | 3 | 9 | 0 |
4420 | 4420 | 2021-01-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 583 | 3 | 12 | 0 |
4432 | 4432 | 2021-01-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 610 | 3 | 14 | 0 |
4531 | 4531 | 2021-05-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 635 | 3 | 19 | 0 |
4767 | 4767 | 2022-01-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 673 | 3 | 19 | 0 |
4768 | 4768 | 2022-01-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 676 | 3 | 19 | 0 |
4786 | 4786 | 2022-01-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 809 | 3 | 19 | 0 |
4791 | 4791 | 2022-01-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 861 | 3 | 19 | 0 |
4804 | 4804 | 2022-02-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 882 | 3 | 20 | 0 |
4893 | 4893 | 2022-05-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 913 | 3 | 20 | 0 |
4922 | 4922 | 2022-06-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1254 | 3 | 22 | 0 |
4930 | 4930 | 2022-06-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1283 | 3 | 22 | 0 |
4959 | 4959 | 2022-07-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1368 | 3 | 22 | 0 |
4966 | 4966 | 2022-07-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1375 | 3 | 22 | 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 );