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

32 rows where county = "Fresno", "date" is on date 2022-01-25 and fips = 19 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Fresno · 32 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
424758 424758 Auberry Auberry 2022-01-25 Fresno 19 242   3994
424759 424759 Biola Biola 2022-01-25 Fresno 19 274   949
424760 424760 Cantua Creek Cantua Creek 2022-01-25 Fresno 19 189   1125
424761 424761 Caruthers Caruthers 2022-01-25 Fresno 19 1042   5887
424762 424762 Clovis Clovis 2022-01-25 Fresno 19 14480   122949
424763 424763 Coalinga Coalinga 2022-01-25 Fresno 19 4672   19345
424764 424764 Del Rey Del Rey 2022-01-25 Fresno 19 449   2759
424765 424765 Dinuba Dinuba 2022-01-25 Fresno 19 0   0
424766 424766 Dos Palos Dos Palos 2022-01-25 Fresno 19 0    
424767 424767 Dunlap Dunlap 2022-01-25 Fresno 19 6    
424768 424768 Firebaugh Firebaugh 2022-01-25 Fresno 19 1527   9965
424769 424769 Five Points Five Points 2022-01-25 Fresno 19 23   0
424770 424770 Fowler Fowler 2022-01-25 Fresno 19 1548   7917
424771 424771 Fresno Fresno 2022-01-25 Fresno 19 61638   608579
424772 424772 Friant Friant 2022-01-25 Fresno 19 148   1930
424773 424773 Huron Huron 2022-01-25 Fresno 19 1088   7579
424774 424774 Kerman Kerman 2022-01-25 Fresno 19 3617   21009
424775 424775 Kingsburg Kingsburg 2022-01-25 Fresno 19 2120   17086
424776 424776 Laton Laton 2022-01-25 Fresno 19 554   3513
424777 424777 Mendota Mendota 2022-01-25 Fresno 19 2222   13576
424778 424778 Orange Cove Orange Cove 2022-01-25 Fresno 19 2238   11320
424779 424779 Parlier Parlier 2022-01-25 Fresno 19 3569   17097
424780 424780 Prather Prather 2022-01-25 Fresno 19 120   0
424781 424781 Raisin Raisin 2022-01-25 Fresno 19 94   380
424782 424782 Reedley Reedley 2022-01-25 Fresno 19 5204   31129
424783 424783 Riverdale Riverdale 2022-01-25 Fresno 19 1129   6459
424784 424784 San Joaquin San Joaquin 2022-01-25 Fresno 19 754   4633
424785 424785 Sanger Sanger 2022-01-25 Fresno 19 6894   38252
424786 424786 Selma Selma 2022-01-25 Fresno 19 6307   31726
424787 424787 Squaw Valley Squaw Valley 2022-01-25 Fresno 19 231   3908
424788 424788 Tollhouse Tollhouse 2022-01-25 Fresno 19 164   2712
424789 424789 Tranquillity Tranquillity 2022-01-25 Fresno 19 167   1132

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