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 2020-07-17 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 |
---|---|---|---|---|---|---|---|---|---|
1123223 | 1123223 | Adelanto | Adelanto | 2020-07-17 | San Bernardino | 71 | 264 | 35234 | |
1123224 | 1123224 | Angelus Oaks | Angelus Oaks | 2020-07-17 | San Bernardino | 71 | 1 | 385 | |
1123225 | 1123225 | Apple Valley | Apple Valley | 2020-07-17 | San Bernardino | 71 | 320 | 73694 | |
1123226 | 1123226 | Arrowbear | Arrowbear | 2020-07-17 | San Bernardino | 71 | 0 | 723 | |
1123227 | 1123227 | Baker | Baker | 2020-07-17 | San Bernardino | 71 | 3 | 799 | |
1123228 | 1123228 | Barstow | Barstow | 2020-07-17 | San Bernardino | 71 | 92 | 23754 | |
1123229 | 1123229 | Big Bear City | Big Bear City | 2020-07-17 | San Bernardino | 71 | 15 | 10045 | |
1123230 | 1123230 | Big Bear Lake | Big Bear Lake | 2020-07-17 | San Bernardino | 71 | 18 | 5231 | |
1123231 | 1123231 | Big River | Big River | 2020-07-17 | San Bernardino | 71 | 1 | 1264 | |
1123232 | 1123232 | Bloomington | Bloomington | 2020-07-17 | San Bernardino | 71 | 414 | 17115 | |
1123233 | 1123233 | Blue Jay | Blue Jay | 2020-07-17 | San Bernardino | 71 | 6 | 900 | |
1123234 | 1123234 | Cedar Glen | Cedar Glen | 2020-07-17 | San Bernardino | 71 | 2 | 739 | |
1123235 | 1123235 | Chino | Chino | 2020-07-17 | San Bernardino | 71 | 1822 | 93099 | |
1123236 | 1123236 | Chino Hills | Chino Hills | 2020-07-17 | San Bernardino | 71 | 447 | 82917 | |
1123237 | 1123237 | Colton | Colton | 2020-07-17 | San Bernardino | 71 | 947 | 54636 | |
1123238 | 1123238 | Crestline | Crestline | 2020-07-17 | San Bernardino | 71 | 31 | 8010 | |
1123239 | 1123239 | Daggett | Daggett | 2020-07-17 | San Bernardino | 71 | 1 | 549 | |
1123240 | 1123240 | Devore | Devore | 2020-07-17 | San Bernardino | 71 | 1 | 2283 | |
1123241 | 1123241 | Fawnskin | Fawnskin | 2020-07-17 | San Bernardino | 71 | 0 | 528 | |
1123242 | 1123242 | Fontana | Fontana | 2020-07-17 | San Bernardino | 71 | 2662 | 215334 | |
1123243 | 1123243 | Forest Falls | Forest Falls | 2020-07-17 | San Bernardino | 71 | 3 | 920 | |
1123244 | 1123244 | Grand Terrace | Grand Terrace | 2020-07-17 | San Bernardino | 71 | 161 | 12403 | |
1123245 | 1123245 | Green Valley Lake | Green Valley Lake | 2020-07-17 | San Bernardino | 71 | 0 | 412 | |
1123246 | 1123246 | Havasu Lake | Havasu Lake | 2020-07-17 | San Bernardino | 71 | 0 | 0 | |
1123247 | 1123247 | Helendale | Helendale | 2020-07-17 | San Bernardino | 71 | 22 | 6629 | |
1123248 | 1123248 | Hesperia | Hesperia | 2020-07-17 | San Bernardino | 71 | 590 | 97312 | |
1123249 | 1123249 | Highland | Highland | 2020-07-17 | San Bernardino | 71 | 648 | 55484 | |
1123250 | 1123250 | Hinkley | Hinkley | 2020-07-17 | San Bernardino | 71 | 3 | 1259 | |
1123251 | 1123251 | Joshua Tree | Joshua Tree | 2020-07-17 | San Bernardino | 71 | 24 | 9887 | |
1123252 | 1123252 | Lake Arrowhead | Lake Arrowhead | 2020-07-17 | San Bernardino | 71 | 3 | 8104 | |
1123253 | 1123253 | Landers | Landers | 2020-07-17 | San Bernardino | 71 | 1 | 2983 | |
1123254 | 1123254 | Loma Linda | Loma Linda | 2020-07-17 | San Bernardino | 71 | 247 | 25260 | |
1123255 | 1123255 | Lucerne Valley | Lucerne Valley | 2020-07-17 | San Bernardino | 71 | 7 | 7041 | |
1123256 | 1123256 | Lytle Creek | Lytle Creek | 2020-07-17 | San Bernardino | 71 | 3 | 837 | |
1123257 | 1123257 | Mentone | Mentone | 2020-07-17 | San Bernardino | 71 | 145 | 9255 | |
1123258 | 1123258 | Montclair | Montclair | 2020-07-17 | San Bernardino | 71 | 458 | 40415 | |
1123259 | 1123259 | Morongo Valley | Morongo Valley | 2020-07-17 | San Bernardino | 71 | 13 | 3739 | |
1123260 | 1123260 | Mt Baldy | Mt Baldy | 2020-07-17 | San Bernardino | 71 | 0 | 537 | |
1123261 | 1123261 | Muscoy | Muscoy | 2020-07-17 | San Bernardino | 71 | 7 | 11536 | |
1123262 | 1123262 | Needles | Needles | 2020-07-17 | San Bernardino | 71 | 16 | 4964 | |
1123263 | 1123263 | Newberry Springs | Newberry Springs | 2020-07-17 | San Bernardino | 71 | 3 | 2215 | |
1123264 | 1123264 | Oak Glen | Oak Glen | 2020-07-17 | San Bernardino | 71 | 0 | 625 | |
1123265 | 1123265 | Oak Hills | Oak Hills | 2020-07-17 | San Bernardino | 71 | 66 | 9488 | |
1123266 | 1123266 | Ontario | Ontario | 2020-07-17 | San Bernardino | 71 | 2065 | 182380 | |
1123267 | 1123267 | Oro Grande | Oro Grande | 2020-07-17 | San Bernardino | 71 | 6 | 1137 | |
1123268 | 1123268 | Phelan | Phelan | 2020-07-17 | San Bernardino | 71 | 70 | 14757 | |
1123269 | 1123269 | Pinon Hills | Pinon Hills | 2020-07-17 | San Bernardino | 71 | 22 | 8042 | |
1123270 | 1123270 | Pioneertown | Pioneertown | 2020-07-17 | San Bernardino | 71 | 1 | 365 | |
1123271 | 1123271 | Rancho Cucamonga | Rancho Cucamonga | 2020-07-17 | San Bernardino | 71 | 1139 | 177037 | |
1123272 | 1123272 | Redlands | Redlands | 2020-07-17 | San Bernardino | 71 | 887 | 72099 | |
1123273 | 1123273 | Rialto | Rialto | 2020-07-17 | San Bernardino | 71 | 1295 | 103884 | |
1123274 | 1123274 | Rimforest | Rimforest | 2020-07-17 | San Bernardino | 71 | 1 | 756 | |
1123275 | 1123275 | Running Springs | Running Springs | 2020-07-17 | San Bernardino | 71 | 12 | 4661 | |
1123276 | 1123276 | San Bernardino | San Bernardino | 2020-07-17 | San Bernardino | 71 | 3475 | 218515 | |
1123277 | 1123277 | Sugarloaf | Sugarloaf | 2020-07-17 | San Bernardino | 71 | 4 | 3137 | |
1123278 | 1123278 | Trona | Trona | 2020-07-17 | San Bernardino | 71 | 0 | 1191 | |
1123279 | 1123279 | Twentynine Palms | Twentynine Palms | 2020-07-17 | San Bernardino | 71 | 17 | 24966 | |
1123280 | 1123280 | Twin Peaks | Twin Peaks | 2020-07-17 | San Bernardino | 71 | 4 | 2493 | |
1123281 | 1123281 | Upland | Upland | 2020-07-17 | San Bernardino | 71 | 555 | 78249 | |
1123282 | 1123282 | Victorville | Victorville | 2020-07-17 | San Bernardino | 71 | 1034 | 128353 | |
1123283 | 1123283 | Wrightwood | Wrightwood | 2020-07-17 | San Bernardino | 71 | 3 | 5177 | |
1123284 | 1123284 | Yermo | Yermo | 2020-07-17 | San Bernardino | 71 | 3 | 1672 | |
1123285 | 1123285 | Yucaipa | Yucaipa | 2020-07-17 | San Bernardino | 71 | 519 | 54490 | |
1123286 | 1123286 | Yucca Valley | Yucca Valley | 2020-07-17 | San Bernardino | 71 | 82 | 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 );