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.
19 rows where name = "California Men's Colony" and new_confirmed_cases = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8259 | 8259 | 2020-04-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 11 | 3 | 0 | 0 |
8352 | 8352 | 2020-07-31 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 16 | 3 | 0 | 0 |
8366 | 8366 | 2020-08-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 224 | 3 | 0 | 0 |
8372 | 8372 | 2020-08-20 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 244 | 3 | 1 | 0 |
8385 | 8385 | 2020-09-02 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 274 | 3 | 2 | 0 |
8506 | 8506 | 2021-01-01 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 1153 | 3 | 4 | 0 |
8886 | 8886 | 2022-01-16 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 2603 | 3 | 13 | 0 |
8914 | 8914 | 2022-02-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3065 | 3 | 13 | 0 |
8936 | 8936 | 2022-03-07 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3231 | 3 | 13 | 0 |
8937 | 8937 | 2022-03-08 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3234 | 3 | 13 | 0 |
9007 | 9007 | 2022-05-17 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3257 | 3 | 13 | 0 |
9014 | 9014 | 2022-05-24 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3323 | 3 | 13 | 0 |
9016 | 9016 | 2022-05-26 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3330 | 3 | 13 | 0 |
9017 | 9017 | 2022-05-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3333 | 3 | 13 | 0 |
9030 | 9030 | 2022-06-09 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3422 | 3 | 13 | 0 |
9050 | 9050 | 2022-06-29 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3476 | 3 | 13 | 0 |
9064 | 9064 | 2022-07-13 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3634 | 3 | 13 | 0 |
9218 | 9218 | 2022-12-14 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3709 | 3 | 13 | 0 |
9231 | 9231 | 2022-12-27 | CMC | California Men's Colony | San Luis Obispo | San Luis Obispo | 79 | 93401 | -120.682159 | 35.2445252 | 3717 | 3 | 13 | 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 );