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-09-30 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 |
---|---|---|---|---|---|---|---|---|---|
111616 | 111616 | Adelanto | Adelanto | 2022-09-30 | San Bernardino | 71 | 11237 | 35234 | |
111617 | 111617 | Angelus Oaks | Angelus Oaks | 2022-09-30 | San Bernardino | 71 | 98 | 385 | |
111618 | 111618 | Apple Valley | Apple Valley | 2022-09-30 | San Bernardino | 71 | 22514 | 73694 | |
111619 | 111619 | Arrowbear | Arrowbear | 2022-09-30 | San Bernardino | 71 | 11 | 723 | |
111620 | 111620 | Baker | Baker | 2022-09-30 | San Bernardino | 71 | 109 | 799 | |
111621 | 111621 | Barstow | Barstow | 2022-09-30 | San Bernardino | 71 | 7866 | 23754 | |
111622 | 111622 | Big Bear City | Big Bear City | 2022-09-30 | San Bernardino | 71 | 1577 | 10045 | |
111623 | 111623 | Big Bear Lake | Big Bear Lake | 2022-09-30 | San Bernardino | 71 | 1042 | 5231 | |
111624 | 111624 | Big River | Big River | 2022-09-30 | San Bernardino | 71 | 51 | 1264 | |
111625 | 111625 | Bloomington | Bloomington | 2022-09-30 | San Bernardino | 71 | 11887 | 17115 | |
111626 | 111626 | Blue Jay | Blue Jay | 2022-09-30 | San Bernardino | 71 | 382 | 900 | |
111627 | 111627 | Cedar Glen | Cedar Glen | 2022-09-30 | San Bernardino | 71 | 7 | 739 | |
111628 | 111628 | Chino | Chino | 2022-09-30 | San Bernardino | 71 | 31838 | 93099 | |
111629 | 111629 | Chino Hills | Chino Hills | 2022-09-30 | San Bernardino | 71 | 18407 | 82917 | |
111630 | 111630 | Colton | Colton | 2022-09-30 | San Bernardino | 71 | 20896 | 54636 | |
111631 | 111631 | Crestline | Crestline | 2022-09-30 | San Bernardino | 71 | 1718 | 8010 | |
111632 | 111632 | Daggett | Daggett | 2022-09-30 | San Bernardino | 71 | 67 | 549 | |
111633 | 111633 | Devore | Devore | 2022-09-30 | San Bernardino | 71 | 2 | 2283 | |
111634 | 111634 | Fawnskin | Fawnskin | 2022-09-30 | San Bernardino | 71 | 76 | 528 | |
111635 | 111635 | Fontana | Fontana | 2022-09-30 | San Bernardino | 71 | 83195 | 215334 | |
111636 | 111636 | Forest Falls | Forest Falls | 2022-09-30 | San Bernardino | 71 | 149 | 920 | |
111637 | 111637 | Grand Terrace | Grand Terrace | 2022-09-30 | San Bernardino | 71 | 3986 | 12403 | |
111638 | 111638 | Green Valley Lake | Green Valley Lake | 2022-09-30 | San Bernardino | 71 | 42 | 412 | |
111639 | 111639 | Havasu Lake | Havasu Lake | 2022-09-30 | San Bernardino | 71 | 106 | 0 | |
111640 | 111640 | Helendale | Helendale | 2022-09-30 | San Bernardino | 71 | 1273 | 6629 | |
111641 | 111641 | Hesperia | Hesperia | 2022-09-30 | San Bernardino | 71 | 29071 | 97312 | |
111642 | 111642 | Highland | Highland | 2022-09-30 | San Bernardino | 71 | 17571 | 55484 | |
111643 | 111643 | Hinkley | Hinkley | 2022-09-30 | San Bernardino | 71 | 134 | 1259 | |
111644 | 111644 | Joshua Tree | Joshua Tree | 2022-09-30 | San Bernardino | 71 | 1373 | 9887 | |
111645 | 111645 | Lake Arrowhead | Lake Arrowhead | 2022-09-30 | San Bernardino | 71 | 1083 | 8104 | |
111646 | 111646 | Landers | Landers | 2022-09-30 | San Bernardino | 71 | 215 | 2983 | |
111647 | 111647 | Loma Linda | Loma Linda | 2022-09-30 | San Bernardino | 71 | 7269 | 25260 | |
111648 | 111648 | Lucerne Valley | Lucerne Valley | 2022-09-30 | San Bernardino | 71 | 895 | 7041 | |
111649 | 111649 | Lytle Creek | Lytle Creek | 2022-09-30 | San Bernardino | 71 | 176 | 837 | |
111650 | 111650 | Mentone | Mentone | 2022-09-30 | San Bernardino | 71 | 2670 | 9255 | |
111651 | 111651 | Montclair | Montclair | 2022-09-30 | San Bernardino | 71 | 13729 | 40415 | |
111652 | 111652 | Morongo Valley | Morongo Valley | 2022-09-30 | San Bernardino | 71 | 528 | 3739 | |
111653 | 111653 | Mt Baldy | Mt Baldy | 2022-09-30 | San Bernardino | 71 | 7 | 537 | |
111654 | 111654 | Muscoy | Muscoy | 2022-09-30 | San Bernardino | 71 | 268 | 11536 | |
111655 | 111655 | Needles | Needles | 2022-09-30 | San Bernardino | 71 | 737 | 4964 | |
111656 | 111656 | Newberry Springs | Newberry Springs | 2022-09-30 | San Bernardino | 71 | 279 | 2215 | |
111657 | 111657 | Oak Glen | Oak Glen | 2022-09-30 | San Bernardino | 71 | 35 | 625 | |
111658 | 111658 | Oak Hills | Oak Hills | 2022-09-30 | San Bernardino | 71 | 3268 | 9488 | |
111659 | 111659 | Ontario | Ontario | 2022-09-30 | San Bernardino | 71 | 56999 | 182380 | |
111660 | 111660 | Oro Grande | Oro Grande | 2022-09-30 | San Bernardino | 71 | 213 | 1137 | |
111661 | 111661 | Phelan | Phelan | 2022-09-30 | San Bernardino | 71 | 3718 | 14757 | |
111662 | 111662 | Pinon Hills | Pinon Hills | 2022-09-30 | San Bernardino | 71 | 1075 | 8042 | |
111663 | 111663 | Pioneertown | Pioneertown | 2022-09-30 | San Bernardino | 71 | 53 | 365 | |
111664 | 111664 | Rancho Cucamonga | Rancho Cucamonga | 2022-09-30 | San Bernardino | 71 | 47411 | 177037 | |
111665 | 111665 | Redlands | Redlands | 2022-09-30 | San Bernardino | 71 | 22596 | 72099 | |
111666 | 111666 | Rialto | Rialto | 2022-09-30 | San Bernardino | 71 | 37662 | 103884 | |
111667 | 111667 | Rimforest | Rimforest | 2022-09-30 | San Bernardino | 71 | 107 | 756 | |
111668 | 111668 | Running Springs | Running Springs | 2022-09-30 | San Bernardino | 71 | 813 | 4661 | |
111669 | 111669 | San Bernardino | San Bernardino | 2022-09-30 | San Bernardino | 71 | 83957 | 218515 | |
111670 | 111670 | Sugarloaf | Sugarloaf | 2022-09-30 | San Bernardino | 71 | 340 | 3137 | |
111671 | 111671 | Trona | Trona | 2022-09-30 | San Bernardino | 71 | 120 | 1191 | |
111672 | 111672 | Twentynine Palms | Twentynine Palms | 2022-09-30 | San Bernardino | 71 | 3702 | 24966 | |
111673 | 111673 | Twin Peaks | Twin Peaks | 2022-09-30 | San Bernardino | 71 | 319 | 2493 | |
111674 | 111674 | Upland | Upland | 2022-09-30 | San Bernardino | 71 | 21403 | 78249 | |
111675 | 111675 | Victorville | Victorville | 2022-09-30 | San Bernardino | 71 | 46648 | 128353 | |
111676 | 111676 | Wrightwood | Wrightwood | 2022-09-30 | San Bernardino | 71 | 844 | 5177 | |
111677 | 111677 | Yermo | Yermo | 2022-09-30 | San Bernardino | 71 | 201 | 1672 | |
111678 | 111678 | Yucaipa | Yucaipa | 2022-09-30 | San Bernardino | 71 | 14394 | 54490 | |
111679 | 111679 | Yucca Valley | Yucca Valley | 2022-09-30 | San Bernardino | 71 | 4828 | 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 );