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

36,928 rows where fips = 71 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 71 · 36,928 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
911 911 Adelanto Adelanto 2021-10-27 San Bernardino 71 6581   35234
912 912 Angelus Oaks Angelus Oaks 2021-10-27 San Bernardino 71 49   385
913 913 Apple Valley Apple Valley 2021-10-27 San Bernardino 71 12288   73694
914 914 Arrowbear Arrowbear 2021-10-27 San Bernardino 71 7   723
915 915 Baker Baker 2021-10-27 San Bernardino 71 59   799
916 916 Barstow Barstow 2021-10-27 San Bernardino 71 4298   23754
917 917 Big Bear City Big Bear City 2021-10-27 San Bernardino 71 895   10045
918 918 Big Bear Lake Big Bear Lake 2021-10-27 San Bernardino 71 579   5231
919 919 Big River Big River 2021-10-27 San Bernardino 71 25   1264
920 920 Bloomington Bloomington 2021-10-27 San Bernardino 71 6917   17115
921 921 Blue Jay Blue Jay 2021-10-27 San Bernardino 71 205   900
922 922 Cedar Glen Cedar Glen 2021-10-27 San Bernardino 71 7   739
923 923 Chino Chino 2021-10-27 San Bernardino 71 15650   93099
924 924 Chino Hills Chino Hills 2021-10-27 San Bernardino 71 7399   82917
925 925 Colton Colton 2021-10-27 San Bernardino 71 11710   54636
926 926 Crestline Crestline 2021-10-27 San Bernardino 71 851   8010
927 927 Daggett Daggett 2021-10-27 San Bernardino 71 33   549
928 928 Devore Devore 2021-10-27 San Bernardino 71 2   2283
929 929 Fawnskin Fawnskin 2021-10-27 San Bernardino 71 31   528
930 930 Fontana Fontana 2021-10-27 San Bernardino 71 46021   215334
931 931 Forest Falls Forest Falls 2021-10-27 San Bernardino 71 54   920
932 932 Grand Terrace Grand Terrace 2021-10-27 San Bernardino 71 2004   12403
933 933 Green Valley Lake Green Valley Lake 2021-10-27 San Bernardino 71 20   412
934 934 Havasu Havasu 2021-10-27 San Bernardino 71 42   0
935 935 Helendale Helendale 2021-10-27 San Bernardino 71 641   6629
936 936 Hesperia Hesperia 2021-10-27 San Bernardino 71 16861   97312
937 937 Highland Highland 2021-10-27 San Bernardino 71 9582   55484
938 938 Hinkley Hinkley 2021-10-27 San Bernardino 71 70   1259
939 939 Joshua Tree Joshua Tree 2021-10-27 San Bernardino 71 577   9887
940 940 Lake Arrowhead Lake Arrowhead 2021-10-27 San Bernardino 71 604   8104
941 941 Landers Landers 2021-10-27 San Bernardino 71 87   2983
942 942 Loma Linda Loma Linda 2021-10-27 San Bernardino 71 3167   25260
943 943 Lucerne Valley Lucerne Valley 2021-10-27 San Bernardino 71 476   7041
944 944 Lytle Creek Lytle Creek 2021-10-27 San Bernardino 71 85   837
945 945 Mentone Mentone 2021-10-27 San Bernardino 71 1353   9255
946 946 Montclair Montclair 2021-10-27 San Bernardino 71 7035   40415
947 947 Morongo Valley Morongo Valley 2021-10-27 San Bernardino 71 251   3739
948 948 Mt Baldy Mt Baldy 2021-10-27 San Bernardino 71 2   537
949 949 Muscoy Muscoy 2021-10-27 San Bernardino 71 123   11536
950 950 Needles Needles 2021-10-27 San Bernardino 71 485   4964
951 951 Newberry Springs Newberry Springs 2021-10-27 San Bernardino 71 171   2215
952 952 Oak Glen Oak Glen 2021-10-27 San Bernardino 71 18   625
953 953 Oak Hills Oak Hills 2021-10-27 San Bernardino 71 1948   9488
954 954 Ontario Ontario 2021-10-27 San Bernardino 71 30397   182380
955 955 Oro Grande Oro Grande 2021-10-27 San Bernardino 71 155   1137
956 956 Phelan Phelan 2021-10-27 San Bernardino 71 2061   14757
957 957 Pioneertown Pioneertown 2021-10-27 San Bernardino 71 15   365
958 958 Piñon Hills Piñon Hills 2021-10-27 San Bernardino 71 573   8042
959 959 Rancho Cucamonga Rancho Cucamonga 2021-10-27 San Bernardino 71 23018   177037
960 960 Redlands Redlands 2021-10-27 San Bernardino 71 10665   72099
961 961 Rialto Rialto 2021-10-27 San Bernardino 71 21461   103884
962 962 Rimforest Rimforest 2021-10-27 San Bernardino 71 57   756
963 963 Running Springs Running Springs 2021-10-27 San Bernardino 71 408   4661
964 964 San Bernardino San Bernardino 2021-10-27 San Bernardino 71 47225   218515
965 965 Sugarloaf Sugarloaf 2021-10-27 San Bernardino 71 162   3137
966 966 Trona Trona 2021-10-27 San Bernardino 71 54   1191
967 967 Twentynine Palms Twentynine Palms 2021-10-27 San Bernardino 71 1849   24966
968 968 Twin Peaks Twin Peaks 2021-10-27 San Bernardino 71 180   2493
969 969 Upland Upland 2021-10-27 San Bernardino 71 10333   78249
970 970 Victorville Victorville 2021-10-27 San Bernardino 71 25953   128353
971 971 Wrightwood Wrightwood 2021-10-27 San Bernardino 71 432   5177
972 972 Yermo Yermo 2021-10-27 San Bernardino 71 107   1672
973 973 Yucaipa Yucaipa 2021-10-27 San Bernardino 71 7298   54490
974 974 Yucca Valley Yucca Valley 2021-10-27 San Bernardino 71 2238   22146
2276 2276 Adelanto Adelanto 2021-10-26 San Bernardino 71 6576   35234
2277 2277 Angelus Oaks Angelus Oaks 2021-10-26 San Bernardino 71 49   385
2278 2278 Apple Valley Apple Valley 2021-10-26 San Bernardino 71 12283   73694
2279 2279 Arrowbear Arrowbear 2021-10-26 San Bernardino 71 7   723
2280 2280 Baker Baker 2021-10-26 San Bernardino 71 59   799
2281 2281 Barstow Barstow 2021-10-26 San Bernardino 71 4297   23754
2282 2282 Big Bear City Big Bear City 2021-10-26 San Bernardino 71 894   10045
2283 2283 Big Bear Lake Big Bear Lake 2021-10-26 San Bernardino 71 579   5231
2284 2284 Big River Big River 2021-10-26 San Bernardino 71 25   1264
2285 2285 Bloomington Bloomington 2021-10-26 San Bernardino 71 6914   17115
2286 2286 Blue Jay Blue Jay 2021-10-26 San Bernardino 71 205   900
2287 2287 Cedar Glen Cedar Glen 2021-10-26 San Bernardino 71 7   739
2288 2288 Chino Chino 2021-10-26 San Bernardino 71 15643   93099
2289 2289 Chino Hills Chino Hills 2021-10-26 San Bernardino 71 7397   82917
2290 2290 Colton Colton 2021-10-26 San Bernardino 71 11707   54636
2291 2291 Crestline Crestline 2021-10-26 San Bernardino 71 850   8010
2292 2292 Daggett Daggett 2021-10-26 San Bernardino 71 33   549
2293 2293 Devore Devore 2021-10-26 San Bernardino 71 2   2283
2294 2294 Fawnskin Fawnskin 2021-10-26 San Bernardino 71 31   528
2295 2295 Fontana Fontana 2021-10-26 San Bernardino 71 46014   215334
2296 2296 Forest Falls Forest Falls 2021-10-26 San Bernardino 71 54   920
2297 2297 Grand Terrace Grand Terrace 2021-10-26 San Bernardino 71 2004   12403
2298 2298 Green Valley Lake Green Valley Lake 2021-10-26 San Bernardino 71 20   412
2299 2299 Havasu Havasu 2021-10-26 San Bernardino 71 42   0
2300 2300 Helendale Helendale 2021-10-26 San Bernardino 71 638   6629
2301 2301 Hesperia Hesperia 2021-10-26 San Bernardino 71 16850   97312
2302 2302 Highland Highland 2021-10-26 San Bernardino 71 9582   55484
2303 2303 Hinkley Hinkley 2021-10-26 San Bernardino 71 70   1259
2304 2304 Joshua Tree Joshua Tree 2021-10-26 San Bernardino 71 577   9887
2305 2305 Lake Arrowhead Lake Arrowhead 2021-10-26 San Bernardino 71 604   8104
2306 2306 Landers Landers 2021-10-26 San Bernardino 71 87   2983
2307 2307 Loma Linda Loma Linda 2021-10-26 San Bernardino 71 3166   25260
2308 2308 Lucerne Valley Lucerne Valley 2021-10-26 San Bernardino 71 475   7041
2309 2309 Lytle Creek Lytle Creek 2021-10-26 San Bernardino 71 85   837
2310 2310 Mentone Mentone 2021-10-26 San Bernardino 71 1350   9255
2311 2311 Montclair Montclair 2021-10-26 San Bernardino 71 7032   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
);