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-09-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 |
---|---|---|---|---|---|---|---|---|---|
1067405 | 1067405 | Adelanto | Adelanto | 2020-09-02 | San Bernardino | 71 | 723 | 35234 | |
1067406 | 1067406 | Angelus Oaks | Angelus Oaks | 2020-09-02 | San Bernardino | 71 | 2 | 385 | |
1067407 | 1067407 | Apple Valley | Apple Valley | 2020-09-02 | San Bernardino | 71 | 1026 | 73694 | |
1067408 | 1067408 | Arrowbear | Arrowbear | 2020-09-02 | San Bernardino | 71 | 0 | 723 | |
1067409 | 1067409 | Baker | Baker | 2020-09-02 | San Bernardino | 71 | 12 | 799 | |
1067410 | 1067410 | Barstow | Barstow | 2020-09-02 | San Bernardino | 71 | 214 | 23754 | |
1067411 | 1067411 | Big Bear City | Big Bear City | 2020-09-02 | San Bernardino | 71 | 35 | 10045 | |
1067412 | 1067412 | Big Bear Lake | Big Bear Lake | 2020-09-02 | San Bernardino | 71 | 49 | 5231 | |
1067413 | 1067413 | Big River | Big River | 2020-09-02 | San Bernardino | 71 | 1 | 1264 | |
1067414 | 1067414 | Bloomington | Bloomington | 2020-09-02 | San Bernardino | 71 | 1037 | 17115 | |
1067415 | 1067415 | Blue Jay | Blue Jay | 2020-09-02 | San Bernardino | 71 | 12 | 900 | |
1067416 | 1067416 | Cedar Glen | Cedar Glen | 2020-09-02 | San Bernardino | 71 | 7 | 739 | |
1067417 | 1067417 | Chino | Chino | 2020-09-02 | San Bernardino | 71 | 2921 | 93099 | |
1067418 | 1067418 | Chino Hills | Chino Hills | 2020-09-02 | San Bernardino | 71 | 823 | 82917 | |
1067419 | 1067419 | Colton | Colton | 2020-09-02 | San Bernardino | 71 | 1902 | 54636 | |
1067420 | 1067420 | Crestline | Crestline | 2020-09-02 | San Bernardino | 71 | 64 | 8010 | |
1067421 | 1067421 | Daggett | Daggett | 2020-09-02 | San Bernardino | 71 | 2 | 549 | |
1067422 | 1067422 | Devore | Devore | 2020-09-02 | San Bernardino | 71 | 2 | 2283 | |
1067423 | 1067423 | Fawnskin | Fawnskin | 2020-09-02 | San Bernardino | 71 | 2 | 528 | |
1067424 | 1067424 | Fontana | Fontana | 2020-09-02 | San Bernardino | 71 | 6479 | 215334 | |
1067425 | 1067425 | Forest Falls | Forest Falls | 2020-09-02 | San Bernardino | 71 | 3 | 920 | |
1067426 | 1067426 | Grand Terrace | Grand Terrace | 2020-09-02 | San Bernardino | 71 | 288 | 12403 | |
1067427 | 1067427 | Green Valley Lake | Green Valley Lake | 2020-09-02 | San Bernardino | 71 | 1 | 412 | |
1067428 | 1067428 | Havasu Lake | Havasu Lake | 2020-09-02 | San Bernardino | 71 | 0 | 0 | |
1067429 | 1067429 | Helendale | Helendale | 2020-09-02 | San Bernardino | 71 | 55 | 6629 | |
1067430 | 1067430 | Hesperia | Hesperia | 2020-09-02 | San Bernardino | 71 | 1762 | 97312 | |
1067431 | 1067431 | Highland | Highland | 2020-09-02 | San Bernardino | 71 | 1357 | 55484 | |
1067432 | 1067432 | Hinkley | Hinkley | 2020-09-02 | San Bernardino | 71 | 7 | 1259 | |
1067433 | 1067433 | Joshua Tree | Joshua Tree | 2020-09-02 | San Bernardino | 71 | 69 | 9887 | |
1067434 | 1067434 | Lake Arrowhead | Lake Arrowhead | 2020-09-02 | San Bernardino | 71 | 15 | 8104 | |
1067435 | 1067435 | Landers | Landers | 2020-09-02 | San Bernardino | 71 | 9 | 2983 | |
1067436 | 1067436 | Loma Linda | Loma Linda | 2020-09-02 | San Bernardino | 71 | 484 | 25260 | |
1067437 | 1067437 | Lucerne Valley | Lucerne Valley | 2020-09-02 | San Bernardino | 71 | 24 | 7041 | |
1067438 | 1067438 | Lytle Creek | Lytle Creek | 2020-09-02 | San Bernardino | 71 | 15 | 837 | |
1067439 | 1067439 | Mentone | Mentone | 2020-09-02 | San Bernardino | 71 | 241 | 9255 | |
1067440 | 1067440 | Montclair | Montclair | 2020-09-02 | San Bernardino | 71 | 1099 | 40415 | |
1067441 | 1067441 | Morongo Valley | Morongo Valley | 2020-09-02 | San Bernardino | 71 | 18 | 3739 | |
1067442 | 1067442 | Mt Baldy | Mt Baldy | 2020-09-02 | San Bernardino | 71 | 1 | 537 | |
1067443 | 1067443 | Muscoy | Muscoy | 2020-09-02 | San Bernardino | 71 | 15 | 11536 | |
1067444 | 1067444 | Needles | Needles | 2020-09-02 | San Bernardino | 71 | 46 | 4964 | |
1067445 | 1067445 | Newberry Springs | Newberry Springs | 2020-09-02 | San Bernardino | 71 | 6 | 2215 | |
1067446 | 1067446 | Oak Glen | Oak Glen | 2020-09-02 | San Bernardino | 71 | 3 | 625 | |
1067447 | 1067447 | Oak Hills | Oak Hills | 2020-09-02 | San Bernardino | 71 | 182 | 9488 | |
1067448 | 1067448 | Ontario | Ontario | 2020-09-02 | San Bernardino | 71 | 4492 | 182380 | |
1067449 | 1067449 | Oro Grande | Oro Grande | 2020-09-02 | San Bernardino | 71 | 11 | 1137 | |
1067450 | 1067450 | Phelan | Phelan | 2020-09-02 | San Bernardino | 71 | 191 | 14757 | |
1067451 | 1067451 | Pinon Hills | Pinon Hills | 2020-09-02 | San Bernardino | 71 | 55 | 8042 | |
1067452 | 1067452 | Pioneertown | Pioneertown | 2020-09-02 | San Bernardino | 71 | 1 | 365 | |
1067453 | 1067453 | Rancho Cucamonga | Rancho Cucamonga | 2020-09-02 | San Bernardino | 71 | 2455 | 177037 | |
1067454 | 1067454 | Redlands | Redlands | 2020-09-02 | San Bernardino | 71 | 1630 | 72099 | |
1067455 | 1067455 | Rialto | Rialto | 2020-09-02 | San Bernardino | 71 | 3086 | 103884 | |
1067456 | 1067456 | Rimforest | Rimforest | 2020-09-02 | San Bernardino | 71 | 1 | 756 | |
1067457 | 1067457 | Running Springs | Running Springs | 2020-09-02 | San Bernardino | 71 | 25 | 4661 | |
1067458 | 1067458 | San Bernardino | San Bernardino | 2020-09-02 | San Bernardino | 71 | 7647 | 218515 | |
1067459 | 1067459 | Sugarloaf | Sugarloaf | 2020-09-02 | San Bernardino | 71 | 11 | 3137 | |
1067460 | 1067460 | Trona | Trona | 2020-09-02 | San Bernardino | 71 | 9 | 1191 | |
1067461 | 1067461 | Twentynine Palms | Twentynine Palms | 2020-09-02 | San Bernardino | 71 | 50 | 24966 | |
1067462 | 1067462 | Twin Peaks | Twin Peaks | 2020-09-02 | San Bernardino | 71 | 10 | 2493 | |
1067463 | 1067463 | Upland | Upland | 2020-09-02 | San Bernardino | 71 | 1250 | 78249 | |
1067464 | 1067464 | Victorville | Victorville | 2020-09-02 | San Bernardino | 71 | 3057 | 128353 | |
1067465 | 1067465 | Wrightwood | Wrightwood | 2020-09-02 | San Bernardino | 71 | 21 | 5177 | |
1067466 | 1067466 | Yermo | Yermo | 2020-09-02 | San Bernardino | 71 | 12 | 1672 | |
1067467 | 1067467 | Yucaipa | Yucaipa | 2020-09-02 | San Bernardino | 71 | 909 | 54490 | |
1067468 | 1067468 | Yucca Valley | Yucca Valley | 2020-09-02 | San Bernardino | 71 | 221 | 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 );