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-11-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
530975 530975 93426 93426: Bradley 2021-11-03 Monterey 53 48   1604
530976 530976 93901 93901: Salinas 2021-11-03 Monterey 53 3033   27805
530977 530977 93905 93905: Salinas 2021-11-03 Monterey 53 9718   60408
530978 530978 93906 93906: Salinas 2021-11-03 Monterey 53 8629   65256
530979 530979 93907 93907: Salinas 2021-11-03 Monterey 53 2003   22766
530980 530980 93908 93908: Salinas 2021-11-03 Monterey 53 680   12093
530981 530981 93912 93912: Boronda 2021-11-03 Monterey 53 147   0
530982 530982 93920 93920: Big Sur 2021-11-03 Monterey 53 60   1403
530983 530983 93921 93921: Carmel 2021-11-03 Monterey 53 58   3379
530984 530984 93922 93922: Carmel 2021-11-03 Monterey 53 31   0
530985 530985 93923 93923: Carmel 2021-11-03 Monterey 53 326   12833
530986 530986 93924 93924: Carmel Valley 2021-11-03 Monterey 53 190   6568
530987 530987 93925 93925: Chualar 2021-11-03 Monterey 53 226   2155
530988 530988 93926 93926: Gonzales 2021-11-03 Monterey 53 1461   9262
530989 530989 93927 93927: Greenfield 2021-11-03 Monterey 53 2914   18778
530990 530990 93930 93930: King City 2021-11-03 Monterey 53 2433   17142
530991 530991 93933 93933: Marina 2021-11-03 Monterey 53 1631   25015
530992 530992 93940 93940: Monterey 2021-11-03 Monterey 53 1309   32411
530993 530993 93942 93942: Monterey 2021-11-03 Monterey 53 41   0
530994 530994 93950 93950: Pacific Grove 2021-11-03 Monterey 53 489   15595
530995 530995 93953 93953: Pebble Beach 2021-11-03 Monterey 53 91   4117
530996 530996 93955 93955: Seaside 2021-11-03 Monterey 53 3070   34395
530997 530997 93960 93960: Soledad 2021-11-03 Monterey 53 6315   26610
530998 530998 95004 95004: Aromas 2021-11-03 Monterey 53 145   3956
530999 530999 95012 95012: Castroville 2021-11-03 Monterey 53 1607   10792
531000 531000 95039 95039: Moss Landing 2021-11-03 Monterey 53 144   1195
531001 531001 95076 95076: Watsonville 2021-11-03 Monterey 53 1451   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
);