latimes_place_totals

Table actions
⚠️ 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

26,950 rows where county = "Kern" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

  • 29 26,950

county

  • Kern · 26,950 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
196 196 93203 93203: Arvin 2021-10-27 Kern 29 3914   22471
197 197 93205 93205: Bodfish 2021-10-27 Kern 29 174   1593
198 198 93206 93206: Buttonwillow 2021-10-27 Kern 29 341   2044
199 199 93215 93215: Delano 2021-10-27 Kern 29 10640   55845
200 200 93220 93220: Edison 2021-10-27 Kern 29 21   313
201 201 93222 93222: Pine Mountain Club 2021-10-27 Kern 29 70   1420
202 202 93224 93224: Fellows 2021-10-27 Kern 29 72   402
203 203 93225 93225: Frazier Park 2021-10-27 Kern 29 335   5319
204 204 93226 93226: Glennville 2021-10-27 Kern 29 22   195
205 205 93238 93238: Kernville 2021-10-27 Kern 29 122   1408
206 206 93240 93240: Lake Isabella 2021-10-27 Kern 29 616   6960
207 207 93241 93241: Lamont 2021-10-27 Kern 29 2885   16969
208 208 93243 93243: Lebec 2021-10-27 Kern 29 119   1709
209 209 93249 93249: Lost Hills 2021-10-27 Kern 29 342   2264
210 210 93250 93250: Mc Farland 2021-10-27 Kern 29 2876   15523
211 211 93251 93251: Mc Kittrick 2021-10-27 Kern 29 26   243
212 212 93252 93252: Maricopa 2021-10-27 Kern 29 162   3188
213 213 93255 93255: Onyx 2021-10-27 Kern 29 25   707
214 214 93263 93263: Shafter 2021-10-27 Kern 29 4524   20710
215 215 93268 93268: Taft 2021-10-27 Kern 29 2687   17620
216 216 93276 93276: Tupman 2021-10-27 Kern 29 34   159
217 217 93280 93280: Wasco 2021-10-27 Kern 29 6492   27552
218 218 93283 93283: Weldon 2021-10-27 Kern 29 144   2086
219 219 93285 93285: Wofford Heights 2021-10-27 Kern 29 159   1723
220 220 93287 93287: Woody 2021-10-27 Kern 29 17   74
221 221 93301 93301: Bakersfield 2021-10-27 Kern 29 2639   12345
222 222 93304 93304: Bakersfield 2021-10-27 Kern 29 8825   50787
223 223 93305 93305: Bakersfield 2021-10-27 Kern 29 6211   39114
224 224 93306 93306: Bakersfield 2021-10-27 Kern 29 12790   70208
225 225 93307 93307: Bakersfield 2021-10-27 Kern 29 16028   84948
226 226 93308 93308: Bakersfield 2021-10-27 Kern 29 7732   54042
227 227 93309 93309: Bakersfield 2021-10-27 Kern 29 9766   60893
228 228 93311 93311: Bakersfield 2021-10-27 Kern 29 7354   44862
229 229 93312 93312: Bakersfield 2021-10-27 Kern 29 8838   59359
230 230 93313 93313: Bakersfield 2021-10-27 Kern 29 10429   51245
231 231 93314 93314: Bakersfield 2021-10-27 Kern 29 4979   26992
232 232 93501 93501: Mojave 2021-10-27 Kern 29 614   5063
233 233 93505 93505: California City 2021-10-27 Kern 29 2183   13445
234 234 93516 93516: Boron 2021-10-27 Kern 29 211   2425
235 235 93518 93518: Caliente 2021-10-27 Kern 29 38   995
236 236 93519 93519: Cantil 2021-10-27 Kern 29 1   28
237 237 93523 93523: Edwards 2021-10-27 Kern 29 175   3312
238 238 93524 93524: Edwards 2021-10-27 Kern 29 37   168
239 239 93527 93527: Inyokern 2021-10-27 Kern 29 134   1852
240 240 93528 93528: Johannesburg 2021-10-27 Kern 29 5   124
241 241 93531 93531: Keene 2021-10-27 Kern 29 43   422
242 242 93554 93554: Randsburg 2021-10-27 Kern 29 9   143
243 243 93555 93555: Ridgecrest 2021-10-27 Kern 29 2936   34075
244 244 93560 93560: Rosamond 2021-10-27 Kern 29 3042   20797
245 245 93561 93561: Tehachapi 2021-10-27 Kern 29 5144   34271
1561 1561 93203 93203: Arvin 2021-10-26 Kern 29 3911   22471
1562 1562 93205 93205: Bodfish 2021-10-26 Kern 29 170   1593
1563 1563 93206 93206: Buttonwillow 2021-10-26 Kern 29 341   2044
1564 1564 93215 93215: Delano 2021-10-26 Kern 29 10624   55845
1565 1565 93220 93220: Edison 2021-10-26 Kern 29 21   313
1566 1566 93222 93222: Pine Mountain Club 2021-10-26 Kern 29 70   1420
1567 1567 93224 93224: Fellows 2021-10-26 Kern 29 72   402
1568 1568 93225 93225: Frazier Park 2021-10-26 Kern 29 335   5319
1569 1569 93226 93226: Glennville 2021-10-26 Kern 29 22   195
1570 1570 93238 93238: Kernville 2021-10-26 Kern 29 122   1408
1571 1571 93240 93240: Lake Isabella 2021-10-26 Kern 29 612   6960
1572 1572 93241 93241: Lamont 2021-10-26 Kern 29 2877   16969
1573 1573 93243 93243: Lebec 2021-10-26 Kern 29 119   1709
1574 1574 93249 93249: Lost Hills 2021-10-26 Kern 29 340   2264
1575 1575 93250 93250: Mc Farland 2021-10-26 Kern 29 2864   15523
1576 1576 93251 93251: Mc Kittrick 2021-10-26 Kern 29 26   243
1577 1577 93252 93252: Maricopa 2021-10-26 Kern 29 162   3188
1578 1578 93255 93255: Onyx 2021-10-26 Kern 29 25   707
1579 1579 93263 93263: Shafter 2021-10-26 Kern 29 4507   20710
1580 1580 93268 93268: Taft 2021-10-26 Kern 29 2681   17620
1581 1581 93276 93276: Tupman 2021-10-26 Kern 29 32   159
1582 1582 93280 93280: Wasco 2021-10-26 Kern 29 6468   27552
1583 1583 93283 93283: Weldon 2021-10-26 Kern 29 141   2086
1584 1584 93285 93285: Wofford Heights 2021-10-26 Kern 29 159   1723
1585 1585 93287 93287: Woody 2021-10-26 Kern 29 17   74
1586 1586 93301 93301: Bakersfield 2021-10-26 Kern 29 2635   12345
1587 1587 93304 93304: Bakersfield 2021-10-26 Kern 29 8789   50787
1588 1588 93305 93305: Bakersfield 2021-10-26 Kern 29 6196   39114
1589 1589 93306 93306: Bakersfield 2021-10-26 Kern 29 12763   70208
1590 1590 93307 93307: Bakersfield 2021-10-26 Kern 29 15977   84948
1591 1591 93308 93308: Bakersfield 2021-10-26 Kern 29 7705   54042
1592 1592 93309 93309: Bakersfield 2021-10-26 Kern 29 9744   60893
1593 1593 93311 93311: Bakersfield 2021-10-26 Kern 29 7321   44862
1594 1594 93312 93312: Bakersfield 2021-10-26 Kern 29 8809   59359
1595 1595 93313 93313: Bakersfield 2021-10-26 Kern 29 10403   51245
1596 1596 93314 93314: Bakersfield 2021-10-26 Kern 29 4962   26992
1597 1597 93501 93501: Mojave 2021-10-26 Kern 29 611   5063
1598 1598 93505 93505: California City 2021-10-26 Kern 29 2175   13445
1599 1599 93516 93516: Boron 2021-10-26 Kern 29 208   2425
1600 1600 93518 93518: Caliente 2021-10-26 Kern 29 37   995
1601 1601 93519 93519: Cantil 2021-10-26 Kern 29 1   28
1602 1602 93523 93523: Edwards 2021-10-26 Kern 29 174   3312
1603 1603 93524 93524: Edwards 2021-10-26 Kern 29 37   168
1604 1604 93527 93527: Inyokern 2021-10-26 Kern 29 134   1852
1605 1605 93528 93528: Johannesburg 2021-10-26 Kern 29 5   124
1606 1606 93531 93531: Keene 2021-10-26 Kern 29 43   422
1607 1607 93554 93554: Randsburg 2021-10-26 Kern 29 9   143
1608 1608 93555 93555: Ridgecrest 2021-10-26 Kern 29 2897   34075
1609 1609 93560 93560: Rosamond 2021-10-26 Kern 29 3031   20797
1610 1610 93561 93561: Tehachapi 2021-10-26 Kern 29 5126   34271

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);