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-08-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 |
---|---|---|---|---|---|---|---|---|---|
631986 | 631986 | Adelanto | Adelanto | 2021-08-16 | San Bernardino | 71 | 5836 | 35234 | |
631987 | 631987 | Angelus Oaks | Angelus Oaks | 2021-08-16 | San Bernardino | 71 | 43 | 385 | |
631988 | 631988 | Apple Valley | Apple Valley | 2021-08-16 | San Bernardino | 71 | 10235 | 73694 | |
631989 | 631989 | Arrowbear | Arrowbear | 2021-08-16 | San Bernardino | 71 | 5 | 723 | |
631990 | 631990 | Baker | Baker | 2021-08-16 | San Bernardino | 71 | 57 | 799 | |
631991 | 631991 | Barstow | Barstow | 2021-08-16 | San Bernardino | 71 | 3679 | 23754 | |
631992 | 631992 | Big Bear City | Big Bear City | 2021-08-16 | San Bernardino | 71 | 744 | 10045 | |
631993 | 631993 | Big Bear Lake | Big Bear Lake | 2021-08-16 | San Bernardino | 71 | 478 | 5231 | |
631994 | 631994 | Big River | Big River | 2021-08-16 | San Bernardino | 71 | 21 | 1264 | |
631995 | 631995 | Bloomington | Bloomington | 2021-08-16 | San Bernardino | 71 | 6375 | 17115 | |
631996 | 631996 | Blue Jay | Blue Jay | 2021-08-16 | San Bernardino | 71 | 176 | 900 | |
631997 | 631997 | Cedar Glen | Cedar Glen | 2021-08-16 | San Bernardino | 71 | 7 | 739 | |
631998 | 631998 | Chino | Chino | 2021-08-16 | San Bernardino | 71 | 14262 | 93099 | |
631999 | 631999 | Chino Hills | Chino Hills | 2021-08-16 | San Bernardino | 71 | 6547 | 82917 | |
632000 | 632000 | Colton | Colton | 2021-08-16 | San Bernardino | 71 | 10780 | 54636 | |
632001 | 632001 | Crestline | Crestline | 2021-08-16 | San Bernardino | 71 | 705 | 8010 | |
632002 | 632002 | Daggett | Daggett | 2021-08-16 | San Bernardino | 71 | 19 | 549 | |
632003 | 632003 | Devore | Devore | 2021-08-16 | San Bernardino | 71 | 2 | 2283 | |
632004 | 632004 | Fawnskin | Fawnskin | 2021-08-16 | San Bernardino | 71 | 26 | 528 | |
632005 | 632005 | Fontana | Fontana | 2021-08-16 | San Bernardino | 71 | 42269 | 215334 | |
632006 | 632006 | Forest Falls | Forest Falls | 2021-08-16 | San Bernardino | 71 | 43 | 920 | |
632007 | 632007 | Grand Terrace | Grand Terrace | 2021-08-16 | San Bernardino | 71 | 1767 | 12403 | |
632008 | 632008 | Green Valley Lake | Green Valley Lake | 2021-08-16 | San Bernardino | 71 | 16 | 412 | |
632009 | 632009 | Havasu Lake | Havasu Lake | 2021-08-16 | San Bernardino | 71 | 0 | 0 | |
632010 | 632010 | Helendale | Helendale | 2021-08-16 | San Bernardino | 71 | 564 | 6629 | |
632011 | 632011 | Hesperia | Hesperia | 2021-08-16 | San Bernardino | 71 | 14942 | 97312 | |
632012 | 632012 | Highland | Highland | 2021-08-16 | San Bernardino | 71 | 8656 | 55484 | |
632013 | 632013 | Hinkley | Hinkley | 2021-08-16 | San Bernardino | 71 | 63 | 1259 | |
632014 | 632014 | Joshua Tree | Joshua Tree | 2021-08-16 | San Bernardino | 71 | 419 | 9887 | |
632015 | 632015 | Lake Arrowhead | Lake Arrowhead | 2021-08-16 | San Bernardino | 71 | 513 | 8104 | |
632016 | 632016 | Landers | Landers | 2021-08-16 | San Bernardino | 71 | 62 | 2983 | |
632017 | 632017 | Loma Linda | Loma Linda | 2021-08-16 | San Bernardino | 71 | 2857 | 25260 | |
632018 | 632018 | Lucerne Valley | Lucerne Valley | 2021-08-16 | San Bernardino | 71 | 406 | 7041 | |
632019 | 632019 | Lytle Creek | Lytle Creek | 2021-08-16 | San Bernardino | 71 | 78 | 837 | |
632020 | 632020 | Mentone | Mentone | 2021-08-16 | San Bernardino | 71 | 1191 | 9255 | |
632021 | 632021 | Montclair | Montclair | 2021-08-16 | San Bernardino | 71 | 6531 | 40415 | |
632022 | 632022 | Morongo Valley | Morongo Valley | 2021-08-16 | San Bernardino | 71 | 197 | 3739 | |
632023 | 632023 | Mt Baldy | Mt Baldy | 2021-08-16 | San Bernardino | 71 | 2 | 537 | |
632024 | 632024 | Muscoy | Muscoy | 2021-08-16 | San Bernardino | 71 | 117 | 11536 | |
632025 | 632025 | Needles | Needles | 2021-08-16 | San Bernardino | 71 | 423 | 4964 | |
632026 | 632026 | Newberry Springs | Newberry Springs | 2021-08-16 | San Bernardino | 71 | 145 | 2215 | |
632027 | 632027 | Oak Glen | Oak Glen | 2021-08-16 | San Bernardino | 71 | 16 | 625 | |
632028 | 632028 | Oak Hills | Oak Hills | 2021-08-16 | San Bernardino | 71 | 1694 | 9488 | |
632029 | 632029 | Ontario | Ontario | 2021-08-16 | San Bernardino | 71 | 27922 | 182380 | |
632030 | 632030 | Oro Grande | Oro Grande | 2021-08-16 | San Bernardino | 71 | 139 | 1137 | |
632031 | 632031 | Phelan | Phelan | 2021-08-16 | San Bernardino | 71 | 1798 | 14757 | |
632032 | 632032 | Pinon Hills | Pinon Hills | 2021-08-16 | San Bernardino | 71 | 468 | 8042 | |
632033 | 632033 | Pioneertown | Pioneertown | 2021-08-16 | San Bernardino | 71 | 10 | 365 | |
632034 | 632034 | Rancho Cucamonga | Rancho Cucamonga | 2021-08-16 | San Bernardino | 71 | 20292 | 177037 | |
632035 | 632035 | Redlands | Redlands | 2021-08-16 | San Bernardino | 71 | 9511 | 72099 | |
632036 | 632036 | Rialto | Rialto | 2021-08-16 | San Bernardino | 71 | 19703 | 103884 | |
632037 | 632037 | Rimforest | Rimforest | 2021-08-16 | San Bernardino | 71 | 49 | 756 | |
632038 | 632038 | Running Springs | Running Springs | 2021-08-16 | San Bernardino | 71 | 337 | 4661 | |
632039 | 632039 | San Bernardino | San Bernardino | 2021-08-16 | San Bernardino | 71 | 43023 | 218515 | |
632040 | 632040 | Sugarloaf | Sugarloaf | 2021-08-16 | San Bernardino | 71 | 122 | 3137 | |
632041 | 632041 | Trona | Trona | 2021-08-16 | San Bernardino | 71 | 49 | 1191 | |
632042 | 632042 | Twentynine Palms | Twentynine Palms | 2021-08-16 | San Bernardino | 71 | 1357 | 24966 | |
632043 | 632043 | Twin Peaks | Twin Peaks | 2021-08-16 | San Bernardino | 71 | 143 | 2493 | |
632044 | 632044 | Upland | Upland | 2021-08-16 | San Bernardino | 71 | 9316 | 78249 | |
632045 | 632045 | Victorville | Victorville | 2021-08-16 | San Bernardino | 71 | 22971 | 128353 | |
632046 | 632046 | Wrightwood | Wrightwood | 2021-08-16 | San Bernardino | 71 | 356 | 5177 | |
632047 | 632047 | Yermo | Yermo | 2021-08-16 | San Bernardino | 71 | 85 | 1672 | |
632048 | 632048 | Yucaipa | Yucaipa | 2021-08-16 | San Bernardino | 71 | 6161 | 54490 | |
632049 | 632049 | Yucca Valley | Yucca Valley | 2021-08-16 | San Bernardino | 71 | 1729 | 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 );