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

7,944 rows where county = "San Diego" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 73 7,944

county

  • San Diego · 7,944
Link rowid date ▲ county fips place confirmed_cases note x y
772 2020-10-27 San Diego 73 Alpine 141   -116.791972 32.844067
773 2020-10-27 San Diego 73 Bonita 243   -117.029174 32.672774
774 2020-10-27 San Diego 73 Bonsall 52   -117.193611 33.279722
775 2020-10-27 San Diego 73 Borrego Springs 20   -116.423024 33.25489
776 2020-10-27 San Diego 73 Boulevard 9   -116.286294 32.663632
777 2020-10-27 San Diego 73 Campo 33   -116.543573 32.652402
778 2020-10-27 San Diego 73 Carlsbad 842   -117.282654 33.130701
779 2020-10-27 San Diego 73 Chula Vista 7077   -117.005993 32.632325
780 2020-10-27 San Diego 73 Coronado 219   -117.1725 32.678056
781 2020-10-27 San Diego 73 Del Mar 37   -117.262392 32.964406
782 2020-10-27 San Diego 73 Descanso 11   -116.615833 32.852778
783 2020-10-27 San Diego 73 Dulzura 69   -116.78201 32.6435
784 2020-10-27 San Diego 73 El Cajon 2422   -116.965206 32.80148
785 2020-10-27 San Diego 73 Encinitas 512   -117.268311 33.045762
786 2020-10-27 San Diego 73 Escondido 2646   -117.078906 33.125218
787 2020-10-27 San Diego 73 Fallbrook 620   -117.251739 33.37523
788 2020-10-27 San Diego 73 Imperial Beach 697   -117.117222 32.578333
789 2020-10-27 San Diego 73 Jacumba 5   -116.19145 32.630987
790 2020-10-27 San Diego 73 Jamul 102   -116.877237 32.718851
791 2020-10-27 San Diego 73 Julian 16   -116.585556 33.070833
792 2020-10-27 San Diego 73 La Mesa 838   -117.022602 32.766092
793 2020-10-27 San Diego 73 Lakeside 492   -116.926798 32.856093
794 2020-10-27 San Diego 73 Lemon Grove 537   -117.031795 32.742202
795 2020-10-27 San Diego 73 National City 1860   -117.095883 32.672397
796 2020-10-27 San Diego 73 Oceanside 2205   -117.309647 33.228541
797 2020-10-27 San Diego 73 Pala 78   -117.076667 33.365278
798 2020-10-27 San Diego 73 Palomar Mountain 2      
799 2020-10-27 San Diego 73 Pauma Valley 30   -116.998926 33.303366
800 2020-10-27 San Diego 73 Pine Valley 10   -116.526667 32.828056
801 2020-10-27 San Diego 73 Potrero 48   -116.613056 32.604722
802 2020-10-27 San Diego 73 Poway 387   -117.031363 32.969113
803 2020-10-27 San Diego 73 Ramona 425   -116.877082 33.037247
804 2020-10-27 San Diego 73 Ranchita 3   -116.625678 33.183513
805 2020-10-27 San Diego 73 Rancho Santa Fe 87   -117.204198 33.019952
806 2020-10-27 San Diego 73 San Diego 23980   -117.148962 32.69247
807 2020-10-27 San Diego 73 San Marcos 1283   -117.170654 33.139888
808 2020-10-27 San Diego 73 Santa Ysabel 12   -116.673979 33.108888
809 2020-10-27 San Diego 73 Santee 607   -116.988058 32.839658
810 2020-10-27 San Diego 73 Solana Beach 76   -117.258008 32.993843
811 2020-10-27 San Diego 73 Spring Valley 1683   -116.999869 32.744752
812 2020-10-27 San Diego 73 Tecate 49   -116.621015 32.582877
813 2020-10-27 San Diego 73 Valley Center 186   -117.090885 33.226252
814 2020-10-27 San Diego 73 Vista 1505   -117.243746 33.201367
815 2020-10-27 San Diego 73 Warner Springs 23   -116.633611 33.282222
1730 2020-10-26 San Diego 73 Alpine 141   -116.791972 32.844067
1731 2020-10-26 San Diego 73 Bonita 241   -117.029174 32.672774
1732 2020-10-26 San Diego 73 Bonsall 52   -117.193611 33.279722
1733 2020-10-26 San Diego 73 Borrego Springs 20   -116.423024 33.25489
1734 2020-10-26 San Diego 73 Boulevard 9   -116.286294 32.663632
1735 2020-10-26 San Diego 73 Campo 33   -116.543573 32.652402
1736 2020-10-26 San Diego 73 Carlsbad 839   -117.282654 33.130701
1737 2020-10-26 San Diego 73 Chula Vista 7055   -117.005993 32.632325
1738 2020-10-26 San Diego 73 Coronado 218   -117.1725 32.678056
1739 2020-10-26 San Diego 73 Del Mar 37   -117.262392 32.964406
1740 2020-10-26 San Diego 73 Descanso 11   -116.615833 32.852778
1741 2020-10-26 San Diego 73 Dulzura 69   -116.78201 32.6435
1742 2020-10-26 San Diego 73 El Cajon 2399   -116.965206 32.80148
1743 2020-10-26 San Diego 73 Encinitas 506   -117.268311 33.045762
1744 2020-10-26 San Diego 73 Escondido 2629   -117.078906 33.125218
1745 2020-10-26 San Diego 73 Fallbrook 619   -117.251739 33.37523
1746 2020-10-26 San Diego 73 Imperial Beach 690   -117.117222 32.578333
1747 2020-10-26 San Diego 73 Jacumba 3   -116.19145 32.630987
1748 2020-10-26 San Diego 73 Jamul 102   -116.877237 32.718851
1749 2020-10-26 San Diego 73 Julian 16   -116.585556 33.070833
1750 2020-10-26 San Diego 73 La Mesa 837   -117.022602 32.766092
1751 2020-10-26 San Diego 73 Lakeside 492   -116.926798 32.856093
1752 2020-10-26 San Diego 73 Lemon Grove 533   -117.031795 32.742202
1753 2020-10-26 San Diego 73 National City 1855   -117.095883 32.672397
1754 2020-10-26 San Diego 73 Oceanside 2192   -117.309647 33.228541
1755 2020-10-26 San Diego 73 Pala 78   -117.076667 33.365278
1756 2020-10-26 San Diego 73 Palomar Mountain 2      
1757 2020-10-26 San Diego 73 Pauma Valley 30   -116.998926 33.303366
1758 2020-10-26 San Diego 73 Pine Valley 8   -116.526667 32.828056
1759 2020-10-26 San Diego 73 Potrero 48   -116.613056 32.604722
1760 2020-10-26 San Diego 73 Poway 384   -117.031363 32.969113
1761 2020-10-26 San Diego 73 Ramona 424   -116.877082 33.037247
1762 2020-10-26 San Diego 73 Ranchita 3   -116.625678 33.183513
1763 2020-10-26 San Diego 73 Rancho Santa Fe 87   -117.204198 33.019952
1764 2020-10-26 San Diego 73 San Diego 23868   -117.148962 32.69247
1765 2020-10-26 San Diego 73 San Marcos 1268   -117.170654 33.139888
1766 2020-10-26 San Diego 73 Santa Ysabel 12   -116.673979 33.108888
1767 2020-10-26 San Diego 73 Santee 601   -116.988058 32.839658
1768 2020-10-26 San Diego 73 Solana Beach 75   -117.258008 32.993843
1769 2020-10-26 San Diego 73 Spring Valley 1681   -116.999869 32.744752
1770 2020-10-26 San Diego 73 Tecate 49   -116.621015 32.582877
1771 2020-10-26 San Diego 73 Valley Center 185   -117.090885 33.226252
1772 2020-10-26 San Diego 73 Vista 1498   -117.243746 33.201367
1773 2020-10-26 San Diego 73 Warner Springs 22   -116.633611 33.282222
2495 2020-10-25 San Diego 73 Alpine 137   -116.791972 32.844067
2496 2020-10-25 San Diego 73 Bonita 238   -117.029174 32.672774
2497 2020-10-25 San Diego 73 Bonsall 52   -117.193611 33.279722
2498 2020-10-25 San Diego 73 Borrego Springs 20   -116.423024 33.25489
2499 2020-10-25 San Diego 73 Boulevard 9   -116.286294 32.663632
2500 2020-10-25 San Diego 73 Campo 33   -116.543573 32.652402
2501 2020-10-25 San Diego 73 Carlsbad 831   -117.282654 33.130701
2502 2020-10-25 San Diego 73 Chula Vista 6970   -117.005993 32.632325
2503 2020-10-25 San Diego 73 Coronado 218   -117.1725 32.678056
2504 2020-10-25 San Diego 73 Del Mar 36   -117.262392 32.964406
2505 2020-10-25 San Diego 73 Descanso 11   -116.615833 32.852778
2506 2020-10-25 San Diego 73 Dulzura 65   -116.78201 32.6435

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 938.462ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals