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

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

✎ View and edit SQL

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

fips

  • 55 · 6,408 ✖

county

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