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 y
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-06-18 35
- 2020-06-19 35
- 2020-06-20 35
- 2020-06-21 35
- 2020-06-22 35
- 2020-06-23 35
- 2020-06-24 35
- 2020-06-25 35
- 2020-06-26 35
- 2020-06-27 35
- 2020-06-28 35
- 2020-06-29 35
- 2020-06-30 35
- 2020-07-01 35
- 2020-07-02 35
- 2020-07-03 35
- 2020-07-04 35
- 2020-07-05 35
- 2020-07-06 35
- 2020-07-07 35
- 2020-07-08 35
- 2020-07-09 35
- 2020-07-10 35
- 2020-07-11 35
- 2020-07-12 35
- 2020-07-13 35
- 2020-07-14 35
- 2020-07-15 35
- 2020-07-16 35
- 2020-07-17 35
- …
Link | rowid | date | code | name | city | county | fips | zipcode | x | y ▼ | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29855 | 29855 | 2020-06-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29856 | 29856 | 2020-06-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29857 | 29857 | 2020-06-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29858 | 29858 | 2020-06-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29859 | 29859 | 2020-06-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29860 | 29860 | 2020-06-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29861 | 29861 | 2020-06-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29862 | 29862 | 2020-06-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29863 | 29863 | 2020-06-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29864 | 29864 | 2020-06-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29865 | 29865 | 2020-06-28 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29866 | 29866 | 2020-06-29 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29867 | 29867 | 2020-06-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29868 | 29868 | 2020-07-01 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29869 | 29869 | 2020-07-02 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29870 | 29870 | 2020-07-03 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29871 | 29871 | 2020-07-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29872 | 29872 | 2020-07-05 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29873 | 29873 | 2020-07-06 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29874 | 29874 | 2020-07-07 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29875 | 29875 | 2020-07-08 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29876 | 29876 | 2020-07-09 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29877 | 29877 | 2020-07-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29878 | 29878 | 2020-07-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29879 | 29879 | 2020-07-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29880 | 29880 | 2020-07-13 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29881 | 29881 | 2020-07-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 0 | 0 | 0 | 0 |
29882 | 29882 | 2020-07-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 1 | 0 | 0 |
29883 | 29883 | 2020-07-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29884 | 29884 | 2020-07-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29885 | 29885 | 2020-07-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29886 | 29886 | 2020-07-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29887 | 29887 | 2020-07-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29888 | 29888 | 2020-07-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29889 | 29889 | 2020-07-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29890 | 29890 | 2020-07-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29891 | 29891 | 2020-07-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29892 | 29892 | 2020-07-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29893 | 29893 | 2020-07-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29894 | 29894 | 2020-07-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29895 | 29895 | 2020-07-28 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29896 | 29896 | 2020-07-29 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1 | 0 | 0 | 0 |
29897 | 29897 | 2020-07-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 2 | 1 | 0 | 0 |
29898 | 29898 | 2020-07-31 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 2 | 0 | 0 | 0 |
29899 | 29899 | 2020-08-01 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 1 | 0 | 0 |
29900 | 29900 | 2020-08-02 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29901 | 29901 | 2020-08-03 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29902 | 29902 | 2020-08-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29903 | 29903 | 2020-08-05 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29904 | 29904 | 2020-08-06 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29905 | 29905 | 2020-08-07 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29906 | 29906 | 2020-08-08 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29907 | 29907 | 2020-08-09 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29908 | 29908 | 2020-08-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29909 | 29909 | 2020-08-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29910 | 29910 | 2020-08-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29911 | 29911 | 2020-08-13 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29912 | 29912 | 2020-08-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29913 | 29913 | 2020-08-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29914 | 29914 | 2020-08-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29915 | 29915 | 2020-08-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29916 | 29916 | 2020-08-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29917 | 29917 | 2020-08-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29918 | 29918 | 2020-08-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29919 | 29919 | 2020-08-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29920 | 29920 | 2020-08-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29921 | 29921 | 2020-08-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29922 | 29922 | 2020-08-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29923 | 29923 | 2020-08-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29924 | 29924 | 2020-08-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29925 | 29925 | 2020-08-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29926 | 29926 | 2020-08-28 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29927 | 29927 | 2020-08-29 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29928 | 29928 | 2020-08-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29929 | 29929 | 2020-08-31 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29930 | 29930 | 2020-09-01 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29931 | 29931 | 2020-09-02 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29932 | 29932 | 2020-09-03 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29933 | 29933 | 2020-09-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29934 | 29934 | 2020-09-05 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29935 | 29935 | 2020-09-06 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29936 | 29936 | 2020-09-07 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29937 | 29937 | 2020-09-08 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29938 | 29938 | 2020-09-09 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29939 | 29939 | 2020-09-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29940 | 29940 | 2020-09-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29941 | 29941 | 2020-09-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29942 | 29942 | 2020-09-13 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29943 | 29943 | 2020-09-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29944 | 29944 | 2020-09-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29945 | 29945 | 2020-09-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29946 | 29946 | 2020-09-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29947 | 29947 | 2020-09-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29948 | 29948 | 2020-09-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29949 | 29949 | 2020-09-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29950 | 29950 | 2020-09-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29951 | 29951 | 2020-09-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29952 | 29952 | 2020-09-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29953 | 29953 | 2020-09-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 0 |
29954 | 29954 | 2020-09-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 3 | 0 | 0 | 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 );