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

View and edit SQL

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

place

fips

  • 75 · 5,529

county

Link rowid date ▲ county fips place confirmed_cases note x y
848 2020-10-30 San Francisco 75 94102 817   -122.419339 37.779584
849 2020-10-30 San Francisco 75 94103 654   -122.411164 37.773152
850 2020-10-30 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
851 2020-10-30 San Francisco 75 94105 106   -122.393067 37.789649
852 2020-10-30 San Francisco 75 94107 402   -122.406044 37.75826
853 2020-10-30 San Francisco 75 94108 99   -122.408584 37.792016
854 2020-10-30 San Francisco 75 94109 714   -122.422444 37.795388
855 2020-10-30 San Francisco 75 94110 1742   -122.415202 37.750022
856 2020-10-30 San Francisco 75 94111 18   -122.398409 37.79937
857 2020-10-30 San Francisco 75 94112 1876   -122.442936 37.720367
858 2020-10-30 San Francisco 75 94114 222   -122.435408 37.758059
859 2020-10-30 San Francisco 75 94115 488   -122.437253 37.785969
860 2020-10-30 San Francisco 75 94116 195   -122.486066 37.745399
861 2020-10-30 San Francisco 75 94117 283   -122.447662 37.769436
862 2020-10-30 San Francisco 75 94118 225   -122.462605 37.780093
863 2020-10-30 San Francisco 75 94121 223   -122.494707 37.776769
864 2020-10-30 San Francisco 75 94122 260   -122.485127 37.758799
865 2020-10-30 San Francisco 75 94123 204   -122.438366 37.800934
866 2020-10-30 San Francisco 75 94124 1494   -122.382779 37.728895
867 2020-10-30 San Francisco 75 94127 124   -122.457207 37.736027
868 2020-10-30 San Francisco 75 94129 37   -122.464466 37.79734
869 2020-10-30 San Francisco 75 94130 40   -122.369537 37.820688
870 2020-10-30 San Francisco 75 94131 184   -122.441473 37.745916
871 2020-10-30 San Francisco 75 94132 252   -122.484083 37.722214
872 2020-10-30 San Francisco 75 94133 167   -122.410852 37.804532
873 2020-10-30 San Francisco 75 94134 1005   -122.413555 37.721046
874 2020-10-30 San Francisco 75 94158 109   -122.387011 37.769893
1838 2020-10-29 San Francisco 75 94102 813   -122.419339 37.779584
1839 2020-10-29 San Francisco 75 94103 650   -122.411164 37.773152
1840 2020-10-29 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
1841 2020-10-29 San Francisco 75 94105 106   -122.393067 37.789649
1842 2020-10-29 San Francisco 75 94107 402   -122.406044 37.75826
1843 2020-10-29 San Francisco 75 94108 99   -122.408584 37.792016
1844 2020-10-29 San Francisco 75 94109 710   -122.422444 37.795388
1845 2020-10-29 San Francisco 75 94110 1741   -122.415202 37.750022
1846 2020-10-29 San Francisco 75 94111 18   -122.398409 37.79937
1847 2020-10-29 San Francisco 75 94112 1870   -122.442936 37.720367
1848 2020-10-29 San Francisco 75 94114 222   -122.435408 37.758059
1849 2020-10-29 San Francisco 75 94115 487   -122.437253 37.785969
1850 2020-10-29 San Francisco 75 94116 195   -122.486066 37.745399
1851 2020-10-29 San Francisco 75 94117 281   -122.447662 37.769436
1852 2020-10-29 San Francisco 75 94118 223   -122.462605 37.780093
1853 2020-10-29 San Francisco 75 94121 221   -122.494707 37.776769
1854 2020-10-29 San Francisco 75 94122 260   -122.485127 37.758799
1855 2020-10-29 San Francisco 75 94123 205   -122.438366 37.800934
1856 2020-10-29 San Francisco 75 94124 1489   -122.382779 37.728895
1857 2020-10-29 San Francisco 75 94127 123   -122.457207 37.736027
1858 2020-10-29 San Francisco 75 94129 37   -122.464466 37.79734
1859 2020-10-29 San Francisco 75 94130 41   -122.369537 37.820688
1860 2020-10-29 San Francisco 75 94131 183   -122.441473 37.745916
1861 2020-10-29 San Francisco 75 94132 250   -122.484083 37.722214
1862 2020-10-29 San Francisco 75 94133 167   -122.410852 37.804532
1863 2020-10-29 San Francisco 75 94134 1000   -122.413555 37.721046
1864 2020-10-29 San Francisco 75 94158 108   -122.387011 37.769893
2822 2020-10-28 San Francisco 75 94102 811   -122.419339 37.779584
2823 2020-10-28 San Francisco 75 94103 650   -122.411164 37.773152
2824 2020-10-28 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
2825 2020-10-28 San Francisco 75 94105 105   -122.393067 37.789649
2826 2020-10-28 San Francisco 75 94107 399   -122.406044 37.75826
2827 2020-10-28 San Francisco 75 94108 98   -122.408584 37.792016
2828 2020-10-28 San Francisco 75 94109 708   -122.422444 37.795388
2829 2020-10-28 San Francisco 75 94110 1736   -122.415202 37.750022
2830 2020-10-28 San Francisco 75 94111 17   -122.398409 37.79937
2831 2020-10-28 San Francisco 75 94112 1865   -122.442936 37.720367
2832 2020-10-28 San Francisco 75 94114 221   -122.435408 37.758059
2833 2020-10-28 San Francisco 75 94115 486   -122.437253 37.785969
2834 2020-10-28 San Francisco 75 94116 194   -122.486066 37.745399
2835 2020-10-28 San Francisco 75 94117 281   -122.447662 37.769436
2836 2020-10-28 San Francisco 75 94118 222   -122.462605 37.780093
2837 2020-10-28 San Francisco 75 94121 221   -122.494707 37.776769
2838 2020-10-28 San Francisco 75 94122 258   -122.485127 37.758799
2839 2020-10-28 San Francisco 75 94123 204   -122.438366 37.800934
2840 2020-10-28 San Francisco 75 94124 1486   -122.382779 37.728895
2841 2020-10-28 San Francisco 75 94127 123   -122.457207 37.736027
2842 2020-10-28 San Francisco 75 94129 36   -122.464466 37.79734
2843 2020-10-28 San Francisco 75 94130 41   -122.369537 37.820688
2844 2020-10-28 San Francisco 75 94131 182   -122.441473 37.745916
2845 2020-10-28 San Francisco 75 94132 249   -122.484083 37.722214
2846 2020-10-28 San Francisco 75 94133 166   -122.410852 37.804532
2847 2020-10-28 San Francisco 75 94134 1000   -122.413555 37.721046
2848 2020-10-28 San Francisco 75 94158 107   -122.387011 37.769893
3798 2020-10-27 San Francisco 75 94102 808   -122.419339 37.779584
3799 2020-10-27 San Francisco 75 94103 647   -122.411164 37.773152
3800 2020-10-27 San Francisco 75 94104 1 9 or fewer -122.402129 37.791412
3801 2020-10-27 San Francisco 75 94105 103   -122.393067 37.789649
3802 2020-10-27 San Francisco 75 94107 397   -122.406044 37.75826
3803 2020-10-27 San Francisco 75 94108 98   -122.408584 37.792016
3804 2020-10-27 San Francisco 75 94109 707   -122.422444 37.795388
3805 2020-10-27 San Francisco 75 94110 1729   -122.415202 37.750022
3806 2020-10-27 San Francisco 75 94111 17   -122.398409 37.79937
3807 2020-10-27 San Francisco 75 94112 1858   -122.442936 37.720367
3808 2020-10-27 San Francisco 75 94114 221   -122.435408 37.758059
3809 2020-10-27 San Francisco 75 94115 484   -122.437253 37.785969
3810 2020-10-27 San Francisco 75 94116 193   -122.486066 37.745399
3811 2020-10-27 San Francisco 75 94117 280   -122.447662 37.769436
3812 2020-10-27 San Francisco 75 94118 221   -122.462605 37.780093
3813 2020-10-27 San Francisco 75 94121 217   -122.494707 37.776769
3814 2020-10-27 San Francisco 75 94122 252   -122.485127 37.758799
3815 2020-10-27 San Francisco 75 94123 204   -122.438366 37.800934
3816 2020-10-27 San Francisco 75 94124 1477   -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 936.255ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals