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 = 92101 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30680 | 30680 | 2022-09-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1704 | 1 | 21 | 0 |
30679 | 30679 | 2022-09-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1703 | 0 | 21 | 0 |
30678 | 30678 | 2022-09-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1703 | 1 | 21 | 0 |
30677 | 30677 | 2022-09-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1702 | 0 | 21 | 0 |
30676 | 30676 | 2022-09-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1702 | 0 | 21 | 0 |
30675 | 30675 | 2022-09-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1702 | 3 | 21 | 0 |
30674 | 30674 | 2022-09-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1699 | 1 | 21 | 0 |
30673 | 30673 | 2022-09-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1698 | 1 | 21 | 0 |
30672 | 30672 | 2022-09-13 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1697 | 0 | 21 | 0 |
30671 | 30671 | 2022-09-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1697 | 4 | 21 | 0 |
30670 | 30670 | 2022-09-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1693 | 0 | 21 | 0 |
30669 | 30669 | 2022-09-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1693 | 1 | 21 | 0 |
30668 | 30668 | 2022-09-09 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1692 | 4 | 21 | 0 |
30667 | 30667 | 2022-09-08 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1688 | 3 | 21 | 0 |
30666 | 30666 | 2022-09-07 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1685 | 4 | 21 | 0 |
30665 | 30665 | 2022-09-06 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1681 | 0 | 21 | 0 |
30664 | 30664 | 2022-09-05 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1681 | 0 | 21 | 0 |
30663 | 30663 | 2022-09-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1681 | 0 | 21 | 0 |
30662 | 30662 | 2022-09-03 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1681 | 0 | 21 | 0 |
30661 | 30661 | 2022-09-02 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1681 | 1 | 21 | 0 |
30660 | 30660 | 2022-09-01 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1680 | 0 | 21 | 0 |
30659 | 30659 | 2022-08-31 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1680 | 1 | 21 | 0 |
30658 | 30658 | 2022-08-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1679 | 0 | 21 | 0 |
30657 | 30657 | 2022-08-29 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1679 | 3 | 21 | 0 |
30656 | 30656 | 2022-08-28 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1676 | 0 | 21 | 0 |
30655 | 30655 | 2022-08-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1676 | 0 | 21 | 0 |
30654 | 30654 | 2022-08-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1676 | 0 | 21 | 0 |
30653 | 30653 | 2022-08-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1676 | 0 | 21 | 0 |
30652 | 30652 | 2022-08-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1676 | 0 | 21 | 0 |
30651 | 30651 | 2022-08-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1676 | 1 | 21 | 0 |
30650 | 30650 | 2022-08-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1675 | 0 | 21 | 0 |
30649 | 30649 | 2022-08-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1675 | 0 | 21 | 0 |
30648 | 30648 | 2022-08-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1675 | 0 | 21 | 0 |
30647 | 30647 | 2022-08-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1675 | 1 | 21 | 0 |
30646 | 30646 | 2022-08-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1674 | 1 | 21 | 0 |
30645 | 30645 | 2022-08-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1673 | 0 | 21 | 0 |
30644 | 30644 | 2022-08-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1673 | 2 | 21 | 0 |
30643 | 30643 | 2022-08-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1671 | 1 | 21 | 0 |
30642 | 30642 | 2022-08-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1670 | 0 | 21 | 0 |
30641 | 30641 | 2022-08-13 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1670 | 0 | 21 | 0 |
30640 | 30640 | 2022-08-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1670 | 1 | 21 | 0 |
30639 | 30639 | 2022-08-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1669 | 1 | 21 | 0 |
30638 | 30638 | 2022-08-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1668 | 1 | 21 | 0 |
30637 | 30637 | 2022-08-09 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1667 | 2 | 21 | 0 |
30636 | 30636 | 2022-08-08 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1665 | 4 | 21 | 0 |
30635 | 30635 | 2022-08-07 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1661 | 1 | 21 | 0 |
30634 | 30634 | 2022-08-06 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1660 | 2 | 21 | 0 |
30633 | 30633 | 2022-08-05 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1658 | 2 | 21 | 0 |
30632 | 30632 | 2022-08-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1656 | 7 | 21 | 0 |
30631 | 30631 | 2022-08-03 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1649 | 2 | 21 | 0 |
30630 | 30630 | 2022-08-02 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1647 | 6 | 21 | 0 |
30629 | 30629 | 2022-08-01 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1641 | 3 | 21 | 0 |
30628 | 30628 | 2022-07-31 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1638 | 2 | 21 | 0 |
30627 | 30627 | 2022-07-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1636 | 4 | 21 | 0 |
30626 | 30626 | 2022-07-29 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1632 | 4 | 21 | 0 |
30625 | 30625 | 2022-07-28 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1628 | 3 | 21 | 0 |
30624 | 30624 | 2022-07-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1625 | 7 | 21 | 0 |
30623 | 30623 | 2022-07-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1618 | 8 | 21 | 0 |
30622 | 30622 | 2022-07-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1610 | 4 | 21 | 0 |
30621 | 30621 | 2022-07-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1606 | 2 | 21 | 0 |
30620 | 30620 | 2022-07-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1604 | 4 | 21 | 0 |
30619 | 30619 | 2022-07-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1600 | 2 | 21 | 0 |
30618 | 30618 | 2022-07-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1598 | 2 | 21 | 0 |
30617 | 30617 | 2022-07-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1596 | 12 | 21 | 0 |
30616 | 30616 | 2022-07-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1584 | 26 | 21 | 0 |
30615 | 30615 | 2022-07-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1558 | 3 | 21 | 0 |
30614 | 30614 | 2022-07-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1555 | 0 | 21 | 0 |
30613 | 30613 | 2022-07-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1555 | 1 | 21 | 0 |
30612 | 30612 | 2022-07-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1554 | 3 | 21 | 0 |
30611 | 30611 | 2022-07-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1551 | 5 | 21 | 0 |
30610 | 30610 | 2022-07-13 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1546 | 3 | 21 | 0 |
30609 | 30609 | 2022-07-12 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1543 | 5 | 21 | 0 |
30608 | 30608 | 2022-07-11 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1538 | 4 | 21 | 0 |
30607 | 30607 | 2022-07-10 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1534 | 1 | 21 | 0 |
30606 | 30606 | 2022-07-09 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1533 | 3 | 21 | 0 |
30605 | 30605 | 2022-07-08 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1530 | 5 | 21 | 0 |
30604 | 30604 | 2022-07-07 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1525 | 1 | 21 | 0 |
30603 | 30603 | 2022-07-06 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1524 | 1 | 21 | 0 |
30602 | 30602 | 2022-07-05 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1523 | 14 | 21 | 0 |
30601 | 30601 | 2022-07-04 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1509 | 2 | 21 | 0 |
30600 | 30600 | 2022-07-03 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1507 | 9 | 21 | 0 |
30599 | 30599 | 2022-07-02 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1498 | 1 | 21 | 0 |
30598 | 30598 | 2022-07-01 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1497 | 1 | 21 | 0 |
30597 | 30597 | 2022-06-30 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1496 | 18 | 21 | 0 |
30596 | 30596 | 2022-06-29 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1478 | 5 | 21 | 0 |
30595 | 30595 | 2022-06-28 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1473 | 1 | 21 | 0 |
30594 | 30594 | 2022-06-27 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1472 | 2 | 21 | 0 |
30593 | 30593 | 2022-06-26 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30592 | 30592 | 2022-06-25 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30591 | 30591 | 2022-06-24 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30590 | 30590 | 2022-06-23 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30589 | 30589 | 2022-06-22 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30588 | 30588 | 2022-06-21 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30587 | 30587 | 2022-06-20 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30586 | 30586 | 2022-06-19 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30585 | 30585 | 2022-06-18 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30584 | 30584 | 2022-06-17 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30583 | 30583 | 2022-06-16 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30582 | 30582 | 2022-06-15 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 0 |
30581 | 30581 | 2022-06-14 | RJD | Richard J. Donovan Correctional Facility | San Diego | San Diego | 73 | 92101 | -116.9334776 | 32.5846461 | 1470 | 0 | 21 | 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 );