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-16 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 |
---|---|---|---|---|---|---|---|---|---|
671542 | 671542 | Adelanto | Adelanto | 2021-07-16 | San Bernardino | 71 | 5605 | 35234 | |
671543 | 671543 | Angelus Oaks | Angelus Oaks | 2021-07-16 | San Bernardino | 71 | 41 | 385 | |
671544 | 671544 | Apple Valley | Apple Valley | 2021-07-16 | San Bernardino | 71 | 9706 | 73694 | |
671545 | 671545 | Arrowbear | Arrowbear | 2021-07-16 | San Bernardino | 71 | 5 | 723 | |
671546 | 671546 | Baker | Baker | 2021-07-16 | San Bernardino | 71 | 57 | 799 | |
671547 | 671547 | Barstow | Barstow | 2021-07-16 | San Bernardino | 71 | 3538 | 23754 | |
671548 | 671548 | Big Bear City | Big Bear City | 2021-07-16 | San Bernardino | 71 | 584 | 10045 | |
671549 | 671549 | Big Bear Lake | Big Bear Lake | 2021-07-16 | San Bernardino | 71 | 408 | 5231 | |
671550 | 671550 | Big River | Big River | 2021-07-16 | San Bernardino | 71 | 20 | 1264 | |
671551 | 671551 | Bloomington | Bloomington | 2021-07-16 | San Bernardino | 71 | 6105 | 17115 | |
671552 | 671552 | Blue Jay | Blue Jay | 2021-07-16 | San Bernardino | 71 | 162 | 900 | |
671553 | 671553 | Cedar Glen | Cedar Glen | 2021-07-16 | San Bernardino | 71 | 7 | 739 | |
671554 | 671554 | Chino | Chino | 2021-07-16 | San Bernardino | 71 | 13541 | 93099 | |
671555 | 671555 | Chino Hills | Chino Hills | 2021-07-16 | San Bernardino | 71 | 6049 | 82917 | |
671556 | 671556 | Colton | Colton | 2021-07-16 | San Bernardino | 71 | 10378 | 54636 | |
671557 | 671557 | Crestline | Crestline | 2021-07-16 | San Bernardino | 71 | 657 | 8010 | |
671558 | 671558 | Daggett | Daggett | 2021-07-16 | San Bernardino | 71 | 19 | 549 | |
671559 | 671559 | Devore | Devore | 2021-07-16 | San Bernardino | 71 | 2 | 2283 | |
671560 | 671560 | Fawnskin | Fawnskin | 2021-07-16 | San Bernardino | 71 | 21 | 528 | |
671561 | 671561 | Fontana | Fontana | 2021-07-16 | San Bernardino | 71 | 40477 | 215334 | |
671562 | 671562 | Forest Falls | Forest Falls | 2021-07-16 | San Bernardino | 71 | 39 | 920 | |
671563 | 671563 | Grand Terrace | Grand Terrace | 2021-07-16 | San Bernardino | 71 | 1664 | 12403 | |
671564 | 671564 | Green Valley Lake | Green Valley Lake | 2021-07-16 | San Bernardino | 71 | 14 | 412 | |
671565 | 671565 | Havasu Lake | Havasu Lake | 2021-07-16 | San Bernardino | 71 | 0 | 0 | |
671566 | 671566 | Helendale | Helendale | 2021-07-16 | San Bernardino | 71 | 532 | 6629 | |
671567 | 671567 | Hesperia | Hesperia | 2021-07-16 | San Bernardino | 71 | 14326 | 97312 | |
671568 | 671568 | Highland | Highland | 2021-07-16 | San Bernardino | 71 | 8276 | 55484 | |
671569 | 671569 | Hinkley | Hinkley | 2021-07-16 | San Bernardino | 71 | 61 | 1259 | |
671570 | 671570 | Joshua Tree | Joshua Tree | 2021-07-16 | San Bernardino | 71 | 373 | 9887 | |
671571 | 671571 | Lake Arrowhead | Lake Arrowhead | 2021-07-16 | San Bernardino | 71 | 479 | 8104 | |
671572 | 671572 | Landers | Landers | 2021-07-16 | San Bernardino | 71 | 59 | 2983 | |
671573 | 671573 | Loma Linda | Loma Linda | 2021-07-16 | San Bernardino | 71 | 2714 | 25260 | |
671574 | 671574 | Lucerne Valley | Lucerne Valley | 2021-07-16 | San Bernardino | 71 | 365 | 7041 | |
671575 | 671575 | Lytle Creek | Lytle Creek | 2021-07-16 | San Bernardino | 71 | 73 | 837 | |
671576 | 671576 | Mentone | Mentone | 2021-07-16 | San Bernardino | 71 | 1112 | 9255 | |
671577 | 671577 | Montclair | Montclair | 2021-07-16 | San Bernardino | 71 | 6305 | 40415 | |
671578 | 671578 | Morongo Valley | Morongo Valley | 2021-07-16 | San Bernardino | 71 | 185 | 3739 | |
671579 | 671579 | Mt Baldy | Mt Baldy | 2021-07-16 | San Bernardino | 71 | 2 | 537 | |
671580 | 671580 | Muscoy | Muscoy | 2021-07-16 | San Bernardino | 71 | 114 | 11536 | |
671581 | 671581 | Needles | Needles | 2021-07-16 | San Bernardino | 71 | 404 | 4964 | |
671582 | 671582 | Newberry Springs | Newberry Springs | 2021-07-16 | San Bernardino | 71 | 140 | 2215 | |
671583 | 671583 | Oak Glen | Oak Glen | 2021-07-16 | San Bernardino | 71 | 16 | 625 | |
671584 | 671584 | Oak Hills | Oak Hills | 2021-07-16 | San Bernardino | 71 | 1615 | 9488 | |
671585 | 671585 | Ontario | Ontario | 2021-07-16 | San Bernardino | 71 | 26727 | 182380 | |
671586 | 671586 | Oro Grande | Oro Grande | 2021-07-16 | San Bernardino | 71 | 132 | 1137 | |
671587 | 671587 | Phelan | Phelan | 2021-07-16 | San Bernardino | 71 | 1695 | 14757 | |
671588 | 671588 | Pinon Hills | Pinon Hills | 2021-07-16 | San Bernardino | 71 | 442 | 8042 | |
671589 | 671589 | Pioneertown | Pioneertown | 2021-07-16 | San Bernardino | 71 | 8 | 365 | |
671590 | 671590 | Rancho Cucamonga | Rancho Cucamonga | 2021-07-16 | San Bernardino | 71 | 18887 | 177037 | |
671591 | 671591 | Redlands | Redlands | 2021-07-16 | San Bernardino | 71 | 8978 | 72099 | |
671592 | 671592 | Rialto | Rialto | 2021-07-16 | San Bernardino | 71 | 18960 | 103884 | |
671593 | 671593 | Rimforest | Rimforest | 2021-07-16 | San Bernardino | 71 | 46 | 756 | |
671594 | 671594 | Running Springs | Running Springs | 2021-07-16 | San Bernardino | 71 | 300 | 4661 | |
671595 | 671595 | San Bernardino | San Bernardino | 2021-07-16 | San Bernardino | 71 | 41379 | 218515 | |
671596 | 671596 | Sugarloaf | Sugarloaf | 2021-07-16 | San Bernardino | 71 | 94 | 3137 | |
671597 | 671597 | Trona | Trona | 2021-07-16 | San Bernardino | 71 | 47 | 1191 | |
671598 | 671598 | Twentynine Palms | Twentynine Palms | 2021-07-16 | San Bernardino | 71 | 1160 | 24966 | |
671599 | 671599 | Twin Peaks | Twin Peaks | 2021-07-16 | San Bernardino | 71 | 137 | 2493 | |
671600 | 671600 | Upland | Upland | 2021-07-16 | San Bernardino | 71 | 8807 | 78249 | |
671601 | 671601 | Victorville | Victorville | 2021-07-16 | San Bernardino | 71 | 21906 | 128353 | |
671602 | 671602 | Wrightwood | Wrightwood | 2021-07-16 | San Bernardino | 71 | 339 | 5177 | |
671603 | 671603 | Yermo | Yermo | 2021-07-16 | San Bernardino | 71 | 84 | 1672 | |
671604 | 671604 | Yucaipa | Yucaipa | 2021-07-16 | San Bernardino | 71 | 5829 | 54490 | |
671605 | 671605 | Yucca Valley | Yucca Valley | 2021-07-16 | San Bernardino | 71 | 1583 | 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 );