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 city = "Represa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: code, x, confirmed_cases, new_confirmed_cases, deaths, date (date)
name 2 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14364 | 14364 | 2022-12-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22572 | 22572 | 2022-12-30 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2907 | 0 | 2 | 0 |
14363 | 14363 | 2022-12-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22571 | 22571 | 2022-12-29 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2907 | 0 | 2 | 0 |
14362 | 14362 | 2022-12-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22570 | 22570 | 2022-12-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2907 | 0 | 2 | 0 |
14361 | 14361 | 2022-12-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22569 | 22569 | 2022-12-27 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2907 | 2 | 2 | 0 |
14360 | 14360 | 2022-12-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22568 | 22568 | 2022-12-26 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2905 | 0 | 2 | 0 |
14359 | 14359 | 2022-12-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22567 | 22567 | 2022-12-25 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2905 | 0 | 2 | 0 |
14358 | 14358 | 2022-12-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
22566 | 22566 | 2022-12-24 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2905 | 0 | 2 | 0 |
14357 | 14357 | 2022-12-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 1 | 2 | 0 |
22565 | 22565 | 2022-12-23 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2905 | 0 | 2 | 0 |
14356 | 14356 | 2022-12-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1000 | 0 | 2 | 0 |
22564 | 22564 | 2022-12-22 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2905 | 2 | 2 | 0 |
14355 | 14355 | 2022-12-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1000 | 1 | 2 | 0 |
22563 | 22563 | 2022-12-21 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2903 | 0 | 2 | 0 |
14354 | 14354 | 2022-12-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 999 | 0 | 2 | 0 |
22562 | 22562 | 2022-12-20 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2903 | 1 | 2 | 0 |
14353 | 14353 | 2022-12-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 999 | 2 | 2 | 0 |
22561 | 22561 | 2022-12-19 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2902 | 0 | 2 | 0 |
14352 | 14352 | 2022-12-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 997 | 1 | 2 | 0 |
22560 | 22560 | 2022-12-18 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2902 | 0 | 2 | 0 |
14351 | 14351 | 2022-12-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 996 | 3 | 2 | 0 |
22559 | 22559 | 2022-12-17 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2902 | 0 | 2 | 0 |
14350 | 14350 | 2022-12-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 993 | 0 | 2 | 0 |
22558 | 22558 | 2022-12-16 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2902 | 4 | 2 | 0 |
14349 | 14349 | 2022-12-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 993 | 1 | 2 | 0 |
22557 | 22557 | 2022-12-15 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2898 | 0 | 2 | 0 |
14348 | 14348 | 2022-12-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 992 | 0 | 2 | 0 |
22556 | 22556 | 2022-12-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2898 | 0 | 2 | 0 |
14347 | 14347 | 2022-12-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 992 | 3 | 2 | 0 |
22555 | 22555 | 2022-12-13 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2898 | 9 | 2 | 0 |
14346 | 14346 | 2022-12-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 989 | 0 | 2 | 0 |
22554 | 22554 | 2022-12-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2889 | 1 | 2 | 0 |
14345 | 14345 | 2022-12-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 989 | 1 | 2 | 0 |
22553 | 22553 | 2022-12-11 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2888 | 0 | 2 | 0 |
14344 | 14344 | 2022-12-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 988 | 2 | 2 | 0 |
22552 | 22552 | 2022-12-10 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2888 | 2 | 2 | 0 |
14343 | 14343 | 2022-12-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 986 | 1 | 2 | 0 |
22551 | 22551 | 2022-12-09 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2886 | 3 | 2 | 0 |
14342 | 14342 | 2022-12-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 985 | 0 | 2 | 0 |
22550 | 22550 | 2022-12-08 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2883 | 1 | 2 | 0 |
14341 | 14341 | 2022-12-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 985 | 2 | 2 | 0 |
22549 | 22549 | 2022-12-07 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2882 | 1 | 2 | 0 |
14340 | 14340 | 2022-12-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 983 | 0 | 2 | 0 |
22548 | 22548 | 2022-12-06 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2881 | 0 | 2 | 0 |
14339 | 14339 | 2022-12-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 983 | 2 | 2 | 0 |
22547 | 22547 | 2022-12-05 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2881 | 0 | 2 | 0 |
14338 | 14338 | 2022-12-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 981 | 2 | 2 | 0 |
22546 | 22546 | 2022-12-04 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2881 | 0 | 2 | 0 |
14337 | 14337 | 2022-12-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 979 | 2 | 2 | 0 |
22545 | 22545 | 2022-12-03 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2881 | 0 | 2 | 0 |
14336 | 14336 | 2022-12-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 977 | 1 | 2 | 0 |
22544 | 22544 | 2022-12-02 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2881 | 2 | 2 | 0 |
14335 | 14335 | 2022-12-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 976 | 1 | 2 | 0 |
22543 | 22543 | 2022-12-01 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2879 | 3 | 2 | 0 |
14334 | 14334 | 2022-11-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 975 | 2 | 2 | 0 |
22542 | 22542 | 2022-11-30 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2876 | 0 | 2 | 0 |
14333 | 14333 | 2022-11-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 973 | 3 | 2 | 0 |
22541 | 22541 | 2022-11-29 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2876 | 1 | 2 | 0 |
14332 | 14332 | 2022-11-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 970 | 3 | 2 | 0 |
22540 | 22540 | 2022-11-28 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14331 | 14331 | 2022-11-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 967 | 1 | 2 | 0 |
22539 | 22539 | 2022-11-27 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14330 | 14330 | 2022-11-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 966 | 1 | 2 | 0 |
22538 | 22538 | 2022-11-26 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14329 | 14329 | 2022-11-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 965 | 6 | 2 | 0 |
22537 | 22537 | 2022-11-25 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14328 | 14328 | 2022-11-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 959 | 0 | 2 | 0 |
22536 | 22536 | 2022-11-24 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14327 | 14327 | 2022-11-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 959 | 2 | 2 | 0 |
22535 | 22535 | 2022-11-23 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14326 | 14326 | 2022-11-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 957 | 6 | 2 | 0 |
22534 | 22534 | 2022-11-22 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14325 | 14325 | 2022-11-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 951 | 3 | 2 | 0 |
22533 | 22533 | 2022-11-21 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14324 | 14324 | 2022-11-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 948 | 0 | 2 | 0 |
22532 | 22532 | 2022-11-20 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14323 | 14323 | 2022-11-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 948 | 1 | 2 | 0 |
22531 | 22531 | 2022-11-19 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14322 | 14322 | 2022-11-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 947 | 0 | 2 | 0 |
22530 | 22530 | 2022-11-18 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14321 | 14321 | 2022-11-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 947 | 1 | 2 | 0 |
22529 | 22529 | 2022-11-17 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 0 | 2 | 0 |
14320 | 14320 | 2022-11-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 946 | 3 | 2 | 0 |
22528 | 22528 | 2022-11-16 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2875 | 1 | 2 | 0 |
14319 | 14319 | 2022-11-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 943 | 4 | 2 | 0 |
22527 | 22527 | 2022-11-15 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2874 | 0 | 2 | 0 |
14318 | 14318 | 2022-11-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 939 | 0 | 2 | 0 |
22526 | 22526 | 2022-11-14 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2874 | 0 | 2 | 0 |
14317 | 14317 | 2022-11-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 939 | 0 | 2 | 0 |
22525 | 22525 | 2022-11-13 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2874 | 0 | 2 | 0 |
14316 | 14316 | 2022-11-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 939 | 2 | 2 | 0 |
22524 | 22524 | 2022-11-12 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2874 | 0 | 2 | 0 |
14315 | 14315 | 2022-11-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
22523 | 22523 | 2022-11-11 | FSP | Folsom State Prison | Represa | Sacramento | 67 | 95671 | -121.1624287 | 38.694558 | 2874 | 0 | 2 | 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 );