home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

46,850 rows where county = "Kern" sorted by date descending

✎ View and edit SQL

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

fips 1

  • 29 46,850

county 1

  • Kern · 46,850 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
36054 36054 93226 93226: Glennville 2022-11-29 Kern 29 49   195
36055 36055 93238 93238: Kernville 2022-11-29 Kern 29 232   1408
36056 36056 93240 93240: Lake Isabella 2022-11-29 Kern 29 1227   6960
36057 36057 93241 93241: Lamont 2022-11-29 Kern 29 5487   16969
36058 36058 93243 93243: Lebec 2022-11-29 Kern 29 274   1709
36059 36059 93249 93249: Lost Hills 2022-11-29 Kern 29 653   2264
36060 36060 93250 93250: Mc Farland 2022-11-29 Kern 29 5242   15523
36061 36061 93251 93251: Mc Kittrick 2022-11-29 Kern 29 69   243
36062 36062 93252 93252: Maricopa 2022-11-29 Kern 29 329   3188
36063 36063 93255 93255: Onyx 2022-11-29 Kern 29 58   707
36064 36064 93263 93263: Shafter 2022-11-29 Kern 29 7849   20710
36065 36065 93268 93268: Taft 2022-11-29 Kern 29 4875   17620
36066 36066 93276 93276: Tupman 2022-11-29 Kern 29 66   159
36067 36067 93280 93280: Wasco 2022-11-29 Kern 29 12817   27552
36068 36068 93283 93283: Weldon 2022-11-29 Kern 29 273   2086
36069 36069 93285 93285: Wofford Heights 2022-11-29 Kern 29 359   1723
36070 36070 93287 93287: Woody 2022-11-29 Kern 29 29   74
36071 36071 93301 93301: Bakersfield 2022-11-29 Kern 29 5243   12345
36072 36072 93304 93304: Bakersfield 2022-11-29 Kern 29 16980   50787
36073 36073 93305 93305: Bakersfield 2022-11-29 Kern 29 12409   39114
36074 36074 93306 93306: Bakersfield 2022-11-29 Kern 29 25062   70208
36075 36075 93307 93307: Bakersfield 2022-11-29 Kern 29 29575   84948
36076 36076 93308 93308: Bakersfield 2022-11-29 Kern 29 15619   54042
36077 36077 93309 93309: Bakersfield 2022-11-29 Kern 29 19512   60893
36078 36078 93311 93311: Bakersfield 2022-11-29 Kern 29 15507   44862
36079 36079 93312 93312: Bakersfield 2022-11-29 Kern 29 18413   59359
36080 36080 93313 93313: Bakersfield 2022-11-29 Kern 29 19701   51245
36081 36081 93314 93314: Bakersfield 2022-11-29 Kern 29 10285   26992
36082 36082 93501 93501: Mojave 2022-11-29 Kern 29 1210   5063
36083 36083 93505 93505: California City 2022-11-29 Kern 29 4236   13445
36084 36084 93516 93516: Boron 2022-11-29 Kern 29 501   2425
36085 36085 93518 93518: Caliente 2022-11-29 Kern 29 111   995
36086 36086 93519 93519: Cantil 2022-11-29 Kern 29 3   28
36087 36087 93523 93523: Edwards 2022-11-29 Kern 29 443   3312
36088 36088 93524 93524: Edwards 2022-11-29 Kern 29 54   168
36089 36089 93203 93203: Arvin 2022-11-29 Kern 29 7141   22471
36090 36090 93205 93205: Bodfish 2022-11-29 Kern 29 384   1593
36091 36091 93206 93206: Buttonwillow 2022-11-29 Kern 29 585   2044
36092 36092 93215 93215: Delano 2022-11-29 Kern 29 22439   55845
36093 36093 93220 93220: Edison 2022-11-29 Kern 29 37   313
36094 36094 93222 93222: Pine Mountain Club 2022-11-29 Kern 29 198   1420
36095 36095 93224 93224: Fellows 2022-11-29 Kern 29 110   402
36096 36096 93225 93225: Frazier Park 2022-11-29 Kern 29 909   5319
36097 36097 93527 93527: Inyokern 2022-11-29 Kern 29 379   1852
36098 36098 93528 93528: Johannesburg 2022-11-29 Kern 29 17   124
36099 36099 93531 93531: Keene 2022-11-29 Kern 29 94   422
36100 36100 93554 93554: Randsburg 2022-11-29 Kern 29 11   143
36101 36101 93555 93555: Ridgecrest 2022-11-29 Kern 29 7502   34075
36102 36102 93560 93560: Rosamond 2022-11-29 Kern 29 5982   20797
36103 36103 93561 93561: Tehachapi 2022-11-29 Kern 29 10193   34271
37285 37285 93226 93226: Glennville 2022-11-28 Kern 29 49   195
37286 37286 93238 93238: Kernville 2022-11-28 Kern 29 232   1408
37287 37287 93240 93240: Lake Isabella 2022-11-28 Kern 29 1227   6960
37288 37288 93241 93241: Lamont 2022-11-28 Kern 29 5487   16969
37289 37289 93243 93243: Lebec 2022-11-28 Kern 29 274   1709
37290 37290 93249 93249: Lost Hills 2022-11-28 Kern 29 653   2264
37291 37291 93250 93250: Mc Farland 2022-11-28 Kern 29 5242   15523
37292 37292 93251 93251: Mc Kittrick 2022-11-28 Kern 29 69   243
37293 37293 93252 93252: Maricopa 2022-11-28 Kern 29 329   3188
37294 37294 93255 93255: Onyx 2022-11-28 Kern 29 58   707
37295 37295 93263 93263: Shafter 2022-11-28 Kern 29 7849   20710
37296 37296 93268 93268: Taft 2022-11-28 Kern 29 4875   17620
37297 37297 93276 93276: Tupman 2022-11-28 Kern 29 66   159
37298 37298 93280 93280: Wasco 2022-11-28 Kern 29 12817   27552
37299 37299 93283 93283: Weldon 2022-11-28 Kern 29 273   2086
37300 37300 93285 93285: Wofford Heights 2022-11-28 Kern 29 359   1723
37301 37301 93287 93287: Woody 2022-11-28 Kern 29 29   74
37302 37302 93301 93301: Bakersfield 2022-11-28 Kern 29 5243   12345
37303 37303 93304 93304: Bakersfield 2022-11-28 Kern 29 16980   50787
37304 37304 93305 93305: Bakersfield 2022-11-28 Kern 29 12409   39114
37305 37305 93306 93306: Bakersfield 2022-11-28 Kern 29 25062   70208
37306 37306 93307 93307: Bakersfield 2022-11-28 Kern 29 29575   84948
37307 37307 93308 93308: Bakersfield 2022-11-28 Kern 29 15619   54042
37308 37308 93309 93309: Bakersfield 2022-11-28 Kern 29 19512   60893
37309 37309 93311 93311: Bakersfield 2022-11-28 Kern 29 15507   44862
37310 37310 93312 93312: Bakersfield 2022-11-28 Kern 29 18413   59359
37311 37311 93313 93313: Bakersfield 2022-11-28 Kern 29 19701   51245
37312 37312 93314 93314: Bakersfield 2022-11-28 Kern 29 10285   26992
37313 37313 93501 93501: Mojave 2022-11-28 Kern 29 1210   5063
37314 37314 93505 93505: California City 2022-11-28 Kern 29 4236   13445
37315 37315 93516 93516: Boron 2022-11-28 Kern 29 501   2425
37316 37316 93518 93518: Caliente 2022-11-28 Kern 29 111   995
37317 37317 93519 93519: Cantil 2022-11-28 Kern 29 3   28
37318 37318 93523 93523: Edwards 2022-11-28 Kern 29 443   3312
37319 37319 93524 93524: Edwards 2022-11-28 Kern 29 54   168
37320 37320 93203 93203: Arvin 2022-11-28 Kern 29 7141   22471
37321 37321 93205 93205: Bodfish 2022-11-28 Kern 29 384   1593
37322 37322 93206 93206: Buttonwillow 2022-11-28 Kern 29 585   2044
37323 37323 93215 93215: Delano 2022-11-28 Kern 29 22439   55845
37324 37324 93220 93220: Edison 2022-11-28 Kern 29 37   313
37325 37325 93222 93222: Pine Mountain Club 2022-11-28 Kern 29 198   1420
37326 37326 93224 93224: Fellows 2022-11-28 Kern 29 110   402
37327 37327 93225 93225: Frazier Park 2022-11-28 Kern 29 909   5319
37328 37328 93527 93527: Inyokern 2022-11-28 Kern 29 379   1852
37329 37329 93528 93528: Johannesburg 2022-11-28 Kern 29 17   124
37330 37330 93531 93531: Keene 2022-11-28 Kern 29 94   422
37331 37331 93554 93554: Randsburg 2022-11-28 Kern 29 11   143
37332 37332 93555 93555: Ridgecrest 2022-11-28 Kern 29 7502   34075
37333 37333 93560 93560: Rosamond 2022-11-28 Kern 29 5982   20797
37334 37334 93561 93561: Tehachapi 2022-11-28 Kern 29 10193   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
);
Powered by Datasette · Queries took 4364.735ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals