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

16,896 rows where fips = 53 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 53 · 16,896 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
698 698 93426 93426: Bradley 2021-10-27 Monterey 53 47   1604
699 699 93450 93450: San Ardo 2021-10-27 Monterey 53 126   806
700 700 93451 93451: San Miguel 2021-10-27 Monterey 53 33   4089
701 701 93901 93901: Salinas 2021-10-27 Monterey 53 3020   27805
702 702 93902 93902: Prunedale 2021-10-27 Monterey 53 68   0
703 703 93905 93905: Salinas 2021-10-27 Monterey 53 9711   60408
704 704 93906 93906: Salinas 2021-10-27 Monterey 53 8619   65256
705 705 93907 93907: Salinas 2021-10-27 Monterey 53 2002   22766
706 706 93908 93908: Salinas 2021-10-27 Monterey 53 679   12093
707 707 93912 93912: Boronda 2021-10-27 Monterey 53 145   0
708 708 93915 93915: Salinas 2021-10-27 Monterey 53 77   0
709 709 93920 93920: Big Sur 2021-10-27 Monterey 53 61   1403
710 710 93921 93921: Carmel 2021-10-27 Monterey 53 58   3379
711 711 93922 93922: Carmel 2021-10-27 Monterey 53 31   0
712 712 93923 93923: Carmel 2021-10-27 Monterey 53 326   12833
713 713 93924 93924: Carmel Valley 2021-10-27 Monterey 53 190   6568
714 714 93925 93925: Chualar 2021-10-27 Monterey 53 226   2155
715 715 93926 93926: Gonzales 2021-10-27 Monterey 53 1460   9262
716 716 93927 93927: Greenfield 2021-10-27 Monterey 53 2906   18778
717 717 93930 93930: King City 2021-10-27 Monterey 53 2424   17142
718 718 93933 93933: Marina 2021-10-27 Monterey 53 1629   25015
719 719 93940 93940: Monterey 2021-10-27 Monterey 53 1304   32411
720 720 93942 93942: Monterey 2021-10-27 Monterey 53 39   0
721 721 93950 93950: Pacific Grove 2021-10-27 Monterey 53 486   15595
722 722 93953 93953: Pebble Beach 2021-10-27 Monterey 53 91   4117
723 723 93954 93954: San Lucas 2021-10-27 Monterey 53 67   472
724 724 93955 93955: Seaside 2021-10-27 Monterey 53 3061   34395
725 725 93960 93960: Soledad 2021-10-27 Monterey 53 6301   26610
726 726 93962 93962: Spreckels 2021-10-27 Monterey 53 34   385
727 727 95004 95004: Aromas 2021-10-27 Monterey 53 145   3956
728 728 95012 95012: Castroville 2021-10-27 Monterey 53 1602   10792
729 729 95039 95039: Moss Landing 2021-10-27 Monterey 53 146   1195
730 730 95076 95076: Watsonville 2021-10-27 Monterey 53 1452   86703
2063 2063 93426 93426: Bradley 2021-10-26 Monterey 53 47   1604
2064 2064 93450 93450: San Ardo 2021-10-26 Monterey 53 124   806
2065 2065 93451 93451: San Miguel 2021-10-26 Monterey 53 33   4089
2066 2066 93901 93901: Salinas 2021-10-26 Monterey 53 3013   27805
2067 2067 93902 93902: Prunedale 2021-10-26 Monterey 53 68   0
2068 2068 93905 93905: Salinas 2021-10-26 Monterey 53 9704   60408
2069 2069 93906 93906: Salinas 2021-10-26 Monterey 53 8609   65256
2070 2070 93907 93907: Salinas 2021-10-26 Monterey 53 2000   22766
2071 2071 93908 93908: Salinas 2021-10-26 Monterey 53 676   12093
2072 2072 93912 93912: Boronda 2021-10-26 Monterey 53 144   0
2073 2073 93915 93915: Salinas 2021-10-26 Monterey 53 78   0
2074 2074 93920 93920: Big Sur 2021-10-26 Monterey 53 61   1403
2075 2075 93921 93921: Carmel 2021-10-26 Monterey 53 58   3379
2076 2076 93922 93922: Carmel 2021-10-26 Monterey 53 31   0
2077 2077 93923 93923: Carmel 2021-10-26 Monterey 53 325   12833
2078 2078 93924 93924: Carmel Valley 2021-10-26 Monterey 53 190   6568
2079 2079 93925 93925: Chualar 2021-10-26 Monterey 53 226   2155
2080 2080 93926 93926: Gonzales 2021-10-26 Monterey 53 1459   9262
2081 2081 93927 93927: Greenfield 2021-10-26 Monterey 53 2903   18778
2082 2082 93930 93930: King City 2021-10-26 Monterey 53 2420   17142
2083 2083 93933 93933: Marina 2021-10-26 Monterey 53 1626   25015
2084 2084 93940 93940: Monterey 2021-10-26 Monterey 53 1303   32411
2085 2085 93942 93942: Monterey 2021-10-26 Monterey 53 39   0
2086 2086 93950 93950: Pacific Grove 2021-10-26 Monterey 53 485   15595
2087 2087 93953 93953: Pebble Beach 2021-10-26 Monterey 53 91   4117
2088 2088 93954 93954: San Lucas 2021-10-26 Monterey 53 67   472
2089 2089 93955 93955: Seaside 2021-10-26 Monterey 53 3057   34395
2090 2090 93960 93960: Soledad 2021-10-26 Monterey 53 6299   26610
2091 2091 93962 93962: Spreckels 2021-10-26 Monterey 53 34   385
2092 2092 95004 95004: Aromas 2021-10-26 Monterey 53 145   3956
2093 2093 95012 95012: Castroville 2021-10-26 Monterey 53 1600   10792
2094 2094 95039 95039: Moss Landing 2021-10-26 Monterey 53 146   1195
2095 2095 95076 95076: Watsonville 2021-10-26 Monterey 53 1450   86703
3428 3428 93426 93426: Bradley 2021-10-25 Monterey 53 47   1604
3429 3429 93450 93450: San Ardo 2021-10-25 Monterey 53 124   806
3430 3430 93451 93451: San Miguel 2021-10-25 Monterey 53 33   4089
3431 3431 93901 93901: Salinas 2021-10-25 Monterey 53 3012   27805
3432 3432 93902 93902: Prunedale 2021-10-25 Monterey 53 68   0
3433 3433 93905 93905: Salinas 2021-10-25 Monterey 53 9703   60408
3434 3434 93906 93906: Salinas 2021-10-25 Monterey 53 8603   65256
3435 3435 93907 93907: Salinas 2021-10-25 Monterey 53 1998   22766
3436 3436 93908 93908: Salinas 2021-10-25 Monterey 53 676   12093
3437 3437 93912 93912: Boronda 2021-10-25 Monterey 53 144   0
3438 3438 93915 93915: Salinas 2021-10-25 Monterey 53 78   0
3439 3439 93920 93920: Big Sur 2021-10-25 Monterey 53 61   1403
3440 3440 93921 93921: Carmel 2021-10-25 Monterey 53 58   3379
3441 3441 93922 93922: Carmel 2021-10-25 Monterey 53 31   0
3442 3442 93923 93923: Carmel 2021-10-25 Monterey 53 325   12833
3443 3443 93924 93924: Carmel Valley 2021-10-25 Monterey 53 190   6568
3444 3444 93925 93925: Chualar 2021-10-25 Monterey 53 226   2155
3445 3445 93926 93926: Gonzales 2021-10-25 Monterey 53 1459   9262
3446 3446 93927 93927: Greenfield 2021-10-25 Monterey 53 2903   18778
3447 3447 93930 93930: King City 2021-10-25 Monterey 53 2416   17142
3448 3448 93933 93933: Marina 2021-10-25 Monterey 53 1624   25015
3449 3449 93940 93940: Monterey 2021-10-25 Monterey 53 1303   32411
3450 3450 93942 93942: Monterey 2021-10-25 Monterey 53 39   0
3451 3451 93950 93950: Pacific Grove 2021-10-25 Monterey 53 485   15595
3452 3452 93953 93953: Pebble Beach 2021-10-25 Monterey 53 91   4117
3453 3453 93954 93954: San Lucas 2021-10-25 Monterey 53 67   472
3454 3454 93955 93955: Seaside 2021-10-25 Monterey 53 3057   34395
3455 3455 93960 93960: Soledad 2021-10-25 Monterey 53 6299   26610
3456 3456 93962 93962: Spreckels 2021-10-25 Monterey 53 34   385
3457 3457 95004 95004: Aromas 2021-10-25 Monterey 53 145   3956
3458 3458 95012 95012: Castroville 2021-10-25 Monterey 53 1599   10792
3459 3459 95039 95039: Moss Landing 2021-10-25 Monterey 53 145   1195
3460 3460 95076 95076: Watsonville 2021-10-25 Monterey 53 1450   86703
4793 4793 93426 93426: Bradley 2021-10-24 Monterey 53 47   1604

Next page

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