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,320 rows where fips = 65 sorted by date descending

✎ View and edit SQL

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

fips

  • 65 · 24,320 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
838 838 Anza Anza 2021-04-10 Riverside 65 148   3151
839 839 Banning Banning 2021-04-10 Riverside 65 3193   30942
840 840 Beaumont Beaumont 2021-04-10 Riverside 65 6062   45403
841 841 Bermuda Dunes Bermuda Dunes 2021-04-10 Riverside 65 644   6817
842 842 Blythe Blythe 2021-04-10 Riverside 65 1371   19581
843 843 Cabazon Cabazon 2021-04-10 Riverside 65 314   3367
844 844 Calimesa Calimesa 2021-04-10 Riverside 65 907   8651
845 845 Canyon Lake Canyon Lake 2021-04-10 Riverside 65 950   11106
846 846 Cathedral City Cathedral City 2021-04-10 Riverside 65 7066   54037
847 847 Cherry Valley Cherry Valley 2021-04-10 Riverside 65 518   7755
848 848 Coachella Coachella 2021-04-10 Riverside 65 7873   44849
849 849 Corona Corona 2021-04-10 Riverside 65 17264   165355
850 850 Coronita Coronita 2021-04-10 Riverside 65 352   3138
851 851 Desert Edge Desert Edge 2021-04-10 Riverside 65 342   3343
852 852 Desert Hot Springs Desert Hot Springs 2021-04-10 Riverside 65 4175   28430
853 853 Desert Palms Desert Palms 2021-04-10 Riverside 65 255   6947
854 854 East Hemet East Hemet 2021-04-10 Riverside 65 2062   20679
855 855 Eastvale Eastvale 2021-04-10 Riverside 65 7196   61337
856 856 El Cerrito El Cerrito 2021-04-10 Riverside 65 675   5471
857 857 El Sobrante El Sobrante 2021-04-10 Riverside 65 1762   13966
858 858 French Valley French Valley 2021-04-10 Riverside 65 2325   33818
859 859 Garnet Garnet 2021-04-10 Riverside 65 889   5057
860 860 Good Hope Good Hope 2021-04-10 Riverside 65 1488   9173
861 861 Green Acres Green Acres 2021-04-10 Riverside 65 250   2542
862 862 Hemet Hemet 2021-04-10 Riverside 65 9269   84069
863 863 Highgrove Highgrove 2021-04-10 Riverside 65 773   4986
864 864 Home Gardens Home Gardens 2021-04-10 Riverside 65 1692   11442
865 865 Homeland Homeland 2021-04-10 Riverside 65 662   7326
866 866 Idyllwild-Pine Cove Idyllwild-Pine Cove 2021-04-10 Riverside 65 114   2459
867 867 Indian Wells Indian Wells 2021-04-10 Riverside 65 192   5317
868 868 Indio Indio 2021-04-10 Riverside 65 12207   88291
869 869 Jurupa Valley Jurupa Valley 2021-04-10 Riverside 65 16268   103784
870 870 La Quinta La Quinta 2021-04-10 Riverside 65 3387   40704
871 871 Lake Elsinore Lake Elsinore 2021-04-10 Riverside 65 7238   64037
872 872 Lake Mathews Lake Mathews 2021-04-10 Riverside 65 561   6848
873 873 Lakeland Village Lakeland Village 2021-04-10 Riverside 65 1153   13170
874 874 Lakeview Lakeview 2021-04-10 Riverside 65 269   2566
875 875 Mead Valley Mead Valley 2021-04-10 Riverside 65 3217   19925
876 876 Meadowbrook Meadowbrook 2021-04-10 Riverside 65 259   3033
877 877 Mecca Mecca 2021-04-10 Riverside 65 1133   7174
878 878 Menifee Menifee 2021-04-10 Riverside 65 9698   88515
879 879 Moreno Valley Moreno Valley 2021-04-10 Riverside 65 32878   205034
880 880 Murrieta Murrieta 2021-04-10 Riverside 65 8539   111427
881 881 Norco Norco 2021-04-10 Riverside 65 2404   26569
882 882 North Shore North Shore 2021-04-10 Riverside 65 357   2892
883 883 Nuevo Nuevo 2021-04-10 Riverside 65 1023   7033
884 884 Oasis Oasis 2021-04-10 Riverside 65 878   3020
885 885 Palm Desert Palm Desert 2021-04-10 Riverside 65 3903   52124
886 886 Palm Springs Palm Springs 2021-04-10 Riverside 65 3703   47525
887 887 Perris Perris 2021-04-10 Riverside 65 13386   76276
888 888 Rancho Mirage Rancho Mirage 2021-04-10 Riverside 65 1091   18075
889 889 Riverside Riverside 2021-04-10 Riverside 65 47299   323935
890 890 Romoland Romoland 2021-04-10 Riverside 65 237   2227
891 891 San Jacinto San Jacinto 2021-04-10 Riverside 65 6595   47474
892 892 Sky Valley Sky Valley 2021-04-10 Riverside 65 220   2430
893 893 Temecula Temecula 2021-04-10 Riverside 65 7372   112230
894 894 Temescal Valley Temescal Valley 2021-04-10 Riverside 65 2494   26709
895 895 Thermal Thermal 2021-04-10 Riverside 65 469   1359
896 896 Thousand Palms Thousand Palms 2021-04-10 Riverside 65 1041   7814
897 897 Valle Vista Valle Vista 2021-04-10 Riverside 65 1476   16879
898 898 Vista Santa Rosa Vista Santa Rosa 2021-04-10 Riverside 65 303   2967
899 899 Wildomar Wildomar 2021-04-10 Riverside 65 3515   36162
900 900 Winchester Winchester 2021-04-10 Riverside 65 189   2931
901 901 Woodcrest Woodcrest 2021-04-10 Riverside 65 1732   17310
2205 2205 Anza Anza 2021-04-09 Riverside 65 148   3151
2206 2206 Banning Banning 2021-04-09 Riverside 65 3193   30942
2207 2207 Beaumont Beaumont 2021-04-09 Riverside 65 6062   45403
2208 2208 Bermuda Dunes Bermuda Dunes 2021-04-09 Riverside 65 644   6817
2209 2209 Blythe Blythe 2021-04-09 Riverside 65 1371   19581
2210 2210 Cabazon Cabazon 2021-04-09 Riverside 65 314   3367
2211 2211 Calimesa Calimesa 2021-04-09 Riverside 65 907   8651
2212 2212 Canyon Lake Canyon Lake 2021-04-09 Riverside 65 950   11106
2213 2213 Cathedral City Cathedral City 2021-04-09 Riverside 65 7066   54037
2214 2214 Cherry Valley Cherry Valley 2021-04-09 Riverside 65 518   7755
2215 2215 Coachella Coachella 2021-04-09 Riverside 65 7873   44849
2216 2216 Corona Corona 2021-04-09 Riverside 65 17264   165355
2217 2217 Coronita Coronita 2021-04-09 Riverside 65 352   3138
2218 2218 Desert Edge Desert Edge 2021-04-09 Riverside 65 342   3343
2219 2219 Desert Hot Springs Desert Hot Springs 2021-04-09 Riverside 65 4175   28430
2220 2220 Desert Palms Desert Palms 2021-04-09 Riverside 65 255   6947
2221 2221 East Hemet East Hemet 2021-04-09 Riverside 65 2062   20679
2222 2222 Eastvale Eastvale 2021-04-09 Riverside 65 7196   61337
2223 2223 El Cerrito El Cerrito 2021-04-09 Riverside 65 675   5471
2224 2224 El Sobrante El Sobrante 2021-04-09 Riverside 65 1762   13966
2225 2225 French Valley French Valley 2021-04-09 Riverside 65 2325   33818
2226 2226 Garnet Garnet 2021-04-09 Riverside 65 889   5057
2227 2227 Good Hope Good Hope 2021-04-09 Riverside 65 1488   9173
2228 2228 Green Acres Green Acres 2021-04-09 Riverside 65 250   2542
2229 2229 Hemet Hemet 2021-04-09 Riverside 65 9269   84069
2230 2230 Highgrove Highgrove 2021-04-09 Riverside 65 773   4986
2231 2231 Home Gardens Home Gardens 2021-04-09 Riverside 65 1692   11442
2232 2232 Homeland Homeland 2021-04-09 Riverside 65 662   7326
2233 2233 Idyllwild-Pine Cove Idyllwild-Pine Cove 2021-04-09 Riverside 65 114   2459
2234 2234 Indian Wells Indian Wells 2021-04-09 Riverside 65 192   5317
2235 2235 Indio Indio 2021-04-09 Riverside 65 12207   88291
2236 2236 Jurupa Valley Jurupa Valley 2021-04-09 Riverside 65 16268   103784
2237 2237 La Quinta La Quinta 2021-04-09 Riverside 65 3387   40704
2238 2238 Lake Elsinore Lake Elsinore 2021-04-09 Riverside 65 7238   64037
2239 2239 Lake Mathews Lake Mathews 2021-04-09 Riverside 65 561   6848
2240 2240 Lakeland Village Lakeland Village 2021-04-09 Riverside 65 1153   13170

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
);