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.
1,026 rows where county = "Fresno" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29654 | 29654 | 2022-09-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29653 | 29653 | 2022-09-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29652 | 29652 | 2022-09-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29651 | 29651 | 2022-09-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 1 | 3 | 0 |
29650 | 29650 | 2022-09-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2727 | 0 | 3 | 0 |
29649 | 29649 | 2022-09-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2727 | 0 | 3 | 0 |
29648 | 29648 | 2022-09-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2727 | 0 | 3 | 0 |
29647 | 29647 | 2022-09-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2727 | 0 | 3 | 0 |
29646 | 29646 | 2022-09-13 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2727 | 2 | 3 | 0 |
29645 | 29645 | 2022-09-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29644 | 29644 | 2022-09-11 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29643 | 29643 | 2022-09-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29642 | 29642 | 2022-09-09 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29641 | 29641 | 2022-09-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29640 | 29640 | 2022-09-07 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29639 | 29639 | 2022-09-06 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29638 | 29638 | 2022-09-05 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29637 | 29637 | 2022-09-04 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29636 | 29636 | 2022-09-03 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29635 | 29635 | 2022-09-02 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29634 | 29634 | 2022-09-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29633 | 29633 | 2022-08-31 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29632 | 29632 | 2022-08-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29631 | 29631 | 2022-08-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29630 | 29630 | 2022-08-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29629 | 29629 | 2022-08-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29628 | 29628 | 2022-08-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29627 | 29627 | 2022-08-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29626 | 29626 | 2022-08-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29625 | 29625 | 2022-08-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29624 | 29624 | 2022-08-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29623 | 29623 | 2022-08-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 0 | 3 | 0 |
29622 | 29622 | 2022-08-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2725 | 1 | 3 | 0 |
29621 | 29621 | 2022-08-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2724 | 0 | 3 | 0 |
29620 | 29620 | 2022-08-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2724 | 0 | 3 | 0 |
29619 | 29619 | 2022-08-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2724 | 1 | 3 | 0 |
29618 | 29618 | 2022-08-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2723 | 10 | 3 | 0 |
29617 | 29617 | 2022-08-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2713 | 1 | 3 | 0 |
29616 | 29616 | 2022-08-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2712 | 0 | 3 | 0 |
29615 | 29615 | 2022-08-13 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2712 | 1 | 3 | 0 |
29614 | 29614 | 2022-08-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2711 | 0 | 3 | 0 |
29613 | 29613 | 2022-08-11 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2711 | 13 | 3 | 0 |
29612 | 29612 | 2022-08-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2698 | 1 | 3 | 0 |
29611 | 29611 | 2022-08-09 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2697 | 0 | 3 | 0 |
29610 | 29610 | 2022-08-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2697 | 2 | 3 | 0 |
29609 | 29609 | 2022-08-07 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2695 | 0 | 3 | 0 |
29608 | 29608 | 2022-08-06 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2695 | 0 | 3 | 0 |
29607 | 29607 | 2022-08-05 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2695 | 0 | 3 | 0 |
29606 | 29606 | 2022-08-04 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2695 | 1 | 3 | 0 |
29605 | 29605 | 2022-08-03 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2694 | 0 | 3 | 0 |
29604 | 29604 | 2022-08-02 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2694 | 1 | 3 | 0 |
29603 | 29603 | 2022-08-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2693 | 0 | 3 | 0 |
29602 | 29602 | 2022-07-31 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2693 | 2 | 3 | 0 |
29601 | 29601 | 2022-07-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2691 | 1 | 3 | 0 |
29600 | 29600 | 2022-07-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2690 | 4 | 3 | 0 |
29599 | 29599 | 2022-07-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2686 | 1 | 3 | 0 |
29598 | 29598 | 2022-07-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2685 | 1 | 3 | 0 |
29597 | 29597 | 2022-07-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2684 | 2 | 3 | 0 |
29596 | 29596 | 2022-07-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2682 | 0 | 3 | 0 |
29595 | 29595 | 2022-07-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2682 | 1 | 3 | 0 |
29594 | 29594 | 2022-07-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2681 | 0 | 3 | 0 |
29593 | 29593 | 2022-07-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2681 | 0 | 3 | 0 |
29592 | 29592 | 2022-07-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2681 | 2 | 3 | 0 |
29591 | 29591 | 2022-07-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2679 | 1 | 3 | 0 |
29590 | 29590 | 2022-07-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2678 | 4 | 3 | 0 |
29589 | 29589 | 2022-07-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2674 | 1 | 3 | 0 |
29588 | 29588 | 2022-07-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2673 | 1 | 3 | 0 |
29587 | 29587 | 2022-07-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2672 | 0 | 3 | 0 |
29586 | 29586 | 2022-07-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2672 | 0 | 3 | 0 |
29585 | 29585 | 2022-07-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2672 | 1 | 3 | 0 |
29584 | 29584 | 2022-07-13 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2671 | 0 | 3 | 0 |
29583 | 29583 | 2022-07-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2671 | 12 | 3 | 0 |
29582 | 29582 | 2022-07-11 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2659 | 2 | 3 | 0 |
29581 | 29581 | 2022-07-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2657 | 1 | 3 | 0 |
29580 | 29580 | 2022-07-09 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2656 | 1 | 3 | 0 |
29579 | 29579 | 2022-07-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2655 | 1 | 3 | 0 |
29578 | 29578 | 2022-07-07 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2654 | 3 | 3 | 0 |
29577 | 29577 | 2022-07-06 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2651 | 2 | 3 | 0 |
29576 | 29576 | 2022-07-05 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2649 | 3 | 3 | 0 |
29575 | 29575 | 2022-07-04 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2646 | 2 | 3 | 0 |
29574 | 29574 | 2022-07-03 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2644 | 0 | 3 | 0 |
29573 | 29573 | 2022-07-02 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2644 | 0 | 3 | 0 |
29572 | 29572 | 2022-07-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2644 | 0 | 3 | 0 |
29571 | 29571 | 2022-06-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2644 | 0 | 3 | 0 |
29570 | 29570 | 2022-06-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2644 | 4 | 3 | 0 |
29569 | 29569 | 2022-06-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2640 | 20 | 3 | 0 |
29568 | 29568 | 2022-06-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2620 | 1 | 3 | 0 |
29567 | 29567 | 2022-06-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2619 | 2 | 3 | 0 |
29566 | 29566 | 2022-06-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2617 | 0 | 3 | 0 |
29565 | 29565 | 2022-06-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2617 | 9 | 3 | 0 |
29564 | 29564 | 2022-06-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2608 | 11 | 3 | 0 |
29563 | 29563 | 2022-06-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2597 | 3 | 3 | 0 |
29562 | 29562 | 2022-06-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2594 | 7 | 3 | 0 |
29561 | 29561 | 2022-06-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 0 |
29560 | 29560 | 2022-06-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 0 |
29559 | 29559 | 2022-06-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 0 |
29558 | 29558 | 2022-06-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 0 |
29557 | 29557 | 2022-06-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 0 |
29556 | 29556 | 2022-06-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 0 |
29555 | 29555 | 2022-06-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2587 | 0 | 3 | 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 );