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,025 rows where new_deaths = 0 and zipcode = 95327
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32834 | 32834 | 2020-03-11 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32835 | 32835 | 2020-03-12 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32836 | 32836 | 2020-03-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32837 | 32837 | 2020-03-14 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32838 | 32838 | 2020-03-15 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32839 | 32839 | 2020-03-16 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32840 | 32840 | 2020-03-17 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32841 | 32841 | 2020-03-18 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32842 | 32842 | 2020-03-19 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32843 | 32843 | 2020-03-20 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32844 | 32844 | 2020-03-21 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32845 | 32845 | 2020-03-22 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32846 | 32846 | 2020-03-23 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32847 | 32847 | 2020-03-24 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32848 | 32848 | 2020-03-25 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32849 | 32849 | 2020-03-26 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32850 | 32850 | 2020-03-27 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32851 | 32851 | 2020-03-28 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32852 | 32852 | 2020-03-29 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32853 | 32853 | 2020-03-30 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32854 | 32854 | 2020-03-31 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32855 | 32855 | 2020-04-01 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32856 | 32856 | 2020-04-02 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32857 | 32857 | 2020-04-03 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32858 | 32858 | 2020-04-04 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32859 | 32859 | 2020-04-05 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32860 | 32860 | 2020-04-06 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32861 | 32861 | 2020-04-07 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32862 | 32862 | 2020-04-08 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32863 | 32863 | 2020-04-09 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32864 | 32864 | 2020-04-10 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32865 | 32865 | 2020-04-11 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32866 | 32866 | 2020-04-12 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32867 | 32867 | 2020-04-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32868 | 32868 | 2020-04-14 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32869 | 32869 | 2020-04-15 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32870 | 32870 | 2020-04-16 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32871 | 32871 | 2020-04-17 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32872 | 32872 | 2020-04-18 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32873 | 32873 | 2020-04-19 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32874 | 32874 | 2020-04-20 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32875 | 32875 | 2020-04-21 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32876 | 32876 | 2020-04-22 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32877 | 32877 | 2020-04-23 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32878 | 32878 | 2020-04-24 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32879 | 32879 | 2020-04-25 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32880 | 32880 | 2020-04-26 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32881 | 32881 | 2020-04-27 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32882 | 32882 | 2020-04-28 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32883 | 32883 | 2020-04-29 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32884 | 32884 | 2020-04-30 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32885 | 32885 | 2020-05-01 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32886 | 32886 | 2020-05-02 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32887 | 32887 | 2020-05-03 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32888 | 32888 | 2020-05-04 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32889 | 32889 | 2020-05-05 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32890 | 32890 | 2020-05-06 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32891 | 32891 | 2020-05-07 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32892 | 32892 | 2020-05-08 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32893 | 32893 | 2020-05-09 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32894 | 32894 | 2020-05-10 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32895 | 32895 | 2020-05-11 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32896 | 32896 | 2020-05-12 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32897 | 32897 | 2020-05-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32898 | 32898 | 2020-05-14 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32899 | 32899 | 2020-05-15 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32900 | 32900 | 2020-05-16 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32901 | 32901 | 2020-05-17 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32902 | 32902 | 2020-05-18 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32903 | 32903 | 2020-05-19 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32904 | 32904 | 2020-05-20 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32905 | 32905 | 2020-05-21 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 0 | 0 | 0 | 0 |
32906 | 32906 | 2020-05-22 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 1 | 0 | 0 |
32907 | 32907 | 2020-05-23 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32908 | 32908 | 2020-05-24 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32909 | 32909 | 2020-05-25 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32910 | 32910 | 2020-05-26 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32911 | 32911 | 2020-05-27 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32912 | 32912 | 2020-05-28 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32913 | 32913 | 2020-05-29 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32914 | 32914 | 2020-05-30 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32915 | 32915 | 2020-05-31 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32916 | 32916 | 2020-06-01 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32917 | 32917 | 2020-06-02 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32918 | 32918 | 2020-06-03 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32919 | 32919 | 2020-06-04 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32920 | 32920 | 2020-06-05 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32921 | 32921 | 2020-06-06 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32922 | 32922 | 2020-06-07 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32923 | 32923 | 2020-06-08 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32924 | 32924 | 2020-06-09 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32925 | 32925 | 2020-06-10 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32926 | 32926 | 2020-06-11 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32927 | 32927 | 2020-06-12 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32928 | 32928 | 2020-06-13 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32929 | 32929 | 2020-06-14 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32930 | 32930 | 2020-06-15 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32931 | 32931 | 2020-06-16 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32932 | 32932 | 2020-06-17 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 0 | 0 | 0 |
32933 | 32933 | 2020-06-18 | SCC | Sierra Conservation Center | Jamestown | Tuolumne | 109 | 95327 | -120.5454373 | 37.8900437 | 1 | 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 );