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

50 rows where county = "Kern", "date" is on date 2021-04-17 and fips = 29 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Kern · 50 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
785672 785672 93226 93226: Glennville 2021-04-17 Kern 29 17   195
785673 785673 93238 93238: Kernville 2021-04-17 Kern 29 69   1408
785674 785674 93240 93240: Lake Isabella 2021-04-17 Kern 29 283   6960
785675 785675 93241 93241: Lamont 2021-04-17 Kern 29 2258   16969
785676 785676 93243 93243: Lebec 2021-04-17 Kern 29 98   1709
785677 785677 93249 93249: Lost Hills 2021-04-17 Kern 29 280   2264
785678 785678 93250 93250: Mc Farland 2021-04-17 Kern 29 2273   15523
785679 785679 93251 93251: Mc Kittrick 2021-04-17 Kern 29 22   243
785680 785680 93252 93252: Maricopa 2021-04-17 Kern 29 113   3188
785681 785681 93255 93255: Onyx 2021-04-17 Kern 29 15   707
785682 785682 93263 93263: Shafter 2021-04-17 Kern 29 3525   20710
785683 785683 93268 93268: Taft 2021-04-17 Kern 29 1728   17620
785684 785684 93276 93276: Tupman 2021-04-17 Kern 29 12   159
785685 785685 93280 93280: Wasco 2021-04-17 Kern 29 5388   27552
785686 785686 93283 93283: Weldon 2021-04-17 Kern 29 58   2086
785687 785687 93285 93285: Wofford Heights 2021-04-17 Kern 29 76   1723
785688 785688 93287 93287: Woody 2021-04-17 Kern 29 14   74
785689 785689 93301 93301: Bakersfield 2021-04-17 Kern 29 1780   12345
785690 785690 93304 93304: Bakersfield 2021-04-17 Kern 29 6285   50787
785691 785691 93305 93305: Bakersfield 2021-04-17 Kern 29 4396   39114
785692 785692 93306 93306: Bakersfield 2021-04-17 Kern 29 9378   70208
785693 785693 93307 93307: Bakersfield 2021-04-17 Kern 29 12026   84948
785694 785694 93308 93308: Bakersfield 2021-04-17 Kern 29 4798   54042
785695 785695 93309 93309: Bakersfield 2021-04-17 Kern 29 6972   60893
785696 785696 93311 93311: Bakersfield 2021-04-17 Kern 29 5128   44862
785697 785697 93312 93312: Bakersfield 2021-04-17 Kern 29 5944   59359
785698 785698 93313 93313: Bakersfield 2021-04-17 Kern 29 7780   51245
785699 785699 93314 93314: Bakersfield 2021-04-17 Kern 29 3372   26992
785700 785700 93501 93501: Mojave 2021-04-17 Kern 29 443   5063
785701 785701 93505 93505: California City 2021-04-17 Kern 29 1690   13445
785702 785702 93516 93516: Boron 2021-04-17 Kern 29 114   2425
785703 785703 93518 93518: Caliente 2021-04-17 Kern 29 24   995
785704 785704 93519 93519: Cantil 2021-04-17 Kern 29 1   28
785705 785705 93523 93523: Edwards 2021-04-17 Kern 29 75   3312
785706 785706 93524 93524: Edwards 2021-04-17 Kern 29 3   168
785707 785707 93203 93203: Arvin 2021-04-17 Kern 29 3080   22471
785708 785708 93205 93205: Bodfish 2021-04-17 Kern 29 75   1593
785709 785709 93206 93206: Buttonwillow 2021-04-17 Kern 29 280   2044
785710 785710 93215 93215: Delano 2021-04-17 Kern 29 8565   55845
785711 785711 93220 93220: Edison 2021-04-17 Kern 29 18   313
785712 785712 93222 93222: Pine Mountain Club 2021-04-17 Kern 29 50   1420
785713 785713 93224 93224: Fellows 2021-04-17 Kern 29 40   402
785714 785714 93225 93225: Frazier Park 2021-04-17 Kern 29 245   5319
785715 785715 93527 93527: Inyokern 2021-04-17 Kern 29 90   1852
785716 785716 93528 93528: Johannesburg 2021-04-17 Kern 29 3   124
785717 785717 93531 93531: Keene 2021-04-17 Kern 29 28   422
785718 785718 93554 93554: Randsburg 2021-04-17 Kern 29 9   143
785719 785719 93555 93555: Ridgecrest 2021-04-17 Kern 29 2193   34075
785720 785720 93560 93560: Rosamond 2021-04-17 Kern 29 2164   20797
785721 785721 93561 93561: Tehachapi 2021-04-17 Kern 29 3786   34271

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
);