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.
30 rows where name = "California State Prison, Solano" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14627 | 14627 | 2020-11-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 31 | 2 | 0 | 0 |
14632 | 14632 | 2020-12-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 43 | 2 | 0 | 0 |
14634 | 14634 | 2020-12-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 56 | 2 | 0 | 0 |
14636 | 14636 | 2020-12-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 59 | 2 | 0 | 0 |
14639 | 14639 | 2020-12-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 122 | 2 | 0 | 0 |
14664 | 14664 | 2021-01-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 662 | 2 | 1 | 0 |
14695 | 14695 | 2021-02-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1135 | 2 | 4 | 1 |
14701 | 14701 | 2021-02-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1143 | 2 | 5 | 1 |
14806 | 14806 | 2021-05-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1162 | 2 | 6 | 0 |
14871 | 14871 | 2021-07-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1248 | 2 | 6 | 0 |
14882 | 14882 | 2021-08-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1262 | 2 | 6 | 0 |
14883 | 14883 | 2021-08-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1264 | 2 | 6 | 0 |
14891 | 14891 | 2021-08-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1267 | 2 | 6 | 0 |
14905 | 14905 | 2021-09-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1277 | 2 | 6 | 0 |
14926 | 14926 | 2021-09-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1338 | 2 | 6 | 0 |
14970 | 14970 | 2021-11-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1344 | 2 | 7 | 0 |
14990 | 14990 | 2021-11-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1386 | 2 | 7 | 0 |
14997 | 14997 | 2021-12-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1394 | 2 | 7 | 0 |
15008 | 15008 | 2021-12-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1396 | 2 | 7 | 0 |
15036 | 15036 | 2022-01-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1406 | 2 | 7 | 0 |
15037 | 15037 | 2022-01-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1408 | 2 | 7 | 0 |
15041 | 15041 | 2022-01-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1419 | 2 | 7 | 0 |
15049 | 15049 | 2022-01-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1530 | 2 | 7 | 0 |
15064 | 15064 | 2022-02-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1738 | 2 | 7 | 0 |
15181 | 15181 | 2022-06-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1817 | 2 | 7 | 0 |
15205 | 15205 | 2022-06-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2013 | 2 | 7 | 0 |
15206 | 15206 | 2022-06-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2015 | 2 | 7 | 0 |
15331 | 15331 | 2022-11-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 2 | 7 | 0 |
15374 | 15374 | 2022-12-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2052 | 2 | 7 | 0 |
15379 | 15379 | 2022-12-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2055 | 2 | 7 | 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 );