home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ 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

55,360 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 1

  • 71 · 55,360 ✖

county 1

  • San Bernardino 55,360
Link rowid id name date ▲ county fips confirmed_cases note population
834 834 Adelanto Adelanto 2022-08-11 San Bernardino 71 10822   35234
835 835 Angelus Oaks Angelus Oaks 2022-08-11 San Bernardino 71 97   385
836 836 Apple Valley Apple Valley 2022-08-11 San Bernardino 71 21871   73694
837 837 Arrowbear Arrowbear 2022-08-11 San Bernardino 71 11   723
838 838 Baker Baker 2022-08-11 San Bernardino 71 108   799
839 839 Barstow Barstow 2022-08-11 San Bernardino 71 7594   23754
840 840 Big Bear City Big Bear City 2022-08-11 San Bernardino 71 1541   10045
841 841 Big Bear Lake Big Bear Lake 2022-08-11 San Bernardino 71 1022   5231
842 842 Big River Big River 2022-08-11 San Bernardino 71 51   1264
843 843 Bloomington Bloomington 2022-08-11 San Bernardino 71 11504   17115
844 844 Blue Jay Blue Jay 2022-08-11 San Bernardino 71 366   900
845 845 Cedar Glen Cedar Glen 2022-08-11 San Bernardino 71 7   739
846 846 Chino Chino 2022-08-11 San Bernardino 71 30359   93099
847 847 Chino Hills Chino Hills 2022-08-11 San Bernardino 71 17782   82917
848 848 Colton Colton 2022-08-11 San Bernardino 71 20122   54636
849 849 Crestline Crestline 2022-08-11 San Bernardino 71 1649   8010
850 850 Daggett Daggett 2022-08-11 San Bernardino 71 65   549
851 851 Devore Devore 2022-08-11 San Bernardino 71 2   2283
852 852 Fawnskin Fawnskin 2022-08-11 San Bernardino 71 76   528
853 853 Fontana Fontana 2022-08-11 San Bernardino 71 80480   215334
854 854 Forest Falls Forest Falls 2022-08-11 San Bernardino 71 145   920
855 855 Grand Terrace Grand Terrace 2022-08-11 San Bernardino 71 3818   12403
856 856 Green Valley Lake Green Valley Lake 2022-08-11 San Bernardino 71 42   412
857 857 Havasu Lake Havasu Lake 2022-08-11 San Bernardino 71 100   0
858 858 Helendale Helendale 2022-08-11 San Bernardino 71 1252   6629
859 859 Hesperia Hesperia 2022-08-11 San Bernardino 71 28216   97312
860 860 Highland Highland 2022-08-11 San Bernardino 71 16868   55484
861 861 Hinkley Hinkley 2022-08-11 San Bernardino 71 129   1259
862 862 Joshua Tree Joshua Tree 2022-08-11 San Bernardino 71 1342   9887
863 863 Lake Arrowhead Lake Arrowhead 2022-08-11 San Bernardino 71 1048   8104
864 864 Landers Landers 2022-08-11 San Bernardino 71 212   2983
865 865 Loma Linda Loma Linda 2022-08-11 San Bernardino 71 6881   25260
866 866 Lucerne Valley Lucerne Valley 2022-08-11 San Bernardino 71 852   7041
867 867 Lytle Creek Lytle Creek 2022-08-11 San Bernardino 71 172   837
868 868 Mentone Mentone 2022-08-11 San Bernardino 71 2560   9255
869 869 Montclair Montclair 2022-08-11 San Bernardino 71 13292   40415
870 870 Morongo Valley Morongo Valley 2022-08-11 San Bernardino 71 517   3739
871 871 Mt Baldy Mt Baldy 2022-08-11 San Bernardino 71 7   537
872 872 Muscoy Muscoy 2022-08-11 San Bernardino 71 255   11536
873 873 Needles Needles 2022-08-11 San Bernardino 71 726   4964
874 874 Newberry Springs Newberry Springs 2022-08-11 San Bernardino 71 274   2215
875 875 Oak Glen Oak Glen 2022-08-11 San Bernardino 71 35   625
876 876 Oak Hills Oak Hills 2022-08-11 San Bernardino 71 3178   9488
877 877 Ontario Ontario 2022-08-11 San Bernardino 71 55103   182380
878 878 Oro Grande Oro Grande 2022-08-11 San Bernardino 71 209   1137
879 879 Phelan Phelan 2022-08-11 San Bernardino 71 3623   14757
880 880 Pinon Hills Pinon Hills 2022-08-11 San Bernardino 71 1049   8042
881 881 Pioneertown Pioneertown 2022-08-11 San Bernardino 71 51   365
882 882 Rancho Cucamonga Rancho Cucamonga 2022-08-11 San Bernardino 71 45954   177037
883 883 Redlands Redlands 2022-08-11 San Bernardino 71 21318   72099
884 884 Rialto Rialto 2022-08-11 San Bernardino 71 36232   103884
885 885 Rimforest Rimforest 2022-08-11 San Bernardino 71 105   756
886 886 Running Springs Running Springs 2022-08-11 San Bernardino 71 778   4661
887 887 San Bernardino San Bernardino 2022-08-11 San Bernardino 71 81102   218515
888 888 Sugarloaf Sugarloaf 2022-08-11 San Bernardino 71 326   3137
889 889 Trona Trona 2022-08-11 San Bernardino 71 113   1191
890 890 Twentynine Palms Twentynine Palms 2022-08-11 San Bernardino 71 3621   24966
891 891 Twin Peaks Twin Peaks 2022-08-11 San Bernardino 71 313   2493
892 892 Upland Upland 2022-08-11 San Bernardino 71 20640   78249
893 893 Victorville Victorville 2022-08-11 San Bernardino 71 45148   128353
894 894 Wrightwood Wrightwood 2022-08-11 San Bernardino 71 829   5177
895 895 Yermo Yermo 2022-08-11 San Bernardino 71 193   1672
896 896 Yucaipa Yucaipa 2022-08-11 San Bernardino 71 13852   54490
897 897 Yucca Valley Yucca Valley 2022-08-11 San Bernardino 71 4735   22146
2105 2105 Adelanto Adelanto 2022-08-10 San Bernardino 71 10822   35234
2106 2106 Angelus Oaks Angelus Oaks 2022-08-10 San Bernardino 71 97   385
2107 2107 Apple Valley Apple Valley 2022-08-10 San Bernardino 71 21871   73694
2108 2108 Arrowbear Arrowbear 2022-08-10 San Bernardino 71 11   723
2109 2109 Baker Baker 2022-08-10 San Bernardino 71 108   799
2110 2110 Barstow Barstow 2022-08-10 San Bernardino 71 7594   23754
2111 2111 Big Bear City Big Bear City 2022-08-10 San Bernardino 71 1541   10045
2112 2112 Big Bear Lake Big Bear Lake 2022-08-10 San Bernardino 71 1022   5231
2113 2113 Big River Big River 2022-08-10 San Bernardino 71 51   1264
2114 2114 Bloomington Bloomington 2022-08-10 San Bernardino 71 11504   17115
2115 2115 Blue Jay Blue Jay 2022-08-10 San Bernardino 71 366   900
2116 2116 Cedar Glen Cedar Glen 2022-08-10 San Bernardino 71 7   739
2117 2117 Chino Chino 2022-08-10 San Bernardino 71 30359   93099
2118 2118 Chino Hills Chino Hills 2022-08-10 San Bernardino 71 17782   82917
2119 2119 Colton Colton 2022-08-10 San Bernardino 71 20122   54636
2120 2120 Crestline Crestline 2022-08-10 San Bernardino 71 1649   8010
2121 2121 Daggett Daggett 2022-08-10 San Bernardino 71 65   549
2122 2122 Devore Devore 2022-08-10 San Bernardino 71 2   2283
2123 2123 Fawnskin Fawnskin 2022-08-10 San Bernardino 71 76   528
2124 2124 Fontana Fontana 2022-08-10 San Bernardino 71 80480   215334
2125 2125 Forest Falls Forest Falls 2022-08-10 San Bernardino 71 145   920
2126 2126 Grand Terrace Grand Terrace 2022-08-10 San Bernardino 71 3818   12403
2127 2127 Green Valley Lake Green Valley Lake 2022-08-10 San Bernardino 71 42   412
2128 2128 Havasu Lake Havasu Lake 2022-08-10 San Bernardino 71 100   0
2129 2129 Helendale Helendale 2022-08-10 San Bernardino 71 1252   6629
2130 2130 Hesperia Hesperia 2022-08-10 San Bernardino 71 28216   97312
2131 2131 Highland Highland 2022-08-10 San Bernardino 71 16868   55484
2132 2132 Hinkley Hinkley 2022-08-10 San Bernardino 71 129   1259
2133 2133 Joshua Tree Joshua Tree 2022-08-10 San Bernardino 71 1342   9887
2134 2134 Lake Arrowhead Lake Arrowhead 2022-08-10 San Bernardino 71 1048   8104
2135 2135 Landers Landers 2022-08-10 San Bernardino 71 212   2983
2136 2136 Loma Linda Loma Linda 2022-08-10 San Bernardino 71 6881   25260
2137 2137 Lucerne Valley Lucerne Valley 2022-08-10 San Bernardino 71 852   7041
2138 2138 Lytle Creek Lytle Creek 2022-08-10 San Bernardino 71 172   837
2139 2139 Mentone Mentone 2022-08-10 San Bernardino 71 2560   9255
2140 2140 Montclair Montclair 2022-08-10 San Bernardino 71 13292   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
);
Powered by Datasette · Queries took 1570.105ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals