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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, x, deaths, date (date)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026 | 1026 | 2022-12-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12312 | 12312 | 2022-12-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2609 | 0 | 8 | 0 |
16416 | 16416 | 2022-12-30 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4831 | 0 | 7 | 0 |
1025 | 1025 | 2022-12-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12311 | 12311 | 2022-12-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2609 | 0 | 8 | 0 |
16415 | 16415 | 2022-12-29 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4831 | 0 | 7 | 0 |
1024 | 1024 | 2022-12-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12310 | 12310 | 2022-12-28 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2609 | 1 | 8 | 0 |
16414 | 16414 | 2022-12-28 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4831 | 1 | 7 | 0 |
1023 | 1023 | 2022-12-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12309 | 12309 | 2022-12-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2608 | 0 | 8 | 0 |
16413 | 16413 | 2022-12-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4830 | 1 | 7 | 0 |
1022 | 1022 | 2022-12-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12308 | 12308 | 2022-12-26 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2608 | 1 | 8 | 0 |
16412 | 16412 | 2022-12-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1021 | 1021 | 2022-12-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12307 | 12307 | 2022-12-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2607 | 0 | 8 | 0 |
16411 | 16411 | 2022-12-25 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1020 | 1020 | 2022-12-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12306 | 12306 | 2022-12-24 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2607 | 1 | 8 | 0 |
16410 | 16410 | 2022-12-24 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1019 | 1019 | 2022-12-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12305 | 12305 | 2022-12-23 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2606 | 0 | 8 | 0 |
16409 | 16409 | 2022-12-23 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1018 | 1018 | 2022-12-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12304 | 12304 | 2022-12-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2606 | 2 | 8 | 0 |
16408 | 16408 | 2022-12-22 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1017 | 1017 | 2022-12-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12303 | 12303 | 2022-12-21 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2604 | 1 | 8 | 0 |
16407 | 16407 | 2022-12-21 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1016 | 1016 | 2022-12-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12302 | 12302 | 2022-12-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2603 | 1 | 8 | 0 |
16406 | 16406 | 2022-12-20 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1015 | 1015 | 2022-12-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12301 | 12301 | 2022-12-19 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2602 | 2 | 8 | 0 |
16405 | 16405 | 2022-12-19 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1014 | 1014 | 2022-12-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12300 | 12300 | 2022-12-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2600 | 1 | 8 | 0 |
16404 | 16404 | 2022-12-18 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1013 | 1013 | 2022-12-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12299 | 12299 | 2022-12-17 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2599 | 5 | 8 | 0 |
16403 | 16403 | 2022-12-17 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1012 | 1012 | 2022-12-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12298 | 12298 | 2022-12-16 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2594 | 0 | 8 | 0 |
16402 | 16402 | 2022-12-16 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1011 | 1011 | 2022-12-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
12297 | 12297 | 2022-12-15 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2594 | 4 | 8 | 0 |
16401 | 16401 | 2022-12-15 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 0 | 7 | 0 |
1010 | 1010 | 2022-12-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 1 | 8 | 0 |
12296 | 12296 | 2022-12-14 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2590 | 1 | 8 | 0 |
16400 | 16400 | 2022-12-14 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4829 | 1 | 7 | 0 |
1009 | 1009 | 2022-12-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4341 | 3 | 8 | 0 |
12295 | 12295 | 2022-12-13 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2589 | 2 | 8 | 0 |
16399 | 16399 | 2022-12-13 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4828 | 1 | 7 | 0 |
1008 | 1008 | 2022-12-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4338 | 1 | 8 | 0 |
12294 | 12294 | 2022-12-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2587 | 1 | 8 | 0 |
16398 | 16398 | 2022-12-12 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4827 | 0 | 7 | 0 |
1007 | 1007 | 2022-12-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12293 | 12293 | 2022-12-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2586 | 3 | 8 | 0 |
16397 | 16397 | 2022-12-11 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4827 | 0 | 7 | 0 |
1006 | 1006 | 2022-12-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12292 | 12292 | 2022-12-10 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2583 | 5 | 8 | 0 |
16396 | 16396 | 2022-12-10 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4827 | 0 | 7 | 0 |
1005 | 1005 | 2022-12-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12291 | 12291 | 2022-12-09 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2578 | 7 | 8 | 0 |
16395 | 16395 | 2022-12-09 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4827 | 0 | 7 | 0 |
1004 | 1004 | 2022-12-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12290 | 12290 | 2022-12-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2571 | 10 | 8 | 0 |
16394 | 16394 | 2022-12-08 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4827 | 0 | 7 | 0 |
1003 | 1003 | 2022-12-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12289 | 12289 | 2022-12-07 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2561 | 3 | 8 | 0 |
16393 | 16393 | 2022-12-07 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4827 | 1 | 7 | 0 |
1002 | 1002 | 2022-12-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12288 | 12288 | 2022-12-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2558 | 1 | 8 | 0 |
16392 | 16392 | 2022-12-06 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4826 | 2 | 7 | 0 |
1001 | 1001 | 2022-12-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
12287 | 12287 | 2022-12-05 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2557 | 3 | 8 | 0 |
16391 | 16391 | 2022-12-05 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4824 | 0 | 7 | 0 |
1000 | 1000 | 2022-12-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 1 | 8 | 0 |
12286 | 12286 | 2022-12-04 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2554 | 5 | 8 | 0 |
16390 | 16390 | 2022-12-04 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4824 | 1 | 7 | 0 |
999 | 999 | 2022-12-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 0 | 8 | 0 |
12285 | 12285 | 2022-12-03 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2549 | 3 | 8 | 0 |
16389 | 16389 | 2022-12-03 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4823 | 0 | 7 | 0 |
998 | 998 | 2022-12-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 0 | 8 | 0 |
12284 | 12284 | 2022-12-02 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2546 | 5 | 8 | 0 |
16388 | 16388 | 2022-12-02 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4823 | 1 | 7 | 0 |
997 | 997 | 2022-12-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 0 | 8 | 0 |
12283 | 12283 | 2022-12-01 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2541 | 7 | 8 | 0 |
16387 | 16387 | 2022-12-01 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4822 | 0 | 7 | 0 |
996 | 996 | 2022-11-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 1 | 8 | 0 |
12282 | 12282 | 2022-11-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2534 | 6 | 8 | 0 |
16386 | 16386 | 2022-11-30 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4822 | 1 | 7 | 0 |
995 | 995 | 2022-11-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4335 | 0 | 8 | 0 |
12281 | 12281 | 2022-11-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2528 | 15 | 8 | 0 |
16385 | 16385 | 2022-11-29 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4821 | 3 | 7 | 0 |
994 | 994 | 2022-11-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4335 | 5 | 8 | 0 |
12280 | 12280 | 2022-11-28 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2513 | 11 | 8 | 0 |
16384 | 16384 | 2022-11-28 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4818 | 1 | 7 | 0 |
993 | 993 | 2022-11-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4330 | 1 | 8 | 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 );