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 zipcode = 92233 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
name 1 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17342 | 17342 | 2022-09-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17341 | 17341 | 2022-09-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17340 | 17340 | 2022-09-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17339 | 17339 | 2022-09-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17338 | 17338 | 2022-09-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17337 | 17337 | 2022-09-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17336 | 17336 | 2022-09-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17335 | 17335 | 2022-09-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17334 | 17334 | 2022-09-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 3 | 3 | 0 |
17333 | 17333 | 2022-09-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1453 | 3 | 3 | 0 |
17332 | 17332 | 2022-09-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1450 | 0 | 3 | 0 |
17331 | 17331 | 2022-09-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1450 | 0 | 3 | 0 |
17330 | 17330 | 2022-09-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1450 | 3 | 3 | 0 |
17329 | 17329 | 2022-09-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1447 | 0 | 3 | 0 |
17328 | 17328 | 2022-09-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1447 | 1 | 3 | 0 |
17327 | 17327 | 2022-09-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1446 | 1 | 3 | 0 |
17326 | 17326 | 2022-09-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1445 | 0 | 3 | 0 |
17325 | 17325 | 2022-09-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1445 | 0 | 3 | 0 |
17324 | 17324 | 2022-09-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1445 | 0 | 3 | 0 |
17323 | 17323 | 2022-09-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1445 | 4 | 3 | 0 |
17322 | 17322 | 2022-09-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1441 | 0 | 3 | 0 |
17321 | 17321 | 2022-08-31 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1441 | 0 | 3 | 0 |
17320 | 17320 | 2022-08-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1441 | 2 | 3 | 0 |
17319 | 17319 | 2022-08-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1439 | 0 | 3 | 0 |
17318 | 17318 | 2022-08-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1439 | 0 | 3 | 0 |
17317 | 17317 | 2022-08-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1439 | 0 | 3 | 0 |
17316 | 17316 | 2022-08-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1439 | 6 | 3 | 0 |
17315 | 17315 | 2022-08-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1433 | 1 | 3 | 0 |
17314 | 17314 | 2022-08-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1432 | 0 | 3 | 0 |
17313 | 17313 | 2022-08-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1432 | 6 | 3 | 0 |
17312 | 17312 | 2022-08-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1426 | 6 | 3 | 0 |
17311 | 17311 | 2022-08-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1420 | 0 | 3 | 0 |
17310 | 17310 | 2022-08-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1420 | 0 | 3 | 0 |
17309 | 17309 | 2022-08-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1420 | 0 | 3 | 0 |
17308 | 17308 | 2022-08-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1420 | 1 | 3 | 0 |
17307 | 17307 | 2022-08-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17306 | 17306 | 2022-08-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17305 | 17305 | 2022-08-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17304 | 17304 | 2022-08-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17303 | 17303 | 2022-08-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17302 | 17302 | 2022-08-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17301 | 17301 | 2022-08-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17300 | 17300 | 2022-08-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17299 | 17299 | 2022-08-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17298 | 17298 | 2022-08-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17297 | 17297 | 2022-08-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17296 | 17296 | 2022-08-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17295 | 17295 | 2022-08-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 0 | 3 | 0 |
17294 | 17294 | 2022-08-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1419 | 2 | 3 | 0 |
17293 | 17293 | 2022-08-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1417 | 1 | 3 | 0 |
17292 | 17292 | 2022-08-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1416 | 6 | 3 | 0 |
17291 | 17291 | 2022-08-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1410 | 5 | 3 | 0 |
17290 | 17290 | 2022-07-31 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1405 | 0 | 3 | 0 |
17289 | 17289 | 2022-07-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1405 | 2 | 3 | 0 |
17288 | 17288 | 2022-07-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1403 | 2 | 3 | 0 |
17287 | 17287 | 2022-07-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1401 | 1 | 3 | 0 |
17286 | 17286 | 2022-07-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1400 | 2 | 3 | 0 |
17285 | 17285 | 2022-07-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1398 | 9 | 3 | 0 |
17284 | 17284 | 2022-07-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1389 | 0 | 3 | 0 |
17283 | 17283 | 2022-07-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1389 | 0 | 3 | 0 |
17282 | 17282 | 2022-07-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1389 | 0 | 3 | 0 |
17281 | 17281 | 2022-07-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1389 | 1 | 3 | 0 |
17280 | 17280 | 2022-07-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1388 | 1 | 3 | 0 |
17279 | 17279 | 2022-07-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1387 | 4 | 3 | 0 |
17278 | 17278 | 2022-07-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1383 | 6 | 3 | 0 |
17277 | 17277 | 2022-07-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1377 | 3 | 3 | 0 |
17276 | 17276 | 2022-07-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1374 | 0 | 3 | 0 |
17275 | 17275 | 2022-07-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1374 | 0 | 3 | 0 |
17274 | 17274 | 2022-07-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1374 | 0 | 3 | 0 |
17273 | 17273 | 2022-07-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1374 | 3 | 3 | 0 |
17272 | 17272 | 2022-07-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1371 | 1 | 3 | 0 |
17271 | 17271 | 2022-07-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1370 | 1 | 3 | 0 |
17270 | 17270 | 2022-07-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1369 | 1 | 3 | 0 |
17269 | 17269 | 2022-07-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1368 | 0 | 3 | 0 |
17268 | 17268 | 2022-07-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1368 | 0 | 3 | 0 |
17267 | 17267 | 2022-07-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1368 | 3 | 3 | 0 |
17266 | 17266 | 2022-07-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1365 | 1 | 3 | 0 |
17265 | 17265 | 2022-07-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1364 | 1 | 3 | 0 |
17264 | 17264 | 2022-07-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1363 | 5 | 3 | 0 |
17263 | 17263 | 2022-07-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1358 | 0 | 3 | 0 |
17262 | 17262 | 2022-07-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1358 | 0 | 3 | 0 |
17261 | 17261 | 2022-07-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1358 | 0 | 3 | 0 |
17260 | 17260 | 2022-07-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1358 | 4 | 3 | 0 |
17259 | 17259 | 2022-06-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1354 | 0 | 3 | 0 |
17258 | 17258 | 2022-06-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1354 | 2 | 3 | 0 |
17257 | 17257 | 2022-06-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1352 | 7 | 3 | 0 |
17256 | 17256 | 2022-06-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1345 | 3 | 3 | 0 |
17255 | 17255 | 2022-06-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1342 | 0 | 3 | 0 |
17254 | 17254 | 2022-06-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1342 | 0 | 3 | 0 |
17253 | 17253 | 2022-06-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1342 | 1 | 3 | 0 |
17252 | 17252 | 2022-06-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1341 | 3 | 3 | 0 |
17251 | 17251 | 2022-06-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1338 | 2 | 3 | 0 |
17250 | 17250 | 2022-06-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1336 | 6 | 3 | 0 |
17249 | 17249 | 2022-06-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1330 | 4 | 3 | 0 |
17248 | 17248 | 2022-06-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1326 | 0 | 3 | 0 |
17247 | 17247 | 2022-06-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1326 | 1 | 3 | 0 |
17246 | 17246 | 2022-06-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1325 | 2 | 3 | 0 |
17245 | 17245 | 2022-06-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1323 | 0 | 3 | 0 |
17244 | 17244 | 2022-06-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1323 | 0 | 3 | 0 |
17243 | 17243 | 2022-06-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1323 | 1 | 3 | 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 );