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 |
---|---|---|---|---|---|---|---|---|---|
1020751 | 1020751 | North Calistoga | North Calistoga | 2020-10-11 | Napa | 55 | 4 | 980 | |
1020752 | 1020752 | Northeast American Canyon Area | Northeast American Canyon Area | 2020-10-11 | Napa | 55 | 1 | 212 | |
1020753 | 1020753 | Pope Valley Area | Pope Valley Area | 2020-10-11 | Napa | 55 | 8 | 1275 | |
1020754 | 1020754 | South Napa Area | South Napa Area | 2020-10-11 | Napa | 55 | 19 | 1961 | |
1020755 | 1020755 | St. Helena | St. Helena | 2020-10-11 | Napa | 55 | 70 | 6543 | |
1020756 | 1020756 | West Napa Area | West Napa Area | 2020-10-11 | Napa | 55 | 3 | 951 | |
1020757 | 1020757 | West Napa and Yountville Area | West Napa and Yountville Area | 2020-10-11 | Napa | 55 | 12 | 1699 | |
1020758 | 1020758 | Yountville | Yountville | 2020-10-11 | Napa | 55 | 14 | 3032 | |
1021933 | 1021933 | American Canyon | American Canyon | 2020-10-10 | Napa | 55 | 305 | 17167 | |
1021934 | 1021934 | Angwin | Angwin | 2020-10-10 | Napa | 55 | 13 | 2046 | |
1021935 | 1021935 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2020-10-10 | Napa | 55 | 46 | 1744 | |
1021936 | 1021936 | Between Yountville and St Helena | Between Yountville and St Helena | 2020-10-10 | Napa | 55 | 25 | 2753 | |
1021937 | 1021937 | Calistoga | Calistoga | 2020-10-10 | Napa | 55 | 133 | 4759 | |
1021938 | 1021938 | Chiles Valley Area | Chiles Valley Area | 2020-10-10 | Napa | 55 | 1 | 776 | |
1021939 | 1021939 | Deer Park | Deer Park | 2020-10-10 | Napa | 55 | 3 | 1460 | |
1021940 | 1021940 | East Napa Area | East Napa Area | 2020-10-10 | Napa | 55 | 61 | 10237 | |
1021941 | 1021941 | Lake Berryessa | Lake Berryessa | 2020-10-10 | Napa | 55 | 2 | 1624 | |
1021942 | 1021942 | Napa | Napa | 2020-10-10 | Napa | 55 | 1071 | 79852 | |
1021943 | 1021943 | North Calistoga | North Calistoga | 2020-10-10 | Napa | 55 | 4 | 980 | |
1021944 | 1021944 | Northeast American Canyon Area | Northeast American Canyon Area | 2020-10-10 | Napa | 55 | 1 | 212 | |
1021945 | 1021945 | Pope Valley Area | Pope Valley Area | 2020-10-10 | Napa | 55 | 8 | 1275 | |
1021946 | 1021946 | South Napa Area | South Napa Area | 2020-10-10 | Napa | 55 | 19 | 1961 | |
1021947 | 1021947 | St. Helena | St. Helena | 2020-10-10 | Napa | 55 | 70 | 6543 | |
1021948 | 1021948 | West Napa Area | West Napa Area | 2020-10-10 | Napa | 55 | 3 | 951 | |
1021949 | 1021949 | West Napa and Yountville Area | West Napa and Yountville Area | 2020-10-10 | Napa | 55 | 12 | 1699 | |
1021950 | 1021950 | Yountville | Yountville | 2020-10-10 | Napa | 55 | 14 | 3032 | |
1023125 | 1023125 | American Canyon | American Canyon | 2020-10-09 | Napa | 55 | 301 | 17167 | |
1023126 | 1023126 | Angwin | Angwin | 2020-10-09 | Napa | 55 | 13 | 2046 | |
1023127 | 1023127 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2020-10-09 | Napa | 55 | 46 | 1744 | |
1023128 | 1023128 | Between Yountville and St Helena | Between Yountville and St Helena | 2020-10-09 | Napa | 55 | 25 | 2753 | |
1023129 | 1023129 | Calistoga | Calistoga | 2020-10-09 | Napa | 55 | 133 | 4759 | |
1023130 | 1023130 | Chiles Valley Area | Chiles Valley Area | 2020-10-09 | Napa | 55 | 1 | 776 | |
1023131 | 1023131 | Deer Park | Deer Park | 2020-10-09 | Napa | 55 | 3 | 1460 | |
1023132 | 1023132 | East Napa Area | East Napa Area | 2020-10-09 | Napa | 55 | 61 | 10237 | |
1023133 | 1023133 | Lake Berryessa | Lake Berryessa | 2020-10-09 | Napa | 55 | 2 | 1624 | |
1023134 | 1023134 | Napa | Napa | 2020-10-09 | Napa | 55 | 1071 | 79852 | |
1023135 | 1023135 | North Calistoga | North Calistoga | 2020-10-09 | Napa | 55 | 4 | 980 | |
1023136 | 1023136 | Northeast American Canyon Area | Northeast American Canyon Area | 2020-10-09 | Napa | 55 | 1 | 212 | |
1023137 | 1023137 | Pope Valley Area | Pope Valley Area | 2020-10-09 | Napa | 55 | 8 | 1275 | |
1023138 | 1023138 | South Napa Area | South Napa Area | 2020-10-09 | Napa | 55 | 19 | 1961 | |
1023139 | 1023139 | St. Helena | St. Helena | 2020-10-09 | Napa | 55 | 70 | 6543 | |
1023140 | 1023140 | West Napa Area | West Napa Area | 2020-10-09 | Napa | 55 | 3 | 951 | |
1023141 | 1023141 | West Napa and Yountville Area | West Napa and Yountville Area | 2020-10-09 | Napa | 55 | 12 | 1699 | |
1023142 | 1023142 | Yountville | Yountville | 2020-10-09 | Napa | 55 | 14 | 3032 | |
1024317 | 1024317 | American Canyon | American Canyon | 2020-10-08 | Napa | 55 | 301 | 17167 | |
1024318 | 1024318 | Angwin | Angwin | 2020-10-08 | Napa | 55 | 13 | 2046 | |
1024319 | 1024319 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2020-10-08 | Napa | 55 | 46 | 1744 | |
1024320 | 1024320 | Between Yountville and St Helena | Between Yountville and St Helena | 2020-10-08 | Napa | 55 | 25 | 2753 | |
1024321 | 1024321 | Calistoga | Calistoga | 2020-10-08 | Napa | 55 | 133 | 4759 | |
1024322 | 1024322 | Chiles Valley Area | Chiles Valley Area | 2020-10-08 | Napa | 55 | 1 | 776 | |
1024323 | 1024323 | Deer Park | Deer Park | 2020-10-08 | Napa | 55 | 3 | 1460 | |
1024324 | 1024324 | East Napa Area | East Napa Area | 2020-10-08 | Napa | 55 | 61 | 10237 | |
1024325 | 1024325 | Lake Berryessa | Lake Berryessa | 2020-10-08 | Napa | 55 | 2 | 1624 | |
1024326 | 1024326 | Napa | Napa | 2020-10-08 | Napa | 55 | 1058 | 79852 | |
1024327 | 1024327 | North Calistoga | North Calistoga | 2020-10-08 | Napa | 55 | 4 | 980 | |
1024328 | 1024328 | Northeast American Canyon Area | Northeast American Canyon Area | 2020-10-08 | Napa | 55 | 1 | 212 | |
1024329 | 1024329 | Pope Valley Area | Pope Valley Area | 2020-10-08 | Napa | 55 | 8 | 1275 | |
1024330 | 1024330 | South Napa Area | South Napa Area | 2020-10-08 | Napa | 55 | 19 | 1961 | |
1024331 | 1024331 | St. Helena | St. Helena | 2020-10-08 | Napa | 55 | 70 | 6543 | |
1024332 | 1024332 | West Napa Area | West Napa Area | 2020-10-08 | Napa | 55 | 3 | 951 | |
1024333 | 1024333 | West Napa and Yountville Area | West Napa and Yountville Area | 2020-10-08 | Napa | 55 | 12 | 1699 | |
1024334 | 1024334 | Yountville | Yountville | 2020-10-08 | Napa | 55 | 14 | 3032 | |
1025509 | 1025509 | American Canyon | American Canyon | 2020-10-07 | Napa | 55 | 301 | 17167 | |
1025510 | 1025510 | Angwin | Angwin | 2020-10-07 | Napa | 55 | 13 | 2046 | |
1025511 | 1025511 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2020-10-07 | Napa | 55 | 46 | 1744 | |
1025512 | 1025512 | Between Yountville and St Helena | Between Yountville and St Helena | 2020-10-07 | Napa | 55 | 25 | 2753 | |
1025513 | 1025513 | Calistoga | Calistoga | 2020-10-07 | Napa | 55 | 133 | 4759 | |
1025514 | 1025514 | Chiles Valley Area | Chiles Valley Area | 2020-10-07 | Napa | 55 | 1 | 776 | |
1025515 | 1025515 | Deer Park | Deer Park | 2020-10-07 | Napa | 55 | 3 | 1460 | |
1025516 | 1025516 | East Napa Area | East Napa Area | 2020-10-07 | Napa | 55 | 61 | 10237 | |
1025517 | 1025517 | Lake Berryessa | Lake Berryessa | 2020-10-07 | Napa | 55 | 2 | 1624 | |
1025518 | 1025518 | Napa | Napa | 2020-10-07 | Napa | 55 | 1054 | 79852 | |
1025519 | 1025519 | North Calistoga | North Calistoga | 2020-10-07 | Napa | 55 | 4 | 980 | |
1025520 | 1025520 | Northeast American Canyon Area | Northeast American Canyon Area | 2020-10-07 | Napa | 55 | 1 | 212 | |
1025521 | 1025521 | Pope Valley Area | Pope Valley Area | 2020-10-07 | Napa | 55 | 8 | 1275 | |
1025522 | 1025522 | South Napa Area | South Napa Area | 2020-10-07 | Napa | 55 | 18 | 1961 | |
1025523 | 1025523 | St. Helena | St. Helena | 2020-10-07 | Napa | 55 | 70 | 6543 | |
1025524 | 1025524 | West Napa Area | West Napa Area | 2020-10-07 | Napa | 55 | 3 | 951 | |
1025525 | 1025525 | West Napa and Yountville Area | West Napa and Yountville Area | 2020-10-07 | Napa | 55 | 12 | 1699 | |
1025526 | 1025526 | Yountville | Yountville | 2020-10-07 | Napa | 55 | 13 | 3032 | |
1026701 | 1026701 | American Canyon | American Canyon | 2020-10-06 | Napa | 55 | 301 | 17167 | |
1026702 | 1026702 | Angwin | Angwin | 2020-10-06 | Napa | 55 | 13 | 2046 | |
1026703 | 1026703 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2020-10-06 | Napa | 55 | 46 | 1744 | |
1026704 | 1026704 | Between Yountville and St Helena | Between Yountville and St Helena | 2020-10-06 | Napa | 55 | 25 | 2753 | |
1026705 | 1026705 | Calistoga | Calistoga | 2020-10-06 | Napa | 55 | 132 | 4759 | |
1026706 | 1026706 | Chiles Valley Area | Chiles Valley Area | 2020-10-06 | Napa | 55 | 1 | 776 | |
1026707 | 1026707 | Deer Park | Deer Park | 2020-10-06 | Napa | 55 | 3 | 1460 | |
1026708 | 1026708 | East Napa Area | East Napa Area | 2020-10-06 | Napa | 55 | 61 | 10237 | |
1026709 | 1026709 | Lake Berryessa | Lake Berryessa | 2020-10-06 | Napa | 55 | 2 | 1624 | |
1026710 | 1026710 | Napa | Napa | 2020-10-06 | Napa | 55 | 1052 | 79852 | |
1026711 | 1026711 | North Calistoga | North Calistoga | 2020-10-06 | Napa | 55 | 4 | 980 | |
1026712 | 1026712 | Northeast American Canyon Area | Northeast American Canyon Area | 2020-10-06 | Napa | 55 | 1 | 212 | |
1026713 | 1026713 | Pope Valley Area | Pope Valley Area | 2020-10-06 | Napa | 55 | 8 | 1275 | |
1026714 | 1026714 | South Napa Area | South Napa Area | 2020-10-06 | Napa | 55 | 18 | 1961 | |
1026715 | 1026715 | St. Helena | St. Helena | 2020-10-06 | Napa | 55 | 70 | 6543 | |
1026716 | 1026716 | West Napa Area | West Napa Area | 2020-10-06 | Napa | 55 | 3 | 951 | |
1026717 | 1026717 | West Napa and Yountville Area | West Napa and Yountville Area | 2020-10-06 | Napa | 55 | 12 | 1699 | |
1026718 | 1026718 | Yountville | Yountville | 2020-10-06 | Napa | 55 | 14 | 3032 | |
1027893 | 1027893 | American Canyon | American Canyon | 2020-10-05 | Napa | 55 | 298 | 17167 | |
1027894 | 1027894 | Angwin | Angwin | 2020-10-05 | Napa | 55 | 13 | 2046 |
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 );