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.
3,078 rows where fips = 31 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, city, zipcode, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2020-03-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | ||
11287 | 11287 | 2020-03-10 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | ||
15391 | 15391 | 2020-03-10 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | ||
2 | 2 | 2020-03-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11288 | 11288 | 2020-03-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15392 | 15392 | 2020-03-11 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
3 | 3 | 2020-03-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11289 | 11289 | 2020-03-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15393 | 15393 | 2020-03-12 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
4 | 4 | 2020-03-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11290 | 11290 | 2020-03-13 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15394 | 15394 | 2020-03-13 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
5 | 5 | 2020-03-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11291 | 11291 | 2020-03-14 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15395 | 15395 | 2020-03-14 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
6 | 6 | 2020-03-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11292 | 11292 | 2020-03-15 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15396 | 15396 | 2020-03-15 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
7 | 7 | 2020-03-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11293 | 11293 | 2020-03-16 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15397 | 15397 | 2020-03-16 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
8 | 8 | 2020-03-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11294 | 11294 | 2020-03-17 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15398 | 15398 | 2020-03-17 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
9 | 9 | 2020-03-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11295 | 11295 | 2020-03-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15399 | 15399 | 2020-03-18 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
10 | 10 | 2020-03-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11296 | 11296 | 2020-03-19 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15400 | 15400 | 2020-03-19 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
11 | 11 | 2020-03-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11297 | 11297 | 2020-03-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15401 | 15401 | 2020-03-20 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
12 | 12 | 2020-03-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11298 | 11298 | 2020-03-21 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15402 | 15402 | 2020-03-21 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
13 | 13 | 2020-03-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11299 | 11299 | 2020-03-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15403 | 15403 | 2020-03-22 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
14 | 14 | 2020-03-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11300 | 11300 | 2020-03-23 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15404 | 15404 | 2020-03-23 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
15 | 15 | 2020-03-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11301 | 11301 | 2020-03-24 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15405 | 15405 | 2020-03-24 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
16 | 16 | 2020-03-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11302 | 11302 | 2020-03-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15406 | 15406 | 2020-03-25 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
17 | 17 | 2020-03-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11303 | 11303 | 2020-03-26 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15407 | 15407 | 2020-03-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
18 | 18 | 2020-03-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11304 | 11304 | 2020-03-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15408 | 15408 | 2020-03-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
19 | 19 | 2020-03-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11305 | 11305 | 2020-03-28 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15409 | 15409 | 2020-03-28 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
20 | 20 | 2020-03-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11306 | 11306 | 2020-03-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15410 | 15410 | 2020-03-29 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
21 | 21 | 2020-03-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11307 | 11307 | 2020-03-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15411 | 15411 | 2020-03-30 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
22 | 22 | 2020-03-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11308 | 11308 | 2020-03-31 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15412 | 15412 | 2020-03-31 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
23 | 23 | 2020-04-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11309 | 11309 | 2020-04-01 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15413 | 15413 | 2020-04-01 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
24 | 24 | 2020-04-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11310 | 11310 | 2020-04-02 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15414 | 15414 | 2020-04-02 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 0 | 0 | 0 | 0 |
25 | 25 | 2020-04-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11311 | 11311 | 2020-04-03 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15415 | 15415 | 2020-04-03 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 1 | 0 | 0 |
26 | 26 | 2020-04-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11312 | 11312 | 2020-04-04 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15416 | 15416 | 2020-04-04 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
27 | 27 | 2020-04-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11313 | 11313 | 2020-04-05 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15417 | 15417 | 2020-04-05 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
28 | 28 | 2020-04-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11314 | 11314 | 2020-04-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15418 | 15418 | 2020-04-06 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
29 | 29 | 2020-04-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11315 | 11315 | 2020-04-07 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15419 | 15419 | 2020-04-07 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
30 | 30 | 2020-04-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11316 | 11316 | 2020-04-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15420 | 15420 | 2020-04-08 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
31 | 31 | 2020-04-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11317 | 11317 | 2020-04-09 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15421 | 15421 | 2020-04-09 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
32 | 32 | 2020-04-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11318 | 11318 | 2020-04-10 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15422 | 15422 | 2020-04-10 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
33 | 33 | 2020-04-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 0 | 0 |
11319 | 11319 | 2020-04-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 0 | 0 | 0 | 0 |
15423 | 15423 | 2020-04-11 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 1 | 0 | 0 | 0 |
34 | 34 | 2020-04-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 0 | 0 | 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 );