latimes_place_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

6,886 rows where fips = 29 sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 29 · 6,886

county

Link rowid date ▲ county fips place confirmed_cases note x y
127 2020-10-30 Kern 29 93203: Arvin 1314   -118.845976 35.196467
128 2020-10-30 Kern 29 93205: Bodfish 7   -118.508875 35.568924
129 2020-10-30 Kern 29 93206: Buttonwillow 121   -119.47438 35.418624
130 2020-10-30 Kern 29 93215: Delano 2279   -119.304631 35.754264
131 2020-10-30 Kern 29 93220: Edison 3   -118.875922 35.3464
132 2020-10-30 Kern 29 93222: Pine Mountain Club 6   -119.206571 34.843183
133 2020-10-30 Kern 29 93224: Fellows 3   -119.556497 35.178493
134 2020-10-30 Kern 29 93225: Frazier Park 37   -118.990444 34.810422
135 2020-10-30 Kern 29 93226: Glennville 3   -118.729746 35.723529
136 2020-10-30 Kern 29 93238: Kernville 18   -118.504448 35.73311
137 2020-10-30 Kern 29 93240: Lake Isabella 50   -118.51853 35.637717
138 2020-10-30 Kern 29 93241: Lamont 1027   -118.930775 35.263374
139 2020-10-30 Kern 29 93243: Lebec 15   -118.934489 34.840174
140 2020-10-30 Kern 29 93249: Lost Hills 96   -119.709567 35.633765
141 2020-10-30 Kern 29 93250: Mc Farland 978   -119.284618 35.678053
142 2020-10-30 Kern 29 93252: Maricopa 25   -119.423844 35.050872
143 2020-10-30 Kern 29 93263: Shafter 1343   -119.294577 35.481604
144 2020-10-30 Kern 29 93268: Taft 564   -119.468953 35.126049
145 2020-10-30 Kern 29 93276: Tupman 2   -119.364401 35.29931
146 2020-10-30 Kern 29 93280: Wasco 1612   -119.406818 35.58496
147 2020-10-30 Kern 29 93283: Weldon 10   -118.384148 35.643632
148 2020-10-30 Kern 29 93285: Wofford Heights 16   -118.511663 35.710558
149 2020-10-30 Kern 29 93287: Woody 2   -118.836405 35.703491
150 2020-10-30 Kern 29 93301: Bakersfield 617   -119.0169 35.3874
151 2020-10-30 Kern 29 93304: Bakersfield 2307   -119.0285 35.3441
152 2020-10-30 Kern 29 93305: Bakersfield 1595   -118.982 35.3965
153 2020-10-30 Kern 29 93306: Bakersfield 3298   -118.7898 35.4516
154 2020-10-30 Kern 29 93307: Bakersfield 4691   -118.9762 35.2421
155 2020-10-30 Kern 29 93308: Bakersfield 1465   -118.9063 35.5217
156 2020-10-30 Kern 29 93309: Bakersfield 2330   -119.0576 35.3516
157 2020-10-30 Kern 29 93311: Bakersfield 1555   -119.1856 35.1269
158 2020-10-30 Kern 29 93312: Bakersfield 1575   -119.1274 35.3734
159 2020-10-30 Kern 29 93313: Bakersfield 2530   -119.0227 35.1091
160 2020-10-30 Kern 29 93314: Bakersfield 826   -119.2088 35.3821
161 2020-10-30 Kern 29 93501: Mojave 58   -118.194488 35.023791
162 2020-10-30 Kern 29 93505: California City 136   -117.879958 35.16675
163 2020-10-30 Kern 29 93516: Boron 10   -117.670056 35.018887
164 2020-10-30 Kern 29 93518: Caliente 2   -118.628869 35.291223
165 2020-10-30 Kern 29 93523: Edwards 17   -117.862804 34.971263
166 2020-10-30 Kern 29 93524: Edwards 1   -117.908625 34.931747
167 2020-10-30 Kern 29 93527: Inyokern 9   -117.805113 35.640156
168 2020-10-30 Kern 29 93531: Keene 6   -118.562992 35.219588
169 2020-10-30 Kern 29 93555: Ridgecrest 139   -117.670833 35.6225
170 2020-10-30 Kern 29 93560: Rosamond 329   -118.219949 34.857685
171 2020-10-30 Kern 29 93561: Tehachapi 1164   -118.447687 35.129115
1121 2020-10-29 Kern 29 93203: Arvin 1310   -118.845976 35.196467
1122 2020-10-29 Kern 29 93205: Bodfish 7   -118.508875 35.568924
1123 2020-10-29 Kern 29 93206: Buttonwillow 120   -119.47438 35.418624
1124 2020-10-29 Kern 29 93215: Delano 2271   -119.304631 35.754264
1125 2020-10-29 Kern 29 93220: Edison 3   -118.875922 35.3464
1126 2020-10-29 Kern 29 93222: Pine Mountain Club 6   -119.206571 34.843183
1127 2020-10-29 Kern 29 93224: Fellows 3   -119.556497 35.178493
1128 2020-10-29 Kern 29 93225: Frazier Park 37   -118.990444 34.810422
1129 2020-10-29 Kern 29 93226: Glennville 3   -118.729746 35.723529
1130 2020-10-29 Kern 29 93238: Kernville 18   -118.504448 35.73311
1131 2020-10-29 Kern 29 93240: Lake Isabella 49   -118.51853 35.637717
1132 2020-10-29 Kern 29 93241: Lamont 1024   -118.930775 35.263374
1133 2020-10-29 Kern 29 93243: Lebec 15   -118.934489 34.840174
1134 2020-10-29 Kern 29 93249: Lost Hills 95   -119.709567 35.633765
1135 2020-10-29 Kern 29 93250: Mc Farland 976   -119.284618 35.678053
1136 2020-10-29 Kern 29 93252: Maricopa 25   -119.423844 35.050872
1137 2020-10-29 Kern 29 93263: Shafter 1333   -119.294577 35.481604
1138 2020-10-29 Kern 29 93268: Taft 559   -119.468953 35.126049
1139 2020-10-29 Kern 29 93276: Tupman 2   -119.364401 35.29931
1140 2020-10-29 Kern 29 93280: Wasco 1613   -119.406818 35.58496
1141 2020-10-29 Kern 29 93283: Weldon 10   -118.384148 35.643632
1142 2020-10-29 Kern 29 93285: Wofford Heights 16   -118.511663 35.710558
1143 2020-10-29 Kern 29 93287: Woody 2   -118.836405 35.703491
1144 2020-10-29 Kern 29 93301: Bakersfield 614   -119.0169 35.3874
1145 2020-10-29 Kern 29 93304: Bakersfield 2304   -119.0285 35.3441
1146 2020-10-29 Kern 29 93305: Bakersfield 1591   -118.982 35.3965
1147 2020-10-29 Kern 29 93306: Bakersfield 3280   -118.7898 35.4516
1148 2020-10-29 Kern 29 93307: Bakersfield 4674   -118.9762 35.2421
1149 2020-10-29 Kern 29 93308: Bakersfield 1449   -118.9063 35.5217
1150 2020-10-29 Kern 29 93309: Bakersfield 2319   -119.0576 35.3516
1151 2020-10-29 Kern 29 93311: Bakersfield 1547   -119.1856 35.1269
1152 2020-10-29 Kern 29 93312: Bakersfield 1573   -119.1274 35.3734
1153 2020-10-29 Kern 29 93313: Bakersfield 2516   -119.0227 35.1091
1154 2020-10-29 Kern 29 93314: Bakersfield 819   -119.2088 35.3821
1155 2020-10-29 Kern 29 93501: Mojave 57   -118.194488 35.023791
1156 2020-10-29 Kern 29 93505: California City 133   -117.879958 35.16675
1157 2020-10-29 Kern 29 93516: Boron 9   -117.670056 35.018887
1158 2020-10-29 Kern 29 93518: Caliente 2   -118.628869 35.291223
1159 2020-10-29 Kern 29 93523: Edwards 17   -117.862804 34.971263
1160 2020-10-29 Kern 29 93524: Edwards 1   -117.908625 34.931747
1161 2020-10-29 Kern 29 93527: Inyokern 9   -117.805113 35.640156
1162 2020-10-29 Kern 29 93531: Keene 6   -118.562992 35.219588
1163 2020-10-29 Kern 29 93555: Ridgecrest 137   -117.670833 35.6225
1164 2020-10-29 Kern 29 93560: Rosamond 325   -118.219949 34.857685
1165 2020-10-29 Kern 29 93561: Tehachapi 1161   -118.447687 35.129115
2122 2020-10-28 Kern 29 93203: Arvin 1310   -118.845976 35.196467
2123 2020-10-28 Kern 29 93205: Bodfish 7   -118.508875 35.568924
2124 2020-10-28 Kern 29 93206: Buttonwillow 120   -119.47438 35.418624
2125 2020-10-28 Kern 29 93215: Delano 2263   -119.304631 35.754264
2126 2020-10-28 Kern 29 93220: Edison 3   -118.875922 35.3464
2127 2020-10-28 Kern 29 93222: Pine Mountain Club 6   -119.206571 34.843183
2128 2020-10-28 Kern 29 93224: Fellows 3   -119.556497 35.178493
2129 2020-10-28 Kern 29 93225: Frazier Park 37   -118.990444 34.810422
2130 2020-10-28 Kern 29 93226: Glennville 2   -118.729746 35.723529
2131 2020-10-28 Kern 29 93238: Kernville 18   -118.504448 35.73311

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 957.53ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals