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

2,063 rows where fips = 55 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 55 · 2,063

county

Link rowid date ▲ county fips place confirmed_cases note x y
584 2020-10-30 Napa 55 American Canyon 330   -122.258349 38.179634
585 2020-10-30 Napa 55 Angwin 13   -122.449988 38.577228
586 2020-10-30 Napa 55 Between St Helena and Calistoga 51   -122.527537 38.542796
587 2020-10-30 Napa 55 Between Yountville and St Helena 20   -122.416388 38.446383
588 2020-10-30 Napa 55 Calistoga 144   -122.582477 38.581757
589 2020-10-30 Napa 55 Chiles Valley Area 1   -122.344756 38.529655
590 2020-10-30 Napa 55 Deer Park 3   -122.467043 38.536308
591 2020-10-30 Napa 55 East Napa Area 67   -122.211126 38.375796
592 2020-10-30 Napa 55 Lake Berryessa 3   -122.237357 38.622114
593 2020-10-30 Napa 55 Napa 1212   -122.359998 38.285942
594 2020-10-30 Napa 55 North Calistoga 4   -122.574599 38.623392
595 2020-10-30 Napa 55 Northeast American Canyon Area 1   -122.224884 38.19752
596 2020-10-30 Napa 55 Pope Valley Area 7   -122.416626 38.679329
597 2020-10-30 Napa 55 South Napa Area 21   -122.3163 38.1997
598 2020-10-30 Napa 55 St. Helena 72   -122.46819 38.50624
599 2020-10-30 Napa 55 West Napa Area 4   -122.353019 38.28391
600 2020-10-30 Napa 55 West Napa and Yountville Area 13   -122.38077 38.363302
601 2020-10-30 Napa 55 Yountville 20   -122.36711 38.396425
1574 2020-10-29 Napa 55 American Canyon 328   -122.258349 38.179634
1575 2020-10-29 Napa 55 Angwin 13   -122.449988 38.577228
1576 2020-10-29 Napa 55 Between St Helena and Calistoga 51   -122.527537 38.542796
1577 2020-10-29 Napa 55 Between Yountville and St Helena 26   -122.416388 38.446383
1578 2020-10-29 Napa 55 Calistoga 146   -122.582477 38.581757
1579 2020-10-29 Napa 55 Chiles Valley Area 1   -122.344756 38.529655
1580 2020-10-29 Napa 55 Deer Park 3   -122.467043 38.536308
1581 2020-10-29 Napa 55 East Napa Area 67   -122.211126 38.375796
1582 2020-10-29 Napa 55 Lake Berryessa 3   -122.237357 38.622114
1583 2020-10-29 Napa 55 Napa 1219   -122.359998 38.285942
1584 2020-10-29 Napa 55 North Calistoga 4   -122.574599 38.623392
1585 2020-10-29 Napa 55 Northeast American Canyon Area 1   -122.224884 38.19752
1586 2020-10-29 Napa 55 Pope Valley Area 8   -122.416626 38.679329
1587 2020-10-29 Napa 55 South Napa Area 21   -122.3163 38.1997
1588 2020-10-29 Napa 55 St. Helena 73   -122.46819 38.50624
1589 2020-10-29 Napa 55 West Napa Area 4   -122.353019 38.28391
1590 2020-10-29 Napa 55 West Napa and Yountville Area 14   -122.38077 38.363302
1591 2020-10-29 Napa 55 Yountville 20   -122.36711 38.396425
2575 2020-10-28 Napa 55 American Canyon 328   -122.258349 38.179634
2576 2020-10-28 Napa 55 Angwin 13   -122.449988 38.577228
2577 2020-10-28 Napa 55 Between St Helena and Calistoga 51   -122.527537 38.542796
2578 2020-10-28 Napa 55 Between Yountville and St Helena 26   -122.416388 38.446383
2579 2020-10-28 Napa 55 Calistoga 145   -122.582477 38.581757
2580 2020-10-28 Napa 55 Chiles Valley Area 1   -122.344756 38.529655
2581 2020-10-28 Napa 55 Deer Park 3   -122.467043 38.536308
2582 2020-10-28 Napa 55 East Napa Area 67   -122.211126 38.375796
2583 2020-10-28 Napa 55 Lake Berryessa 3   -122.237357 38.622114
2584 2020-10-28 Napa 55 Napa 1210   -122.359998 38.285942
2585 2020-10-28 Napa 55 North Calistoga 4   -122.574599 38.623392
2586 2020-10-28 Napa 55 Northeast American Canyon Area 1   -122.224884 38.19752
2587 2020-10-28 Napa 55 Pope Valley Area 8   -122.416626 38.679329
2588 2020-10-28 Napa 55 South Napa Area 21   -122.3163 38.1997
2589 2020-10-28 Napa 55 St. Helena 73   -122.46819 38.50624
2590 2020-10-28 Napa 55 West Napa Area 4   -122.353019 38.28391
2591 2020-10-28 Napa 55 West Napa and Yountville Area 14   -122.38077 38.363302
2592 2020-10-28 Napa 55 Yountville 20   -122.36711 38.396425
3534 2020-10-27 Napa 55 American Canyon 327   -122.258349 38.179634
3535 2020-10-27 Napa 55 Angwin 13   -122.449988 38.577228
3536 2020-10-27 Napa 55 Between St Helena and Calistoga 51   -122.527537 38.542796
3537 2020-10-27 Napa 55 Between Yountville and St Helena 26   -122.416388 38.446383
3538 2020-10-27 Napa 55 Calistoga 145   -122.582477 38.581757
3539 2020-10-27 Napa 55 Chiles Valley Area 1   -122.344756 38.529655
3540 2020-10-27 Napa 55 Deer Park 3   -122.467043 38.536308
3541 2020-10-27 Napa 55 East Napa Area 65   -122.211126 38.375796
3542 2020-10-27 Napa 55 Lake Berryessa 3   -122.237357 38.622114
3543 2020-10-27 Napa 55 Napa 1198   -122.359998 38.285942
3544 2020-10-27 Napa 55 North Calistoga 4   -122.574599 38.623392
3545 2020-10-27 Napa 55 Northeast American Canyon Area 1   -122.224884 38.19752
3546 2020-10-27 Napa 55 Pope Valley Area 8   -122.416626 38.679329
3547 2020-10-27 Napa 55 South Napa Area 21   -122.3163 38.1997
3548 2020-10-27 Napa 55 St. Helena 72   -122.46819 38.50624
3549 2020-10-27 Napa 55 West Napa Area 3   -122.353019 38.28391
3550 2020-10-27 Napa 55 West Napa and Yountville Area 14   -122.38077 38.363302
3551 2020-10-27 Napa 55 Yountville 20   -122.36711 38.396425
4496 2020-10-26 Napa 55 American Canyon 327   -122.258349 38.179634
4497 2020-10-26 Napa 55 Angwin 13   -122.449988 38.577228
4498 2020-10-26 Napa 55 Between St Helena and Calistoga 51   -122.527537 38.542796
4499 2020-10-26 Napa 55 Between Yountville and St Helena 26   -122.416388 38.446383
4500 2020-10-26 Napa 55 Calistoga 145   -122.582477 38.581757
4501 2020-10-26 Napa 55 Chiles Valley Area 1   -122.344756 38.529655
4502 2020-10-26 Napa 55 Deer Park 3   -122.467043 38.536308
4503 2020-10-26 Napa 55 East Napa Area 64   -122.211126 38.375796
4504 2020-10-26 Napa 55 Lake Berryessa 3   -122.237357 38.622114
4505 2020-10-26 Napa 55 Napa 1185   -122.359998 38.285942
4506 2020-10-26 Napa 55 North Calistoga 4   -122.574599 38.623392
4507 2020-10-26 Napa 55 Northeast American Canyon Area 1   -122.224884 38.19752
4508 2020-10-26 Napa 55 Pope Valley Area 8   -122.416626 38.679329
4509 2020-10-26 Napa 55 South Napa Area 21   -122.3163 38.1997
4510 2020-10-26 Napa 55 St. Helena 72   -122.46819 38.50624
4511 2020-10-26 Napa 55 West Napa Area 3   -122.353019 38.28391
4512 2020-10-26 Napa 55 West Napa and Yountville Area 14   -122.38077 38.363302
4513 2020-10-26 Napa 55 Yountville 20   -122.36711 38.396425
6778 2020-10-23 Napa 55 American Canyon 325   -122.258349 38.179634
6779 2020-10-23 Napa 55 Angwin 13   -122.449988 38.577228
6780 2020-10-23 Napa 55 Between St Helena and Calistoga 51   -122.527537 38.542796
6781 2020-10-23 Napa 55 Between Yountville and St Helena 26   -122.416388 38.446383
6782 2020-10-23 Napa 55 Calistoga 144   -122.582477 38.581757
6783 2020-10-23 Napa 55 Chiles Valley Area 1   -122.344756 38.529655
6784 2020-10-23 Napa 55 Deer Park 3   -122.467043 38.536308
6785 2020-10-23 Napa 55 East Napa Area 63   -122.211126 38.375796
6786 2020-10-23 Napa 55 Lake Berryessa 3   -122.237357 38.622114
6787 2020-10-23 Napa 55 Napa 1170   -122.359998 38.285942

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 853.606ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals