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 2021-12-11 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
481935 481935 Auberry Auberry 2021-12-11 Fresno 19 215   3994
481936 481936 Biola Biola 2021-12-11 Fresno 19 254   949
481937 481937 Cantua Creek Cantua Creek 2021-12-11 Fresno 19 176   1125
481938 481938 Caruthers Caruthers 2021-12-11 Fresno 19 990   5887
481939 481939 Clovis Clovis 2021-12-11 Fresno 19 12738   122949
481940 481940 Coalinga Coalinga 2021-12-11 Fresno 19 4446   19345
481941 481941 Del Rey Del Rey 2021-12-11 Fresno 19 422   2759
481942 481942 Dinuba Dinuba 2021-12-11 Fresno 19 0   0
481943 481943 Dos Palos Dos Palos 2021-12-11 Fresno 19 0    
481944 481944 Dunlap Dunlap 2021-12-11 Fresno 19 6    
481945 481945 Firebaugh Firebaugh 2021-12-11 Fresno 19 1431   9965
481946 481946 Five Points Five Points 2021-12-11 Fresno 19 23   0
481947 481947 Fowler Fowler 2021-12-11 Fresno 19 1446   7917
481948 481948 Fresno Fresno 2021-12-11 Fresno 19 61638   608579
481949 481949 Friant Friant 2021-12-11 Fresno 19 117   1930
481950 481950 Huron Huron 2021-12-11 Fresno 19 1034   7579
481951 481951 Kerman Kerman 2021-12-11 Fresno 19 3376   21009
481952 481952 Kingsburg Kingsburg 2021-12-11 Fresno 19 1947   17086
481953 481953 Laton Laton 2021-12-11 Fresno 19 522   3513
481954 481954 Mendota Mendota 2021-12-11 Fresno 19 2112   13576
481955 481955 Orange Cove Orange Cove 2021-12-11 Fresno 19 2136   11320
481956 481956 Parlier Parlier 2021-12-11 Fresno 19 3407   17097
481957 481957 Prather Prather 2021-12-11 Fresno 19 107   0
481958 481958 Raisin Raisin 2021-12-11 Fresno 19 91   380
481959 481959 Reedley Reedley 2021-12-11 Fresno 19 4864   31129
481960 481960 Riverdale Riverdale 2021-12-11 Fresno 19 1064   6459
481961 481961 San Joaquin San Joaquin 2021-12-11 Fresno 19 716   4633
481962 481962 Sanger Sanger 2021-12-11 Fresno 19 6292   38252
481963 481963 Selma Selma 2021-12-11 Fresno 19 5913   31726
481964 481964 Squaw Valley Squaw Valley 2021-12-11 Fresno 19 207   3908
481965 481965 Tollhouse Tollhouse 2021-12-11 Fresno 19 150   2712
481966 481966 Tranquillity Tranquillity 2021-12-11 Fresno 19 153   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
);