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.
139 rows where new_confirmed_cases = 1 and y = "37.8947278"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4221 | 4221 | 2020-07-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1 | 1 | 0 | 0 |
4224 | 4224 | 2020-07-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 2 | 1 | 0 | 0 |
4227 | 4227 | 2020-07-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 1 | 0 | 0 |
4241 | 4241 | 2020-07-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 1 | 0 | 0 |
4269 | 4269 | 2020-08-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 5 | 1 | 0 | 0 |
4272 | 4272 | 2020-08-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 1 | 0 | 0 |
4281 | 4281 | 2020-09-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 1 | 1 | 0 |
4325 | 4325 | 2020-10-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 8 | 1 | 1 | 0 |
4327 | 4327 | 2020-10-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 9 | 1 | 1 | 0 |
4335 | 4335 | 2020-10-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 10 | 1 | 1 | 0 |
4353 | 4353 | 2020-11-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 11 | 1 | 1 | 0 |
4355 | 4355 | 2020-11-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 12 | 1 | 1 | 0 |
4358 | 4358 | 2020-11-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 18 | 1 | 1 | 0 |
4363 | 4363 | 2020-11-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 23 | 1 | 1 | 0 |
4366 | 4366 | 2020-11-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 28 | 1 | 1 | 0 |
4375 | 4375 | 2020-12-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 37 | 1 | 1 | 0 |
4383 | 4383 | 2020-12-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 52 | 1 | 2 | 1 |
4389 | 4389 | 2020-12-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 184 | 1 | 2 | 0 |
4391 | 4391 | 2020-12-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 189 | 1 | 3 | 0 |
4396 | 4396 | 2020-12-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 347 | 1 | 4 | 1 |
4408 | 4408 | 2021-01-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 551 | 1 | 9 | 0 |
4416 | 4416 | 2021-01-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 567 | 1 | 11 | 0 |
4429 | 4429 | 2021-01-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 603 | 1 | 13 | 0 |
4433 | 4433 | 2021-02-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 611 | 1 | 14 | 0 |
4434 | 4434 | 2021-02-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 612 | 1 | 14 | 0 |
4439 | 4439 | 2021-02-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 615 | 1 | 17 | 2 |
4443 | 4443 | 2021-02-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 618 | 1 | 18 | 0 |
4456 | 4456 | 2021-02-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 619 | 1 | 18 | 0 |
4463 | 4463 | 2021-03-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 620 | 1 | 18 | 0 |
4475 | 4475 | 2021-03-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 621 | 1 | 18 | 0 |
4478 | 4478 | 2021-03-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 622 | 1 | 18 | 0 |
4482 | 4482 | 2021-03-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 623 | 1 | 18 | 0 |
4486 | 4486 | 2021-03-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 624 | 1 | 18 | 0 |
4490 | 4490 | 2021-03-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 625 | 1 | 18 | 0 |
4497 | 4497 | 2021-04-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 626 | 1 | 18 | 0 |
4506 | 4506 | 2021-04-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 629 | 1 | 18 | 0 |
4511 | 4511 | 2021-04-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 630 | 1 | 18 | 0 |
4514 | 4514 | 2021-04-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 631 | 1 | 18 | 0 |
4520 | 4520 | 2021-04-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 632 | 1 | 18 | 0 |
4533 | 4533 | 2021-05-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 636 | 1 | 19 | 0 |
4535 | 4535 | 2021-05-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 637 | 1 | 19 | 0 |
4539 | 4539 | 2021-05-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 638 | 1 | 19 | 0 |
4540 | 4540 | 2021-05-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 639 | 1 | 19 | 0 |
4553 | 4553 | 2021-06-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 640 | 1 | 19 | 0 |
4556 | 4556 | 2021-06-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 641 | 1 | 19 | 0 |
4558 | 4558 | 2021-06-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 642 | 1 | 19 | 0 |
4559 | 4559 | 2021-06-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 643 | 1 | 19 | 0 |
4560 | 4560 | 2021-06-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 644 | 1 | 19 | 0 |
4561 | 4561 | 2021-06-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 645 | 1 | 19 | 0 |
4563 | 4563 | 2021-06-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 646 | 1 | 19 | 0 |
4573 | 4573 | 2021-06-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 647 | 1 | 19 | 0 |
4600 | 4600 | 2021-07-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 648 | 1 | 19 | 0 |
4602 | 4602 | 2021-07-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 649 | 1 | 19 | 0 |
4603 | 4603 | 2021-07-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 650 | 1 | 19 | 0 |
4608 | 4608 | 2021-07-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 651 | 1 | 19 | 0 |
4617 | 4617 | 2021-08-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 652 | 1 | 19 | 0 |
4633 | 4633 | 2021-08-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 655 | 1 | 19 | 0 |
4645 | 4645 | 2021-09-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 656 | 1 | 19 | 0 |
4652 | 4652 | 2021-09-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 657 | 1 | 19 | 0 |
4685 | 4685 | 2021-10-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 660 | 1 | 19 | 0 |
4689 | 4689 | 2021-10-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 661 | 1 | 19 | 0 |
4702 | 4702 | 2021-10-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 662 | 1 | 19 | 0 |
4703 | 4703 | 2021-10-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 663 | 1 | 19 | 0 |
4704 | 4704 | 2021-10-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 664 | 1 | 19 | 0 |
4706 | 4706 | 2021-11-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 665 | 1 | 19 | 0 |
4717 | 4717 | 2021-11-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 666 | 1 | 19 | 0 |
4724 | 4724 | 2021-11-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 667 | 1 | 19 | 0 |
4731 | 4731 | 2021-11-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 668 | 1 | 19 | 0 |
4755 | 4755 | 2021-12-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 669 | 1 | 19 | 0 |
4764 | 4764 | 2021-12-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 670 | 1 | 19 | 0 |
4782 | 4782 | 2022-01-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 792 | 1 | 19 | 0 |
4787 | 4787 | 2022-01-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 810 | 1 | 19 | 0 |
4789 | 4789 | 2022-01-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 833 | 1 | 19 | 0 |
4792 | 4792 | 2022-01-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 862 | 1 | 19 | 0 |
4794 | 4794 | 2022-01-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 865 | 1 | 19 | 0 |
4795 | 4795 | 2022-01-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 866 | 1 | 19 | 0 |
4808 | 4808 | 2022-02-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 885 | 1 | 20 | 0 |
4811 | 4811 | 2022-02-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 886 | 1 | 20 | 0 |
4812 | 4812 | 2022-02-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 887 | 1 | 20 | 0 |
4813 | 4813 | 2022-02-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 888 | 1 | 20 | 0 |
4814 | 4814 | 2022-02-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 889 | 1 | 20 | 0 |
4826 | 4826 | 2022-03-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 892 | 1 | 20 | 0 |
4827 | 4827 | 2022-03-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 893 | 1 | 20 | 0 |
4828 | 4828 | 2022-03-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 894 | 1 | 20 | 0 |
4832 | 4832 | 2022-03-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 895 | 1 | 20 | 0 |
4834 | 4834 | 2022-03-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 896 | 1 | 20 | 0 |
4837 | 4837 | 2022-03-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 897 | 1 | 20 | 0 |
4839 | 4839 | 2022-03-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 898 | 1 | 20 | 0 |
4859 | 4859 | 2022-04-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 899 | 1 | 20 | 0 |
4892 | 4892 | 2022-05-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 910 | 1 | 20 | 0 |
4915 | 4915 | 2022-05-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1191 | 1 | 21 | 0 |
4933 | 4933 | 2022-06-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1291 | 1 | 22 | 0 |
4944 | 4944 | 2022-06-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1335 | 1 | 22 | 0 |
4945 | 4945 | 2022-06-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1336 | 1 | 22 | 0 |
4947 | 4947 | 2022-06-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1350 | 1 | 22 | 0 |
4949 | 4949 | 2022-07-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1353 | 1 | 22 | 0 |
4950 | 4950 | 2022-07-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1354 | 1 | 22 | 0 |
4954 | 4954 | 2022-07-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1361 | 1 | 22 | 0 |
4961 | 4961 | 2022-07-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1371 | 1 | 22 | 0 |
4965 | 4965 | 2022-07-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1372 | 1 | 22 | 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 );