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 = "California Men's Colony" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9134 | 9134 | 2022-09-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3697 | 1 | 13 | 0 |
9133 | 9133 | 2022-09-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3696 | 0 | 13 | 0 |
9132 | 9132 | 2022-09-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3696 | 1 | 13 | 0 |
9131 | 9131 | 2022-09-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3695 | 0 | 13 | 0 |
9130 | 9130 | 2022-09-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3695 | 0 | 13 | 0 |
9129 | 9129 | 2022-09-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3695 | 1 | 13 | 0 |
9128 | 9128 | 2022-09-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3694 | 1 | 13 | 0 |
9127 | 9127 | 2022-09-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9126 | 9126 | 2022-09-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9125 | 9125 | 2022-09-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9124 | 9124 | 2022-09-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9123 | 9123 | 2022-09-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9122 | 9122 | 2022-09-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9121 | 9121 | 2022-09-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9120 | 9120 | 2022-09-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9119 | 9119 | 2022-09-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9118 | 9118 | 2022-09-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9117 | 9117 | 2022-09-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 0 | 13 | 0 |
9116 | 9116 | 2022-09-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3693 | 1 | 13 | 0 |
9115 | 9115 | 2022-09-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3692 | 0 | 13 | 0 |
9114 | 9114 | 2022-09-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3692 | 0 | 13 | 0 |
9113 | 9113 | 2022-08-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3692 | 0 | 13 | 0 |
9112 | 9112 | 2022-08-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3692 | 1 | 13 | 0 |
9111 | 9111 | 2022-08-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9110 | 9110 | 2022-08-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9109 | 9109 | 2022-08-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9108 | 9108 | 2022-08-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9107 | 9107 | 2022-08-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9106 | 9106 | 2022-08-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9105 | 9105 | 2022-08-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9104 | 9104 | 2022-08-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9103 | 9103 | 2022-08-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 0 | 13 | 0 |
9102 | 9102 | 2022-08-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3691 | 1 | 13 | 0 |
9101 | 9101 | 2022-08-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3690 | 1 | 13 | 0 |
9100 | 9100 | 2022-08-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3689 | 2 | 13 | 0 |
9099 | 9099 | 2022-08-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9098 | 9098 | 2022-08-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9097 | 9097 | 2022-08-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9096 | 9096 | 2022-08-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9095 | 9095 | 2022-08-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9094 | 9094 | 2022-08-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9093 | 9093 | 2022-08-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 0 | 13 | 0 |
9092 | 9092 | 2022-08-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3687 | 1 | 13 | 0 |
9091 | 9091 | 2022-08-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3686 | 1 | 13 | 0 |
9090 | 9090 | 2022-08-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3685 | 0 | 13 | 0 |
9089 | 9089 | 2022-08-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3685 | 2 | 13 | 0 |
9088 | 9088 | 2022-08-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3683 | 0 | 13 | 0 |
9087 | 9087 | 2022-08-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3683 | 0 | 13 | 0 |
9086 | 9086 | 2022-08-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3683 | 8 | 13 | 0 |
9085 | 9085 | 2022-08-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3675 | 6 | 13 | 0 |
9084 | 9084 | 2022-08-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3669 | 1 | 13 | 0 |
9083 | 9083 | 2022-08-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3668 | 4 | 13 | 0 |
9082 | 9082 | 2022-07-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3664 | 1 | 13 | 0 |
9081 | 9081 | 2022-07-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3663 | 0 | 13 | 0 |
9080 | 9080 | 2022-07-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3663 | 0 | 13 | 0 |
9079 | 9079 | 2022-07-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3663 | 0 | 13 | 0 |
9078 | 9078 | 2022-07-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3663 | 1 | 13 | 0 |
9077 | 9077 | 2022-07-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3662 | 2 | 13 | 0 |
9076 | 9076 | 2022-07-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3660 | 1 | 13 | 0 |
9075 | 9075 | 2022-07-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3659 | 0 | 13 | 0 |
9074 | 9074 | 2022-07-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3659 | 0 | 13 | 0 |
9073 | 9073 | 2022-07-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3659 | 6 | 13 | 0 |
9072 | 9072 | 2022-07-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3653 | 2 | 13 | 0 |
9071 | 9071 | 2022-07-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3651 | 1 | 13 | 0 |
9070 | 9070 | 2022-07-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3650 | 1 | 13 | 0 |
9069 | 9069 | 2022-07-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3649 | 0 | 13 | 0 |
9068 | 9068 | 2022-07-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3649 | 7 | 13 | 0 |
9067 | 9067 | 2022-07-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3642 | 5 | 13 | 0 |
9066 | 9066 | 2022-07-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3637 | 2 | 13 | 0 |
9065 | 9065 | 2022-07-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3635 | 1 | 13 | 0 |
9064 | 9064 | 2022-07-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3634 | 3 | 13 | 0 |
9063 | 9063 | 2022-07-12 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3631 | 0 | 13 | 0 |
9062 | 9062 | 2022-07-11 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3631 | 6 | 13 | 0 |
9061 | 9061 | 2022-07-10 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3625 | 11 | 13 | 0 |
9060 | 9060 | 2022-07-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3614 | 0 | 13 | 0 |
9059 | 9059 | 2022-07-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3614 | 0 | 13 | 0 |
9058 | 9058 | 2022-07-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3614 | 0 | 13 | 0 |
9057 | 9057 | 2022-07-06 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3614 | 29 | 13 | 0 |
9056 | 9056 | 2022-07-05 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3585 | 13 | 13 | 0 |
9055 | 9055 | 2022-07-04 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3572 | 42 | 13 | 0 |
9054 | 9054 | 2022-07-03 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3530 | 1 | 13 | 0 |
9053 | 9053 | 2022-07-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3529 | 1 | 13 | 0 |
9052 | 9052 | 2022-07-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3528 | 16 | 13 | 0 |
9051 | 9051 | 2022-06-30 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3512 | 36 | 13 | 0 |
9050 | 9050 | 2022-06-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3476 | 3 | 13 | 0 |
9049 | 9049 | 2022-06-28 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3473 | 1 | 13 | 0 |
9048 | 9048 | 2022-06-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3472 | 0 | 13 | 0 |
9047 | 9047 | 2022-06-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3472 | 16 | 13 | 0 |
9046 | 9046 | 2022-06-25 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3456 | 1 | 13 | 0 |
9045 | 9045 | 2022-06-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3455 | 1 | 13 | 0 |
9044 | 9044 | 2022-06-23 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3454 | 0 | 13 | 0 |
9043 | 9043 | 2022-06-22 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3454 | 1 | 13 | 0 |
9042 | 9042 | 2022-06-21 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3453 | 0 | 13 | 0 |
9041 | 9041 | 2022-06-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3453 | 0 | 13 | 0 |
9040 | 9040 | 2022-06-19 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3453 | 0 | 13 | 0 |
9039 | 9039 | 2022-06-18 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3453 | 0 | 13 | 0 |
9038 | 9038 | 2022-06-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3453 | 1 | 13 | 0 |
9037 | 9037 | 2022-06-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3452 | 0 | 13 | 0 |
9036 | 9036 | 2022-06-15 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3452 | 1 | 13 | 0 |
9035 | 9035 | 2022-06-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3451 | 17 | 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 );