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.
2,052 rows where city = "Delano" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, name, y, new_deaths, date (date)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25650 | 25650 | 2022-12-30 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1452 | 0 | 7 | 0 |
27702 | 27702 | 2022-12-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4261 | 0 | 5 | 0 |
25649 | 25649 | 2022-12-29 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1452 | 5 | 7 | 0 |
27701 | 27701 | 2022-12-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4261 | 2 | 5 | 0 |
25648 | 25648 | 2022-12-28 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1447 | 9 | 7 | 0 |
27700 | 27700 | 2022-12-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4259 | 17 | 5 | 0 |
25647 | 25647 | 2022-12-27 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1438 | 9 | 7 | 0 |
27699 | 27699 | 2022-12-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4242 | 6 | 5 | 0 |
25646 | 25646 | 2022-12-26 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1429 | 4 | 7 | 0 |
27698 | 27698 | 2022-12-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4236 | 1 | 5 | 0 |
25645 | 25645 | 2022-12-25 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1425 | 4 | 7 | 0 |
27697 | 27697 | 2022-12-25 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4235 | 1 | 5 | 0 |
25644 | 25644 | 2022-12-24 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1421 | 3 | 7 | 0 |
27696 | 27696 | 2022-12-24 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4234 | 1 | 5 | 0 |
25643 | 25643 | 2022-12-23 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1418 | 3 | 7 | 0 |
27695 | 27695 | 2022-12-23 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4233 | 4 | 5 | 0 |
25642 | 25642 | 2022-12-22 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1415 | 8 | 7 | 0 |
27694 | 27694 | 2022-12-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4229 | 5 | 5 | 0 |
25641 | 25641 | 2022-12-21 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1407 | 7 | 7 | 0 |
27693 | 27693 | 2022-12-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4224 | 7 | 5 | 0 |
25640 | 25640 | 2022-12-20 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1400 | 5 | 7 | 0 |
27692 | 27692 | 2022-12-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4217 | 6 | 5 | 0 |
25639 | 25639 | 2022-12-19 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1395 | 12 | 7 | 0 |
27691 | 27691 | 2022-12-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4211 | 8 | 5 | 0 |
25638 | 25638 | 2022-12-18 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1383 | 6 | 7 | 0 |
27690 | 27690 | 2022-12-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4203 | 0 | 5 | 0 |
25637 | 25637 | 2022-12-17 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1377 | 5 | 7 | 0 |
27689 | 27689 | 2022-12-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4203 | 29 | 5 | 0 |
25636 | 25636 | 2022-12-16 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1372 | 6 | 7 | 0 |
27688 | 27688 | 2022-12-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4174 | 27 | 5 | 0 |
25635 | 25635 | 2022-12-15 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1366 | 5 | 7 | 0 |
27687 | 27687 | 2022-12-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4147 | 4 | 5 | 0 |
25634 | 25634 | 2022-12-14 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1361 | 2 | 7 | 0 |
27686 | 27686 | 2022-12-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4143 | 18 | 5 | 0 |
25633 | 25633 | 2022-12-13 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1359 | 9 | 7 | 0 |
27685 | 27685 | 2022-12-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4125 | 34 | 5 | 0 |
25632 | 25632 | 2022-12-12 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1350 | 3 | 7 | 0 |
27684 | 27684 | 2022-12-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4091 | 36 | 5 | 0 |
25631 | 25631 | 2022-12-11 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1347 | 0 | 7 | 0 |
27683 | 27683 | 2022-12-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4055 | 0 | 5 | 0 |
25630 | 25630 | 2022-12-10 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1347 | 2 | 7 | 0 |
27682 | 27682 | 2022-12-10 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4055 | 13 | 5 | 0 |
25629 | 25629 | 2022-12-09 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1345 | 1 | 7 | 0 |
27681 | 27681 | 2022-12-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4042 | 3 | 5 | 0 |
25628 | 25628 | 2022-12-08 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1344 | 4 | 7 | 0 |
27680 | 27680 | 2022-12-08 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4039 | 11 | 5 | 0 |
25627 | 25627 | 2022-12-07 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1340 | 1 | 7 | 0 |
27679 | 27679 | 2022-12-07 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4028 | 10 | 5 | 0 |
25626 | 25626 | 2022-12-06 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1339 | 4 | 7 | 0 |
27678 | 27678 | 2022-12-06 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4018 | 36 | 5 | 0 |
25625 | 25625 | 2022-12-05 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1335 | 4 | 7 | 0 |
27677 | 27677 | 2022-12-05 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3982 | 4 | 5 | 0 |
25624 | 25624 | 2022-12-04 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1331 | 2 | 7 | 0 |
27676 | 27676 | 2022-12-04 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3978 | 0 | 5 | 0 |
25623 | 25623 | 2022-12-03 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1329 | 1 | 7 | 0 |
27675 | 27675 | 2022-12-03 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3978 | 15 | 5 | 0 |
25622 | 25622 | 2022-12-02 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1328 | 0 | 7 | 0 |
27674 | 27674 | 2022-12-02 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3963 | 6 | 5 | 0 |
25621 | 25621 | 2022-12-01 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1328 | 2 | 7 | 0 |
27673 | 27673 | 2022-12-01 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3957 | 1 | 5 | 0 |
25620 | 25620 | 2022-11-30 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1326 | 3 | 7 | 0 |
27672 | 27672 | 2022-11-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3956 | 1 | 5 | 0 |
25619 | 25619 | 2022-11-29 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1323 | 7 | 7 | 0 |
27671 | 27671 | 2022-11-29 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3955 | 42 | 5 | 0 |
25618 | 25618 | 2022-11-28 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1316 | 2 | 7 | 0 |
27670 | 27670 | 2022-11-28 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3913 | 10 | 5 | 0 |
25617 | 25617 | 2022-11-27 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1314 | 0 | 7 | 0 |
27669 | 27669 | 2022-11-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3903 | 0 | 5 | 0 |
25616 | 25616 | 2022-11-26 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1314 | 0 | 7 | 0 |
27668 | 27668 | 2022-11-26 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3903 | 2 | 5 | 0 |
25615 | 25615 | 2022-11-25 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1314 | 0 | 7 | 0 |
27667 | 27667 | 2022-11-25 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3901 | 0 | 5 | 0 |
25614 | 25614 | 2022-11-24 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1314 | 3 | 7 | 0 |
27666 | 27666 | 2022-11-24 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3901 | 0 | 5 | 0 |
25613 | 25613 | 2022-11-23 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1311 | 2 | 7 | 0 |
27665 | 27665 | 2022-11-23 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3901 | 3 | 5 | 0 |
25612 | 25612 | 2022-11-22 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1309 | 3 | 7 | 0 |
27664 | 27664 | 2022-11-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3898 | 9 | 5 | 0 |
25611 | 25611 | 2022-11-21 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1306 | 2 | 7 | 0 |
27663 | 27663 | 2022-11-21 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3889 | 1 | 5 | 0 |
25610 | 25610 | 2022-11-20 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1304 | 1 | 7 | 0 |
27662 | 27662 | 2022-11-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3888 | 0 | 5 | 0 |
25609 | 25609 | 2022-11-19 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1303 | 3 | 7 | 0 |
27661 | 27661 | 2022-11-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3888 | 0 | 5 | 0 |
25608 | 25608 | 2022-11-18 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1300 | 4 | 7 | 0 |
27660 | 27660 | 2022-11-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3888 | 0 | 5 | 0 |
25607 | 25607 | 2022-11-17 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1296 | 0 | 7 | 0 |
27659 | 27659 | 2022-11-17 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3888 | 2 | 5 | 0 |
25606 | 25606 | 2022-11-16 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1296 | 5 | 7 | 0 |
27658 | 27658 | 2022-11-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3886 | 0 | 5 | 0 |
25605 | 25605 | 2022-11-15 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1291 | 1 | 7 | 0 |
27657 | 27657 | 2022-11-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3886 | 0 | 5 | 0 |
25604 | 25604 | 2022-11-14 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1290 | 3 | 7 | 0 |
27656 | 27656 | 2022-11-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3886 | 1 | 5 | 0 |
25603 | 25603 | 2022-11-13 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1287 | 0 | 7 | 0 |
27655 | 27655 | 2022-11-13 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3885 | 0 | 5 | 0 |
25602 | 25602 | 2022-11-12 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1287 | 0 | 7 | 0 |
27654 | 27654 | 2022-11-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3885 | 1 | 5 | 0 |
25601 | 25601 | 2022-11-11 | KVSP | Kern Valley State Prison | Delano | Kern | 29 | 93215 | -119.3220574 | 35.7656527 | 1287 | 0 | 7 | 0 |
27653 | 27653 | 2022-11-11 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3884 | 0 | 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 );