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 city = "Soledad" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20520 | 20520 | 2022-12-30 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31806 | 31806 | 2022-12-30 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1285 | 0 | 6 | 0 |
20519 | 20519 | 2022-12-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31805 | 31805 | 2022-12-29 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1285 | 1 | 6 | 0 |
20518 | 20518 | 2022-12-28 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31804 | 31804 | 2022-12-28 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1284 | 0 | 6 | 0 |
20517 | 20517 | 2022-12-27 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31803 | 31803 | 2022-12-27 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1284 | 1 | 6 | 0 |
20516 | 20516 | 2022-12-26 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31802 | 31802 | 2022-12-26 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1283 | 0 | 6 | 0 |
20515 | 20515 | 2022-12-25 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31801 | 31801 | 2022-12-25 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1283 | 1 | 6 | 0 |
20514 | 20514 | 2022-12-24 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31800 | 31800 | 2022-12-24 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1282 | 0 | 6 | 0 |
20513 | 20513 | 2022-12-23 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31799 | 31799 | 2022-12-23 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1282 | 0 | 6 | 0 |
20512 | 20512 | 2022-12-22 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31798 | 31798 | 2022-12-22 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1282 | 0 | 6 | 0 |
20511 | 20511 | 2022-12-21 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31797 | 31797 | 2022-12-21 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1282 | 1 | 6 | 0 |
20510 | 20510 | 2022-12-20 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31796 | 31796 | 2022-12-20 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1281 | 1 | 6 | 0 |
20509 | 20509 | 2022-12-19 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31795 | 31795 | 2022-12-19 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1280 | 0 | 6 | 0 |
20508 | 20508 | 2022-12-18 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31794 | 31794 | 2022-12-18 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1280 | 0 | 6 | 0 |
20507 | 20507 | 2022-12-17 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31793 | 31793 | 2022-12-17 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1280 | 0 | 6 | 0 |
20506 | 20506 | 2022-12-16 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31792 | 31792 | 2022-12-16 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1280 | 0 | 6 | 0 |
20505 | 20505 | 2022-12-15 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31791 | 31791 | 2022-12-15 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1280 | 0 | 6 | 0 |
20504 | 20504 | 2022-12-14 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 0 | 21 | 0 |
31790 | 31790 | 2022-12-14 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1280 | 6 | 6 | 0 |
20503 | 20503 | 2022-12-13 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3577 | 1 | 21 | 0 |
31789 | 31789 | 2022-12-13 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1274 | 5 | 6 | 0 |
20502 | 20502 | 2022-12-12 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31788 | 31788 | 2022-12-12 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1269 | 1 | 6 | 0 |
20501 | 20501 | 2022-12-11 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31787 | 31787 | 2022-12-11 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1268 | 0 | 6 | 0 |
20500 | 20500 | 2022-12-10 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31786 | 31786 | 2022-12-10 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1268 | 0 | 6 | 0 |
20499 | 20499 | 2022-12-09 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31785 | 31785 | 2022-12-09 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1268 | 2 | 6 | 0 |
20498 | 20498 | 2022-12-08 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31784 | 31784 | 2022-12-08 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1266 | 1 | 6 | 0 |
20497 | 20497 | 2022-12-07 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31783 | 31783 | 2022-12-07 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1265 | 2 | 6 | 0 |
20496 | 20496 | 2022-12-06 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 0 | 21 | 0 |
31782 | 31782 | 2022-12-06 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1263 | 4 | 6 | 0 |
20495 | 20495 | 2022-12-05 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3576 | 1 | 21 | 0 |
31781 | 31781 | 2022-12-05 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1259 | 4 | 6 | 0 |
20494 | 20494 | 2022-12-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31780 | 31780 | 2022-12-04 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1255 | 0 | 6 | 0 |
20493 | 20493 | 2022-12-03 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31779 | 31779 | 2022-12-03 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1255 | 0 | 6 | 0 |
20492 | 20492 | 2022-12-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31778 | 31778 | 2022-12-02 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1255 | 0 | 6 | 0 |
20491 | 20491 | 2022-12-01 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31777 | 31777 | 2022-12-01 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1255 | 3 | 6 | 0 |
20490 | 20490 | 2022-11-30 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31776 | 31776 | 2022-11-30 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1252 | 2 | 6 | 0 |
20489 | 20489 | 2022-11-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31775 | 31775 | 2022-11-29 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1250 | 0 | 6 | 0 |
20488 | 20488 | 2022-11-28 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31774 | 31774 | 2022-11-28 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1250 | 2 | 6 | 0 |
20487 | 20487 | 2022-11-27 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31773 | 31773 | 2022-11-27 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1248 | 0 | 6 | 0 |
20486 | 20486 | 2022-11-26 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31772 | 31772 | 2022-11-26 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1248 | 1 | 6 | 0 |
20485 | 20485 | 2022-11-25 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31771 | 31771 | 2022-11-25 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1247 | 0 | 6 | 0 |
20484 | 20484 | 2022-11-24 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31770 | 31770 | 2022-11-24 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1247 | 0 | 6 | 0 |
20483 | 20483 | 2022-11-23 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31769 | 31769 | 2022-11-23 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1247 | 1 | 6 | 0 |
20482 | 20482 | 2022-11-22 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31768 | 31768 | 2022-11-22 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1246 | 1 | 6 | 0 |
20481 | 20481 | 2022-11-21 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31767 | 31767 | 2022-11-21 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1245 | 0 | 6 | 0 |
20480 | 20480 | 2022-11-20 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31766 | 31766 | 2022-11-20 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1245 | 0 | 6 | 0 |
20479 | 20479 | 2022-11-19 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31765 | 31765 | 2022-11-19 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1245 | 0 | 6 | 0 |
20478 | 20478 | 2022-11-18 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 0 | 21 | 0 |
31764 | 31764 | 2022-11-18 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1245 | 0 | 6 | 0 |
20477 | 20477 | 2022-11-17 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3575 | 1 | 21 | 0 |
31763 | 31763 | 2022-11-17 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1245 | 0 | 6 | 0 |
20476 | 20476 | 2022-11-16 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31762 | 31762 | 2022-11-16 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1245 | 1 | 6 | 0 |
20475 | 20475 | 2022-11-15 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31761 | 31761 | 2022-11-15 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1244 | 1 | 6 | 0 |
20474 | 20474 | 2022-11-14 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31760 | 31760 | 2022-11-14 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1243 | 1 | 6 | 0 |
20473 | 20473 | 2022-11-13 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31759 | 31759 | 2022-11-13 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1242 | 0 | 6 | 0 |
20472 | 20472 | 2022-11-12 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31758 | 31758 | 2022-11-12 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1242 | 0 | 6 | 0 |
20471 | 20471 | 2022-11-11 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3574 | 0 | 21 | 0 |
31757 | 31757 | 2022-11-11 | SVSP | Salinas Valley State Prison | Soledad | Monterey | 53 | 93960 | -121.2781234 | 36.3639126 | 1242 | 1 | 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 );