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

10,296 rows where fips = 53 sorted by date descending

✎ View and edit SQL

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

fips

  • 53 · 10,296 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
697 697 93426 93426: Bradley 2021-04-10 Monterey 53 28   1604
698 698 93450 93450: San Ardo 2021-04-10 Monterey 53 106   806
699 699 93451 93451: San Miguel 2021-04-10 Monterey 53 22   4089
700 700 93901 93901: Salinas 2021-04-10 Monterey 53 2565   27805
701 701 93902 93902: Prunedale 2021-04-10 Monterey 53 61   0
702 702 93905 93905: Salinas 2021-04-10 Monterey 53 9039   60408
703 703 93906 93906: Salinas 2021-04-10 Monterey 53 7562   65256
704 704 93907 93907: Salinas 2021-04-10 Monterey 53 1724   22766
705 705 93908 93908: Salinas 2021-04-10 Monterey 53 517   12093
706 706 93912 93912: Boronda 2021-04-10 Monterey 53 125   0
707 707 93915 93915: Salinas 2021-04-10 Monterey 53 76   0
708 708 93920 93920: Big Sur 2021-04-10 Monterey 53 50   1403
709 709 93921 93921: Carmel 2021-04-10 Monterey 53 35   3379
710 710 93922 93922: Carmel 2021-04-10 Monterey 53 21   0
711 711 93923 93923: Carmel 2021-04-10 Monterey 53 208   12833
712 712 93924 93924: Carmel Valley 2021-04-10 Monterey 53 130   6568
713 713 93925 93925: Chualar 2021-04-10 Monterey 53 199   2155
714 714 93926 93926: Gonzales 2021-04-10 Monterey 53 1364   9262
715 715 93927 93927: Greenfield 2021-04-10 Monterey 53 2729   18778
716 716 93930 93930: King City 2021-04-10 Monterey 53 2169   17142
717 717 93933 93933: Marina 2021-04-10 Monterey 53 1300   25015
718 718 93940 93940: Monterey 2021-04-10 Monterey 53 977   32411
719 719 93942 93942: Monterey 2021-04-10 Monterey 53 28   0
720 720 93950 93950: Pacific Grove 2021-04-10 Monterey 53 331   15595
721 721 93953 93953: Pebble Beach 2021-04-10 Monterey 53 55   4117
722 722 93954 93954: San Lucas 2021-04-10 Monterey 53 64   472
723 723 93955 93955: Seaside 2021-04-10 Monterey 53 2562   34395
724 724 93960 93960: Soledad 2021-04-10 Monterey 53 6101   26610
725 725 93962 93962: Spreckels 2021-04-10 Monterey 53 28   385
726 726 95004 95004: Aromas 2021-04-10 Monterey 53 107   3956
727 727 95012 95012: Castroville 2021-04-10 Monterey 53 1390   10792
728 728 95039 95039: Moss Landing 2021-04-10 Monterey 53 126   1195
729 729 95076 95076: Watsonville 2021-04-10 Monterey 53 1255   86703
2064 2064 93426 93426: Bradley 2021-04-09 Monterey 53 28   1604
2065 2065 93450 93450: San Ardo 2021-04-09 Monterey 53 106   806
2066 2066 93451 93451: San Miguel 2021-04-09 Monterey 53 22   4089
2067 2067 93901 93901: Salinas 2021-04-09 Monterey 53 2558   27805
2068 2068 93902 93902: Prunedale 2021-04-09 Monterey 53 61   0
2069 2069 93905 93905: Salinas 2021-04-09 Monterey 53 9026   60408
2070 2070 93906 93906: Salinas 2021-04-09 Monterey 53 7547   65256
2071 2071 93907 93907: Salinas 2021-04-09 Monterey 53 1722   22766
2072 2072 93908 93908: Salinas 2021-04-09 Monterey 53 520   12093
2073 2073 93912 93912: Boronda 2021-04-09 Monterey 53 124   0
2074 2074 93915 93915: Salinas 2021-04-09 Monterey 53 76   0
2075 2075 93920 93920: Big Sur 2021-04-09 Monterey 53 50   1403
2076 2076 93921 93921: Carmel 2021-04-09 Monterey 53 35   3379
2077 2077 93922 93922: Carmel 2021-04-09 Monterey 53 21   0
2078 2078 93923 93923: Carmel 2021-04-09 Monterey 53 208   12833
2079 2079 93924 93924: Carmel Valley 2021-04-09 Monterey 53 129   6568
2080 2080 93925 93925: Chualar 2021-04-09 Monterey 53 198   2155
2081 2081 93926 93926: Gonzales 2021-04-09 Monterey 53 1363   9262
2082 2082 93927 93927: Greenfield 2021-04-09 Monterey 53 2728   18778
2083 2083 93930 93930: King City 2021-04-09 Monterey 53 2170   17142
2084 2084 93933 93933: Marina 2021-04-09 Monterey 53 1299   25015
2085 2085 93940 93940: Monterey 2021-04-09 Monterey 53 971   32411
2086 2086 93942 93942: Monterey 2021-04-09 Monterey 53 28   0
2087 2087 93950 93950: Pacific Grove 2021-04-09 Monterey 53 327   15595
2088 2088 93953 93953: Pebble Beach 2021-04-09 Monterey 53 55   4117
2089 2089 93954 93954: San Lucas 2021-04-09 Monterey 53 64   472
2090 2090 93955 93955: Seaside 2021-04-09 Monterey 53 2562   34395
2091 2091 93960 93960: Soledad 2021-04-09 Monterey 53 6100   26610
2092 2092 93962 93962: Spreckels 2021-04-09 Monterey 53 28   385
2093 2093 95004 95004: Aromas 2021-04-09 Monterey 53 107   3956
2094 2094 95012 95012: Castroville 2021-04-09 Monterey 53 1391   10792
2095 2095 95039 95039: Moss Landing 2021-04-09 Monterey 53 124   1195
2096 2096 95076 95076: Watsonville 2021-04-09 Monterey 53 1253   86703
3434 3434 93426 93426: Bradley 2021-04-08 Monterey 53 28   1604
3435 3435 93450 93450: San Ardo 2021-04-08 Monterey 53 106   806
3436 3436 93451 93451: San Miguel 2021-04-08 Monterey 53 22   4089
3437 3437 93901 93901: Salinas 2021-04-08 Monterey 53 2552   27805
3438 3438 93902 93902: Prunedale 2021-04-08 Monterey 53 61   0
3439 3439 93905 93905: Salinas 2021-04-08 Monterey 53 9017   60408
3440 3440 93906 93906: Salinas 2021-04-08 Monterey 53 7540   65256
3441 3441 93907 93907: Salinas 2021-04-08 Monterey 53 1716   22766
3442 3442 93908 93908: Salinas 2021-04-08 Monterey 53 518   12093
3443 3443 93912 93912: Boronda 2021-04-08 Monterey 53 124   0
3444 3444 93915 93915: Salinas 2021-04-08 Monterey 53 76   0
3445 3445 93920 93920: Big Sur 2021-04-08 Monterey 53 50   1403
3446 3446 93921 93921: Carmel 2021-04-08 Monterey 53 35   3379
3447 3447 93922 93922: Carmel 2021-04-08 Monterey 53 21   0
3448 3448 93923 93923: Carmel 2021-04-08 Monterey 53 208   12833
3449 3449 93924 93924: Carmel Valley 2021-04-08 Monterey 53 128   6568
3450 3450 93925 93925: Chualar 2021-04-08 Monterey 53 198   2155
3451 3451 93926 93926: Gonzales 2021-04-08 Monterey 53 1364   9262
3452 3452 93927 93927: Greenfield 2021-04-08 Monterey 53 2727   18778
3453 3453 93930 93930: King City 2021-04-08 Monterey 53 2171   17142
3454 3454 93933 93933: Marina 2021-04-08 Monterey 53 1295   25015
3455 3455 93940 93940: Monterey 2021-04-08 Monterey 53 971   32411
3456 3456 93942 93942: Monterey 2021-04-08 Monterey 53 27   0
3457 3457 93950 93950: Pacific Grove 2021-04-08 Monterey 53 326   15595
3458 3458 93953 93953: Pebble Beach 2021-04-08 Monterey 53 55   4117
3459 3459 93954 93954: San Lucas 2021-04-08 Monterey 53 63   472
3460 3460 93955 93955: Seaside 2021-04-08 Monterey 53 2563   34395
3461 3461 93960 93960: Soledad 2021-04-08 Monterey 53 6101   26610
3462 3462 93962 93962: Spreckels 2021-04-08 Monterey 53 29   385
3463 3463 95004 95004: Aromas 2021-04-08 Monterey 53 107   3956
3464 3464 95012 95012: Castroville 2021-04-08 Monterey 53 1387   10792
3465 3465 95039 95039: Moss Landing 2021-04-08 Monterey 53 125   1195
3466 3466 95076 95076: Watsonville 2021-04-08 Monterey 53 1249   86703
4804 4804 93426 93426: Bradley 2021-04-07 Monterey 53 28   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
);