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.
111 rows where name = "Mule Creek State Prison" and new_confirmed_cases = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26675 | 26675 | 2022-12-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3354 | 1 | 9 | 0 |
26670 | 26670 | 2022-12-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3342 | 1 | 9 | 0 |
26665 | 26665 | 2022-12-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3328 | 1 | 9 | 0 |
26664 | 26664 | 2022-12-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3327 | 1 | 9 | 0 |
26657 | 26657 | 2022-12-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3319 | 1 | 9 | 0 |
26651 | 26651 | 2022-12-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3313 | 1 | 9 | 0 |
26638 | 26638 | 2022-11-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 1 | 9 | 0 |
26633 | 26633 | 2022-11-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3309 | 1 | 9 | 0 |
26623 | 26623 | 2022-11-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3306 | 1 | 9 | 0 |
26617 | 26617 | 2022-11-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 1 | 9 | 0 |
26614 | 26614 | 2022-10-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3304 | 1 | 9 | 0 |
26606 | 26606 | 2022-10-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 1 | 9 | 0 |
26605 | 26605 | 2022-10-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3302 | 1 | 9 | 0 |
26596 | 26596 | 2022-10-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 1 | 9 | 0 |
26595 | 26595 | 2022-10-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3298 | 1 | 9 | 0 |
26590 | 26590 | 2022-10-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3297 | 1 | 9 | 0 |
26585 | 26585 | 2022-09-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3296 | 1 | 9 | 0 |
26584 | 26584 | 2022-09-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3295 | 1 | 9 | 0 |
26577 | 26577 | 2022-09-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3290 | 1 | 9 | 0 |
26575 | 26575 | 2022-09-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3285 | 1 | 9 | 0 |
26572 | 26572 | 2022-09-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3282 | 1 | 9 | 0 |
26569 | 26569 | 2022-09-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3279 | 1 | 9 | 0 |
26567 | 26567 | 2022-09-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3275 | 1 | 9 | 0 |
26566 | 26566 | 2022-09-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3274 | 1 | 9 | 0 |
26562 | 26562 | 2022-09-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3271 | 1 | 9 | 0 |
26561 | 26561 | 2022-09-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3270 | 1 | 9 | 0 |
26560 | 26560 | 2022-09-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3269 | 1 | 9 | 0 |
26558 | 26558 | 2022-09-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3268 | 1 | 9 | 0 |
26556 | 26556 | 2022-09-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3267 | 1 | 9 | 0 |
26553 | 26553 | 2022-08-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3259 | 1 | 9 | 0 |
26551 | 26551 | 2022-08-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3255 | 1 | 9 | 0 |
26542 | 26542 | 2022-08-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3242 | 1 | 9 | 0 |
26541 | 26541 | 2022-08-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3241 | 1 | 9 | 0 |
26539 | 26539 | 2022-08-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3238 | 1 | 9 | 0 |
26538 | 26538 | 2022-08-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3237 | 1 | 9 | 0 |
26531 | 26531 | 2022-08-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3219 | 1 | 9 | 0 |
26522 | 26522 | 2022-07-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3200 | 1 | 9 | 0 |
26520 | 26520 | 2022-07-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3196 | 1 | 9 | 0 |
26516 | 26516 | 2022-07-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3187 | 1 | 9 | 0 |
26515 | 26515 | 2022-07-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3186 | 1 | 9 | 0 |
26499 | 26499 | 2022-07-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3140 | 1 | 9 | 0 |
26498 | 26498 | 2022-07-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3139 | 1 | 9 | 0 |
26497 | 26497 | 2022-07-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3138 | 1 | 9 | 0 |
26494 | 26494 | 2022-07-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3135 | 1 | 9 | 0 |
26485 | 26485 | 2022-06-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3107 | 1 | 9 | 0 |
26475 | 26475 | 2022-06-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3043 | 1 | 9 | 0 |
26474 | 26474 | 2022-06-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3042 | 1 | 9 | 0 |
26473 | 26473 | 2022-06-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3041 | 1 | 9 | 0 |
26472 | 26472 | 2022-06-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3040 | 1 | 9 | 0 |
26471 | 26471 | 2022-06-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3039 | 1 | 9 | 0 |
26464 | 26464 | 2022-06-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2970 | 1 | 9 | 0 |
26461 | 26461 | 2022-05-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2964 | 1 | 9 | 0 |
26459 | 26459 | 2022-05-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2963 | 1 | 9 | 0 |
26455 | 26455 | 2022-05-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2938 | 1 | 9 | 0 |
26452 | 26452 | 2022-05-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2937 | 1 | 9 | 0 |
26450 | 26450 | 2022-05-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2927 | 1 | 9 | 0 |
26440 | 26440 | 2022-05-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2902 | 1 | 9 | 0 |
26436 | 26436 | 2022-05-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2901 | 1 | 9 | 0 |
26426 | 26426 | 2022-04-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2898 | 1 | 9 | 0 |
26422 | 26422 | 2022-04-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2897 | 1 | 9 | 0 |
26399 | 26399 | 2022-03-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2896 | 1 | 9 | 0 |
26384 | 26384 | 2022-03-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2872 | 1 | 9 | 0 |
26382 | 26382 | 2022-03-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2871 | 1 | 9 | 0 |
26379 | 26379 | 2022-03-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2852 | 1 | 9 | 0 |
26376 | 26376 | 2022-03-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2847 | 1 | 9 | 0 |
26375 | 26375 | 2022-03-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2846 | 1 | 9 | 0 |
26371 | 26371 | 2022-02-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2788 | 1 | 9 | 0 |
26368 | 26368 | 2022-02-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2779 | 1 | 9 | 0 |
26356 | 26356 | 2022-02-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2695 | 1 | 9 | 0 |
26355 | 26355 | 2022-02-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2694 | 1 | 9 | 0 |
26348 | 26348 | 2022-02-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 2642 | 1 | 9 | 0 |
26315 | 26315 | 2022-01-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1907 | 1 | 9 | 0 |
26313 | 26313 | 2022-01-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1906 | 1 | 9 | 0 |
26275 | 26275 | 2021-11-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1905 | 1 | 9 | 0 |
26264 | 26264 | 2021-11-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1904 | 1 | 9 | 0 |
26249 | 26249 | 2021-10-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1903 | 1 | 9 | 0 |
26246 | 26246 | 2021-10-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1902 | 1 | 9 | 0 |
26245 | 26245 | 2021-10-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1901 | 1 | 9 | 0 |
26240 | 26240 | 2021-10-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1900 | 1 | 9 | 0 |
26198 | 26198 | 2021-09-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1887 | 1 | 9 | 0 |
26191 | 26191 | 2021-09-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1886 | 1 | 9 | 0 |
26155 | 26155 | 2021-07-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1885 | 1 | 9 | 0 |
26127 | 26127 | 2021-06-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1884 | 1 | 9 | 0 |
26123 | 26123 | 2021-06-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1883 | 1 | 9 | 0 |
26119 | 26119 | 2021-06-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1882 | 1 | 9 | 0 |
26116 | 26116 | 2021-06-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1881 | 1 | 9 | 0 |
26114 | 26114 | 2021-06-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1880 | 1 | 9 | 0 |
26109 | 26109 | 2021-06-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1879 | 1 | 9 | 0 |
26100 | 26100 | 2021-06-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1863 | 1 | 9 | 0 |
26099 | 26099 | 2021-06-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1862 | 1 | 9 | 0 |
26092 | 26092 | 2021-05-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1858 | 1 | 9 | 0 |
26059 | 26059 | 2021-04-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1857 | 1 | 9 | 0 |
26022 | 26022 | 2021-03-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1856 | 1 | 9 | 0 |
26021 | 26021 | 2021-03-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1855 | 1 | 9 | 0 |
26016 | 26016 | 2021-03-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1854 | 1 | 8 | 0 |
26015 | 26015 | 2021-03-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1853 | 1 | 8 | 0 |
26007 | 26007 | 2021-03-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1852 | 1 | 8 | 0 |
26003 | 26003 | 2021-02-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1849 | 1 | 8 | 0 |
26000 | 26000 | 2021-02-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1848 | 1 | 8 | 0 |
25994 | 25994 | 2021-02-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 1841 | 1 | 8 | 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 );