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: date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 669 | 669 | 2020-10-23 | San Bernardino | 71 | Adelanto | 1203 | -117.560861 | 34.591254 | |
| 670 | 670 | 2020-10-23 | San Bernardino | 71 | Angelus Oaks | 3 | -116.9825 | 34.145833 | |
| 671 | 671 | 2020-10-23 | San Bernardino | 71 | Apple Valley | 1372 | -117.185876 | 34.500831 | |
| 672 | 672 | 2020-10-23 | San Bernardino | 71 | Baker | 14 | -116.065833 | 35.275833 | |
| 673 | 673 | 2020-10-23 | San Bernardino | 71 | Baldy Mesa | 1 | -117.450278 | 34.459167 | |
| 674 | 674 | 2020-10-23 | San Bernardino | 71 | Barstow | 350 | -117.017283 | 34.895796 | |
| 675 | 675 | 2020-10-23 | San Bernardino | 71 | Big Bear City | 63 | -116.84503 | 34.261118 | |
| 676 | 676 | 2020-10-23 | San Bernardino | 71 | Big Bear Lake | 63 | -116.911422 | 34.243896 | |
| 677 | 677 | 2020-10-23 | San Bernardino | 71 | Big River | 2 | -114.369722 | 34.133889 | |
| 678 | 678 | 2020-10-23 | San Bernardino | 71 | Bloomington | 1355 | -117.39588 | 34.07029 | |
| 679 | 679 | 2020-10-23 | San Bernardino | 71 | Blue Jay | 16 | -117.216863 | 34.244027 | |
| 680 | 680 | 2020-10-23 | San Bernardino | 71 | Cedar Glen | 7 | -117.165 | 34.253889 | |
| 681 | 681 | 2020-10-23 | San Bernardino | 71 | Chino | 3885 | -117.688944 | 34.012235 | |
| 682 | 682 | 2020-10-23 | San Bernardino | 71 | Chino Hills | 1079 | -117.732585 | 33.989819 | |
| 683 | 683 | 2020-10-23 | San Bernardino | 71 | Colton | 2382 | -117.313655 | 34.073902 | |
| 684 | 684 | 2020-10-23 | San Bernardino | 71 | Crestline | 86 | -117.285599 | 34.241951 | |
| 685 | 685 | 2020-10-23 | San Bernardino | 71 | Daggett | 1 | -116.886523 | 34.86215 | |
| 686 | 686 | 2020-10-23 | San Bernardino | 71 | Devore | 2 | -117.401389 | 34.216389 | |
| 687 | 687 | 2020-10-23 | San Bernardino | 71 | Fawnskin | 3 | -116.947186 | 34.267411 | |
| 688 | 688 | 2020-10-23 | San Bernardino | 71 | Fontana | 8181 | -117.435048 | 34.092234 | |
| 689 | 689 | 2020-10-23 | San Bernardino | 71 | Forest Falls | 8 | -116.920278 | 34.088333 | |
| 690 | 690 | 2020-10-23 | San Bernardino | 71 | Grand Terrace | 361 | -117.313654 | 34.033903 | |
| 691 | 691 | 2020-10-23 | San Bernardino | 71 | Green Valley Lake | 1 | -117.077222 | 34.240833 | |
| 692 | 692 | 2020-10-23 | San Bernardino | 71 | Helendale | 76 | -117.324444 | 34.743889 | |
| 693 | 693 | 2020-10-23 | San Bernardino | 71 | Hesperia | 2363 | -117.300878 | 34.426389 | |
| 694 | 694 | 2020-10-23 | San Bernardino | 71 | Highland | 1688 | -117.208651 | 34.128344 | |
| 695 | 695 | 2020-10-23 | San Bernardino | 71 | Hinkley | 7 | -117.2 | 34.933333 | |
| 696 | 696 | 2020-10-23 | San Bernardino | 71 | Joshua Tree | 99 | -116.338749 | 34.126721 | |
| 697 | 697 | 2020-10-23 | San Bernardino | 71 | Lake Arrowhead | 41 | -117.189167 | 34.248333 | |
| 698 | 698 | 2020-10-23 | San Bernardino | 71 | Landers | 12 | -116.392222 | 34.266111 | |
| 699 | 699 | 2020-10-23 | San Bernardino | 71 | Loma Linda | 615 | -117.261153 | 34.048347 | |
| 700 | 700 | 2020-10-23 | San Bernardino | 71 | Lucerne Valley | 38 | -116.966944 | 34.443889 | |
| 701 | 701 | 2020-10-23 | San Bernardino | 71 | Lytle Creek | 16 | -117.499167 | 34.259167 | |
| 702 | 702 | 2020-10-23 | San Bernardino | 71 | Mentone | 289 | -117.124574 | 34.062589 | |
| 703 | 703 | 2020-10-23 | San Bernardino | 71 | Montclair | 1458 | -117.689778 | 34.07751 | |
| 704 | 704 | 2020-10-23 | San Bernardino | 71 | Morongo Valley | 46 | -116.580847 | 34.046955 | |
| 705 | 705 | 2020-10-23 | San Bernardino | 71 | Mt Baldy | 1 | -117.66 | 34.236111 | |
| 706 | 706 | 2020-10-23 | San Bernardino | 71 | Muscoy | 19 | -117.344167 | 34.154167 | |
| 707 | 707 | 2020-10-23 | San Bernardino | 71 | Needles | 76 | -114.619621 | 34.806179 | |
| 708 | 708 | 2020-10-23 | San Bernardino | 71 | Newberry Springs | 10 | -116.6875 | 34.827778 | |
| 709 | 709 | 2020-10-23 | San Bernardino | 71 | Oak Glen | 3 | -116.949444 | 34.045 | |
| 710 | 710 | 2020-10-23 | San Bernardino | 71 | Oak Hills | 213 | -117.434696 | 34.434038 | |
| 711 | 711 | 2020-10-23 | San Bernardino | 71 | Ontario | 5764 | -117.650888 | 34.063344 | |
| 712 | 712 | 2020-10-23 | San Bernardino | 71 | Oro Grande | 17 | -117.334167 | 34.598889 | |
| 713 | 713 | 2020-10-23 | San Bernardino | 71 | Phelan | 242 | -117.572563 | 34.426288 | |
| 714 | 714 | 2020-10-23 | San Bernardino | 71 | Pioneertown | 2 | -116.494722 | 34.157222 | |
| 715 | 715 | 2020-10-23 | San Bernardino | 71 | Piñon Hills | 66 | -117.650052 | 34.429272 | |
| 716 | 716 | 2020-10-23 | San Bernardino | 71 | Rancho Cucamonga | 3286 | -117.593108 | 34.106399 | |
| 717 | 717 | 2020-10-23 | San Bernardino | 71 | Redlands | 2007 | -117.182538 | 34.055569 | |
| 718 | 718 | 2020-10-23 | San Bernardino | 71 | Rialto | 4144 | -117.370324 | 34.1064 | |
| 719 | 719 | 2020-10-23 | San Bernardino | 71 | Rimforest | 4 | -117.225666 | 34.22955 | |
| 720 | 720 | 2020-10-23 | San Bernardino | 71 | Running Springs | 36 | -117.109205 | 34.207786 | |
| 721 | 721 | 2020-10-23 | San Bernardino | 71 | San Bernardino | 9695 | -117.289765 | 34.108345 | |
| 722 | 722 | 2020-10-23 | San Bernardino | 71 | Sugarloaf | 15 | -116.828889 | 34.243333 | |
| 723 | 723 | 2020-10-23 | San Bernardino | 71 | Trona | 14 | -117.382778 | 35.765278 | |
| 724 | 724 | 2020-10-23 | San Bernardino | 71 | Twentynine Palms | 97 | -116.054167 | 34.135556 | |
| 725 | 725 | 2020-10-23 | San Bernardino | 71 | Twin Peaks | 12 | -117.233611 | 34.238889 | |
| 726 | 726 | 2020-10-23 | San Bernardino | 71 | Upland | 1600 | -117.648388 | 34.09751 | |
| 727 | 727 | 2020-10-23 | San Bernardino | 71 | Victorville | 3974 | -117.292764 | 34.536218 | |
| 728 | 728 | 2020-10-23 | San Bernardino | 71 | Wrightwood | 39 | -117.633388 | 34.360834 | |
| 729 | 729 | 2020-10-23 | San Bernardino | 71 | Yermo | 14 | -116.820278 | 34.905 | |
| 730 | 730 | 2020-10-23 | San Bernardino | 71 | Yucaipa | 1152 | -117.043086 | 34.033625 | |
| 731 | 731 | 2020-10-23 | San Bernardino | 71 | Yucca Valley | 248 | -116.432235 | 34.114174 | |
| 1670 | 1670 | 2020-10-22 | San Bernardino | 71 | Adelanto | 1199 | -117.560861 | 34.591254 | |
| 1671 | 1671 | 2020-10-22 | San Bernardino | 71 | Angelus Oaks | 3 | -116.9825 | 34.145833 | |
| 1672 | 1672 | 2020-10-22 | San Bernardino | 71 | Apple Valley | 1367 | -117.185876 | 34.500831 | |
| 1673 | 1673 | 2020-10-22 | San Bernardino | 71 | Baker | 14 | -116.065833 | 35.275833 | |
| 1674 | 1674 | 2020-10-22 | San Bernardino | 71 | Baldy Mesa | 1 | -117.450278 | 34.459167 | |
| 1675 | 1675 | 2020-10-22 | San Bernardino | 71 | Barstow | 349 | -117.017283 | 34.895796 | |
| 1676 | 1676 | 2020-10-22 | San Bernardino | 71 | Big Bear City | 62 | -116.84503 | 34.261118 | |
| 1677 | 1677 | 2020-10-22 | San Bernardino | 71 | Big Bear Lake | 63 | -116.911422 | 34.243896 | |
| 1678 | 1678 | 2020-10-22 | San Bernardino | 71 | Big River | 2 | -114.369722 | 34.133889 | |
| 1679 | 1679 | 2020-10-22 | San Bernardino | 71 | Bloomington | 1352 | -117.39588 | 34.07029 | |
| 1680 | 1680 | 2020-10-22 | San Bernardino | 71 | Blue Jay | 16 | -117.216863 | 34.244027 | |
| 1681 | 1681 | 2020-10-22 | San Bernardino | 71 | Cedar Glen | 7 | -117.165 | 34.253889 | |
| 1682 | 1682 | 2020-10-22 | San Bernardino | 71 | Chino | 3878 | -117.688944 | 34.012235 | |
| 1683 | 1683 | 2020-10-22 | San Bernardino | 71 | Chino Hills | 1078 | -117.732585 | 33.989819 | |
| 1684 | 1684 | 2020-10-22 | San Bernardino | 71 | Colton | 2375 | -117.313655 | 34.073902 | |
| 1685 | 1685 | 2020-10-22 | San Bernardino | 71 | Crestline | 86 | -117.285599 | 34.241951 | |
| 1686 | 1686 | 2020-10-22 | San Bernardino | 71 | Daggett | 1 | -116.886523 | 34.86215 | |
| 1687 | 1687 | 2020-10-22 | San Bernardino | 71 | Devore | 2 | -117.401389 | 34.216389 | |
| 1688 | 1688 | 2020-10-22 | San Bernardino | 71 | Fawnskin | 3 | -116.947186 | 34.267411 | |
| 1689 | 1689 | 2020-10-22 | San Bernardino | 71 | Fontana | 8158 | -117.435048 | 34.092234 | |
| 1690 | 1690 | 2020-10-22 | San Bernardino | 71 | Forest Falls | 8 | -116.920278 | 34.088333 | |
| 1691 | 1691 | 2020-10-22 | San Bernardino | 71 | Grand Terrace | 360 | -117.313654 | 34.033903 | |
| 1692 | 1692 | 2020-10-22 | San Bernardino | 71 | Green Valley Lake | 1 | -117.077222 | 34.240833 | |
| 1693 | 1693 | 2020-10-22 | San Bernardino | 71 | Helendale | 76 | -117.324444 | 34.743889 | |
| 1694 | 1694 | 2020-10-22 | San Bernardino | 71 | Hesperia | 2359 | -117.300878 | 34.426389 | |
| 1695 | 1695 | 2020-10-22 | San Bernardino | 71 | Highland | 1684 | -117.208651 | 34.128344 | |
| 1696 | 1696 | 2020-10-22 | San Bernardino | 71 | Hinkley | 7 | -117.2 | 34.933333 | |
| 1697 | 1697 | 2020-10-22 | San Bernardino | 71 | Joshua Tree | 99 | -116.338749 | 34.126721 | |
| 1698 | 1698 | 2020-10-22 | San Bernardino | 71 | Lake Arrowhead | 41 | -117.189167 | 34.248333 | |
| 1699 | 1699 | 2020-10-22 | San Bernardino | 71 | Landers | 12 | -116.392222 | 34.266111 | |
| 1700 | 1700 | 2020-10-22 | San Bernardino | 71 | Loma Linda | 613 | -117.261153 | 34.048347 | |
| 1701 | 1701 | 2020-10-22 | San Bernardino | 71 | Lucerne Valley | 37 | -116.966944 | 34.443889 | |
| 1702 | 1702 | 2020-10-22 | San Bernardino | 71 | Lytle Creek | 16 | -117.499167 | 34.259167 | |
| 1703 | 1703 | 2020-10-22 | San Bernardino | 71 | Mentone | 290 | -117.124574 | 34.062589 | |
| 1704 | 1704 | 2020-10-22 | San Bernardino | 71 | Montclair | 1456 | -117.689778 | 34.07751 | |
| 1705 | 1705 | 2020-10-22 | San Bernardino | 71 | Morongo Valley | 46 | -116.580847 | 34.046955 | |
| 1706 | 1706 | 2020-10-22 | San Bernardino | 71 | Mt Baldy | 1 | -117.66 | 34.236111 |
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 );