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-08 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 |
---|---|---|---|---|---|---|---|---|---|
642194 | 642194 | Adelanto | Adelanto | 2021-08-08 | San Bernardino | 71 | 5732 | 35234 | |
642195 | 642195 | Angelus Oaks | Angelus Oaks | 2021-08-08 | San Bernardino | 71 | 42 | 385 | |
642196 | 642196 | Apple Valley | Apple Valley | 2021-08-08 | San Bernardino | 71 | 9999 | 73694 | |
642197 | 642197 | Arrowbear | Arrowbear | 2021-08-08 | San Bernardino | 71 | 5 | 723 | |
642198 | 642198 | Baker | Baker | 2021-08-08 | San Bernardino | 71 | 57 | 799 | |
642199 | 642199 | Barstow | Barstow | 2021-08-08 | San Bernardino | 71 | 3630 | 23754 | |
642200 | 642200 | Big Bear City | Big Bear City | 2021-08-08 | San Bernardino | 71 | 686 | 10045 | |
642201 | 642201 | Big Bear Lake | Big Bear Lake | 2021-08-08 | San Bernardino | 71 | 437 | 5231 | |
642202 | 642202 | Big River | Big River | 2021-08-08 | San Bernardino | 71 | 20 | 1264 | |
642203 | 642203 | Bloomington | Bloomington | 2021-08-08 | San Bernardino | 71 | 6243 | 17115 | |
642204 | 642204 | Blue Jay | Blue Jay | 2021-08-08 | San Bernardino | 71 | 168 | 900 | |
642205 | 642205 | Cedar Glen | Cedar Glen | 2021-08-08 | San Bernardino | 71 | 7 | 739 | |
642206 | 642206 | Chino | Chino | 2021-08-08 | San Bernardino | 71 | 13942 | 93099 | |
642207 | 642207 | Chino Hills | Chino Hills | 2021-08-08 | San Bernardino | 71 | 6330 | 82917 | |
642208 | 642208 | Colton | Colton | 2021-08-08 | San Bernardino | 71 | 10596 | 54636 | |
642209 | 642209 | Crestline | Crestline | 2021-08-08 | San Bernardino | 71 | 682 | 8010 | |
642210 | 642210 | Daggett | Daggett | 2021-08-08 | San Bernardino | 71 | 19 | 549 | |
642211 | 642211 | Devore | Devore | 2021-08-08 | San Bernardino | 71 | 2 | 2283 | |
642212 | 642212 | Fawnskin | Fawnskin | 2021-08-08 | San Bernardino | 71 | 23 | 528 | |
642213 | 642213 | Fontana | Fontana | 2021-08-08 | San Bernardino | 71 | 41436 | 215334 | |
642214 | 642214 | Forest Falls | Forest Falls | 2021-08-08 | San Bernardino | 71 | 43 | 920 | |
642215 | 642215 | Grand Terrace | Grand Terrace | 2021-08-08 | San Bernardino | 71 | 1723 | 12403 | |
642216 | 642216 | Green Valley Lake | Green Valley Lake | 2021-08-08 | San Bernardino | 71 | 15 | 412 | |
642217 | 642217 | Havasu Lake | Havasu Lake | 2021-08-08 | San Bernardino | 71 | 0 | 0 | |
642218 | 642218 | Helendale | Helendale | 2021-08-08 | San Bernardino | 71 | 553 | 6629 | |
642219 | 642219 | Hesperia | Hesperia | 2021-08-08 | San Bernardino | 71 | 14656 | 97312 | |
642220 | 642220 | Highland | Highland | 2021-08-08 | San Bernardino | 71 | 8482 | 55484 | |
642221 | 642221 | Hinkley | Hinkley | 2021-08-08 | San Bernardino | 71 | 61 | 1259 | |
642222 | 642222 | Joshua Tree | Joshua Tree | 2021-08-08 | San Bernardino | 71 | 404 | 9887 | |
642223 | 642223 | Lake Arrowhead | Lake Arrowhead | 2021-08-08 | San Bernardino | 71 | 492 | 8104 | |
642224 | 642224 | Landers | Landers | 2021-08-08 | San Bernardino | 71 | 62 | 2983 | |
642225 | 642225 | Loma Linda | Loma Linda | 2021-08-08 | San Bernardino | 71 | 2800 | 25260 | |
642226 | 642226 | Lucerne Valley | Lucerne Valley | 2021-08-08 | San Bernardino | 71 | 395 | 7041 | |
642227 | 642227 | Lytle Creek | Lytle Creek | 2021-08-08 | San Bernardino | 71 | 76 | 837 | |
642228 | 642228 | Mentone | Mentone | 2021-08-08 | San Bernardino | 71 | 1157 | 9255 | |
642229 | 642229 | Montclair | Montclair | 2021-08-08 | San Bernardino | 71 | 6443 | 40415 | |
642230 | 642230 | Morongo Valley | Morongo Valley | 2021-08-08 | San Bernardino | 71 | 193 | 3739 | |
642231 | 642231 | Mt Baldy | Mt Baldy | 2021-08-08 | San Bernardino | 71 | 2 | 537 | |
642232 | 642232 | Muscoy | Muscoy | 2021-08-08 | San Bernardino | 71 | 114 | 11536 | |
642233 | 642233 | Needles | Needles | 2021-08-08 | San Bernardino | 71 | 416 | 4964 | |
642234 | 642234 | Newberry Springs | Newberry Springs | 2021-08-08 | San Bernardino | 71 | 144 | 2215 | |
642235 | 642235 | Oak Glen | Oak Glen | 2021-08-08 | San Bernardino | 71 | 16 | 625 | |
642236 | 642236 | Oak Hills | Oak Hills | 2021-08-08 | San Bernardino | 71 | 1658 | 9488 | |
642237 | 642237 | Ontario | Ontario | 2021-08-08 | San Bernardino | 71 | 27378 | 182380 | |
642238 | 642238 | Oro Grande | Oro Grande | 2021-08-08 | San Bernardino | 71 | 134 | 1137 | |
642239 | 642239 | Phelan | Phelan | 2021-08-08 | San Bernardino | 71 | 1755 | 14757 | |
642240 | 642240 | Pinon Hills | Pinon Hills | 2021-08-08 | San Bernardino | 71 | 458 | 8042 | |
642241 | 642241 | Pioneertown | Pioneertown | 2021-08-08 | San Bernardino | 71 | 10 | 365 | |
642242 | 642242 | Rancho Cucamonga | Rancho Cucamonga | 2021-08-08 | San Bernardino | 71 | 19661 | 177037 | |
642243 | 642243 | Redlands | Redlands | 2021-08-08 | San Bernardino | 71 | 9283 | 72099 | |
642244 | 642244 | Rialto | Rialto | 2021-08-08 | San Bernardino | 71 | 19370 | 103884 | |
642245 | 642245 | Rimforest | Rimforest | 2021-08-08 | San Bernardino | 71 | 47 | 756 | |
642246 | 642246 | Running Springs | Running Springs | 2021-08-08 | San Bernardino | 71 | 324 | 4661 | |
642247 | 642247 | San Bernardino | San Bernardino | 2021-08-08 | San Bernardino | 71 | 42272 | 218515 | |
642248 | 642248 | Sugarloaf | Sugarloaf | 2021-08-08 | San Bernardino | 71 | 110 | 3137 | |
642249 | 642249 | Trona | Trona | 2021-08-08 | San Bernardino | 71 | 49 | 1191 | |
642250 | 642250 | Twentynine Palms | Twentynine Palms | 2021-08-08 | San Bernardino | 71 | 1271 | 24966 | |
642251 | 642251 | Twin Peaks | Twin Peaks | 2021-08-08 | San Bernardino | 71 | 141 | 2493 | |
642252 | 642252 | Upland | Upland | 2021-08-08 | San Bernardino | 71 | 9097 | 78249 | |
642253 | 642253 | Victorville | Victorville | 2021-08-08 | San Bernardino | 71 | 22483 | 128353 | |
642254 | 642254 | Wrightwood | Wrightwood | 2021-08-08 | San Bernardino | 71 | 353 | 5177 | |
642255 | 642255 | Yermo | Yermo | 2021-08-08 | San Bernardino | 71 | 85 | 1672 | |
642256 | 642256 | Yucaipa | Yucaipa | 2021-08-08 | San Bernardino | 71 | 6007 | 54490 | |
642257 | 642257 | Yucca Valley | Yucca Valley | 2021-08-08 | San Bernardino | 71 | 1673 | 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 );