latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
17,730 rows where county = "Napa" and fips = 55 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
593526 | 593526 | American Canyon | American Canyon | 2021-09-15 | Napa | 55 | 2128 | 17167 | |
593527 | 593527 | Angwin | Angwin | 2021-09-15 | Napa | 55 | 125 | 2046 | |
593528 | 593528 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-09-15 | Napa | 55 | 89 | 1744 | |
593529 | 593529 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-09-15 | Napa | 55 | 85 | 2753 | |
593530 | 593530 | Calistoga | Calistoga | 2021-09-15 | Napa | 55 | 505 | 4759 | |
593531 | 593531 | Chiles Valley Area | Chiles Valley Area | 2021-09-15 | Napa | 55 | 6 | 776 | |
593532 | 593532 | Deer Park | Deer Park | 2021-09-15 | Napa | 55 | 69 | 1460 | |
593533 | 593533 | East Napa Area | East Napa Area | 2021-09-15 | Napa | 55 | 382 | 10237 | |
593534 | 593534 | Lake Berryessa | Lake Berryessa | 2021-09-15 | Napa | 55 | 52 | 1624 | |
593535 | 593535 | Napa | Napa | 2021-09-15 | Napa | 55 | 7282 | 79852 | |
593536 | 593536 | North Calistoga | North Calistoga | 2021-09-15 | Napa | 55 | 53 | 980 | |
593537 | 593537 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-09-15 | Napa | 55 | 15 | 212 | |
593538 | 593538 | Pope Valley Area | Pope Valley Area | 2021-09-15 | Napa | 55 | 38 | 1275 | |
593539 | 593539 | South Napa Area | South Napa Area | 2021-09-15 | Napa | 55 | 304 | 1961 | |
593540 | 593540 | St. Helena | St. Helena | 2021-09-15 | Napa | 55 | 327 | 6543 | |
593541 | 593541 | West Napa Area | West Napa Area | 2021-09-15 | Napa | 55 | 40 | 951 | |
593542 | 593542 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-09-15 | Napa | 55 | 59 | 1699 | |
593543 | 593543 | Yountville | Yountville | 2021-09-15 | Napa | 55 | 175 | 3032 | |
594802 | 594802 | American Canyon | American Canyon | 2021-09-14 | Napa | 55 | 2128 | 17167 | |
594803 | 594803 | Angwin | Angwin | 2021-09-14 | Napa | 55 | 125 | 2046 | |
594804 | 594804 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-09-14 | Napa | 55 | 89 | 1744 | |
594805 | 594805 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-09-14 | Napa | 55 | 85 | 2753 | |
594806 | 594806 | Calistoga | Calistoga | 2021-09-14 | Napa | 55 | 505 | 4759 | |
594807 | 594807 | Chiles Valley Area | Chiles Valley Area | 2021-09-14 | Napa | 55 | 6 | 776 | |
594808 | 594808 | Deer Park | Deer Park | 2021-09-14 | Napa | 55 | 69 | 1460 | |
594809 | 594809 | East Napa Area | East Napa Area | 2021-09-14 | Napa | 55 | 382 | 10237 | |
594810 | 594810 | Lake Berryessa | Lake Berryessa | 2021-09-14 | Napa | 55 | 52 | 1624 | |
594811 | 594811 | Napa | Napa | 2021-09-14 | Napa | 55 | 7282 | 79852 | |
594812 | 594812 | North Calistoga | North Calistoga | 2021-09-14 | Napa | 55 | 53 | 980 | |
594813 | 594813 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-09-14 | Napa | 55 | 15 | 212 | |
594814 | 594814 | Pope Valley Area | Pope Valley Area | 2021-09-14 | Napa | 55 | 38 | 1275 | |
594815 | 594815 | South Napa Area | South Napa Area | 2021-09-14 | Napa | 55 | 304 | 1961 | |
594816 | 594816 | St. Helena | St. Helena | 2021-09-14 | Napa | 55 | 327 | 6543 | |
594817 | 594817 | West Napa Area | West Napa Area | 2021-09-14 | Napa | 55 | 40 | 951 | |
594818 | 594818 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-09-14 | Napa | 55 | 59 | 1699 | |
594819 | 594819 | Yountville | Yountville | 2021-09-14 | Napa | 55 | 175 | 3032 | |
596078 | 596078 | American Canyon | American Canyon | 2021-09-13 | Napa | 55 | 2128 | 17167 | |
596079 | 596079 | Angwin | Angwin | 2021-09-13 | Napa | 55 | 125 | 2046 | |
596080 | 596080 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-09-13 | Napa | 55 | 89 | 1744 | |
596081 | 596081 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-09-13 | Napa | 55 | 85 | 2753 | |
596082 | 596082 | Calistoga | Calistoga | 2021-09-13 | Napa | 55 | 505 | 4759 | |
596083 | 596083 | Chiles Valley Area | Chiles Valley Area | 2021-09-13 | Napa | 55 | 6 | 776 | |
596084 | 596084 | Deer Park | Deer Park | 2021-09-13 | Napa | 55 | 69 | 1460 | |
596085 | 596085 | East Napa Area | East Napa Area | 2021-09-13 | Napa | 55 | 382 | 10237 | |
596086 | 596086 | Lake Berryessa | Lake Berryessa | 2021-09-13 | Napa | 55 | 52 | 1624 | |
596087 | 596087 | Napa | Napa | 2021-09-13 | Napa | 55 | 7282 | 79852 | |
596088 | 596088 | North Calistoga | North Calistoga | 2021-09-13 | Napa | 55 | 53 | 980 | |
596089 | 596089 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-09-13 | Napa | 55 | 15 | 212 | |
596090 | 596090 | Pope Valley Area | Pope Valley Area | 2021-09-13 | Napa | 55 | 38 | 1275 | |
596091 | 596091 | South Napa Area | South Napa Area | 2021-09-13 | Napa | 55 | 304 | 1961 | |
596092 | 596092 | St. Helena | St. Helena | 2021-09-13 | Napa | 55 | 327 | 6543 | |
596093 | 596093 | West Napa Area | West Napa Area | 2021-09-13 | Napa | 55 | 40 | 951 | |
596094 | 596094 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-09-13 | Napa | 55 | 59 | 1699 | |
596095 | 596095 | Yountville | Yountville | 2021-09-13 | Napa | 55 | 175 | 3032 | |
597354 | 597354 | American Canyon | American Canyon | 2021-09-12 | Napa | 55 | 2128 | 17167 | |
597355 | 597355 | Angwin | Angwin | 2021-09-12 | Napa | 55 | 125 | 2046 | |
597356 | 597356 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-09-12 | Napa | 55 | 89 | 1744 | |
597357 | 597357 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-09-12 | Napa | 55 | 85 | 2753 | |
597358 | 597358 | Calistoga | Calistoga | 2021-09-12 | Napa | 55 | 505 | 4759 | |
597359 | 597359 | Chiles Valley Area | Chiles Valley Area | 2021-09-12 | Napa | 55 | 6 | 776 | |
597360 | 597360 | Deer Park | Deer Park | 2021-09-12 | Napa | 55 | 69 | 1460 | |
597361 | 597361 | East Napa Area | East Napa Area | 2021-09-12 | Napa | 55 | 382 | 10237 | |
597362 | 597362 | Lake Berryessa | Lake Berryessa | 2021-09-12 | Napa | 55 | 52 | 1624 | |
597363 | 597363 | Napa | Napa | 2021-09-12 | Napa | 55 | 7282 | 79852 | |
597364 | 597364 | North Calistoga | North Calistoga | 2021-09-12 | Napa | 55 | 53 | 980 | |
597365 | 597365 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-09-12 | Napa | 55 | 15 | 212 | |
597366 | 597366 | Pope Valley Area | Pope Valley Area | 2021-09-12 | Napa | 55 | 38 | 1275 | |
597367 | 597367 | South Napa Area | South Napa Area | 2021-09-12 | Napa | 55 | 304 | 1961 | |
597368 | 597368 | St. Helena | St. Helena | 2021-09-12 | Napa | 55 | 327 | 6543 | |
597369 | 597369 | West Napa Area | West Napa Area | 2021-09-12 | Napa | 55 | 40 | 951 | |
597370 | 597370 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-09-12 | Napa | 55 | 59 | 1699 | |
597371 | 597371 | Yountville | Yountville | 2021-09-12 | Napa | 55 | 175 | 3032 | |
598630 | 598630 | American Canyon | American Canyon | 2021-09-11 | Napa | 55 | 2128 | 17167 | |
598631 | 598631 | Angwin | Angwin | 2021-09-11 | Napa | 55 | 125 | 2046 | |
598632 | 598632 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-09-11 | Napa | 55 | 89 | 1744 | |
598633 | 598633 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-09-11 | Napa | 55 | 85 | 2753 | |
598634 | 598634 | Calistoga | Calistoga | 2021-09-11 | Napa | 55 | 505 | 4759 | |
598635 | 598635 | Chiles Valley Area | Chiles Valley Area | 2021-09-11 | Napa | 55 | 6 | 776 | |
598636 | 598636 | Deer Park | Deer Park | 2021-09-11 | Napa | 55 | 69 | 1460 | |
598637 | 598637 | East Napa Area | East Napa Area | 2021-09-11 | Napa | 55 | 382 | 10237 | |
598638 | 598638 | Lake Berryessa | Lake Berryessa | 2021-09-11 | Napa | 55 | 52 | 1624 | |
598639 | 598639 | Napa | Napa | 2021-09-11 | Napa | 55 | 7282 | 79852 | |
598640 | 598640 | North Calistoga | North Calistoga | 2021-09-11 | Napa | 55 | 53 | 980 | |
598641 | 598641 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-09-11 | Napa | 55 | 15 | 212 | |
598642 | 598642 | Pope Valley Area | Pope Valley Area | 2021-09-11 | Napa | 55 | 38 | 1275 | |
598643 | 598643 | South Napa Area | South Napa Area | 2021-09-11 | Napa | 55 | 304 | 1961 | |
598644 | 598644 | St. Helena | St. Helena | 2021-09-11 | Napa | 55 | 327 | 6543 | |
598645 | 598645 | West Napa Area | West Napa Area | 2021-09-11 | Napa | 55 | 40 | 951 | |
598646 | 598646 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-09-11 | Napa | 55 | 59 | 1699 | |
598647 | 598647 | Yountville | Yountville | 2021-09-11 | Napa | 55 | 175 | 3032 | |
599906 | 599906 | American Canyon | American Canyon | 2021-09-10 | Napa | 55 | 2128 | 17167 | |
599907 | 599907 | Angwin | Angwin | 2021-09-10 | Napa | 55 | 125 | 2046 | |
599908 | 599908 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-09-10 | Napa | 55 | 89 | 1744 | |
599909 | 599909 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-09-10 | Napa | 55 | 85 | 2753 | |
599910 | 599910 | Calistoga | Calistoga | 2021-09-10 | Napa | 55 | 505 | 4759 | |
599911 | 599911 | Chiles Valley Area | Chiles Valley Area | 2021-09-10 | Napa | 55 | 6 | 776 | |
599912 | 599912 | Deer Park | Deer Park | 2021-09-10 | Napa | 55 | 69 | 1460 | |
599913 | 599913 | East Napa Area | East Napa Area | 2021-09-10 | Napa | 55 | 382 | 10237 | |
599914 | 599914 | Lake Berryessa | Lake Berryessa | 2021-09-10 | Napa | 55 | 52 | 1624 | |
599915 | 599915 | Napa | Napa | 2021-09-10 | Napa | 55 | 7282 | 79852 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );