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 2022-11-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 |
---|---|---|---|---|---|---|---|---|---|
51504 | 51504 | Adelanto | Adelanto | 2022-11-17 | San Bernardino | 71 | 11309 | 35234 | |
51505 | 51505 | Angelus Oaks | Angelus Oaks | 2022-11-17 | San Bernardino | 71 | 99 | 385 | |
51506 | 51506 | Apple Valley | Apple Valley | 2022-11-17 | San Bernardino | 71 | 22642 | 73694 | |
51507 | 51507 | Arrowbear | Arrowbear | 2022-11-17 | San Bernardino | 71 | 11 | 723 | |
51508 | 51508 | Baker | Baker | 2022-11-17 | San Bernardino | 71 | 109 | 799 | |
51509 | 51509 | Barstow | Barstow | 2022-11-17 | San Bernardino | 71 | 7960 | 23754 | |
51510 | 51510 | Big Bear City | Big Bear City | 2022-11-17 | San Bernardino | 71 | 1590 | 10045 | |
51511 | 51511 | Big Bear Lake | Big Bear Lake | 2022-11-17 | San Bernardino | 71 | 1050 | 5231 | |
51512 | 51512 | Big River | Big River | 2022-11-17 | San Bernardino | 71 | 51 | 1264 | |
51513 | 51513 | Bloomington | Bloomington | 2022-11-17 | San Bernardino | 71 | 11976 | 17115 | |
51514 | 51514 | Blue Jay | Blue Jay | 2022-11-17 | San Bernardino | 71 | 383 | 900 | |
51515 | 51515 | Cedar Glen | Cedar Glen | 2022-11-17 | San Bernardino | 71 | 7 | 739 | |
51516 | 51516 | Chino | Chino | 2022-11-17 | San Bernardino | 71 | 32227 | 93099 | |
51517 | 51517 | Chino Hills | Chino Hills | 2022-11-17 | San Bernardino | 71 | 18625 | 82917 | |
51518 | 51518 | Colton | Colton | 2022-11-17 | San Bernardino | 71 | 21052 | 54636 | |
51519 | 51519 | Crestline | Crestline | 2022-11-17 | San Bernardino | 71 | 1724 | 8010 | |
51520 | 51520 | Daggett | Daggett | 2022-11-17 | San Bernardino | 71 | 67 | 549 | |
51521 | 51521 | Devore | Devore | 2022-11-17 | San Bernardino | 71 | 2 | 2283 | |
51522 | 51522 | Fawnskin | Fawnskin | 2022-11-17 | San Bernardino | 71 | 76 | 528 | |
51523 | 51523 | Fontana | Fontana | 2022-11-17 | San Bernardino | 71 | 83818 | 215334 | |
51524 | 51524 | Forest Falls | Forest Falls | 2022-11-17 | San Bernardino | 71 | 151 | 920 | |
51525 | 51525 | Grand Terrace | Grand Terrace | 2022-11-17 | San Bernardino | 71 | 4012 | 12403 | |
51526 | 51526 | Green Valley Lake | Green Valley Lake | 2022-11-17 | San Bernardino | 71 | 43 | 412 | |
51527 | 51527 | Havasu Lake | Havasu Lake | 2022-11-17 | San Bernardino | 71 | 106 | 0 | |
51528 | 51528 | Helendale | Helendale | 2022-11-17 | San Bernardino | 71 | 1284 | 6629 | |
51529 | 51529 | Hesperia | Hesperia | 2022-11-17 | San Bernardino | 71 | 29254 | 97312 | |
51530 | 51530 | Highland | Highland | 2022-11-17 | San Bernardino | 71 | 17686 | 55484 | |
51531 | 51531 | Hinkley | Hinkley | 2022-11-17 | San Bernardino | 71 | 133 | 1259 | |
51532 | 51532 | Joshua Tree | Joshua Tree | 2022-11-17 | San Bernardino | 71 | 1382 | 9887 | |
51533 | 51533 | Lake Arrowhead | Lake Arrowhead | 2022-11-17 | San Bernardino | 71 | 1086 | 8104 | |
51534 | 51534 | Landers | Landers | 2022-11-17 | San Bernardino | 71 | 217 | 2983 | |
51535 | 51535 | Loma Linda | Loma Linda | 2022-11-17 | San Bernardino | 71 | 7340 | 25260 | |
51536 | 51536 | Lucerne Valley | Lucerne Valley | 2022-11-17 | San Bernardino | 71 | 899 | 7041 | |
51537 | 51537 | Lytle Creek | Lytle Creek | 2022-11-17 | San Bernardino | 71 | 177 | 837 | |
51538 | 51538 | Mentone | Mentone | 2022-11-17 | San Bernardino | 71 | 2695 | 9255 | |
51539 | 51539 | Montclair | Montclair | 2022-11-17 | San Bernardino | 71 | 13834 | 40415 | |
51540 | 51540 | Morongo Valley | Morongo Valley | 2022-11-17 | San Bernardino | 71 | 530 | 3739 | |
51541 | 51541 | Mt Baldy | Mt Baldy | 2022-11-17 | San Bernardino | 71 | 7 | 537 | |
51542 | 51542 | Muscoy | Muscoy | 2022-11-17 | San Bernardino | 71 | 269 | 11536 | |
51543 | 51543 | Needles | Needles | 2022-11-17 | San Bernardino | 71 | 740 | 4964 | |
51544 | 51544 | Newberry Springs | Newberry Springs | 2022-11-17 | San Bernardino | 71 | 281 | 2215 | |
51545 | 51545 | Oak Glen | Oak Glen | 2022-11-17 | San Bernardino | 71 | 35 | 625 | |
51546 | 51546 | Oak Hills | Oak Hills | 2022-11-17 | San Bernardino | 71 | 3287 | 9488 | |
51547 | 51547 | Ontario | Ontario | 2022-11-17 | San Bernardino | 71 | 57429 | 182380 | |
51548 | 51548 | Oro Grande | Oro Grande | 2022-11-17 | San Bernardino | 71 | 214 | 1137 | |
51549 | 51549 | Phelan | Phelan | 2022-11-17 | San Bernardino | 71 | 3743 | 14757 | |
51550 | 51550 | Pinon Hills | Pinon Hills | 2022-11-17 | San Bernardino | 71 | 1079 | 8042 | |
51551 | 51551 | Pioneertown | Pioneertown | 2022-11-17 | San Bernardino | 71 | 53 | 365 | |
51552 | 51552 | Rancho Cucamonga | Rancho Cucamonga | 2022-11-17 | San Bernardino | 71 | 47871 | 177037 | |
51553 | 51553 | Redlands | Redlands | 2022-11-17 | San Bernardino | 71 | 22795 | 72099 | |
51554 | 51554 | Rialto | Rialto | 2022-11-17 | San Bernardino | 71 | 37914 | 103884 | |
51555 | 51555 | Rimforest | Rimforest | 2022-11-17 | San Bernardino | 71 | 110 | 756 | |
51556 | 51556 | Running Springs | Running Springs | 2022-11-17 | San Bernardino | 71 | 828 | 4661 | |
51557 | 51557 | San Bernardino | San Bernardino | 2022-11-17 | San Bernardino | 71 | 84546 | 218515 | |
51558 | 51558 | Sugarloaf | Sugarloaf | 2022-11-17 | San Bernardino | 71 | 341 | 3137 | |
51559 | 51559 | Trona | Trona | 2022-11-17 | San Bernardino | 71 | 125 | 1191 | |
51560 | 51560 | Twentynine Palms | Twentynine Palms | 2022-11-17 | San Bernardino | 71 | 3727 | 24966 | |
51561 | 51561 | Twin Peaks | Twin Peaks | 2022-11-17 | San Bernardino | 71 | 322 | 2493 | |
51562 | 51562 | Upland | Upland | 2022-11-17 | San Bernardino | 71 | 21571 | 78249 | |
51563 | 51563 | Victorville | Victorville | 2022-11-17 | San Bernardino | 71 | 46958 | 128353 | |
51564 | 51564 | Wrightwood | Wrightwood | 2022-11-17 | San Bernardino | 71 | 848 | 5177 | |
51565 | 51565 | Yermo | Yermo | 2022-11-17 | San Bernardino | 71 | 202 | 1672 | |
51566 | 51566 | Yucaipa | Yucaipa | 2022-11-17 | San Bernardino | 71 | 14509 | 54490 | |
51567 | 51567 | Yucca Valley | Yucca Valley | 2022-11-17 | San Bernardino | 71 | 4894 | 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 );