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.
41 rows where new_confirmed_cases = 21
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, city, county, zipcode, x, y, deaths, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
688 | 688 | 2022-01-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3819 | 21 | 8 | 0 |
702 | 702 | 2022-02-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3995 | 21 | 8 | 0 |
1308 | 1308 | 2020-12-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 515 | 21 | 0 | 0 |
3761 | 3761 | 2022-01-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1576 | 21 | 4 | 0 |
5190 | 5190 | 2020-05-08 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 396 | 21 | 4 | 0 |
5810 | 5810 | 2022-01-18 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 2402 | 21 | 30 | 0 |
6033 | 6033 | 2022-08-29 | CIM | California Institution for Men | Chino | San Bernardino | 71 | 91708 | -117.3861722 | 34.0821285 | 3338 | 21 | 30 | 0 |
7097 | 7097 | 2022-10-06 | CIW | California Institution for Women | Chino | San Bernardino | 71 | 92877 | -117.634771 | 33.9493511 | 990 | 21 | 1 | 0 |
7884 | 7884 | 2022-02-09 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1038 | 21 | 12 | 0 |
7970 | 7970 | 2022-05-06 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 1218 | 21 | 13 | 0 |
8894 | 8894 | 2022-01-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2734 | 21 | 13 | 0 |
9010 | 9010 | 2022-05-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3281 | 21 | 13 | 0 |
9914 | 9914 | 2022-01-18 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2607 | 21 | 1 | 0 |
9920 | 9920 | 2022-01-24 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 2653 | 21 | 1 | 0 |
10251 | 10251 | 2022-12-21 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3671 | 21 | 1 | 0 |
10253 | 10253 | 2022-12-23 | CRC | California Rehabilitation Center | Norco | Riverside | 65 | 92860 | -117.5766389 | 33.9311823 | 3700 | 21 | 1 | 0 |
11973 | 11973 | 2022-01-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 1769 | 21 | 7 | 0 |
12158 | 12158 | 2022-07-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2357 | 21 | 8 | 0 |
13015 | 13015 | 2022-02-10 | LAC | California State Prison, Los Angeles | Lancaster | Los Angeles | 37 | 93534 | -118.2365963 | 34.6894876 | 1945 | 21 | 14 | 0 |
16728 | 16728 | 2021-01-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 998 | 21 | 2 | 0 |
18132 | 18132 | 2022-01-28 | CCWF | Central California Women's Facility | Chowchilla | Madera | 39 | 93610 | -120.1497066 | 37.0903601 | 1475 | 21 | 1 | 0 |
19749 | 19749 | 2020-11-19 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 696 | 21 | 2 | 1 |
20864 | 20864 | 2021-02-16 | DVI | Deuel Vocational Institute | Tracy | San Joaquin | 77 | 95304 | -121.3299863 | 37.747725 | 540 | 21 | 0 | 0 |
22373 | 22373 | 2022-06-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2716 | 21 | 2 | 0 |
22846 | 22846 | 2020-12-08 | HDSP | High Desert State Prison | Susanville | Lassen | 35 | 96127 | -120.5260649 | 40.4052702 | 1510 | 21 | 1 | 0 |
23936 | 23936 | 2021-02-10 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 1537 | 21 | 1 | 0 |
24481 | 24481 | 2022-08-09 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 2795 | 21 | 1 | 0 |
24504 | 24504 | 2022-09-01 | ISP | Ironwood State Prison | Blythe | Riverside | 65 | 92225 | -114.9266802 | 33.5609644 | 2955 | 21 | 1 | 0 |
26350 | 26350 | 2022-02-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2663 | 21 | 9 | 0 |
26456 | 26456 | 2022-05-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2959 | 21 | 9 | 0 |
27364 | 27364 | 2022-01-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2631 | 21 | 5 | 0 |
27572 | 27572 | 2022-08-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3742 | 21 | 5 | 0 |
30427 | 30427 | 2022-01-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1136 | 21 | 18 | 0 |
30447 | 30447 | 2022-01-31 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1325 | 21 | 19 | 0 |
31479 | 31479 | 2022-02-06 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 900 | 21 | 6 | 0 |
33142 | 33142 | 2021-01-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1216 | 21 | 0 | 0 |
34119 | 34119 | 2020-11-25 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 608 | 21 | 0 | 0 |
34146 | 34146 | 2020-12-22 | VSP | Valley State Prison | Chowchilla | Madera | 39 | 93610 | -120.1541466 | 37.1033659 | 1408 | 21 | 1 | 0 |
35752 | 35752 | 2022-07-25 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 4643 | 21 | 2 | 0 |
35753 | 35753 | 2022-07-26 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 4664 | 21 | 2 | 0 |
35888 | 35888 | 2022-12-08 | WSP | Wasco State Prison | Wasco | Kern | 29 | 93280 | -119.4080748 | 35.5950806 | 5012 | 21 | 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 );