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-08-17 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 |
---|---|---|---|---|---|---|---|---|---|
630710 | 630710 | Adelanto | Adelanto | 2021-08-17 | San Bernardino | 71 | 5869 | 35234 | |
630711 | 630711 | Angelus Oaks | Angelus Oaks | 2021-08-17 | San Bernardino | 71 | 43 | 385 | |
630712 | 630712 | Apple Valley | Apple Valley | 2021-08-17 | San Bernardino | 71 | 10295 | 73694 | |
630713 | 630713 | Arrowbear | Arrowbear | 2021-08-17 | San Bernardino | 71 | 5 | 723 | |
630714 | 630714 | Baker | Baker | 2021-08-17 | San Bernardino | 71 | 57 | 799 | |
630715 | 630715 | Barstow | Barstow | 2021-08-17 | San Bernardino | 71 | 3696 | 23754 | |
630716 | 630716 | Big Bear City | Big Bear City | 2021-08-17 | San Bernardino | 71 | 759 | 10045 | |
630717 | 630717 | Big Bear Lake | Big Bear Lake | 2021-08-17 | San Bernardino | 71 | 483 | 5231 | |
630718 | 630718 | Big River | Big River | 2021-08-17 | San Bernardino | 71 | 21 | 1264 | |
630719 | 630719 | Bloomington | Bloomington | 2021-08-17 | San Bernardino | 71 | 6410 | 17115 | |
630720 | 630720 | Blue Jay | Blue Jay | 2021-08-17 | San Bernardino | 71 | 177 | 900 | |
630721 | 630721 | Cedar Glen | Cedar Glen | 2021-08-17 | San Bernardino | 71 | 7 | 739 | |
630722 | 630722 | Chino | Chino | 2021-08-17 | San Bernardino | 71 | 14349 | 93099 | |
630723 | 630723 | Chino Hills | Chino Hills | 2021-08-17 | San Bernardino | 71 | 6591 | 82917 | |
630724 | 630724 | Colton | Colton | 2021-08-17 | San Bernardino | 71 | 10843 | 54636 | |
630725 | 630725 | Crestline | Crestline | 2021-08-17 | San Bernardino | 71 | 710 | 8010 | |
630726 | 630726 | Daggett | Daggett | 2021-08-17 | San Bernardino | 71 | 19 | 549 | |
630727 | 630727 | Devore | Devore | 2021-08-17 | San Bernardino | 71 | 2 | 2283 | |
630728 | 630728 | Fawnskin | Fawnskin | 2021-08-17 | San Bernardino | 71 | 27 | 528 | |
630729 | 630729 | Fontana | Fontana | 2021-08-17 | San Bernardino | 71 | 42479 | 215334 | |
630730 | 630730 | Forest Falls | Forest Falls | 2021-08-17 | San Bernardino | 71 | 43 | 920 | |
630731 | 630731 | Grand Terrace | Grand Terrace | 2021-08-17 | San Bernardino | 71 | 1775 | 12403 | |
630732 | 630732 | Green Valley Lake | Green Valley Lake | 2021-08-17 | San Bernardino | 71 | 16 | 412 | |
630733 | 630733 | Havasu Lake | Havasu Lake | 2021-08-17 | San Bernardino | 71 | 0 | 0 | |
630734 | 630734 | Helendale | Helendale | 2021-08-17 | San Bernardino | 71 | 568 | 6629 | |
630735 | 630735 | Hesperia | Hesperia | 2021-08-17 | San Bernardino | 71 | 15015 | 97312 | |
630736 | 630736 | Highland | Highland | 2021-08-17 | San Bernardino | 71 | 8696 | 55484 | |
630737 | 630737 | Hinkley | Hinkley | 2021-08-17 | San Bernardino | 71 | 64 | 1259 | |
630738 | 630738 | Joshua Tree | Joshua Tree | 2021-08-17 | San Bernardino | 71 | 425 | 9887 | |
630739 | 630739 | Lake Arrowhead | Lake Arrowhead | 2021-08-17 | San Bernardino | 71 | 515 | 8104 | |
630740 | 630740 | Landers | Landers | 2021-08-17 | San Bernardino | 71 | 62 | 2983 | |
630741 | 630741 | Loma Linda | Loma Linda | 2021-08-17 | San Bernardino | 71 | 2866 | 25260 | |
630742 | 630742 | Lucerne Valley | Lucerne Valley | 2021-08-17 | San Bernardino | 71 | 406 | 7041 | |
630743 | 630743 | Lytle Creek | Lytle Creek | 2021-08-17 | San Bernardino | 71 | 78 | 837 | |
630744 | 630744 | Mentone | Mentone | 2021-08-17 | San Bernardino | 71 | 1195 | 9255 | |
630745 | 630745 | Montclair | Montclair | 2021-08-17 | San Bernardino | 71 | 6552 | 40415 | |
630746 | 630746 | Morongo Valley | Morongo Valley | 2021-08-17 | San Bernardino | 71 | 198 | 3739 | |
630747 | 630747 | Mt Baldy | Mt Baldy | 2021-08-17 | San Bernardino | 71 | 2 | 537 | |
630748 | 630748 | Muscoy | Muscoy | 2021-08-17 | San Bernardino | 71 | 117 | 11536 | |
630749 | 630749 | Needles | Needles | 2021-08-17 | San Bernardino | 71 | 424 | 4964 | |
630750 | 630750 | Newberry Springs | Newberry Springs | 2021-08-17 | San Bernardino | 71 | 146 | 2215 | |
630751 | 630751 | Oak Glen | Oak Glen | 2021-08-17 | San Bernardino | 71 | 16 | 625 | |
630752 | 630752 | Oak Hills | Oak Hills | 2021-08-17 | San Bernardino | 71 | 1705 | 9488 | |
630753 | 630753 | Ontario | Ontario | 2021-08-17 | San Bernardino | 71 | 28032 | 182380 | |
630754 | 630754 | Oro Grande | Oro Grande | 2021-08-17 | San Bernardino | 71 | 141 | 1137 | |
630755 | 630755 | Phelan | Phelan | 2021-08-17 | San Bernardino | 71 | 1809 | 14757 | |
630756 | 630756 | Pinon Hills | Pinon Hills | 2021-08-17 | San Bernardino | 71 | 472 | 8042 | |
630757 | 630757 | Pioneertown | Pioneertown | 2021-08-17 | San Bernardino | 71 | 10 | 365 | |
630758 | 630758 | Rancho Cucamonga | Rancho Cucamonga | 2021-08-17 | San Bernardino | 71 | 20437 | 177037 | |
630759 | 630759 | Redlands | Redlands | 2021-08-17 | San Bernardino | 71 | 9577 | 72099 | |
630760 | 630760 | Rialto | Rialto | 2021-08-17 | San Bernardino | 71 | 19780 | 103884 | |
630761 | 630761 | Rimforest | Rimforest | 2021-08-17 | San Bernardino | 71 | 49 | 756 | |
630762 | 630762 | Running Springs | Running Springs | 2021-08-17 | San Bernardino | 71 | 340 | 4661 | |
630763 | 630763 | San Bernardino | San Bernardino | 2021-08-17 | San Bernardino | 71 | 43191 | 218515 | |
630764 | 630764 | Sugarloaf | Sugarloaf | 2021-08-17 | San Bernardino | 71 | 123 | 3137 | |
630765 | 630765 | Trona | Trona | 2021-08-17 | San Bernardino | 71 | 49 | 1191 | |
630766 | 630766 | Twentynine Palms | Twentynine Palms | 2021-08-17 | San Bernardino | 71 | 1382 | 24966 | |
630767 | 630767 | Twin Peaks | Twin Peaks | 2021-08-17 | San Bernardino | 71 | 144 | 2493 | |
630768 | 630768 | Upland | Upland | 2021-08-17 | San Bernardino | 71 | 9383 | 78249 | |
630769 | 630769 | Victorville | Victorville | 2021-08-17 | San Bernardino | 71 | 23112 | 128353 | |
630770 | 630770 | Wrightwood | Wrightwood | 2021-08-17 | San Bernardino | 71 | 360 | 5177 | |
630771 | 630771 | Yermo | Yermo | 2021-08-17 | San Bernardino | 71 | 86 | 1672 | |
630772 | 630772 | Yucaipa | Yucaipa | 2021-08-17 | San Bernardino | 71 | 6202 | 54490 | |
630773 | 630773 | Yucca Valley | Yucca Valley | 2021-08-17 | San Bernardino | 71 | 1734 | 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 );