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, Sacramento" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
y 1 ✖
- 38.6875176 1,026
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 |
14363 | 14363 | 2022-12-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 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 |
14361 | 14361 | 2022-12-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 0 | 2 | 0 |
14360 | 14360 | 2022-12-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 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 |
14358 | 14358 | 2022-12-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1001 | 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 |
14356 | 14356 | 2022-12-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1000 | 0 | 2 | 0 |
14355 | 14355 | 2022-12-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 1000 | 1 | 2 | 0 |
14354 | 14354 | 2022-12-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 999 | 0 | 2 | 0 |
14353 | 14353 | 2022-12-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 999 | 2 | 2 | 0 |
14352 | 14352 | 2022-12-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 997 | 1 | 2 | 0 |
14351 | 14351 | 2022-12-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 996 | 3 | 2 | 0 |
14350 | 14350 | 2022-12-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 993 | 0 | 2 | 0 |
14349 | 14349 | 2022-12-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 993 | 1 | 2 | 0 |
14348 | 14348 | 2022-12-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 992 | 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 |
14346 | 14346 | 2022-12-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 989 | 0 | 2 | 0 |
14345 | 14345 | 2022-12-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 989 | 1 | 2 | 0 |
14344 | 14344 | 2022-12-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 988 | 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 |
14342 | 14342 | 2022-12-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 985 | 0 | 2 | 0 |
14341 | 14341 | 2022-12-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 985 | 2 | 2 | 0 |
14340 | 14340 | 2022-12-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 983 | 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 |
14338 | 14338 | 2022-12-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 981 | 2 | 2 | 0 |
14337 | 14337 | 2022-12-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 979 | 2 | 2 | 0 |
14336 | 14336 | 2022-12-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 977 | 1 | 2 | 0 |
14335 | 14335 | 2022-12-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 976 | 1 | 2 | 0 |
14334 | 14334 | 2022-11-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 975 | 2 | 2 | 0 |
14333 | 14333 | 2022-11-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 973 | 3 | 2 | 0 |
14332 | 14332 | 2022-11-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 970 | 3 | 2 | 0 |
14331 | 14331 | 2022-11-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 967 | 1 | 2 | 0 |
14330 | 14330 | 2022-11-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 966 | 1 | 2 | 0 |
14329 | 14329 | 2022-11-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 965 | 6 | 2 | 0 |
14328 | 14328 | 2022-11-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 959 | 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 |
14326 | 14326 | 2022-11-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 957 | 6 | 2 | 0 |
14325 | 14325 | 2022-11-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 951 | 3 | 2 | 0 |
14324 | 14324 | 2022-11-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 948 | 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 |
14322 | 14322 | 2022-11-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 947 | 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 |
14320 | 14320 | 2022-11-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 946 | 3 | 2 | 0 |
14319 | 14319 | 2022-11-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 943 | 4 | 2 | 0 |
14318 | 14318 | 2022-11-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 939 | 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 |
14316 | 14316 | 2022-11-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 939 | 2 | 2 | 0 |
14315 | 14315 | 2022-11-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14314 | 14314 | 2022-11-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14313 | 14313 | 2022-11-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14312 | 14312 | 2022-11-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14311 | 14311 | 2022-11-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14310 | 14310 | 2022-11-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14309 | 14309 | 2022-11-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14308 | 14308 | 2022-11-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 0 | 2 | 0 |
14307 | 14307 | 2022-11-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 937 | 1 | 2 | 0 |
14306 | 14306 | 2022-11-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 936 | 0 | 2 | 0 |
14305 | 14305 | 2022-11-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 936 | 0 | 2 | 0 |
14304 | 14304 | 2022-10-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 936 | 1 | 2 | 0 |
14303 | 14303 | 2022-10-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14302 | 14302 | 2022-10-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14301 | 14301 | 2022-10-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14300 | 14300 | 2022-10-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14299 | 14299 | 2022-10-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14298 | 14298 | 2022-10-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14297 | 14297 | 2022-10-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14296 | 14296 | 2022-10-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14295 | 14295 | 2022-10-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14294 | 14294 | 2022-10-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14293 | 14293 | 2022-10-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14292 | 14292 | 2022-10-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14291 | 14291 | 2022-10-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14290 | 14290 | 2022-10-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14289 | 14289 | 2022-10-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14288 | 14288 | 2022-10-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14287 | 14287 | 2022-10-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14286 | 14286 | 2022-10-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14285 | 14285 | 2022-10-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14284 | 14284 | 2022-10-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14283 | 14283 | 2022-10-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14282 | 14282 | 2022-10-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14281 | 14281 | 2022-10-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14280 | 14280 | 2022-10-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 0 | 2 | 0 |
14279 | 14279 | 2022-10-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 935 | 1 | 2 | 0 |
14278 | 14278 | 2022-10-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 934 | 0 | 2 | 0 |
14277 | 14277 | 2022-10-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 934 | 1 | 2 | 0 |
14276 | 14276 | 2022-10-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 0 | 2 | 0 |
14275 | 14275 | 2022-10-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 0 | 2 | 0 |
14274 | 14274 | 2022-10-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 0 | 2 | 0 |
14273 | 14273 | 2022-09-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 0 | 2 | 0 |
14272 | 14272 | 2022-09-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 0 | 2 | 0 |
14271 | 14271 | 2022-09-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 0 | 2 | 0 |
14270 | 14270 | 2022-09-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 933 | 1 | 2 | 0 |
14269 | 14269 | 2022-09-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14268 | 14268 | 2022-09-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14267 | 14267 | 2022-09-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14266 | 14266 | 2022-09-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14265 | 14265 | 2022-09-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 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 );