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.
5,130 rows where county = "Kern" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, city, zipcode, x, new_confirmed_cases, deaths, new_deaths, date (date)
name 5 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2052 | 2052 | 2022-12-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1831 | 0 | 2 | 0 |
4104 | 4104 | 2022-12-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 0 | 4 | 0 |
25650 | 25650 | 2022-12-30 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1452 | 0 | 7 | 0 |
27702 | 27702 | 2022-12-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4261 | 0 | 5 | 0 |
35910 | 35910 | 2022-12-30 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5226 | 0 | 2 | 0 |
2051 | 2051 | 2022-12-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1831 | 0 | 2 | 0 |
4103 | 4103 | 2022-12-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 0 | 4 | 0 |
25649 | 25649 | 2022-12-29 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1452 | 5 | 7 | 0 |
27701 | 27701 | 2022-12-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4261 | 2 | 5 | 0 |
35909 | 35909 | 2022-12-29 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5226 | 0 | 2 | 0 |
2050 | 2050 | 2022-12-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1831 | 0 | 2 | 0 |
4102 | 4102 | 2022-12-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1824 | 3 | 4 | 0 |
25648 | 25648 | 2022-12-28 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1447 | 9 | 7 | 0 |
27700 | 27700 | 2022-12-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4259 | 17 | 5 | 0 |
35908 | 35908 | 2022-12-28 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5226 | 6 | 2 | 0 |
2049 | 2049 | 2022-12-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1831 | 0 | 2 | 0 |
4101 | 4101 | 2022-12-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1821 | 1 | 4 | 0 |
25647 | 25647 | 2022-12-27 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1438 | 9 | 7 | 0 |
27699 | 27699 | 2022-12-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4242 | 6 | 5 | 0 |
35907 | 35907 | 2022-12-27 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5220 | 4 | 2 | 0 |
2048 | 2048 | 2022-12-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1831 | 1 | 2 | 0 |
4100 | 4100 | 2022-12-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25646 | 25646 | 2022-12-26 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1429 | 4 | 7 | 0 |
27698 | 27698 | 2022-12-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4236 | 1 | 5 | 0 |
35906 | 35906 | 2022-12-26 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5216 | 5 | 2 | 0 |
2047 | 2047 | 2022-12-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4099 | 4099 | 2022-12-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25645 | 25645 | 2022-12-25 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1425 | 4 | 7 | 0 |
27697 | 27697 | 2022-12-25 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4235 | 1 | 5 | 0 |
35905 | 35905 | 2022-12-25 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5211 | 0 | 2 | 0 |
2046 | 2046 | 2022-12-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4098 | 4098 | 2022-12-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25644 | 25644 | 2022-12-24 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1421 | 3 | 7 | 0 |
27696 | 27696 | 2022-12-24 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4234 | 1 | 5 | 0 |
35904 | 35904 | 2022-12-24 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5211 | 3 | 2 | 0 |
2045 | 2045 | 2022-12-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4097 | 4097 | 2022-12-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25643 | 25643 | 2022-12-23 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1418 | 3 | 7 | 0 |
27695 | 27695 | 2022-12-23 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4233 | 4 | 5 | 0 |
35903 | 35903 | 2022-12-23 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5208 | 4 | 2 | 0 |
2044 | 2044 | 2022-12-22 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4096 | 4096 | 2022-12-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25642 | 25642 | 2022-12-22 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1415 | 8 | 7 | 0 |
27694 | 27694 | 2022-12-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4229 | 5 | 5 | 0 |
35902 | 35902 | 2022-12-22 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5204 | 16 | 2 | 0 |
2043 | 2043 | 2022-12-21 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4095 | 4095 | 2022-12-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25641 | 25641 | 2022-12-21 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1407 | 7 | 7 | 0 |
27693 | 27693 | 2022-12-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4224 | 7 | 5 | 0 |
35901 | 35901 | 2022-12-21 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5188 | 11 | 2 | 0 |
2042 | 2042 | 2022-12-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4094 | 4094 | 2022-12-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 0 | 4 | 0 |
25640 | 25640 | 2022-12-20 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1400 | 5 | 7 | 0 |
27692 | 27692 | 2022-12-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4217 | 6 | 5 | 0 |
35900 | 35900 | 2022-12-20 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5177 | 3 | 2 | 0 |
2041 | 2041 | 2022-12-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4093 | 4093 | 2022-12-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1820 | 1 | 4 | 0 |
25639 | 25639 | 2022-12-19 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1395 | 12 | 7 | 0 |
27691 | 27691 | 2022-12-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4211 | 8 | 5 | 0 |
35899 | 35899 | 2022-12-19 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5174 | 30 | 2 | 0 |
2040 | 2040 | 2022-12-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4092 | 4092 | 2022-12-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1819 | 0 | 4 | 0 |
25638 | 25638 | 2022-12-18 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1383 | 6 | 7 | 0 |
27690 | 27690 | 2022-12-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4203 | 0 | 5 | 0 |
35898 | 35898 | 2022-12-18 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5144 | 0 | 2 | 0 |
2039 | 2039 | 2022-12-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 0 | 2 | 0 |
4091 | 4091 | 2022-12-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1819 | 0 | 4 | 0 |
25637 | 25637 | 2022-12-17 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1377 | 5 | 7 | 0 |
27689 | 27689 | 2022-12-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4203 | 29 | 5 | 0 |
35897 | 35897 | 2022-12-17 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5144 | 0 | 2 | 0 |
2038 | 2038 | 2022-12-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1830 | 1 | 2 | 0 |
4090 | 4090 | 2022-12-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1819 | 1 | 4 | 0 |
25636 | 25636 | 2022-12-16 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1372 | 6 | 7 | 0 |
27688 | 27688 | 2022-12-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4174 | 27 | 5 | 0 |
35896 | 35896 | 2022-12-16 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5144 | 16 | 2 | 0 |
2037 | 2037 | 2022-12-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1829 | 0 | 2 | 0 |
4089 | 4089 | 2022-12-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
25635 | 25635 | 2022-12-15 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1366 | 5 | 7 | 0 |
27687 | 27687 | 2022-12-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4147 | 4 | 5 | 0 |
35895 | 35895 | 2022-12-15 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5128 | 32 | 2 | 0 |
2036 | 2036 | 2022-12-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1829 | 0 | 2 | 0 |
4088 | 4088 | 2022-12-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
25634 | 25634 | 2022-12-14 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1361 | 2 | 7 | 0 |
27686 | 27686 | 2022-12-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4143 | 18 | 5 | 0 |
35894 | 35894 | 2022-12-14 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5096 | 3 | 2 | 0 |
2035 | 2035 | 2022-12-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1829 | 1 | 2 | 0 |
4087 | 4087 | 2022-12-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
25633 | 25633 | 2022-12-13 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1359 | 9 | 7 | 0 |
27685 | 27685 | 2022-12-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4125 | 34 | 5 | 0 |
35893 | 35893 | 2022-12-13 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5093 | 4 | 2 | 0 |
2034 | 2034 | 2022-12-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1828 | 0 | 2 | 0 |
4086 | 4086 | 2022-12-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
25632 | 25632 | 2022-12-12 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1350 | 3 | 7 | 0 |
27684 | 27684 | 2022-12-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4091 | 36 | 5 | 0 |
35892 | 35892 | 2022-12-12 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5089 | 51 | 2 | 0 |
2033 | 2033 | 2022-12-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1828 | 0 | 2 | 0 |
4085 | 4085 | 2022-12-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1818 | 0 | 4 | 0 |
25631 | 25631 | 2022-12-11 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1347 | 0 | 7 | 0 |
27683 | 27683 | 2022-12-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4055 | 0 | 5 | 0 |
35891 | 35891 | 2022-12-11 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5038 | 13 | 2 | 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 );