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,376 rows where new_confirmed_cases = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: city, fips, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72 | 72 | 2020-05-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 53 | 2 | 0 | 0 |
88 | 88 | 2020-06-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 842 | 2 | 0 | 0 |
89 | 89 | 2020-06-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 844 | 2 | 0 | 0 |
91 | 91 | 2020-06-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 846 | 2 | 0 | 0 |
93 | 93 | 2020-06-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 897 | 2 | 0 | 0 |
96 | 96 | 2020-06-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 916 | 2 | 0 | 0 |
98 | 98 | 2020-06-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 918 | 2 | 0 | 0 |
99 | 99 | 2020-06-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 920 | 2 | 0 | 0 |
108 | 108 | 2020-06-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 935 | 2 | 2 | 0 |
116 | 116 | 2020-07-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 945 | 2 | 3 | 0 |
123 | 123 | 2020-07-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 954 | 2 | 3 | 0 |
126 | 126 | 2020-07-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 956 | 2 | 4 | 1 |
129 | 129 | 2020-07-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 961 | 2 | 4 | 0 |
134 | 134 | 2020-07-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1096 | 2 | 4 | 0 |
142 | 142 | 2020-07-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1369 | 2 | 5 | 0 |
147 | 147 | 2020-08-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1419 | 2 | 5 | 0 |
155 | 155 | 2020-08-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1589 | 2 | 5 | 0 |
161 | 161 | 2020-08-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1604 | 2 | 5 | 0 |
169 | 169 | 2020-08-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 1769 | 2 | 5 | 0 |
208 | 208 | 2020-10-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2842 | 2 | 7 | 0 |
224 | 224 | 2020-10-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2944 | 2 | 7 | 0 |
225 | 225 | 2020-10-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2946 | 2 | 7 | 0 |
235 | 235 | 2020-10-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 2 | 8 | 1 |
241 | 241 | 2020-11-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2986 | 2 | 8 | 0 |
254 | 254 | 2020-11-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3001 | 2 | 8 | 0 |
282 | 282 | 2020-12-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3040 | 2 | 8 | 0 |
284 | 284 | 2020-12-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 2 | 8 | 0 |
315 | 315 | 2021-01-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3125 | 2 | 8 | 0 |
323 | 323 | 2021-01-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3129 | 2 | 8 | 0 |
513 | 513 | 2021-08-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3133 | 2 | 8 | 0 |
606 | 606 | 2021-11-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3136 | 2 | 8 | 0 |
698 | 698 | 2022-02-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3961 | 2 | 8 | 0 |
704 | 704 | 2022-02-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4006 | 2 | 8 | 0 |
714 | 714 | 2022-02-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4016 | 2 | 8 | 0 |
835 | 835 | 2022-06-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4040 | 2 | 8 | 0 |
843 | 843 | 2022-06-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4056 | 2 | 8 | 0 |
872 | 872 | 2022-07-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4136 | 2 | 8 | 0 |
876 | 876 | 2022-08-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4144 | 2 | 8 | 0 |
884 | 884 | 2022-08-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4146 | 2 | 8 | 0 |
906 | 906 | 2022-09-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4170 | 2 | 8 | 0 |
973 | 973 | 2022-11-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4208 | 2 | 8 | 0 |
975 | 975 | 2022-11-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4213 | 2 | 8 | 0 |
977 | 977 | 2022-11-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4229 | 2 | 8 | 0 |
984 | 984 | 2022-11-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4310 | 2 | 8 | 0 |
1187 | 1187 | 2020-08-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 3 | 2 | 0 | 0 |
1297 | 1297 | 2020-12-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 173 | 2 | 0 | 0 |
1311 | 1311 | 2020-12-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 524 | 2 | 0 | 0 |
1316 | 1316 | 2020-12-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 694 | 2 | 0 | 0 |
1329 | 1329 | 2021-01-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 910 | 2 | 0 | 0 |
1338 | 1338 | 2021-01-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 936 | 2 | 2 | 0 |
1586 | 1586 | 2021-09-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1010 | 2 | 2 | 0 |
1589 | 1589 | 2021-09-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1013 | 2 | 2 | 0 |
1593 | 1593 | 2021-09-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1016 | 2 | 2 | 0 |
1702 | 1702 | 2022-01-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1102 | 2 | 2 | 0 |
1727 | 1727 | 2022-02-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1135 | 2 | 2 | 0 |
1728 | 1728 | 2022-02-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1137 | 2 | 2 | 0 |
1851 | 1851 | 2022-06-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1555 | 2 | 2 | 0 |
1870 | 1870 | 2022-07-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1703 | 2 | 2 | 0 |
1894 | 1894 | 2022-07-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1712 | 2 | 2 | 0 |
1904 | 1904 | 2022-08-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1723 | 2 | 2 | 0 |
1909 | 1909 | 2022-08-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1737 | 2 | 2 | 0 |
1912 | 1912 | 2022-08-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1743 | 2 | 2 | 0 |
1916 | 1916 | 2022-08-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1745 | 2 | 2 | 0 |
1986 | 1986 | 2022-10-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1761 | 2 | 2 | 0 |
1994 | 1994 | 2022-11-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1778 | 2 | 2 | 0 |
1999 | 1999 | 2022-11-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1795 | 2 | 2 | 0 |
2001 | 2001 | 2022-11-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1797 | 2 | 2 | 0 |
2010 | 2010 | 2022-11-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1820 | 2 | 2 | 0 |
2161 | 2161 | 2020-06-26 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 216 | 2 | 0 | 0 |
2172 | 2172 | 2020-07-07 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 230 | 2 | 0 | 0 |
2186 | 2186 | 2020-07-21 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 517 | 2 | 0 | 0 |
2196 | 2196 | 2020-07-31 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 589 | 2 | 0 | 0 |
2230 | 2230 | 2020-09-03 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 661 | 2 | 0 | 0 |
2319 | 2319 | 2020-12-01 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 699 | 2 | 0 | 0 |
2329 | 2329 | 2020-12-11 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 742 | 2 | 0 | 0 |
2339 | 2339 | 2020-12-21 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 874 | 2 | 0 | 0 |
2353 | 2353 | 2021-01-04 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1243 | 2 | 0 | 0 |
2357 | 2357 | 2021-01-08 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1256 | 2 | 0 | 0 |
2380 | 2380 | 2021-01-31 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1316 | 2 | 0 | 0 |
2383 | 2383 | 2021-02-03 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1331 | 2 | 0 | 0 |
2391 | 2391 | 2021-02-11 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1349 | 2 | 0 | 0 |
2393 | 2393 | 2021-02-13 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1359 | 2 | 0 | 0 |
2395 | 2395 | 2021-02-15 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1362 | 2 | 0 | 0 |
2397 | 2397 | 2021-02-17 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1365 | 2 | 0 | 0 |
2401 | 2401 | 2021-02-21 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1379 | 2 | 0 | 0 |
2406 | 2406 | 2021-02-26 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1388 | 2 | 0 | 0 |
2526 | 2526 | 2021-06-26 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1434 | 2 | 0 | 0 |
2530 | 2530 | 2021-06-30 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1437 | 2 | 0 | 0 |
2630 | 2630 | 2021-10-08 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1458 | 2 | 0 | 0 |
2649 | 2649 | 2021-10-27 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1462 | 2 | 0 | 0 |
2658 | 2658 | 2021-11-05 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1465 | 2 | 0 | 0 |
2723 | 2723 | 2022-01-09 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1472 | 2 | 0 | 0 |
2727 | 2727 | 2022-01-13 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1492 | 2 | 0 | 0 |
2729 | 2729 | 2022-01-15 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 1494 | 2 | 0 | 0 |
2764 | 2764 | 2022-02-19 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2054 | 2 | 0 | 0 |
2769 | 2769 | 2022-02-24 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2091 | 2 | 0 | 0 |
2872 | 2872 | 2022-06-07 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2206 | 2 | 0 | 0 |
2877 | 2877 | 2022-06-12 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2210 | 2 | 0 | 0 |
2912 | 2912 | 2022-07-17 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2239 | 2 | 0 | 0 |
2919 | 2919 | 2022-07-24 | CCC | California Correctional Center | Susanville | Lassen | 35 | 96127 | -120.5117488 | 40.3974017 | 2263 | 2 | 0 | 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 );