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

56,064 rows where fips = 65 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 65 · 56,064 ✖

county 1

Link rowid id name date ▲ county fips confirmed_cases note population
762 762 Anza Anza 2022-08-19 Riverside 65 430   3151
763 763 Banning Banning 2022-08-19 Riverside 65 7201   30942
764 764 Beaumont Beaumont 2022-08-19 Riverside 65 14960   45403
765 765 Bermuda Dunes Bermuda Dunes 2022-08-19 Riverside 65 1657   6817
766 766 Blythe Blythe 2022-08-19 Riverside 65 3835   19581
767 767 Cabazon Cabazon 2022-08-19 Riverside 65 756   3367
768 768 Calimesa Calimesa 2022-08-19 Riverside 65 2435   8651
769 769 Canyon Lake Canyon Lake 2022-08-19 Riverside 65 2280   11106
770 770 Cathedral City Cathedral City 2022-08-19 Riverside 65 13649   54037
771 771 Cherry Valley Cherry Valley 2022-08-19 Riverside 65 1292   7755
772 772 Coachella Coachella 2022-08-19 Riverside 65 13938   44849
773 773 Corona Corona 2022-08-19 Riverside 65 41391   165355
774 774 Coronita Coronita 2022-08-19 Riverside 65 720   3138
775 775 Desert Edge Desert Edge 2022-08-19 Riverside 65 706   3343
776 776 Desert Hot Springs Desert Hot Springs 2022-08-19 Riverside 65 8399   28430
777 777 Desert Palms Desert Palms 2022-08-19 Riverside 65 825   6947
778 778 East Hemet East Hemet 2022-08-19 Riverside 65 4962   20679
779 779 Eastvale Eastvale 2022-08-19 Riverside 65 18011   61337
780 780 El Cerrito El Cerrito 2022-08-19 Riverside 65 1438   5471
781 781 El Sobrante El Sobrante 2022-08-19 Riverside 65 4567   13966
782 782 French Valley French Valley 2022-08-19 Riverside 65 6839   33818
783 783 Garnet Garnet 2022-08-19 Riverside 65 1593   5057
784 784 Good Hope Good Hope 2022-08-19 Riverside 65 3052   9173
785 785 Green Acres Green Acres 2022-08-19 Riverside 65 624   2542
786 786 Hemet Hemet 2022-08-19 Riverside 65 22311   84069
787 787 Highgrove Highgrove 2022-08-19 Riverside 65 1804   4986
788 788 Home Gardens Home Gardens 2022-08-19 Riverside 65 3400   11442
789 789 Homeland Homeland 2022-08-19 Riverside 65 1546   7326
790 790 Idyllwild-Pine Cove Idyllwild-Pine Cove 2022-08-19 Riverside 65 345   2459
791 791 Indian Wells Indian Wells 2022-08-19 Riverside 65 691   5317
792 792 Indio Indio 2022-08-19 Riverside 65 24761   88291
793 793 Jurupa Valley Jurupa Valley 2022-08-19 Riverside 65 32054   103784
794 794 La Quinta La Quinta 2022-08-19 Riverside 65 9118   40704
795 795 Lake Elsinore Lake Elsinore 2022-08-19 Riverside 65 18945   64037
796 796 Lake Mathews Lake Mathews 2022-08-19 Riverside 65 1385   6848
797 797 Lakeland Village Lakeland Village 2022-08-19 Riverside 65 2782   13170
798 798 Lakeview Lakeview 2022-08-19 Riverside 65 603   2566
799 799 Mead Valley Mead Valley 2022-08-19 Riverside 65 6305   19925
800 800 Meadowbrook Meadowbrook 2022-08-19 Riverside 65 674   3033
801 801 Mecca Mecca 2022-08-19 Riverside 65 1997   7174
802 802 Menifee Menifee 2022-08-19 Riverside 65 25674   88515
803 803 Moreno Valley Moreno Valley 2022-08-19 Riverside 65 72971   205034
804 804 Murrieta Murrieta 2022-08-19 Riverside 65 24790   111427
805 805 Norco Norco 2022-08-19 Riverside 65 5577   26569
806 806 North Shore North Shore 2022-08-19 Riverside 65 745   2892
807 807 Nuevo Nuevo 2022-08-19 Riverside 65 2290   7033
808 808 Oasis Oasis 2022-08-19 Riverside 65 1671   3020
809 809 Palm Desert Palm Desert 2022-08-19 Riverside 65 10655   52124
810 810 Palm Springs Palm Springs 2022-08-19 Riverside 65 8954   47525
811 811 Perris Perris 2022-08-19 Riverside 65 28290   76276
812 812 Rancho Mirage Rancho Mirage 2022-08-19 Riverside 65 3149   18075
813 813 Riverside Riverside 2022-08-19 Riverside 65 102746   323935
814 814 Romoland Romoland 2022-08-19 Riverside 65 511   2227
815 815 San Jacinto San Jacinto 2022-08-19 Riverside 65 15152   47474
816 816 Sky Valley Sky Valley 2022-08-19 Riverside 65 480   2430
817 817 Temecula Temecula 2022-08-19 Riverside 65 21061   112230
818 818 Temescal Valley Temescal Valley 2022-08-19 Riverside 65 7230   26709
819 819 Thermal Thermal 2022-08-19 Riverside 65 820   1359
820 820 Thousand Palms Thousand Palms 2022-08-19 Riverside 65 2017   7814
821 821 Valle Vista Valle Vista 2022-08-19 Riverside 65 3723   16879
822 822 Vista Santa Rosa Vista Santa Rosa 2022-08-19 Riverside 65 630   2967
823 823 Wildomar Wildomar 2022-08-19 Riverside 65 8824   36162
824 824 Winchester Winchester 2022-08-19 Riverside 65 423   2931
825 825 Woodcrest Woodcrest 2022-08-19 Riverside 65 3959   17310
1985 1985 Anza Anza 2022-08-18 Riverside 65 430   3151
1986 1986 Banning Banning 2022-08-18 Riverside 65 7201   30942
1987 1987 Beaumont Beaumont 2022-08-18 Riverside 65 14960   45403
1988 1988 Bermuda Dunes Bermuda Dunes 2022-08-18 Riverside 65 1657   6817
1989 1989 Blythe Blythe 2022-08-18 Riverside 65 3835   19581
1990 1990 Cabazon Cabazon 2022-08-18 Riverside 65 756   3367
1991 1991 Calimesa Calimesa 2022-08-18 Riverside 65 2435   8651
1992 1992 Canyon Lake Canyon Lake 2022-08-18 Riverside 65 2280   11106
1993 1993 Cathedral City Cathedral City 2022-08-18 Riverside 65 13649   54037
1994 1994 Cherry Valley Cherry Valley 2022-08-18 Riverside 65 1292   7755
1995 1995 Coachella Coachella 2022-08-18 Riverside 65 13938   44849
1996 1996 Corona Corona 2022-08-18 Riverside 65 41391   165355
1997 1997 Coronita Coronita 2022-08-18 Riverside 65 720   3138
1998 1998 Desert Edge Desert Edge 2022-08-18 Riverside 65 706   3343
1999 1999 Desert Hot Springs Desert Hot Springs 2022-08-18 Riverside 65 8399   28430
2000 2000 Desert Palms Desert Palms 2022-08-18 Riverside 65 825   6947
2001 2001 East Hemet East Hemet 2022-08-18 Riverside 65 4962   20679
2002 2002 Eastvale Eastvale 2022-08-18 Riverside 65 18011   61337
2003 2003 El Cerrito El Cerrito 2022-08-18 Riverside 65 1438   5471
2004 2004 El Sobrante El Sobrante 2022-08-18 Riverside 65 4567   13966
2005 2005 French Valley French Valley 2022-08-18 Riverside 65 6839   33818
2006 2006 Garnet Garnet 2022-08-18 Riverside 65 1593   5057
2007 2007 Good Hope Good Hope 2022-08-18 Riverside 65 3052   9173
2008 2008 Green Acres Green Acres 2022-08-18 Riverside 65 624   2542
2009 2009 Hemet Hemet 2022-08-18 Riverside 65 22311   84069
2010 2010 Highgrove Highgrove 2022-08-18 Riverside 65 1804   4986
2011 2011 Home Gardens Home Gardens 2022-08-18 Riverside 65 3400   11442
2012 2012 Homeland Homeland 2022-08-18 Riverside 65 1546   7326
2013 2013 Idyllwild-Pine Cove Idyllwild-Pine Cove 2022-08-18 Riverside 65 345   2459
2014 2014 Indian Wells Indian Wells 2022-08-18 Riverside 65 691   5317
2015 2015 Indio Indio 2022-08-18 Riverside 65 24761   88291
2016 2016 Jurupa Valley Jurupa Valley 2022-08-18 Riverside 65 32054   103784
2017 2017 La Quinta La Quinta 2022-08-18 Riverside 65 9118   40704
2018 2018 Lake Elsinore Lake Elsinore 2022-08-18 Riverside 65 18945   64037
2019 2019 Lake Mathews Lake Mathews 2022-08-18 Riverside 65 1385   6848
2020 2020 Lakeland Village Lakeland Village 2022-08-18 Riverside 65 2782   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
);