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

10,294 rows where county = "Riverside" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 65 10,294

county

  • Riverside · 10,294
Link rowid date ▲ county fips place confirmed_cases note x y
667 2020-10-30 Riverside 65 Anza 18   -116.638908 33.549092
668 2020-10-30 Riverside 65 Banning 797   -116.955647 33.968698
669 2020-10-30 Riverside 65 Beaumont 1246   -117.061065 33.896342
670 2020-10-30 Riverside 65 Bermuda Dunes 153   -116.289175 33.742799
671 2020-10-30 Riverside 65 Blythe 417   -114.588902 33.610393
672 2020-10-30 Riverside 65 Cabazon 69   -116.766389 33.909167
673 2020-10-30 Riverside 65 Calimesa 170   -117.095906 33.979146
674 2020-10-30 Riverside 65 Canyon Lake 132   -117.276834 33.692301
675 2020-10-30 Riverside 65 Cathedral City 2108   -116.534922 33.822583
676 2020-10-30 Riverside 65 Cherry Valley 101   -116.977248 33.972515
677 2020-10-30 Riverside 65 Coachella 2928   -116.182425 33.686059
678 2020-10-30 Riverside 65 Corona 3539   -117.648816 33.85932
679 2020-10-30 Riverside 65 Coronita 67   -117.611389 33.875833
680 2020-10-30 Riverside 65 Desert Edge 80   -116.440538 33.921539
681 2020-10-30 Riverside 65 Desert Hot Springs 1228   -116.61534 33.961634
682 2020-10-30 Riverside 65 Desert Palms 54   -116.374456 33.722244
683 2020-10-30 Riverside 65 East Hemet 402   -116.958516 33.736753
684 2020-10-30 Riverside 65 Eastvale 1297   -117.65215 33.971305
685 2020-10-30 Riverside 65 El Cerrito 152   -117.522944 33.836027
686 2020-10-30 Riverside 65 El Sobrante 335   -117.46117 33.872462
687 2020-10-30 Riverside 65 French Valley 386   -117.124328 33.583461
688 2020-10-30 Riverside 65 Garnet 250   -116.545569 33.90196
689 2020-10-30 Riverside 65 Good Hope 266   -117.266982 33.764742
690 2020-10-30 Riverside 65 Green Acres 40   -117.09307 33.738058
691 2020-10-30 Riverside 65 Hemet 1946   -117.060185 33.725795
692 2020-10-30 Riverside 65 Highgrove 146      
693 2020-10-30 Riverside 65 Home Gardens 375   -117.523476 33.881265
694 2020-10-30 Riverside 65 Homeland 144   -117.113333 33.741944
695 2020-10-30 Riverside 65 Idyllwild-Pine Cove 24   -116.762466 33.743539
696 2020-10-30 Riverside 65 Indian Wells 55   -116.369369 33.707409
697 2020-10-30 Riverside 65 Indio 4080   -116.215422 33.718907
698 2020-10-30 Riverside 65 Jails 476      
699 2020-10-30 Riverside 65 Jurupa Valley 3781   -117.529214 33.992044
700 2020-10-30 Riverside 65 La Quinta 927   -116.344796 33.660873
701 2020-10-30 Riverside 65 Lake Elsinore 1430   -117.38781 33.688474
702 2020-10-30 Riverside 65 Lake Mathews 120   -117.368333 33.825
703 2020-10-30 Riverside 65 Lakeland Village 232   -117.365068 33.641002
704 2020-10-30 Riverside 65 Lakeview 50   -117.118056 33.838611
705 2020-10-30 Riverside 65 Mead Valley 596   -117.296361 33.837219
706 2020-10-30 Riverside 65 Meadowbrook 45   -117.301306 33.72459
707 2020-10-30 Riverside 65 Mecca 492   -116.085007 33.576657
708 2020-10-30 Riverside 65 Menifee 1739   -117.258498 33.692352
709 2020-10-30 Riverside 65 Moreno Valley 6999   -117.262466 33.921775
710 2020-10-30 Riverside 65 Murrieta 1462   -117.26848 33.57744
711 2020-10-30 Riverside 65 Norco 520   -117.595116 33.92786
712 2020-10-30 Riverside 65 North Shore 159   -115.927222 33.512778
713 2020-10-30 Riverside 65 Nuevo 216   -117.147359 33.805509
714 2020-10-30 Riverside 65 Oasis 366   -116.0979 33.461632
715 2020-10-30 Riverside 65 Palm Desert 1144   -116.382825 33.729027
716 2020-10-30 Riverside 65 Palm Springs 1204   -116.704031 33.771553
717 2020-10-30 Riverside 65 Perris 2617   -117.2912 33.791973
718 2020-10-30 Riverside 65 Prisons 3251      
719 2020-10-30 Riverside 65 Rancho Mirage 276   -116.46805 33.769852
720 2020-10-30 Riverside 65 Riverside 9746   -117.469568 33.945996
721 2020-10-30 Riverside 65 Romoland 56   -117.175 33.745833
722 2020-10-30 Riverside 65 San Jacinto 1286   -117.024268 33.794605
723 2020-10-30 Riverside 65 Sky Valley 52   -116.35505 33.89124
724 2020-10-30 Riverside 65 Temecula 1275   -117.157264 33.501366
725 2020-10-30 Riverside 65 Temescal Valley 459   -117.495958 33.766606
726 2020-10-30 Riverside 65 Thermal 196   -116.142235 33.640264
727 2020-10-30 Riverside 65 Thousand Palms 254   -116.390289 33.820018
728 2020-10-30 Riverside 65 Valle Vista 263   -116.887115 33.743607
729 2020-10-30 Riverside 65 Vista Santa Rosa 107   -116.2125 33.6225
730 2020-10-30 Riverside 65 Wildomar 674   -117.293586 33.616152
731 2020-10-30 Riverside 65 Winchester 26   -117.086944 33.707778
732 2020-10-30 Riverside 65 Woodcrest 283   -117.405956 33.887064
1657 2020-10-29 Riverside 65 Anza 18   -116.638908 33.549092
1658 2020-10-29 Riverside 65 Banning 792   -116.955647 33.968698
1659 2020-10-29 Riverside 65 Beaumont 1237   -117.061065 33.896342
1660 2020-10-29 Riverside 65 Bermuda Dunes 153   -116.289175 33.742799
1661 2020-10-29 Riverside 65 Blythe 417   -114.588902 33.610393
1662 2020-10-29 Riverside 65 Cabazon 69   -116.766389 33.909167
1663 2020-10-29 Riverside 65 Calimesa 169   -117.095906 33.979146
1664 2020-10-29 Riverside 65 Canyon Lake 131   -117.276834 33.692301
1665 2020-10-29 Riverside 65 Cathedral City 2099   -116.534922 33.822583
1666 2020-10-29 Riverside 65 Cherry Valley 99   -116.977248 33.972515
1667 2020-10-29 Riverside 65 Coachella 2919   -116.182425 33.686059
1668 2020-10-29 Riverside 65 Corona 3516   -117.648816 33.85932
1669 2020-10-29 Riverside 65 Coronita 67   -117.611389 33.875833
1670 2020-10-29 Riverside 65 Desert Edge 79   -116.440538 33.921539
1671 2020-10-29 Riverside 65 Desert Hot Springs 1221   -116.61534 33.961634
1672 2020-10-29 Riverside 65 Desert Palms 51   -116.374456 33.722244
1673 2020-10-29 Riverside 65 East Hemet 400   -116.958516 33.736753
1674 2020-10-29 Riverside 65 Eastvale 1286   -117.65215 33.971305
1675 2020-10-29 Riverside 65 El Cerrito 150   -117.522944 33.836027
1676 2020-10-29 Riverside 65 El Sobrante 341   -117.46117 33.872462
1677 2020-10-29 Riverside 65 French Valley 385   -117.124328 33.583461
1678 2020-10-29 Riverside 65 Garnet 247   -116.545569 33.90196
1679 2020-10-29 Riverside 65 Good Hope 265   -117.266982 33.764742
1680 2020-10-29 Riverside 65 Green Acres 40   -117.09307 33.738058
1681 2020-10-29 Riverside 65 Hemet 1934   -117.060185 33.725795
1682 2020-10-29 Riverside 65 Highgrove 143      
1683 2020-10-29 Riverside 65 Home Gardens 371   -117.523476 33.881265
1684 2020-10-29 Riverside 65 Homeland 142   -117.113333 33.741944
1685 2020-10-29 Riverside 65 Idyllwild-Pine Cove 24   -116.762466 33.743539
1686 2020-10-29 Riverside 65 Indian Wells 55   -116.369369 33.707409
1687 2020-10-29 Riverside 65 Indio 4056   -116.215422 33.718907
1688 2020-10-29 Riverside 65 Jails 470      
1689 2020-10-29 Riverside 65 Jurupa Valley 3749   -117.529214 33.992044
1690 2020-10-29 Riverside 65 La Quinta 916   -116.344796 33.660873

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 966.408ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals