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.
35,910 rows sorted by fips
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25751 | 25751 | 2020-06-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25752 | 25752 | 2020-06-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25753 | 25753 | 2020-06-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25754 | 25754 | 2020-06-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25755 | 25755 | 2020-06-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25756 | 25756 | 2020-06-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25757 | 25757 | 2020-06-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25758 | 25758 | 2020-06-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25759 | 25759 | 2020-06-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25760 | 25760 | 2020-06-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25761 | 25761 | 2020-06-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25762 | 25762 | 2020-06-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25763 | 25763 | 2020-06-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25764 | 25764 | 2020-07-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25765 | 25765 | 2020-07-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25766 | 25766 | 2020-07-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25767 | 25767 | 2020-07-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25768 | 25768 | 2020-07-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25769 | 25769 | 2020-07-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25770 | 25770 | 2020-07-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25771 | 25771 | 2020-07-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25772 | 25772 | 2020-07-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25773 | 25773 | 2020-07-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25774 | 25774 | 2020-07-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25775 | 25775 | 2020-07-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25776 | 25776 | 2020-07-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25777 | 25777 | 2020-07-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25778 | 25778 | 2020-07-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25779 | 25779 | 2020-07-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25780 | 25780 | 2020-07-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25781 | 25781 | 2020-07-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25782 | 25782 | 2020-07-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25783 | 25783 | 2020-07-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25784 | 25784 | 2020-07-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25785 | 25785 | 2020-07-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25786 | 25786 | 2020-07-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25787 | 25787 | 2020-07-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25788 | 25788 | 2020-07-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25789 | 25789 | 2020-07-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 0 | 0 | 0 | 0 |
25790 | 25790 | 2020-07-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1 | 1 | 0 | 0 |
25791 | 25791 | 2020-07-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 4 | 3 | 0 | 0 |
25792 | 25792 | 2020-07-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 10 | 6 | 0 | 0 |
25793 | 25793 | 2020-07-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 15 | 5 | 0 | 0 |
25794 | 25794 | 2020-07-31 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 15 | 0 | 0 | 0 |
25795 | 25795 | 2020-08-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 15 | 0 | 0 | 0 |
25796 | 25796 | 2020-08-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 16 | 1 | 0 | 0 |
25797 | 25797 | 2020-08-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 16 | 0 | 0 | 0 |
25798 | 25798 | 2020-08-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 23 | 7 | 0 | 0 |
25799 | 25799 | 2020-08-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 37 | 14 | 0 | 0 |
25800 | 25800 | 2020-08-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 39 | 2 | 0 | 0 |
25801 | 25801 | 2020-08-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 39 | 0 | 0 | 0 |
25802 | 25802 | 2020-08-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 39 | 0 | 0 | 0 |
25803 | 25803 | 2020-08-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 39 | 0 | 0 | 0 |
25804 | 25804 | 2020-08-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 39 | 0 | 0 | 0 |
25805 | 25805 | 2020-08-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 39 | 0 | 0 | 0 |
25806 | 25806 | 2020-08-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 4 | 0 | 0 |
25807 | 25807 | 2020-08-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 0 | 0 |
25808 | 25808 | 2020-08-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 0 | 0 |
25809 | 25809 | 2020-08-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 0 | 0 |
25810 | 25810 | 2020-08-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 0 | 0 |
25811 | 25811 | 2020-08-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 0 | 0 |
25812 | 25812 | 2020-08-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 1 |
25813 | 25813 | 2020-08-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25814 | 25814 | 2020-08-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25815 | 25815 | 2020-08-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25816 | 25816 | 2020-08-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25817 | 25817 | 2020-08-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25818 | 25818 | 2020-08-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25819 | 25819 | 2020-08-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25820 | 25820 | 2020-08-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25821 | 25821 | 2020-08-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25822 | 25822 | 2020-08-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25823 | 25823 | 2020-08-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25824 | 25824 | 2020-08-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25825 | 25825 | 2020-08-31 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25826 | 25826 | 2020-09-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25827 | 25827 | 2020-09-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25828 | 25828 | 2020-09-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25829 | 25829 | 2020-09-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25830 | 25830 | 2020-09-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25831 | 25831 | 2020-09-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25832 | 25832 | 2020-09-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25833 | 25833 | 2020-09-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25834 | 25834 | 2020-09-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25835 | 25835 | 2020-09-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25836 | 25836 | 2020-09-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25837 | 25837 | 2020-09-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25838 | 25838 | 2020-09-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25839 | 25839 | 2020-09-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25840 | 25840 | 2020-09-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25841 | 25841 | 2020-09-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25842 | 25842 | 2020-09-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25843 | 25843 | 2020-09-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25844 | 25844 | 2020-09-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25845 | 25845 | 2020-09-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25846 | 25846 | 2020-09-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25847 | 25847 | 2020-09-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 43 | 0 | 1 | 0 |
25848 | 25848 | 2020-09-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 44 | 1 | 1 | 0 |
25849 | 25849 | 2020-09-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 44 | 0 | 1 | 0 |
25850 | 25850 | 2020-09-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 44 | 0 | 1 | 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 );