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.
2,052 rows where fips = 53 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
name 2 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20470 | 20470 | 2022-11-10 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31756 | 31756 | 2022-11-10 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1241 | 1 | 6 | 0 |
20469 | 20469 | 2022-11-09 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31755 | 31755 | 2022-11-09 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1240 | 1 | 6 | 0 |
20468 | 20468 | 2022-11-08 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31754 | 31754 | 2022-11-08 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1239 | 0 | 6 | 0 |
20467 | 20467 | 2022-11-07 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31753 | 31753 | 2022-11-07 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1239 | 0 | 6 | 0 |
20466 | 20466 | 2022-11-06 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31752 | 31752 | 2022-11-06 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1239 | 0 | 6 | 0 |
20465 | 20465 | 2022-11-05 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31751 | 31751 | 2022-11-05 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1239 | 1 | 6 | 0 |
20464 | 20464 | 2022-11-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31750 | 31750 | 2022-11-04 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1238 | 3 | 6 | 0 |
20463 | 20463 | 2022-11-03 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31749 | 31749 | 2022-11-03 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1235 | 2 | 6 | 0 |
20462 | 20462 | 2022-11-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 1 | 21 | 0 |
31748 | 31748 | 2022-11-02 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1233 | 0 | 6 | 0 |
20461 | 20461 | 2022-11-01 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3573 | 0 | 21 | 0 |
31747 | 31747 | 2022-11-01 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1233 | 0 | 6 | 0 |
20460 | 20460 | 2022-10-31 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3573 | 0 | 21 | 0 |
31746 | 31746 | 2022-10-31 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1233 | 3 | 6 | 0 |
20459 | 20459 | 2022-10-30 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3573 | 0 | 21 | 0 |
31745 | 31745 | 2022-10-30 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 0 | 6 | 0 |
20458 | 20458 | 2022-10-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3573 | 0 | 21 | 0 |
31744 | 31744 | 2022-10-29 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 0 | 6 | 0 |
20457 | 20457 | 2022-10-28 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3573 | 4 | 21 | 0 |
31743 | 31743 | 2022-10-28 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 0 | 6 | 0 |
20456 | 20456 | 2022-10-27 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31742 | 31742 | 2022-10-27 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 0 | 6 | 0 |
20455 | 20455 | 2022-10-26 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31741 | 31741 | 2022-10-26 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 0 | 6 | 0 |
20454 | 20454 | 2022-10-25 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31740 | 31740 | 2022-10-25 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 0 | 6 | 0 |
20453 | 20453 | 2022-10-24 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31739 | 31739 | 2022-10-24 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1230 | 1 | 6 | 0 |
20452 | 20452 | 2022-10-23 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31738 | 31738 | 2022-10-23 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1229 | 0 | 6 | 0 |
20451 | 20451 | 2022-10-22 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31737 | 31737 | 2022-10-22 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1229 | 1 | 6 | 0 |
20450 | 20450 | 2022-10-21 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31736 | 31736 | 2022-10-21 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1228 | 0 | 6 | 0 |
20449 | 20449 | 2022-10-20 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31735 | 31735 | 2022-10-20 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1228 | 1 | 6 | 0 |
20448 | 20448 | 2022-10-19 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31734 | 31734 | 2022-10-19 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 0 | 6 | 0 |
20447 | 20447 | 2022-10-18 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31733 | 31733 | 2022-10-18 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 0 | 6 | 0 |
20446 | 20446 | 2022-10-17 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31732 | 31732 | 2022-10-17 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 0 | 6 | 0 |
20445 | 20445 | 2022-10-16 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31731 | 31731 | 2022-10-16 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 0 | 6 | 0 |
20444 | 20444 | 2022-10-15 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31730 | 31730 | 2022-10-15 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 0 | 6 | 0 |
20443 | 20443 | 2022-10-14 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31729 | 31729 | 2022-10-14 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 0 | 6 | 0 |
20442 | 20442 | 2022-10-13 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31728 | 31728 | 2022-10-13 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1227 | 1 | 6 | 0 |
20441 | 20441 | 2022-10-12 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31727 | 31727 | 2022-10-12 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20440 | 20440 | 2022-10-11 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31726 | 31726 | 2022-10-11 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20439 | 20439 | 2022-10-10 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31725 | 31725 | 2022-10-10 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20438 | 20438 | 2022-10-09 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31724 | 31724 | 2022-10-09 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20437 | 20437 | 2022-10-08 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31723 | 31723 | 2022-10-08 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20436 | 20436 | 2022-10-07 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31722 | 31722 | 2022-10-07 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20435 | 20435 | 2022-10-06 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31721 | 31721 | 2022-10-06 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20434 | 20434 | 2022-10-05 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31720 | 31720 | 2022-10-05 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 0 | 6 | 0 |
20433 | 20433 | 2022-10-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31719 | 31719 | 2022-10-04 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1226 | 1 | 6 | 0 |
20432 | 20432 | 2022-10-03 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31718 | 31718 | 2022-10-03 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1225 | 0 | 6 | 0 |
20431 | 20431 | 2022-10-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31717 | 31717 | 2022-10-02 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1225 | 0 | 6 | 0 |
20430 | 20430 | 2022-10-01 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31716 | 31716 | 2022-10-01 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1225 | 0 | 6 | 0 |
20429 | 20429 | 2022-09-30 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31715 | 31715 | 2022-09-30 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1225 | 0 | 6 | 0 |
20428 | 20428 | 2022-09-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31714 | 31714 | 2022-09-29 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1225 | 0 | 6 | 0 |
20427 | 20427 | 2022-09-28 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31713 | 31713 | 2022-09-28 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1225 | 2 | 6 | 0 |
20426 | 20426 | 2022-09-27 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31712 | 31712 | 2022-09-27 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1223 | 2 | 6 | 0 |
20425 | 20425 | 2022-09-26 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31711 | 31711 | 2022-09-26 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1221 | 0 | 6 | 0 |
20424 | 20424 | 2022-09-25 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31710 | 31710 | 2022-09-25 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1221 | 0 | 6 | 0 |
20423 | 20423 | 2022-09-24 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31709 | 31709 | 2022-09-24 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1221 | 2 | 6 | 0 |
20422 | 20422 | 2022-09-23 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31708 | 31708 | 2022-09-23 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1219 | 0 | 6 | 0 |
20421 | 20421 | 2022-09-22 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3569 | 0 | 21 | 0 |
31707 | 31707 | 2022-09-22 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1219 | 2 | 6 | 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 );