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 = "Mule Creek State Prison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, deaths, new_deaths
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26676 | 26676 | 2022-12-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3354 | 0 | 9 | 0 |
26675 | 26675 | 2022-12-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3354 | 1 | 9 | 0 |
26674 | 26674 | 2022-12-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3353 | 5 | 9 | 0 |
26673 | 26673 | 2022-12-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3348 | 2 | 9 | 0 |
26672 | 26672 | 2022-12-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3346 | 4 | 9 | 0 |
26671 | 26671 | 2022-12-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3342 | 0 | 9 | 0 |
26670 | 26670 | 2022-12-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3342 | 1 | 9 | 0 |
26669 | 26669 | 2022-12-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3341 | 2 | 9 | 0 |
26668 | 26668 | 2022-12-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3339 | 0 | 9 | 0 |
26667 | 26667 | 2022-12-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3339 | 4 | 9 | 0 |
26666 | 26666 | 2022-12-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3335 | 7 | 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 |
26663 | 26663 | 2022-12-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3326 | 0 | 9 | 0 |
26662 | 26662 | 2022-12-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3326 | 2 | 9 | 0 |
26661 | 26661 | 2022-12-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3324 | 0 | 9 | 0 |
26660 | 26660 | 2022-12-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3324 | 2 | 9 | 0 |
26659 | 26659 | 2022-12-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3322 | 3 | 9 | 0 |
26658 | 26658 | 2022-12-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3319 | 0 | 9 | 0 |
26657 | 26657 | 2022-12-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3319 | 1 | 9 | 0 |
26656 | 26656 | 2022-12-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3318 | 0 | 9 | 0 |
26655 | 26655 | 2022-12-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3318 | 0 | 9 | 0 |
26654 | 26654 | 2022-12-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3318 | 2 | 9 | 0 |
26653 | 26653 | 2022-12-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3316 | 0 | 9 | 0 |
26652 | 26652 | 2022-12-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3316 | 3 | 9 | 0 |
26651 | 26651 | 2022-12-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3313 | 1 | 9 | 0 |
26650 | 26650 | 2022-12-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 0 | 9 | 0 |
26649 | 26649 | 2022-12-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 0 | 9 | 0 |
26648 | 26648 | 2022-12-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 0 | 9 | 0 |
26647 | 26647 | 2022-12-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 0 | 9 | 0 |
26646 | 26646 | 2022-11-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 0 | 9 | 0 |
26645 | 26645 | 2022-11-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3312 | 2 | 9 | 0 |
26644 | 26644 | 2022-11-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 0 | 9 | 0 |
26643 | 26643 | 2022-11-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 0 | 9 | 0 |
26642 | 26642 | 2022-11-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 0 | 9 | 0 |
26641 | 26641 | 2022-11-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 0 | 9 | 0 |
26640 | 26640 | 2022-11-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 0 | 9 | 0 |
26639 | 26639 | 2022-11-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 0 | 9 | 0 |
26638 | 26638 | 2022-11-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3310 | 1 | 9 | 0 |
26637 | 26637 | 2022-11-21 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3309 | 0 | 9 | 0 |
26636 | 26636 | 2022-11-20 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3309 | 0 | 9 | 0 |
26635 | 26635 | 2022-11-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3309 | 0 | 9 | 0 |
26634 | 26634 | 2022-11-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3309 | 0 | 9 | 0 |
26633 | 26633 | 2022-11-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3309 | 1 | 9 | 0 |
26632 | 26632 | 2022-11-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26631 | 26631 | 2022-11-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26630 | 26630 | 2022-11-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26629 | 26629 | 2022-11-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26628 | 26628 | 2022-11-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26627 | 26627 | 2022-11-11 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26626 | 26626 | 2022-11-10 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26625 | 26625 | 2022-11-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 0 | 9 | 0 |
26624 | 26624 | 2022-11-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3308 | 2 | 9 | 0 |
26623 | 26623 | 2022-11-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3306 | 1 | 9 | 0 |
26622 | 26622 | 2022-11-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 0 | 9 | 0 |
26621 | 26621 | 2022-11-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 0 | 9 | 0 |
26620 | 26620 | 2022-11-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 0 | 9 | 0 |
26619 | 26619 | 2022-11-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 0 | 9 | 0 |
26618 | 26618 | 2022-11-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 0 | 9 | 0 |
26617 | 26617 | 2022-11-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3305 | 1 | 9 | 0 |
26616 | 26616 | 2022-10-31 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3304 | 0 | 9 | 0 |
26615 | 26615 | 2022-10-30 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3304 | 0 | 9 | 0 |
26614 | 26614 | 2022-10-29 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3304 | 1 | 9 | 0 |
26613 | 26613 | 2022-10-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 9 | 0 |
26612 | 26612 | 2022-10-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 9 | 0 |
26611 | 26611 | 2022-10-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 9 | 0 |
26610 | 26610 | 2022-10-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 9 | 0 |
26609 | 26609 | 2022-10-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 9 | 0 |
26608 | 26608 | 2022-10-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 9 | 0 |
26607 | 26607 | 2022-10-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3303 | 0 | 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 |
26604 | 26604 | 2022-10-19 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3301 | 0 | 9 | 0 |
26603 | 26603 | 2022-10-18 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3301 | 2 | 9 | 0 |
26602 | 26602 | 2022-10-17 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 0 | 9 | 0 |
26601 | 26601 | 2022-10-16 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 0 | 9 | 0 |
26600 | 26600 | 2022-10-15 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 0 | 9 | 0 |
26599 | 26599 | 2022-10-14 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 0 | 9 | 0 |
26598 | 26598 | 2022-10-13 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 0 | 9 | 0 |
26597 | 26597 | 2022-10-12 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3299 | 0 | 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 |
26594 | 26594 | 2022-10-09 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3297 | 0 | 9 | 0 |
26593 | 26593 | 2022-10-08 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3297 | 0 | 9 | 0 |
26592 | 26592 | 2022-10-07 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3297 | 0 | 9 | 0 |
26591 | 26591 | 2022-10-06 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3297 | 0 | 9 | 0 |
26590 | 26590 | 2022-10-05 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3297 | 1 | 9 | 0 |
26589 | 26589 | 2022-10-04 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3296 | 0 | 9 | 0 |
26588 | 26588 | 2022-10-03 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3296 | 0 | 9 | 0 |
26587 | 26587 | 2022-10-02 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3296 | 0 | 9 | 0 |
26586 | 26586 | 2022-10-01 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3296 | 0 | 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 |
26583 | 26583 | 2022-09-28 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3294 | 0 | 9 | 0 |
26582 | 26582 | 2022-09-27 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3294 | 0 | 9 | 0 |
26581 | 26581 | 2022-09-26 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3294 | 2 | 9 | 0 |
26580 | 26580 | 2022-09-25 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3292 | 0 | 9 | 0 |
26579 | 26579 | 2022-09-24 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3292 | 2 | 9 | 0 |
26578 | 26578 | 2022-09-23 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3290 | 0 | 9 | 0 |
26577 | 26577 | 2022-09-22 | MCSP | Mule Creek State Prison | Ione | Amador | 5 | 95640 | -120.9594405 | 38.3686728 | 3290 | 1 | 9 | 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 );