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 = "North Kern State Prison" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27602 | 27602 | 2022-09-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3826 | 3 | 5 | 0 |
27601 | 27601 | 2022-09-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3823 | 0 | 5 | 0 |
27600 | 27600 | 2022-09-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3823 | 0 | 5 | 0 |
27599 | 27599 | 2022-09-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3823 | 0 | 5 | 0 |
27598 | 27598 | 2022-09-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3823 | 0 | 5 | 0 |
27597 | 27597 | 2022-09-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3823 | 0 | 5 | 0 |
27596 | 27596 | 2022-09-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3823 | 1 | 5 | 0 |
27595 | 27595 | 2022-09-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3822 | 8 | 5 | 0 |
27594 | 27594 | 2022-09-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3814 | 4 | 5 | 0 |
27593 | 27593 | 2022-09-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3810 | 4 | 5 | 0 |
27592 | 27592 | 2022-09-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3806 | 0 | 5 | 0 |
27591 | 27591 | 2022-09-10 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3806 | 0 | 5 | 0 |
27590 | 27590 | 2022-09-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3806 | 1 | 5 | 0 |
27589 | 27589 | 2022-09-08 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3805 | 2 | 5 | 0 |
27588 | 27588 | 2022-09-07 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3803 | 1 | 5 | 0 |
27587 | 27587 | 2022-09-06 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3802 | 5 | 5 | 0 |
27586 | 27586 | 2022-09-05 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3797 | 1 | 5 | 0 |
27585 | 27585 | 2022-09-04 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3796 | 0 | 5 | 0 |
27584 | 27584 | 2022-09-03 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3796 | 1 | 5 | 0 |
27583 | 27583 | 2022-09-02 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3795 | 1 | 5 | 0 |
27582 | 27582 | 2022-09-01 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3794 | 2 | 5 | 0 |
27581 | 27581 | 2022-08-31 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3792 | 3 | 5 | 0 |
27580 | 27580 | 2022-08-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3789 | 9 | 5 | 0 |
27579 | 27579 | 2022-08-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3780 | 4 | 5 | 0 |
27578 | 27578 | 2022-08-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3776 | 0 | 5 | 0 |
27577 | 27577 | 2022-08-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3776 | 6 | 5 | 0 |
27576 | 27576 | 2022-08-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3770 | 4 | 5 | 0 |
27575 | 27575 | 2022-08-25 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3766 | 16 | 5 | 0 |
27574 | 27574 | 2022-08-24 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3750 | 4 | 5 | 0 |
27573 | 27573 | 2022-08-23 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3746 | 4 | 5 | 0 |
27572 | 27572 | 2022-08-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3742 | 21 | 5 | 0 |
27571 | 27571 | 2022-08-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3721 | 0 | 5 | 0 |
27570 | 27570 | 2022-08-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3721 | 2 | 5 | 0 |
27569 | 27569 | 2022-08-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3719 | 10 | 5 | 0 |
27568 | 27568 | 2022-08-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3709 | 0 | 5 | 0 |
27567 | 27567 | 2022-08-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3709 | 2 | 5 | 0 |
27566 | 27566 | 2022-08-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3707 | 7 | 5 | 0 |
27565 | 27565 | 2022-08-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3700 | 5 | 5 | 0 |
27564 | 27564 | 2022-08-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3695 | 1 | 5 | 0 |
27563 | 27563 | 2022-08-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3694 | 1 | 5 | 0 |
27562 | 27562 | 2022-08-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3693 | 17 | 5 | 0 |
27561 | 27561 | 2022-08-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3676 | 1 | 5 | 0 |
27560 | 27560 | 2022-08-10 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3675 | 1 | 5 | 0 |
27559 | 27559 | 2022-08-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3674 | 62 | 5 | 0 |
27558 | 27558 | 2022-08-08 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3612 | 3 | 5 | 0 |
27557 | 27557 | 2022-08-07 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3609 | 3 | 5 | 0 |
27556 | 27556 | 2022-08-06 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3606 | 2 | 5 | 0 |
27555 | 27555 | 2022-08-05 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3604 | 13 | 5 | 0 |
27554 | 27554 | 2022-08-04 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3591 | 5 | 5 | 0 |
27553 | 27553 | 2022-08-03 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3586 | 15 | 5 | 0 |
27552 | 27552 | 2022-08-02 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3571 | 33 | 5 | 0 |
27551 | 27551 | 2022-08-01 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3538 | 10 | 5 | 0 |
27550 | 27550 | 2022-07-31 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3528 | 0 | 5 | 0 |
27549 | 27549 | 2022-07-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3528 | 5 | 5 | 0 |
27548 | 27548 | 2022-07-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3523 | 6 | 5 | 0 |
27547 | 27547 | 2022-07-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3517 | 2 | 5 | 0 |
27546 | 27546 | 2022-07-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3515 | 53 | 5 | 0 |
27545 | 27545 | 2022-07-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3462 | 6 | 5 | 0 |
27544 | 27544 | 2022-07-25 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3456 | 19 | 5 | 0 |
27543 | 27543 | 2022-07-24 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3437 | 1 | 5 | 0 |
27542 | 27542 | 2022-07-23 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3436 | 6 | 5 | 0 |
27541 | 27541 | 2022-07-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3430 | 4 | 5 | 0 |
27540 | 27540 | 2022-07-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3426 | 41 | 5 | 0 |
27539 | 27539 | 2022-07-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3385 | 5 | 5 | 0 |
27538 | 27538 | 2022-07-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3380 | 36 | 5 | 0 |
27537 | 27537 | 2022-07-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3344 | 99 | 5 | 0 |
27536 | 27536 | 2022-07-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3245 | 2 | 5 | 0 |
27535 | 27535 | 2022-07-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3243 | 4 | 5 | 0 |
27534 | 27534 | 2022-07-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3239 | 7 | 5 | 0 |
27533 | 27533 | 2022-07-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3232 | 70 | 5 | 0 |
27532 | 27532 | 2022-07-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3162 | 4 | 5 | 0 |
27531 | 27531 | 2022-07-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3158 | 3 | 5 | 0 |
27530 | 27530 | 2022-07-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3155 | 101 | 5 | 0 |
27529 | 27529 | 2022-07-10 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3054 | 0 | 5 | 0 |
27528 | 27528 | 2022-07-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3054 | 17 | 5 | 0 |
27527 | 27527 | 2022-07-08 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3037 | 2 | 5 | 0 |
27526 | 27526 | 2022-07-07 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3035 | 2 | 5 | 0 |
27525 | 27525 | 2022-07-06 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3033 | 51 | 5 | 0 |
27524 | 27524 | 2022-07-05 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2982 | 5 | 5 | 0 |
27523 | 27523 | 2022-07-04 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2977 | 5 | 5 | 0 |
27522 | 27522 | 2022-07-03 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2972 | 0 | 5 | 0 |
27521 | 27521 | 2022-07-02 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2972 | 0 | 5 | 0 |
27520 | 27520 | 2022-07-01 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2972 | 47 | 5 | 0 |
27519 | 27519 | 2022-06-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2925 | 2 | 5 | 0 |
27518 | 27518 | 2022-06-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2923 | 2 | 5 | 0 |
27517 | 27517 | 2022-06-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2921 | 7 | 5 | 0 |
27516 | 27516 | 2022-06-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2914 | 2 | 5 | 0 |
27515 | 27515 | 2022-06-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2912 | 0 | 5 | 0 |
27514 | 27514 | 2022-06-25 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2912 | 0 | 5 | 0 |
27513 | 27513 | 2022-06-24 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2912 | 1 | 5 | 0 |
27512 | 27512 | 2022-06-23 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2911 | 2 | 5 | 0 |
27511 | 27511 | 2022-06-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2909 | 3 | 5 | 0 |
27510 | 27510 | 2022-06-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2906 | 1 | 5 | 0 |
27509 | 27509 | 2022-06-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2905 | 12 | 5 | 0 |
27508 | 27508 | 2022-06-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2893 | 0 | 5 | 0 |
27507 | 27507 | 2022-06-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2893 | 1 | 5 | 0 |
27506 | 27506 | 2022-06-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2892 | 2 | 5 | 0 |
27505 | 27505 | 2022-06-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2890 | 1 | 5 | 0 |
27504 | 27504 | 2022-06-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2889 | 2 | 5 | 0 |
27503 | 27503 | 2022-06-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2887 | 1 | 5 | 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 );