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 name = "California Correctional Institution" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4004 | 4004 | 2022-09-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1789 | 1 | 4 | 0 |
4003 | 4003 | 2022-09-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1788 | 2 | 4 | 0 |
4002 | 4002 | 2022-09-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1786 | 2 | 4 | 0 |
4001 | 4001 | 2022-09-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1784 | 0 | 4 | 0 |
4000 | 4000 | 2022-09-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1784 | 0 | 4 | 0 |
3999 | 3999 | 2022-09-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1784 | 0 | 4 | 0 |
3998 | 3998 | 2022-09-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1784 | 0 | 4 | 0 |
3997 | 3997 | 2022-09-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1784 | 2 | 4 | 0 |
3996 | 3996 | 2022-09-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1782 | 3 | 4 | 0 |
3995 | 3995 | 2022-09-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1779 | 1 | 4 | 0 |
3994 | 3994 | 2022-09-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1778 | 0 | 4 | 0 |
3993 | 3993 | 2022-09-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1778 | 0 | 4 | 0 |
3992 | 3992 | 2022-09-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1778 | 5 | 4 | 0 |
3991 | 3991 | 2022-09-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1773 | 0 | 4 | 0 |
3990 | 3990 | 2022-09-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1773 | 5 | 4 | 0 |
3989 | 3989 | 2022-09-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1768 | 1 | 4 | 0 |
3988 | 3988 | 2022-09-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1767 | 3 | 4 | 0 |
3987 | 3987 | 2022-09-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1764 | 0 | 4 | 0 |
3986 | 3986 | 2022-09-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1764 | 2 | 4 | 0 |
3985 | 3985 | 2022-09-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1762 | 1 | 4 | 0 |
3984 | 3984 | 2022-09-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1761 | 1 | 4 | 0 |
3983 | 3983 | 2022-08-31 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1760 | 0 | 4 | 0 |
3982 | 3982 | 2022-08-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1760 | 3 | 4 | 0 |
3981 | 3981 | 2022-08-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1757 | 0 | 4 | 0 |
3980 | 3980 | 2022-08-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1757 | 0 | 4 | 0 |
3979 | 3979 | 2022-08-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1757 | 0 | 4 | 0 |
3978 | 3978 | 2022-08-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1757 | 1 | 4 | 0 |
3977 | 3977 | 2022-08-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1756 | 2 | 4 | 0 |
3976 | 3976 | 2022-08-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3975 | 3975 | 2022-08-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3974 | 3974 | 2022-08-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3973 | 3973 | 2022-08-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3972 | 3972 | 2022-08-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3971 | 3971 | 2022-08-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3970 | 3970 | 2022-08-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3969 | 3969 | 2022-08-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 0 | 4 | 0 |
3968 | 3968 | 2022-08-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1754 | 1 | 4 | 0 |
3967 | 3967 | 2022-08-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1753 | 2 | 4 | 0 |
3966 | 3966 | 2022-08-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1751 | 1 | 4 | 0 |
3965 | 3965 | 2022-08-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1750 | 0 | 4 | 0 |
3964 | 3964 | 2022-08-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1750 | 0 | 4 | 0 |
3963 | 3963 | 2022-08-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1750 | 0 | 4 | 0 |
3962 | 3962 | 2022-08-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1750 | 1 | 4 | 0 |
3961 | 3961 | 2022-08-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1749 | 1 | 4 | 0 |
3960 | 3960 | 2022-08-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1748 | 1 | 4 | 0 |
3959 | 3959 | 2022-08-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1747 | 1 | 4 | 0 |
3958 | 3958 | 2022-08-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1746 | 1 | 4 | 0 |
3957 | 3957 | 2022-08-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1745 | 6 | 4 | 0 |
3956 | 3956 | 2022-08-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1739 | 1 | 4 | 0 |
3955 | 3955 | 2022-08-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1738 | 1 | 4 | 0 |
3954 | 3954 | 2022-08-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1737 | 4 | 4 | 0 |
3953 | 3953 | 2022-08-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1733 | 14 | 4 | 0 |
3952 | 3952 | 2022-07-31 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1719 | 0 | 4 | 0 |
3951 | 3951 | 2022-07-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1719 | 1 | 4 | 0 |
3950 | 3950 | 2022-07-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1718 | 1 | 4 | 0 |
3949 | 3949 | 2022-07-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1717 | 0 | 4 | 0 |
3948 | 3948 | 2022-07-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1717 | 3 | 4 | 0 |
3947 | 3947 | 2022-07-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1714 | 4 | 4 | 0 |
3946 | 3946 | 2022-07-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1710 | 0 | 4 | 0 |
3945 | 3945 | 2022-07-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1710 | 0 | 4 | 0 |
3944 | 3944 | 2022-07-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1710 | 2 | 4 | 0 |
3943 | 3943 | 2022-07-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 0 | 4 | 0 |
3942 | 3942 | 2022-07-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 0 | 4 | 0 |
3941 | 3941 | 2022-07-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 0 | 4 | 0 |
3940 | 3940 | 2022-07-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 0 | 4 | 0 |
3939 | 3939 | 2022-07-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 0 | 4 | 0 |
3938 | 3938 | 2022-07-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 0 | 4 | 0 |
3937 | 3937 | 2022-07-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1708 | 1 | 4 | 0 |
3936 | 3936 | 2022-07-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1707 | 0 | 4 | 0 |
3935 | 3935 | 2022-07-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1707 | 0 | 4 | 0 |
3934 | 3934 | 2022-07-13 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1707 | 1 | 4 | 0 |
3933 | 3933 | 2022-07-12 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1706 | 1 | 4 | 0 |
3932 | 3932 | 2022-07-11 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1705 | 0 | 4 | 0 |
3931 | 3931 | 2022-07-10 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1705 | 1 | 4 | 0 |
3930 | 3930 | 2022-07-09 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1704 | 0 | 4 | 0 |
3929 | 3929 | 2022-07-08 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1704 | 0 | 4 | 0 |
3928 | 3928 | 2022-07-07 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1704 | 1 | 4 | 0 |
3927 | 3927 | 2022-07-06 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1703 | 0 | 4 | 0 |
3926 | 3926 | 2022-07-05 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1703 | 1 | 4 | 0 |
3925 | 3925 | 2022-07-04 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1702 | 0 | 4 | 0 |
3924 | 3924 | 2022-07-03 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1702 | 0 | 4 | 0 |
3923 | 3923 | 2022-07-02 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1702 | 2 | 4 | 0 |
3922 | 3922 | 2022-07-01 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1700 | 2 | 4 | 0 |
3921 | 3921 | 2022-06-30 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1698 | 0 | 4 | 0 |
3920 | 3920 | 2022-06-29 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1698 | 5 | 4 | 0 |
3919 | 3919 | 2022-06-28 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1693 | 1 | 4 | 0 |
3918 | 3918 | 2022-06-27 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1692 | 1 | 4 | 0 |
3917 | 3917 | 2022-06-26 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1691 | 0 | 4 | 0 |
3916 | 3916 | 2022-06-25 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1691 | 0 | 4 | 0 |
3915 | 3915 | 2022-06-24 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1691 | 13 | 4 | 0 |
3914 | 3914 | 2022-06-23 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1678 | 0 | 4 | 0 |
3913 | 3913 | 2022-06-22 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1678 | 7 | 4 | 0 |
3912 | 3912 | 2022-06-21 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1671 | 5 | 4 | 0 |
3911 | 3911 | 2022-06-20 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1666 | 2 | 4 | 0 |
3910 | 3910 | 2022-06-19 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1664 | 1 | 4 | 0 |
3909 | 3909 | 2022-06-18 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1663 | 0 | 4 | 0 |
3908 | 3908 | 2022-06-17 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1663 | 0 | 4 | 0 |
3907 | 3907 | 2022-06-16 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1663 | 0 | 4 | 0 |
3906 | 3906 | 2022-06-15 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1663 | 0 | 4 | 0 |
3905 | 3905 | 2022-06-14 | CCI | California Correctional Institution | Tehachapi | Kern | 29 | 93561 | -118.5694869 | 35.1133011 | 1663 | 0 | 4 | 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 );