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 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 |
---|---|---|---|---|---|---|---|---|---|
170797 | 170797 | American Canyon | American Canyon | 2022-08-14 | Napa | 55 | 6201 | 17167 | |
170798 | 170798 | Angwin | Angwin | 2022-08-14 | Napa | 55 | 373 | 2046 | |
170799 | 170799 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-08-14 | Napa | 55 | 160 | 1744 | |
170800 | 170800 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-08-14 | Napa | 55 | 231 | 2753 | |
170801 | 170801 | Calistoga | Calistoga | 2022-08-14 | Napa | 55 | 1049 | 4759 | |
170802 | 170802 | Chiles Valley Area | Chiles Valley Area | 2022-08-14 | Napa | 55 | 46 | 776 | |
170803 | 170803 | Deer Park | Deer Park | 2022-08-14 | Napa | 55 | 118 | 1460 | |
170804 | 170804 | East Napa Area | East Napa Area | 2022-08-14 | Napa | 55 | 1109 | 10237 | |
170805 | 170805 | Lake Berryessa | Lake Berryessa | 2022-08-14 | Napa | 55 | 147 | 1624 | |
170806 | 170806 | Napa | Napa | 2022-08-14 | Napa | 55 | 18631 | 79852 | |
170807 | 170807 | North Calistoga | North Calistoga | 2022-08-14 | Napa | 55 | 98 | 980 | |
170808 | 170808 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-08-14 | Napa | 55 | 29 | 212 | |
170809 | 170809 | Pope Valley Area | Pope Valley Area | 2022-08-14 | Napa | 55 | 98 | 1275 | |
170810 | 170810 | South Napa Area | South Napa Area | 2022-08-14 | Napa | 55 | 941 | 1961 | |
170811 | 170811 | St. Helena | St. Helena | 2022-08-14 | Napa | 55 | 918 | 6543 | |
170812 | 170812 | West Napa Area | West Napa Area | 2022-08-14 | Napa | 55 | 119 | 951 | |
170813 | 170813 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-08-14 | Napa | 55 | 170 | 1699 | |
170814 | 170814 | Yountville | Yountville | 2022-08-14 | Napa | 55 | 444 | 3032 | |
172060 | 172060 | American Canyon | American Canyon | 2022-08-13 | Napa | 55 | 6201 | 17167 | |
172061 | 172061 | Angwin | Angwin | 2022-08-13 | Napa | 55 | 373 | 2046 | |
172062 | 172062 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-08-13 | Napa | 55 | 160 | 1744 | |
172063 | 172063 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-08-13 | Napa | 55 | 231 | 2753 | |
172064 | 172064 | Calistoga | Calistoga | 2022-08-13 | Napa | 55 | 1049 | 4759 | |
172065 | 172065 | Chiles Valley Area | Chiles Valley Area | 2022-08-13 | Napa | 55 | 46 | 776 | |
172066 | 172066 | Deer Park | Deer Park | 2022-08-13 | Napa | 55 | 118 | 1460 | |
172067 | 172067 | East Napa Area | East Napa Area | 2022-08-13 | Napa | 55 | 1109 | 10237 | |
172068 | 172068 | Lake Berryessa | Lake Berryessa | 2022-08-13 | Napa | 55 | 147 | 1624 | |
172069 | 172069 | Napa | Napa | 2022-08-13 | Napa | 55 | 18631 | 79852 | |
172070 | 172070 | North Calistoga | North Calistoga | 2022-08-13 | Napa | 55 | 98 | 980 | |
172071 | 172071 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-08-13 | Napa | 55 | 29 | 212 | |
172072 | 172072 | Pope Valley Area | Pope Valley Area | 2022-08-13 | Napa | 55 | 98 | 1275 | |
172073 | 172073 | South Napa Area | South Napa Area | 2022-08-13 | Napa | 55 | 941 | 1961 | |
172074 | 172074 | St. Helena | St. Helena | 2022-08-13 | Napa | 55 | 918 | 6543 | |
172075 | 172075 | West Napa Area | West Napa Area | 2022-08-13 | Napa | 55 | 119 | 951 | |
172076 | 172076 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-08-13 | Napa | 55 | 170 | 1699 | |
172077 | 172077 | Yountville | Yountville | 2022-08-13 | Napa | 55 | 444 | 3032 | |
173323 | 173323 | American Canyon | American Canyon | 2022-08-12 | Napa | 55 | 6201 | 17167 | |
173324 | 173324 | Angwin | Angwin | 2022-08-12 | Napa | 55 | 373 | 2046 | |
173325 | 173325 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-08-12 | Napa | 55 | 160 | 1744 | |
173326 | 173326 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-08-12 | Napa | 55 | 231 | 2753 | |
173327 | 173327 | Calistoga | Calistoga | 2022-08-12 | Napa | 55 | 1049 | 4759 | |
173328 | 173328 | Chiles Valley Area | Chiles Valley Area | 2022-08-12 | Napa | 55 | 46 | 776 | |
173329 | 173329 | Deer Park | Deer Park | 2022-08-12 | Napa | 55 | 118 | 1460 | |
173330 | 173330 | East Napa Area | East Napa Area | 2022-08-12 | Napa | 55 | 1109 | 10237 | |
173331 | 173331 | Lake Berryessa | Lake Berryessa | 2022-08-12 | Napa | 55 | 147 | 1624 | |
173332 | 173332 | Napa | Napa | 2022-08-12 | Napa | 55 | 18631 | 79852 | |
173333 | 173333 | North Calistoga | North Calistoga | 2022-08-12 | Napa | 55 | 98 | 980 | |
173334 | 173334 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-08-12 | Napa | 55 | 29 | 212 | |
173335 | 173335 | Pope Valley Area | Pope Valley Area | 2022-08-12 | Napa | 55 | 98 | 1275 | |
173336 | 173336 | South Napa Area | South Napa Area | 2022-08-12 | Napa | 55 | 941 | 1961 | |
173337 | 173337 | St. Helena | St. Helena | 2022-08-12 | Napa | 55 | 918 | 6543 | |
173338 | 173338 | West Napa Area | West Napa Area | 2022-08-12 | Napa | 55 | 119 | 951 | |
173339 | 173339 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-08-12 | Napa | 55 | 170 | 1699 | |
173340 | 173340 | Yountville | Yountville | 2022-08-12 | Napa | 55 | 444 | 3032 | |
174586 | 174586 | American Canyon | American Canyon | 2022-08-11 | Napa | 55 | 6201 | 17167 | |
174587 | 174587 | Angwin | Angwin | 2022-08-11 | Napa | 55 | 373 | 2046 | |
174588 | 174588 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-08-11 | Napa | 55 | 160 | 1744 | |
174589 | 174589 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-08-11 | Napa | 55 | 231 | 2753 | |
174590 | 174590 | Calistoga | Calistoga | 2022-08-11 | Napa | 55 | 1049 | 4759 | |
174591 | 174591 | Chiles Valley Area | Chiles Valley Area | 2022-08-11 | Napa | 55 | 46 | 776 | |
174592 | 174592 | Deer Park | Deer Park | 2022-08-11 | Napa | 55 | 118 | 1460 | |
174593 | 174593 | East Napa Area | East Napa Area | 2022-08-11 | Napa | 55 | 1109 | 10237 | |
174594 | 174594 | Lake Berryessa | Lake Berryessa | 2022-08-11 | Napa | 55 | 147 | 1624 | |
174595 | 174595 | Napa | Napa | 2022-08-11 | Napa | 55 | 18631 | 79852 | |
174596 | 174596 | North Calistoga | North Calistoga | 2022-08-11 | Napa | 55 | 98 | 980 | |
174597 | 174597 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-08-11 | Napa | 55 | 29 | 212 | |
174598 | 174598 | Pope Valley Area | Pope Valley Area | 2022-08-11 | Napa | 55 | 98 | 1275 | |
174599 | 174599 | South Napa Area | South Napa Area | 2022-08-11 | Napa | 55 | 941 | 1961 | |
174600 | 174600 | St. Helena | St. Helena | 2022-08-11 | Napa | 55 | 918 | 6543 | |
174601 | 174601 | West Napa Area | West Napa Area | 2022-08-11 | Napa | 55 | 119 | 951 | |
174602 | 174602 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-08-11 | Napa | 55 | 170 | 1699 | |
174603 | 174603 | Yountville | Yountville | 2022-08-11 | Napa | 55 | 444 | 3032 | |
175849 | 175849 | American Canyon | American Canyon | 2022-08-10 | Napa | 55 | 6201 | 17167 | |
175850 | 175850 | Angwin | Angwin | 2022-08-10 | Napa | 55 | 373 | 2046 | |
175851 | 175851 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-08-10 | Napa | 55 | 160 | 1744 | |
175852 | 175852 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-08-10 | Napa | 55 | 231 | 2753 | |
175853 | 175853 | Calistoga | Calistoga | 2022-08-10 | Napa | 55 | 1049 | 4759 | |
175854 | 175854 | Chiles Valley Area | Chiles Valley Area | 2022-08-10 | Napa | 55 | 46 | 776 | |
175855 | 175855 | Deer Park | Deer Park | 2022-08-10 | Napa | 55 | 118 | 1460 | |
175856 | 175856 | East Napa Area | East Napa Area | 2022-08-10 | Napa | 55 | 1109 | 10237 | |
175857 | 175857 | Lake Berryessa | Lake Berryessa | 2022-08-10 | Napa | 55 | 147 | 1624 | |
175858 | 175858 | Napa | Napa | 2022-08-10 | Napa | 55 | 18631 | 79852 | |
175859 | 175859 | North Calistoga | North Calistoga | 2022-08-10 | Napa | 55 | 98 | 980 | |
175860 | 175860 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-08-10 | Napa | 55 | 29 | 212 | |
175861 | 175861 | Pope Valley Area | Pope Valley Area | 2022-08-10 | Napa | 55 | 98 | 1275 | |
175862 | 175862 | South Napa Area | South Napa Area | 2022-08-10 | Napa | 55 | 941 | 1961 | |
175863 | 175863 | St. Helena | St. Helena | 2022-08-10 | Napa | 55 | 918 | 6543 | |
175864 | 175864 | West Napa Area | West Napa Area | 2022-08-10 | Napa | 55 | 119 | 951 | |
175865 | 175865 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-08-10 | Napa | 55 | 170 | 1699 | |
175866 | 175866 | Yountville | Yountville | 2022-08-10 | Napa | 55 | 444 | 3032 | |
177112 | 177112 | American Canyon | American Canyon | 2022-08-09 | Napa | 55 | 6201 | 17167 | |
177113 | 177113 | Angwin | Angwin | 2022-08-09 | Napa | 55 | 373 | 2046 | |
177114 | 177114 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-08-09 | Napa | 55 | 160 | 1744 | |
177115 | 177115 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-08-09 | Napa | 55 | 231 | 2753 | |
177116 | 177116 | Calistoga | Calistoga | 2022-08-09 | Napa | 55 | 1049 | 4759 | |
177117 | 177117 | Chiles Valley Area | Chiles Valley Area | 2022-08-09 | Napa | 55 | 46 | 776 | |
177118 | 177118 | Deer Park | Deer Park | 2022-08-09 | Napa | 55 | 118 | 1460 | |
177119 | 177119 | East Napa Area | East Napa Area | 2022-08-09 | Napa | 55 | 1109 | 10237 | |
177120 | 177120 | Lake Berryessa | Lake Berryessa | 2022-08-09 | Napa | 55 | 147 | 1624 | |
177121 | 177121 | Napa | Napa | 2022-08-09 | Napa | 55 | 18631 | 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 );