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 2021-04-14 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 |
---|---|---|---|---|---|---|---|---|---|
790030 | 790030 | American Canyon | American Canyon | 2021-04-14 | Napa | 55 | 1609 | 17167 | |
790031 | 790031 | Angwin | Angwin | 2021-04-14 | Napa | 55 | 101 | 2046 | |
790032 | 790032 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2021-04-14 | Napa | 55 | 82 | 1744 | |
790033 | 790033 | Between Yountville and St Helena | Between Yountville and St Helena | 2021-04-14 | Napa | 55 | 66 | 2753 | |
790034 | 790034 | Calistoga | Calistoga | 2021-04-14 | Napa | 55 | 480 | 4759 | |
790035 | 790035 | Chiles Valley Area | Chiles Valley Area | 2021-04-14 | Napa | 55 | 6 | 776 | |
790036 | 790036 | Deer Park | Deer Park | 2021-04-14 | Napa | 55 | 54 | 1460 | |
790037 | 790037 | East Napa Area | East Napa Area | 2021-04-14 | Napa | 55 | 296 | 10237 | |
790038 | 790038 | Lake Berryessa | Lake Berryessa | 2021-04-14 | Napa | 55 | 33 | 1624 | |
790039 | 790039 | Napa | Napa | 2021-04-14 | Napa | 55 | 5951 | 79852 | |
790040 | 790040 | North Calistoga | North Calistoga | 2021-04-14 | Napa | 55 | 31 | 980 | |
790041 | 790041 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-04-14 | Napa | 55 | 11 | 212 | |
790042 | 790042 | Pope Valley Area | Pope Valley Area | 2021-04-14 | Napa | 55 | 34 | 1275 | |
790043 | 790043 | South Napa Area | South Napa Area | 2021-04-14 | Napa | 55 | 259 | 1961 | |
790044 | 790044 | St. Helena | St. Helena | 2021-04-14 | Napa | 55 | 295 | 6543 | |
790045 | 790045 | West Napa Area | West Napa Area | 2021-04-14 | Napa | 55 | 30 | 951 | |
790046 | 790046 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-04-14 | Napa | 55 | 45 | 1699 | |
790047 | 790047 | Yountville | Yountville | 2021-04-14 | Napa | 55 | 153 | 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 );