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

5,342 rows where county = "San Francisco" sorted by date descending

View and edit SQL

Suggested facets: note, x, y, date (date)

place

fips

  • 75 5,342

county

  • San Francisco · 5,342
Link rowid date ▲ county fips place confirmed_cases note x y
775 2020-10-23 San Francisco 75 94102 805   -122.419339 37.779584
776 2020-10-23 San Francisco 75 94103 642   -122.411164 37.773152
777 2020-10-23 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
778 2020-10-23 San Francisco 75 94105 99   -122.393067 37.789649
779 2020-10-23 San Francisco 75 94107 395   -122.406044 37.75826
780 2020-10-23 San Francisco 75 94108 96   -122.408584 37.792016
781 2020-10-23 San Francisco 75 94109 697   -122.422444 37.795388
782 2020-10-23 San Francisco 75 94110 1704   -122.415202 37.750022
783 2020-10-23 San Francisco 75 94111 16   -122.398409 37.79937
784 2020-10-23 San Francisco 75 94112 1840   -122.442936 37.720367
785 2020-10-23 San Francisco 75 94114 217   -122.435408 37.758059
786 2020-10-23 San Francisco 75 94115 478   -122.437253 37.785969
787 2020-10-23 San Francisco 75 94116 190   -122.486066 37.745399
788 2020-10-23 San Francisco 75 94117 273   -122.447662 37.769436
789 2020-10-23 San Francisco 75 94118 218   -122.462605 37.780093
790 2020-10-23 San Francisco 75 94121 215   -122.494707 37.776769
791 2020-10-23 San Francisco 75 94122 251   -122.485127 37.758799
792 2020-10-23 San Francisco 75 94123 199   -122.438366 37.800934
793 2020-10-23 San Francisco 75 94124 1454   -122.382779 37.728895
794 2020-10-23 San Francisco 75 94127 118   -122.457207 37.736027
795 2020-10-23 San Francisco 75 94129 36   -122.464466 37.79734
796 2020-10-23 San Francisco 75 94130 40   -122.369537 37.820688
797 2020-10-23 San Francisco 75 94131 181   -122.441473 37.745916
798 2020-10-23 San Francisco 75 94132 247   -122.484083 37.722214
799 2020-10-23 San Francisco 75 94133 160   -122.410852 37.804532
800 2020-10-23 San Francisco 75 94134 986   -122.413555 37.721046
801 2020-10-23 San Francisco 75 94158 106   -122.387011 37.769893
1776 2020-10-22 San Francisco 75 94102 804   -122.419339 37.779584
1777 2020-10-22 San Francisco 75 94103 635   -122.411164 37.773152
1778 2020-10-22 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
1779 2020-10-22 San Francisco 75 94105 98   -122.393067 37.789649
1780 2020-10-22 San Francisco 75 94107 390   -122.406044 37.75826
1781 2020-10-22 San Francisco 75 94108 95   -122.408584 37.792016
1782 2020-10-22 San Francisco 75 94109 693   -122.422444 37.795388
1783 2020-10-22 San Francisco 75 94110 1690   -122.415202 37.750022
1784 2020-10-22 San Francisco 75 94111 16   -122.398409 37.79937
1785 2020-10-22 San Francisco 75 94112 1829   -122.442936 37.720367
1786 2020-10-22 San Francisco 75 94114 216   -122.435408 37.758059
1787 2020-10-22 San Francisco 75 94115 474   -122.437253 37.785969
1788 2020-10-22 San Francisco 75 94116 189   -122.486066 37.745399
1789 2020-10-22 San Francisco 75 94117 271   -122.447662 37.769436
1790 2020-10-22 San Francisco 75 94118 217   -122.462605 37.780093
1791 2020-10-22 San Francisco 75 94121 213   -122.494707 37.776769
1792 2020-10-22 San Francisco 75 94122 250   -122.485127 37.758799
1793 2020-10-22 San Francisco 75 94123 195   -122.438366 37.800934
1794 2020-10-22 San Francisco 75 94124 1445   -122.382779 37.728895
1795 2020-10-22 San Francisco 75 94127 117   -122.457207 37.736027
1796 2020-10-22 San Francisco 75 94129 36   -122.464466 37.79734
1797 2020-10-22 San Francisco 75 94130 39   -122.369537 37.820688
1798 2020-10-22 San Francisco 75 94131 181   -122.441473 37.745916
1799 2020-10-22 San Francisco 75 94132 247   -122.484083 37.722214
1800 2020-10-22 San Francisco 75 94133 157   -122.410852 37.804532
1801 2020-10-22 San Francisco 75 94134 979   -122.413555 37.721046
1802 2020-10-22 San Francisco 75 94158 106   -122.387011 37.769893
2750 2020-10-21 San Francisco 75 94102 804   -122.419339 37.779584
2751 2020-10-21 San Francisco 75 94103 635   -122.411164 37.773152
2752 2020-10-21 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
2753 2020-10-21 San Francisco 75 94105 98   -122.393067 37.789649
2754 2020-10-21 San Francisco 75 94107 390   -122.406044 37.75826
2755 2020-10-21 San Francisco 75 94108 95   -122.408584 37.792016
2756 2020-10-21 San Francisco 75 94109 693   -122.422444 37.795388
2757 2020-10-21 San Francisco 75 94110 1690   -122.415202 37.750022
2758 2020-10-21 San Francisco 75 94111 16   -122.398409 37.79937
2759 2020-10-21 San Francisco 75 94112 1829   -122.442936 37.720367
2760 2020-10-21 San Francisco 75 94114 216   -122.435408 37.758059
2761 2020-10-21 San Francisco 75 94115 474   -122.437253 37.785969
2762 2020-10-21 San Francisco 75 94116 189   -122.486066 37.745399
2763 2020-10-21 San Francisco 75 94117 271   -122.447662 37.769436
2764 2020-10-21 San Francisco 75 94118 217   -122.462605 37.780093
2765 2020-10-21 San Francisco 75 94121 213   -122.494707 37.776769
2766 2020-10-21 San Francisco 75 94122 250   -122.485127 37.758799
2767 2020-10-21 San Francisco 75 94123 195   -122.438366 37.800934
2768 2020-10-21 San Francisco 75 94124 1445   -122.382779 37.728895
2769 2020-10-21 San Francisco 75 94127 117   -122.457207 37.736027
2770 2020-10-21 San Francisco 75 94129 36   -122.464466 37.79734
2771 2020-10-21 San Francisco 75 94130 39   -122.369537 37.820688
2772 2020-10-21 San Francisco 75 94131 181   -122.441473 37.745916
2773 2020-10-21 San Francisco 75 94132 247   -122.484083 37.722214
2774 2020-10-21 San Francisco 75 94133 157   -122.410852 37.804532
2775 2020-10-21 San Francisco 75 94134 979   -122.413555 37.721046
2776 2020-10-21 San Francisco 75 94158 106   -122.387011 37.769893
3762 2020-10-20 San Francisco 75 94102 804   -122.419339 37.779584
3763 2020-10-20 San Francisco 75 94103 633   -122.411164 37.773152
3764 2020-10-20 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
3765 2020-10-20 San Francisco 75 94105 97   -122.393067 37.789649
3766 2020-10-20 San Francisco 75 94107 389   -122.406044 37.75826
3767 2020-10-20 San Francisco 75 94108 93   -122.408584 37.792016
3768 2020-10-20 San Francisco 75 94109 689   -122.422444 37.795388
3769 2020-10-20 San Francisco 75 94110 1686   -122.415202 37.750022
3770 2020-10-20 San Francisco 75 94111 16   -122.398409 37.79937
3771 2020-10-20 San Francisco 75 94112 1827   -122.442936 37.720367
3772 2020-10-20 San Francisco 75 94114 214   -122.435408 37.758059
3773 2020-10-20 San Francisco 75 94115 473   -122.437253 37.785969
3774 2020-10-20 San Francisco 75 94116 187   -122.486066 37.745399
3775 2020-10-20 San Francisco 75 94117 270   -122.447662 37.769436
3776 2020-10-20 San Francisco 75 94118 217   -122.462605 37.780093
3777 2020-10-20 San Francisco 75 94121 213   -122.494707 37.776769
3778 2020-10-20 San Francisco 75 94122 248   -122.485127 37.758799
3779 2020-10-20 San Francisco 75 94123 194   -122.438366 37.800934
3780 2020-10-20 San Francisco 75 94124 1442   -122.382779 37.728895

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