⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

24,128 rows where fips = 71 sorted by date descending

View and edit SQL

fips

  • 71 · 24,128

county

Link rowid id name date ▲ county fips confirmed_cases note population
910 Adelanto Adelanto 2021-04-10 San Bernardino 71 5359   35234
911 Angelus Oaks Angelus Oaks 2021-04-10 San Bernardino 71 38   385
912 Apple Valley Apple Valley 2021-04-10 San Bernardino 71 9275   73694
913 Arrowbear Arrowbear 2021-04-10 San Bernardino 71 5   723
914 Baker Baker 2021-04-10 San Bernardino 71 56   799
915 Barstow Barstow 2021-04-10 San Bernardino 71 3444   23754
916 Big Bear City Big Bear City 2021-04-10 San Bernardino 71 555   10045
917 Big Bear Lake Big Bear Lake 2021-04-10 San Bernardino 71 384   5231
918 Big River Big River 2021-04-10 San Bernardino 71 20   1264
919 Bloomington Bloomington 2021-04-10 San Bernardino 71 5996   17115
920 Blue Jay Blue Jay 2021-04-10 San Bernardino 71 152   900
921 Cedar Glen Cedar Glen 2021-04-10 San Bernardino 71 7   739
922 Chino Chino 2021-04-10 San Bernardino 71 13086   93099
923 Chino Hills Chino Hills 2021-04-10 San Bernardino 71 5774   82917
924 Colton Colton 2021-04-10 San Bernardino 71 10188   54636
925 Crestline Crestline 2021-04-10 San Bernardino 71 632   8010
926 Daggett Daggett 2021-04-10 San Bernardino 71 20   549
927 Devore Devore 2021-04-10 San Bernardino 71 2   2283
928 Fawnskin Fawnskin 2021-04-10 San Bernardino 71 21   528
929 Fontana Fontana 2021-04-10 San Bernardino 71 39410   215334
930 Forest Falls Forest Falls 2021-04-10 San Bernardino 71 38   920
931 Grand Terrace Grand Terrace 2021-04-10 San Bernardino 71 1611   12403
932 Green Valley Lake Green Valley Lake 2021-04-10 San Bernardino 71 13   412
933 Havasu Havasu 2021-04-10 San Bernardino 71 5   0
934 Helendale Helendale 2021-04-10 San Bernardino 71 519   6629
935 Hesperia Hesperia 2021-04-10 San Bernardino 71 13784   97312
936 Highland Highland 2021-04-10 San Bernardino 71 8007   55484
937 Hinkley Hinkley 2021-04-10 San Bernardino 71 55   1259
938 Joshua Tree Joshua Tree 2021-04-10 San Bernardino 71 333   9887
939 Lake Arrowhead Lake Arrowhead 2021-04-10 San Bernardino 71 458   8104
940 Landers Landers 2021-04-10 San Bernardino 71 59   2983
941 Loma Linda Loma Linda 2021-04-10 San Bernardino 71 2654   25260
942 Lucerne Valley Lucerne Valley 2021-04-10 San Bernardino 71 347   7041
943 Lytle Creek Lytle Creek 2021-04-10 San Bernardino 71 73   837
944 Mentone Mentone 2021-04-10 San Bernardino 71 1090   9255
945 Montclair Montclair 2021-04-10 San Bernardino 71 6110   40415
946 Morongo Valley Morongo Valley 2021-04-10 San Bernardino 71 176   3739
947 Mt Baldy Mt Baldy 2021-04-10 San Bernardino 71 2   537
948 Muscoy Muscoy 2021-04-10 San Bernardino 71 108   11536
949 Needles Needles 2021-04-10 San Bernardino 71 390   4964
950 Newberry Springs Newberry Springs 2021-04-10 San Bernardino 71 132   2215
951 Oak Glen Oak Glen 2021-04-10 San Bernardino 71 12   625
952 Oak Hills Oak Hills 2021-04-10 San Bernardino 71 1527   9488
953 Ontario Ontario 2021-04-10 San Bernardino 71 25904   182380
954 Oro Grande Oro Grande 2021-04-10 San Bernardino 71 131   1137
955 Phelan Phelan 2021-04-10 San Bernardino 71 1623   14757
956 Pioneertown Pioneertown 2021-04-10 San Bernardino 71 9   365
957 Piñon Hills Piñon Hills 2021-04-10 San Bernardino 71 415   8042
958 Rancho Cucamonga Rancho Cucamonga 2021-04-10 San Bernardino 71 18155   177037
959 Redlands Redlands 2021-04-10 San Bernardino 71 8676   72099
960 Rialto Rialto 2021-04-10 San Bernardino 71 18437   103884
961 Rimforest Rimforest 2021-04-10 San Bernardino 71 45   756
962 Running Springs Running Springs 2021-04-10 San Bernardino 71 282   4661
963 San Bernardino San Bernardino 2021-04-10 San Bernardino 71 40257   218515
964 Sugarloaf Sugarloaf 2021-04-10 San Bernardino 71 92   3137
965 Trona Trona 2021-04-10 San Bernardino 71 42   1191
966 Twentynine Palms Twentynine Palms 2021-04-10 San Bernardino 71 1073   24966
967 Twin Peaks Twin Peaks 2021-04-10 San Bernardino 71 127   2493
968 Upland Upland 2021-04-10 San Bernardino 71 8511   78249
969 Victorville Victorville 2021-04-10 San Bernardino 71 20901   128353
970 Wrightwood Wrightwood 2021-04-10 San Bernardino 71 328   5177
971 Yermo Yermo 2021-04-10 San Bernardino 71 82   1672
972 Yucaipa Yucaipa 2021-04-10 San Bernardino 71 5600   54490
973 Yucca Valley Yucca Valley 2021-04-10 San Bernardino 71 1475   22146
2277 Adelanto Adelanto 2021-04-09 San Bernardino 71 5353   35234
2278 Angelus Oaks Angelus Oaks 2021-04-09 San Bernardino 71 38   385
2279 Apple Valley Apple Valley 2021-04-09 San Bernardino 71 9264   73694
2280 Arrowbear Arrowbear 2021-04-09 San Bernardino 71 5   723
2281 Baker Baker 2021-04-09 San Bernardino 71 56   799
2282 Barstow Barstow 2021-04-09 San Bernardino 71 3439   23754
2283 Big Bear City Big Bear City 2021-04-09 San Bernardino 71 555   10045
2284 Big Bear Lake Big Bear Lake 2021-04-09 San Bernardino 71 385   5231
2285 Big River Big River 2021-04-09 San Bernardino 71 20   1264
2286 Bloomington Bloomington 2021-04-09 San Bernardino 71 5994   17115
2287 Blue Jay Blue Jay 2021-04-09 San Bernardino 71 151   900
2288 Cedar Glen Cedar Glen 2021-04-09 San Bernardino 71 7   739
2289 Chino Chino 2021-04-09 San Bernardino 71 13079   93099
2290 Chino Hills Chino Hills 2021-04-09 San Bernardino 71 5770   82917
2291 Colton Colton 2021-04-09 San Bernardino 71 10186   54636
2292 Crestline Crestline 2021-04-09 San Bernardino 71 632   8010
2293 Daggett Daggett 2021-04-09 San Bernardino 71 20   549
2294 Devore Devore 2021-04-09 San Bernardino 71 2   2283
2295 Fawnskin Fawnskin 2021-04-09 San Bernardino 71 21   528
2296 Fontana Fontana 2021-04-09 San Bernardino 71 39377   215334
2297 Forest Falls Forest Falls 2021-04-09 San Bernardino 71 38   920
2298 Grand Terrace Grand Terrace 2021-04-09 San Bernardino 71 1610   12403
2299 Green Valley Lake Green Valley Lake 2021-04-09 San Bernardino 71 13   412
2300 Havasu Havasu 2021-04-09 San Bernardino 71 5   0
2301 Helendale Helendale 2021-04-09 San Bernardino 71 519   6629
2302 Hesperia Hesperia 2021-04-09 San Bernardino 71 13777   97312
2303 Highland Highland 2021-04-09 San Bernardino 71 8003   55484
2304 Hinkley Hinkley 2021-04-09 San Bernardino 71 55   1259
2305 Joshua Tree Joshua Tree 2021-04-09 San Bernardino 71 333   9887
2306 Lake Arrowhead Lake Arrowhead 2021-04-09 San Bernardino 71 457   8104
2307 Landers Landers 2021-04-09 San Bernardino 71 59   2983
2308 Loma Linda Loma Linda 2021-04-09 San Bernardino 71 2654   25260
2309 Lucerne Valley Lucerne Valley 2021-04-09 San Bernardino 71 347   7041
2310 Lytle Creek Lytle Creek 2021-04-09 San Bernardino 71 73   837
2311 Mentone Mentone 2021-04-09 San Bernardino 71 1090   9255
2312 Montclair Montclair 2021-04-09 San Bernardino 71 6111   40415

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);