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-06-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 |
---|---|---|---|---|---|---|---|---|---|
698338 | 698338 | Adelanto | Adelanto | 2021-06-25 | San Bernardino | 71 | 5546 | 35234 | |
698339 | 698339 | Angelus Oaks | Angelus Oaks | 2021-06-25 | San Bernardino | 71 | 40 | 385 | |
698340 | 698340 | Apple Valley | Apple Valley | 2021-06-25 | San Bernardino | 71 | 9621 | 73694 | |
698341 | 698341 | Arrowbear | Arrowbear | 2021-06-25 | San Bernardino | 71 | 5 | 723 | |
698342 | 698342 | Baker | Baker | 2021-06-25 | San Bernardino | 71 | 57 | 799 | |
698343 | 698343 | Barstow | Barstow | 2021-06-25 | San Bernardino | 71 | 3508 | 23754 | |
698344 | 698344 | Big Bear City | Big Bear City | 2021-06-25 | San Bernardino | 71 | 577 | 10045 | |
698345 | 698345 | Big Bear Lake | Big Bear Lake | 2021-06-25 | San Bernardino | 71 | 401 | 5231 | |
698346 | 698346 | Big River | Big River | 2021-06-25 | San Bernardino | 71 | 20 | 1264 | |
698347 | 698347 | Bloomington | Bloomington | 2021-06-25 | San Bernardino | 71 | 6080 | 17115 | |
698348 | 698348 | Blue Jay | Blue Jay | 2021-06-25 | San Bernardino | 71 | 159 | 900 | |
698349 | 698349 | Cedar Glen | Cedar Glen | 2021-06-25 | San Bernardino | 71 | 7 | 739 | |
698350 | 698350 | Chino | Chino | 2021-06-25 | San Bernardino | 71 | 13390 | 93099 | |
698351 | 698351 | Chino Hills | Chino Hills | 2021-06-25 | San Bernardino | 71 | 5959 | 82917 | |
698352 | 698352 | Colton | Colton | 2021-06-25 | San Bernardino | 71 | 10321 | 54636 | |
698353 | 698353 | Crestline | Crestline | 2021-06-25 | San Bernardino | 71 | 650 | 8010 | |
698354 | 698354 | Daggett | Daggett | 2021-06-25 | San Bernardino | 71 | 20 | 549 | |
698355 | 698355 | Devore | Devore | 2021-06-25 | San Bernardino | 71 | 2 | 2283 | |
698356 | 698356 | Fawnskin | Fawnskin | 2021-06-25 | San Bernardino | 71 | 21 | 528 | |
698357 | 698357 | Fontana | Fontana | 2021-06-25 | San Bernardino | 71 | 40144 | 215334 | |
698358 | 698358 | Forest Falls | Forest Falls | 2021-06-25 | San Bernardino | 71 | 39 | 920 | |
698359 | 698359 | Grand Terrace | Grand Terrace | 2021-06-25 | San Bernardino | 71 | 1648 | 12403 | |
698360 | 698360 | Green Valley Lake | Green Valley Lake | 2021-06-25 | San Bernardino | 71 | 13 | 412 | |
698361 | 698361 | Havasu Lake | Havasu Lake | 2021-06-25 | San Bernardino | 71 | 0 | 0 | |
698362 | 698362 | Helendale | Helendale | 2021-06-25 | San Bernardino | 71 | 528 | 6629 | |
698363 | 698363 | Hesperia | Hesperia | 2021-06-25 | San Bernardino | 71 | 14217 | 97312 | |
698364 | 698364 | Highland | Highland | 2021-06-25 | San Bernardino | 71 | 8212 | 55484 | |
698365 | 698365 | Hinkley | Hinkley | 2021-06-25 | San Bernardino | 71 | 60 | 1259 | |
698366 | 698366 | Joshua Tree | Joshua Tree | 2021-06-25 | San Bernardino | 71 | 360 | 9887 | |
698367 | 698367 | Lake Arrowhead | Lake Arrowhead | 2021-06-25 | San Bernardino | 71 | 474 | 8104 | |
698368 | 698368 | Landers | Landers | 2021-06-25 | San Bernardino | 71 | 60 | 2983 | |
698369 | 698369 | Loma Linda | Loma Linda | 2021-06-25 | San Bernardino | 71 | 2695 | 25260 | |
698370 | 698370 | Lucerne Valley | Lucerne Valley | 2021-06-25 | San Bernardino | 71 | 361 | 7041 | |
698371 | 698371 | Lytle Creek | Lytle Creek | 2021-06-25 | San Bernardino | 71 | 72 | 837 | |
698372 | 698372 | Mentone | Mentone | 2021-06-25 | San Bernardino | 71 | 1105 | 9255 | |
698373 | 698373 | Montclair | Montclair | 2021-06-25 | San Bernardino | 71 | 6252 | 40415 | |
698374 | 698374 | Morongo Valley | Morongo Valley | 2021-06-25 | San Bernardino | 71 | 181 | 3739 | |
698375 | 698375 | Mt Baldy | Mt Baldy | 2021-06-25 | San Bernardino | 71 | 2 | 537 | |
698376 | 698376 | Muscoy | Muscoy | 2021-06-25 | San Bernardino | 71 | 114 | 11536 | |
698377 | 698377 | Needles | Needles | 2021-06-25 | San Bernardino | 71 | 400 | 4964 | |
698378 | 698378 | Newberry Springs | Newberry Springs | 2021-06-25 | San Bernardino | 71 | 138 | 2215 | |
698379 | 698379 | Oak Glen | Oak Glen | 2021-06-25 | San Bernardino | 71 | 14 | 625 | |
698380 | 698380 | Oak Hills | Oak Hills | 2021-06-25 | San Bernardino | 71 | 1593 | 9488 | |
698381 | 698381 | Ontario | Ontario | 2021-06-25 | San Bernardino | 71 | 26483 | 182380 | |
698382 | 698382 | Oro Grande | Oro Grande | 2021-06-25 | San Bernardino | 71 | 132 | 1137 | |
698383 | 698383 | Phelan | Phelan | 2021-06-25 | San Bernardino | 71 | 1682 | 14757 | |
698384 | 698384 | Pinon Hills | Pinon Hills | 2021-06-25 | San Bernardino | 71 | 432 | 8042 | |
698385 | 698385 | Pioneertown | Pioneertown | 2021-06-25 | San Bernardino | 71 | 8 | 365 | |
698386 | 698386 | Rancho Cucamonga | Rancho Cucamonga | 2021-06-25 | San Bernardino | 71 | 18586 | 177037 | |
698387 | 698387 | Redlands | Redlands | 2021-06-25 | San Bernardino | 71 | 8895 | 72099 | |
698388 | 698388 | Rialto | Rialto | 2021-06-25 | San Bernardino | 71 | 18814 | 103884 | |
698389 | 698389 | Rimforest | Rimforest | 2021-06-25 | San Bernardino | 71 | 45 | 756 | |
698390 | 698390 | Running Springs | Running Springs | 2021-06-25 | San Bernardino | 71 | 294 | 4661 | |
698391 | 698391 | San Bernardino | San Bernardino | 2021-06-25 | San Bernardino | 71 | 41058 | 218515 | |
698392 | 698392 | Sugarloaf | Sugarloaf | 2021-06-25 | San Bernardino | 71 | 91 | 3137 | |
698393 | 698393 | Trona | Trona | 2021-06-25 | San Bernardino | 71 | 47 | 1191 | |
698394 | 698394 | Twentynine Palms | Twentynine Palms | 2021-06-25 | San Bernardino | 71 | 1129 | 24966 | |
698395 | 698395 | Twin Peaks | Twin Peaks | 2021-06-25 | San Bernardino | 71 | 136 | 2493 | |
698396 | 698396 | Upland | Upland | 2021-06-25 | San Bernardino | 71 | 8691 | 78249 | |
698397 | 698397 | Victorville | Victorville | 2021-06-25 | San Bernardino | 71 | 21682 | 128353 | |
698398 | 698398 | Wrightwood | Wrightwood | 2021-06-25 | San Bernardino | 71 | 335 | 5177 | |
698399 | 698399 | Yermo | Yermo | 2021-06-25 | San Bernardino | 71 | 83 | 1672 | |
698400 | 698400 | Yucaipa | Yucaipa | 2021-06-25 | San Bernardino | 71 | 5761 | 54490 | |
698401 | 698401 | Yucca Valley | Yucca Valley | 2021-06-25 | San Bernardino | 71 | 1553 | 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 );