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

4,751 rows where fips = 53 sorted by date descending

✎ View and edit SQL

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

fips

  • 53 · 4,751 ✖

county

Link rowid date ▲ county fips place confirmed_cases note x y population
651 651 2021-01-27 Monterey 53 93450: San Ardo 102   -120.82447 36.05635  
652 652 2021-01-27 Monterey 53 93901: Salinas 2241   -121.62402 36.638629  
653 653 2021-01-27 Monterey 53 93902: Prunedale 56   -121.660129 36.780789  
654 654 2021-01-27 Monterey 53 93905: Salinas 8083   -121.607 36.683204  
655 655 2021-01-27 Monterey 53 93906: Salinas 6825   -121.63228 36.72258  
656 656 2021-01-27 Monterey 53 93907: Salinas 1543   -121.66779 36.769577  
657 657 2021-01-27 Monterey 53 93908: Salinas 455   -121.60704 36.634147  
658 658 2021-01-27 Monterey 53 93912: Boronda 110   -121.67 36.700653  
659 659 2021-01-27 Monterey 53 93915: Salinas 71   -121.630129 36.670481  
660 660 2021-01-27 Monterey 53 93920: Big Sur 43   -121.56042 36.11053  
661 661 2021-01-27 Monterey 53 93921: Carmel 26   -121.9229 36.554033  
662 662 2021-01-27 Monterey 53 93923: Carmel 185   -121.84288 36.458124  
663 663 2021-01-27 Monterey 53 93924: Carmel Valley 103   -121.64066 36.398908  
664 664 2021-01-27 Monterey 53 93925: Chualar 181   -121.43135 36.600561  
665 665 2021-01-27 Monterey 53 93926: Gonzales 1255   -121.40775 36.529198  
666 666 2021-01-27 Monterey 53 93927: Greenfield 2519   -121.37717 36.233576  
667 667 2021-01-27 Monterey 53 93930: King City 1987   -121.04405 36.18912  
668 668 2021-01-27 Monterey 53 93933: Marina 1124   -121.787 36.686076  
669 669 2021-01-27 Monterey 53 93940: Monterey 836   -121.84327 36.579412  
670 670 2021-01-27 Monterey 53 93942: Monterey 26   -121.9 36.610653  
671 671 2021-01-27 Monterey 53 93950: Pacific Grove 273   -121.9257 36.618984  
672 672 2021-01-27 Monterey 53 93953: Pebble Beach 45   -121.94279 36.584923  
673 673 2021-01-27 Monterey 53 93954: San Lucas 58   -120.94207 36.133135  
674 674 2021-01-27 Monterey 53 93955: Seaside 2227   -121.79275 36.621158  
675 675 2021-01-27 Monterey 53 93960: Soledad 5710   -121.34123 36.398245  
676 676 2021-01-27 Monterey 53 93962: Spreckels 23   -121.64648 36.624718  
677 677 2021-01-27 Monterey 53 95004: Aromas 93   -121.64895 36.870187  
678 678 2021-01-27 Monterey 53 95012: Castroville 1189   -121.75273 36.776574  
679 679 2021-01-27 Monterey 53 95039: Moss Landing 104   -121.77444 36.825881  
680 680 2021-01-27 Monterey 53 95076: Watsonville 1118   -121.71403 36.864966  
1988 1988 2021-01-26 Monterey 53 93450: San Ardo 102   -120.82447 36.05635  
1989 1989 2021-01-26 Monterey 53 93901: Salinas 2227   -121.62402 36.638629  
1990 1990 2021-01-26 Monterey 53 93902: Prunedale 56   -121.660129 36.780789  
1991 1991 2021-01-26 Monterey 53 93905: Salinas 8023   -121.607 36.683204  
1992 1992 2021-01-26 Monterey 53 93906: Salinas 6784   -121.63228 36.72258  
1993 1993 2021-01-26 Monterey 53 93907: Salinas 1532   -121.66779 36.769577  
1994 1994 2021-01-26 Monterey 53 93908: Salinas 454   -121.60704 36.634147  
1995 1995 2021-01-26 Monterey 53 93912: Boronda 109   -121.67 36.700653  
1996 1996 2021-01-26 Monterey 53 93915: Salinas 68   -121.630129 36.670481  
1997 1997 2021-01-26 Monterey 53 93920: Big Sur 43   -121.56042 36.11053  
1998 1998 2021-01-26 Monterey 53 93921: Carmel 26   -121.9229 36.554033  
1999 1999 2021-01-26 Monterey 53 93923: Carmel 180   -121.84288 36.458124  
2000 2000 2021-01-26 Monterey 53 93924: Carmel Valley 102   -121.64066 36.398908  
2001 2001 2021-01-26 Monterey 53 93925: Chualar 181   -121.43135 36.600561  
2002 2002 2021-01-26 Monterey 53 93926: Gonzales 1252   -121.40775 36.529198  
2003 2003 2021-01-26 Monterey 53 93927: Greenfield 2493   -121.37717 36.233576  
2004 2004 2021-01-26 Monterey 53 93930: King City 1959   -121.04405 36.18912  
2005 2005 2021-01-26 Monterey 53 93933: Marina 1114   -121.787 36.686076  
2006 2006 2021-01-26 Monterey 53 93940: Monterey 829   -121.84327 36.579412  
2007 2007 2021-01-26 Monterey 53 93942: Monterey 26   -121.9 36.610653  
2008 2008 2021-01-26 Monterey 53 93950: Pacific Grove 271   -121.9257 36.618984  
2009 2009 2021-01-26 Monterey 53 93953: Pebble Beach 45   -121.94279 36.584923  
2010 2010 2021-01-26 Monterey 53 93954: San Lucas 58   -120.94207 36.133135  
2011 2011 2021-01-26 Monterey 53 93955: Seaside 2208   -121.79275 36.621158  
2012 2012 2021-01-26 Monterey 53 93960: Soledad 5683   -121.34123 36.398245  
2013 2013 2021-01-26 Monterey 53 93962: Spreckels 23   -121.64648 36.624718  
2014 2014 2021-01-26 Monterey 53 95004: Aromas 93   -121.64895 36.870187  
2015 2015 2021-01-26 Monterey 53 95012: Castroville 1173   -121.75273 36.776574  
2016 2016 2021-01-26 Monterey 53 95039: Moss Landing 104   -121.77444 36.825881  
2017 2017 2021-01-26 Monterey 53 95076: Watsonville 1114   -121.71403 36.864966  
3329 3329 2021-01-25 Monterey 53 93450: San Ardo 99   -120.82447 36.05635  
3330 3330 2021-01-25 Monterey 53 93901: Salinas 2186   -121.62402 36.638629  
3331 3331 2021-01-25 Monterey 53 93902: Prunedale 57   -121.660129 36.780789  
3332 3332 2021-01-25 Monterey 53 93905: Salinas 7751   -121.607 36.683204  
3333 3333 2021-01-25 Monterey 53 93906: Salinas 6598   -121.63228 36.72258  
3334 3334 2021-01-25 Monterey 53 93907: Salinas 1471   -121.66779 36.769577  
3335 3335 2021-01-25 Monterey 53 93908: Salinas 441   -121.60704 36.634147  
3336 3336 2021-01-25 Monterey 53 93912: Boronda 103   -121.67 36.700653  
3337 3337 2021-01-25 Monterey 53 93915: Salinas 62   -121.630129 36.670481  
3338 3338 2021-01-25 Monterey 53 93920: Big Sur 40   -121.56042 36.11053  
3339 3339 2021-01-25 Monterey 53 93921: Carmel 26   -121.9229 36.554033  
3340 3340 2021-01-25 Monterey 53 93923: Carmel 174   -121.84288 36.458124  
3341 3341 2021-01-25 Monterey 53 93924: Carmel Valley 100   -121.64066 36.398908  
3342 3342 2021-01-25 Monterey 53 93925: Chualar 174   -121.43135 36.600561  
3343 3343 2021-01-25 Monterey 53 93926: Gonzales 1205   -121.40775 36.529198  
3344 3344 2021-01-25 Monterey 53 93927: Greenfield 2423   -121.37717 36.233576  
3345 3345 2021-01-25 Monterey 53 93930: King City 1885   -121.04405 36.18912  
3346 3346 2021-01-25 Monterey 53 93933: Marina 1073   -121.787 36.686076  
3347 3347 2021-01-25 Monterey 53 93940: Monterey 804   -121.84327 36.579412  
3348 3348 2021-01-25 Monterey 53 93942: Monterey 26   -121.9 36.610653  
3349 3349 2021-01-25 Monterey 53 93950: Pacific Grove 259   -121.9257 36.618984  
3350 3350 2021-01-25 Monterey 53 93953: Pebble Beach 43   -121.94279 36.584923  
3351 3351 2021-01-25 Monterey 53 93954: San Lucas 47   -120.94207 36.133135  
3352 3352 2021-01-25 Monterey 53 93955: Seaside 2140   -121.79275 36.621158  
3353 3353 2021-01-25 Monterey 53 93960: Soledad 5546   -121.34123 36.398245  
3354 3354 2021-01-25 Monterey 53 93962: Spreckels 23   -121.64648 36.624718  
3355 3355 2021-01-25 Monterey 53 95004: Aromas 90   -121.64895 36.870187  
3356 3356 2021-01-25 Monterey 53 95012: Castroville 1140   -121.75273 36.776574  
3357 3357 2021-01-25 Monterey 53 95039: Moss Landing 102   -121.77444 36.825881  
3358 3358 2021-01-25 Monterey 53 95076: Watsonville 1094   -121.71403 36.864966  
4657 4657 2021-01-24 Monterey 53 93450: San Ardo 99   -120.82447 36.05635  
4658 4658 2021-01-24 Monterey 53 93901: Salinas 2186   -121.62402 36.638629  
4659 4659 2021-01-24 Monterey 53 93902: Prunedale 57   -121.660129 36.780789  
4660 4660 2021-01-24 Monterey 53 93905: Salinas 7751   -121.607 36.683204  
4661 4661 2021-01-24 Monterey 53 93906: Salinas 6598   -121.63228 36.72258  
4662 4662 2021-01-24 Monterey 53 93907: Salinas 1471   -121.66779 36.769577  
4663 4663 2021-01-24 Monterey 53 93908: Salinas 441   -121.60704 36.634147  
4664 4664 2021-01-24 Monterey 53 93912: Boronda 103   -121.67 36.700653  
4665 4665 2021-01-24 Monterey 53 93915: Salinas 62   -121.630129 36.670481  
4666 4666 2021-01-24 Monterey 53 93920: Big Sur 40   -121.56042 36.11053  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT,
   [population] TEXT
);