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 = "Calipatria State Prison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, deaths, new_deaths, date (date)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17442 | 17442 | 2022-12-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17441 | 17441 | 2022-12-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17440 | 17440 | 2022-12-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17439 | 17439 | 2022-12-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17438 | 17438 | 2022-12-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17437 | 17437 | 2022-12-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17436 | 17436 | 2022-12-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17435 | 17435 | 2022-12-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17434 | 17434 | 2022-12-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17433 | 17433 | 2022-12-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17432 | 17432 | 2022-12-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 0 | 3 | 0 |
17431 | 17431 | 2022-12-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1481 | 1 | 3 | 0 |
17430 | 17430 | 2022-12-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 0 | 3 | 0 |
17429 | 17429 | 2022-12-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 0 | 3 | 0 |
17428 | 17428 | 2022-12-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 0 | 3 | 0 |
17427 | 17427 | 2022-12-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 0 | 3 | 0 |
17426 | 17426 | 2022-12-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 0 | 3 | 0 |
17425 | 17425 | 2022-12-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 0 | 3 | 0 |
17424 | 17424 | 2022-12-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1480 | 1 | 3 | 0 |
17423 | 17423 | 2022-12-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17422 | 17422 | 2022-12-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17421 | 17421 | 2022-12-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17420 | 17420 | 2022-12-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17419 | 17419 | 2022-12-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17418 | 17418 | 2022-12-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17417 | 17417 | 2022-12-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17416 | 17416 | 2022-12-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17415 | 17415 | 2022-12-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17414 | 17414 | 2022-12-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17413 | 17413 | 2022-12-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17412 | 17412 | 2022-11-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 0 | 3 | 0 |
17411 | 17411 | 2022-11-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1479 | 1 | 3 | 0 |
17410 | 17410 | 2022-11-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17409 | 17409 | 2022-11-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17408 | 17408 | 2022-11-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17407 | 17407 | 2022-11-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17406 | 17406 | 2022-11-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17405 | 17405 | 2022-11-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17404 | 17404 | 2022-11-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17403 | 17403 | 2022-11-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17402 | 17402 | 2022-11-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17401 | 17401 | 2022-11-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 0 | 3 | 0 |
17400 | 17400 | 2022-11-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1478 | 1 | 3 | 0 |
17399 | 17399 | 2022-11-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1477 | 1 | 3 | 0 |
17398 | 17398 | 2022-11-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17397 | 17397 | 2022-11-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17396 | 17396 | 2022-11-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17395 | 17395 | 2022-11-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17394 | 17394 | 2022-11-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17393 | 17393 | 2022-11-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17392 | 17392 | 2022-11-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 0 | 3 | 0 |
17391 | 17391 | 2022-11-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1476 | 1 | 3 | 0 |
17390 | 17390 | 2022-11-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1475 | 1 | 3 | 0 |
17389 | 17389 | 2022-11-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1474 | 1 | 3 | 0 |
17388 | 17388 | 2022-11-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1473 | 0 | 3 | 0 |
17387 | 17387 | 2022-11-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1473 | 0 | 3 | 0 |
17386 | 17386 | 2022-11-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1473 | 1 | 3 | 0 |
17385 | 17385 | 2022-11-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1472 | 0 | 3 | 0 |
17384 | 17384 | 2022-11-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1472 | 0 | 3 | 0 |
17383 | 17383 | 2022-11-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1472 | 0 | 3 | 0 |
17382 | 17382 | 2022-10-31 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1472 | 2 | 3 | 0 |
17381 | 17381 | 2022-10-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1470 | 0 | 3 | 0 |
17380 | 17380 | 2022-10-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1470 | 0 | 3 | 0 |
17379 | 17379 | 2022-10-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1470 | 1 | 3 | 0 |
17378 | 17378 | 2022-10-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1469 | 1 | 3 | 0 |
17377 | 17377 | 2022-10-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1468 | 0 | 3 | 0 |
17376 | 17376 | 2022-10-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1468 | 3 | 3 | 0 |
17375 | 17375 | 2022-10-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1465 | 0 | 3 | 0 |
17374 | 17374 | 2022-10-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1465 | 0 | 3 | 0 |
17373 | 17373 | 2022-10-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1465 | 1 | 3 | 0 |
17372 | 17372 | 2022-10-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1464 | 0 | 3 | 0 |
17371 | 17371 | 2022-10-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1464 | 0 | 3 | 0 |
17370 | 17370 | 2022-10-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1464 | 1 | 3 | 0 |
17369 | 17369 | 2022-10-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1463 | 0 | 3 | 0 |
17368 | 17368 | 2022-10-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1463 | 2 | 3 | 0 |
17367 | 17367 | 2022-10-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1461 | 0 | 3 | 0 |
17366 | 17366 | 2022-10-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1461 | 0 | 3 | 0 |
17365 | 17365 | 2022-10-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1461 | 0 | 3 | 0 |
17364 | 17364 | 2022-10-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1461 | 0 | 3 | 0 |
17363 | 17363 | 2022-10-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1461 | 0 | 3 | 0 |
17362 | 17362 | 2022-10-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1461 | 1 | 3 | 0 |
17361 | 17361 | 2022-10-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1460 | 0 | 3 | 0 |
17360 | 17360 | 2022-10-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1460 | 0 | 3 | 0 |
17359 | 17359 | 2022-10-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1460 | 0 | 3 | 0 |
17358 | 17358 | 2022-10-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1460 | 1 | 3 | 0 |
17357 | 17357 | 2022-10-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1459 | 0 | 3 | 0 |
17356 | 17356 | 2022-10-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1459 | 0 | 3 | 0 |
17355 | 17355 | 2022-10-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1459 | 0 | 3 | 0 |
17354 | 17354 | 2022-10-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1459 | 1 | 3 | 0 |
17353 | 17353 | 2022-10-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1458 | 0 | 3 | 0 |
17352 | 17352 | 2022-10-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1458 | 0 | 3 | 0 |
17351 | 17351 | 2022-09-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1458 | 0 | 3 | 0 |
17350 | 17350 | 2022-09-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1458 | 0 | 3 | 0 |
17349 | 17349 | 2022-09-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1458 | 0 | 3 | 0 |
17348 | 17348 | 2022-09-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1458 | 2 | 3 | 0 |
17347 | 17347 | 2022-09-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17346 | 17346 | 2022-09-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17345 | 17345 | 2022-09-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17344 | 17344 | 2022-09-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 3 | 0 |
17343 | 17343 | 2022-09-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1456 | 0 | 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 );