ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Flathead" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175824 | 2175824 | 2022-02-02 | Flathead | Montana | 30029 | 24834 | 235 |
2172571 | 2172571 | 2022-02-01 | Flathead | Montana | 30029 | 24678 | 235 |
2169318 | 2169318 | 2022-01-31 | Flathead | Montana | 30029 | 24578 | 228 |
2166063 | 2166063 | 2022-01-30 | Flathead | Montana | 30029 | 24306 | 228 |
2162808 | 2162808 | 2022-01-29 | Flathead | Montana | 30029 | 24306 | 228 |
2159553 | 2159553 | 2022-01-28 | Flathead | Montana | 30029 | 24306 | 228 |
2156299 | 2156299 | 2022-01-27 | Flathead | Montana | 30029 | 24109 | 228 |
2153046 | 2153046 | 2022-01-26 | Flathead | Montana | 30029 | 23921 | 228 |
2149794 | 2149794 | 2022-01-25 | Flathead | Montana | 30029 | 23636 | 228 |
2146542 | 2146542 | 2022-01-24 | Flathead | Montana | 30029 | 23406 | 228 |
2143287 | 2143287 | 2022-01-23 | Flathead | Montana | 30029 | 23107 | 228 |
2140032 | 2140032 | 2022-01-22 | Flathead | Montana | 30029 | 23107 | 228 |
2136776 | 2136776 | 2022-01-21 | Flathead | Montana | 30029 | 23107 | 228 |
2133524 | 2133524 | 2022-01-20 | Flathead | Montana | 30029 | 23064 | 228 |
2130271 | 2130271 | 2022-01-19 | Flathead | Montana | 30029 | 23026 | 228 |
2127017 | 2127017 | 2022-01-18 | Flathead | Montana | 30029 | 22880 | 228 |
2123765 | 2123765 | 2022-01-17 | Flathead | Montana | 30029 | 22666 | 228 |
2120513 | 2120513 | 2022-01-16 | Flathead | Montana | 30029 | 22666 | 228 |
2117261 | 2117261 | 2022-01-15 | Flathead | Montana | 30029 | 22666 | 228 |
2114010 | 2114010 | 2022-01-14 | Flathead | Montana | 30029 | 22666 | 228 |
2110758 | 2110758 | 2022-01-13 | Flathead | Montana | 30029 | 22360 | 228 |
2107507 | 2107507 | 2022-01-12 | Flathead | Montana | 30029 | 22198 | 228 |
2104256 | 2104256 | 2022-01-11 | Flathead | Montana | 30029 | 22123 | 225 |
2101005 | 2101005 | 2022-01-10 | Flathead | Montana | 30029 | 22003 | 225 |
2097754 | 2097754 | 2022-01-09 | Flathead | Montana | 30029 | 21873 | 225 |
2094502 | 2094502 | 2022-01-08 | Flathead | Montana | 30029 | 21873 | 225 |
2091250 | 2091250 | 2022-01-07 | Flathead | Montana | 30029 | 21873 | 225 |
2087999 | 2087999 | 2022-01-06 | Flathead | Montana | 30029 | 21819 | 225 |
2084747 | 2084747 | 2022-01-05 | Flathead | Montana | 30029 | 21762 | 225 |
2081495 | 2081495 | 2022-01-04 | Flathead | Montana | 30029 | 21599 | 225 |
2078243 | 2078243 | 2022-01-03 | Flathead | Montana | 30029 | 21539 | 225 |
2074992 | 2074992 | 2022-01-02 | Flathead | Montana | 30029 | 21480 | 225 |
2071741 | 2071741 | 2022-01-01 | Flathead | Montana | 30029 | 21480 | 225 |
2068490 | 2068490 | 2021-12-31 | Flathead | Montana | 30029 | 21480 | 225 |
2065239 | 2065239 | 2021-12-30 | Flathead | Montana | 30029 | 21480 | 225 |
2061989 | 2061989 | 2021-12-29 | Flathead | Montana | 30029 | 21399 | 225 |
2058740 | 2058740 | 2021-12-28 | Flathead | Montana | 30029 | 21351 | 225 |
2055491 | 2055491 | 2021-12-27 | Flathead | Montana | 30029 | 21320 | 225 |
2052241 | 2052241 | 2021-12-26 | Flathead | Montana | 30029 | 21280 | 225 |
2048991 | 2048991 | 2021-12-25 | Flathead | Montana | 30029 | 21280 | 225 |
2045741 | 2045741 | 2021-12-24 | Flathead | Montana | 30029 | 21280 | 225 |
2042491 | 2042491 | 2021-12-23 | Flathead | Montana | 30029 | 21280 | 225 |
2039242 | 2039242 | 2021-12-22 | Flathead | Montana | 30029 | 21258 | 225 |
2035992 | 2035992 | 2021-12-21 | Flathead | Montana | 30029 | 21237 | 225 |
2032742 | 2032742 | 2021-12-20 | Flathead | Montana | 30029 | 21204 | 218 |
2029491 | 2029491 | 2021-12-19 | Flathead | Montana | 30029 | 21187 | 218 |
2026240 | 2026240 | 2021-12-18 | Flathead | Montana | 30029 | 21187 | 218 |
2022989 | 2022989 | 2021-12-17 | Flathead | Montana | 30029 | 21187 | 218 |
2019738 | 2019738 | 2021-12-16 | Flathead | Montana | 30029 | 21157 | 218 |
2016488 | 2016488 | 2021-12-15 | Flathead | Montana | 30029 | 21140 | 217 |
2013237 | 2013237 | 2021-12-14 | Flathead | Montana | 30029 | 21109 | 217 |
2009986 | 2009986 | 2021-12-13 | Flathead | Montana | 30029 | 21099 | 217 |
2006735 | 2006735 | 2021-12-12 | Flathead | Montana | 30029 | 21077 | 214 |
2003484 | 2003484 | 2021-12-11 | Flathead | Montana | 30029 | 21077 | 214 |
2000234 | 2000234 | 2021-12-10 | Flathead | Montana | 30029 | 21077 | 214 |
1996983 | 1996983 | 2021-12-09 | Flathead | Montana | 30029 | 21056 | 214 |
1993732 | 1993732 | 2021-12-08 | Flathead | Montana | 30029 | 21030 | 214 |
1990481 | 1990481 | 2021-12-07 | Flathead | Montana | 30029 | 21009 | 214 |
1987231 | 1987231 | 2021-12-06 | Flathead | Montana | 30029 | 20981 | 214 |
1983981 | 1983981 | 2021-12-05 | Flathead | Montana | 30029 | 20933 | 205 |
1980731 | 1980731 | 2021-12-04 | Flathead | Montana | 30029 | 20933 | 205 |
1977481 | 1977481 | 2021-12-03 | Flathead | Montana | 30029 | 20933 | 205 |
1974231 | 1974231 | 2021-12-02 | Flathead | Montana | 30029 | 20923 | 205 |
1970982 | 1970982 | 2021-12-01 | Flathead | Montana | 30029 | 20899 | 205 |
1967732 | 1967732 | 2021-11-30 | Flathead | Montana | 30029 | 20839 | 205 |
1964480 | 1964480 | 2021-11-29 | Flathead | Montana | 30029 | 20790 | 205 |
1961229 | 1961229 | 2021-11-28 | Flathead | Montana | 30029 | 20758 | 205 |
1957978 | 1957978 | 2021-11-27 | Flathead | Montana | 30029 | 20758 | 205 |
1954727 | 1954727 | 2021-11-26 | Flathead | Montana | 30029 | 20758 | 205 |
1951476 | 1951476 | 2021-11-25 | Flathead | Montana | 30029 | 20732 | 205 |
1948225 | 1948225 | 2021-11-24 | Flathead | Montana | 30029 | 20732 | 205 |
1944974 | 1944974 | 2021-11-23 | Flathead | Montana | 30029 | 20665 | 205 |
1941723 | 1941723 | 2021-11-22 | Flathead | Montana | 30029 | 20563 | 199 |
1938473 | 1938473 | 2021-11-21 | Flathead | Montana | 30029 | 20519 | 199 |
1935223 | 1935223 | 2021-11-20 | Flathead | Montana | 30029 | 20519 | 199 |
1931973 | 1931973 | 2021-11-19 | Flathead | Montana | 30029 | 20519 | 199 |
1928722 | 1928722 | 2021-11-18 | Flathead | Montana | 30029 | 20480 | 199 |
1925472 | 1925472 | 2021-11-17 | Flathead | Montana | 30029 | 20400 | 199 |
1922223 | 1922223 | 2021-11-16 | Flathead | Montana | 30029 | 20306 | 199 |
1918973 | 1918973 | 2021-11-15 | Flathead | Montana | 30029 | 20226 | 199 |
1915723 | 1915723 | 2021-11-14 | Flathead | Montana | 30029 | 20162 | 189 |
1912473 | 1912473 | 2021-11-13 | Flathead | Montana | 30029 | 20162 | 189 |
1909223 | 1909223 | 2021-11-12 | Flathead | Montana | 30029 | 20162 | 189 |
1905974 | 1905974 | 2021-11-11 | Flathead | Montana | 30029 | 20076 | 180 |
1902725 | 1902725 | 2021-11-10 | Flathead | Montana | 30029 | 20076 | 180 |
1899475 | 1899475 | 2021-11-09 | Flathead | Montana | 30029 | 19998 | 180 |
1896225 | 1896225 | 2021-11-08 | Flathead | Montana | 30029 | 19936 | 180 |
1892975 | 1892975 | 2021-11-07 | Flathead | Montana | 30029 | 19793 | 180 |
1889725 | 1889725 | 2021-11-06 | Flathead | Montana | 30029 | 19793 | 180 |
1886475 | 1886475 | 2021-11-05 | Flathead | Montana | 30029 | 19793 | 180 |
1883226 | 1883226 | 2021-11-04 | Flathead | Montana | 30029 | 19731 | 180 |
1879977 | 1879977 | 2021-11-03 | Flathead | Montana | 30029 | 19660 | 174 |
1876728 | 1876728 | 2021-11-02 | Flathead | Montana | 30029 | 19585 | 174 |
1873479 | 1873479 | 2021-11-01 | Flathead | Montana | 30029 | 19541 | 174 |
1870230 | 1870230 | 2021-10-31 | Flathead | Montana | 30029 | 19378 | 171 |
1866981 | 1866981 | 2021-10-30 | Flathead | Montana | 30029 | 19378 | 171 |
1863732 | 1863732 | 2021-10-29 | Flathead | Montana | 30029 | 19378 | 171 |
1860483 | 1860483 | 2021-10-28 | Flathead | Montana | 30029 | 19315 | 171 |
1857234 | 1857234 | 2021-10-27 | Flathead | Montana | 30029 | 19203 | 171 |
1853985 | 1853985 | 2021-10-26 | Flathead | Montana | 30029 | 19110 | 171 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);