⚠️ 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

6,408 rows where fips = 55 sorted by date descending

View and edit SQL

fips

  • 55 · 6,408

county

Link rowid id name date ▲ county fips confirmed_cases note population
730 American Canyon American Canyon 2021-04-10 Napa 55 1594   17167
731 Angwin Angwin 2021-04-10 Napa 55 101   2046
732 Between St Helena and Calistoga Between St Helena and Calistoga 2021-04-10 Napa 55 77   1744
733 Between Yountville and St Helena Between Yountville and St Helena 2021-04-10 Napa 55 65   2753
734 Calistoga Calistoga 2021-04-10 Napa 55 479   4759
735 Chiles Valley Area Chiles Valley Area 2021-04-10 Napa 55 6   776
736 Deer Park Deer Park 2021-04-10 Napa 55 54   1460
737 East Napa Area East Napa Area 2021-04-10 Napa 55 296   10237
738 Lake Berryessa Lake Berryessa 2021-04-10 Napa 55 33   1624
739 Napa Napa 2021-04-10 Napa 55 5891   79852
740 North Calistoga North Calistoga 2021-04-10 Napa 55 31   980
741 Northeast American Canyon Area Northeast American Canyon Area 2021-04-10 Napa 55 11   212
742 Pope Valley Area Pope Valley Area 2021-04-10 Napa 55 33   1275
743 South Napa Area South Napa Area 2021-04-10 Napa 55 256   1961
744 St. Helena St. Helena 2021-04-10 Napa 55 289   6543
745 West Napa Area West Napa Area 2021-04-10 Napa 55 30   951
746 West Napa and Yountville Area West Napa and Yountville Area 2021-04-10 Napa 55 45   1699
747 Yountville Yountville 2021-04-10 Napa 55 148   3032
2097 American Canyon American Canyon 2021-04-09 Napa 55 1594   17167
2098 Angwin Angwin 2021-04-09 Napa 55 101   2046
2099 Between St Helena and Calistoga Between St Helena and Calistoga 2021-04-09 Napa 55 77   1744
2100 Between Yountville and St Helena Between Yountville and St Helena 2021-04-09 Napa 55 65   2753
2101 Calistoga Calistoga 2021-04-09 Napa 55 479   4759
2102 Chiles Valley Area Chiles Valley Area 2021-04-09 Napa 55 6   776
2103 Deer Park Deer Park 2021-04-09 Napa 55 54   1460
2104 East Napa Area East Napa Area 2021-04-09 Napa 55 296   10237
2105 Lake Berryessa Lake Berryessa 2021-04-09 Napa 55 33   1624
2106 Napa Napa 2021-04-09 Napa 55 5891   79852
2107 North Calistoga North Calistoga 2021-04-09 Napa 55 31   980
2108 Northeast American Canyon Area Northeast American Canyon Area 2021-04-09 Napa 55 11   212
2109 Pope Valley Area Pope Valley Area 2021-04-09 Napa 55 33   1275
2110 South Napa Area South Napa Area 2021-04-09 Napa 55 256   1961
2111 St. Helena St. Helena 2021-04-09 Napa 55 289   6543
2112 West Napa Area West Napa Area 2021-04-09 Napa 55 30   951
2113 West Napa and Yountville Area West Napa and Yountville Area 2021-04-09 Napa 55 45   1699
2114 Yountville Yountville 2021-04-09 Napa 55 148   3032
3467 American Canyon American Canyon 2021-04-08 Napa 55 1594   17167
3468 Angwin Angwin 2021-04-08 Napa 55 101   2046
3469 Between St Helena and Calistoga Between St Helena and Calistoga 2021-04-08 Napa 55 77   1744
3470 Between Yountville and St Helena Between Yountville and St Helena 2021-04-08 Napa 55 65   2753
3471 Calistoga Calistoga 2021-04-08 Napa 55 479   4759
3472 Chiles Valley Area Chiles Valley Area 2021-04-08 Napa 55 6   776
3473 Deer Park Deer Park 2021-04-08 Napa 55 54   1460
3474 East Napa Area East Napa Area 2021-04-08 Napa 55 296   10237
3475 Lake Berryessa Lake Berryessa 2021-04-08 Napa 55 33   1624
3476 Napa Napa 2021-04-08 Napa 55 5891   79852
3477 North Calistoga North Calistoga 2021-04-08 Napa 55 31   980
3478 Northeast American Canyon Area Northeast American Canyon Area 2021-04-08 Napa 55 11   212
3479 Pope Valley Area Pope Valley Area 2021-04-08 Napa 55 33   1275
3480 South Napa Area South Napa Area 2021-04-08 Napa 55 256   1961
3481 St. Helena St. Helena 2021-04-08 Napa 55 289   6543
3482 West Napa Area West Napa Area 2021-04-08 Napa 55 30   951
3483 West Napa and Yountville Area West Napa and Yountville Area 2021-04-08 Napa 55 45   1699
3484 Yountville Yountville 2021-04-08 Napa 55 148   3032
4837 American Canyon American Canyon 2021-04-07 Napa 55 1594   17167
4838 Angwin Angwin 2021-04-07 Napa 55 101   2046
4839 Between St Helena and Calistoga Between St Helena and Calistoga 2021-04-07 Napa 55 77   1744
4840 Between Yountville and St Helena Between Yountville and St Helena 2021-04-07 Napa 55 65   2753
4841 Calistoga Calistoga 2021-04-07 Napa 55 479   4759
4842 Chiles Valley Area Chiles Valley Area 2021-04-07 Napa 55 6   776
4843 Deer Park Deer Park 2021-04-07 Napa 55 54   1460
4844 East Napa Area East Napa Area 2021-04-07 Napa 55 296   10237
4845 Lake Berryessa Lake Berryessa 2021-04-07 Napa 55 33   1624
4846 Napa Napa 2021-04-07 Napa 55 5891   79852
4847 North Calistoga North Calistoga 2021-04-07 Napa 55 31   980
4848 Northeast American Canyon Area Northeast American Canyon Area 2021-04-07 Napa 55 11   212
4849 Pope Valley Area Pope Valley Area 2021-04-07 Napa 55 33   1275
4850 South Napa Area South Napa Area 2021-04-07 Napa 55 256   1961
4851 St. Helena St. Helena 2021-04-07 Napa 55 289   6543
4852 West Napa Area West Napa Area 2021-04-07 Napa 55 30   951
4853 West Napa and Yountville Area West Napa and Yountville Area 2021-04-07 Napa 55 45   1699
4854 Yountville Yountville 2021-04-07 Napa 55 148   3032
6209 American Canyon American Canyon 2021-04-06 Napa 55 1594   17167
6210 Angwin Angwin 2021-04-06 Napa 55 101   2046
6211 Between St Helena and Calistoga Between St Helena and Calistoga 2021-04-06 Napa 55 77   1744
6212 Between Yountville and St Helena Between Yountville and St Helena 2021-04-06 Napa 55 65   2753
6213 Calistoga Calistoga 2021-04-06 Napa 55 479   4759
6214 Chiles Valley Area Chiles Valley Area 2021-04-06 Napa 55 6   776
6215 Deer Park Deer Park 2021-04-06 Napa 55 54   1460
6216 East Napa Area East Napa Area 2021-04-06 Napa 55 296   10237
6217 Lake Berryessa Lake Berryessa 2021-04-06 Napa 55 33   1624
6218 Napa Napa 2021-04-06 Napa 55 5891   79852
6219 North Calistoga North Calistoga 2021-04-06 Napa 55 31   980
6220 Northeast American Canyon Area Northeast American Canyon Area 2021-04-06 Napa 55 11   212
6221 Pope Valley Area Pope Valley Area 2021-04-06 Napa 55 33   1275
6222 South Napa Area South Napa Area 2021-04-06 Napa 55 256   1961
6223 St. Helena St. Helena 2021-04-06 Napa 55 289   6543
6224 West Napa Area West Napa Area 2021-04-06 Napa 55 30   951
6225 West Napa and Yountville Area West Napa and Yountville Area 2021-04-06 Napa 55 45   1699
6226 Yountville Yountville 2021-04-06 Napa 55 148   3032
7581 American Canyon American Canyon 2021-04-05 Napa 55 1594   17167
7582 Angwin Angwin 2021-04-05 Napa 55 101   2046
7583 Between St Helena and Calistoga Between St Helena and Calistoga 2021-04-05 Napa 55 77   1744
7584 Between Yountville and St Helena Between Yountville and St Helena 2021-04-05 Napa 55 65   2753
7585 Calistoga Calistoga 2021-04-05 Napa 55 479   4759
7586 Chiles Valley Area Chiles Valley Area 2021-04-05 Napa 55 6   776
7587 Deer Park Deer Park 2021-04-05 Napa 55 54   1460
7588 East Napa Area East Napa Area 2021-04-05 Napa 55 296   10237
7589 Lake Berryessa Lake Berryessa 2021-04-05 Napa 55 33   1624
7590 Napa Napa 2021-04-05 Napa 55 5891   79852

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