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 City Correctional Facility" sorted by name
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, deaths, new_deaths, date (date)
confirmed_cases 178 ✖
- 1016 91
- 1 88
- 3 87
- 0 72
- 1003 71
- 1008 52
- 1138 52
- 1139 32
- 1000 29
- 1004 29
- 1001 25
- 1140 25
- 1753 22
- 1828 15
- 1005 14
- 1752 14
- 4 11
- 1710 11
- 1830 10
- 1755 8
- 1712 7
- 1751 7
- 1754 7
- 968 5
- 997 5
- 1756 5
- 1762 5
- 1831 5
- 936 4
- 1102 4
- 1701 4
- 1703 4
- 1723 4
- 1743 4
- 1820 4
- 924 3
- 983 3
- 1014 3
- 1111 3
- 1122 3
- 1132 3
- 1706 3
- 1750 3
- 1793 3
- 1798 3
- 1829 3
- 8 2
- 46 2
- 404 2
- 695 2
- 869 2
- 870 2
- 933 2
- 981 2
- 982 2
- 994 2
- 1002 2
- 1010 2
- 1053 2
- 1054 2
- 1065 2
- 1080 2
- 1100 2
- 1110 2
- 1112 2
- 1113 2
- 1127 2
- 1698 2
- 1705 2
- 1737 2
- 1745 2
- 1795 2
- 1797 2
- 1826 2
- 1827 2
- 9 1
- 12 1
- 47 1
- 107 1
- 121 1
- 126 1
- 138 1
- 171 1
- 173 1
- 174 1
- 269 1
- 278 1
- 288 1
- 386 1
- 422 1
- 493 1
- 494 1
- 515 1
- 518 1
- 522 1
- 524 1
- 528 1
- 642 1
- 646 1
- 692 1
- 694 1
- 696 1
- 814 1
- 826 1
- 868 1
- 902 1
- 908 1
- 910 1
- 911 1
- 932 1
- 934 1
- 940 1
- 998 1
- 999 1
- 1011 1
- 1013 1
- 1019 1
- 1022 1
- 1040 1
- 1070 1
- 1073 1
- 1081 1
- 1084 1
- 1088 1
- 1109 1
- 1123 1
- 1128 1
- 1133 1
- 1135 1
- 1137 1
- 1141 1
- 1155 1
- 1158 1
- 1191 1
- 1282 1
- 1288 1
- 1301 1
- 1352 1
- 1418 1
- 1458 1
- 1531 1
- 1544 1
- 1553 1
- 1555 1
- 1577 1
- 1609 1
- 1647 1
- 1661 1
- 1668 1
- 1669 1
- 1670 1
- 1671 1
- 1678 1
- 1691 1
- 1696 1
- 1697 1
- 1704 1
- 1707 1
- 1708 1
- 1709 1
- 1717 1
- 1718 1
- 1721 1
- 1735 1
- 1741 1
- 1749 1
- 1759 1
- 1761 1
- 1766 1
- 1776 1
- 1778 1
- 1789 1
- 1803 1
- 1808 1
- 1811 1
- 1818 1
- 1824 1
- 1825 1
Link | rowid | date | code | name ▼ | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1027 | 1027 | 2020-03-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | ||
1028 | 1028 | 2020-03-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1029 | 1029 | 2020-03-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1030 | 1030 | 2020-03-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1031 | 1031 | 2020-03-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1032 | 1032 | 2020-03-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1033 | 1033 | 2020-03-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1034 | 1034 | 2020-03-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1035 | 1035 | 2020-03-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1036 | 1036 | 2020-03-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1037 | 1037 | 2020-03-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1038 | 1038 | 2020-03-21 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1039 | 1039 | 2020-03-22 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1040 | 1040 | 2020-03-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1041 | 1041 | 2020-03-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1042 | 1042 | 2020-03-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1043 | 1043 | 2020-03-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1044 | 1044 | 2020-03-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1045 | 1045 | 2020-03-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1046 | 1046 | 2020-03-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1047 | 1047 | 2020-03-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1048 | 1048 | 2020-03-31 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1049 | 1049 | 2020-04-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1050 | 1050 | 2020-04-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1051 | 1051 | 2020-04-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1052 | 1052 | 2020-04-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1053 | 1053 | 2020-04-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1054 | 1054 | 2020-04-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1055 | 1055 | 2020-04-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1056 | 1056 | 2020-04-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1057 | 1057 | 2020-04-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1058 | 1058 | 2020-04-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1059 | 1059 | 2020-04-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1060 | 1060 | 2020-04-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1061 | 1061 | 2020-04-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1062 | 1062 | 2020-04-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1063 | 1063 | 2020-04-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1064 | 1064 | 2020-04-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1065 | 1065 | 2020-04-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1066 | 1066 | 2020-04-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1067 | 1067 | 2020-04-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1068 | 1068 | 2020-04-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1069 | 1069 | 2020-04-21 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1070 | 1070 | 2020-04-22 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1071 | 1071 | 2020-04-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1072 | 1072 | 2020-04-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1073 | 1073 | 2020-04-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1074 | 1074 | 2020-04-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1075 | 1075 | 2020-04-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1076 | 1076 | 2020-04-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1077 | 1077 | 2020-04-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1078 | 1078 | 2020-04-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1079 | 1079 | 2020-05-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1080 | 1080 | 2020-05-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1081 | 1081 | 2020-05-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1082 | 1082 | 2020-05-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1083 | 1083 | 2020-05-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1084 | 1084 | 2020-05-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1085 | 1085 | 2020-05-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1086 | 1086 | 2020-05-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1087 | 1087 | 2020-05-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1088 | 1088 | 2020-05-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1089 | 1089 | 2020-05-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1090 | 1090 | 2020-05-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1091 | 1091 | 2020-05-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1092 | 1092 | 2020-05-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1093 | 1093 | 2020-05-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1094 | 1094 | 2020-05-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1095 | 1095 | 2020-05-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1096 | 1096 | 2020-05-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1097 | 1097 | 2020-05-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1098 | 1098 | 2020-05-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 0 | 0 | 0 | 0 |
1099 | 1099 | 2020-05-21 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 1 | 0 | 0 |
1100 | 1100 | 2020-05-22 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1101 | 1101 | 2020-05-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1102 | 1102 | 2020-05-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1103 | 1103 | 2020-05-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1104 | 1104 | 2020-05-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1105 | 1105 | 2020-05-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1106 | 1106 | 2020-05-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1107 | 1107 | 2020-05-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1108 | 1108 | 2020-05-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1109 | 1109 | 2020-05-31 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1110 | 1110 | 2020-06-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1111 | 1111 | 2020-06-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1112 | 1112 | 2020-06-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1113 | 1113 | 2020-06-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1114 | 1114 | 2020-06-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1115 | 1115 | 2020-06-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1116 | 1116 | 2020-06-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1117 | 1117 | 2020-06-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1118 | 1118 | 2020-06-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1119 | 1119 | 2020-06-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1120 | 1120 | 2020-06-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1121 | 1121 | 2020-06-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1122 | 1122 | 2020-06-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1123 | 1123 | 2020-06-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1124 | 1124 | 2020-06-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1125 | 1125 | 2020-06-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 0 | 0 | 0 |
1126 | 1126 | 2020-06-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1 | 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 );