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-06-20 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 |
---|---|---|---|---|---|---|---|---|---|
704718 | 704718 | Adelanto | Adelanto | 2021-06-20 | San Bernardino | 71 | 5542 | 35234 | |
704719 | 704719 | Angelus Oaks | Angelus Oaks | 2021-06-20 | San Bernardino | 71 | 40 | 385 | |
704720 | 704720 | Apple Valley | Apple Valley | 2021-06-20 | San Bernardino | 71 | 9611 | 73694 | |
704721 | 704721 | Arrowbear | Arrowbear | 2021-06-20 | San Bernardino | 71 | 5 | 723 | |
704722 | 704722 | Baker | Baker | 2021-06-20 | San Bernardino | 71 | 57 | 799 | |
704723 | 704723 | Barstow | Barstow | 2021-06-20 | San Bernardino | 71 | 3503 | 23754 | |
704724 | 704724 | Big Bear City | Big Bear City | 2021-06-20 | San Bernardino | 71 | 573 | 10045 | |
704725 | 704725 | Big Bear Lake | Big Bear Lake | 2021-06-20 | San Bernardino | 71 | 401 | 5231 | |
704726 | 704726 | Big River | Big River | 2021-06-20 | San Bernardino | 71 | 20 | 1264 | |
704727 | 704727 | Bloomington | Bloomington | 2021-06-20 | San Bernardino | 71 | 6081 | 17115 | |
704728 | 704728 | Blue Jay | Blue Jay | 2021-06-20 | San Bernardino | 71 | 159 | 900 | |
704729 | 704729 | Cedar Glen | Cedar Glen | 2021-06-20 | San Bernardino | 71 | 7 | 739 | |
704730 | 704730 | Chino | Chino | 2021-06-20 | San Bernardino | 71 | 13386 | 93099 | |
704731 | 704731 | Chino Hills | Chino Hills | 2021-06-20 | San Bernardino | 71 | 5954 | 82917 | |
704732 | 704732 | Colton | Colton | 2021-06-20 | San Bernardino | 71 | 10323 | 54636 | |
704733 | 704733 | Crestline | Crestline | 2021-06-20 | San Bernardino | 71 | 650 | 8010 | |
704734 | 704734 | Daggett | Daggett | 2021-06-20 | San Bernardino | 71 | 20 | 549 | |
704735 | 704735 | Devore | Devore | 2021-06-20 | San Bernardino | 71 | 2 | 2283 | |
704736 | 704736 | Fawnskin | Fawnskin | 2021-06-20 | San Bernardino | 71 | 21 | 528 | |
704737 | 704737 | Fontana | Fontana | 2021-06-20 | San Bernardino | 71 | 40113 | 215334 | |
704738 | 704738 | Forest Falls | Forest Falls | 2021-06-20 | San Bernardino | 71 | 40 | 920 | |
704739 | 704739 | Grand Terrace | Grand Terrace | 2021-06-20 | San Bernardino | 71 | 1651 | 12403 | |
704740 | 704740 | Green Valley Lake | Green Valley Lake | 2021-06-20 | San Bernardino | 71 | 13 | 412 | |
704741 | 704741 | Havasu Lake | Havasu Lake | 2021-06-20 | San Bernardino | 71 | 0 | 0 | |
704742 | 704742 | Helendale | Helendale | 2021-06-20 | San Bernardino | 71 | 529 | 6629 | |
704743 | 704743 | Hesperia | Hesperia | 2021-06-20 | San Bernardino | 71 | 14197 | 97312 | |
704744 | 704744 | Highland | Highland | 2021-06-20 | San Bernardino | 71 | 8205 | 55484 | |
704745 | 704745 | Hinkley | Hinkley | 2021-06-20 | San Bernardino | 71 | 60 | 1259 | |
704746 | 704746 | Joshua Tree | Joshua Tree | 2021-06-20 | San Bernardino | 71 | 360 | 9887 | |
704747 | 704747 | Lake Arrowhead | Lake Arrowhead | 2021-06-20 | San Bernardino | 71 | 474 | 8104 | |
704748 | 704748 | Landers | Landers | 2021-06-20 | San Bernardino | 71 | 60 | 2983 | |
704749 | 704749 | Loma Linda | Loma Linda | 2021-06-20 | San Bernardino | 71 | 2695 | 25260 | |
704750 | 704750 | Lucerne Valley | Lucerne Valley | 2021-06-20 | San Bernardino | 71 | 360 | 7041 | |
704751 | 704751 | Lytle Creek | Lytle Creek | 2021-06-20 | San Bernardino | 71 | 72 | 837 | |
704752 | 704752 | Mentone | Mentone | 2021-06-20 | San Bernardino | 71 | 1104 | 9255 | |
704753 | 704753 | Montclair | Montclair | 2021-06-20 | San Bernardino | 71 | 6247 | 40415 | |
704754 | 704754 | Morongo Valley | Morongo Valley | 2021-06-20 | San Bernardino | 71 | 181 | 3739 | |
704755 | 704755 | Mt Baldy | Mt Baldy | 2021-06-20 | San Bernardino | 71 | 2 | 537 | |
704756 | 704756 | Muscoy | Muscoy | 2021-06-20 | San Bernardino | 71 | 114 | 11536 | |
704757 | 704757 | Needles | Needles | 2021-06-20 | San Bernardino | 71 | 400 | 4964 | |
704758 | 704758 | Newberry Springs | Newberry Springs | 2021-06-20 | San Bernardino | 71 | 137 | 2215 | |
704759 | 704759 | Oak Glen | Oak Glen | 2021-06-20 | San Bernardino | 71 | 14 | 625 | |
704760 | 704760 | Oak Hills | Oak Hills | 2021-06-20 | San Bernardino | 71 | 1590 | 9488 | |
704761 | 704761 | Ontario | Ontario | 2021-06-20 | San Bernardino | 71 | 26466 | 182380 | |
704762 | 704762 | Oro Grande | Oro Grande | 2021-06-20 | San Bernardino | 71 | 133 | 1137 | |
704763 | 704763 | Phelan | Phelan | 2021-06-20 | San Bernardino | 71 | 1680 | 14757 | |
704764 | 704764 | Pinon Hills | Pinon Hills | 2021-06-20 | San Bernardino | 71 | 432 | 8042 | |
704765 | 704765 | Pioneertown | Pioneertown | 2021-06-20 | San Bernardino | 71 | 8 | 365 | |
704766 | 704766 | Rancho Cucamonga | Rancho Cucamonga | 2021-06-20 | San Bernardino | 71 | 18565 | 177037 | |
704767 | 704767 | Redlands | Redlands | 2021-06-20 | San Bernardino | 71 | 8883 | 72099 | |
704768 | 704768 | Rialto | Rialto | 2021-06-20 | San Bernardino | 71 | 18804 | 103884 | |
704769 | 704769 | Rimforest | Rimforest | 2021-06-20 | San Bernardino | 71 | 45 | 756 | |
704770 | 704770 | Running Springs | Running Springs | 2021-06-20 | San Bernardino | 71 | 293 | 4661 | |
704771 | 704771 | San Bernardino | San Bernardino | 2021-06-20 | San Bernardino | 71 | 41045 | 218515 | |
704772 | 704772 | Sugarloaf | Sugarloaf | 2021-06-20 | San Bernardino | 71 | 91 | 3137 | |
704773 | 704773 | Trona | Trona | 2021-06-20 | San Bernardino | 71 | 47 | 1191 | |
704774 | 704774 | Twentynine Palms | Twentynine Palms | 2021-06-20 | San Bernardino | 71 | 1129 | 24966 | |
704775 | 704775 | Twin Peaks | Twin Peaks | 2021-06-20 | San Bernardino | 71 | 136 | 2493 | |
704776 | 704776 | Upland | Upland | 2021-06-20 | San Bernardino | 71 | 8682 | 78249 | |
704777 | 704777 | Victorville | Victorville | 2021-06-20 | San Bernardino | 71 | 21662 | 128353 | |
704778 | 704778 | Wrightwood | Wrightwood | 2021-06-20 | San Bernardino | 71 | 336 | 5177 | |
704779 | 704779 | Yermo | Yermo | 2021-06-20 | San Bernardino | 71 | 83 | 1672 | |
704780 | 704780 | Yucaipa | Yucaipa | 2021-06-20 | San Bernardino | 71 | 5756 | 54490 | |
704781 | 704781 | Yucca Valley | Yucca Valley | 2021-06-20 | San Bernardino | 71 | 1552 | 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 );