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

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

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