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 = "Avenal State Prison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
y 1 ✖
- 35.9705041 1,026
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026 | 1026 | 2022-12-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1025 | 1025 | 2022-12-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1024 | 1024 | 2022-12-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1023 | 1023 | 2022-12-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1022 | 1022 | 2022-12-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1021 | 1021 | 2022-12-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1020 | 1020 | 2022-12-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1019 | 1019 | 2022-12-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1018 | 1018 | 2022-12-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1017 | 1017 | 2022-12-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1016 | 1016 | 2022-12-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1015 | 1015 | 2022-12-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1014 | 1014 | 2022-12-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1013 | 1013 | 2022-12-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1012 | 1012 | 2022-12-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1011 | 1011 | 2022-12-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 0 | 8 | 0 |
1010 | 1010 | 2022-12-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4342 | 1 | 8 | 0 |
1009 | 1009 | 2022-12-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4341 | 3 | 8 | 0 |
1008 | 1008 | 2022-12-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4338 | 1 | 8 | 0 |
1007 | 1007 | 2022-12-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1006 | 1006 | 2022-12-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1005 | 1005 | 2022-12-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1004 | 1004 | 2022-12-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1003 | 1003 | 2022-12-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1002 | 1002 | 2022-12-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1001 | 1001 | 2022-12-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 0 | 8 | 0 |
1000 | 1000 | 2022-12-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4337 | 1 | 8 | 0 |
999 | 999 | 2022-12-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 0 | 8 | 0 |
998 | 998 | 2022-12-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 0 | 8 | 0 |
997 | 997 | 2022-12-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 0 | 8 | 0 |
996 | 996 | 2022-11-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4336 | 1 | 8 | 0 |
995 | 995 | 2022-11-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4335 | 0 | 8 | 0 |
994 | 994 | 2022-11-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4335 | 5 | 8 | 0 |
993 | 993 | 2022-11-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4330 | 1 | 8 | 0 |
992 | 992 | 2022-11-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4329 | 0 | 8 | 0 |
991 | 991 | 2022-11-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4329 | 1 | 8 | 0 |
990 | 990 | 2022-11-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4328 | 0 | 8 | 0 |
989 | 989 | 2022-11-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4328 | 1 | 8 | 0 |
988 | 988 | 2022-11-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4327 | 0 | 8 | 0 |
987 | 987 | 2022-11-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4327 | 0 | 8 | 0 |
986 | 986 | 2022-11-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4327 | 17 | 8 | 0 |
985 | 985 | 2022-11-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4310 | 0 | 8 | 0 |
984 | 984 | 2022-11-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4310 | 2 | 8 | 0 |
983 | 983 | 2022-11-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4308 | 18 | 8 | 0 |
982 | 982 | 2022-11-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4290 | 1 | 8 | 0 |
981 | 981 | 2022-11-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4289 | 34 | 8 | 0 |
980 | 980 | 2022-11-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4255 | 8 | 8 | 0 |
979 | 979 | 2022-11-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4247 | 17 | 8 | 0 |
978 | 978 | 2022-11-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4230 | 1 | 8 | 0 |
977 | 977 | 2022-11-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4229 | 2 | 8 | 0 |
976 | 976 | 2022-11-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4227 | 14 | 8 | 0 |
975 | 975 | 2022-11-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4213 | 2 | 8 | 0 |
974 | 974 | 2022-11-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4211 | 3 | 8 | 0 |
973 | 973 | 2022-11-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4208 | 2 | 8 | 0 |
972 | 972 | 2022-11-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
971 | 971 | 2022-11-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
970 | 970 | 2022-11-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
969 | 969 | 2022-11-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
968 | 968 | 2022-11-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
967 | 967 | 2022-11-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
966 | 966 | 2022-10-31 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
965 | 965 | 2022-10-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
964 | 964 | 2022-10-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
963 | 963 | 2022-10-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
962 | 962 | 2022-10-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 0 | 8 | 0 |
961 | 961 | 2022-10-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4206 | 1 | 8 | 0 |
960 | 960 | 2022-10-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
959 | 959 | 2022-10-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
958 | 958 | 2022-10-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
957 | 957 | 2022-10-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
956 | 956 | 2022-10-21 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
955 | 955 | 2022-10-20 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 0 | 8 | 0 |
954 | 954 | 2022-10-19 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4205 | 1 | 8 | 0 |
953 | 953 | 2022-10-18 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
952 | 952 | 2022-10-17 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
951 | 951 | 2022-10-16 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
950 | 950 | 2022-10-15 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
949 | 949 | 2022-10-14 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
948 | 948 | 2022-10-13 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
947 | 947 | 2022-10-12 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
946 | 946 | 2022-10-11 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
945 | 945 | 2022-10-10 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
944 | 944 | 2022-10-09 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
943 | 943 | 2022-10-08 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
942 | 942 | 2022-10-07 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
941 | 941 | 2022-10-06 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
940 | 940 | 2022-10-05 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
939 | 939 | 2022-10-04 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
938 | 938 | 2022-10-03 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
937 | 937 | 2022-10-02 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
936 | 936 | 2022-10-01 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
935 | 935 | 2022-09-30 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
934 | 934 | 2022-09-29 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
933 | 933 | 2022-09-28 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
932 | 932 | 2022-09-27 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
931 | 931 | 2022-09-26 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
930 | 930 | 2022-09-25 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
929 | 929 | 2022-09-24 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
928 | 928 | 2022-09-23 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 0 | 8 | 0 |
927 | 927 | 2022-09-22 | ASP | Avenal State Prison | Avenal | Kings | 31 | 93204 | -120.1211248 | 35.9705041 | 4204 | 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 );