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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | 2020-09-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2662 | 0 | 6 | 1 |
202 | 202 | 2020-09-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2662 | 0 | 6 | 0 |
203 | 203 | 2020-09-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2671 | 9 | 6 | 0 |
204 | 204 | 2020-09-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2796 | 125 | 6 | 0 |
205 | 205 | 2020-09-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2831 | 35 | 7 | 1 |
206 | 206 | 2020-10-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2839 | 8 | 7 | 0 |
207 | 207 | 2020-10-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2840 | 1 | 7 | 0 |
208 | 208 | 2020-10-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2842 | 2 | 7 | 0 |
209 | 209 | 2020-10-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2842 | 0 | 7 | 0 |
210 | 210 | 2020-10-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2843 | 1 | 7 | 0 |
211 | 211 | 2020-10-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2928 | 85 | 7 | 0 |
212 | 212 | 2020-10-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2936 | 8 | 7 | 0 |
213 | 213 | 2020-10-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2937 | 1 | 7 | 0 |
214 | 214 | 2020-10-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2937 | 0 | 7 | 0 |
215 | 215 | 2020-10-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2938 | 1 | 7 | 0 |
216 | 216 | 2020-10-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2938 | 0 | 7 | 0 |
217 | 217 | 2020-10-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 4 | 7 | 0 |
218 | 218 | 2020-10-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
219 | 219 | 2020-10-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
220 | 220 | 2020-10-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
221 | 221 | 2020-10-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
222 | 222 | 2020-10-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
223 | 223 | 2020-10-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2942 | 0 | 7 | 0 |
224 | 224 | 2020-10-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2944 | 2 | 7 | 0 |
225 | 225 | 2020-10-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2946 | 2 | 7 | 0 |
226 | 226 | 2020-10-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2947 | 1 | 7 | 0 |
227 | 227 | 2020-10-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2950 | 3 | 7 | 0 |
228 | 228 | 2020-10-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2953 | 3 | 7 | 0 |
229 | 229 | 2020-10-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2953 | 0 | 7 | 0 |
230 | 230 | 2020-10-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2953 | 0 | 7 | 0 |
231 | 231 | 2020-10-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2968 | 15 | 7 | 0 |
232 | 232 | 2020-10-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2968 | 0 | 7 | 0 |
233 | 233 | 2020-10-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2968 | 0 | 7 | 0 |
234 | 234 | 2020-10-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2969 | 1 | 7 | 0 |
235 | 235 | 2020-10-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 2 | 8 | 1 |
236 | 236 | 2020-10-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 0 | 8 | 0 |
237 | 237 | 2020-11-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2971 | 0 | 8 | 0 |
238 | 238 | 2020-11-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2983 | 12 | 8 | 0 |
239 | 239 | 2020-11-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2984 | 1 | 8 | 0 |
240 | 240 | 2020-11-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2984 | 0 | 8 | 0 |
241 | 241 | 2020-11-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2986 | 2 | 8 | 0 |
242 | 242 | 2020-11-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 5 | 8 | 0 |
243 | 243 | 2020-11-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 0 | 8 | 0 |
244 | 244 | 2020-11-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 0 | 8 | 0 |
245 | 245 | 2020-11-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2991 | 0 | 8 | 0 |
246 | 246 | 2020-11-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2994 | 3 | 8 | 0 |
247 | 247 | 2020-11-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2994 | 0 | 8 | 0 |
248 | 248 | 2020-11-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2995 | 1 | 8 | 0 |
249 | 249 | 2020-11-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 1 | 8 | 0 |
250 | 250 | 2020-11-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 0 | 8 | 0 |
251 | 251 | 2020-11-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 0 | 8 | 0 |
252 | 252 | 2020-11-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2996 | 0 | 8 | 0 |
253 | 253 | 2020-11-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 2999 | 3 | 8 | 0 |
254 | 254 | 2020-11-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3001 | 2 | 8 | 0 |
255 | 255 | 2020-11-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 1 | 8 | 0 |
256 | 256 | 2020-11-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 0 | 8 | 0 |
257 | 257 | 2020-11-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 0 | 8 | 0 |
258 | 258 | 2020-11-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3002 | 0 | 8 | 0 |
259 | 259 | 2020-11-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3005 | 3 | 8 | 0 |
260 | 260 | 2020-11-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3005 | 0 | 8 | 0 |
261 | 261 | 2020-11-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 1 | 8 | 0 |
262 | 262 | 2020-11-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
263 | 263 | 2020-11-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
264 | 264 | 2020-11-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
265 | 265 | 2020-11-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
266 | 266 | 2020-11-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3006 | 0 | 8 | 0 |
267 | 267 | 2020-12-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3007 | 1 | 8 | 0 |
268 | 268 | 2020-12-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3012 | 5 | 8 | 0 |
269 | 269 | 2020-12-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3012 | 0 | 8 | 0 |
270 | 270 | 2020-12-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3013 | 1 | 8 | 0 |
271 | 271 | 2020-12-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3013 | 0 | 8 | 0 |
272 | 272 | 2020-12-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3013 | 0 | 8 | 0 |
273 | 273 | 2020-12-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3014 | 1 | 8 | 0 |
274 | 274 | 2020-12-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3014 | 0 | 8 | 0 |
275 | 275 | 2020-12-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3015 | 1 | 8 | 0 |
276 | 276 | 2020-12-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 1 | 8 | 0 |
277 | 277 | 2020-12-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 0 | 8 | 0 |
278 | 278 | 2020-12-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 0 | 8 | 0 |
279 | 279 | 2020-12-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3016 | 0 | 8 | 0 |
280 | 280 | 2020-12-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3038 | 22 | 8 | 0 |
281 | 281 | 2020-12-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3038 | 0 | 8 | 0 |
282 | 282 | 2020-12-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3040 | 2 | 8 | 0 |
283 | 283 | 2020-12-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3067 | 27 | 8 | 0 |
284 | 284 | 2020-12-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 2 | 8 | 0 |
285 | 285 | 2020-12-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 0 | 8 | 0 |
286 | 286 | 2020-12-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3069 | 0 | 8 | 0 |
287 | 287 | 2020-12-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3094 | 25 | 8 | 0 |
288 | 288 | 2020-12-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3094 | 0 | 8 | 0 |
289 | 289 | 2020-12-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 1 | 8 | 0 |
290 | 290 | 2020-12-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
291 | 291 | 2020-12-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
292 | 292 | 2020-12-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
293 | 293 | 2020-12-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3095 | 0 | 8 | 0 |
294 | 294 | 2020-12-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3104 | 9 | 8 | 0 |
295 | 295 | 2020-12-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3104 | 0 | 8 | 0 |
296 | 296 | 2020-12-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3105 | 1 | 8 | 0 |
297 | 297 | 2020-12-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 5 | 8 | 0 |
298 | 298 | 2021-01-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 0 |
299 | 299 | 2021-01-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 0 |
300 | 300 | 2021-01-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 3110 | 0 | 8 | 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 );