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-03-14 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 |
---|---|---|---|---|---|---|---|---|---|
829766 | 829766 | Adelanto | Adelanto | 2021-03-14 | San Bernardino | 71 | 5289 | 35234 | |
829767 | 829767 | Angelus Oaks | Angelus Oaks | 2021-03-14 | San Bernardino | 71 | 37 | 385 | |
829768 | 829768 | Apple Valley | Apple Valley | 2021-03-14 | San Bernardino | 71 | 9131 | 73694 | |
829769 | 829769 | Arrowbear | Arrowbear | 2021-03-14 | San Bernardino | 71 | 5 | 723 | |
829770 | 829770 | Baker | Baker | 2021-03-14 | San Bernardino | 71 | 49 | 799 | |
829771 | 829771 | Barstow | Barstow | 2021-03-14 | San Bernardino | 71 | 3424 | 23754 | |
829772 | 829772 | Big Bear City | Big Bear City | 2021-03-14 | San Bernardino | 71 | 544 | 10045 | |
829773 | 829773 | Big Bear Lake | Big Bear Lake | 2021-03-14 | San Bernardino | 71 | 372 | 5231 | |
829774 | 829774 | Big River | Big River | 2021-03-14 | San Bernardino | 71 | 20 | 1264 | |
829775 | 829775 | Bloomington | Bloomington | 2021-03-14 | San Bernardino | 71 | 5942 | 17115 | |
829776 | 829776 | Blue Jay | Blue Jay | 2021-03-14 | San Bernardino | 71 | 151 | 900 | |
829777 | 829777 | Cedar Glen | Cedar Glen | 2021-03-14 | San Bernardino | 71 | 7 | 739 | |
829778 | 829778 | Chino | Chino | 2021-03-14 | San Bernardino | 71 | 12987 | 93099 | |
829779 | 829779 | Chino Hills | Chino Hills | 2021-03-14 | San Bernardino | 71 | 5672 | 82917 | |
829780 | 829780 | Colton | Colton | 2021-03-14 | San Bernardino | 71 | 10093 | 54636 | |
829781 | 829781 | Crestline | Crestline | 2021-03-14 | San Bernardino | 71 | 624 | 8010 | |
829782 | 829782 | Daggett | Daggett | 2021-03-14 | San Bernardino | 71 | 18 | 549 | |
829783 | 829783 | Devore | Devore | 2021-03-14 | San Bernardino | 71 | 2 | 2283 | |
829784 | 829784 | Fawnskin | Fawnskin | 2021-03-14 | San Bernardino | 71 | 20 | 528 | |
829785 | 829785 | Fontana | Fontana | 2021-03-14 | San Bernardino | 71 | 38958 | 215334 | |
829786 | 829786 | Forest Falls | Forest Falls | 2021-03-14 | San Bernardino | 71 | 36 | 920 | |
829787 | 829787 | Grand Terrace | Grand Terrace | 2021-03-14 | San Bernardino | 71 | 1595 | 12403 | |
829788 | 829788 | Green Valley Lake | Green Valley Lake | 2021-03-14 | San Bernardino | 71 | 14 | 412 | |
829789 | 829789 | Havasu Lake | Havasu Lake | 2021-03-14 | San Bernardino | 71 | 0 | 0 | |
829790 | 829790 | Helendale | Helendale | 2021-03-14 | San Bernardino | 71 | 506 | 6629 | |
829791 | 829791 | Hesperia | Hesperia | 2021-03-14 | San Bernardino | 71 | 13615 | 97312 | |
829792 | 829792 | Highland | Highland | 2021-03-14 | San Bernardino | 71 | 7872 | 55484 | |
829793 | 829793 | Hinkley | Hinkley | 2021-03-14 | San Bernardino | 71 | 56 | 1259 | |
829794 | 829794 | Joshua Tree | Joshua Tree | 2021-03-14 | San Bernardino | 71 | 320 | 9887 | |
829795 | 829795 | Lake Arrowhead | Lake Arrowhead | 2021-03-14 | San Bernardino | 71 | 450 | 8104 | |
829796 | 829796 | Landers | Landers | 2021-03-14 | San Bernardino | 71 | 57 | 2983 | |
829797 | 829797 | Loma Linda | Loma Linda | 2021-03-14 | San Bernardino | 71 | 2621 | 25260 | |
829798 | 829798 | Lucerne Valley | Lucerne Valley | 2021-03-14 | San Bernardino | 71 | 341 | 7041 | |
829799 | 829799 | Lytle Creek | Lytle Creek | 2021-03-14 | San Bernardino | 71 | 73 | 837 | |
829800 | 829800 | Mentone | Mentone | 2021-03-14 | San Bernardino | 71 | 1080 | 9255 | |
829801 | 829801 | Montclair | Montclair | 2021-03-14 | San Bernardino | 71 | 6049 | 40415 | |
829802 | 829802 | Morongo Valley | Morongo Valley | 2021-03-14 | San Bernardino | 71 | 172 | 3739 | |
829803 | 829803 | Mt Baldy | Mt Baldy | 2021-03-14 | San Bernardino | 71 | 2 | 537 | |
829804 | 829804 | Muscoy | Muscoy | 2021-03-14 | San Bernardino | 71 | 103 | 11536 | |
829805 | 829805 | Needles | Needles | 2021-03-14 | San Bernardino | 71 | 339 | 4964 | |
829806 | 829806 | Newberry Springs | Newberry Springs | 2021-03-14 | San Bernardino | 71 | 133 | 2215 | |
829807 | 829807 | Oak Glen | Oak Glen | 2021-03-14 | San Bernardino | 71 | 12 | 625 | |
829808 | 829808 | Oak Hills | Oak Hills | 2021-03-14 | San Bernardino | 71 | 1507 | 9488 | |
829809 | 829809 | Ontario | Ontario | 2021-03-14 | San Bernardino | 71 | 25642 | 182380 | |
829810 | 829810 | Oro Grande | Oro Grande | 2021-03-14 | San Bernardino | 71 | 130 | 1137 | |
829811 | 829811 | Phelan | Phelan | 2021-03-14 | San Bernardino | 71 | 1589 | 14757 | |
829812 | 829812 | Pinon Hills | Pinon Hills | 2021-03-14 | San Bernardino | 71 | 401 | 8042 | |
829813 | 829813 | Pioneertown | Pioneertown | 2021-03-14 | San Bernardino | 71 | 9 | 365 | |
829814 | 829814 | Rancho Cucamonga | Rancho Cucamonga | 2021-03-14 | San Bernardino | 71 | 17899 | 177037 | |
829815 | 829815 | Redlands | Redlands | 2021-03-14 | San Bernardino | 71 | 8508 | 72099 | |
829816 | 829816 | Rialto | Rialto | 2021-03-14 | San Bernardino | 71 | 18245 | 103884 | |
829817 | 829817 | Rimforest | Rimforest | 2021-03-14 | San Bernardino | 71 | 43 | 756 | |
829818 | 829818 | Running Springs | Running Springs | 2021-03-14 | San Bernardino | 71 | 274 | 4661 | |
829819 | 829819 | San Bernardino | San Bernardino | 2021-03-14 | San Bernardino | 71 | 39744 | 218515 | |
829820 | 829820 | Sugarloaf | Sugarloaf | 2021-03-14 | San Bernardino | 71 | 89 | 3137 | |
829821 | 829821 | Trona | Trona | 2021-03-14 | San Bernardino | 71 | 41 | 1191 | |
829822 | 829822 | Twentynine Palms | Twentynine Palms | 2021-03-14 | San Bernardino | 71 | 1026 | 24966 | |
829823 | 829823 | Twin Peaks | Twin Peaks | 2021-03-14 | San Bernardino | 71 | 127 | 2493 | |
829824 | 829824 | Upland | Upland | 2021-03-14 | San Bernardino | 71 | 8403 | 78249 | |
829825 | 829825 | Victorville | Victorville | 2021-03-14 | San Bernardino | 71 | 20480 | 128353 | |
829826 | 829826 | Wrightwood | Wrightwood | 2021-03-14 | San Bernardino | 71 | 321 | 5177 | |
829827 | 829827 | Yermo | Yermo | 2021-03-14 | San Bernardino | 71 | 81 | 1672 | |
829828 | 829828 | Yucaipa | Yucaipa | 2021-03-14 | San Bernardino | 71 | 5504 | 54490 | |
829829 | 829829 | Yucca Valley | Yucca Valley | 2021-03-14 | San Bernardino | 71 | 1403 | 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 );