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" and "date" is on date 2020-09-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1037609 | 1037609 | Adelanto | Adelanto | 2020-09-27 | San Bernardino | 71 | 879 | 35234 | |
1037610 | 1037610 | Angelus Oaks | Angelus Oaks | 2020-09-27 | San Bernardino | 71 | 3 | 385 | |
1037611 | 1037611 | Apple Valley | Apple Valley | 2020-09-27 | San Bernardino | 71 | 1191 | 73694 | |
1037612 | 1037612 | Arrowbear | Arrowbear | 2020-09-27 | San Bernardino | 71 | 0 | 723 | |
1037613 | 1037613 | Baker | Baker | 2020-09-27 | San Bernardino | 71 | 14 | 799 | |
1037614 | 1037614 | Barstow | Barstow | 2020-09-27 | San Bernardino | 71 | 306 | 23754 | |
1037615 | 1037615 | Big Bear City | Big Bear City | 2020-09-27 | San Bernardino | 71 | 45 | 10045 | |
1037616 | 1037616 | Big Bear Lake | Big Bear Lake | 2020-09-27 | San Bernardino | 71 | 57 | 5231 | |
1037617 | 1037617 | Big River | Big River | 2020-09-27 | San Bernardino | 71 | 2 | 1264 | |
1037618 | 1037618 | Bloomington | Bloomington | 2020-09-27 | San Bernardino | 71 | 1174 | 17115 | |
1037619 | 1037619 | Blue Jay | Blue Jay | 2020-09-27 | San Bernardino | 71 | 12 | 900 | |
1037620 | 1037620 | Cedar Glen | Cedar Glen | 2020-09-27 | San Bernardino | 71 | 7 | 739 | |
1037621 | 1037621 | Chino | Chino | 2020-09-27 | San Bernardino | 71 | 3435 | 93099 | |
1037622 | 1037622 | Chino Hills | Chino Hills | 2020-09-27 | San Bernardino | 71 | 947 | 82917 | |
1037623 | 1037623 | Colton | Colton | 2020-09-27 | San Bernardino | 71 | 2116 | 54636 | |
1037624 | 1037624 | Crestline | Crestline | 2020-09-27 | San Bernardino | 71 | 76 | 8010 | |
1037625 | 1037625 | Daggett | Daggett | 2020-09-27 | San Bernardino | 71 | 1 | 549 | |
1037626 | 1037626 | Devore | Devore | 2020-09-27 | San Bernardino | 71 | 2 | 2283 | |
1037627 | 1037627 | Fawnskin | Fawnskin | 2020-09-27 | San Bernardino | 71 | 3 | 528 | |
1037628 | 1037628 | Fontana | Fontana | 2020-09-27 | San Bernardino | 71 | 7287 | 215334 | |
1037629 | 1037629 | Forest Falls | Forest Falls | 2020-09-27 | San Bernardino | 71 | 7 | 920 | |
1037630 | 1037630 | Grand Terrace | Grand Terrace | 2020-09-27 | San Bernardino | 71 | 322 | 12403 | |
1037631 | 1037631 | Green Valley Lake | Green Valley Lake | 2020-09-27 | San Bernardino | 71 | 1 | 412 | |
1037632 | 1037632 | Havasu Lake | Havasu Lake | 2020-09-27 | San Bernardino | 71 | 0 | 0 | |
1037633 | 1037633 | Helendale | Helendale | 2020-09-27 | San Bernardino | 71 | 68 | 6629 | |
1037634 | 1037634 | Hesperia | Hesperia | 2020-09-27 | San Bernardino | 71 | 2038 | 97312 | |
1037635 | 1037635 | Highland | Highland | 2020-09-27 | San Bernardino | 71 | 1501 | 55484 | |
1037636 | 1037636 | Hinkley | Hinkley | 2020-09-27 | San Bernardino | 71 | 7 | 1259 | |
1037637 | 1037637 | Joshua Tree | Joshua Tree | 2020-09-27 | San Bernardino | 71 | 96 | 9887 | |
1037638 | 1037638 | Lake Arrowhead | Lake Arrowhead | 2020-09-27 | San Bernardino | 71 | 32 | 8104 | |
1037639 | 1037639 | Landers | Landers | 2020-09-27 | San Bernardino | 71 | 10 | 2983 | |
1037640 | 1037640 | Loma Linda | Loma Linda | 2020-09-27 | San Bernardino | 71 | 556 | 25260 | |
1037641 | 1037641 | Lucerne Valley | Lucerne Valley | 2020-09-27 | San Bernardino | 71 | 31 | 7041 | |
1037642 | 1037642 | Lytle Creek | Lytle Creek | 2020-09-27 | San Bernardino | 71 | 16 | 837 | |
1037643 | 1037643 | Mentone | Mentone | 2020-09-27 | San Bernardino | 71 | 264 | 9255 | |
1037644 | 1037644 | Montclair | Montclair | 2020-09-27 | San Bernardino | 71 | 1271 | 40415 | |
1037645 | 1037645 | Morongo Valley | Morongo Valley | 2020-09-27 | San Bernardino | 71 | 43 | 3739 | |
1037646 | 1037646 | Mt Baldy | Mt Baldy | 2020-09-27 | San Bernardino | 71 | 1 | 537 | |
1037647 | 1037647 | Muscoy | Muscoy | 2020-09-27 | San Bernardino | 71 | 19 | 11536 | |
1037648 | 1037648 | Needles | Needles | 2020-09-27 | San Bernardino | 71 | 71 | 4964 | |
1037649 | 1037649 | Newberry Springs | Newberry Springs | 2020-09-27 | San Bernardino | 71 | 9 | 2215 | |
1037650 | 1037650 | Oak Glen | Oak Glen | 2020-09-27 | San Bernardino | 71 | 3 | 625 | |
1037651 | 1037651 | Oak Hills | Oak Hills | 2020-09-27 | San Bernardino | 71 | 188 | 9488 | |
1037652 | 1037652 | Ontario | Ontario | 2020-09-27 | San Bernardino | 71 | 5072 | 182380 | |
1037653 | 1037653 | Oro Grande | Oro Grande | 2020-09-27 | San Bernardino | 71 | 16 | 1137 | |
1037654 | 1037654 | Phelan | Phelan | 2020-09-27 | San Bernardino | 71 | 229 | 14757 | |
1037655 | 1037655 | Pinon Hills | Pinon Hills | 2020-09-27 | San Bernardino | 71 | 59 | 8042 | |
1037656 | 1037656 | Pioneertown | Pioneertown | 2020-09-27 | San Bernardino | 71 | 2 | 365 | |
1037657 | 1037657 | Rancho Cucamonga | Rancho Cucamonga | 2020-09-27 | San Bernardino | 71 | 2885 | 177037 | |
1037658 | 1037658 | Redlands | Redlands | 2020-09-27 | San Bernardino | 71 | 1858 | 72099 | |
1037659 | 1037659 | Rialto | Rialto | 2020-09-27 | San Bernardino | 71 | 3563 | 103884 | |
1037660 | 1037660 | Rimforest | Rimforest | 2020-09-27 | San Bernardino | 71 | 4 | 756 | |
1037661 | 1037661 | Running Springs | Running Springs | 2020-09-27 | San Bernardino | 71 | 27 | 4661 | |
1037662 | 1037662 | San Bernardino | San Bernardino | 2020-09-27 | San Bernardino | 71 | 8741 | 218515 | |
1037663 | 1037663 | Sugarloaf | Sugarloaf | 2020-09-27 | San Bernardino | 71 | 12 | 3137 | |
1037664 | 1037664 | Trona | Trona | 2020-09-27 | San Bernardino | 71 | 9 | 1191 | |
1037665 | 1037665 | Twentynine Palms | Twentynine Palms | 2020-09-27 | San Bernardino | 71 | 87 | 24966 | |
1037666 | 1037666 | Twin Peaks | Twin Peaks | 2020-09-27 | San Bernardino | 71 | 12 | 2493 | |
1037667 | 1037667 | Upland | Upland | 2020-09-27 | San Bernardino | 71 | 1422 | 78249 | |
1037668 | 1037668 | Victorville | Victorville | 2020-09-27 | San Bernardino | 71 | 3456 | 128353 | |
1037669 | 1037669 | Wrightwood | Wrightwood | 2020-09-27 | San Bernardino | 71 | 31 | 5177 | |
1037670 | 1037670 | Yermo | Yermo | 2020-09-27 | San Bernardino | 71 | 14 | 1672 | |
1037671 | 1037671 | Yucaipa | Yucaipa | 2020-09-27 | San Bernardino | 71 | 1024 | 54490 | |
1037672 | 1037672 | Yucca Valley | Yucca Valley | 2020-09-27 | San Bernardino | 71 | 241 | 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 );