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.
107 rows where deaths = 0 and name = "San Quentin State Prison"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31807 | 31807 | 2020-03-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | ||
31808 | 31808 | 2020-03-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31809 | 31809 | 2020-03-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31810 | 31810 | 2020-03-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31811 | 31811 | 2020-03-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31812 | 31812 | 2020-03-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31813 | 31813 | 2020-03-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31814 | 31814 | 2020-03-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31815 | 31815 | 2020-03-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31816 | 31816 | 2020-03-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31817 | 31817 | 2020-03-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31818 | 31818 | 2020-03-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31819 | 31819 | 2020-03-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31820 | 31820 | 2020-03-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31821 | 31821 | 2020-03-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31822 | 31822 | 2020-03-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31823 | 31823 | 2020-03-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31824 | 31824 | 2020-03-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31825 | 31825 | 2020-03-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31826 | 31826 | 2020-03-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31827 | 31827 | 2020-03-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31828 | 31828 | 2020-03-31 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31829 | 31829 | 2020-04-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31830 | 31830 | 2020-04-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31831 | 31831 | 2020-04-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31832 | 31832 | 2020-04-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31833 | 31833 | 2020-04-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31834 | 31834 | 2020-04-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31835 | 31835 | 2020-04-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31836 | 31836 | 2020-04-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31837 | 31837 | 2020-04-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31838 | 31838 | 2020-04-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31839 | 31839 | 2020-04-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31840 | 31840 | 2020-04-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31841 | 31841 | 2020-04-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31842 | 31842 | 2020-04-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31843 | 31843 | 2020-04-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31844 | 31844 | 2020-04-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31845 | 31845 | 2020-04-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31846 | 31846 | 2020-04-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31847 | 31847 | 2020-04-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31848 | 31848 | 2020-04-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31849 | 31849 | 2020-04-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31850 | 31850 | 2020-04-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31851 | 31851 | 2020-04-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31852 | 31852 | 2020-04-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31853 | 31853 | 2020-04-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31854 | 31854 | 2020-04-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31855 | 31855 | 2020-04-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31856 | 31856 | 2020-04-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31857 | 31857 | 2020-04-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31858 | 31858 | 2020-04-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31859 | 31859 | 2020-05-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31860 | 31860 | 2020-05-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31861 | 31861 | 2020-05-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31862 | 31862 | 2020-05-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31863 | 31863 | 2020-05-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31864 | 31864 | 2020-05-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31865 | 31865 | 2020-05-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31866 | 31866 | 2020-05-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31867 | 31867 | 2020-05-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31868 | 31868 | 2020-05-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31869 | 31869 | 2020-05-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31870 | 31870 | 2020-05-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31871 | 31871 | 2020-05-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31872 | 31872 | 2020-05-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31873 | 31873 | 2020-05-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31874 | 31874 | 2020-05-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31875 | 31875 | 2020-05-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31876 | 31876 | 2020-05-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31877 | 31877 | 2020-05-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31878 | 31878 | 2020-05-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31879 | 31879 | 2020-05-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31880 | 31880 | 2020-05-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31881 | 31881 | 2020-05-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31882 | 31882 | 2020-05-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31883 | 31883 | 2020-05-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31884 | 31884 | 2020-05-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31885 | 31885 | 2020-05-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31886 | 31886 | 2020-05-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31887 | 31887 | 2020-05-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31888 | 31888 | 2020-05-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 0 | 0 | 0 | 0 |
31889 | 31889 | 2020-05-31 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 1 | 1 | 0 | 0 |
31890 | 31890 | 2020-06-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 2 | 1 | 0 | 0 |
31891 | 31891 | 2020-06-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 9 | 7 | 0 | 0 |
31892 | 31892 | 2020-06-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 16 | 7 | 0 | 0 |
31893 | 31893 | 2020-06-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 16 | 0 | 0 | 0 |
31894 | 31894 | 2020-06-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 17 | 1 | 0 | 0 |
31895 | 31895 | 2020-06-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 17 | 0 | 0 | 0 |
31896 | 31896 | 2020-06-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 17 | 0 | 0 | 0 |
31897 | 31897 | 2020-06-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 17 | 0 | 0 | 0 |
31898 | 31898 | 2020-06-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 26 | 9 | 0 | 0 |
31899 | 31899 | 2020-06-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 27 | 1 | 0 | 0 |
31900 | 31900 | 2020-06-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 31 | 4 | 0 | 0 |
31901 | 31901 | 2020-06-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 49 | 18 | 0 | 0 |
31902 | 31902 | 2020-06-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 49 | 0 | 0 | 0 |
31903 | 31903 | 2020-06-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 49 | 0 | 0 | 0 |
31904 | 31904 | 2020-06-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 198 | 149 | 0 | 0 |
31905 | 31905 | 2020-06-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 319 | 121 | 0 | 0 |
31906 | 31906 | 2020-06-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 321 | 2 | 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 );