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"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14365 | 14365 | 2020-03-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | ||
14366 | 14366 | 2020-03-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14367 | 14367 | 2020-03-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14368 | 14368 | 2020-03-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14369 | 14369 | 2020-03-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14370 | 14370 | 2020-03-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14371 | 14371 | 2020-03-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14372 | 14372 | 2020-03-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14373 | 14373 | 2020-03-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14374 | 14374 | 2020-03-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14375 | 14375 | 2020-03-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14376 | 14376 | 2020-03-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14377 | 14377 | 2020-03-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14378 | 14378 | 2020-03-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14379 | 14379 | 2020-03-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14380 | 14380 | 2020-03-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14381 | 14381 | 2020-03-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14382 | 14382 | 2020-03-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14383 | 14383 | 2020-03-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14384 | 14384 | 2020-03-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14385 | 14385 | 2020-03-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14386 | 14386 | 2020-03-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14387 | 14387 | 2020-04-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14388 | 14388 | 2020-04-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14389 | 14389 | 2020-04-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14390 | 14390 | 2020-04-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14391 | 14391 | 2020-04-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14392 | 14392 | 2020-04-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14393 | 14393 | 2020-04-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14394 | 14394 | 2020-04-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14395 | 14395 | 2020-04-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14396 | 14396 | 2020-04-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14397 | 14397 | 2020-04-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14398 | 14398 | 2020-04-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14399 | 14399 | 2020-04-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14400 | 14400 | 2020-04-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14401 | 14401 | 2020-04-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14402 | 14402 | 2020-04-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14403 | 14403 | 2020-04-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14404 | 14404 | 2020-04-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14405 | 14405 | 2020-04-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14406 | 14406 | 2020-04-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14407 | 14407 | 2020-04-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14408 | 14408 | 2020-04-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14409 | 14409 | 2020-04-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14410 | 14410 | 2020-04-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14411 | 14411 | 2020-04-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14412 | 14412 | 2020-04-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14413 | 14413 | 2020-04-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14414 | 14414 | 2020-04-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14415 | 14415 | 2020-04-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14416 | 14416 | 2020-04-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14417 | 14417 | 2020-05-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14418 | 14418 | 2020-05-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14419 | 14419 | 2020-05-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14420 | 14420 | 2020-05-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14421 | 14421 | 2020-05-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14422 | 14422 | 2020-05-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14423 | 14423 | 2020-05-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14424 | 14424 | 2020-05-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14425 | 14425 | 2020-05-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14426 | 14426 | 2020-05-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14427 | 14427 | 2020-05-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14428 | 14428 | 2020-05-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14429 | 14429 | 2020-05-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14430 | 14430 | 2020-05-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14431 | 14431 | 2020-05-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14432 | 14432 | 2020-05-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14433 | 14433 | 2020-05-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14434 | 14434 | 2020-05-18 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14435 | 14435 | 2020-05-19 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14436 | 14436 | 2020-05-20 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14437 | 14437 | 2020-05-21 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14438 | 14438 | 2020-05-22 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14439 | 14439 | 2020-05-23 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14440 | 14440 | 2020-05-24 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14441 | 14441 | 2020-05-25 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14442 | 14442 | 2020-05-26 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14443 | 14443 | 2020-05-27 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14444 | 14444 | 2020-05-28 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14445 | 14445 | 2020-05-29 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14446 | 14446 | 2020-05-30 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14447 | 14447 | 2020-05-31 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14448 | 14448 | 2020-06-01 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14449 | 14449 | 2020-06-02 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14450 | 14450 | 2020-06-03 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14451 | 14451 | 2020-06-04 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14452 | 14452 | 2020-06-05 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14453 | 14453 | 2020-06-06 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14454 | 14454 | 2020-06-07 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 0 | 0 | 0 | 0 |
14455 | 14455 | 2020-06-08 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 1 | 0 | 0 |
14456 | 14456 | 2020-06-09 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14457 | 14457 | 2020-06-10 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14458 | 14458 | 2020-06-11 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14459 | 14459 | 2020-06-12 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14460 | 14460 | 2020-06-13 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14461 | 14461 | 2020-06-14 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14462 | 14462 | 2020-06-15 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14463 | 14463 | 2020-06-16 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 0 |
14464 | 14464 | 2020-06-17 | SOL | California State Prison, Solano | Vacaville | Solano | 95 | 95687 | -121.9742829 | 38.3168817 | 1 | 0 | 0 | 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 );