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 fips = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29754 | 29754 | 2022-12-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2772 | 0 | 3 | 0 |
29753 | 29753 | 2022-12-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2772 | 1 | 3 | 0 |
29752 | 29752 | 2022-12-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2771 | 1 | 3 | 0 |
29751 | 29751 | 2022-12-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2770 | 5 | 3 | 0 |
29750 | 29750 | 2022-12-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2765 | 0 | 3 | 0 |
29749 | 29749 | 2022-12-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2765 | 0 | 3 | 0 |
29748 | 29748 | 2022-12-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2765 | 0 | 3 | 0 |
29747 | 29747 | 2022-12-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2765 | 1 | 3 | 0 |
29746 | 29746 | 2022-12-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2764 | 3 | 3 | 0 |
29745 | 29745 | 2022-12-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2761 | 1 | 3 | 0 |
29744 | 29744 | 2022-12-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2760 | 0 | 3 | 0 |
29743 | 29743 | 2022-12-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2760 | 1 | 3 | 0 |
29742 | 29742 | 2022-12-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2759 | 0 | 3 | 0 |
29741 | 29741 | 2022-12-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2759 | 0 | 3 | 0 |
29740 | 29740 | 2022-12-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2759 | 0 | 3 | 0 |
29739 | 29739 | 2022-12-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2759 | 0 | 3 | 0 |
29738 | 29738 | 2022-12-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2759 | 0 | 3 | 0 |
29737 | 29737 | 2022-12-13 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2759 | 1 | 3 | 0 |
29736 | 29736 | 2022-12-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2758 | 1 | 3 | 0 |
29735 | 29735 | 2022-12-11 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2757 | 1 | 3 | 0 |
29734 | 29734 | 2022-12-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2756 | 1 | 3 | 0 |
29733 | 29733 | 2022-12-09 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2755 | 1 | 3 | 0 |
29732 | 29732 | 2022-12-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2754 | 0 | 3 | 0 |
29731 | 29731 | 2022-12-07 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2754 | 0 | 3 | 0 |
29730 | 29730 | 2022-12-06 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2754 | 0 | 3 | 0 |
29729 | 29729 | 2022-12-05 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2754 | 0 | 3 | 0 |
29728 | 29728 | 2022-12-04 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2754 | 0 | 3 | 0 |
29727 | 29727 | 2022-12-03 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2754 | 1 | 3 | 0 |
29726 | 29726 | 2022-12-02 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2753 | 1 | 3 | 0 |
29725 | 29725 | 2022-12-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2752 | 1 | 3 | 0 |
29724 | 29724 | 2022-11-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2751 | 4 | 3 | 0 |
29723 | 29723 | 2022-11-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2747 | 1 | 3 | 0 |
29722 | 29722 | 2022-11-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2746 | 0 | 3 | 0 |
29721 | 29721 | 2022-11-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2746 | 1 | 3 | 0 |
29720 | 29720 | 2022-11-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2745 | 0 | 3 | 0 |
29719 | 29719 | 2022-11-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2745 | 1 | 3 | 0 |
29718 | 29718 | 2022-11-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2744 | 0 | 3 | 0 |
29717 | 29717 | 2022-11-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2744 | 1 | 3 | 0 |
29716 | 29716 | 2022-11-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2743 | 1 | 3 | 0 |
29715 | 29715 | 2022-11-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2742 | 2 | 3 | 0 |
29714 | 29714 | 2022-11-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2740 | 8 | 3 | 0 |
29713 | 29713 | 2022-11-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2732 | 1 | 3 | 0 |
29712 | 29712 | 2022-11-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2731 | 0 | 3 | 0 |
29711 | 29711 | 2022-11-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2731 | 0 | 3 | 0 |
29710 | 29710 | 2022-11-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2731 | 2 | 3 | 0 |
29709 | 29709 | 2022-11-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29708 | 29708 | 2022-11-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29707 | 29707 | 2022-11-13 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29706 | 29706 | 2022-11-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29705 | 29705 | 2022-11-11 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29704 | 29704 | 2022-11-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29703 | 29703 | 2022-11-09 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29702 | 29702 | 2022-11-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29701 | 29701 | 2022-11-07 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29700 | 29700 | 2022-11-06 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29699 | 29699 | 2022-11-05 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29698 | 29698 | 2022-11-04 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29697 | 29697 | 2022-11-03 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29696 | 29696 | 2022-11-02 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29695 | 29695 | 2022-11-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29694 | 29694 | 2022-10-31 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29693 | 29693 | 2022-10-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29692 | 29692 | 2022-10-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29691 | 29691 | 2022-10-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29690 | 29690 | 2022-10-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29689 | 29689 | 2022-10-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29688 | 29688 | 2022-10-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29687 | 29687 | 2022-10-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29686 | 29686 | 2022-10-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29685 | 29685 | 2022-10-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29684 | 29684 | 2022-10-21 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29683 | 29683 | 2022-10-20 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 0 | 3 | 0 |
29682 | 29682 | 2022-10-19 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2729 | 1 | 3 | 0 |
29681 | 29681 | 2022-10-18 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29680 | 29680 | 2022-10-17 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29679 | 29679 | 2022-10-16 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29678 | 29678 | 2022-10-15 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29677 | 29677 | 2022-10-14 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29676 | 29676 | 2022-10-13 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29675 | 29675 | 2022-10-12 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29674 | 29674 | 2022-10-11 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29673 | 29673 | 2022-10-10 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29672 | 29672 | 2022-10-09 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29671 | 29671 | 2022-10-08 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29670 | 29670 | 2022-10-07 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29669 | 29669 | 2022-10-06 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29668 | 29668 | 2022-10-05 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29667 | 29667 | 2022-10-04 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29666 | 29666 | 2022-10-03 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29665 | 29665 | 2022-10-02 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29664 | 29664 | 2022-10-01 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29663 | 29663 | 2022-09-30 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29662 | 29662 | 2022-09-29 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29661 | 29661 | 2022-09-28 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29660 | 29660 | 2022-09-27 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29659 | 29659 | 2022-09-26 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29658 | 29658 | 2022-09-25 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29657 | 29657 | 2022-09-24 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29656 | 29656 | 2022-09-23 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 0 | 3 | 0 |
29655 | 29655 | 2022-09-22 | PVSP | Pleasant Valley State Prison | Coalinga | Fresno | 19 | 93210 | -120.2486679 | 36.1314523 | 2728 | 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 );