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-19 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 |
---|---|---|---|---|---|---|---|---|---|
628158 | 628158 | Adelanto | Adelanto | 2021-08-19 | San Bernardino | 71 | 5869 | 35234 | |
628159 | 628159 | Angelus Oaks | Angelus Oaks | 2021-08-19 | San Bernardino | 71 | 43 | 385 | |
628160 | 628160 | Apple Valley | Apple Valley | 2021-08-19 | San Bernardino | 71 | 10295 | 73694 | |
628161 | 628161 | Arrowbear | Arrowbear | 2021-08-19 | San Bernardino | 71 | 5 | 723 | |
628162 | 628162 | Baker | Baker | 2021-08-19 | San Bernardino | 71 | 57 | 799 | |
628163 | 628163 | Barstow | Barstow | 2021-08-19 | San Bernardino | 71 | 3696 | 23754 | |
628164 | 628164 | Big Bear City | Big Bear City | 2021-08-19 | San Bernardino | 71 | 759 | 10045 | |
628165 | 628165 | Big Bear Lake | Big Bear Lake | 2021-08-19 | San Bernardino | 71 | 483 | 5231 | |
628166 | 628166 | Big River | Big River | 2021-08-19 | San Bernardino | 71 | 21 | 1264 | |
628167 | 628167 | Bloomington | Bloomington | 2021-08-19 | San Bernardino | 71 | 6410 | 17115 | |
628168 | 628168 | Blue Jay | Blue Jay | 2021-08-19 | San Bernardino | 71 | 177 | 900 | |
628169 | 628169 | Cedar Glen | Cedar Glen | 2021-08-19 | San Bernardino | 71 | 7 | 739 | |
628170 | 628170 | Chino | Chino | 2021-08-19 | San Bernardino | 71 | 14349 | 93099 | |
628171 | 628171 | Chino Hills | Chino Hills | 2021-08-19 | San Bernardino | 71 | 6591 | 82917 | |
628172 | 628172 | Colton | Colton | 2021-08-19 | San Bernardino | 71 | 10843 | 54636 | |
628173 | 628173 | Crestline | Crestline | 2021-08-19 | San Bernardino | 71 | 710 | 8010 | |
628174 | 628174 | Daggett | Daggett | 2021-08-19 | San Bernardino | 71 | 19 | 549 | |
628175 | 628175 | Devore | Devore | 2021-08-19 | San Bernardino | 71 | 2 | 2283 | |
628176 | 628176 | Fawnskin | Fawnskin | 2021-08-19 | San Bernardino | 71 | 27 | 528 | |
628177 | 628177 | Fontana | Fontana | 2021-08-19 | San Bernardino | 71 | 42479 | 215334 | |
628178 | 628178 | Forest Falls | Forest Falls | 2021-08-19 | San Bernardino | 71 | 43 | 920 | |
628179 | 628179 | Grand Terrace | Grand Terrace | 2021-08-19 | San Bernardino | 71 | 1775 | 12403 | |
628180 | 628180 | Green Valley Lake | Green Valley Lake | 2021-08-19 | San Bernardino | 71 | 16 | 412 | |
628181 | 628181 | Havasu Lake | Havasu Lake | 2021-08-19 | San Bernardino | 71 | 0 | 0 | |
628182 | 628182 | Helendale | Helendale | 2021-08-19 | San Bernardino | 71 | 568 | 6629 | |
628183 | 628183 | Hesperia | Hesperia | 2021-08-19 | San Bernardino | 71 | 15015 | 97312 | |
628184 | 628184 | Highland | Highland | 2021-08-19 | San Bernardino | 71 | 8696 | 55484 | |
628185 | 628185 | Hinkley | Hinkley | 2021-08-19 | San Bernardino | 71 | 64 | 1259 | |
628186 | 628186 | Joshua Tree | Joshua Tree | 2021-08-19 | San Bernardino | 71 | 425 | 9887 | |
628187 | 628187 | Lake Arrowhead | Lake Arrowhead | 2021-08-19 | San Bernardino | 71 | 515 | 8104 | |
628188 | 628188 | Landers | Landers | 2021-08-19 | San Bernardino | 71 | 62 | 2983 | |
628189 | 628189 | Loma Linda | Loma Linda | 2021-08-19 | San Bernardino | 71 | 2866 | 25260 | |
628190 | 628190 | Lucerne Valley | Lucerne Valley | 2021-08-19 | San Bernardino | 71 | 406 | 7041 | |
628191 | 628191 | Lytle Creek | Lytle Creek | 2021-08-19 | San Bernardino | 71 | 78 | 837 | |
628192 | 628192 | Mentone | Mentone | 2021-08-19 | San Bernardino | 71 | 1195 | 9255 | |
628193 | 628193 | Montclair | Montclair | 2021-08-19 | San Bernardino | 71 | 6552 | 40415 | |
628194 | 628194 | Morongo Valley | Morongo Valley | 2021-08-19 | San Bernardino | 71 | 198 | 3739 | |
628195 | 628195 | Mt Baldy | Mt Baldy | 2021-08-19 | San Bernardino | 71 | 2 | 537 | |
628196 | 628196 | Muscoy | Muscoy | 2021-08-19 | San Bernardino | 71 | 117 | 11536 | |
628197 | 628197 | Needles | Needles | 2021-08-19 | San Bernardino | 71 | 424 | 4964 | |
628198 | 628198 | Newberry Springs | Newberry Springs | 2021-08-19 | San Bernardino | 71 | 146 | 2215 | |
628199 | 628199 | Oak Glen | Oak Glen | 2021-08-19 | San Bernardino | 71 | 16 | 625 | |
628200 | 628200 | Oak Hills | Oak Hills | 2021-08-19 | San Bernardino | 71 | 1705 | 9488 | |
628201 | 628201 | Ontario | Ontario | 2021-08-19 | San Bernardino | 71 | 28032 | 182380 | |
628202 | 628202 | Oro Grande | Oro Grande | 2021-08-19 | San Bernardino | 71 | 141 | 1137 | |
628203 | 628203 | Phelan | Phelan | 2021-08-19 | San Bernardino | 71 | 1809 | 14757 | |
628204 | 628204 | Pinon Hills | Pinon Hills | 2021-08-19 | San Bernardino | 71 | 472 | 8042 | |
628205 | 628205 | Pioneertown | Pioneertown | 2021-08-19 | San Bernardino | 71 | 10 | 365 | |
628206 | 628206 | Rancho Cucamonga | Rancho Cucamonga | 2021-08-19 | San Bernardino | 71 | 20437 | 177037 | |
628207 | 628207 | Redlands | Redlands | 2021-08-19 | San Bernardino | 71 | 9577 | 72099 | |
628208 | 628208 | Rialto | Rialto | 2021-08-19 | San Bernardino | 71 | 19780 | 103884 | |
628209 | 628209 | Rimforest | Rimforest | 2021-08-19 | San Bernardino | 71 | 49 | 756 | |
628210 | 628210 | Running Springs | Running Springs | 2021-08-19 | San Bernardino | 71 | 340 | 4661 | |
628211 | 628211 | San Bernardino | San Bernardino | 2021-08-19 | San Bernardino | 71 | 43191 | 218515 | |
628212 | 628212 | Sugarloaf | Sugarloaf | 2021-08-19 | San Bernardino | 71 | 123 | 3137 | |
628213 | 628213 | Trona | Trona | 2021-08-19 | San Bernardino | 71 | 49 | 1191 | |
628214 | 628214 | Twentynine Palms | Twentynine Palms | 2021-08-19 | San Bernardino | 71 | 1382 | 24966 | |
628215 | 628215 | Twin Peaks | Twin Peaks | 2021-08-19 | San Bernardino | 71 | 144 | 2493 | |
628216 | 628216 | Upland | Upland | 2021-08-19 | San Bernardino | 71 | 9383 | 78249 | |
628217 | 628217 | Victorville | Victorville | 2021-08-19 | San Bernardino | 71 | 23112 | 128353 | |
628218 | 628218 | Wrightwood | Wrightwood | 2021-08-19 | San Bernardino | 71 | 360 | 5177 | |
628219 | 628219 | Yermo | Yermo | 2021-08-19 | San Bernardino | 71 | 86 | 1672 | |
628220 | 628220 | Yucaipa | Yucaipa | 2021-08-19 | San Bernardino | 71 | 6202 | 54490 | |
628221 | 628221 | Yucca Valley | Yucca Valley | 2021-08-19 | San Bernardino | 71 | 1734 | 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 );