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

17,730 rows where county = "Napa" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 55 17,730

county 1

  • Napa · 17,730 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
276 276 American Canyon American Canyon 2022-12-30 Napa 55 6739   17167
277 277 Angwin Angwin 2022-12-30 Napa 55 380   2046
278 278 Between St Helena and Calistoga Between St Helena and Calistoga 2022-12-30 Napa 55 171   1744
279 279 Between Yountville and St Helena Between Yountville and St Helena 2022-12-30 Napa 55 253   2753
280 280 Calistoga Calistoga 2022-12-30 Napa 55 1100   4759
281 281 Chiles Valley Area Chiles Valley Area 2022-12-30 Napa 55 51   776
282 282 Deer Park Deer Park 2022-12-30 Napa 55 130   1460
283 283 East Napa Area East Napa Area 2022-12-30 Napa 55 1208   10237
284 284 Lake Berryessa Lake Berryessa 2022-12-30 Napa 55 163   1624
285 285 Napa Napa 2022-12-30 Napa 55 19892   79852
286 286 North Calistoga North Calistoga 2022-12-30 Napa 55 105   980
287 287 Northeast American Canyon Area Northeast American Canyon Area 2022-12-30 Napa 55 31   212
288 288 Pope Valley Area Pope Valley Area 2022-12-30 Napa 55 106   1275
289 289 South Napa Area South Napa Area 2022-12-30 Napa 55 1045   1961
290 290 St. Helena St. Helena 2022-12-30 Napa 55 961   6543
291 291 West Napa Area West Napa Area 2022-12-30 Napa 55 138   951
292 292 West Napa and Yountville Area West Napa and Yountville Area 2022-12-30 Napa 55 190   1699
293 293 Yountville Yountville 2022-12-30 Napa 55 528   3032
1104 1104 American Canyon American Canyon 2022-12-29 Napa 55 6739   17167
1105 1105 Angwin Angwin 2022-12-29 Napa 55 380   2046
1106 1106 Between St Helena and Calistoga Between St Helena and Calistoga 2022-12-29 Napa 55 171   1744
1107 1107 Between Yountville and St Helena Between Yountville and St Helena 2022-12-29 Napa 55 253   2753
1108 1108 Calistoga Calistoga 2022-12-29 Napa 55 1100   4759
1109 1109 Chiles Valley Area Chiles Valley Area 2022-12-29 Napa 55 51   776
1110 1110 Deer Park Deer Park 2022-12-29 Napa 55 130   1460
1111 1111 East Napa Area East Napa Area 2022-12-29 Napa 55 1208   10237
1112 1112 Lake Berryessa Lake Berryessa 2022-12-29 Napa 55 163   1624
1113 1113 Napa Napa 2022-12-29 Napa 55 19892   79852
1114 1114 North Calistoga North Calistoga 2022-12-29 Napa 55 105   980
1115 1115 Northeast American Canyon Area Northeast American Canyon Area 2022-12-29 Napa 55 31   212
1116 1116 Pope Valley Area Pope Valley Area 2022-12-29 Napa 55 106   1275
1117 1117 South Napa Area South Napa Area 2022-12-29 Napa 55 1045   1961
1118 1118 St. Helena St. Helena 2022-12-29 Napa 55 961   6543
1119 1119 West Napa Area West Napa Area 2022-12-29 Napa 55 138   951
1120 1120 West Napa and Yountville Area West Napa and Yountville Area 2022-12-29 Napa 55 190   1699
1121 1121 Yountville Yountville 2022-12-29 Napa 55 528   3032
2285 2285 American Canyon American Canyon 2022-12-28 Napa 55 6698   17167
2286 2286 Angwin Angwin 2022-12-28 Napa 55 380   2046
2287 2287 Between St Helena and Calistoga Between St Helena and Calistoga 2022-12-28 Napa 55 171   1744
2288 2288 Between Yountville and St Helena Between Yountville and St Helena 2022-12-28 Napa 55 252   2753
2289 2289 Calistoga Calistoga 2022-12-28 Napa 55 1093   4759
2290 2290 Chiles Valley Area Chiles Valley Area 2022-12-28 Napa 55 51   776
2291 2291 Deer Park Deer Park 2022-12-28 Napa 55 129   1460
2292 2292 East Napa Area East Napa Area 2022-12-28 Napa 55 1197   10237
2293 2293 Lake Berryessa Lake Berryessa 2022-12-28 Napa 55 163   1624
2294 2294 Napa Napa 2022-12-28 Napa 55 19804   79852
2295 2295 North Calistoga North Calistoga 2022-12-28 Napa 55 106   980
2296 2296 Northeast American Canyon Area Northeast American Canyon Area 2022-12-28 Napa 55 31   212
2297 2297 Pope Valley Area Pope Valley Area 2022-12-28 Napa 55 106   1275
2298 2298 South Napa Area South Napa Area 2022-12-28 Napa 55 1037   1961
2299 2299 St. Helena St. Helena 2022-12-28 Napa 55 958   6543
2300 2300 West Napa Area West Napa Area 2022-12-28 Napa 55 134   951
2301 2301 West Napa and Yountville Area West Napa and Yountville Area 2022-12-28 Napa 55 188   1699
2302 2302 Yountville Yountville 2022-12-28 Napa 55 520   3032
3466 3466 American Canyon American Canyon 2022-12-27 Napa 55 6698   17167
3467 3467 Angwin Angwin 2022-12-27 Napa 55 380   2046
3468 3468 Between St Helena and Calistoga Between St Helena and Calistoga 2022-12-27 Napa 55 171   1744
3469 3469 Between Yountville and St Helena Between Yountville and St Helena 2022-12-27 Napa 55 252   2753
3470 3470 Calistoga Calistoga 2022-12-27 Napa 55 1093   4759
3471 3471 Chiles Valley Area Chiles Valley Area 2022-12-27 Napa 55 51   776
3472 3472 Deer Park Deer Park 2022-12-27 Napa 55 129   1460
3473 3473 East Napa Area East Napa Area 2022-12-27 Napa 55 1197   10237
3474 3474 Lake Berryessa Lake Berryessa 2022-12-27 Napa 55 163   1624
3475 3475 Napa Napa 2022-12-27 Napa 55 19804   79852
3476 3476 North Calistoga North Calistoga 2022-12-27 Napa 55 106   980
3477 3477 Northeast American Canyon Area Northeast American Canyon Area 2022-12-27 Napa 55 31   212
3478 3478 Pope Valley Area Pope Valley Area 2022-12-27 Napa 55 106   1275
3479 3479 South Napa Area South Napa Area 2022-12-27 Napa 55 1037   1961
3480 3480 St. Helena St. Helena 2022-12-27 Napa 55 958   6543
3481 3481 West Napa Area West Napa Area 2022-12-27 Napa 55 134   951
3482 3482 West Napa and Yountville Area West Napa and Yountville Area 2022-12-27 Napa 55 188   1699
3483 3483 Yountville Yountville 2022-12-27 Napa 55 520   3032
4647 4647 American Canyon American Canyon 2022-12-26 Napa 55 6698   17167
4648 4648 Angwin Angwin 2022-12-26 Napa 55 380   2046
4649 4649 Between St Helena and Calistoga Between St Helena and Calistoga 2022-12-26 Napa 55 171   1744
4650 4650 Between Yountville and St Helena Between Yountville and St Helena 2022-12-26 Napa 55 252   2753
4651 4651 Calistoga Calistoga 2022-12-26 Napa 55 1093   4759
4652 4652 Chiles Valley Area Chiles Valley Area 2022-12-26 Napa 55 51   776
4653 4653 Deer Park Deer Park 2022-12-26 Napa 55 129   1460
4654 4654 East Napa Area East Napa Area 2022-12-26 Napa 55 1197   10237
4655 4655 Lake Berryessa Lake Berryessa 2022-12-26 Napa 55 163   1624
4656 4656 Napa Napa 2022-12-26 Napa 55 19804   79852
4657 4657 North Calistoga North Calistoga 2022-12-26 Napa 55 106   980
4658 4658 Northeast American Canyon Area Northeast American Canyon Area 2022-12-26 Napa 55 31   212
4659 4659 Pope Valley Area Pope Valley Area 2022-12-26 Napa 55 106   1275
4660 4660 South Napa Area South Napa Area 2022-12-26 Napa 55 1037   1961
4661 4661 St. Helena St. Helena 2022-12-26 Napa 55 958   6543
4662 4662 West Napa Area West Napa Area 2022-12-26 Napa 55 134   951
4663 4663 West Napa and Yountville Area West Napa and Yountville Area 2022-12-26 Napa 55 188   1699
4664 4664 Yountville Yountville 2022-12-26 Napa 55 520   3032
5828 5828 American Canyon American Canyon 2022-12-25 Napa 55 6698   17167
5829 5829 Angwin Angwin 2022-12-25 Napa 55 380   2046
5830 5830 Between St Helena and Calistoga Between St Helena and Calistoga 2022-12-25 Napa 55 171   1744
5831 5831 Between Yountville and St Helena Between Yountville and St Helena 2022-12-25 Napa 55 252   2753
5832 5832 Calistoga Calistoga 2022-12-25 Napa 55 1093   4759
5833 5833 Chiles Valley Area Chiles Valley Area 2022-12-25 Napa 55 51   776
5834 5834 Deer Park Deer Park 2022-12-25 Napa 55 129   1460
5835 5835 East Napa Area East Napa Area 2022-12-25 Napa 55 1197   10237
5836 5836 Lake Berryessa Lake Berryessa 2022-12-25 Napa 55 163   1624
5837 5837 Napa Napa 2022-12-25 Napa 55 19804   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 1886.094ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals