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,812 rows where fips = 73 sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 73 · 7,812

county

Link rowid date ▲ county fips place confirmed_cases note x y
732 2020-10-23 San Diego 73 Alpine 137   -116.791972 32.844067
733 2020-10-23 San Diego 73 Bonita 235   -117.029174 32.672774
734 2020-10-23 San Diego 73 Bonsall 51   -117.193611 33.279722
735 2020-10-23 San Diego 73 Borrego Springs 20   -116.423024 33.25489
736 2020-10-23 San Diego 73 Boulevard 8   -116.286294 32.663632
737 2020-10-23 San Diego 73 Campo 33   -116.543573 32.652402
738 2020-10-23 San Diego 73 Carlsbad 823   -117.282654 33.130701
739 2020-10-23 San Diego 73 Chula Vista 6909   -117.005993 32.632325
740 2020-10-23 San Diego 73 Coronado 219   -117.1725 32.678056
741 2020-10-23 San Diego 73 Del Mar 35   -117.262392 32.964406
742 2020-10-23 San Diego 73 Descanso 11   -116.615833 32.852778
743 2020-10-23 San Diego 73 Dulzura 65   -116.78201 32.6435
744 2020-10-23 San Diego 73 El Cajon 2341   -116.965206 32.80148
745 2020-10-23 San Diego 73 Encinitas 500   -117.268311 33.045762
746 2020-10-23 San Diego 73 Escondido 2565   -117.078906 33.125218
747 2020-10-23 San Diego 73 Fallbrook 611   -117.251739 33.37523
748 2020-10-23 San Diego 73 Imperial Beach 685   -117.117222 32.578333
749 2020-10-23 San Diego 73 Jacumba 3   -116.19145 32.630987
750 2020-10-23 San Diego 73 Jamul 101   -116.877237 32.718851
751 2020-10-23 San Diego 73 Julian 16   -116.585556 33.070833
752 2020-10-23 San Diego 73 La Mesa 824   -117.022602 32.766092
753 2020-10-23 San Diego 73 Lakeside 480   -116.926798 32.856093
754 2020-10-23 San Diego 73 Lemon Grove 528   -117.031795 32.742202
755 2020-10-23 San Diego 73 National City 1835   -117.095883 32.672397
756 2020-10-23 San Diego 73 Oceanside 2149   -117.309647 33.228541
757 2020-10-23 San Diego 73 Pala 77   -117.076667 33.365278
758 2020-10-23 San Diego 73 Pauma Valley 30   -116.998926 33.303366
759 2020-10-23 San Diego 73 Pine Valley 5   -116.526667 32.828056
760 2020-10-23 San Diego 73 Potrero 47   -116.613056 32.604722
761 2020-10-23 San Diego 73 Poway 378   -117.031363 32.969113
762 2020-10-23 San Diego 73 Ramona 414   -116.877082 33.037247
763 2020-10-23 San Diego 73 Ranchita 3   -116.625678 33.183513
764 2020-10-23 San Diego 73 Rancho Santa Fe 84   -117.204198 33.019952
765 2020-10-23 San Diego 73 San Diego 23498   -117.148962 32.69247
766 2020-10-23 San Diego 73 San Marcos 1243   -117.170654 33.139888
767 2020-10-23 San Diego 73 Santa Ysabel 12   -116.673979 33.108888
768 2020-10-23 San Diego 73 Santee 585   -116.988058 32.839658
769 2020-10-23 San Diego 73 Solana Beach 75   -117.258008 32.993843
770 2020-10-23 San Diego 73 Spring Valley 1659   -116.999869 32.744752
771 2020-10-23 San Diego 73 Tecate 41   -116.621015 32.582877
772 2020-10-23 San Diego 73 Valley Center 181   -117.090885 33.226252
773 2020-10-23 San Diego 73 Vista 1464   -117.243746 33.201367
774 2020-10-23 San Diego 73 Warner Springs 22   -116.633611 33.282222
1733 2020-10-22 San Diego 73 Alpine 134   -116.791972 32.844067
1734 2020-10-22 San Diego 73 Bonita 234   -117.029174 32.672774
1735 2020-10-22 San Diego 73 Bonsall 51   -117.193611 33.279722
1736 2020-10-22 San Diego 73 Borrego Springs 20   -116.423024 33.25489
1737 2020-10-22 San Diego 73 Boulevard 8   -116.286294 32.663632
1738 2020-10-22 San Diego 73 Campo 32   -116.543573 32.652402
1739 2020-10-22 San Diego 73 Carlsbad 816   -117.282654 33.130701
1740 2020-10-22 San Diego 73 Chula Vista 6851   -117.005993 32.632325
1741 2020-10-22 San Diego 73 Coronado 217   -117.1725 32.678056
1742 2020-10-22 San Diego 73 Del Mar 35   -117.262392 32.964406
1743 2020-10-22 San Diego 73 Descanso 11   -116.615833 32.852778
1744 2020-10-22 San Diego 73 Dulzura 64   -116.78201 32.6435
1745 2020-10-22 San Diego 73 El Cajon 2321   -116.965206 32.80148
1746 2020-10-22 San Diego 73 Encinitas 490   -117.268311 33.045762
1747 2020-10-22 San Diego 73 Escondido 2546   -117.078906 33.125218
1748 2020-10-22 San Diego 73 Fallbrook 608   -117.251739 33.37523
1749 2020-10-22 San Diego 73 Imperial Beach 681   -117.117222 32.578333
1750 2020-10-22 San Diego 73 Jacumba 3   -116.19145 32.630987
1751 2020-10-22 San Diego 73 Jamul 100   -116.877237 32.718851
1752 2020-10-22 San Diego 73 Julian 15   -116.585556 33.070833
1753 2020-10-22 San Diego 73 La Mesa 820   -117.022602 32.766092
1754 2020-10-22 San Diego 73 Lakeside 476   -116.926798 32.856093
1755 2020-10-22 San Diego 73 Lemon Grove 527   -117.031795 32.742202
1756 2020-10-22 San Diego 73 National City 1821   -117.095883 32.672397
1757 2020-10-22 San Diego 73 Oceanside 2129   -117.309647 33.228541
1758 2020-10-22 San Diego 73 Pala 76   -117.076667 33.365278
1759 2020-10-22 San Diego 73 Pauma Valley 30   -116.998926 33.303366
1760 2020-10-22 San Diego 73 Pine Valley 5   -116.526667 32.828056
1761 2020-10-22 San Diego 73 Potrero 46   -116.613056 32.604722
1762 2020-10-22 San Diego 73 Poway 372   -117.031363 32.969113
1763 2020-10-22 San Diego 73 Ramona 413   -116.877082 33.037247
1764 2020-10-22 San Diego 73 Ranchita 3   -116.625678 33.183513
1765 2020-10-22 San Diego 73 Rancho Santa Fe 84   -117.204198 33.019952
1766 2020-10-22 San Diego 73 San Diego 23348   -117.148962 32.69247
1767 2020-10-22 San Diego 73 San Marcos 1231   -117.170654 33.139888
1768 2020-10-22 San Diego 73 Santa Ysabel 12   -116.673979 33.108888
1769 2020-10-22 San Diego 73 Santee 581   -116.988058 32.839658
1770 2020-10-22 San Diego 73 Solana Beach 74   -117.258008 32.993843
1771 2020-10-22 San Diego 73 Spring Valley 1646   -116.999869 32.744752
1772 2020-10-22 San Diego 73 Tecate 39   -116.621015 32.582877
1773 2020-10-22 San Diego 73 Valley Center 181   -117.090885 33.226252
1774 2020-10-22 San Diego 73 Vista 1441   -117.243746 33.201367
1775 2020-10-22 San Diego 73 Warner Springs 22   -116.633611 33.282222
2707 2020-10-21 San Diego 73 Alpine 134   -116.791972 32.844067
2708 2020-10-21 San Diego 73 Bonita 234   -117.029174 32.672774
2709 2020-10-21 San Diego 73 Bonsall 51   -117.193611 33.279722
2710 2020-10-21 San Diego 73 Borrego Springs 20   -116.423024 33.25489
2711 2020-10-21 San Diego 73 Boulevard 8   -116.286294 32.663632
2712 2020-10-21 San Diego 73 Campo 32   -116.543573 32.652402
2713 2020-10-21 San Diego 73 Carlsbad 809   -117.282654 33.130701
2714 2020-10-21 San Diego 73 Chula Vista 6827   -117.005993 32.632325
2715 2020-10-21 San Diego 73 Coronado 217   -117.1725 32.678056
2716 2020-10-21 San Diego 73 Del Mar 35   -117.262392 32.964406
2717 2020-10-21 San Diego 73 Descanso 11   -116.615833 32.852778
2718 2020-10-21 San Diego 73 Dulzura 64   -116.78201 32.6435
2719 2020-10-21 San Diego 73 El Cajon 2314   -116.965206 32.80148
2720 2020-10-21 San Diego 73 Encinitas 486   -117.268311 33.045762

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