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.
585 rows where deaths = 13 and name = "California Men's Colony"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8650 | 8650 | 2021-05-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 1 |
8651 | 8651 | 2021-05-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8652 | 8652 | 2021-05-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8653 | 8653 | 2021-05-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8654 | 8654 | 2021-05-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8655 | 8655 | 2021-05-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8656 | 8656 | 2021-05-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8657 | 8657 | 2021-06-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8658 | 8658 | 2021-06-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8659 | 8659 | 2021-06-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8660 | 8660 | 2021-06-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8661 | 8661 | 2021-06-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8662 | 8662 | 2021-06-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8663 | 8663 | 2021-06-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8664 | 8664 | 2021-06-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8665 | 8665 | 2021-06-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8666 | 8666 | 2021-06-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8667 | 8667 | 2021-06-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8668 | 8668 | 2021-06-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8669 | 8669 | 2021-06-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8670 | 8670 | 2021-06-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8671 | 8671 | 2021-06-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8672 | 8672 | 2021-06-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8673 | 8673 | 2021-06-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8674 | 8674 | 2021-06-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8675 | 8675 | 2021-06-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8676 | 8676 | 2021-06-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8677 | 8677 | 2021-06-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8678 | 8678 | 2021-06-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8679 | 8679 | 2021-06-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8680 | 8680 | 2021-06-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8681 | 8681 | 2021-06-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8682 | 8682 | 2021-06-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8683 | 8683 | 2021-06-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8684 | 8684 | 2021-06-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8685 | 8685 | 2021-06-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8686 | 8686 | 2021-06-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8687 | 8687 | 2021-07-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8688 | 8688 | 2021-07-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8689 | 8689 | 2021-07-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8690 | 8690 | 2021-07-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8691 | 8691 | 2021-07-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8692 | 8692 | 2021-07-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2488 | 0 | 13 | 0 |
8693 | 8693 | 2021-07-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 1 | 13 | 0 |
8694 | 8694 | 2021-07-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8695 | 8695 | 2021-07-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8696 | 8696 | 2021-07-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8697 | 8697 | 2021-07-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8698 | 8698 | 2021-07-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8699 | 8699 | 2021-07-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8700 | 8700 | 2021-07-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8701 | 8701 | 2021-07-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8702 | 8702 | 2021-07-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8703 | 8703 | 2021-07-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8704 | 8704 | 2021-07-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8705 | 8705 | 2021-07-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8706 | 8706 | 2021-07-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8707 | 8707 | 2021-07-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8708 | 8708 | 2021-07-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8709 | 8709 | 2021-07-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8710 | 8710 | 2021-07-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8711 | 8711 | 2021-07-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8712 | 8712 | 2021-07-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8713 | 8713 | 2021-07-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8714 | 8714 | 2021-07-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8715 | 8715 | 2021-07-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8716 | 8716 | 2021-07-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8717 | 8717 | 2021-07-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8718 | 8718 | 2021-08-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8719 | 8719 | 2021-08-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8720 | 8720 | 2021-08-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8721 | 8721 | 2021-08-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8722 | 8722 | 2021-08-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8723 | 8723 | 2021-08-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8724 | 8724 | 2021-08-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8725 | 8725 | 2021-08-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8726 | 8726 | 2021-08-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8727 | 8727 | 2021-08-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8728 | 8728 | 2021-08-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8729 | 8729 | 2021-08-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2489 | 0 | 13 | 0 |
8730 | 8730 | 2021-08-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2490 | 1 | 13 | 0 |
8731 | 8731 | 2021-08-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 1 | 13 | 0 |
8732 | 8732 | 2021-08-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8733 | 8733 | 2021-08-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8734 | 8734 | 2021-08-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8735 | 8735 | 2021-08-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8736 | 8736 | 2021-08-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8737 | 8737 | 2021-08-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8738 | 8738 | 2021-08-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8739 | 8739 | 2021-08-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8740 | 8740 | 2021-08-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8741 | 8741 | 2021-08-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2491 | 0 | 13 | 0 |
8742 | 8742 | 2021-08-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2492 | 1 | 13 | 0 |
8743 | 8743 | 2021-08-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 1 | 13 | 0 |
8744 | 8744 | 2021-08-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 0 | 13 | 0 |
8745 | 8745 | 2021-08-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 0 | 13 | 0 |
8746 | 8746 | 2021-08-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 0 | 13 | 0 |
8747 | 8747 | 2021-08-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 0 | 13 | 0 |
8748 | 8748 | 2021-08-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 0 | 13 | 0 |
8749 | 8749 | 2021-09-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2493 | 0 | 13 | 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 );