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,008 rows where fips = 55 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 55 · 10,008 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
731 731 American Canyon American Canyon 2021-10-27 Napa 55 2302   17167
732 732 Angwin Angwin 2021-10-27 Napa 55 160   2046
733 733 Between St Helena and Calistoga Between St Helena and Calistoga 2021-10-27 Napa 55 92   1744
734 734 Between Yountville and St Helena Between Yountville and St Helena 2021-10-27 Napa 55 91   2753
735 735 Calistoga Calistoga 2021-10-27 Napa 55 543   4759
736 736 Chiles Valley Area Chiles Valley Area 2021-10-27 Napa 55 14   776
737 737 Deer Park Deer Park 2021-10-27 Napa 55 74   1460
738 738 East Napa Area East Napa Area 2021-10-27 Napa 55 427   10237
739 739 Lake Berryessa Lake Berryessa 2021-10-27 Napa 55 66   1624
740 740 Napa Napa 2021-10-27 Napa 55 7888   79852
741 741 North Calistoga North Calistoga 2021-10-27 Napa 55 52   980
742 742 Northeast American Canyon Area Northeast American Canyon Area 2021-10-27 Napa 55 18   212
743 743 Pope Valley Area Pope Valley Area 2021-10-27 Napa 55 48   1275
744 744 South Napa Area South Napa Area 2021-10-27 Napa 55 323   1961
745 745 St. Helena St. Helena 2021-10-27 Napa 55 348   6543
746 746 West Napa Area West Napa Area 2021-10-27 Napa 55 47   951
747 747 West Napa and Yountville Area West Napa and Yountville Area 2021-10-27 Napa 55 64   1699
748 748 Yountville Yountville 2021-10-27 Napa 55 219   3032
2096 2096 American Canyon American Canyon 2021-10-26 Napa 55 2302   17167
2097 2097 Angwin Angwin 2021-10-26 Napa 55 160   2046
2098 2098 Between St Helena and Calistoga Between St Helena and Calistoga 2021-10-26 Napa 55 92   1744
2099 2099 Between Yountville and St Helena Between Yountville and St Helena 2021-10-26 Napa 55 91   2753
2100 2100 Calistoga Calistoga 2021-10-26 Napa 55 543   4759
2101 2101 Chiles Valley Area Chiles Valley Area 2021-10-26 Napa 55 14   776
2102 2102 Deer Park Deer Park 2021-10-26 Napa 55 74   1460
2103 2103 East Napa Area East Napa Area 2021-10-26 Napa 55 427   10237
2104 2104 Lake Berryessa Lake Berryessa 2021-10-26 Napa 55 66   1624
2105 2105 Napa Napa 2021-10-26 Napa 55 7888   79852
2106 2106 North Calistoga North Calistoga 2021-10-26 Napa 55 52   980
2107 2107 Northeast American Canyon Area Northeast American Canyon Area 2021-10-26 Napa 55 18   212
2108 2108 Pope Valley Area Pope Valley Area 2021-10-26 Napa 55 48   1275
2109 2109 South Napa Area South Napa Area 2021-10-26 Napa 55 323   1961
2110 2110 St. Helena St. Helena 2021-10-26 Napa 55 348   6543
2111 2111 West Napa Area West Napa Area 2021-10-26 Napa 55 47   951
2112 2112 West Napa and Yountville Area West Napa and Yountville Area 2021-10-26 Napa 55 64   1699
2113 2113 Yountville Yountville 2021-10-26 Napa 55 219   3032
3461 3461 American Canyon American Canyon 2021-10-25 Napa 55 2128   17167
3462 3462 Angwin Angwin 2021-10-25 Napa 55 125   2046
3463 3463 Between St Helena and Calistoga Between St Helena and Calistoga 2021-10-25 Napa 55 89   1744
3464 3464 Between Yountville and St Helena Between Yountville and St Helena 2021-10-25 Napa 55 85   2753
3465 3465 Calistoga Calistoga 2021-10-25 Napa 55 505   4759
3466 3466 Chiles Valley Area Chiles Valley Area 2021-10-25 Napa 55 6   776
3467 3467 Deer Park Deer Park 2021-10-25 Napa 55 69   1460
3468 3468 East Napa Area East Napa Area 2021-10-25 Napa 55 382   10237
3469 3469 Lake Berryessa Lake Berryessa 2021-10-25 Napa 55 52   1624
3470 3470 Napa Napa 2021-10-25 Napa 55 7282   79852
3471 3471 North Calistoga North Calistoga 2021-10-25 Napa 55 53   980
3472 3472 Northeast American Canyon Area Northeast American Canyon Area 2021-10-25 Napa 55 15   212
3473 3473 Pope Valley Area Pope Valley Area 2021-10-25 Napa 55 38   1275
3474 3474 South Napa Area South Napa Area 2021-10-25 Napa 55 304   1961
3475 3475 St. Helena St. Helena 2021-10-25 Napa 55 327   6543
3476 3476 West Napa Area West Napa Area 2021-10-25 Napa 55 40   951
3477 3477 West Napa and Yountville Area West Napa and Yountville Area 2021-10-25 Napa 55 59   1699
3478 3478 Yountville Yountville 2021-10-25 Napa 55 175   3032
4826 4826 American Canyon American Canyon 2021-10-24 Napa 55 2128   17167
4827 4827 Angwin Angwin 2021-10-24 Napa 55 125   2046
4828 4828 Between St Helena and Calistoga Between St Helena and Calistoga 2021-10-24 Napa 55 89   1744
4829 4829 Between Yountville and St Helena Between Yountville and St Helena 2021-10-24 Napa 55 85   2753
4830 4830 Calistoga Calistoga 2021-10-24 Napa 55 505   4759
4831 4831 Chiles Valley Area Chiles Valley Area 2021-10-24 Napa 55 6   776
4832 4832 Deer Park Deer Park 2021-10-24 Napa 55 69   1460
4833 4833 East Napa Area East Napa Area 2021-10-24 Napa 55 382   10237
4834 4834 Lake Berryessa Lake Berryessa 2021-10-24 Napa 55 52   1624
4835 4835 Napa Napa 2021-10-24 Napa 55 7282   79852
4836 4836 North Calistoga North Calistoga 2021-10-24 Napa 55 53   980
4837 4837 Northeast American Canyon Area Northeast American Canyon Area 2021-10-24 Napa 55 15   212
4838 4838 Pope Valley Area Pope Valley Area 2021-10-24 Napa 55 38   1275
4839 4839 South Napa Area South Napa Area 2021-10-24 Napa 55 304   1961
4840 4840 St. Helena St. Helena 2021-10-24 Napa 55 327   6543
4841 4841 West Napa Area West Napa Area 2021-10-24 Napa 55 40   951
4842 4842 West Napa and Yountville Area West Napa and Yountville Area 2021-10-24 Napa 55 59   1699
4843 4843 Yountville Yountville 2021-10-24 Napa 55 175   3032
6191 6191 American Canyon American Canyon 2021-10-23 Napa 55 2128   17167
6192 6192 Angwin Angwin 2021-10-23 Napa 55 125   2046
6193 6193 Between St Helena and Calistoga Between St Helena and Calistoga 2021-10-23 Napa 55 89   1744
6194 6194 Between Yountville and St Helena Between Yountville and St Helena 2021-10-23 Napa 55 85   2753
6195 6195 Calistoga Calistoga 2021-10-23 Napa 55 505   4759
6196 6196 Chiles Valley Area Chiles Valley Area 2021-10-23 Napa 55 6   776
6197 6197 Deer Park Deer Park 2021-10-23 Napa 55 69   1460
6198 6198 East Napa Area East Napa Area 2021-10-23 Napa 55 382   10237
6199 6199 Lake Berryessa Lake Berryessa 2021-10-23 Napa 55 52   1624
6200 6200 Napa Napa 2021-10-23 Napa 55 7282   79852
6201 6201 North Calistoga North Calistoga 2021-10-23 Napa 55 53   980
6202 6202 Northeast American Canyon Area Northeast American Canyon Area 2021-10-23 Napa 55 15   212
6203 6203 Pope Valley Area Pope Valley Area 2021-10-23 Napa 55 38   1275
6204 6204 South Napa Area South Napa Area 2021-10-23 Napa 55 304   1961
6205 6205 St. Helena St. Helena 2021-10-23 Napa 55 327   6543
6206 6206 West Napa Area West Napa Area 2021-10-23 Napa 55 40   951
6207 6207 West Napa and Yountville Area West Napa and Yountville Area 2021-10-23 Napa 55 59   1699
6208 6208 Yountville Yountville 2021-10-23 Napa 55 175   3032
7556 7556 American Canyon American Canyon 2021-10-22 Napa 55 2128   17167
7557 7557 Angwin Angwin 2021-10-22 Napa 55 125   2046
7558 7558 Between St Helena and Calistoga Between St Helena and Calistoga 2021-10-22 Napa 55 89   1744
7559 7559 Between Yountville and St Helena Between Yountville and St Helena 2021-10-22 Napa 55 85   2753
7560 7560 Calistoga Calistoga 2021-10-22 Napa 55 505   4759
7561 7561 Chiles Valley Area Chiles Valley Area 2021-10-22 Napa 55 6   776
7562 7562 Deer Park Deer Park 2021-10-22 Napa 55 69   1460
7563 7563 East Napa Area East Napa Area 2021-10-22 Napa 55 382   10237
7564 7564 Lake Berryessa Lake Berryessa 2021-10-22 Napa 55 52   1624
7565 7565 Napa Napa 2021-10-22 Napa 55 7282   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
);