latimes_place_totals

Table actions
⚠️ 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 county = "San Bernardino" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips

  • 71 24,128

county

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