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 |
---|---|---|---|---|---|---|---|---|---|
767062 | 767062 | American Canyon | American Canyon | 2021-05-02 | Napa | 55 | 1647 | 17167 | |
767063 | 767063 | Angwin | Angwin | 2021-05-02 | Napa | 55 | 102 | 2046 | |
767064 | 767064 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-05-02 | Napa | 55 | 82 | 1744 | |
767065 | 767065 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-05-02 | Napa | 55 | 66 | 2753 | |
767066 | 767066 | Calistoga | Calistoga | 2021-05-02 | Napa | 55 | 484 | 4759 | |
767067 | 767067 | Chiles Valley Area | Chiles Valley Area | 2021-05-02 | Napa | 55 | 6 | 776 | |
767068 | 767068 | Deer Park | Deer Park | 2021-05-02 | Napa | 55 | 54 | 1460 | |
767069 | 767069 | East Napa Area | East Napa Area | 2021-05-02 | Napa | 55 | 300 | 10237 | |
767070 | 767070 | Lake Berryessa | Lake Berryessa | 2021-05-02 | Napa | 55 | 33 | 1624 | |
767071 | 767071 | Napa | Napa | 2021-05-02 | Napa | 55 | 6055 | 79852 | |
767072 | 767072 | North Calistoga | North Calistoga | 2021-05-02 | Napa | 55 | 32 | 980 | |
767073 | 767073 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-05-02 | Napa | 55 | 11 | 212 | |
767074 | 767074 | Pope Valley Area | Pope Valley Area | 2021-05-02 | Napa | 55 | 34 | 1275 | |
767075 | 767075 | South Napa Area | South Napa Area | 2021-05-02 | Napa | 55 | 262 | 1961 | |
767076 | 767076 | St. Helena | St. Helena | 2021-05-02 | Napa | 55 | 298 | 6543 | |
767077 | 767077 | West Napa Area | West Napa Area | 2021-05-02 | Napa | 55 | 31 | 951 | |
767078 | 767078 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-05-02 | Napa | 55 | 45 | 1699 | |
767079 | 767079 | Yountville | Yountville | 2021-05-02 | Napa | 55 | 154 | 3032 | |
768338 | 768338 | American Canyon | American Canyon | 2021-05-01 | Napa | 55 | 1647 | 17167 | |
768339 | 768339 | Angwin | Angwin | 2021-05-01 | Napa | 55 | 102 | 2046 | |
768340 | 768340 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-05-01 | Napa | 55 | 82 | 1744 | |
768341 | 768341 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-05-01 | Napa | 55 | 66 | 2753 | |
768342 | 768342 | Calistoga | Calistoga | 2021-05-01 | Napa | 55 | 484 | 4759 | |
768343 | 768343 | Chiles Valley Area | Chiles Valley Area | 2021-05-01 | Napa | 55 | 6 | 776 | |
768344 | 768344 | Deer Park | Deer Park | 2021-05-01 | Napa | 55 | 54 | 1460 | |
768345 | 768345 | East Napa Area | East Napa Area | 2021-05-01 | Napa | 55 | 300 | 10237 | |
768346 | 768346 | Lake Berryessa | Lake Berryessa | 2021-05-01 | Napa | 55 | 33 | 1624 | |
768347 | 768347 | Napa | Napa | 2021-05-01 | Napa | 55 | 6055 | 79852 | |
768348 | 768348 | North Calistoga | North Calistoga | 2021-05-01 | Napa | 55 | 32 | 980 | |
768349 | 768349 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-05-01 | Napa | 55 | 11 | 212 | |
768350 | 768350 | Pope Valley Area | Pope Valley Area | 2021-05-01 | Napa | 55 | 34 | 1275 | |
768351 | 768351 | South Napa Area | South Napa Area | 2021-05-01 | Napa | 55 | 262 | 1961 | |
768352 | 768352 | St. Helena | St. Helena | 2021-05-01 | Napa | 55 | 298 | 6543 | |
768353 | 768353 | West Napa Area | West Napa Area | 2021-05-01 | Napa | 55 | 31 | 951 | |
768354 | 768354 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-05-01 | Napa | 55 | 45 | 1699 | |
768355 | 768355 | Yountville | Yountville | 2021-05-01 | Napa | 55 | 154 | 3032 | |
769614 | 769614 | American Canyon | American Canyon | 2021-04-30 | Napa | 55 | 1647 | 17167 | |
769615 | 769615 | Angwin | Angwin | 2021-04-30 | Napa | 55 | 102 | 2046 | |
769616 | 769616 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-04-30 | Napa | 55 | 82 | 1744 | |
769617 | 769617 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-04-30 | Napa | 55 | 66 | 2753 | |
769618 | 769618 | Calistoga | Calistoga | 2021-04-30 | Napa | 55 | 484 | 4759 | |
769619 | 769619 | Chiles Valley Area | Chiles Valley Area | 2021-04-30 | Napa | 55 | 6 | 776 | |
769620 | 769620 | Deer Park | Deer Park | 2021-04-30 | Napa | 55 | 54 | 1460 | |
769621 | 769621 | East Napa Area | East Napa Area | 2021-04-30 | Napa | 55 | 300 | 10237 | |
769622 | 769622 | Lake Berryessa | Lake Berryessa | 2021-04-30 | Napa | 55 | 33 | 1624 | |
769623 | 769623 | Napa | Napa | 2021-04-30 | Napa | 55 | 6055 | 79852 | |
769624 | 769624 | North Calistoga | North Calistoga | 2021-04-30 | Napa | 55 | 32 | 980 | |
769625 | 769625 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-04-30 | Napa | 55 | 11 | 212 | |
769626 | 769626 | Pope Valley Area | Pope Valley Area | 2021-04-30 | Napa | 55 | 34 | 1275 | |
769627 | 769627 | South Napa Area | South Napa Area | 2021-04-30 | Napa | 55 | 262 | 1961 | |
769628 | 769628 | St. Helena | St. Helena | 2021-04-30 | Napa | 55 | 298 | 6543 | |
769629 | 769629 | West Napa Area | West Napa Area | 2021-04-30 | Napa | 55 | 31 | 951 | |
769630 | 769630 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-04-30 | Napa | 55 | 45 | 1699 | |
769631 | 769631 | Yountville | Yountville | 2021-04-30 | Napa | 55 | 154 | 3032 | |
770890 | 770890 | American Canyon | American Canyon | 2021-04-29 | Napa | 55 | 1647 | 17167 | |
770891 | 770891 | Angwin | Angwin | 2021-04-29 | Napa | 55 | 102 | 2046 | |
770892 | 770892 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-04-29 | Napa | 55 | 82 | 1744 | |
770893 | 770893 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-04-29 | Napa | 55 | 66 | 2753 | |
770894 | 770894 | Calistoga | Calistoga | 2021-04-29 | Napa | 55 | 484 | 4759 | |
770895 | 770895 | Chiles Valley Area | Chiles Valley Area | 2021-04-29 | Napa | 55 | 6 | 776 | |
770896 | 770896 | Deer Park | Deer Park | 2021-04-29 | Napa | 55 | 54 | 1460 | |
770897 | 770897 | East Napa Area | East Napa Area | 2021-04-29 | Napa | 55 | 300 | 10237 | |
770898 | 770898 | Lake Berryessa | Lake Berryessa | 2021-04-29 | Napa | 55 | 33 | 1624 | |
770899 | 770899 | Napa | Napa | 2021-04-29 | Napa | 55 | 6055 | 79852 | |
770900 | 770900 | North Calistoga | North Calistoga | 2021-04-29 | Napa | 55 | 32 | 980 | |
770901 | 770901 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-04-29 | Napa | 55 | 11 | 212 | |
770902 | 770902 | Pope Valley Area | Pope Valley Area | 2021-04-29 | Napa | 55 | 34 | 1275 | |
770903 | 770903 | South Napa Area | South Napa Area | 2021-04-29 | Napa | 55 | 262 | 1961 | |
770904 | 770904 | St. Helena | St. Helena | 2021-04-29 | Napa | 55 | 298 | 6543 | |
770905 | 770905 | West Napa Area | West Napa Area | 2021-04-29 | Napa | 55 | 31 | 951 | |
770906 | 770906 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-04-29 | Napa | 55 | 45 | 1699 | |
770907 | 770907 | Yountville | Yountville | 2021-04-29 | Napa | 55 | 154 | 3032 | |
772166 | 772166 | American Canyon | American Canyon | 2021-04-28 | Napa | 55 | 1647 | 17167 | |
772167 | 772167 | Angwin | Angwin | 2021-04-28 | Napa | 55 | 102 | 2046 | |
772168 | 772168 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-04-28 | Napa | 55 | 82 | 1744 | |
772169 | 772169 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-04-28 | Napa | 55 | 66 | 2753 | |
772170 | 772170 | Calistoga | Calistoga | 2021-04-28 | Napa | 55 | 484 | 4759 | |
772171 | 772171 | Chiles Valley Area | Chiles Valley Area | 2021-04-28 | Napa | 55 | 6 | 776 | |
772172 | 772172 | Deer Park | Deer Park | 2021-04-28 | Napa | 55 | 54 | 1460 | |
772173 | 772173 | East Napa Area | East Napa Area | 2021-04-28 | Napa | 55 | 300 | 10237 | |
772174 | 772174 | Lake Berryessa | Lake Berryessa | 2021-04-28 | Napa | 55 | 33 | 1624 | |
772175 | 772175 | Napa | Napa | 2021-04-28 | Napa | 55 | 6055 | 79852 | |
772176 | 772176 | North Calistoga | North Calistoga | 2021-04-28 | Napa | 55 | 32 | 980 | |
772177 | 772177 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-04-28 | Napa | 55 | 11 | 212 | |
772178 | 772178 | Pope Valley Area | Pope Valley Area | 2021-04-28 | Napa | 55 | 34 | 1275 | |
772179 | 772179 | South Napa Area | South Napa Area | 2021-04-28 | Napa | 55 | 262 | 1961 | |
772180 | 772180 | St. Helena | St. Helena | 2021-04-28 | Napa | 55 | 298 | 6543 | |
772181 | 772181 | West Napa Area | West Napa Area | 2021-04-28 | Napa | 55 | 31 | 951 | |
772182 | 772182 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-04-28 | Napa | 55 | 45 | 1699 | |
772183 | 772183 | Yountville | Yountville | 2021-04-28 | Napa | 55 | 154 | 3032 | |
773442 | 773442 | American Canyon | American Canyon | 2021-04-27 | Napa | 55 | 1647 | 17167 | |
773443 | 773443 | Angwin | Angwin | 2021-04-27 | Napa | 55 | 102 | 2046 | |
773444 | 773444 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-04-27 | Napa | 55 | 82 | 1744 | |
773445 | 773445 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-04-27 | Napa | 55 | 66 | 2753 | |
773446 | 773446 | Calistoga | Calistoga | 2021-04-27 | Napa | 55 | 484 | 4759 | |
773447 | 773447 | Chiles Valley Area | Chiles Valley Area | 2021-04-27 | Napa | 55 | 6 | 776 | |
773448 | 773448 | Deer Park | Deer Park | 2021-04-27 | Napa | 55 | 54 | 1460 | |
773449 | 773449 | East Napa Area | East Napa Area | 2021-04-27 | Napa | 55 | 300 | 10237 | |
773450 | 773450 | Lake Berryessa | Lake Berryessa | 2021-04-27 | Napa | 55 | 33 | 1624 | |
773451 | 773451 | Napa | Napa | 2021-04-27 | Napa | 55 | 6055 | 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 );