home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ 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

15,336 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 1

  • 55 · 15,336 ✖

county 1

  • Napa 15,336
Link rowid id name date ▲ county fips confirmed_cases note population
654 654 American Canyon American Canyon 2022-08-19 Napa 55 6233   17167
655 655 Angwin Angwin 2022-08-19 Napa 55 373   2046
656 656 Between St Helena and Calistoga Between St Helena and Calistoga 2022-08-19 Napa 55 160   1744
657 657 Between Yountville and St Helena Between Yountville and St Helena 2022-08-19 Napa 55 236   2753
658 658 Calistoga Calistoga 2022-08-19 Napa 55 1052   4759
659 659 Chiles Valley Area Chiles Valley Area 2022-08-19 Napa 55 46   776
660 660 Deer Park Deer Park 2022-08-19 Napa 55 119   1460
661 661 East Napa Area East Napa Area 2022-08-19 Napa 55 1114   10237
662 662 Lake Berryessa Lake Berryessa 2022-08-19 Napa 55 150   1624
663 663 Napa Napa 2022-08-19 Napa 55 18746   79852
664 664 North Calistoga North Calistoga 2022-08-19 Napa 55 100   980
665 665 Northeast American Canyon Area Northeast American Canyon Area 2022-08-19 Napa 55 29   212
666 666 Pope Valley Area Pope Valley Area 2022-08-19 Napa 55 99   1275
667 667 South Napa Area South Napa Area 2022-08-19 Napa 55 982   1961
668 668 St. Helena St. Helena 2022-08-19 Napa 55 925   6543
669 669 West Napa Area West Napa Area 2022-08-19 Napa 55 120   951
670 670 West Napa and Yountville Area West Napa and Yountville Area 2022-08-19 Napa 55 175   1699
671 671 Yountville Yountville 2022-08-19 Napa 55 449   3032
1877 1877 American Canyon American Canyon 2022-08-18 Napa 55 6233   17167
1878 1878 Angwin Angwin 2022-08-18 Napa 55 373   2046
1879 1879 Between St Helena and Calistoga Between St Helena and Calistoga 2022-08-18 Napa 55 160   1744
1880 1880 Between Yountville and St Helena Between Yountville and St Helena 2022-08-18 Napa 55 236   2753
1881 1881 Calistoga Calistoga 2022-08-18 Napa 55 1052   4759
1882 1882 Chiles Valley Area Chiles Valley Area 2022-08-18 Napa 55 46   776
1883 1883 Deer Park Deer Park 2022-08-18 Napa 55 119   1460
1884 1884 East Napa Area East Napa Area 2022-08-18 Napa 55 1114   10237
1885 1885 Lake Berryessa Lake Berryessa 2022-08-18 Napa 55 150   1624
1886 1886 Napa Napa 2022-08-18 Napa 55 18746   79852
1887 1887 North Calistoga North Calistoga 2022-08-18 Napa 55 100   980
1888 1888 Northeast American Canyon Area Northeast American Canyon Area 2022-08-18 Napa 55 29   212
1889 1889 Pope Valley Area Pope Valley Area 2022-08-18 Napa 55 99   1275
1890 1890 South Napa Area South Napa Area 2022-08-18 Napa 55 982   1961
1891 1891 St. Helena St. Helena 2022-08-18 Napa 55 925   6543
1892 1892 West Napa Area West Napa Area 2022-08-18 Napa 55 120   951
1893 1893 West Napa and Yountville Area West Napa and Yountville Area 2022-08-18 Napa 55 175   1699
1894 1894 Yountville Yountville 2022-08-18 Napa 55 449   3032
3115 3115 American Canyon American Canyon 2022-08-17 Napa 55 6233   17167
3116 3116 Angwin Angwin 2022-08-17 Napa 55 373   2046
3117 3117 Between St Helena and Calistoga Between St Helena and Calistoga 2022-08-17 Napa 55 160   1744
3118 3118 Between Yountville and St Helena Between Yountville and St Helena 2022-08-17 Napa 55 236   2753
3119 3119 Calistoga Calistoga 2022-08-17 Napa 55 1052   4759
3120 3120 Chiles Valley Area Chiles Valley Area 2022-08-17 Napa 55 46   776
3121 3121 Deer Park Deer Park 2022-08-17 Napa 55 119   1460
3122 3122 East Napa Area East Napa Area 2022-08-17 Napa 55 1114   10237
3123 3123 Lake Berryessa Lake Berryessa 2022-08-17 Napa 55 150   1624
3124 3124 Napa Napa 2022-08-17 Napa 55 18746   79852
3125 3125 North Calistoga North Calistoga 2022-08-17 Napa 55 100   980
3126 3126 Northeast American Canyon Area Northeast American Canyon Area 2022-08-17 Napa 55 29   212
3127 3127 Pope Valley Area Pope Valley Area 2022-08-17 Napa 55 99   1275
3128 3128 South Napa Area South Napa Area 2022-08-17 Napa 55 982   1961
3129 3129 St. Helena St. Helena 2022-08-17 Napa 55 925   6543
3130 3130 West Napa Area West Napa Area 2022-08-17 Napa 55 120   951
3131 3131 West Napa and Yountville Area West Napa and Yountville Area 2022-08-17 Napa 55 175   1699
3132 3132 Yountville Yountville 2022-08-17 Napa 55 449   3032
4353 4353 American Canyon American Canyon 2022-08-16 Napa 55 6233   17167
4354 4354 Angwin Angwin 2022-08-16 Napa 55 373   2046
4355 4355 Between St Helena and Calistoga Between St Helena and Calistoga 2022-08-16 Napa 55 160   1744
4356 4356 Between Yountville and St Helena Between Yountville and St Helena 2022-08-16 Napa 55 236   2753
4357 4357 Calistoga Calistoga 2022-08-16 Napa 55 1052   4759
4358 4358 Chiles Valley Area Chiles Valley Area 2022-08-16 Napa 55 46   776
4359 4359 Deer Park Deer Park 2022-08-16 Napa 55 119   1460
4360 4360 East Napa Area East Napa Area 2022-08-16 Napa 55 1114   10237
4361 4361 Lake Berryessa Lake Berryessa 2022-08-16 Napa 55 150   1624
4362 4362 Napa Napa 2022-08-16 Napa 55 18746   79852
4363 4363 North Calistoga North Calistoga 2022-08-16 Napa 55 100   980
4364 4364 Northeast American Canyon Area Northeast American Canyon Area 2022-08-16 Napa 55 29   212
4365 4365 Pope Valley Area Pope Valley Area 2022-08-16 Napa 55 99   1275
4366 4366 South Napa Area South Napa Area 2022-08-16 Napa 55 982   1961
4367 4367 St. Helena St. Helena 2022-08-16 Napa 55 925   6543
4368 4368 West Napa Area West Napa Area 2022-08-16 Napa 55 120   951
4369 4369 West Napa and Yountville Area West Napa and Yountville Area 2022-08-16 Napa 55 175   1699
4370 4370 Yountville Yountville 2022-08-16 Napa 55 449   3032
5623 5623 American Canyon American Canyon 2022-08-15 Napa 55 6201   17167
5624 5624 Angwin Angwin 2022-08-15 Napa 55 373   2046
5625 5625 Between St Helena and Calistoga Between St Helena and Calistoga 2022-08-15 Napa 55 160   1744
5626 5626 Between Yountville and St Helena Between Yountville and St Helena 2022-08-15 Napa 55 231   2753
5627 5627 Calistoga Calistoga 2022-08-15 Napa 55 1049   4759
5628 5628 Chiles Valley Area Chiles Valley Area 2022-08-15 Napa 55 46   776
5629 5629 Deer Park Deer Park 2022-08-15 Napa 55 118   1460
5630 5630 East Napa Area East Napa Area 2022-08-15 Napa 55 1109   10237
5631 5631 Lake Berryessa Lake Berryessa 2022-08-15 Napa 55 147   1624
5632 5632 Napa Napa 2022-08-15 Napa 55 18631   79852
5633 5633 North Calistoga North Calistoga 2022-08-15 Napa 55 98   980
5634 5634 Northeast American Canyon Area Northeast American Canyon Area 2022-08-15 Napa 55 29   212
5635 5635 Pope Valley Area Pope Valley Area 2022-08-15 Napa 55 98   1275
5636 5636 South Napa Area South Napa Area 2022-08-15 Napa 55 941   1961
5637 5637 St. Helena St. Helena 2022-08-15 Napa 55 918   6543
5638 5638 West Napa Area West Napa Area 2022-08-15 Napa 55 119   951
5639 5639 West Napa and Yountville Area West Napa and Yountville Area 2022-08-15 Napa 55 170   1699
5640 5640 Yountville Yountville 2022-08-15 Napa 55 444   3032
6893 6893 American Canyon American Canyon 2022-08-14 Napa 55 6201   17167
6894 6894 Angwin Angwin 2022-08-14 Napa 55 373   2046
6895 6895 Between St Helena and Calistoga Between St Helena and Calistoga 2022-08-14 Napa 55 160   1744
6896 6896 Between Yountville and St Helena Between Yountville and St Helena 2022-08-14 Napa 55 231   2753
6897 6897 Calistoga Calistoga 2022-08-14 Napa 55 1049   4759
6898 6898 Chiles Valley Area Chiles Valley Area 2022-08-14 Napa 55 46   776
6899 6899 Deer Park Deer Park 2022-08-14 Napa 55 118   1460
6900 6900 East Napa Area East Napa Area 2022-08-14 Napa 55 1109   10237
6901 6901 Lake Berryessa Lake Berryessa 2022-08-14 Napa 55 147   1624
6902 6902 Napa Napa 2022-08-14 Napa 55 18631   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
);
Powered by Datasette · Queries took 1166.164ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals