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.
93 rows where name = "California State Prison, Solano" and new_confirmed_cases = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14455 | 14455 | 2020-06-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 1 | 0 | 0 |
14485 | 14485 | 2020-07-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2 | 1 | 0 | 0 |
14539 | 14539 | 2020-08-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 3 | 1 | 0 | 0 |
14563 | 14563 | 2020-09-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 4 | 1 | 0 | 0 |
14605 | 14605 | 2020-11-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 5 | 1 | 0 | 0 |
14614 | 14614 | 2020-11-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 15 | 1 | 0 | 0 |
14619 | 14619 | 2020-11-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 16 | 1 | 0 | 0 |
14620 | 14620 | 2020-11-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 17 | 1 | 0 | 0 |
14622 | 14622 | 2020-11-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 18 | 1 | 0 | 0 |
14624 | 14624 | 2020-11-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 23 | 1 | 0 | 0 |
14635 | 14635 | 2020-12-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 57 | 1 | 0 | 0 |
14642 | 14642 | 2020-12-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 165 | 1 | 0 | 0 |
14691 | 14691 | 2021-01-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1123 | 1 | 3 | 0 |
14698 | 14698 | 2021-02-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1140 | 1 | 4 | 0 |
14700 | 14700 | 2021-02-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1141 | 1 | 4 | 0 |
14705 | 14705 | 2021-02-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1149 | 1 | 5 | 0 |
14707 | 14707 | 2021-02-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1150 | 1 | 5 | 0 |
14736 | 14736 | 2021-03-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1151 | 1 | 5 | 0 |
14746 | 14746 | 2021-03-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1152 | 1 | 5 | 0 |
14779 | 14779 | 2021-04-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1153 | 1 | 6 | 0 |
14810 | 14810 | 2021-05-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1210 | 1 | 6 | 0 |
14812 | 14812 | 2021-05-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1211 | 1 | 6 | 0 |
14877 | 14877 | 2021-08-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1254 | 1 | 6 | 0 |
14880 | 14880 | 2021-08-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1260 | 1 | 6 | 0 |
14889 | 14889 | 2021-08-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1265 | 1 | 6 | 0 |
14892 | 14892 | 2021-08-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1268 | 1 | 6 | 0 |
14893 | 14893 | 2021-08-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1269 | 1 | 6 | 0 |
14899 | 14899 | 2021-08-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1273 | 1 | 6 | 0 |
14901 | 14901 | 2021-08-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1274 | 1 | 6 | 0 |
14904 | 14904 | 2021-08-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1275 | 1 | 6 | 0 |
14909 | 14909 | 2021-09-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1289 | 1 | 6 | 0 |
14912 | 14912 | 2021-09-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1301 | 1 | 6 | 0 |
14916 | 14916 | 2021-09-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1327 | 1 | 6 | 0 |
14920 | 14920 | 2021-09-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1334 | 1 | 6 | 0 |
14921 | 14921 | 2021-09-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1335 | 1 | 6 | 0 |
14924 | 14924 | 2021-09-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1336 | 1 | 6 | 0 |
14929 | 14929 | 2021-09-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1339 | 1 | 6 | 0 |
14960 | 14960 | 2021-10-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1340 | 1 | 7 | 0 |
14962 | 14962 | 2021-10-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1341 | 1 | 7 | 0 |
14967 | 14967 | 2021-11-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1342 | 1 | 7 | 0 |
14971 | 14971 | 2021-11-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1345 | 1 | 7 | 0 |
14975 | 14975 | 2021-11-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1354 | 1 | 7 | 0 |
14983 | 14983 | 2021-11-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1375 | 1 | 7 | 0 |
14985 | 14985 | 2021-11-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1379 | 1 | 7 | 0 |
14989 | 14989 | 2021-11-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1384 | 1 | 7 | 0 |
14991 | 14991 | 2021-11-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1387 | 1 | 7 | 0 |
14993 | 14993 | 2021-11-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1388 | 1 | 7 | 0 |
15012 | 15012 | 2021-12-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1397 | 1 | 7 | 0 |
15019 | 15019 | 2021-12-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1398 | 1 | 7 | 0 |
15026 | 15026 | 2021-12-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1399 | 1 | 7 | 0 |
15030 | 15030 | 2022-01-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1400 | 1 | 7 | 0 |
15031 | 15031 | 2022-01-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1401 | 1 | 7 | 0 |
15040 | 15040 | 2022-01-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1417 | 1 | 7 | 0 |
15043 | 15043 | 2022-01-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1420 | 1 | 7 | 0 |
15048 | 15048 | 2022-01-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1528 | 1 | 7 | 0 |
15055 | 15055 | 2022-01-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1688 | 1 | 7 | 0 |
15056 | 15056 | 2022-01-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1689 | 1 | 7 | 0 |
15057 | 15057 | 2022-01-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1690 | 1 | 7 | 0 |
15068 | 15068 | 2022-02-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1743 | 1 | 7 | 0 |
15071 | 15071 | 2022-02-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1744 | 1 | 7 | 0 |
15075 | 15075 | 2022-02-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1756 | 1 | 7 | 0 |
15076 | 15076 | 2022-02-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1757 | 1 | 7 | 0 |
15082 | 15082 | 2022-02-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1765 | 1 | 7 | 0 |
15092 | 15092 | 2022-03-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1769 | 1 | 7 | 0 |
15093 | 15093 | 2022-03-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1770 | 1 | 7 | 0 |
15098 | 15098 | 2022-03-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1771 | 1 | 7 | 0 |
15106 | 15106 | 2022-03-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1775 | 1 | 7 | 0 |
15123 | 15123 | 2022-04-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1776 | 1 | 7 | 0 |
15153 | 15153 | 2022-05-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1777 | 1 | 7 | 0 |
15157 | 15157 | 2022-05-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1778 | 1 | 7 | 0 |
15170 | 15170 | 2022-05-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1779 | 1 | 7 | 0 |
15175 | 15175 | 2022-05-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1784 | 1 | 7 | 0 |
15203 | 15203 | 2022-06-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2007 | 1 | 7 | 0 |
15210 | 15210 | 2022-07-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2026 | 1 | 7 | 0 |
15215 | 15215 | 2022-07-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2030 | 1 | 7 | 0 |
15219 | 15219 | 2022-07-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2031 | 1 | 7 | 0 |
15220 | 15220 | 2022-07-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2032 | 1 | 7 | 0 |
15227 | 15227 | 2022-07-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2033 | 1 | 7 | 0 |
15228 | 15228 | 2022-07-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2034 | 1 | 7 | 0 |
15231 | 15231 | 2022-07-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2035 | 1 | 7 | 0 |
15234 | 15234 | 2022-07-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2036 | 1 | 7 | 0 |
15238 | 15238 | 2022-07-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2037 | 1 | 7 | 0 |
15254 | 15254 | 2022-08-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2038 | 1 | 7 | 0 |
15275 | 15275 | 2022-09-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 1 | 7 | 0 |
15302 | 15302 | 2022-10-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 1 | 7 | 0 |
15329 | 15329 | 2022-10-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2041 | 1 | 7 | 0 |
15330 | 15330 | 2022-10-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2042 | 1 | 7 | 0 |
15338 | 15338 | 2022-11-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 1 | 7 | 0 |
15360 | 15360 | 2022-11-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 1 | 7 | 0 |
15376 | 15376 | 2022-12-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2053 | 1 | 7 | 0 |
15382 | 15382 | 2022-12-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2064 | 1 | 7 | 0 |
15387 | 15387 | 2022-12-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2070 | 1 | 7 | 0 |
15388 | 15388 | 2022-12-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2071 | 1 | 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 );