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

9,898 rows where fips = 65 sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 65 · 9,898

county

Link rowid date ▲ county fips place confirmed_cases note x y
609 2020-10-22 Riverside 65 Anza 17   -116.638908 33.549092
610 2020-10-22 Riverside 65 Banning 756   -116.955647 33.968698
611 2020-10-22 Riverside 65 Beaumont 1188   -117.061065 33.896342
612 2020-10-22 Riverside 65 Bermuda Dunes 147   -116.289175 33.742799
613 2020-10-22 Riverside 65 Blythe 408   -114.588902 33.610393
614 2020-10-22 Riverside 65 Cabazon 65   -116.766389 33.909167
615 2020-10-22 Riverside 65 Calimesa 164   -117.095906 33.979146
616 2020-10-22 Riverside 65 Canyon Lake 122   -117.276834 33.692301
617 2020-10-22 Riverside 65 Cathedral City 2056   -116.534922 33.822583
618 2020-10-22 Riverside 65 Cherry Valley 97   -116.977248 33.972515
619 2020-10-22 Riverside 65 Coachella 2861   -116.182425 33.686059
620 2020-10-22 Riverside 65 Corona 3399   -117.648816 33.85932
621 2020-10-22 Riverside 65 Coronita 67   -117.611389 33.875833
622 2020-10-22 Riverside 65 Desert Edge 74   -116.440538 33.921539
623 2020-10-22 Riverside 65 Desert Hot Springs 1192   -116.61534 33.961634
624 2020-10-22 Riverside 65 Desert Palms 48   -116.374456 33.722244
625 2020-10-22 Riverside 65 East Hemet 388   -116.958516 33.736753
626 2020-10-22 Riverside 65 Eastvale 1215   -117.65215 33.971305
627 2020-10-22 Riverside 65 El Cerrito 144   -117.522944 33.836027
628 2020-10-22 Riverside 65 El Sobrante 317   -117.46117 33.872462
629 2020-10-22 Riverside 65 French Valley 369   -117.124328 33.583461
630 2020-10-22 Riverside 65 Garnet 240   -116.545569 33.90196
631 2020-10-22 Riverside 65 Good Hope 260   -117.266982 33.764742
632 2020-10-22 Riverside 65 Green Acres 39   -117.09307 33.738058
633 2020-10-22 Riverside 65 Hemet 1873   -117.060185 33.725795
634 2020-10-22 Riverside 65 Highgrove 133      
635 2020-10-22 Riverside 65 Home Gardens 360   -117.523476 33.881265
636 2020-10-22 Riverside 65 Homeland 131   -117.113333 33.741944
637 2020-10-22 Riverside 65 Idyllwild-Pine Cove 24   -116.762466 33.743539
638 2020-10-22 Riverside 65 Indian Wells 53   -116.369369 33.707409
639 2020-10-22 Riverside 65 Indio 3947   -116.215422 33.718907
640 2020-10-22 Riverside 65 Jails 465      
641 2020-10-22 Riverside 65 Jurupa Valley 3628   -117.529214 33.992044
642 2020-10-22 Riverside 65 La Quinta 893   -116.344796 33.660873
643 2020-10-22 Riverside 65 Lake Elsinore 1352   -117.38781 33.688474
644 2020-10-22 Riverside 65 Lake Mathews 119   -117.368333 33.825
645 2020-10-22 Riverside 65 Lakeland Village 227   -117.365068 33.641002
646 2020-10-22 Riverside 65 Lakeview 48   -117.118056 33.838611
647 2020-10-22 Riverside 65 Mead Valley 573   -117.296361 33.837219
648 2020-10-22 Riverside 65 Meadowbrook 45   -117.301306 33.72459
649 2020-10-22 Riverside 65 Mecca 480   -116.085007 33.576657
650 2020-10-22 Riverside 65 Menifee 1670   -117.258498 33.692352
651 2020-10-22 Riverside 65 Moreno Valley 6725   -117.262466 33.921775
652 2020-10-22 Riverside 65 Murrieta 1400   -117.26848 33.57744
653 2020-10-22 Riverside 65 Norco 507   -117.595116 33.92786
654 2020-10-22 Riverside 65 North Shore 151   -115.927222 33.512778
655 2020-10-22 Riverside 65 Nuevo 203   -117.147359 33.805509
656 2020-10-22 Riverside 65 Oasis 352   -116.0979 33.461632
657 2020-10-22 Riverside 65 Palm Desert 1114   -116.382825 33.729027
658 2020-10-22 Riverside 65 Palm Springs 1166   -116.704031 33.771553
659 2020-10-22 Riverside 65 Perris 2499   -117.2912 33.791973
660 2020-10-22 Riverside 65 Prisons 3117      
661 2020-10-22 Riverside 65 Rancho Mirage 263   -116.46805 33.769852
662 2020-10-22 Riverside 65 Riverside 9320   -117.469568 33.945996
663 2020-10-22 Riverside 65 Romoland 50   -117.175 33.745833
664 2020-10-22 Riverside 65 San Jacinto 1236   -117.024268 33.794605
665 2020-10-22 Riverside 65 Sky Valley 50   -116.35505 33.89124
666 2020-10-22 Riverside 65 Temecula 1222   -117.157264 33.501366
667 2020-10-22 Riverside 65 Temescal Valley 448   -117.495958 33.766606
668 2020-10-22 Riverside 65 Thermal 192   -116.142235 33.640264
669 2020-10-22 Riverside 65 Thousand Palms 249   -116.390289 33.820018
670 2020-10-22 Riverside 65 Valle Vista 253   -116.887115 33.743607
671 2020-10-22 Riverside 65 Vista Santa Rosa 103   -116.2125 33.6225
672 2020-10-22 Riverside 65 Wildomar 645   -117.293586 33.616152
673 2020-10-22 Riverside 65 Winchester 26   -117.086944 33.707778
674 2020-10-22 Riverside 65 Woodcrest 269   -117.405956 33.887064
1583 2020-10-21 Riverside 65 Anza 17   -116.638908 33.549092
1584 2020-10-21 Riverside 65 Banning 755   -116.955647 33.968698
1585 2020-10-21 Riverside 65 Beaumont 1181   -117.061065 33.896342
1586 2020-10-21 Riverside 65 Bermuda Dunes 147   -116.289175 33.742799
1587 2020-10-21 Riverside 65 Blythe 406   -114.588902 33.610393
1588 2020-10-21 Riverside 65 Cabazon 65   -116.766389 33.909167
1589 2020-10-21 Riverside 65 Calimesa 165   -117.095906 33.979146
1590 2020-10-21 Riverside 65 Canyon Lake 122   -117.276834 33.692301
1591 2020-10-21 Riverside 65 Cathedral City 2049   -116.534922 33.822583
1592 2020-10-21 Riverside 65 Cherry Valley 97   -116.977248 33.972515
1593 2020-10-21 Riverside 65 Coachella 2851   -116.182425 33.686059
1594 2020-10-21 Riverside 65 Corona 3379   -117.648816 33.85932
1595 2020-10-21 Riverside 65 Coronita 67   -117.611389 33.875833
1596 2020-10-21 Riverside 65 Desert Edge 74   -116.440538 33.921539
1597 2020-10-21 Riverside 65 Desert Hot Springs 1187   -116.61534 33.961634
1598 2020-10-21 Riverside 65 Desert Palms 48   -116.374456 33.722244
1599 2020-10-21 Riverside 65 East Hemet 388   -116.958516 33.736753
1600 2020-10-21 Riverside 65 Eastvale 1206   -117.65215 33.971305
1601 2020-10-21 Riverside 65 El Cerrito 144   -117.522944 33.836027
1602 2020-10-21 Riverside 65 El Sobrante 314   -117.46117 33.872462
1603 2020-10-21 Riverside 65 French Valley 368   -117.124328 33.583461
1604 2020-10-21 Riverside 65 Garnet 239   -116.545569 33.90196
1605 2020-10-21 Riverside 65 Good Hope 259   -117.266982 33.764742
1606 2020-10-21 Riverside 65 Green Acres 39   -117.09307 33.738058
1607 2020-10-21 Riverside 65 Hemet 1859   -117.060185 33.725795
1608 2020-10-21 Riverside 65 Highgrove 132      
1609 2020-10-21 Riverside 65 Home Gardens 357   -117.523476 33.881265
1610 2020-10-21 Riverside 65 Homeland 127   -117.113333 33.741944
1611 2020-10-21 Riverside 65 Idyllwild-Pine Cove 23   -116.762466 33.743539
1612 2020-10-21 Riverside 65 Indian Wells 53   -116.369369 33.707409
1613 2020-10-21 Riverside 65 Indio 3930   -116.215422 33.718907
1614 2020-10-21 Riverside 65 Jails 452      
1615 2020-10-21 Riverside 65 Jurupa Valley 3613   -117.529214 33.992044
1616 2020-10-21 Riverside 65 La Quinta 888   -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 983.044ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals