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

9,613 rows where county = "San Bernardino" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 71 9,613

county

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