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

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

View and edit SQL

fips

  • 29 16,950

county

  • Kern · 16,950
Link rowid id name date ▲ county fips confirmed_cases note population
195 93203 93203: Arvin 2021-04-10 Kern 29 3077   22471
196 93205 93205: Bodfish 2021-04-10 Kern 29 75   1593
197 93206 93206: Buttonwillow 2021-04-10 Kern 29 278   2044
198 93215 93215: Delano 2021-04-10 Kern 29 8534   55845
199 93220 93220: Edison 2021-04-10 Kern 29 18   313
200 93222 93222: Pine Mountain Club 2021-04-10 Kern 29 48   1420
201 93224 93224: Fellows 2021-04-10 Kern 29 40   402
202 93225 93225: Frazier Park 2021-04-10 Kern 29 243   5319
203 93226 93226: Glennville 2021-04-10 Kern 29 17   195
204 93238 93238: Kernville 2021-04-10 Kern 29 69   1408
205 93240 93240: Lake Isabella 2021-04-10 Kern 29 283   6960
206 93241 93241: Lamont 2021-04-10 Kern 29 2251   16969
207 93243 93243: Lebec 2021-04-10 Kern 29 97   1709
208 93249 93249: Lost Hills 2021-04-10 Kern 29 280   2264
209 93250 93250: Mc Farland 2021-04-10 Kern 29 2272   15523
210 93251 93251: Mc Kittrick 2021-04-10 Kern 29 22   243
211 93252 93252: Maricopa 2021-04-10 Kern 29 109   3188
212 93255 93255: Onyx 2021-04-10 Kern 29 15   707
213 93263 93263: Shafter 2021-04-10 Kern 29 3517   20710
214 93268 93268: Taft 2021-04-10 Kern 29 1717   17620
215 93276 93276: Tupman 2021-04-10 Kern 29 12   159
216 93280 93280: Wasco 2021-04-10 Kern 29 5363   27552
217 93283 93283: Weldon 2021-04-10 Kern 29 55   2086
218 93285 93285: Wofford Heights 2021-04-10 Kern 29 77   1723
219 93287 93287: Woody 2021-04-10 Kern 29 14   74
220 93301 93301: Bakersfield 2021-04-10 Kern 29 1769   12345
221 93304 93304: Bakersfield 2021-04-10 Kern 29 6241   50787
222 93305 93305: Bakersfield 2021-04-10 Kern 29 4363   39114
223 93306 93306: Bakersfield 2021-04-10 Kern 29 9312   70208
224 93307 93307: Bakersfield 2021-04-10 Kern 29 11941   84948
225 93308 93308: Bakersfield 2021-04-10 Kern 29 4760   54042
226 93309 93309: Bakersfield 2021-04-10 Kern 29 6923   60893
227 93311 93311: Bakersfield 2021-04-10 Kern 29 5097   44862
228 93312 93312: Bakersfield 2021-04-10 Kern 29 5919   59359
229 93313 93313: Bakersfield 2021-04-10 Kern 29 7723   51245
230 93314 93314: Bakersfield 2021-04-10 Kern 29 3336   26992
231 93501 93501: Mojave 2021-04-10 Kern 29 440   5063
232 93505 93505: California City 2021-04-10 Kern 29 1685   13445
233 93516 93516: Boron 2021-04-10 Kern 29 114   2425
234 93518 93518: Caliente 2021-04-10 Kern 29 23   995
235 93519 93519: Cantil 2021-04-10 Kern 29 1   28
236 93523 93523: Edwards 2021-04-10 Kern 29 73   3312
237 93524 93524: Edwards 2021-04-10 Kern 29 3   168
238 93527 93527: Inyokern 2021-04-10 Kern 29 87   1852
239 93528 93528: Johannesburg 2021-04-10 Kern 29 3   124
240 93531 93531: Keene 2021-04-10 Kern 29 28   422
241 93554 93554: Randsburg 2021-04-10 Kern 29 9   143
242 93555 93555: Ridgecrest 2021-04-10 Kern 29 2165   34075
243 93560 93560: Rosamond 2021-04-10 Kern 29 2150   20797
244 93561 93561: Tehachapi 2021-04-10 Kern 29 3774   34271
1562 93203 93203: Arvin 2021-04-09 Kern 29 3076   22471
1563 93205 93205: Bodfish 2021-04-09 Kern 29 75   1593
1564 93206 93206: Buttonwillow 2021-04-09 Kern 29 278   2044
1565 93215 93215: Delano 2021-04-09 Kern 29 8534   55845
1566 93220 93220: Edison 2021-04-09 Kern 29 18   313
1567 93222 93222: Pine Mountain Club 2021-04-09 Kern 29 48   1420
1568 93224 93224: Fellows 2021-04-09 Kern 29 40   402
1569 93225 93225: Frazier Park 2021-04-09 Kern 29 243   5319
1570 93226 93226: Glennville 2021-04-09 Kern 29 17   195
1571 93238 93238: Kernville 2021-04-09 Kern 29 69   1408
1572 93240 93240: Lake Isabella 2021-04-09 Kern 29 283   6960
1573 93241 93241: Lamont 2021-04-09 Kern 29 2248   16969
1574 93243 93243: Lebec 2021-04-09 Kern 29 97   1709
1575 93249 93249: Lost Hills 2021-04-09 Kern 29 280   2264
1576 93250 93250: Mc Farland 2021-04-09 Kern 29 2272   15523
1577 93251 93251: Mc Kittrick 2021-04-09 Kern 29 22   243
1578 93252 93252: Maricopa 2021-04-09 Kern 29 108   3188
1579 93255 93255: Onyx 2021-04-09 Kern 29 15   707
1580 93263 93263: Shafter 2021-04-09 Kern 29 3516   20710
1581 93268 93268: Taft 2021-04-09 Kern 29 1708   17620
1582 93276 93276: Tupman 2021-04-09 Kern 29 12   159
1583 93280 93280: Wasco 2021-04-09 Kern 29 5360   27552
1584 93283 93283: Weldon 2021-04-09 Kern 29 55   2086
1585 93285 93285: Wofford Heights 2021-04-09 Kern 29 77   1723
1586 93287 93287: Woody 2021-04-09 Kern 29 14   74
1587 93301 93301: Bakersfield 2021-04-09 Kern 29 1766   12345
1588 93304 93304: Bakersfield 2021-04-09 Kern 29 6232   50787
1589 93305 93305: Bakersfield 2021-04-09 Kern 29 4350   39114
1590 93306 93306: Bakersfield 2021-04-09 Kern 29 9288   70208
1591 93307 93307: Bakersfield 2021-04-09 Kern 29 11918   84948
1592 93308 93308: Bakersfield 2021-04-09 Kern 29 4744   54042
1593 93309 93309: Bakersfield 2021-04-09 Kern 29 6907   60893
1594 93311 93311: Bakersfield 2021-04-09 Kern 29 5088   44862
1595 93312 93312: Bakersfield 2021-04-09 Kern 29 5908   59359
1596 93313 93313: Bakersfield 2021-04-09 Kern 29 7707   51245
1597 93314 93314: Bakersfield 2021-04-09 Kern 29 3334   26992
1598 93501 93501: Mojave 2021-04-09 Kern 29 439   5063
1599 93505 93505: California City 2021-04-09 Kern 29 1681   13445
1600 93516 93516: Boron 2021-04-09 Kern 29 114   2425
1601 93518 93518: Caliente 2021-04-09 Kern 29 23   995
1602 93519 93519: Cantil 2021-04-09 Kern 29 1   28
1603 93523 93523: Edwards 2021-04-09 Kern 29 73   3312
1604 93524 93524: Edwards 2021-04-09 Kern 29 3   168
1605 93527 93527: Inyokern 2021-04-09 Kern 29 87   1852
1606 93528 93528: Johannesburg 2021-04-09 Kern 29 3   124
1607 93531 93531: Keene 2021-04-09 Kern 29 28   422
1608 93554 93554: Randsburg 2021-04-09 Kern 29 9   143
1609 93555 93555: Ridgecrest 2021-04-09 Kern 29 2154   34075
1610 93560 93560: Rosamond 2021-04-09 Kern 29 2147   20797
1611 93561 93561: Tehachapi 2021-04-09 Kern 29 3771   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
);