latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
64 rows where county = "San Bernardino", "date" is on date 2021-07-04 and fips = 71 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
686854 | 686854 | Adelanto | Adelanto | 2021-07-04 | San Bernardino | 71 | 5553 | 35234 | |
686855 | 686855 | Angelus Oaks | Angelus Oaks | 2021-07-04 | San Bernardino | 71 | 40 | 385 | |
686856 | 686856 | Apple Valley | Apple Valley | 2021-07-04 | San Bernardino | 71 | 9642 | 73694 | |
686857 | 686857 | Arrowbear | Arrowbear | 2021-07-04 | San Bernardino | 71 | 5 | 723 | |
686858 | 686858 | Baker | Baker | 2021-07-04 | San Bernardino | 71 | 57 | 799 | |
686859 | 686859 | Barstow | Barstow | 2021-07-04 | San Bernardino | 71 | 3517 | 23754 | |
686860 | 686860 | Big Bear City | Big Bear City | 2021-07-04 | San Bernardino | 71 | 579 | 10045 | |
686861 | 686861 | Big Bear Lake | Big Bear Lake | 2021-07-04 | San Bernardino | 71 | 404 | 5231 | |
686862 | 686862 | Big River | Big River | 2021-07-04 | San Bernardino | 71 | 20 | 1264 | |
686863 | 686863 | Bloomington | Bloomington | 2021-07-04 | San Bernardino | 71 | 6086 | 17115 | |
686864 | 686864 | Blue Jay | Blue Jay | 2021-07-04 | San Bernardino | 71 | 159 | 900 | |
686865 | 686865 | Cedar Glen | Cedar Glen | 2021-07-04 | San Bernardino | 71 | 7 | 739 | |
686866 | 686866 | Chino | Chino | 2021-07-04 | San Bernardino | 71 | 13418 | 93099 | |
686867 | 686867 | Chino Hills | Chino Hills | 2021-07-04 | San Bernardino | 71 | 5977 | 82917 | |
686868 | 686868 | Colton | Colton | 2021-07-04 | San Bernardino | 71 | 10337 | 54636 | |
686869 | 686869 | Crestline | Crestline | 2021-07-04 | San Bernardino | 71 | 650 | 8010 | |
686870 | 686870 | Daggett | Daggett | 2021-07-04 | San Bernardino | 71 | 20 | 549 | |
686871 | 686871 | Devore | Devore | 2021-07-04 | San Bernardino | 71 | 2 | 2283 | |
686872 | 686872 | Fawnskin | Fawnskin | 2021-07-04 | San Bernardino | 71 | 21 | 528 | |
686873 | 686873 | Fontana | Fontana | 2021-07-04 | San Bernardino | 71 | 40181 | 215334 | |
686874 | 686874 | Forest Falls | Forest Falls | 2021-07-04 | San Bernardino | 71 | 39 | 920 | |
686875 | 686875 | Grand Terrace | Grand Terrace | 2021-07-04 | San Bernardino | 71 | 1651 | 12403 | |
686876 | 686876 | Green Valley Lake | Green Valley Lake | 2021-07-04 | San Bernardino | 71 | 13 | 412 | |
686877 | 686877 | Havasu Lake | Havasu Lake | 2021-07-04 | San Bernardino | 71 | 0 | 0 | |
686878 | 686878 | Helendale | Helendale | 2021-07-04 | San Bernardino | 71 | 529 | 6629 | |
686879 | 686879 | Hesperia | Hesperia | 2021-07-04 | San Bernardino | 71 | 14235 | 97312 | |
686880 | 686880 | Highland | Highland | 2021-07-04 | San Bernardino | 71 | 8218 | 55484 | |
686881 | 686881 | Hinkley | Hinkley | 2021-07-04 | San Bernardino | 71 | 60 | 1259 | |
686882 | 686882 | Joshua Tree | Joshua Tree | 2021-07-04 | San Bernardino | 71 | 360 | 9887 | |
686883 | 686883 | Lake Arrowhead | Lake Arrowhead | 2021-07-04 | San Bernardino | 71 | 471 | 8104 | |
686884 | 686884 | Landers | Landers | 2021-07-04 | San Bernardino | 71 | 60 | 2983 | |
686885 | 686885 | Loma Linda | Loma Linda | 2021-07-04 | San Bernardino | 71 | 2699 | 25260 | |
686886 | 686886 | Lucerne Valley | Lucerne Valley | 2021-07-04 | San Bernardino | 71 | 363 | 7041 | |
686887 | 686887 | Lytle Creek | Lytle Creek | 2021-07-04 | San Bernardino | 71 | 72 | 837 | |
686888 | 686888 | Mentone | Mentone | 2021-07-04 | San Bernardino | 71 | 1104 | 9255 | |
686889 | 686889 | Montclair | Montclair | 2021-07-04 | San Bernardino | 71 | 6259 | 40415 | |
686890 | 686890 | Morongo Valley | Morongo Valley | 2021-07-04 | San Bernardino | 71 | 181 | 3739 | |
686891 | 686891 | Mt Baldy | Mt Baldy | 2021-07-04 | San Bernardino | 71 | 2 | 537 | |
686892 | 686892 | Muscoy | Muscoy | 2021-07-04 | San Bernardino | 71 | 114 | 11536 | |
686893 | 686893 | Needles | Needles | 2021-07-04 | San Bernardino | 71 | 400 | 4964 | |
686894 | 686894 | Newberry Springs | Newberry Springs | 2021-07-04 | San Bernardino | 71 | 139 | 2215 | |
686895 | 686895 | Oak Glen | Oak Glen | 2021-07-04 | San Bernardino | 71 | 15 | 625 | |
686896 | 686896 | Oak Hills | Oak Hills | 2021-07-04 | San Bernardino | 71 | 1600 | 9488 | |
686897 | 686897 | Ontario | Ontario | 2021-07-04 | San Bernardino | 71 | 26508 | 182380 | |
686898 | 686898 | Oro Grande | Oro Grande | 2021-07-04 | San Bernardino | 71 | 132 | 1137 | |
686899 | 686899 | Phelan | Phelan | 2021-07-04 | San Bernardino | 71 | 1683 | 14757 | |
686900 | 686900 | Pinon Hills | Pinon Hills | 2021-07-04 | San Bernardino | 71 | 434 | 8042 | |
686901 | 686901 | Pioneertown | Pioneertown | 2021-07-04 | San Bernardino | 71 | 8 | 365 | |
686902 | 686902 | Rancho Cucamonga | Rancho Cucamonga | 2021-07-04 | San Bernardino | 71 | 18649 | 177037 | |
686903 | 686903 | Redlands | Redlands | 2021-07-04 | San Bernardino | 71 | 8912 | 72099 | |
686904 | 686904 | Rialto | Rialto | 2021-07-04 | San Bernardino | 71 | 18854 | 103884 | |
686905 | 686905 | Rimforest | Rimforest | 2021-07-04 | San Bernardino | 71 | 45 | 756 | |
686906 | 686906 | Running Springs | Running Springs | 2021-07-04 | San Bernardino | 71 | 294 | 4661 | |
686907 | 686907 | San Bernardino | San Bernardino | 2021-07-04 | San Bernardino | 71 | 41145 | 218515 | |
686908 | 686908 | Sugarloaf | Sugarloaf | 2021-07-04 | San Bernardino | 71 | 93 | 3137 | |
686909 | 686909 | Trona | Trona | 2021-07-04 | San Bernardino | 71 | 47 | 1191 | |
686910 | 686910 | Twentynine Palms | Twentynine Palms | 2021-07-04 | San Bernardino | 71 | 1135 | 24966 | |
686911 | 686911 | Twin Peaks | Twin Peaks | 2021-07-04 | San Bernardino | 71 | 136 | 2493 | |
686912 | 686912 | Upland | Upland | 2021-07-04 | San Bernardino | 71 | 8707 | 78249 | |
686913 | 686913 | Victorville | Victorville | 2021-07-04 | San Bernardino | 71 | 21727 | 128353 | |
686914 | 686914 | Wrightwood | Wrightwood | 2021-07-04 | San Bernardino | 71 | 336 | 5177 | |
686915 | 686915 | Yermo | Yermo | 2021-07-04 | San Bernardino | 71 | 83 | 1672 | |
686916 | 686916 | Yucaipa | Yucaipa | 2021-07-04 | San Bernardino | 71 | 5774 | 54490 | |
686917 | 686917 | Yucca Valley | Yucca Valley | 2021-07-04 | San Bernardino | 71 | 1556 | 22146 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );