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.
21 rows where name = "North Kern State Prison" and new_confirmed_cases = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26839 | 26839 | 2020-08-19 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 16 | 5 | 0 | 0 |
26840 | 26840 | 2020-08-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 21 | 5 | 0 | 0 |
26930 | 26930 | 2020-11-18 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 94 | 5 | 0 | 0 |
26956 | 26956 | 2020-12-14 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 317 | 5 | 0 | 0 |
26958 | 26958 | 2020-12-16 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 363 | 5 | 0 | 0 |
27146 | 27146 | 2021-06-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 941 | 5 | 4 | 0 |
27225 | 27225 | 2021-09-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 971 | 5 | 5 | 0 |
27228 | 27228 | 2021-09-12 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 1000 | 5 | 5 | 0 |
27236 | 27236 | 2021-09-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 1046 | 5 | 5 | 0 |
27243 | 27243 | 2021-09-27 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 1134 | 5 | 5 | 0 |
27251 | 27251 | 2021-10-05 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 1215 | 5 | 5 | 0 |
27467 | 27467 | 2022-05-09 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2818 | 5 | 5 | 0 |
27491 | 27491 | 2022-06-02 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2839 | 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 |
27524 | 27524 | 2022-07-05 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 2982 | 5 | 5 | 0 |
27539 | 27539 | 2022-07-20 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3385 | 5 | 5 | 0 |
27549 | 27549 | 2022-07-30 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3528 | 5 | 5 | 0 |
27554 | 27554 | 2022-08-04 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3591 | 5 | 5 | 0 |
27565 | 27565 | 2022-08-15 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3700 | 5 | 5 | 0 |
27587 | 27587 | 2022-09-06 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 3802 | 5 | 5 | 0 |
27694 | 27694 | 2022-12-22 | NKSP | North Kern State Prison | Delano | Kern | 29 | 93215 | -119.3060685 | 35.7813675 | 4229 | 5 | 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 );