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-02 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 |
---|---|---|---|---|---|---|---|---|---|
689406 | 689406 | Adelanto | Adelanto | 2021-07-02 | San Bernardino | 71 | 5553 | 35234 | |
689407 | 689407 | Angelus Oaks | Angelus Oaks | 2021-07-02 | San Bernardino | 71 | 40 | 385 | |
689408 | 689408 | Apple Valley | Apple Valley | 2021-07-02 | San Bernardino | 71 | 9642 | 73694 | |
689409 | 689409 | Arrowbear | Arrowbear | 2021-07-02 | San Bernardino | 71 | 5 | 723 | |
689410 | 689410 | Baker | Baker | 2021-07-02 | San Bernardino | 71 | 57 | 799 | |
689411 | 689411 | Barstow | Barstow | 2021-07-02 | San Bernardino | 71 | 3517 | 23754 | |
689412 | 689412 | Big Bear City | Big Bear City | 2021-07-02 | San Bernardino | 71 | 579 | 10045 | |
689413 | 689413 | Big Bear Lake | Big Bear Lake | 2021-07-02 | San Bernardino | 71 | 404 | 5231 | |
689414 | 689414 | Big River | Big River | 2021-07-02 | San Bernardino | 71 | 20 | 1264 | |
689415 | 689415 | Bloomington | Bloomington | 2021-07-02 | San Bernardino | 71 | 6086 | 17115 | |
689416 | 689416 | Blue Jay | Blue Jay | 2021-07-02 | San Bernardino | 71 | 159 | 900 | |
689417 | 689417 | Cedar Glen | Cedar Glen | 2021-07-02 | San Bernardino | 71 | 7 | 739 | |
689418 | 689418 | Chino | Chino | 2021-07-02 | San Bernardino | 71 | 13418 | 93099 | |
689419 | 689419 | Chino Hills | Chino Hills | 2021-07-02 | San Bernardino | 71 | 5977 | 82917 | |
689420 | 689420 | Colton | Colton | 2021-07-02 | San Bernardino | 71 | 10337 | 54636 | |
689421 | 689421 | Crestline | Crestline | 2021-07-02 | San Bernardino | 71 | 650 | 8010 | |
689422 | 689422 | Daggett | Daggett | 2021-07-02 | San Bernardino | 71 | 20 | 549 | |
689423 | 689423 | Devore | Devore | 2021-07-02 | San Bernardino | 71 | 2 | 2283 | |
689424 | 689424 | Fawnskin | Fawnskin | 2021-07-02 | San Bernardino | 71 | 21 | 528 | |
689425 | 689425 | Fontana | Fontana | 2021-07-02 | San Bernardino | 71 | 40181 | 215334 | |
689426 | 689426 | Forest Falls | Forest Falls | 2021-07-02 | San Bernardino | 71 | 39 | 920 | |
689427 | 689427 | Grand Terrace | Grand Terrace | 2021-07-02 | San Bernardino | 71 | 1651 | 12403 | |
689428 | 689428 | Green Valley Lake | Green Valley Lake | 2021-07-02 | San Bernardino | 71 | 13 | 412 | |
689429 | 689429 | Havasu Lake | Havasu Lake | 2021-07-02 | San Bernardino | 71 | 0 | 0 | |
689430 | 689430 | Helendale | Helendale | 2021-07-02 | San Bernardino | 71 | 529 | 6629 | |
689431 | 689431 | Hesperia | Hesperia | 2021-07-02 | San Bernardino | 71 | 14235 | 97312 | |
689432 | 689432 | Highland | Highland | 2021-07-02 | San Bernardino | 71 | 8218 | 55484 | |
689433 | 689433 | Hinkley | Hinkley | 2021-07-02 | San Bernardino | 71 | 60 | 1259 | |
689434 | 689434 | Joshua Tree | Joshua Tree | 2021-07-02 | San Bernardino | 71 | 360 | 9887 | |
689435 | 689435 | Lake Arrowhead | Lake Arrowhead | 2021-07-02 | San Bernardino | 71 | 471 | 8104 | |
689436 | 689436 | Landers | Landers | 2021-07-02 | San Bernardino | 71 | 60 | 2983 | |
689437 | 689437 | Loma Linda | Loma Linda | 2021-07-02 | San Bernardino | 71 | 2699 | 25260 | |
689438 | 689438 | Lucerne Valley | Lucerne Valley | 2021-07-02 | San Bernardino | 71 | 363 | 7041 | |
689439 | 689439 | Lytle Creek | Lytle Creek | 2021-07-02 | San Bernardino | 71 | 72 | 837 | |
689440 | 689440 | Mentone | Mentone | 2021-07-02 | San Bernardino | 71 | 1104 | 9255 | |
689441 | 689441 | Montclair | Montclair | 2021-07-02 | San Bernardino | 71 | 6259 | 40415 | |
689442 | 689442 | Morongo Valley | Morongo Valley | 2021-07-02 | San Bernardino | 71 | 181 | 3739 | |
689443 | 689443 | Mt Baldy | Mt Baldy | 2021-07-02 | San Bernardino | 71 | 2 | 537 | |
689444 | 689444 | Muscoy | Muscoy | 2021-07-02 | San Bernardino | 71 | 114 | 11536 | |
689445 | 689445 | Needles | Needles | 2021-07-02 | San Bernardino | 71 | 400 | 4964 | |
689446 | 689446 | Newberry Springs | Newberry Springs | 2021-07-02 | San Bernardino | 71 | 139 | 2215 | |
689447 | 689447 | Oak Glen | Oak Glen | 2021-07-02 | San Bernardino | 71 | 15 | 625 | |
689448 | 689448 | Oak Hills | Oak Hills | 2021-07-02 | San Bernardino | 71 | 1600 | 9488 | |
689449 | 689449 | Ontario | Ontario | 2021-07-02 | San Bernardino | 71 | 26508 | 182380 | |
689450 | 689450 | Oro Grande | Oro Grande | 2021-07-02 | San Bernardino | 71 | 132 | 1137 | |
689451 | 689451 | Phelan | Phelan | 2021-07-02 | San Bernardino | 71 | 1683 | 14757 | |
689452 | 689452 | Pinon Hills | Pinon Hills | 2021-07-02 | San Bernardino | 71 | 434 | 8042 | |
689453 | 689453 | Pioneertown | Pioneertown | 2021-07-02 | San Bernardino | 71 | 8 | 365 | |
689454 | 689454 | Rancho Cucamonga | Rancho Cucamonga | 2021-07-02 | San Bernardino | 71 | 18649 | 177037 | |
689455 | 689455 | Redlands | Redlands | 2021-07-02 | San Bernardino | 71 | 8912 | 72099 | |
689456 | 689456 | Rialto | Rialto | 2021-07-02 | San Bernardino | 71 | 18854 | 103884 | |
689457 | 689457 | Rimforest | Rimforest | 2021-07-02 | San Bernardino | 71 | 45 | 756 | |
689458 | 689458 | Running Springs | Running Springs | 2021-07-02 | San Bernardino | 71 | 294 | 4661 | |
689459 | 689459 | San Bernardino | San Bernardino | 2021-07-02 | San Bernardino | 71 | 41145 | 218515 | |
689460 | 689460 | Sugarloaf | Sugarloaf | 2021-07-02 | San Bernardino | 71 | 93 | 3137 | |
689461 | 689461 | Trona | Trona | 2021-07-02 | San Bernardino | 71 | 47 | 1191 | |
689462 | 689462 | Twentynine Palms | Twentynine Palms | 2021-07-02 | San Bernardino | 71 | 1135 | 24966 | |
689463 | 689463 | Twin Peaks | Twin Peaks | 2021-07-02 | San Bernardino | 71 | 136 | 2493 | |
689464 | 689464 | Upland | Upland | 2021-07-02 | San Bernardino | 71 | 8707 | 78249 | |
689465 | 689465 | Victorville | Victorville | 2021-07-02 | San Bernardino | 71 | 21727 | 128353 | |
689466 | 689466 | Wrightwood | Wrightwood | 2021-07-02 | San Bernardino | 71 | 336 | 5177 | |
689467 | 689467 | Yermo | Yermo | 2021-07-02 | San Bernardino | 71 | 83 | 1672 | |
689468 | 689468 | Yucaipa | Yucaipa | 2021-07-02 | San Bernardino | 71 | 5774 | 54490 | |
689469 | 689469 | Yucca Valley | Yucca Valley | 2021-07-02 | San Bernardino | 71 | 1556 | 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 );