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.
32 rows where name = "Correctional Training Facility" and new_confirmed_cases = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19636 | 19636 | 2020-07-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2 | 2 | 0 | 0 |
19671 | 19671 | 2020-09-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 103 | 2 | 1 | 0 |
19703 | 19703 | 2020-10-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 162 | 2 | 1 | 0 |
19719 | 19719 | 2020-10-20 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 194 | 2 | 1 | 0 |
19722 | 19722 | 2020-10-23 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 196 | 2 | 1 | 0 |
19728 | 19728 | 2020-10-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 228 | 2 | 1 | 0 |
19732 | 19732 | 2020-11-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 257 | 2 | 1 | 0 |
19786 | 19786 | 2020-12-26 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2150 | 2 | 9 | 0 |
19795 | 19795 | 2021-01-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2363 | 2 | 13 | 1 |
19801 | 19801 | 2021-01-10 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2488 | 2 | 17 | 0 |
19802 | 19802 | 2021-01-11 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2490 | 2 | 17 | 0 |
19821 | 19821 | 2021-01-30 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2711 | 2 | 19 | 0 |
19830 | 19830 | 2021-02-08 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2723 | 2 | 20 | 0 |
19907 | 19907 | 2021-04-26 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2732 | 2 | 21 | 0 |
20163 | 20163 | 2022-01-07 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2743 | 2 | 21 | 0 |
20166 | 20166 | 2022-01-10 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2746 | 2 | 21 | 0 |
20184 | 20184 | 2022-01-28 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2885 | 2 | 21 | 0 |
20191 | 20191 | 2022-02-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 2972 | 2 | 21 | 0 |
20229 | 20229 | 2022-03-14 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3360 | 2 | 21 | 0 |
20233 | 20233 | 2022-03-18 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3363 | 2 | 21 | 0 |
20332 | 20332 | 2022-06-25 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3376 | 2 | 21 | 0 |
20341 | 20341 | 2022-07-04 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3382 | 2 | 21 | 0 |
20357 | 20357 | 2022-07-20 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3391 | 2 | 21 | 0 |
20366 | 20366 | 2022-07-29 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3412 | 2 | 21 | 0 |
20374 | 20374 | 2022-08-06 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3436 | 2 | 21 | 0 |
20382 | 20382 | 2022-08-14 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3478 | 2 | 21 | 0 |
20386 | 20386 | 2022-08-18 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3512 | 2 | 21 | 0 |
20392 | 20392 | 2022-08-24 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3536 | 2 | 21 | 0 |
20398 | 20398 | 2022-08-30 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3553 | 2 | 21 | 0 |
20400 | 20400 | 2022-09-01 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3555 | 2 | 21 | 0 |
20401 | 20401 | 2022-09-02 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3557 | 2 | 21 | 0 |
20406 | 20406 | 2022-09-07 | CTF | Correctional Training Facility | Soledad | Monterey | 53 | 93960 | -121.3193189 | 36.4093667 | 3564 | 2 | 21 | 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 );