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 confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, deaths, date (date)
Link | rowid | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases ▼ | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16417 | 16417 | 2020-03-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | ||
16418 | 16418 | 2020-03-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16419 | 16419 | 2020-03-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16420 | 16420 | 2020-03-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16421 | 16421 | 2020-03-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16422 | 16422 | 2020-03-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16423 | 16423 | 2020-03-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16424 | 16424 | 2020-03-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16425 | 16425 | 2020-03-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16426 | 16426 | 2020-03-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16427 | 16427 | 2020-03-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16428 | 16428 | 2020-03-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16429 | 16429 | 2020-03-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16430 | 16430 | 2020-03-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16431 | 16431 | 2020-03-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16432 | 16432 | 2020-03-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16433 | 16433 | 2020-03-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16434 | 16434 | 2020-03-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16435 | 16435 | 2020-03-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16436 | 16436 | 2020-03-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16437 | 16437 | 2020-03-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16438 | 16438 | 2020-03-31 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16439 | 16439 | 2020-04-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16440 | 16440 | 2020-04-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16441 | 16441 | 2020-04-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16442 | 16442 | 2020-04-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16443 | 16443 | 2020-04-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16444 | 16444 | 2020-04-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16445 | 16445 | 2020-04-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16446 | 16446 | 2020-04-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16447 | 16447 | 2020-04-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16448 | 16448 | 2020-04-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16449 | 16449 | 2020-04-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16450 | 16450 | 2020-04-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16451 | 16451 | 2020-04-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16452 | 16452 | 2020-04-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16453 | 16453 | 2020-04-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16454 | 16454 | 2020-04-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16455 | 16455 | 2020-04-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16456 | 16456 | 2020-04-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16457 | 16457 | 2020-04-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16458 | 16458 | 2020-04-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16459 | 16459 | 2020-04-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16460 | 16460 | 2020-04-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16461 | 16461 | 2020-04-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16462 | 16462 | 2020-04-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16463 | 16463 | 2020-04-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16464 | 16464 | 2020-04-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16465 | 16465 | 2020-04-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16466 | 16466 | 2020-04-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16467 | 16467 | 2020-04-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16468 | 16468 | 2020-04-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16469 | 16469 | 2020-05-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16470 | 16470 | 2020-05-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16471 | 16471 | 2020-05-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16472 | 16472 | 2020-05-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16473 | 16473 | 2020-05-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16474 | 16474 | 2020-05-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16475 | 16475 | 2020-05-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16476 | 16476 | 2020-05-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16477 | 16477 | 2020-05-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16478 | 16478 | 2020-05-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16479 | 16479 | 2020-05-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16480 | 16480 | 2020-05-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16481 | 16481 | 2020-05-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16482 | 16482 | 2020-05-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16483 | 16483 | 2020-05-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16484 | 16484 | 2020-05-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16485 | 16485 | 2020-05-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16486 | 16486 | 2020-05-18 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16487 | 16487 | 2020-05-19 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16488 | 16488 | 2020-05-20 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16489 | 16489 | 2020-05-21 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16490 | 16490 | 2020-05-22 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16491 | 16491 | 2020-05-23 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16492 | 16492 | 2020-05-24 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16493 | 16493 | 2020-05-25 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16494 | 16494 | 2020-05-26 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16495 | 16495 | 2020-05-27 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16496 | 16496 | 2020-05-28 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16497 | 16497 | 2020-05-29 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16498 | 16498 | 2020-05-30 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16499 | 16499 | 2020-05-31 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16500 | 16500 | 2020-06-01 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16501 | 16501 | 2020-06-02 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16502 | 16502 | 2020-06-03 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16503 | 16503 | 2020-06-04 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16504 | 16504 | 2020-06-05 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16505 | 16505 | 2020-06-06 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16506 | 16506 | 2020-06-07 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16507 | 16507 | 2020-06-08 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16508 | 16508 | 2020-06-09 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16509 | 16509 | 2020-06-10 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16510 | 16510 | 2020-06-11 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16511 | 16511 | 2020-06-12 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16512 | 16512 | 2020-06-13 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16513 | 16513 | 2020-06-14 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16514 | 16514 | 2020-06-15 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 0 | 0 | 0 | 0 |
16515 | 16515 | 2020-06-16 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1 | 1 | 0 | 0 |
16516 | 16516 | 2020-06-17 | CAL | Calipatria State Prison | Calipatria | Imperial | 25 | 92233 | -115.4931693 | 33.163567 | 1 | 0 | 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 );