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-04-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 |
---|---|---|---|---|---|---|---|---|---|
786382 | 786382 | Adelanto | Adelanto | 2021-04-17 | San Bernardino | 71 | 5427 | 35234 | |
786383 | 786383 | Angelus Oaks | Angelus Oaks | 2021-04-17 | San Bernardino | 71 | 39 | 385 | |
786384 | 786384 | Apple Valley | Apple Valley | 2021-04-17 | San Bernardino | 71 | 9411 | 73694 | |
786385 | 786385 | Arrowbear | Arrowbear | 2021-04-17 | San Bernardino | 71 | 5 | 723 | |
786386 | 786386 | Baker | Baker | 2021-04-17 | San Bernardino | 71 | 56 | 799 | |
786387 | 786387 | Barstow | Barstow | 2021-04-17 | San Bernardino | 71 | 3462 | 23754 | |
786388 | 786388 | Big Bear City | Big Bear City | 2021-04-17 | San Bernardino | 71 | 562 | 10045 | |
786389 | 786389 | Big Bear Lake | Big Bear Lake | 2021-04-17 | San Bernardino | 71 | 390 | 5231 | |
786390 | 786390 | Big River | Big River | 2021-04-17 | San Bernardino | 71 | 20 | 1264 | |
786391 | 786391 | Bloomington | Bloomington | 2021-04-17 | San Bernardino | 71 | 6020 | 17115 | |
786392 | 786392 | Blue Jay | Blue Jay | 2021-04-17 | San Bernardino | 71 | 156 | 900 | |
786393 | 786393 | Cedar Glen | Cedar Glen | 2021-04-17 | San Bernardino | 71 | 7 | 739 | |
786394 | 786394 | Chino | Chino | 2021-04-17 | San Bernardino | 71 | 13186 | 93099 | |
786395 | 786395 | Chino Hills | Chino Hills | 2021-04-17 | San Bernardino | 71 | 5815 | 82917 | |
786396 | 786396 | Colton | Colton | 2021-04-17 | San Bernardino | 71 | 10232 | 54636 | |
786397 | 786397 | Crestline | Crestline | 2021-04-17 | San Bernardino | 71 | 638 | 8010 | |
786398 | 786398 | Daggett | Daggett | 2021-04-17 | San Bernardino | 71 | 20 | 549 | |
786399 | 786399 | Devore | Devore | 2021-04-17 | San Bernardino | 71 | 2 | 2283 | |
786400 | 786400 | Fawnskin | Fawnskin | 2021-04-17 | San Bernardino | 71 | 21 | 528 | |
786401 | 786401 | Fontana | Fontana | 2021-04-17 | San Bernardino | 71 | 39624 | 215334 | |
786402 | 786402 | Forest Falls | Forest Falls | 2021-04-17 | San Bernardino | 71 | 38 | 920 | |
786403 | 786403 | Grand Terrace | Grand Terrace | 2021-04-17 | San Bernardino | 71 | 1619 | 12403 | |
786404 | 786404 | Green Valley Lake | Green Valley Lake | 2021-04-17 | San Bernardino | 71 | 13 | 412 | |
786405 | 786405 | Havasu Lake | Havasu Lake | 2021-04-17 | San Bernardino | 71 | 0 | 0 | |
786406 | 786406 | Helendale | Helendale | 2021-04-17 | San Bernardino | 71 | 523 | 6629 | |
786407 | 786407 | Hesperia | Hesperia | 2021-04-17 | San Bernardino | 71 | 13946 | 97312 | |
786408 | 786408 | Highland | Highland | 2021-04-17 | San Bernardino | 71 | 8063 | 55484 | |
786409 | 786409 | Hinkley | Hinkley | 2021-04-17 | San Bernardino | 71 | 55 | 1259 | |
786410 | 786410 | Joshua Tree | Joshua Tree | 2021-04-17 | San Bernardino | 71 | 347 | 9887 | |
786411 | 786411 | Lake Arrowhead | Lake Arrowhead | 2021-04-17 | San Bernardino | 71 | 465 | 8104 | |
786412 | 786412 | Landers | Landers | 2021-04-17 | San Bernardino | 71 | 60 | 2983 | |
786413 | 786413 | Loma Linda | Loma Linda | 2021-04-17 | San Bernardino | 71 | 2666 | 25260 | |
786414 | 786414 | Lucerne Valley | Lucerne Valley | 2021-04-17 | San Bernardino | 71 | 355 | 7041 | |
786415 | 786415 | Lytle Creek | Lytle Creek | 2021-04-17 | San Bernardino | 71 | 73 | 837 | |
786416 | 786416 | Mentone | Mentone | 2021-04-17 | San Bernardino | 71 | 1093 | 9255 | |
786417 | 786417 | Montclair | Montclair | 2021-04-17 | San Bernardino | 71 | 6156 | 40415 | |
786418 | 786418 | Morongo Valley | Morongo Valley | 2021-04-17 | San Bernardino | 71 | 177 | 3739 | |
786419 | 786419 | Mt Baldy | Mt Baldy | 2021-04-17 | San Bernardino | 71 | 2 | 537 | |
786420 | 786420 | Muscoy | Muscoy | 2021-04-17 | San Bernardino | 71 | 109 | 11536 | |
786421 | 786421 | Needles | Needles | 2021-04-17 | San Bernardino | 71 | 391 | 4964 | |
786422 | 786422 | Newberry Springs | Newberry Springs | 2021-04-17 | San Bernardino | 71 | 134 | 2215 | |
786423 | 786423 | Oak Glen | Oak Glen | 2021-04-17 | San Bernardino | 71 | 12 | 625 | |
786424 | 786424 | Oak Hills | Oak Hills | 2021-04-17 | San Bernardino | 71 | 1542 | 9488 | |
786425 | 786425 | Ontario | Ontario | 2021-04-17 | San Bernardino | 71 | 26079 | 182380 | |
786426 | 786426 | Oro Grande | Oro Grande | 2021-04-17 | San Bernardino | 71 | 132 | 1137 | |
786427 | 786427 | Phelan | Phelan | 2021-04-17 | San Bernardino | 71 | 1638 | 14757 | |
786428 | 786428 | Pinon Hills | Pinon Hills | 2021-04-17 | San Bernardino | 71 | 421 | 8042 | |
786429 | 786429 | Pioneertown | Pioneertown | 2021-04-17 | San Bernardino | 71 | 9 | 365 | |
786430 | 786430 | Rancho Cucamonga | Rancho Cucamonga | 2021-04-17 | San Bernardino | 71 | 18243 | 177037 | |
786431 | 786431 | Redlands | Redlands | 2021-04-17 | San Bernardino | 71 | 8729 | 72099 | |
786432 | 786432 | Rialto | Rialto | 2021-04-17 | San Bernardino | 71 | 18574 | 103884 | |
786433 | 786433 | Rimforest | Rimforest | 2021-04-17 | San Bernardino | 71 | 45 | 756 | |
786434 | 786434 | Running Springs | Running Springs | 2021-04-17 | San Bernardino | 71 | 284 | 4661 | |
786435 | 786435 | San Bernardino | San Bernardino | 2021-04-17 | San Bernardino | 71 | 40494 | 218515 | |
786436 | 786436 | Sugarloaf | Sugarloaf | 2021-04-17 | San Bernardino | 71 | 91 | 3137 | |
786437 | 786437 | Trona | Trona | 2021-04-17 | San Bernardino | 71 | 43 | 1191 | |
786438 | 786438 | Twentynine Palms | Twentynine Palms | 2021-04-17 | San Bernardino | 71 | 1080 | 24966 | |
786439 | 786439 | Twin Peaks | Twin Peaks | 2021-04-17 | San Bernardino | 71 | 130 | 2493 | |
786440 | 786440 | Upland | Upland | 2021-04-17 | San Bernardino | 71 | 8556 | 78249 | |
786441 | 786441 | Victorville | Victorville | 2021-04-17 | San Bernardino | 71 | 21093 | 128353 | |
786442 | 786442 | Wrightwood | Wrightwood | 2021-04-17 | San Bernardino | 71 | 331 | 5177 | |
786443 | 786443 | Yermo | Yermo | 2021-04-17 | San Bernardino | 71 | 82 | 1672 | |
786444 | 786444 | Yucaipa | Yucaipa | 2021-04-17 | San Bernardino | 71 | 5635 | 54490 | |
786445 | 786445 | Yucca Valley | Yucca Valley | 2021-04-17 | San Bernardino | 71 | 1491 | 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 );