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 "date" is on date 2020-04-20 and fips = 19 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

Link rowid id name date ▲ county fips confirmed_cases note population
1222197 1222197 Auberry Auberry 2020-04-20 Fresno 19 0   3994
1222198 1222198 Biola Biola 2020-04-20 Fresno 19 0   949
1222199 1222199 Cantua Creek Cantua Creek 2020-04-20 Fresno 19 0   1125
1222200 1222200 Caruthers Caruthers 2020-04-20 Fresno 19 0   5887
1222201 1222201 Clovis Clovis 2020-04-20 Fresno 19 32   122949
1222202 1222202 Coalinga Coalinga 2020-04-20 Fresno 19 4 4 or fewer 19345
1222203 1222203 Del Rey Del Rey 2020-04-20 Fresno 19 0   2759
1222204 1222204 Dinuba Dinuba 2020-04-20 Fresno 19 0   0
1222205 1222205 Dos Palos Dos Palos 2020-04-20 Fresno 19 0    
1222206 1222206 Dunlap Dunlap 2020-04-20 Fresno 19 0    
1222207 1222207 Firebaugh Firebaugh 2020-04-20 Fresno 19 17   9965
1222208 1222208 Five Points Five Points 2020-04-20 Fresno 19 0   0
1222209 1222209 Fowler Fowler 2020-04-20 Fresno 19 4 4 or fewer 7917
1222210 1222210 Fresno Fresno 2020-04-20 Fresno 19 189   608579
1222211 1222211 Friant Friant 2020-04-20 Fresno 19 0   1930
1222212 1222212 Huron Huron 2020-04-20 Fresno 19 8   7579
1222213 1222213 Kerman Kerman 2020-04-20 Fresno 19 4 4 or fewer 21009
1222214 1222214 Kingsburg Kingsburg 2020-04-20 Fresno 19 10   17086
1222215 1222215 Laton Laton 2020-04-20 Fresno 19 0   3513
1222216 1222216 Mendota Mendota 2020-04-20 Fresno 19 13   13576
1222217 1222217 Orange Cove Orange Cove 2020-04-20 Fresno 19 6   11320
1222218 1222218 Parlier Parlier 2020-04-20 Fresno 19 16   17097
1222219 1222219 Prather Prather 2020-04-20 Fresno 19 0   0
1222220 1222220 Raisin Raisin 2020-04-20 Fresno 19 0   380
1222221 1222221 Reedley Reedley 2020-04-20 Fresno 19 11   31129
1222222 1222222 Riverdale Riverdale 2020-04-20 Fresno 19 0   6459
1222223 1222223 San Joaquin San Joaquin 2020-04-20 Fresno 19 4 4 or fewer 4633
1222224 1222224 Sanger Sanger 2020-04-20 Fresno 19 15   38252
1222225 1222225 Selma Selma 2020-04-20 Fresno 19 15   31726
1222226 1222226 Squaw Valley Squaw Valley 2020-04-20 Fresno 19 0   3908
1222227 1222227 Tollhouse Tollhouse 2020-04-20 Fresno 19 0   2712
1222228 1222228 Tranquillity Tranquillity 2020-04-20 Fresno 19 0   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
);