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-12 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 |
---|---|---|---|---|---|---|---|---|---|
676646 | 676646 | Adelanto | Adelanto | 2021-07-12 | San Bernardino | 71 | 5585 | 35234 | |
676647 | 676647 | Angelus Oaks | Angelus Oaks | 2021-07-12 | San Bernardino | 71 | 41 | 385 | |
676648 | 676648 | Apple Valley | Apple Valley | 2021-07-12 | San Bernardino | 71 | 9669 | 73694 | |
676649 | 676649 | Arrowbear | Arrowbear | 2021-07-12 | San Bernardino | 71 | 5 | 723 | |
676650 | 676650 | Baker | Baker | 2021-07-12 | San Bernardino | 71 | 57 | 799 | |
676651 | 676651 | Barstow | Barstow | 2021-07-12 | San Bernardino | 71 | 3525 | 23754 | |
676652 | 676652 | Big Bear City | Big Bear City | 2021-07-12 | San Bernardino | 71 | 579 | 10045 | |
676653 | 676653 | Big Bear Lake | Big Bear Lake | 2021-07-12 | San Bernardino | 71 | 406 | 5231 | |
676654 | 676654 | Big River | Big River | 2021-07-12 | San Bernardino | 71 | 20 | 1264 | |
676655 | 676655 | Bloomington | Bloomington | 2021-07-12 | San Bernardino | 71 | 6096 | 17115 | |
676656 | 676656 | Blue Jay | Blue Jay | 2021-07-12 | San Bernardino | 71 | 161 | 900 | |
676657 | 676657 | Cedar Glen | Cedar Glen | 2021-07-12 | San Bernardino | 71 | 7 | 739 | |
676658 | 676658 | Chino | Chino | 2021-07-12 | San Bernardino | 71 | 13460 | 93099 | |
676659 | 676659 | Chino Hills | Chino Hills | 2021-07-12 | San Bernardino | 71 | 6009 | 82917 | |
676660 | 676660 | Colton | Colton | 2021-07-12 | San Bernardino | 71 | 10357 | 54636 | |
676661 | 676661 | Crestline | Crestline | 2021-07-12 | San Bernardino | 71 | 653 | 8010 | |
676662 | 676662 | Daggett | Daggett | 2021-07-12 | San Bernardino | 71 | 19 | 549 | |
676663 | 676663 | Devore | Devore | 2021-07-12 | San Bernardino | 71 | 2 | 2283 | |
676664 | 676664 | Fawnskin | Fawnskin | 2021-07-12 | San Bernardino | 71 | 22 | 528 | |
676665 | 676665 | Fontana | Fontana | 2021-07-12 | San Bernardino | 71 | 40306 | 215334 | |
676666 | 676666 | Forest Falls | Forest Falls | 2021-07-12 | San Bernardino | 71 | 39 | 920 | |
676667 | 676667 | Grand Terrace | Grand Terrace | 2021-07-12 | San Bernardino | 71 | 1661 | 12403 | |
676668 | 676668 | Green Valley Lake | Green Valley Lake | 2021-07-12 | San Bernardino | 71 | 13 | 412 | |
676669 | 676669 | Havasu Lake | Havasu Lake | 2021-07-12 | San Bernardino | 71 | 0 | 0 | |
676670 | 676670 | Helendale | Helendale | 2021-07-12 | San Bernardino | 71 | 529 | 6629 | |
676671 | 676671 | Hesperia | Hesperia | 2021-07-12 | San Bernardino | 71 | 14277 | 97312 | |
676672 | 676672 | Highland | Highland | 2021-07-12 | San Bernardino | 71 | 8243 | 55484 | |
676673 | 676673 | Hinkley | Hinkley | 2021-07-12 | San Bernardino | 71 | 60 | 1259 | |
676674 | 676674 | Joshua Tree | Joshua Tree | 2021-07-12 | San Bernardino | 71 | 366 | 9887 | |
676675 | 676675 | Lake Arrowhead | Lake Arrowhead | 2021-07-12 | San Bernardino | 71 | 475 | 8104 | |
676676 | 676676 | Landers | Landers | 2021-07-12 | San Bernardino | 71 | 59 | 2983 | |
676677 | 676677 | Loma Linda | Loma Linda | 2021-07-12 | San Bernardino | 71 | 2710 | 25260 | |
676678 | 676678 | Lucerne Valley | Lucerne Valley | 2021-07-12 | San Bernardino | 71 | 363 | 7041 | |
676679 | 676679 | Lytle Creek | Lytle Creek | 2021-07-12 | San Bernardino | 71 | 73 | 837 | |
676680 | 676680 | Mentone | Mentone | 2021-07-12 | San Bernardino | 71 | 1108 | 9255 | |
676681 | 676681 | Montclair | Montclair | 2021-07-12 | San Bernardino | 71 | 6286 | 40415 | |
676682 | 676682 | Morongo Valley | Morongo Valley | 2021-07-12 | San Bernardino | 71 | 182 | 3739 | |
676683 | 676683 | Mt Baldy | Mt Baldy | 2021-07-12 | San Bernardino | 71 | 2 | 537 | |
676684 | 676684 | Muscoy | Muscoy | 2021-07-12 | San Bernardino | 71 | 114 | 11536 | |
676685 | 676685 | Needles | Needles | 2021-07-12 | San Bernardino | 71 | 402 | 4964 | |
676686 | 676686 | Newberry Springs | Newberry Springs | 2021-07-12 | San Bernardino | 71 | 139 | 2215 | |
676687 | 676687 | Oak Glen | Oak Glen | 2021-07-12 | San Bernardino | 71 | 15 | 625 | |
676688 | 676688 | Oak Hills | Oak Hills | 2021-07-12 | San Bernardino | 71 | 1607 | 9488 | |
676689 | 676689 | Ontario | Ontario | 2021-07-12 | San Bernardino | 71 | 26619 | 182380 | |
676690 | 676690 | Oro Grande | Oro Grande | 2021-07-12 | San Bernardino | 71 | 132 | 1137 | |
676691 | 676691 | Phelan | Phelan | 2021-07-12 | San Bernardino | 71 | 1689 | 14757 | |
676692 | 676692 | Pinon Hills | Pinon Hills | 2021-07-12 | San Bernardino | 71 | 438 | 8042 | |
676693 | 676693 | Pioneertown | Pioneertown | 2021-07-12 | San Bernardino | 71 | 8 | 365 | |
676694 | 676694 | Rancho Cucamonga | Rancho Cucamonga | 2021-07-12 | San Bernardino | 71 | 18755 | 177037 | |
676695 | 676695 | Redlands | Redlands | 2021-07-12 | San Bernardino | 71 | 8933 | 72099 | |
676696 | 676696 | Rialto | Rialto | 2021-07-12 | San Bernardino | 71 | 18909 | 103884 | |
676697 | 676697 | Rimforest | Rimforest | 2021-07-12 | San Bernardino | 71 | 45 | 756 | |
676698 | 676698 | Running Springs | Running Springs | 2021-07-12 | San Bernardino | 71 | 295 | 4661 | |
676699 | 676699 | San Bernardino | San Bernardino | 2021-07-12 | San Bernardino | 71 | 41260 | 218515 | |
676700 | 676700 | Sugarloaf | Sugarloaf | 2021-07-12 | San Bernardino | 71 | 94 | 3137 | |
676701 | 676701 | Trona | Trona | 2021-07-12 | San Bernardino | 71 | 47 | 1191 | |
676702 | 676702 | Twentynine Palms | Twentynine Palms | 2021-07-12 | San Bernardino | 71 | 1150 | 24966 | |
676703 | 676703 | Twin Peaks | Twin Peaks | 2021-07-12 | San Bernardino | 71 | 137 | 2493 | |
676704 | 676704 | Upland | Upland | 2021-07-12 | San Bernardino | 71 | 8751 | 78249 | |
676705 | 676705 | Victorville | Victorville | 2021-07-12 | San Bernardino | 71 | 21808 | 128353 | |
676706 | 676706 | Wrightwood | Wrightwood | 2021-07-12 | San Bernardino | 71 | 339 | 5177 | |
676707 | 676707 | Yermo | Yermo | 2021-07-12 | San Bernardino | 71 | 84 | 1672 | |
676708 | 676708 | Yucaipa | Yucaipa | 2021-07-12 | San Bernardino | 71 | 5801 | 54490 | |
676709 | 676709 | Yucca Valley | Yucca Valley | 2021-07-12 | San Bernardino | 71 | 1565 | 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 );