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.
2,052 rows where fips = 67
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, y, deaths, new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13339 | 13339 | 2020-03-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | ||
13340 | 13340 | 2020-03-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13341 | 13341 | 2020-03-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13342 | 13342 | 2020-03-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13343 | 13343 | 2020-03-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13344 | 13344 | 2020-03-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13345 | 13345 | 2020-03-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13346 | 13346 | 2020-03-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13347 | 13347 | 2020-03-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13348 | 13348 | 2020-03-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13349 | 13349 | 2020-03-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13350 | 13350 | 2020-03-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13351 | 13351 | 2020-03-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13352 | 13352 | 2020-03-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13353 | 13353 | 2020-03-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13354 | 13354 | 2020-03-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13355 | 13355 | 2020-03-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13356 | 13356 | 2020-03-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13357 | 13357 | 2020-03-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13358 | 13358 | 2020-03-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13359 | 13359 | 2020-03-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13360 | 13360 | 2020-03-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13361 | 13361 | 2020-04-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13362 | 13362 | 2020-04-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13363 | 13363 | 2020-04-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13364 | 13364 | 2020-04-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13365 | 13365 | 2020-04-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13366 | 13366 | 2020-04-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13367 | 13367 | 2020-04-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13368 | 13368 | 2020-04-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13369 | 13369 | 2020-04-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13370 | 13370 | 2020-04-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13371 | 13371 | 2020-04-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13372 | 13372 | 2020-04-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13373 | 13373 | 2020-04-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13374 | 13374 | 2020-04-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13375 | 13375 | 2020-04-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13376 | 13376 | 2020-04-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13377 | 13377 | 2020-04-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13378 | 13378 | 2020-04-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13379 | 13379 | 2020-04-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13380 | 13380 | 2020-04-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13381 | 13381 | 2020-04-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13382 | 13382 | 2020-04-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13383 | 13383 | 2020-04-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13384 | 13384 | 2020-04-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13385 | 13385 | 2020-04-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13386 | 13386 | 2020-04-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13387 | 13387 | 2020-04-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13388 | 13388 | 2020-04-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13389 | 13389 | 2020-04-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13390 | 13390 | 2020-04-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13391 | 13391 | 2020-05-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13392 | 13392 | 2020-05-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13393 | 13393 | 2020-05-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13394 | 13394 | 2020-05-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13395 | 13395 | 2020-05-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13396 | 13396 | 2020-05-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13397 | 13397 | 2020-05-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13398 | 13398 | 2020-05-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13399 | 13399 | 2020-05-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13400 | 13400 | 2020-05-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13401 | 13401 | 2020-05-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13402 | 13402 | 2020-05-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13403 | 13403 | 2020-05-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13404 | 13404 | 2020-05-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13405 | 13405 | 2020-05-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13406 | 13406 | 2020-05-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13407 | 13407 | 2020-05-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13408 | 13408 | 2020-05-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13409 | 13409 | 2020-05-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13410 | 13410 | 2020-05-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13411 | 13411 | 2020-05-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13412 | 13412 | 2020-05-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13413 | 13413 | 2020-05-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13414 | 13414 | 2020-05-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13415 | 13415 | 2020-05-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13416 | 13416 | 2020-05-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13417 | 13417 | 2020-05-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13418 | 13418 | 2020-05-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13419 | 13419 | 2020-05-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13420 | 13420 | 2020-05-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13421 | 13421 | 2020-05-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13422 | 13422 | 2020-06-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13423 | 13423 | 2020-06-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13424 | 13424 | 2020-06-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13425 | 13425 | 2020-06-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13426 | 13426 | 2020-06-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13427 | 13427 | 2020-06-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13428 | 13428 | 2020-06-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13429 | 13429 | 2020-06-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13430 | 13430 | 2020-06-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13431 | 13431 | 2020-06-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13432 | 13432 | 2020-06-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 0 | 0 | 0 | 0 |
13433 | 13433 | 2020-06-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1 | 1 | 0 | 0 |
13434 | 13434 | 2020-06-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1 | 0 | 0 | 0 |
13435 | 13435 | 2020-06-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1 | 0 | 0 | 0 |
13436 | 13436 | 2020-06-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 3 | 2 | 0 | 0 |
13437 | 13437 | 2020-06-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 3 | 0 | 0 | 0 |
13438 | 13438 | 2020-06-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 3 | 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 );