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-07-06 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 |
---|---|---|---|---|---|---|---|---|---|
684302 | 684302 | Adelanto | Adelanto | 2021-07-06 | San Bernardino | 71 | 5557 | 35234 | |
684303 | 684303 | Angelus Oaks | Angelus Oaks | 2021-07-06 | San Bernardino | 71 | 40 | 385 | |
684304 | 684304 | Apple Valley | Apple Valley | 2021-07-06 | San Bernardino | 71 | 9643 | 73694 | |
684305 | 684305 | Arrowbear | Arrowbear | 2021-07-06 | San Bernardino | 71 | 5 | 723 | |
684306 | 684306 | Baker | Baker | 2021-07-06 | San Bernardino | 71 | 57 | 799 | |
684307 | 684307 | Barstow | Barstow | 2021-07-06 | San Bernardino | 71 | 3517 | 23754 | |
684308 | 684308 | Big Bear City | Big Bear City | 2021-07-06 | San Bernardino | 71 | 579 | 10045 | |
684309 | 684309 | Big Bear Lake | Big Bear Lake | 2021-07-06 | San Bernardino | 71 | 404 | 5231 | |
684310 | 684310 | Big River | Big River | 2021-07-06 | San Bernardino | 71 | 20 | 1264 | |
684311 | 684311 | Bloomington | Bloomington | 2021-07-06 | San Bernardino | 71 | 6086 | 17115 | |
684312 | 684312 | Blue Jay | Blue Jay | 2021-07-06 | San Bernardino | 71 | 159 | 900 | |
684313 | 684313 | Cedar Glen | Cedar Glen | 2021-07-06 | San Bernardino | 71 | 7 | 739 | |
684314 | 684314 | Chino | Chino | 2021-07-06 | San Bernardino | 71 | 13419 | 93099 | |
684315 | 684315 | Chino Hills | Chino Hills | 2021-07-06 | San Bernardino | 71 | 5980 | 82917 | |
684316 | 684316 | Colton | Colton | 2021-07-06 | San Bernardino | 71 | 10338 | 54636 | |
684317 | 684317 | Crestline | Crestline | 2021-07-06 | San Bernardino | 71 | 650 | 8010 | |
684318 | 684318 | Daggett | Daggett | 2021-07-06 | San Bernardino | 71 | 20 | 549 | |
684319 | 684319 | Devore | Devore | 2021-07-06 | San Bernardino | 71 | 2 | 2283 | |
684320 | 684320 | Fawnskin | Fawnskin | 2021-07-06 | San Bernardino | 71 | 21 | 528 | |
684321 | 684321 | Fontana | Fontana | 2021-07-06 | San Bernardino | 71 | 40193 | 215334 | |
684322 | 684322 | Forest Falls | Forest Falls | 2021-07-06 | San Bernardino | 71 | 39 | 920 | |
684323 | 684323 | Grand Terrace | Grand Terrace | 2021-07-06 | San Bernardino | 71 | 1652 | 12403 | |
684324 | 684324 | Green Valley Lake | Green Valley Lake | 2021-07-06 | San Bernardino | 71 | 13 | 412 | |
684325 | 684325 | Havasu Lake | Havasu Lake | 2021-07-06 | San Bernardino | 71 | 0 | 0 | |
684326 | 684326 | Helendale | Helendale | 2021-07-06 | San Bernardino | 71 | 529 | 6629 | |
684327 | 684327 | Hesperia | Hesperia | 2021-07-06 | San Bernardino | 71 | 14240 | 97312 | |
684328 | 684328 | Highland | Highland | 2021-07-06 | San Bernardino | 71 | 8218 | 55484 | |
684329 | 684329 | Hinkley | Hinkley | 2021-07-06 | San Bernardino | 71 | 60 | 1259 | |
684330 | 684330 | Joshua Tree | Joshua Tree | 2021-07-06 | San Bernardino | 71 | 360 | 9887 | |
684331 | 684331 | Lake Arrowhead | Lake Arrowhead | 2021-07-06 | San Bernardino | 71 | 472 | 8104 | |
684332 | 684332 | Landers | Landers | 2021-07-06 | San Bernardino | 71 | 60 | 2983 | |
684333 | 684333 | Loma Linda | Loma Linda | 2021-07-06 | San Bernardino | 71 | 2700 | 25260 | |
684334 | 684334 | Lucerne Valley | Lucerne Valley | 2021-07-06 | San Bernardino | 71 | 363 | 7041 | |
684335 | 684335 | Lytle Creek | Lytle Creek | 2021-07-06 | San Bernardino | 71 | 72 | 837 | |
684336 | 684336 | Mentone | Mentone | 2021-07-06 | San Bernardino | 71 | 1104 | 9255 | |
684337 | 684337 | Montclair | Montclair | 2021-07-06 | San Bernardino | 71 | 6260 | 40415 | |
684338 | 684338 | Morongo Valley | Morongo Valley | 2021-07-06 | San Bernardino | 71 | 181 | 3739 | |
684339 | 684339 | Mt Baldy | Mt Baldy | 2021-07-06 | San Bernardino | 71 | 2 | 537 | |
684340 | 684340 | Muscoy | Muscoy | 2021-07-06 | San Bernardino | 71 | 114 | 11536 | |
684341 | 684341 | Needles | Needles | 2021-07-06 | San Bernardino | 71 | 400 | 4964 | |
684342 | 684342 | Newberry Springs | Newberry Springs | 2021-07-06 | San Bernardino | 71 | 139 | 2215 | |
684343 | 684343 | Oak Glen | Oak Glen | 2021-07-06 | San Bernardino | 71 | 15 | 625 | |
684344 | 684344 | Oak Hills | Oak Hills | 2021-07-06 | San Bernardino | 71 | 1600 | 9488 | |
684345 | 684345 | Ontario | Ontario | 2021-07-06 | San Bernardino | 71 | 26515 | 182380 | |
684346 | 684346 | Oro Grande | Oro Grande | 2021-07-06 | San Bernardino | 71 | 132 | 1137 | |
684347 | 684347 | Phelan | Phelan | 2021-07-06 | San Bernardino | 71 | 1684 | 14757 | |
684348 | 684348 | Pinon Hills | Pinon Hills | 2021-07-06 | San Bernardino | 71 | 434 | 8042 | |
684349 | 684349 | Pioneertown | Pioneertown | 2021-07-06 | San Bernardino | 71 | 8 | 365 | |
684350 | 684350 | Rancho Cucamonga | Rancho Cucamonga | 2021-07-06 | San Bernardino | 71 | 18661 | 177037 | |
684351 | 684351 | Redlands | Redlands | 2021-07-06 | San Bernardino | 71 | 8913 | 72099 | |
684352 | 684352 | Rialto | Rialto | 2021-07-06 | San Bernardino | 71 | 18861 | 103884 | |
684353 | 684353 | Rimforest | Rimforest | 2021-07-06 | San Bernardino | 71 | 45 | 756 | |
684354 | 684354 | Running Springs | Running Springs | 2021-07-06 | San Bernardino | 71 | 294 | 4661 | |
684355 | 684355 | San Bernardino | San Bernardino | 2021-07-06 | San Bernardino | 71 | 41163 | 218515 | |
684356 | 684356 | Sugarloaf | Sugarloaf | 2021-07-06 | San Bernardino | 71 | 93 | 3137 | |
684357 | 684357 | Trona | Trona | 2021-07-06 | San Bernardino | 71 | 47 | 1191 | |
684358 | 684358 | Twentynine Palms | Twentynine Palms | 2021-07-06 | San Bernardino | 71 | 1135 | 24966 | |
684359 | 684359 | Twin Peaks | Twin Peaks | 2021-07-06 | San Bernardino | 71 | 136 | 2493 | |
684360 | 684360 | Upland | Upland | 2021-07-06 | San Bernardino | 71 | 8712 | 78249 | |
684361 | 684361 | Victorville | Victorville | 2021-07-06 | San Bernardino | 71 | 21735 | 128353 | |
684362 | 684362 | Wrightwood | Wrightwood | 2021-07-06 | San Bernardino | 71 | 336 | 5177 | |
684363 | 684363 | Yermo | Yermo | 2021-07-06 | San Bernardino | 71 | 83 | 1672 | |
684364 | 684364 | Yucaipa | Yucaipa | 2021-07-06 | San Bernardino | 71 | 5777 | 54490 | |
684365 | 684365 | Yucca Valley | Yucca Valley | 2021-07-06 | San Bernardino | 71 | 1558 | 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 );