Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: x, y, date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 584 | 584 | 2020-10-30 | Napa | 55 | American Canyon | 330 | -122.258349 | 38.179634 | |
| 585 | 585 | 2020-10-30 | Napa | 55 | Angwin | 13 | -122.449988 | 38.577228 | |
| 586 | 586 | 2020-10-30 | Napa | 55 | Between St Helena and Calistoga | 51 | -122.527537 | 38.542796 | |
| 587 | 587 | 2020-10-30 | Napa | 55 | Between Yountville and St Helena | 20 | -122.416388 | 38.446383 | |
| 588 | 588 | 2020-10-30 | Napa | 55 | Calistoga | 144 | -122.582477 | 38.581757 | |
| 589 | 589 | 2020-10-30 | Napa | 55 | Chiles Valley Area | 1 | -122.344756 | 38.529655 | |
| 590 | 590 | 2020-10-30 | Napa | 55 | Deer Park | 3 | -122.467043 | 38.536308 | |
| 591 | 591 | 2020-10-30 | Napa | 55 | East Napa Area | 67 | -122.211126 | 38.375796 | |
| 592 | 592 | 2020-10-30 | Napa | 55 | Lake Berryessa | 3 | -122.237357 | 38.622114 | |
| 593 | 593 | 2020-10-30 | Napa | 55 | Napa | 1212 | -122.359998 | 38.285942 | |
| 594 | 594 | 2020-10-30 | Napa | 55 | North Calistoga | 4 | -122.574599 | 38.623392 | |
| 595 | 595 | 2020-10-30 | Napa | 55 | Northeast American Canyon Area | 1 | -122.224884 | 38.19752 | |
| 596 | 596 | 2020-10-30 | Napa | 55 | Pope Valley Area | 7 | -122.416626 | 38.679329 | |
| 597 | 597 | 2020-10-30 | Napa | 55 | South Napa Area | 21 | -122.3163 | 38.1997 | |
| 598 | 598 | 2020-10-30 | Napa | 55 | St. Helena | 72 | -122.46819 | 38.50624 | |
| 599 | 599 | 2020-10-30 | Napa | 55 | West Napa Area | 4 | -122.353019 | 38.28391 | |
| 600 | 600 | 2020-10-30 | Napa | 55 | West Napa and Yountville Area | 13 | -122.38077 | 38.363302 | |
| 601 | 601 | 2020-10-30 | Napa | 55 | Yountville | 20 | -122.36711 | 38.396425 | |
| 1574 | 1574 | 2020-10-29 | Napa | 55 | American Canyon | 328 | -122.258349 | 38.179634 | |
| 1575 | 1575 | 2020-10-29 | Napa | 55 | Angwin | 13 | -122.449988 | 38.577228 | |
| 1576 | 1576 | 2020-10-29 | Napa | 55 | Between St Helena and Calistoga | 51 | -122.527537 | 38.542796 | |
| 1577 | 1577 | 2020-10-29 | Napa | 55 | Between Yountville and St Helena | 26 | -122.416388 | 38.446383 | |
| 1578 | 1578 | 2020-10-29 | Napa | 55 | Calistoga | 146 | -122.582477 | 38.581757 | |
| 1579 | 1579 | 2020-10-29 | Napa | 55 | Chiles Valley Area | 1 | -122.344756 | 38.529655 | |
| 1580 | 1580 | 2020-10-29 | Napa | 55 | Deer Park | 3 | -122.467043 | 38.536308 | |
| 1581 | 1581 | 2020-10-29 | Napa | 55 | East Napa Area | 67 | -122.211126 | 38.375796 | |
| 1582 | 1582 | 2020-10-29 | Napa | 55 | Lake Berryessa | 3 | -122.237357 | 38.622114 | |
| 1583 | 1583 | 2020-10-29 | Napa | 55 | Napa | 1219 | -122.359998 | 38.285942 | |
| 1584 | 1584 | 2020-10-29 | Napa | 55 | North Calistoga | 4 | -122.574599 | 38.623392 | |
| 1585 | 1585 | 2020-10-29 | Napa | 55 | Northeast American Canyon Area | 1 | -122.224884 | 38.19752 | |
| 1586 | 1586 | 2020-10-29 | Napa | 55 | Pope Valley Area | 8 | -122.416626 | 38.679329 | |
| 1587 | 1587 | 2020-10-29 | Napa | 55 | South Napa Area | 21 | -122.3163 | 38.1997 | |
| 1588 | 1588 | 2020-10-29 | Napa | 55 | St. Helena | 73 | -122.46819 | 38.50624 | |
| 1589 | 1589 | 2020-10-29 | Napa | 55 | West Napa Area | 4 | -122.353019 | 38.28391 | |
| 1590 | 1590 | 2020-10-29 | Napa | 55 | West Napa and Yountville Area | 14 | -122.38077 | 38.363302 | |
| 1591 | 1591 | 2020-10-29 | Napa | 55 | Yountville | 20 | -122.36711 | 38.396425 | |
| 2575 | 2575 | 2020-10-28 | Napa | 55 | American Canyon | 328 | -122.258349 | 38.179634 | |
| 2576 | 2576 | 2020-10-28 | Napa | 55 | Angwin | 13 | -122.449988 | 38.577228 | |
| 2577 | 2577 | 2020-10-28 | Napa | 55 | Between St Helena and Calistoga | 51 | -122.527537 | 38.542796 | |
| 2578 | 2578 | 2020-10-28 | Napa | 55 | Between Yountville and St Helena | 26 | -122.416388 | 38.446383 | |
| 2579 | 2579 | 2020-10-28 | Napa | 55 | Calistoga | 145 | -122.582477 | 38.581757 | |
| 2580 | 2580 | 2020-10-28 | Napa | 55 | Chiles Valley Area | 1 | -122.344756 | 38.529655 | |
| 2581 | 2581 | 2020-10-28 | Napa | 55 | Deer Park | 3 | -122.467043 | 38.536308 | |
| 2582 | 2582 | 2020-10-28 | Napa | 55 | East Napa Area | 67 | -122.211126 | 38.375796 | |
| 2583 | 2583 | 2020-10-28 | Napa | 55 | Lake Berryessa | 3 | -122.237357 | 38.622114 | |
| 2584 | 2584 | 2020-10-28 | Napa | 55 | Napa | 1210 | -122.359998 | 38.285942 | |
| 2585 | 2585 | 2020-10-28 | Napa | 55 | North Calistoga | 4 | -122.574599 | 38.623392 | |
| 2586 | 2586 | 2020-10-28 | Napa | 55 | Northeast American Canyon Area | 1 | -122.224884 | 38.19752 | |
| 2587 | 2587 | 2020-10-28 | Napa | 55 | Pope Valley Area | 8 | -122.416626 | 38.679329 | |
| 2588 | 2588 | 2020-10-28 | Napa | 55 | South Napa Area | 21 | -122.3163 | 38.1997 | |
| 2589 | 2589 | 2020-10-28 | Napa | 55 | St. Helena | 73 | -122.46819 | 38.50624 | |
| 2590 | 2590 | 2020-10-28 | Napa | 55 | West Napa Area | 4 | -122.353019 | 38.28391 | |
| 2591 | 2591 | 2020-10-28 | Napa | 55 | West Napa and Yountville Area | 14 | -122.38077 | 38.363302 | |
| 2592 | 2592 | 2020-10-28 | Napa | 55 | Yountville | 20 | -122.36711 | 38.396425 | |
| 3534 | 3534 | 2020-10-27 | Napa | 55 | American Canyon | 327 | -122.258349 | 38.179634 | |
| 3535 | 3535 | 2020-10-27 | Napa | 55 | Angwin | 13 | -122.449988 | 38.577228 | |
| 3536 | 3536 | 2020-10-27 | Napa | 55 | Between St Helena and Calistoga | 51 | -122.527537 | 38.542796 | |
| 3537 | 3537 | 2020-10-27 | Napa | 55 | Between Yountville and St Helena | 26 | -122.416388 | 38.446383 | |
| 3538 | 3538 | 2020-10-27 | Napa | 55 | Calistoga | 145 | -122.582477 | 38.581757 | |
| 3539 | 3539 | 2020-10-27 | Napa | 55 | Chiles Valley Area | 1 | -122.344756 | 38.529655 | |
| 3540 | 3540 | 2020-10-27 | Napa | 55 | Deer Park | 3 | -122.467043 | 38.536308 | |
| 3541 | 3541 | 2020-10-27 | Napa | 55 | East Napa Area | 65 | -122.211126 | 38.375796 | |
| 3542 | 3542 | 2020-10-27 | Napa | 55 | Lake Berryessa | 3 | -122.237357 | 38.622114 | |
| 3543 | 3543 | 2020-10-27 | Napa | 55 | Napa | 1198 | -122.359998 | 38.285942 | |
| 3544 | 3544 | 2020-10-27 | Napa | 55 | North Calistoga | 4 | -122.574599 | 38.623392 | |
| 3545 | 3545 | 2020-10-27 | Napa | 55 | Northeast American Canyon Area | 1 | -122.224884 | 38.19752 | |
| 3546 | 3546 | 2020-10-27 | Napa | 55 | Pope Valley Area | 8 | -122.416626 | 38.679329 | |
| 3547 | 3547 | 2020-10-27 | Napa | 55 | South Napa Area | 21 | -122.3163 | 38.1997 | |
| 3548 | 3548 | 2020-10-27 | Napa | 55 | St. Helena | 72 | -122.46819 | 38.50624 | |
| 3549 | 3549 | 2020-10-27 | Napa | 55 | West Napa Area | 3 | -122.353019 | 38.28391 | |
| 3550 | 3550 | 2020-10-27 | Napa | 55 | West Napa and Yountville Area | 14 | -122.38077 | 38.363302 | |
| 3551 | 3551 | 2020-10-27 | Napa | 55 | Yountville | 20 | -122.36711 | 38.396425 | |
| 4496 | 4496 | 2020-10-26 | Napa | 55 | American Canyon | 327 | -122.258349 | 38.179634 | |
| 4497 | 4497 | 2020-10-26 | Napa | 55 | Angwin | 13 | -122.449988 | 38.577228 | |
| 4498 | 4498 | 2020-10-26 | Napa | 55 | Between St Helena and Calistoga | 51 | -122.527537 | 38.542796 | |
| 4499 | 4499 | 2020-10-26 | Napa | 55 | Between Yountville and St Helena | 26 | -122.416388 | 38.446383 | |
| 4500 | 4500 | 2020-10-26 | Napa | 55 | Calistoga | 145 | -122.582477 | 38.581757 | |
| 4501 | 4501 | 2020-10-26 | Napa | 55 | Chiles Valley Area | 1 | -122.344756 | 38.529655 | |
| 4502 | 4502 | 2020-10-26 | Napa | 55 | Deer Park | 3 | -122.467043 | 38.536308 | |
| 4503 | 4503 | 2020-10-26 | Napa | 55 | East Napa Area | 64 | -122.211126 | 38.375796 | |
| 4504 | 4504 | 2020-10-26 | Napa | 55 | Lake Berryessa | 3 | -122.237357 | 38.622114 | |
| 4505 | 4505 | 2020-10-26 | Napa | 55 | Napa | 1185 | -122.359998 | 38.285942 | |
| 4506 | 4506 | 2020-10-26 | Napa | 55 | North Calistoga | 4 | -122.574599 | 38.623392 | |
| 4507 | 4507 | 2020-10-26 | Napa | 55 | Northeast American Canyon Area | 1 | -122.224884 | 38.19752 | |
| 4508 | 4508 | 2020-10-26 | Napa | 55 | Pope Valley Area | 8 | -122.416626 | 38.679329 | |
| 4509 | 4509 | 2020-10-26 | Napa | 55 | South Napa Area | 21 | -122.3163 | 38.1997 | |
| 4510 | 4510 | 2020-10-26 | Napa | 55 | St. Helena | 72 | -122.46819 | 38.50624 | |
| 4511 | 4511 | 2020-10-26 | Napa | 55 | West Napa Area | 3 | -122.353019 | 38.28391 | |
| 4512 | 4512 | 2020-10-26 | Napa | 55 | West Napa and Yountville Area | 14 | -122.38077 | 38.363302 | |
| 4513 | 4513 | 2020-10-26 | Napa | 55 | Yountville | 20 | -122.36711 | 38.396425 | |
| 6778 | 6778 | 2020-10-23 | Napa | 55 | American Canyon | 325 | -122.258349 | 38.179634 | |
| 6779 | 6779 | 2020-10-23 | Napa | 55 | Angwin | 13 | -122.449988 | 38.577228 | |
| 6780 | 6780 | 2020-10-23 | Napa | 55 | Between St Helena and Calistoga | 51 | -122.527537 | 38.542796 | |
| 6781 | 6781 | 2020-10-23 | Napa | 55 | Between Yountville and St Helena | 26 | -122.416388 | 38.446383 | |
| 6782 | 6782 | 2020-10-23 | Napa | 55 | Calistoga | 144 | -122.582477 | 38.581757 | |
| 6783 | 6783 | 2020-10-23 | Napa | 55 | Chiles Valley Area | 1 | -122.344756 | 38.529655 | |
| 6784 | 6784 | 2020-10-23 | Napa | 55 | Deer Park | 3 | -122.467043 | 38.536308 | |
| 6785 | 6785 | 2020-10-23 | Napa | 55 | East Napa Area | 63 | -122.211126 | 38.375796 | |
| 6786 | 6786 | 2020-10-23 | Napa | 55 | Lake Berryessa | 3 | -122.237357 | 38.622114 | |
| 6787 | 6787 | 2020-10-23 | Napa | 55 | Napa | 1170 | -122.359998 | 38.285942 |
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT );