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

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

✎ View and edit SQL

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

fips

  • 29 16,950

county

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