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 = "Pelican Bay State Prison" sorted by date descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28628 | 28628 | 2022-09-21 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28627 | 28627 | 2022-09-20 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28626 | 28626 | 2022-09-19 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28625 | 28625 | 2022-09-18 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28624 | 28624 | 2022-09-17 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28623 | 28623 | 2022-09-16 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28622 | 28622 | 2022-09-15 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28621 | 28621 | 2022-09-14 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28620 | 28620 | 2022-09-13 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28619 | 28619 | 2022-09-12 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28618 | 28618 | 2022-09-11 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28617 | 28617 | 2022-09-10 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28616 | 28616 | 2022-09-09 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28615 | 28615 | 2022-09-08 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28614 | 28614 | 2022-09-07 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28613 | 28613 | 2022-09-06 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28612 | 28612 | 2022-09-05 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28611 | 28611 | 2022-09-04 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28610 | 28610 | 2022-09-03 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28609 | 28609 | 2022-09-02 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 0 | 0 | 0 |
28608 | 28608 | 2022-09-01 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 910 | 1 | 0 | 0 |
28607 | 28607 | 2022-08-31 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28606 | 28606 | 2022-08-30 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28605 | 28605 | 2022-08-29 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28604 | 28604 | 2022-08-28 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28603 | 28603 | 2022-08-27 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28602 | 28602 | 2022-08-26 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28601 | 28601 | 2022-08-25 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28600 | 28600 | 2022-08-24 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28599 | 28599 | 2022-08-23 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28598 | 28598 | 2022-08-22 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28597 | 28597 | 2022-08-21 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28596 | 28596 | 2022-08-20 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28595 | 28595 | 2022-08-19 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28594 | 28594 | 2022-08-18 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28593 | 28593 | 2022-08-17 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28592 | 28592 | 2022-08-16 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28591 | 28591 | 2022-08-15 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28590 | 28590 | 2022-08-14 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 0 | 0 | 0 |
28589 | 28589 | 2022-08-13 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 909 | 1 | 0 | 0 |
28588 | 28588 | 2022-08-12 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28587 | 28587 | 2022-08-11 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28586 | 28586 | 2022-08-10 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28585 | 28585 | 2022-08-09 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28584 | 28584 | 2022-08-08 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28583 | 28583 | 2022-08-07 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28582 | 28582 | 2022-08-06 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 0 | 0 | 0 |
28581 | 28581 | 2022-08-05 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 908 | 1 | 0 | 0 |
28580 | 28580 | 2022-08-04 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 907 | 0 | 0 | 0 |
28579 | 28579 | 2022-08-03 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 907 | 0 | 0 | 0 |
28578 | 28578 | 2022-08-02 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 907 | 0 | 0 | 0 |
28577 | 28577 | 2022-08-01 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 907 | 1 | 0 | 0 |
28576 | 28576 | 2022-07-31 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 906 | 2 | 0 | 0 |
28575 | 28575 | 2022-07-30 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28574 | 28574 | 2022-07-29 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28573 | 28573 | 2022-07-28 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28572 | 28572 | 2022-07-27 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28571 | 28571 | 2022-07-26 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28570 | 28570 | 2022-07-25 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28569 | 28569 | 2022-07-24 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28568 | 28568 | 2022-07-23 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 0 | 0 | 0 |
28567 | 28567 | 2022-07-22 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 904 | 1 | 0 | 0 |
28566 | 28566 | 2022-07-21 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 903 | 0 | 0 | 0 |
28565 | 28565 | 2022-07-20 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 903 | 1 | 0 | 0 |
28564 | 28564 | 2022-07-19 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 902 | 0 | 0 | 0 |
28563 | 28563 | 2022-07-18 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 902 | 2 | 0 | 0 |
28562 | 28562 | 2022-07-17 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 900 | 1 | 0 | 0 |
28561 | 28561 | 2022-07-16 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 899 | 0 | 0 | 0 |
28560 | 28560 | 2022-07-15 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 899 | 0 | 0 | 0 |
28559 | 28559 | 2022-07-14 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 899 | 1 | 0 | 0 |
28558 | 28558 | 2022-07-13 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 898 | 10 | 0 | 0 |
28557 | 28557 | 2022-07-12 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 888 | 50 | 0 | 0 |
28556 | 28556 | 2022-07-11 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 838 | 20 | 0 | 0 |
28555 | 28555 | 2022-07-10 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 818 | 1 | 0 | 0 |
28554 | 28554 | 2022-07-09 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 817 | 2 | 0 | 0 |
28553 | 28553 | 2022-07-08 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 815 | 8 | 0 | 0 |
28552 | 28552 | 2022-07-07 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 807 | 12 | 0 | 0 |
28551 | 28551 | 2022-07-06 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 795 | 2 | 0 | 0 |
28550 | 28550 | 2022-07-05 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 793 | 13 | 0 | 0 |
28549 | 28549 | 2022-07-04 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 780 | 3 | 0 | 0 |
28548 | 28548 | 2022-07-03 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 777 | 0 | 0 | 0 |
28547 | 28547 | 2022-07-02 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 777 | 11 | 0 | 0 |
28546 | 28546 | 2022-07-01 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 766 | 0 | 0 | 0 |
28545 | 28545 | 2022-06-30 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 766 | 5 | 0 | 0 |
28544 | 28544 | 2022-06-29 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 761 | 12 | 0 | 0 |
28543 | 28543 | 2022-06-28 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 749 | 4 | 0 | 0 |
28542 | 28542 | 2022-06-27 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 745 | 2 | 0 | 0 |
28541 | 28541 | 2022-06-26 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 743 | 2 | 0 | 0 |
28540 | 28540 | 2022-06-25 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 741 | 2 | 0 | 0 |
28539 | 28539 | 2022-06-24 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 739 | 3 | 0 | 0 |
28538 | 28538 | 2022-06-23 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 736 | 6 | 0 | 0 |
28537 | 28537 | 2022-06-22 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 730 | 11 | 0 | 0 |
28536 | 28536 | 2022-06-21 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 719 | 4 | 0 | 0 |
28535 | 28535 | 2022-06-20 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 715 | 4 | 0 | 0 |
28534 | 28534 | 2022-06-19 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 711 | 0 | 0 | 0 |
28533 | 28533 | 2022-06-18 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 711 | 0 | 0 | 0 |
28532 | 28532 | 2022-06-17 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 711 | 1 | 0 | 0 |
28531 | 28531 | 2022-06-16 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 710 | 2 | 0 | 0 |
28530 | 28530 | 2022-06-15 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 708 | 2 | 0 | 0 |
28529 | 28529 | 2022-06-14 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 706 | 2 | 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 );