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 city = "San Quentin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_deaths
name 1 ✖
- San Quentin State Prison 1,026
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32832 | 32832 | 2022-12-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3239 | 0 | 28 | 0 |
32831 | 32831 | 2022-12-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3239 | 0 | 28 | 0 |
32830 | 32830 | 2022-12-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3239 | 0 | 28 | 0 |
32829 | 32829 | 2022-12-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3239 | 1 | 28 | 0 |
32828 | 32828 | 2022-12-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 0 | 28 | 0 |
32827 | 32827 | 2022-12-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 0 | 28 | 0 |
32826 | 32826 | 2022-12-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 0 | 28 | 0 |
32825 | 32825 | 2022-12-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 0 | 28 | 0 |
32824 | 32824 | 2022-12-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 0 | 28 | 0 |
32823 | 32823 | 2022-12-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 0 | 28 | 0 |
32822 | 32822 | 2022-12-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3238 | 2 | 28 | 0 |
32821 | 32821 | 2022-12-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 0 | 28 | 0 |
32820 | 32820 | 2022-12-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 0 | 28 | 0 |
32819 | 32819 | 2022-12-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 0 | 28 | 0 |
32818 | 32818 | 2022-12-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 0 | 28 | 0 |
32817 | 32817 | 2022-12-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 0 | 28 | 0 |
32816 | 32816 | 2022-12-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 0 | 28 | 0 |
32815 | 32815 | 2022-12-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3236 | 2 | 28 | 0 |
32814 | 32814 | 2022-12-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3234 | 2 | 28 | 0 |
32813 | 32813 | 2022-12-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3232 | 1 | 28 | 0 |
32812 | 32812 | 2022-12-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3231 | 0 | 28 | 0 |
32811 | 32811 | 2022-12-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3231 | 0 | 28 | 0 |
32810 | 32810 | 2022-12-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3231 | 0 | 28 | 0 |
32809 | 32809 | 2022-12-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3231 | 1 | 28 | 0 |
32808 | 32808 | 2022-12-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3230 | 0 | 28 | 0 |
32807 | 32807 | 2022-12-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3230 | 0 | 28 | 0 |
32806 | 32806 | 2022-12-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3230 | 0 | 28 | 0 |
32805 | 32805 | 2022-12-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3230 | 0 | 28 | 0 |
32804 | 32804 | 2022-12-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3230 | 0 | 28 | 0 |
32803 | 32803 | 2022-12-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3230 | 1 | 28 | 0 |
32802 | 32802 | 2022-11-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3229 | 2 | 28 | 0 |
32801 | 32801 | 2022-11-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3227 | 6 | 28 | 0 |
32800 | 32800 | 2022-11-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3221 | 1 | 28 | 0 |
32799 | 32799 | 2022-11-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3220 | 5 | 28 | 0 |
32798 | 32798 | 2022-11-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3215 | 3 | 28 | 0 |
32797 | 32797 | 2022-11-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3212 | 2 | 28 | 0 |
32796 | 32796 | 2022-11-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3210 | 0 | 28 | 0 |
32795 | 32795 | 2022-11-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3210 | 0 | 28 | 0 |
32794 | 32794 | 2022-11-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3210 | 7 | 28 | 0 |
32793 | 32793 | 2022-11-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3203 | 0 | 28 | 0 |
32792 | 32792 | 2022-11-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3203 | 0 | 28 | 0 |
32791 | 32791 | 2022-11-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3203 | 1 | 28 | 0 |
32790 | 32790 | 2022-11-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3202 | 2 | 28 | 0 |
32789 | 32789 | 2022-11-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3200 | 0 | 28 | 0 |
32788 | 32788 | 2022-11-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3200 | 2 | 28 | 0 |
32787 | 32787 | 2022-11-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3198 | 5 | 28 | 0 |
32786 | 32786 | 2022-11-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3193 | 4 | 28 | 0 |
32785 | 32785 | 2022-11-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3189 | 0 | 28 | 0 |
32784 | 32784 | 2022-11-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3189 | 8 | 28 | 0 |
32783 | 32783 | 2022-11-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3181 | 0 | 28 | 0 |
32782 | 32782 | 2022-11-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3181 | 0 | 28 | 0 |
32781 | 32781 | 2022-11-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3181 | 2 | 28 | 0 |
32780 | 32780 | 2022-11-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3179 | 3 | 28 | 0 |
32779 | 32779 | 2022-11-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3176 | 0 | 28 | 0 |
32778 | 32778 | 2022-11-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3176 | 1 | 28 | 0 |
32777 | 32777 | 2022-11-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3175 | 0 | 28 | 0 |
32776 | 32776 | 2022-11-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3175 | 2 | 28 | 0 |
32775 | 32775 | 2022-11-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3173 | 0 | 28 | 0 |
32774 | 32774 | 2022-11-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3173 | 1 | 28 | 0 |
32773 | 32773 | 2022-11-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3172 | 6 | 28 | 0 |
32772 | 32772 | 2022-10-31 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3166 | 1 | 28 | 0 |
32771 | 32771 | 2022-10-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3165 | 2 | 28 | 0 |
32770 | 32770 | 2022-10-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3163 | 0 | 28 | 0 |
32769 | 32769 | 2022-10-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3163 | 4 | 28 | 0 |
32768 | 32768 | 2022-10-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3159 | 2 | 28 | 0 |
32767 | 32767 | 2022-10-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3157 | 2 | 28 | 0 |
32766 | 32766 | 2022-10-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3155 | 7 | 28 | 0 |
32765 | 32765 | 2022-10-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3148 | 1 | 28 | 0 |
32764 | 32764 | 2022-10-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3147 | 1 | 28 | 0 |
32763 | 32763 | 2022-10-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3146 | 1 | 28 | 0 |
32762 | 32762 | 2022-10-21 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3145 | 4 | 28 | 0 |
32761 | 32761 | 2022-10-20 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3141 | 5 | 28 | 0 |
32760 | 32760 | 2022-10-19 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3136 | 0 | 28 | 0 |
32759 | 32759 | 2022-10-18 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3136 | 7 | 28 | 0 |
32758 | 32758 | 2022-10-17 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3129 | 1 | 28 | 0 |
32757 | 32757 | 2022-10-16 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3128 | 1 | 28 | 0 |
32756 | 32756 | 2022-10-15 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3127 | 0 | 28 | 0 |
32755 | 32755 | 2022-10-14 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3127 | 0 | 28 | 0 |
32754 | 32754 | 2022-10-13 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3127 | 1 | 28 | 0 |
32753 | 32753 | 2022-10-12 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3126 | 2 | 28 | 0 |
32752 | 32752 | 2022-10-11 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3124 | 0 | 28 | 0 |
32751 | 32751 | 2022-10-10 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3124 | 1 | 28 | 0 |
32750 | 32750 | 2022-10-09 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3123 | 0 | 28 | 0 |
32749 | 32749 | 2022-10-08 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3123 | 1 | 28 | 0 |
32748 | 32748 | 2022-10-07 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3122 | 0 | 28 | 0 |
32747 | 32747 | 2022-10-06 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3122 | 3 | 28 | 0 |
32746 | 32746 | 2022-10-05 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3119 | 2 | 28 | 0 |
32745 | 32745 | 2022-10-04 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3117 | 2 | 28 | 0 |
32744 | 32744 | 2022-10-03 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3115 | 1 | 28 | 0 |
32743 | 32743 | 2022-10-02 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3114 | 2 | 28 | 0 |
32742 | 32742 | 2022-10-01 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3112 | 1 | 28 | 0 |
32741 | 32741 | 2022-09-30 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3111 | 1 | 28 | 0 |
32740 | 32740 | 2022-09-29 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3110 | 0 | 28 | 0 |
32739 | 32739 | 2022-09-28 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3110 | 0 | 28 | 0 |
32738 | 32738 | 2022-09-27 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3110 | 1 | 28 | 0 |
32737 | 32737 | 2022-09-26 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3109 | 4 | 28 | 0 |
32736 | 32736 | 2022-09-25 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3105 | 0 | 28 | 0 |
32735 | 32735 | 2022-09-24 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3105 | 4 | 28 | 0 |
32734 | 32734 | 2022-09-23 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3101 | 1 | 28 | 0 |
32733 | 32733 | 2022-09-22 | SQ | San Quentin State Prison | San Quentin | Marin | 41 | 94964 | -122.4843922 | 37.9415566 | 3100 | 1 | 28 | 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 );