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.
3,078 rows where fips = 31 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
name 3 ✖
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12279 | 12279 | 2022-11-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2502 | 2 | 8 | 0 |
16383 | 16383 | 2022-11-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4817 | 0 | 7 | 0 |
992 | 992 | 2022-11-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4329 | 0 | 8 | 0 |
12278 | 12278 | 2022-11-26 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2500 | 3 | 8 | 0 |
16382 | 16382 | 2022-11-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4817 | 0 | 7 | 0 |
991 | 991 | 2022-11-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4329 | 1 | 8 | 0 |
12277 | 12277 | 2022-11-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2497 | 5 | 8 | 0 |
16381 | 16381 | 2022-11-25 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4817 | 0 | 7 | 0 |
990 | 990 | 2022-11-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4328 | 0 | 8 | 0 |
12276 | 12276 | 2022-11-24 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2492 | 5 | 8 | 0 |
16380 | 16380 | 2022-11-24 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4817 | 0 | 7 | 0 |
989 | 989 | 2022-11-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4328 | 1 | 8 | 0 |
12275 | 12275 | 2022-11-23 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2487 | 8 | 8 | 0 |
16379 | 16379 | 2022-11-23 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4817 | 1 | 7 | 0 |
988 | 988 | 2022-11-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4327 | 0 | 8 | 0 |
12274 | 12274 | 2022-11-22 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2479 | 5 | 8 | 0 |
16378 | 16378 | 2022-11-22 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4816 | 1 | 7 | 0 |
987 | 987 | 2022-11-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4327 | 0 | 8 | 0 |
12273 | 12273 | 2022-11-21 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2474 | 1 | 8 | 0 |
16377 | 16377 | 2022-11-21 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4815 | 4 | 7 | 0 |
986 | 986 | 2022-11-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4327 | 17 | 8 | 0 |
12272 | 12272 | 2022-11-20 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2473 | 0 | 8 | 0 |
16376 | 16376 | 2022-11-20 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4811 | 0 | 7 | 0 |
985 | 985 | 2022-11-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4310 | 0 | 8 | 0 |
12271 | 12271 | 2022-11-19 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2473 | 1 | 8 | 0 |
16375 | 16375 | 2022-11-19 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4811 | 28 | 7 | 0 |
984 | 984 | 2022-11-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4310 | 2 | 8 | 0 |
12270 | 12270 | 2022-11-18 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2472 | 11 | 8 | 0 |
16374 | 16374 | 2022-11-18 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4783 | 1 | 7 | 0 |
983 | 983 | 2022-11-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4308 | 18 | 8 | 0 |
12269 | 12269 | 2022-11-17 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2461 | 14 | 8 | 0 |
16373 | 16373 | 2022-11-17 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4782 | 23 | 7 | 0 |
982 | 982 | 2022-11-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4290 | 1 | 8 | 0 |
12268 | 12268 | 2022-11-16 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2447 | 2 | 8 | 0 |
16372 | 16372 | 2022-11-16 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4759 | 3 | 7 | 0 |
981 | 981 | 2022-11-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4289 | 34 | 8 | 0 |
12267 | 12267 | 2022-11-15 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2445 | 5 | 8 | 0 |
16371 | 16371 | 2022-11-15 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4756 | 16 | 7 | 0 |
980 | 980 | 2022-11-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4255 | 8 | 8 | 0 |
12266 | 12266 | 2022-11-14 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2440 | 1 | 8 | 0 |
16370 | 16370 | 2022-11-14 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4740 | 1 | 7 | 0 |
979 | 979 | 2022-11-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4247 | 17 | 8 | 0 |
12265 | 12265 | 2022-11-13 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2439 | 1 | 8 | 0 |
16369 | 16369 | 2022-11-13 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4739 | 0 | 7 | 0 |
978 | 978 | 2022-11-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4230 | 1 | 8 | 0 |
12264 | 12264 | 2022-11-12 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2438 | 2 | 8 | 0 |
16368 | 16368 | 2022-11-12 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4739 | 3 | 7 | 0 |
977 | 977 | 2022-11-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4229 | 2 | 8 | 0 |
12263 | 12263 | 2022-11-11 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2436 | 1 | 8 | 0 |
16367 | 16367 | 2022-11-11 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4736 | 0 | 7 | 0 |
976 | 976 | 2022-11-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4227 | 14 | 8 | 0 |
12262 | 12262 | 2022-11-10 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2435 | 7 | 8 | 0 |
16366 | 16366 | 2022-11-10 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4736 | 0 | 7 | 0 |
975 | 975 | 2022-11-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4213 | 2 | 8 | 0 |
12261 | 12261 | 2022-11-09 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2428 | 3 | 8 | 0 |
16365 | 16365 | 2022-11-09 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4736 | 8 | 7 | 0 |
974 | 974 | 2022-11-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4211 | 3 | 8 | 0 |
12260 | 12260 | 2022-11-08 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2425 | 1 | 8 | 0 |
16364 | 16364 | 2022-11-08 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4728 | 4 | 7 | 0 |
973 | 973 | 2022-11-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4208 | 2 | 8 | 0 |
12259 | 12259 | 2022-11-07 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2424 | 3 | 8 | 0 |
16363 | 16363 | 2022-11-07 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4724 | 3 | 7 | 0 |
972 | 972 | 2022-11-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12258 | 12258 | 2022-11-06 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16362 | 16362 | 2022-11-06 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4721 | 0 | 7 | 0 |
971 | 971 | 2022-11-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12257 | 12257 | 2022-11-05 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16361 | 16361 | 2022-11-05 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4721 | 1 | 7 | 0 |
970 | 970 | 2022-11-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12256 | 12256 | 2022-11-04 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16360 | 16360 | 2022-11-04 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4720 | 1 | 7 | 0 |
969 | 969 | 2022-11-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12255 | 12255 | 2022-11-03 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16359 | 16359 | 2022-11-03 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4719 | 4 | 7 | 0 |
968 | 968 | 2022-11-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12254 | 12254 | 2022-11-02 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16358 | 16358 | 2022-11-02 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4715 | 5 | 7 | 0 |
967 | 967 | 2022-11-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12253 | 12253 | 2022-11-01 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16357 | 16357 | 2022-11-01 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4710 | 8 | 7 | 0 |
966 | 966 | 2022-10-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12252 | 12252 | 2022-10-31 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 0 | 8 | 0 |
16356 | 16356 | 2022-10-31 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4702 | 19 | 7 | 0 |
965 | 965 | 2022-10-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12251 | 12251 | 2022-10-30 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2421 | 1 | 8 | 0 |
16355 | 16355 | 2022-10-30 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4683 | 7 | 7 | 0 |
964 | 964 | 2022-10-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12250 | 12250 | 2022-10-29 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2420 | 0 | 8 | 0 |
16354 | 16354 | 2022-10-29 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4676 | 25 | 7 | 0 |
963 | 963 | 2022-10-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12249 | 12249 | 2022-10-28 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2420 | 0 | 8 | 0 |
16353 | 16353 | 2022-10-28 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4651 | 29 | 7 | 0 |
962 | 962 | 2022-10-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
12248 | 12248 | 2022-10-27 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2420 | 1 | 8 | 0 |
16352 | 16352 | 2022-10-27 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4622 | 60 | 7 | 0 |
961 | 961 | 2022-10-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 1 | 8 | 0 |
12247 | 12247 | 2022-10-26 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2419 | 0 | 8 | 0 |
16351 | 16351 | 2022-10-26 | SATF | California Substance Abuse Treatment Facility and State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.5536827 | 36.0525532 | 4562 | 2 | 7 | 0 |
960 | 960 | 2022-10-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
12246 | 12246 | 2022-10-25 | COR | California State Prison, Corcoran | Corcoran | Kings | 31 | 93212 | -119.552853 | 36.060226 | 2419 | 0 | 8 | 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 );