latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
18 rows where county = "Napa", "date" is on date 2022-07-25 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 |
---|---|---|---|---|---|---|---|---|---|
196057 | 196057 | American Canyon | American Canyon | 2022-07-25 | Napa | 55 | 5998 | 17167 | |
196058 | 196058 | Angwin | Angwin | 2022-07-25 | Napa | 55 | 344 | 2046 | |
196059 | 196059 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-07-25 | Napa | 55 | 157 | 1744 | |
196060 | 196060 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-07-25 | Napa | 55 | 228 | 2753 | |
196061 | 196061 | Calistoga | Calistoga | 2022-07-25 | Napa | 55 | 1029 | 4759 | |
196062 | 196062 | Chiles Valley Area | Chiles Valley Area | 2022-07-25 | Napa | 55 | 45 | 776 | |
196063 | 196063 | Deer Park | Deer Park | 2022-07-25 | Napa | 55 | 116 | 1460 | |
196064 | 196064 | East Napa Area | East Napa Area | 2022-07-25 | Napa | 55 | 1076 | 10237 | |
196065 | 196065 | Lake Berryessa | Lake Berryessa | 2022-07-25 | Napa | 55 | 145 | 1624 | |
196066 | 196066 | Napa | Napa | 2022-07-25 | Napa | 55 | 18146 | 79852 | |
196067 | 196067 | North Calistoga | North Calistoga | 2022-07-25 | Napa | 55 | 97 | 980 | |
196068 | 196068 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-07-25 | Napa | 55 | 29 | 212 | |
196069 | 196069 | Pope Valley Area | Pope Valley Area | 2022-07-25 | Napa | 55 | 95 | 1275 | |
196070 | 196070 | South Napa Area | South Napa Area | 2022-07-25 | Napa | 55 | 911 | 1961 | |
196071 | 196071 | St. Helena | St. Helena | 2022-07-25 | Napa | 55 | 895 | 6543 | |
196072 | 196072 | West Napa Area | West Napa Area | 2022-07-25 | Napa | 55 | 117 | 951 | |
196073 | 196073 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-07-25 | Napa | 55 | 165 | 1699 | |
196074 | 196074 | Yountville | Yountville | 2022-07-25 | Napa | 55 | 424 | 3032 |
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 );