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 = "San Quentin State Prison" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, deaths, new_deaths, date (date)
confirmed_cases 253 ✖
- 2252 83
- 0 82
- 2260 68
- 2239 56
- 2238 43
- 2250 38
- 2837 37
- 2245 34
- 2262 29
- 2251 27
- 2835 23
- 2254 21
- 2264 18
- 2236 14
- 3080 14
- 2253 10
- 2255 10
- 2266 10
- 3083 10
- 2259 9
- 2836 9
- 3079 8
- 3236 7
- 3238 7
- 2237 6
- 3039 6
- 3230 6
- 2233 5
- 2242 5
- 2249 5
- 2265 5
- 3041 5
- 3077 5
- 17 4
- 2243 4
- 2246 4
- 3034 4
- 3036 4
- 3070 4
- 3075 4
- 3231 4
- 3239 4
- 49 3
- 2175 3
- 2223 3
- 2258 3
- 2263 3
- 2271 3
- 2832 3
- 3038 3
- 3062 3
- 3064 3
- 3068 3
- 3071 3
- 3110 3
- 3127 3
- 3181 3
- 3203 3
- 3210 3
- 16 2
- 501 2
- 1206 2
- 2070 2
- 2117 2
- 2256 2
- 2261 2
- 2682 2
- 2821 2
- 2826 2
- 2834 2
- 2838 2
- 3017 2
- 3028 2
- 3037 2
- 3043 2
- 3065 2
- 3074 2
- 3097 2
- 3105 2
- 3122 2
- 3123 2
- 3124 2
- 3136 2
- 3163 2
- 3173 2
- 3175 2
- 3176 2
- 3189 2
- 3200 2
- 1 1
- 2 1
- 9 1
- 26 1
- 27 1
- 31 1
- 198 1
- 319 1
- 321 1
- 465 1
- 506 1
- 599 1
- 791 1
- 1011 1
- 1170 1
- 1209 1
- 1506 1
- 1533 1
- 1548 1
- 1562 1
- 1634 1
- 1682 1
- 1695 1
- 1813 1
- 1972 1
- 1980 1
- 2009 1
- 2067 1
- 2076 1
- 2098 1
- 2106 1
- 2109 1
- 2115 1
- 2118 1
- 2141 1
- 2149 1
- 2174 1
- 2177 1
- 2202 1
- 2214 1
- 2219 1
- 2224 1
- 2226 1
- 2229 1
- 2235 1
- 2244 1
- 2248 1
- 2267 1
- 2270 1
- 2339 1
- 2345 1
- 2364 1
- 2490 1
- 2502 1
- 2510 1
- 2513 1
- 2518 1
- 2597 1
- 2599 1
- 2635 1
- 2637 1
- 2699 1
- 2704 1
- 2708 1
- 2749 1
- 2761 1
- 2762 1
- 2763 1
- 2765 1
- 2773 1
- 2774 1
- 2778 1
- 2791 1
- 2814 1
- 2815 1
- 2817 1
- 2823 1
- 2824 1
- 2827 1
- 2831 1
- 2866 1
- 2867 1
- 2877 1
- 2895 1
- 2901 1
- 2903 1
- 2915 1
- 2916 1
- 2926 1
- 2944 1
- 2958 1
- 2961 1
- 2966 1
- 2995 1
- 3001 1
- 3009 1
- 3013 1
- 3015 1
- 3025 1
- 3027 1
- 3030 1
- 3031 1
- 3035 1
- 3040 1
- 3044 1
- 3048 1
- 3051 1
- 3052 1
- 3055 1
- 3056 1
- 3058 1
- 3059 1
- 3060 1
- 3063 1
- 3066 1
- 3067 1
- 3069 1
- 3073 1
- 3076 1
- 3078 1
- 3082 1
- 3084 1
- 3087 1
- 3088 1
- 3091 1
- 3092 1
- 3096 1
- 3098 1
- 3099 1
- 3100 1
- 3101 1
- 3109 1
- 3111 1
- 3112 1
- 3114 1
- 3115 1
- 3117 1
- 3119 1
- 3126 1
- 3128 1
- 3129 1
- 3141 1
- 3145 1
- 3146 1
- 3147 1
- 3148 1
- 3155 1
- 3157 1
- 3159 1
- 3165 1
- 3166 1
- 3172 1
- 3179 1
- 3193 1
- 3198 1
- 3202 1
- 3212 1
- 3215 1
- 3220 1
- 3221 1
- 3227 1
- 3229 1
- 3232 1
- 3234 1
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 );