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 |
|---|---|---|---|---|---|---|---|---|---|
| 741 | 741 | 2020-10-30 | San Bernardino | 71 | Adelanto | 1267 | -117.560861 | 34.591254 | |
| 742 | 742 | 2020-10-30 | San Bernardino | 71 | Angelus Oaks | 3 | -116.9825 | 34.145833 | |
| 743 | 743 | 2020-10-30 | San Bernardino | 71 | Apple Valley | 1452 | -117.185876 | 34.500831 | |
| 744 | 744 | 2020-10-30 | San Bernardino | 71 | Baker | 14 | -116.065833 | 35.275833 | |
| 745 | 745 | 2020-10-30 | San Bernardino | 71 | Baldy Mesa | 1 | -117.450278 | 34.459167 | |
| 746 | 746 | 2020-10-30 | San Bernardino | 71 | Barstow | 374 | -117.017283 | 34.895796 | |
| 747 | 747 | 2020-10-30 | San Bernardino | 71 | Big Bear City | 69 | -116.84503 | 34.261118 | |
| 748 | 748 | 2020-10-30 | San Bernardino | 71 | Big Bear Lake | 70 | -116.911422 | 34.243896 | |
| 749 | 749 | 2020-10-30 | San Bernardino | 71 | Big River | 2 | -114.369722 | 34.133889 | |
| 750 | 750 | 2020-10-30 | San Bernardino | 71 | Bloomington | 1412 | -117.39588 | 34.07029 | |
| 751 | 751 | 2020-10-30 | San Bernardino | 71 | Blue Jay | 19 | -117.216863 | 34.244027 | |
| 752 | 752 | 2020-10-30 | San Bernardino | 71 | Cedar Glen | 7 | -117.165 | 34.253889 | |
| 753 | 753 | 2020-10-30 | San Bernardino | 71 | Chino | 3995 | -117.688944 | 34.012235 | |
| 754 | 754 | 2020-10-30 | San Bernardino | 71 | Chino Hills | 1135 | -117.732585 | 33.989819 | |
| 755 | 755 | 2020-10-30 | San Bernardino | 71 | Colton | 2483 | -117.313655 | 34.073902 | |
| 756 | 756 | 2020-10-30 | San Bernardino | 71 | Crestline | 94 | -117.285599 | 34.241951 | |
| 757 | 757 | 2020-10-30 | San Bernardino | 71 | Daggett | 1 | -116.886523 | 34.86215 | |
| 758 | 758 | 2020-10-30 | San Bernardino | 71 | Devore | 2 | -117.401389 | 34.216389 | |
| 759 | 759 | 2020-10-30 | San Bernardino | 71 | Fawnskin | 3 | -116.947186 | 34.267411 | |
| 760 | 760 | 2020-10-30 | San Bernardino | 71 | Fontana | 8589 | -117.435048 | 34.092234 | |
| 761 | 761 | 2020-10-30 | San Bernardino | 71 | Forest Falls | 9 | -116.920278 | 34.088333 | |
| 762 | 762 | 2020-10-30 | San Bernardino | 71 | Grand Terrace | 373 | -117.313654 | 34.033903 | |
| 763 | 763 | 2020-10-30 | San Bernardino | 71 | Green Valley Lake | 1 | -117.077222 | 34.240833 | |
| 764 | 764 | 2020-10-30 | San Bernardino | 71 | Helendale | 77 | -117.324444 | 34.743889 | |
| 765 | 765 | 2020-10-30 | San Bernardino | 71 | Hesperia | 2464 | -117.300878 | 34.426389 | |
| 766 | 766 | 2020-10-30 | San Bernardino | 71 | Highland | 1748 | -117.208651 | 34.128344 | |
| 767 | 767 | 2020-10-30 | San Bernardino | 71 | Hinkley | 8 | -117.2 | 34.933333 | |
| 768 | 768 | 2020-10-30 | San Bernardino | 71 | Joshua Tree | 103 | -116.338749 | 34.126721 | |
| 769 | 769 | 2020-10-30 | San Bernardino | 71 | Lake Arrowhead | 52 | -117.189167 | 34.248333 | |
| 770 | 770 | 2020-10-30 | San Bernardino | 71 | Landers | 12 | -116.392222 | 34.266111 | |
| 771 | 771 | 2020-10-30 | San Bernardino | 71 | Loma Linda | 627 | -117.261153 | 34.048347 | |
| 772 | 772 | 2020-10-30 | San Bernardino | 71 | Lucerne Valley | 41 | -116.966944 | 34.443889 | |
| 773 | 773 | 2020-10-30 | San Bernardino | 71 | Lytle Creek | 16 | -117.499167 | 34.259167 | |
| 774 | 774 | 2020-10-30 | San Bernardino | 71 | Mentone | 291 | -117.124574 | 34.062589 | |
| 775 | 775 | 2020-10-30 | San Bernardino | 71 | Montclair | 1509 | -117.689778 | 34.07751 | |
| 776 | 776 | 2020-10-30 | San Bernardino | 71 | Morongo Valley | 47 | -116.580847 | 34.046955 | |
| 777 | 777 | 2020-10-30 | San Bernardino | 71 | Mt Baldy | 1 | -117.66 | 34.236111 | |
| 778 | 778 | 2020-10-30 | San Bernardino | 71 | Muscoy | 20 | -117.344167 | 34.154167 | |
| 779 | 779 | 2020-10-30 | San Bernardino | 71 | Needles | 77 | -114.619621 | 34.806179 | |
| 780 | 780 | 2020-10-30 | San Bernardino | 71 | Newberry Springs | 10 | -116.6875 | 34.827778 | |
| 781 | 781 | 2020-10-30 | San Bernardino | 71 | Oak Glen | 3 | -116.949444 | 34.045 | |
| 782 | 782 | 2020-10-30 | San Bernardino | 71 | Oak Hills | 224 | -117.434696 | 34.434038 | |
| 783 | 783 | 2020-10-30 | San Bernardino | 71 | Ontario | 6017 | -117.650888 | 34.063344 | |
| 784 | 784 | 2020-10-30 | San Bernardino | 71 | Oro Grande | 17 | -117.334167 | 34.598889 | |
| 785 | 785 | 2020-10-30 | San Bernardino | 71 | Phelan | 258 | -117.572563 | 34.426288 | |
| 786 | 786 | 2020-10-30 | San Bernardino | 71 | Pioneertown | 2 | -116.494722 | 34.157222 | |
| 787 | 787 | 2020-10-30 | San Bernardino | 71 | Piñon Hills | 71 | -117.650052 | 34.429272 | |
| 788 | 788 | 2020-10-30 | San Bernardino | 71 | Rancho Cucamonga | 3438 | -117.593108 | 34.106399 | |
| 789 | 789 | 2020-10-30 | San Bernardino | 71 | Redlands | 2061 | -117.182538 | 34.055569 | |
| 790 | 790 | 2020-10-30 | San Bernardino | 71 | Rialto | 4327 | -117.370324 | 34.1064 | |
| 791 | 791 | 2020-10-30 | San Bernardino | 71 | Rimforest | 4 | -117.225666 | 34.22955 | |
| 792 | 792 | 2020-10-30 | San Bernardino | 71 | Running Springs | 38 | -117.109205 | 34.207786 | |
| 793 | 793 | 2020-10-30 | San Bernardino | 71 | San Bernardino | 10093 | -117.289765 | 34.108345 | |
| 794 | 794 | 2020-10-30 | San Bernardino | 71 | Sugarloaf | 18 | -116.828889 | 34.243333 | |
| 795 | 795 | 2020-10-30 | San Bernardino | 71 | Trona | 14 | -117.382778 | 35.765278 | |
| 796 | 796 | 2020-10-30 | San Bernardino | 71 | Twentynine Palms | 100 | -116.054167 | 34.135556 | |
| 797 | 797 | 2020-10-30 | San Bernardino | 71 | Twin Peaks | 13 | -117.233611 | 34.238889 | |
| 798 | 798 | 2020-10-30 | San Bernardino | 71 | Upland | 1710 | -117.648388 | 34.09751 | |
| 799 | 799 | 2020-10-30 | San Bernardino | 71 | Victorville | 4152 | -117.292764 | 34.536218 | |
| 800 | 800 | 2020-10-30 | San Bernardino | 71 | Wrightwood | 41 | -117.633388 | 34.360834 | |
| 801 | 801 | 2020-10-30 | San Bernardino | 71 | Yermo | 14 | -116.820278 | 34.905 | |
| 802 | 802 | 2020-10-30 | San Bernardino | 71 | Yucaipa | 1201 | -117.043086 | 34.033625 | |
| 803 | 803 | 2020-10-30 | San Bernardino | 71 | Yucca Valley | 255 | -116.432235 | 34.114174 | |
| 1731 | 1731 | 2020-10-29 | San Bernardino | 71 | Adelanto | 1263 | -117.560861 | 34.591254 | |
| 1732 | 1732 | 2020-10-29 | San Bernardino | 71 | Angelus Oaks | 3 | -116.9825 | 34.145833 | |
| 1733 | 1733 | 2020-10-29 | San Bernardino | 71 | Apple Valley | 1446 | -117.185876 | 34.500831 | |
| 1734 | 1734 | 2020-10-29 | San Bernardino | 71 | Baker | 14 | -116.065833 | 35.275833 | |
| 1735 | 1735 | 2020-10-29 | San Bernardino | 71 | Baldy Mesa | 1 | -117.450278 | 34.459167 | |
| 1736 | 1736 | 2020-10-29 | San Bernardino | 71 | Barstow | 374 | -117.017283 | 34.895796 | |
| 1737 | 1737 | 2020-10-29 | San Bernardino | 71 | Big Bear City | 67 | -116.84503 | 34.261118 | |
| 1738 | 1738 | 2020-10-29 | San Bernardino | 71 | Big Bear Lake | 70 | -116.911422 | 34.243896 | |
| 1739 | 1739 | 2020-10-29 | San Bernardino | 71 | Big River | 2 | -114.369722 | 34.133889 | |
| 1740 | 1740 | 2020-10-29 | San Bernardino | 71 | Bloomington | 1410 | -117.39588 | 34.07029 | |
| 1741 | 1741 | 2020-10-29 | San Bernardino | 71 | Blue Jay | 18 | -117.216863 | 34.244027 | |
| 1742 | 1742 | 2020-10-29 | San Bernardino | 71 | Cedar Glen | 7 | -117.165 | 34.253889 | |
| 1743 | 1743 | 2020-10-29 | San Bernardino | 71 | Chino | 3986 | -117.688944 | 34.012235 | |
| 1744 | 1744 | 2020-10-29 | San Bernardino | 71 | Chino Hills | 1129 | -117.732585 | 33.989819 | |
| 1745 | 1745 | 2020-10-29 | San Bernardino | 71 | Colton | 2469 | -117.313655 | 34.073902 | |
| 1746 | 1746 | 2020-10-29 | San Bernardino | 71 | Crestline | 95 | -117.285599 | 34.241951 | |
| 1747 | 1747 | 2020-10-29 | San Bernardino | 71 | Daggett | 1 | -116.886523 | 34.86215 | |
| 1748 | 1748 | 2020-10-29 | San Bernardino | 71 | Devore | 2 | -117.401389 | 34.216389 | |
| 1749 | 1749 | 2020-10-29 | San Bernardino | 71 | Fawnskin | 3 | -116.947186 | 34.267411 | |
| 1750 | 1750 | 2020-10-29 | San Bernardino | 71 | Fontana | 8558 | -117.435048 | 34.092234 | |
| 1751 | 1751 | 2020-10-29 | San Bernardino | 71 | Forest Falls | 9 | -116.920278 | 34.088333 | |
| 1752 | 1752 | 2020-10-29 | San Bernardino | 71 | Grand Terrace | 374 | -117.313654 | 34.033903 | |
| 1753 | 1753 | 2020-10-29 | San Bernardino | 71 | Green Valley Lake | 1 | -117.077222 | 34.240833 | |
| 1754 | 1754 | 2020-10-29 | San Bernardino | 71 | Helendale | 77 | -117.324444 | 34.743889 | |
| 1755 | 1755 | 2020-10-29 | San Bernardino | 71 | Hesperia | 2455 | -117.300878 | 34.426389 | |
| 1756 | 1756 | 2020-10-29 | San Bernardino | 71 | Highland | 1740 | -117.208651 | 34.128344 | |
| 1757 | 1757 | 2020-10-29 | San Bernardino | 71 | Hinkley | 7 | -117.2 | 34.933333 | |
| 1758 | 1758 | 2020-10-29 | San Bernardino | 71 | Joshua Tree | 102 | -116.338749 | 34.126721 | |
| 1759 | 1759 | 2020-10-29 | San Bernardino | 71 | Lake Arrowhead | 52 | -117.189167 | 34.248333 | |
| 1760 | 1760 | 2020-10-29 | San Bernardino | 71 | Landers | 12 | -116.392222 | 34.266111 | |
| 1761 | 1761 | 2020-10-29 | San Bernardino | 71 | Loma Linda | 626 | -117.261153 | 34.048347 | |
| 1762 | 1762 | 2020-10-29 | San Bernardino | 71 | Lucerne Valley | 41 | -116.966944 | 34.443889 | |
| 1763 | 1763 | 2020-10-29 | San Bernardino | 71 | Lytle Creek | 16 | -117.499167 | 34.259167 | |
| 1764 | 1764 | 2020-10-29 | San Bernardino | 71 | Mentone | 291 | -117.124574 | 34.062589 | |
| 1765 | 1765 | 2020-10-29 | San Bernardino | 71 | Montclair | 1502 | -117.689778 | 34.07751 | |
| 1766 | 1766 | 2020-10-29 | San Bernardino | 71 | Morongo Valley | 47 | -116.580847 | 34.046955 | |
| 1767 | 1767 | 2020-10-29 | 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 );