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-09-21 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 |
---|---|---|---|---|---|---|---|---|---|
586050 | 586050 | Adelanto | Adelanto | 2021-09-21 | San Bernardino | 71 | 6312 | 35234 | |
586051 | 586051 | Angelus Oaks | Angelus Oaks | 2021-09-21 | San Bernardino | 71 | 46 | 385 | |
586052 | 586052 | Apple Valley | Apple Valley | 2021-09-21 | San Bernardino | 71 | 11432 | 73694 | |
586053 | 586053 | Arrowbear | Arrowbear | 2021-09-21 | San Bernardino | 71 | 7 | 723 | |
586054 | 586054 | Baker | Baker | 2021-09-21 | San Bernardino | 71 | 58 | 799 | |
586055 | 586055 | Barstow | Barstow | 2021-09-21 | San Bernardino | 71 | 4017 | 23754 | |
586056 | 586056 | Big Bear City | Big Bear City | 2021-09-21 | San Bernardino | 71 | 834 | 10045 | |
586057 | 586057 | Big Bear Lake | Big Bear Lake | 2021-09-21 | San Bernardino | 71 | 542 | 5231 | |
586058 | 586058 | Big River | Big River | 2021-09-21 | San Bernardino | 71 | 23 | 1264 | |
586059 | 586059 | Bloomington | Bloomington | 2021-09-21 | San Bernardino | 71 | 6762 | 17115 | |
586060 | 586060 | Blue Jay | Blue Jay | 2021-09-21 | San Bernardino | 71 | 188 | 900 | |
586061 | 586061 | Cedar Glen | Cedar Glen | 2021-09-21 | San Bernardino | 71 | 7 | 739 | |
586062 | 586062 | Chino | Chino | 2021-09-21 | San Bernardino | 71 | 15181 | 93099 | |
586063 | 586063 | Chino Hills | Chino Hills | 2021-09-21 | San Bernardino | 71 | 7104 | 82917 | |
586064 | 586064 | Colton | Colton | 2021-09-21 | San Bernardino | 71 | 11424 | 54636 | |
586065 | 586065 | Crestline | Crestline | 2021-09-21 | San Bernardino | 71 | 781 | 8010 | |
586066 | 586066 | Daggett | Daggett | 2021-09-21 | San Bernardino | 71 | 20 | 549 | |
586067 | 586067 | Devore | Devore | 2021-09-21 | San Bernardino | 71 | 2 | 2283 | |
586068 | 586068 | Fawnskin | Fawnskin | 2021-09-21 | San Bernardino | 71 | 31 | 528 | |
586069 | 586069 | Fontana | Fontana | 2021-09-21 | San Bernardino | 71 | 44921 | 215334 | |
586070 | 586070 | Forest Falls | Forest Falls | 2021-09-21 | San Bernardino | 71 | 50 | 920 | |
586071 | 586071 | Grand Terrace | Grand Terrace | 2021-09-21 | San Bernardino | 71 | 1905 | 12403 | |
586072 | 586072 | Green Valley Lake | Green Valley Lake | 2021-09-21 | San Bernardino | 71 | 18 | 412 | |
586073 | 586073 | Havasu Lake | Havasu Lake | 2021-09-21 | San Bernardino | 71 | 0 | 0 | |
586074 | 586074 | Helendale | Helendale | 2021-09-21 | San Bernardino | 71 | 606 | 6629 | |
586075 | 586075 | Hesperia | Hesperia | 2021-09-21 | San Bernardino | 71 | 16086 | 97312 | |
586076 | 586076 | Highland | Highland | 2021-09-21 | San Bernardino | 71 | 9288 | 55484 | |
586077 | 586077 | Hinkley | Hinkley | 2021-09-21 | San Bernardino | 71 | 66 | 1259 | |
586078 | 586078 | Joshua Tree | Joshua Tree | 2021-09-21 | San Bernardino | 71 | 494 | 9887 | |
586079 | 586079 | Lake Arrowhead | Lake Arrowhead | 2021-09-21 | San Bernardino | 71 | 561 | 8104 | |
586080 | 586080 | Landers | Landers | 2021-09-21 | San Bernardino | 71 | 81 | 2983 | |
586081 | 586081 | Loma Linda | Loma Linda | 2021-09-21 | San Bernardino | 71 | 3046 | 25260 | |
586082 | 586082 | Lucerne Valley | Lucerne Valley | 2021-09-21 | San Bernardino | 71 | 428 | 7041 | |
586083 | 586083 | Lytle Creek | Lytle Creek | 2021-09-21 | San Bernardino | 71 | 83 | 837 | |
586084 | 586084 | Mentone | Mentone | 2021-09-21 | San Bernardino | 71 | 1285 | 9255 | |
586085 | 586085 | Montclair | Montclair | 2021-09-21 | San Bernardino | 71 | 6890 | 40415 | |
586086 | 586086 | Morongo Valley | Morongo Valley | 2021-09-21 | San Bernardino | 71 | 214 | 3739 | |
586087 | 586087 | Mt Baldy | Mt Baldy | 2021-09-21 | San Bernardino | 71 | 2 | 537 | |
586088 | 586088 | Muscoy | Muscoy | 2021-09-21 | San Bernardino | 71 | 123 | 11536 | |
586089 | 586089 | Needles | Needles | 2021-09-21 | San Bernardino | 71 | 463 | 4964 | |
586090 | 586090 | Newberry Springs | Newberry Springs | 2021-09-21 | San Bernardino | 71 | 158 | 2215 | |
586091 | 586091 | Oak Glen | Oak Glen | 2021-09-21 | San Bernardino | 71 | 17 | 625 | |
586092 | 586092 | Oak Hills | Oak Hills | 2021-09-21 | San Bernardino | 71 | 1849 | 9488 | |
586093 | 586093 | Ontario | Ontario | 2021-09-21 | San Bernardino | 71 | 29669 | 182380 | |
586094 | 586094 | Oro Grande | Oro Grande | 2021-09-21 | San Bernardino | 71 | 146 | 1137 | |
586095 | 586095 | Phelan | Phelan | 2021-09-21 | San Bernardino | 71 | 1948 | 14757 | |
586096 | 586096 | Pinon Hills | Pinon Hills | 2021-09-21 | San Bernardino | 71 | 528 | 8042 | |
586097 | 586097 | Pioneertown | Pioneertown | 2021-09-21 | San Bernardino | 71 | 13 | 365 | |
586098 | 586098 | Rancho Cucamonga | Rancho Cucamonga | 2021-09-21 | San Bernardino | 71 | 22184 | 177037 | |
586099 | 586099 | Redlands | Redlands | 2021-09-21 | San Bernardino | 71 | 10248 | 72099 | |
586100 | 586100 | Rialto | Rialto | 2021-09-21 | San Bernardino | 71 | 20831 | 103884 | |
586101 | 586101 | Rimforest | Rimforest | 2021-09-21 | San Bernardino | 71 | 54 | 756 | |
586102 | 586102 | Running Springs | Running Springs | 2021-09-21 | San Bernardino | 71 | 374 | 4661 | |
586103 | 586103 | San Bernardino | San Bernardino | 2021-09-21 | San Bernardino | 71 | 45828 | 218515 | |
586104 | 586104 | Sugarloaf | Sugarloaf | 2021-09-21 | San Bernardino | 71 | 145 | 3137 | |
586105 | 586105 | Trona | Trona | 2021-09-21 | San Bernardino | 71 | 53 | 1191 | |
586106 | 586106 | Twentynine Palms | Twentynine Palms | 2021-09-21 | San Bernardino | 71 | 1619 | 24966 | |
586107 | 586107 | Twin Peaks | Twin Peaks | 2021-09-21 | San Bernardino | 71 | 166 | 2493 | |
586108 | 586108 | Upland | Upland | 2021-09-21 | San Bernardino | 71 | 9995 | 78249 | |
586109 | 586109 | Victorville | Victorville | 2021-09-21 | San Bernardino | 71 | 24799 | 128353 | |
586110 | 586110 | Wrightwood | Wrightwood | 2021-09-21 | San Bernardino | 71 | 410 | 5177 | |
586111 | 586111 | Yermo | Yermo | 2021-09-21 | San Bernardino | 71 | 99 | 1672 | |
586112 | 586112 | Yucaipa | Yucaipa | 2021-09-21 | San Bernardino | 71 | 6884 | 54490 | |
586113 | 586113 | Yucca Valley | Yucca Valley | 2021-09-21 | San Bernardino | 71 | 1962 | 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 );