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 2022-06-27 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 |
---|---|---|---|---|---|---|---|---|---|
231601 | 231601 | Adelanto | Adelanto | 2022-06-27 | San Bernardino | 71 | 10135 | 35234 | |
231602 | 231602 | Angelus Oaks | Angelus Oaks | 2022-06-27 | San Bernardino | 71 | 88 | 385 | |
231603 | 231603 | Apple Valley | Apple Valley | 2022-06-27 | San Bernardino | 71 | 20726 | 73694 | |
231604 | 231604 | Arrowbear | Arrowbear | 2022-06-27 | San Bernardino | 71 | 10 | 723 | |
231605 | 231605 | Baker | Baker | 2022-06-27 | San Bernardino | 71 | 104 | 799 | |
231606 | 231606 | Barstow | Barstow | 2022-06-27 | San Bernardino | 71 | 7093 | 23754 | |
231607 | 231607 | Big Bear City | Big Bear City | 2022-06-27 | San Bernardino | 71 | 1440 | 10045 | |
231608 | 231608 | Big Bear Lake | Big Bear Lake | 2022-06-27 | San Bernardino | 71 | 974 | 5231 | |
231609 | 231609 | Big River | Big River | 2022-06-27 | San Bernardino | 71 | 48 | 1264 | |
231610 | 231610 | Bloomington | Bloomington | 2022-06-27 | San Bernardino | 71 | 10717 | 17115 | |
231611 | 231611 | Blue Jay | Blue Jay | 2022-06-27 | San Bernardino | 71 | 352 | 900 | |
231612 | 231612 | Cedar Glen | Cedar Glen | 2022-06-27 | San Bernardino | 71 | 7 | 739 | |
231613 | 231613 | Chino | Chino | 2022-06-27 | San Bernardino | 71 | 27868 | 93099 | |
231614 | 231614 | Chino Hills | Chino Hills | 2022-06-27 | San Bernardino | 71 | 16030 | 82917 | |
231615 | 231615 | Colton | Colton | 2022-06-27 | San Bernardino | 71 | 18621 | 54636 | |
231616 | 231616 | Crestline | Crestline | 2022-06-27 | San Bernardino | 71 | 1553 | 8010 | |
231617 | 231617 | Daggett | Daggett | 2022-06-27 | San Bernardino | 71 | 57 | 549 | |
231618 | 231618 | Devore | Devore | 2022-06-27 | San Bernardino | 71 | 2 | 2283 | |
231619 | 231619 | Fawnskin | Fawnskin | 2022-06-27 | San Bernardino | 71 | 62 | 528 | |
231620 | 231620 | Fontana | Fontana | 2022-06-27 | San Bernardino | 71 | 74685 | 215334 | |
231621 | 231621 | Forest Falls | Forest Falls | 2022-06-27 | San Bernardino | 71 | 131 | 920 | |
231622 | 231622 | Grand Terrace | Grand Terrace | 2022-06-27 | San Bernardino | 71 | 3547 | 12403 | |
231623 | 231623 | Green Valley Lake | Green Valley Lake | 2022-06-27 | San Bernardino | 71 | 41 | 412 | |
231624 | 231624 | Havasu Lake | Havasu Lake | 2022-06-27 | San Bernardino | 71 | 95 | 0 | |
231625 | 231625 | Helendale | Helendale | 2022-06-27 | San Bernardino | 71 | 1175 | 6629 | |
231626 | 231626 | Hesperia | Hesperia | 2022-06-27 | San Bernardino | 71 | 26630 | 97312 | |
231627 | 231627 | Highland | Highland | 2022-06-27 | San Bernardino | 71 | 15712 | 55484 | |
231628 | 231628 | Hinkley | Hinkley | 2022-06-27 | San Bernardino | 71 | 127 | 1259 | |
231629 | 231629 | Joshua Tree | Joshua Tree | 2022-06-27 | San Bernardino | 71 | 1248 | 9887 | |
231630 | 231630 | Lake Arrowhead | Lake Arrowhead | 2022-06-27 | San Bernardino | 71 | 994 | 8104 | |
231631 | 231631 | Landers | Landers | 2022-06-27 | San Bernardino | 71 | 200 | 2983 | |
231632 | 231632 | Loma Linda | Loma Linda | 2022-06-27 | San Bernardino | 71 | 6255 | 25260 | |
231633 | 231633 | Lucerne Valley | Lucerne Valley | 2022-06-27 | San Bernardino | 71 | 821 | 7041 | |
231634 | 231634 | Lytle Creek | Lytle Creek | 2022-06-27 | San Bernardino | 71 | 150 | 837 | |
231635 | 231635 | Mentone | Mentone | 2022-06-27 | San Bernardino | 71 | 2385 | 9255 | |
231636 | 231636 | Montclair | Montclair | 2022-06-27 | San Bernardino | 71 | 12350 | 40415 | |
231637 | 231637 | Morongo Valley | Morongo Valley | 2022-06-27 | San Bernardino | 71 | 486 | 3739 | |
231638 | 231638 | Mt Baldy | Mt Baldy | 2022-06-27 | San Bernardino | 71 | 7 | 537 | |
231639 | 231639 | Muscoy | Muscoy | 2022-06-27 | San Bernardino | 71 | 237 | 11536 | |
231640 | 231640 | Needles | Needles | 2022-06-27 | San Bernardino | 71 | 727 | 4964 | |
231641 | 231641 | Newberry Springs | Newberry Springs | 2022-06-27 | San Bernardino | 71 | 259 | 2215 | |
231642 | 231642 | Oak Glen | Oak Glen | 2022-06-27 | San Bernardino | 71 | 33 | 625 | |
231643 | 231643 | Oak Hills | Oak Hills | 2022-06-27 | San Bernardino | 71 | 3009 | 9488 | |
231644 | 231644 | Ontario | Ontario | 2022-06-27 | San Bernardino | 71 | 51302 | 182380 | |
231645 | 231645 | Oro Grande | Oro Grande | 2022-06-27 | San Bernardino | 71 | 202 | 1137 | |
231646 | 231646 | Phelan | Phelan | 2022-06-27 | San Bernardino | 71 | 3398 | 14757 | |
231647 | 231647 | Pinon Hills | Pinon Hills | 2022-06-27 | San Bernardino | 71 | 991 | 8042 | |
231648 | 231648 | Pioneertown | Pioneertown | 2022-06-27 | San Bernardino | 71 | 44 | 365 | |
231649 | 231649 | Rancho Cucamonga | Rancho Cucamonga | 2022-06-27 | San Bernardino | 71 | 42442 | 177037 | |
231650 | 231650 | Redlands | Redlands | 2022-06-27 | San Bernardino | 71 | 19694 | 72099 | |
231651 | 231651 | Rialto | Rialto | 2022-06-27 | San Bernardino | 71 | 33615 | 103884 | |
231652 | 231652 | Rimforest | Rimforest | 2022-06-27 | San Bernardino | 71 | 98 | 756 | |
231653 | 231653 | Running Springs | Running Springs | 2022-06-27 | San Bernardino | 71 | 730 | 4661 | |
231654 | 231654 | San Bernardino | San Bernardino | 2022-06-27 | San Bernardino | 71 | 75644 | 218515 | |
231655 | 231655 | Sugarloaf | Sugarloaf | 2022-06-27 | San Bernardino | 71 | 304 | 3137 | |
231656 | 231656 | Trona | Trona | 2022-06-27 | San Bernardino | 71 | 94 | 1191 | |
231657 | 231657 | Twentynine Palms | Twentynine Palms | 2022-06-27 | San Bernardino | 71 | 3460 | 24966 | |
231658 | 231658 | Twin Peaks | Twin Peaks | 2022-06-27 | San Bernardino | 71 | 308 | 2493 | |
231659 | 231659 | Upland | Upland | 2022-06-27 | San Bernardino | 71 | 19022 | 78249 | |
231660 | 231660 | Victorville | Victorville | 2022-06-27 | San Bernardino | 71 | 42555 | 128353 | |
231661 | 231661 | Wrightwood | Wrightwood | 2022-06-27 | San Bernardino | 71 | 787 | 5177 | |
231662 | 231662 | Yermo | Yermo | 2022-06-27 | San Bernardino | 71 | 178 | 1672 | |
231663 | 231663 | Yucaipa | Yucaipa | 2022-06-27 | San Bernardino | 71 | 12898 | 54490 | |
231664 | 231664 | Yucca Valley | Yucca Valley | 2022-06-27 | San Bernardino | 71 | 4479 | 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 );