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-01 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 |
---|---|---|---|---|---|---|---|---|---|
71200 | 71200 | Adelanto | Adelanto | 2022-11-01 | San Bernardino | 71 | 11291 | 35234 | |
71201 | 71201 | Angelus Oaks | Angelus Oaks | 2022-11-01 | San Bernardino | 71 | 99 | 385 | |
71202 | 71202 | Apple Valley | Apple Valley | 2022-11-01 | San Bernardino | 71 | 22612 | 73694 | |
71203 | 71203 | Arrowbear | Arrowbear | 2022-11-01 | San Bernardino | 71 | 11 | 723 | |
71204 | 71204 | Baker | Baker | 2022-11-01 | San Bernardino | 71 | 109 | 799 | |
71205 | 71205 | Barstow | Barstow | 2022-11-01 | San Bernardino | 71 | 7943 | 23754 | |
71206 | 71206 | Big Bear City | Big Bear City | 2022-11-01 | San Bernardino | 71 | 1587 | 10045 | |
71207 | 71207 | Big Bear Lake | Big Bear Lake | 2022-11-01 | San Bernardino | 71 | 1047 | 5231 | |
71208 | 71208 | Big River | Big River | 2022-11-01 | San Bernardino | 71 | 51 | 1264 | |
71209 | 71209 | Bloomington | Bloomington | 2022-11-01 | San Bernardino | 71 | 11958 | 17115 | |
71210 | 71210 | Blue Jay | Blue Jay | 2022-11-01 | San Bernardino | 71 | 382 | 900 | |
71211 | 71211 | Cedar Glen | Cedar Glen | 2022-11-01 | San Bernardino | 71 | 7 | 739 | |
71212 | 71212 | Chino | Chino | 2022-11-01 | San Bernardino | 71 | 32177 | 93099 | |
71213 | 71213 | Chino Hills | Chino Hills | 2022-11-01 | San Bernardino | 71 | 18588 | 82917 | |
71214 | 71214 | Colton | Colton | 2022-11-01 | San Bernardino | 71 | 21025 | 54636 | |
71215 | 71215 | Crestline | Crestline | 2022-11-01 | San Bernardino | 71 | 1723 | 8010 | |
71216 | 71216 | Daggett | Daggett | 2022-11-01 | San Bernardino | 71 | 67 | 549 | |
71217 | 71217 | Devore | Devore | 2022-11-01 | San Bernardino | 71 | 2 | 2283 | |
71218 | 71218 | Fawnskin | Fawnskin | 2022-11-01 | San Bernardino | 71 | 76 | 528 | |
71219 | 71219 | Fontana | Fontana | 2022-11-01 | San Bernardino | 71 | 83700 | 215334 | |
71220 | 71220 | Forest Falls | Forest Falls | 2022-11-01 | San Bernardino | 71 | 151 | 920 | |
71221 | 71221 | Grand Terrace | Grand Terrace | 2022-11-01 | San Bernardino | 71 | 4007 | 12403 | |
71222 | 71222 | Green Valley Lake | Green Valley Lake | 2022-11-01 | San Bernardino | 71 | 43 | 412 | |
71223 | 71223 | Havasu Lake | Havasu Lake | 2022-11-01 | San Bernardino | 71 | 106 | 0 | |
71224 | 71224 | Helendale | Helendale | 2022-11-01 | San Bernardino | 71 | 1281 | 6629 | |
71225 | 71225 | Hesperia | Hesperia | 2022-11-01 | San Bernardino | 71 | 29216 | 97312 | |
71226 | 71226 | Highland | Highland | 2022-11-01 | San Bernardino | 71 | 17663 | 55484 | |
71227 | 71227 | Hinkley | Hinkley | 2022-11-01 | San Bernardino | 71 | 133 | 1259 | |
71228 | 71228 | Joshua Tree | Joshua Tree | 2022-11-01 | San Bernardino | 71 | 1380 | 9887 | |
71229 | 71229 | Lake Arrowhead | Lake Arrowhead | 2022-11-01 | San Bernardino | 71 | 1085 | 8104 | |
71230 | 71230 | Landers | Landers | 2022-11-01 | San Bernardino | 71 | 217 | 2983 | |
71231 | 71231 | Loma Linda | Loma Linda | 2022-11-01 | San Bernardino | 71 | 7323 | 25260 | |
71232 | 71232 | Lucerne Valley | Lucerne Valley | 2022-11-01 | San Bernardino | 71 | 899 | 7041 | |
71233 | 71233 | Lytle Creek | Lytle Creek | 2022-11-01 | San Bernardino | 71 | 176 | 837 | |
71234 | 71234 | Mentone | Mentone | 2022-11-01 | San Bernardino | 71 | 2691 | 9255 | |
71235 | 71235 | Montclair | Montclair | 2022-11-01 | San Bernardino | 71 | 13816 | 40415 | |
71236 | 71236 | Morongo Valley | Morongo Valley | 2022-11-01 | San Bernardino | 71 | 530 | 3739 | |
71237 | 71237 | Mt Baldy | Mt Baldy | 2022-11-01 | San Bernardino | 71 | 7 | 537 | |
71238 | 71238 | Muscoy | Muscoy | 2022-11-01 | San Bernardino | 71 | 269 | 11536 | |
71239 | 71239 | Needles | Needles | 2022-11-01 | San Bernardino | 71 | 738 | 4964 | |
71240 | 71240 | Newberry Springs | Newberry Springs | 2022-11-01 | San Bernardino | 71 | 281 | 2215 | |
71241 | 71241 | Oak Glen | Oak Glen | 2022-11-01 | San Bernardino | 71 | 35 | 625 | |
71242 | 71242 | Oak Hills | Oak Hills | 2022-11-01 | San Bernardino | 71 | 3283 | 9488 | |
71243 | 71243 | Ontario | Ontario | 2022-11-01 | San Bernardino | 71 | 57345 | 182380 | |
71244 | 71244 | Oro Grande | Oro Grande | 2022-11-01 | San Bernardino | 71 | 214 | 1137 | |
71245 | 71245 | Phelan | Phelan | 2022-11-01 | San Bernardino | 71 | 3739 | 14757 | |
71246 | 71246 | Pinon Hills | Pinon Hills | 2022-11-01 | San Bernardino | 71 | 1077 | 8042 | |
71247 | 71247 | Pioneertown | Pioneertown | 2022-11-01 | San Bernardino | 71 | 53 | 365 | |
71248 | 71248 | Rancho Cucamonga | Rancho Cucamonga | 2022-11-01 | San Bernardino | 71 | 47766 | 177037 | |
71249 | 71249 | Redlands | Redlands | 2022-11-01 | San Bernardino | 71 | 22754 | 72099 | |
71250 | 71250 | Rialto | Rialto | 2022-11-01 | San Bernardino | 71 | 37865 | 103884 | |
71251 | 71251 | Rimforest | Rimforest | 2022-11-01 | San Bernardino | 71 | 109 | 756 | |
71252 | 71252 | Running Springs | Running Springs | 2022-11-01 | San Bernardino | 71 | 822 | 4661 | |
71253 | 71253 | San Bernardino | San Bernardino | 2022-11-01 | San Bernardino | 71 | 84438 | 218515 | |
71254 | 71254 | Sugarloaf | Sugarloaf | 2022-11-01 | San Bernardino | 71 | 340 | 3137 | |
71255 | 71255 | Trona | Trona | 2022-11-01 | San Bernardino | 71 | 123 | 1191 | |
71256 | 71256 | Twentynine Palms | Twentynine Palms | 2022-11-01 | San Bernardino | 71 | 3722 | 24966 | |
71257 | 71257 | Twin Peaks | Twin Peaks | 2022-11-01 | San Bernardino | 71 | 322 | 2493 | |
71258 | 71258 | Upland | Upland | 2022-11-01 | San Bernardino | 71 | 21523 | 78249 | |
71259 | 71259 | Victorville | Victorville | 2022-11-01 | San Bernardino | 71 | 46897 | 128353 | |
71260 | 71260 | Wrightwood | Wrightwood | 2022-11-01 | San Bernardino | 71 | 848 | 5177 | |
71261 | 71261 | Yermo | Yermo | 2022-11-01 | San Bernardino | 71 | 202 | 1672 | |
71262 | 71262 | Yucaipa | Yucaipa | 2022-11-01 | San Bernardino | 71 | 14483 | 54490 | |
71263 | 71263 | Yucca Valley | Yucca Valley | 2022-11-01 | San Bernardino | 71 | 4879 | 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 );