latimes_place_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

10,054 rows where fips = 71 sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 71 · 10,054

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 983.622ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals