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.
1,026 rows where name = "California State Prison, Solano" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_deaths
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15390 | 15390 | 2022-12-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2071 | 0 | 7 | 0 |
15389 | 15389 | 2022-12-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2071 | 0 | 7 | 0 |
15388 | 15388 | 2022-12-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2071 | 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 |
15386 | 15386 | 2022-12-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2069 | 0 | 7 | 0 |
15385 | 15385 | 2022-12-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2069 | 5 | 7 | 0 |
15384 | 15384 | 2022-12-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2064 | 0 | 7 | 0 |
15383 | 15383 | 2022-12-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2064 | 0 | 7 | 0 |
15382 | 15382 | 2022-12-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2064 | 1 | 7 | 0 |
15381 | 15381 | 2022-12-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2063 | 3 | 7 | 0 |
15380 | 15380 | 2022-12-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2060 | 5 | 7 | 0 |
15379 | 15379 | 2022-12-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2055 | 2 | 7 | 0 |
15378 | 15378 | 2022-12-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2053 | 0 | 7 | 0 |
15377 | 15377 | 2022-12-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2053 | 0 | 7 | 0 |
15376 | 15376 | 2022-12-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2053 | 1 | 7 | 0 |
15375 | 15375 | 2022-12-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2052 | 0 | 7 | 0 |
15374 | 15374 | 2022-12-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2052 | 2 | 7 | 0 |
15373 | 15373 | 2022-12-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2050 | 4 | 7 | 0 |
15372 | 15372 | 2022-12-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15371 | 15371 | 2022-12-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15370 | 15370 | 2022-12-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15369 | 15369 | 2022-12-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15368 | 15368 | 2022-12-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15367 | 15367 | 2022-12-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15366 | 15366 | 2022-12-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15365 | 15365 | 2022-12-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15364 | 15364 | 2022-12-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15363 | 15363 | 2022-12-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15362 | 15362 | 2022-12-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15361 | 15361 | 2022-12-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 0 | 7 | 0 |
15360 | 15360 | 2022-11-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2046 | 1 | 7 | 0 |
15359 | 15359 | 2022-11-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15358 | 15358 | 2022-11-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15357 | 15357 | 2022-11-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15356 | 15356 | 2022-11-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15355 | 15355 | 2022-11-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15354 | 15354 | 2022-11-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15353 | 15353 | 2022-11-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15352 | 15352 | 2022-11-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15351 | 15351 | 2022-11-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15350 | 15350 | 2022-11-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15349 | 15349 | 2022-11-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15348 | 15348 | 2022-11-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15347 | 15347 | 2022-11-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15346 | 15346 | 2022-11-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15345 | 15345 | 2022-11-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15344 | 15344 | 2022-11-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15343 | 15343 | 2022-11-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15342 | 15342 | 2022-11-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15341 | 15341 | 2022-11-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15340 | 15340 | 2022-11-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15339 | 15339 | 2022-11-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 0 | 7 | 0 |
15338 | 15338 | 2022-11-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2045 | 1 | 7 | 0 |
15337 | 15337 | 2022-11-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 0 | 7 | 0 |
15336 | 15336 | 2022-11-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 0 | 7 | 0 |
15335 | 15335 | 2022-11-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 0 | 7 | 0 |
15334 | 15334 | 2022-11-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 0 | 7 | 0 |
15333 | 15333 | 2022-11-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 0 | 7 | 0 |
15332 | 15332 | 2022-11-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 0 | 7 | 0 |
15331 | 15331 | 2022-11-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2044 | 2 | 7 | 0 |
15330 | 15330 | 2022-10-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2042 | 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 |
15328 | 15328 | 2022-10-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15327 | 15327 | 2022-10-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15326 | 15326 | 2022-10-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15325 | 15325 | 2022-10-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15324 | 15324 | 2022-10-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15323 | 15323 | 2022-10-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15322 | 15322 | 2022-10-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15321 | 15321 | 2022-10-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15320 | 15320 | 2022-10-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15319 | 15319 | 2022-10-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15318 | 15318 | 2022-10-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15317 | 15317 | 2022-10-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15316 | 15316 | 2022-10-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15315 | 15315 | 2022-10-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15314 | 15314 | 2022-10-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15313 | 15313 | 2022-10-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15312 | 15312 | 2022-10-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15311 | 15311 | 2022-10-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15310 | 15310 | 2022-10-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15309 | 15309 | 2022-10-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15308 | 15308 | 2022-10-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15307 | 15307 | 2022-10-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15306 | 15306 | 2022-10-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15305 | 15305 | 2022-10-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15304 | 15304 | 2022-10-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15303 | 15303 | 2022-10-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 0 | 7 | 0 |
15302 | 15302 | 2022-10-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2040 | 1 | 7 | 0 |
15301 | 15301 | 2022-10-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15300 | 15300 | 2022-10-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15299 | 15299 | 2022-09-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15298 | 15298 | 2022-09-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15297 | 15297 | 2022-09-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15296 | 15296 | 2022-09-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15295 | 15295 | 2022-09-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15294 | 15294 | 2022-09-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15293 | 15293 | 2022-09-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15292 | 15292 | 2022-09-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 7 | 0 |
15291 | 15291 | 2022-09-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 2039 | 0 | 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 );