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

27 rows where county = "Monterey", "date" is on date 2021-02-03 and fips = 53 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Monterey · 27 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
879323 879323 93426 93426: Bradley 2021-02-03 Monterey 53 23   1604
879324 879324 93901 93901: Salinas 2021-02-03 Monterey 53 2322   27805
879325 879325 93905 93905: Salinas 2021-02-03 Monterey 53 8385   60408
879326 879326 93906 93906: Salinas 2021-02-03 Monterey 53 7033   65256
879327 879327 93907 93907: Salinas 2021-02-03 Monterey 53 1591   22766
879328 879328 93908 93908: Salinas 2021-02-03 Monterey 53 464   12093
879329 879329 93912 93912: Boronda 2021-02-03 Monterey 53 112   0
879330 879330 93920 93920: Big Sur 2021-02-03 Monterey 53 48   1403
879331 879331 93921 93921: Carmel 2021-02-03 Monterey 53 27   3379
879332 879332 93922 93922: Carmel 2021-02-03 Monterey 53 19   0
879333 879333 93923 93923: Carmel 2021-02-03 Monterey 53 187   12833
879334 879334 93924 93924: Carmel Valley 2021-02-03 Monterey 53 106   6568
879335 879335 93925 93925: Chualar 2021-02-03 Monterey 53 190   2155
879336 879336 93926 93926: Gonzales 2021-02-03 Monterey 53 1296   9262
879337 879337 93927 93927: Greenfield 2021-02-03 Monterey 53 2605   18778
879338 879338 93930 93930: King City 2021-02-03 Monterey 53 2062   17142
879339 879339 93933 93933: Marina 2021-02-03 Monterey 53 1182   25015
879340 879340 93940 93940: Monterey 2021-02-03 Monterey 53 867   32411
879341 879341 93942 93942: Monterey 2021-02-03 Monterey 53 26   0
879342 879342 93950 93950: Pacific Grove 2021-02-03 Monterey 53 293   15595
879343 879343 93953 93953: Pebble Beach 2021-02-03 Monterey 53 48   4117
879344 879344 93955 93955: Seaside 2021-02-03 Monterey 53 2330   34395
879345 879345 93960 93960: Soledad 2021-02-03 Monterey 53 5867   26610
879346 879346 95004 95004: Aromas 2021-02-03 Monterey 53 97   3956
879347 879347 95012 95012: Castroville 2021-02-03 Monterey 53 1255   10792
879348 879348 95039 95039: Moss Landing 2021-02-03 Monterey 53 110   1195
879349 879349 95076 95076: Watsonville 2021-02-03 Monterey 53 1145   86703

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