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-08-25 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 |
---|---|---|---|---|---|---|---|---|---|
620502 | 620502 | Adelanto | Adelanto | 2021-08-25 | San Bernardino | 71 | 6026 | 35234 | |
620503 | 620503 | Angelus Oaks | Angelus Oaks | 2021-08-25 | San Bernardino | 71 | 43 | 385 | |
620504 | 620504 | Apple Valley | Apple Valley | 2021-08-25 | San Bernardino | 71 | 10676 | 73694 | |
620505 | 620505 | Arrowbear | Arrowbear | 2021-08-25 | San Bernardino | 71 | 5 | 723 | |
620506 | 620506 | Baker | Baker | 2021-08-25 | San Bernardino | 71 | 57 | 799 | |
620507 | 620507 | Barstow | Barstow | 2021-08-25 | San Bernardino | 71 | 3803 | 23754 | |
620508 | 620508 | Big Bear City | Big Bear City | 2021-08-25 | San Bernardino | 71 | 780 | 10045 | |
620509 | 620509 | Big Bear Lake | Big Bear Lake | 2021-08-25 | San Bernardino | 71 | 502 | 5231 | |
620510 | 620510 | Big River | Big River | 2021-08-25 | San Bernardino | 71 | 21 | 1264 | |
620511 | 620511 | Bloomington | Bloomington | 2021-08-25 | San Bernardino | 71 | 6557 | 17115 | |
620512 | 620512 | Blue Jay | Blue Jay | 2021-08-25 | San Bernardino | 71 | 183 | 900 | |
620513 | 620513 | Cedar Glen | Cedar Glen | 2021-08-25 | San Bernardino | 71 | 7 | 739 | |
620514 | 620514 | Chino | Chino | 2021-08-25 | San Bernardino | 71 | 14615 | 93099 | |
620515 | 620515 | Chino Hills | Chino Hills | 2021-08-25 | San Bernardino | 71 | 6764 | 82917 | |
620516 | 620516 | Colton | Colton | 2021-08-25 | San Bernardino | 71 | 11072 | 54636 | |
620517 | 620517 | Crestline | Crestline | 2021-08-25 | San Bernardino | 71 | 734 | 8010 | |
620518 | 620518 | Daggett | Daggett | 2021-08-25 | San Bernardino | 71 | 20 | 549 | |
620519 | 620519 | Devore | Devore | 2021-08-25 | San Bernardino | 71 | 2 | 2283 | |
620520 | 620520 | Fawnskin | Fawnskin | 2021-08-25 | San Bernardino | 71 | 28 | 528 | |
620521 | 620521 | Fontana | Fontana | 2021-08-25 | San Bernardino | 71 | 43455 | 215334 | |
620522 | 620522 | Forest Falls | Forest Falls | 2021-08-25 | San Bernardino | 71 | 46 | 920 | |
620523 | 620523 | Grand Terrace | Grand Terrace | 2021-08-25 | San Bernardino | 71 | 1825 | 12403 | |
620524 | 620524 | Green Valley Lake | Green Valley Lake | 2021-08-25 | San Bernardino | 71 | 17 | 412 | |
620525 | 620525 | Havasu Lake | Havasu Lake | 2021-08-25 | San Bernardino | 71 | 0 | 0 | |
620526 | 620526 | Helendale | Helendale | 2021-08-25 | San Bernardino | 71 | 582 | 6629 | |
620527 | 620527 | Hesperia | Hesperia | 2021-08-25 | San Bernardino | 71 | 15376 | 97312 | |
620528 | 620528 | Highland | Highland | 2021-08-25 | San Bernardino | 71 | 8877 | 55484 | |
620529 | 620529 | Hinkley | Hinkley | 2021-08-25 | San Bernardino | 71 | 67 | 1259 | |
620530 | 620530 | Joshua Tree | Joshua Tree | 2021-08-25 | San Bernardino | 71 | 445 | 9887 | |
620531 | 620531 | Lake Arrowhead | Lake Arrowhead | 2021-08-25 | San Bernardino | 71 | 529 | 8104 | |
620532 | 620532 | Landers | Landers | 2021-08-25 | San Bernardino | 71 | 67 | 2983 | |
620533 | 620533 | Loma Linda | Loma Linda | 2021-08-25 | San Bernardino | 71 | 2931 | 25260 | |
620534 | 620534 | Lucerne Valley | Lucerne Valley | 2021-08-25 | San Bernardino | 71 | 411 | 7041 | |
620535 | 620535 | Lytle Creek | Lytle Creek | 2021-08-25 | San Bernardino | 71 | 81 | 837 | |
620536 | 620536 | Mentone | Mentone | 2021-08-25 | San Bernardino | 71 | 1227 | 9255 | |
620537 | 620537 | Montclair | Montclair | 2021-08-25 | San Bernardino | 71 | 6651 | 40415 | |
620538 | 620538 | Morongo Valley | Morongo Valley | 2021-08-25 | San Bernardino | 71 | 203 | 3739 | |
620539 | 620539 | Mt Baldy | Mt Baldy | 2021-08-25 | San Bernardino | 71 | 2 | 537 | |
620540 | 620540 | Muscoy | Muscoy | 2021-08-25 | San Bernardino | 71 | 117 | 11536 | |
620541 | 620541 | Needles | Needles | 2021-08-25 | San Bernardino | 71 | 435 | 4964 | |
620542 | 620542 | Newberry Springs | Newberry Springs | 2021-08-25 | San Bernardino | 71 | 147 | 2215 | |
620543 | 620543 | Oak Glen | Oak Glen | 2021-08-25 | San Bernardino | 71 | 16 | 625 | |
620544 | 620544 | Oak Hills | Oak Hills | 2021-08-25 | San Bernardino | 71 | 1756 | 9488 | |
620545 | 620545 | Ontario | Ontario | 2021-08-25 | San Bernardino | 71 | 28580 | 182380 | |
620546 | 620546 | Oro Grande | Oro Grande | 2021-08-25 | San Bernardino | 71 | 143 | 1137 | |
620547 | 620547 | Phelan | Phelan | 2021-08-25 | San Bernardino | 71 | 1848 | 14757 | |
620548 | 620548 | Pinon Hills | Pinon Hills | 2021-08-25 | San Bernardino | 71 | 485 | 8042 | |
620549 | 620549 | Pioneertown | Pioneertown | 2021-08-25 | San Bernardino | 71 | 10 | 365 | |
620550 | 620550 | Rancho Cucamonga | Rancho Cucamonga | 2021-08-25 | San Bernardino | 71 | 21121 | 177037 | |
620551 | 620551 | Redlands | Redlands | 2021-08-25 | San Bernardino | 71 | 9820 | 72099 | |
620552 | 620552 | Rialto | Rialto | 2021-08-25 | San Bernardino | 71 | 20187 | 103884 | |
620553 | 620553 | Rimforest | Rimforest | 2021-08-25 | San Bernardino | 71 | 52 | 756 | |
620554 | 620554 | Running Springs | Running Springs | 2021-08-25 | San Bernardino | 71 | 351 | 4661 | |
620555 | 620555 | San Bernardino | San Bernardino | 2021-08-25 | San Bernardino | 71 | 44101 | 218515 | |
620556 | 620556 | Sugarloaf | Sugarloaf | 2021-08-25 | San Bernardino | 71 | 130 | 3137 | |
620557 | 620557 | Trona | Trona | 2021-08-25 | San Bernardino | 71 | 51 | 1191 | |
620558 | 620558 | Twentynine Palms | Twentynine Palms | 2021-08-25 | San Bernardino | 71 | 1437 | 24966 | |
620559 | 620559 | Twin Peaks | Twin Peaks | 2021-08-25 | San Bernardino | 71 | 151 | 2493 | |
620560 | 620560 | Upland | Upland | 2021-08-25 | San Bernardino | 71 | 9616 | 78249 | |
620561 | 620561 | Victorville | Victorville | 2021-08-25 | San Bernardino | 71 | 23685 | 128353 | |
620562 | 620562 | Wrightwood | Wrightwood | 2021-08-25 | San Bernardino | 71 | 369 | 5177 | |
620563 | 620563 | Yermo | Yermo | 2021-08-25 | San Bernardino | 71 | 92 | 1672 | |
620564 | 620564 | Yucaipa | Yucaipa | 2021-08-25 | San Bernardino | 71 | 6402 | 54490 | |
620565 | 620565 | Yucca Valley | Yucca Valley | 2021-08-25 | San Bernardino | 71 | 1799 | 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 );