ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Missoula" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175841 | 2175841 | 2022-02-02 | Missoula | Montana | 30063 | 24643 | 199 |
2172588 | 2172588 | 2022-02-01 | Missoula | Montana | 30063 | 24338 | 199 |
2169335 | 2169335 | 2022-01-31 | Missoula | Montana | 30063 | 24183 | 199 |
2166080 | 2166080 | 2022-01-30 | Missoula | Montana | 30063 | 23693 | 199 |
2162825 | 2162825 | 2022-01-29 | Missoula | Montana | 30063 | 23693 | 199 |
2159570 | 2159570 | 2022-01-28 | Missoula | Montana | 30063 | 23693 | 199 |
2156316 | 2156316 | 2022-01-27 | Missoula | Montana | 30063 | 23327 | 199 |
2153063 | 2153063 | 2022-01-26 | Missoula | Montana | 30063 | 22733 | 199 |
2149811 | 2149811 | 2022-01-25 | Missoula | Montana | 30063 | 22328 | 199 |
2146559 | 2146559 | 2022-01-24 | Missoula | Montana | 30063 | 21984 | 199 |
2143304 | 2143304 | 2022-01-23 | Missoula | Montana | 30063 | 21459 | 197 |
2140049 | 2140049 | 2022-01-22 | Missoula | Montana | 30063 | 21459 | 197 |
2136793 | 2136793 | 2022-01-21 | Missoula | Montana | 30063 | 21459 | 197 |
2133541 | 2133541 | 2022-01-20 | Missoula | Montana | 30063 | 21199 | 195 |
2130288 | 2130288 | 2022-01-19 | Missoula | Montana | 30063 | 20955 | 195 |
2127034 | 2127034 | 2022-01-18 | Missoula | Montana | 30063 | 20700 | 195 |
2123782 | 2123782 | 2022-01-17 | Missoula | Montana | 30063 | 20163 | 193 |
2120530 | 2120530 | 2022-01-16 | Missoula | Montana | 30063 | 20163 | 193 |
2117278 | 2117278 | 2022-01-15 | Missoula | Montana | 30063 | 20163 | 193 |
2114027 | 2114027 | 2022-01-14 | Missoula | Montana | 30063 | 20163 | 193 |
2110775 | 2110775 | 2022-01-13 | Missoula | Montana | 30063 | 19962 | 193 |
2107524 | 2107524 | 2022-01-12 | Missoula | Montana | 30063 | 19710 | 193 |
2104273 | 2104273 | 2022-01-11 | Missoula | Montana | 30063 | 19481 | 193 |
2101022 | 2101022 | 2022-01-10 | Missoula | Montana | 30063 | 19282 | 193 |
2097771 | 2097771 | 2022-01-09 | Missoula | Montana | 30063 | 18985 | 192 |
2094519 | 2094519 | 2022-01-08 | Missoula | Montana | 30063 | 18985 | 192 |
2091267 | 2091267 | 2022-01-07 | Missoula | Montana | 30063 | 18985 | 192 |
2088016 | 2088016 | 2022-01-06 | Missoula | Montana | 30063 | 18746 | 192 |
2084764 | 2084764 | 2022-01-05 | Missoula | Montana | 30063 | 18557 | 192 |
2081512 | 2081512 | 2022-01-04 | Missoula | Montana | 30063 | 18421 | 192 |
2078260 | 2078260 | 2022-01-03 | Missoula | Montana | 30063 | 18316 | 192 |
2075009 | 2075009 | 2022-01-02 | Missoula | Montana | 30063 | 18124 | 192 |
2071758 | 2071758 | 2022-01-01 | Missoula | Montana | 30063 | 18124 | 192 |
2068507 | 2068507 | 2021-12-31 | Missoula | Montana | 30063 | 18124 | 192 |
2065256 | 2065256 | 2021-12-30 | Missoula | Montana | 30063 | 18124 | 192 |
2062006 | 2062006 | 2021-12-29 | Missoula | Montana | 30063 | 18012 | 192 |
2058757 | 2058757 | 2021-12-28 | Missoula | Montana | 30063 | 17934 | 192 |
2055508 | 2055508 | 2021-12-27 | Missoula | Montana | 30063 | 17869 | 191 |
2052258 | 2052258 | 2021-12-26 | Missoula | Montana | 30063 | 17790 | 191 |
2049008 | 2049008 | 2021-12-25 | Missoula | Montana | 30063 | 17790 | 191 |
2045758 | 2045758 | 2021-12-24 | Missoula | Montana | 30063 | 17790 | 191 |
2042508 | 2042508 | 2021-12-23 | Missoula | Montana | 30063 | 17790 | 191 |
2039259 | 2039259 | 2021-12-22 | Missoula | Montana | 30063 | 17762 | 191 |
2036009 | 2036009 | 2021-12-21 | Missoula | Montana | 30063 | 17747 | 191 |
2032759 | 2032759 | 2021-12-20 | Missoula | Montana | 30063 | 17720 | 191 |
2029508 | 2029508 | 2021-12-19 | Missoula | Montana | 30063 | 17700 | 191 |
2026257 | 2026257 | 2021-12-18 | Missoula | Montana | 30063 | 17700 | 191 |
2023006 | 2023006 | 2021-12-17 | Missoula | Montana | 30063 | 17700 | 191 |
2019755 | 2019755 | 2021-12-16 | Missoula | Montana | 30063 | 17681 | 191 |
2016505 | 2016505 | 2021-12-15 | Missoula | Montana | 30063 | 17662 | 190 |
2013254 | 2013254 | 2021-12-14 | Missoula | Montana | 30063 | 17642 | 190 |
2010003 | 2010003 | 2021-12-13 | Missoula | Montana | 30063 | 17625 | 190 |
2006752 | 2006752 | 2021-12-12 | Missoula | Montana | 30063 | 17592 | 189 |
2003501 | 2003501 | 2021-12-11 | Missoula | Montana | 30063 | 17592 | 189 |
2000251 | 2000251 | 2021-12-10 | Missoula | Montana | 30063 | 17592 | 189 |
1997000 | 1997000 | 2021-12-09 | Missoula | Montana | 30063 | 17581 | 189 |
1993749 | 1993749 | 2021-12-08 | Missoula | Montana | 30063 | 17566 | 189 |
1990498 | 1990498 | 2021-12-07 | Missoula | Montana | 30063 | 17541 | 189 |
1987248 | 1987248 | 2021-12-06 | Missoula | Montana | 30063 | 17519 | 188 |
1983998 | 1983998 | 2021-12-05 | Missoula | Montana | 30063 | 17491 | 188 |
1980748 | 1980748 | 2021-12-04 | Missoula | Montana | 30063 | 17491 | 188 |
1977498 | 1977498 | 2021-12-03 | Missoula | Montana | 30063 | 17491 | 188 |
1974248 | 1974248 | 2021-12-02 | Missoula | Montana | 30063 | 17473 | 188 |
1970999 | 1970999 | 2021-12-01 | Missoula | Montana | 30063 | 17463 | 187 |
1967749 | 1967749 | 2021-11-30 | Missoula | Montana | 30063 | 17429 | 185 |
1964497 | 1964497 | 2021-11-29 | Missoula | Montana | 30063 | 17395 | 180 |
1961246 | 1961246 | 2021-11-28 | Missoula | Montana | 30063 | 17355 | 179 |
1957995 | 1957995 | 2021-11-27 | Missoula | Montana | 30063 | 17355 | 179 |
1954744 | 1954744 | 2021-11-26 | Missoula | Montana | 30063 | 17355 | 179 |
1951493 | 1951493 | 2021-11-25 | Missoula | Montana | 30063 | 17311 | 177 |
1948242 | 1948242 | 2021-11-24 | Missoula | Montana | 30063 | 17311 | 177 |
1944991 | 1944991 | 2021-11-23 | Missoula | Montana | 30063 | 17278 | 177 |
1941740 | 1941740 | 2021-11-22 | Missoula | Montana | 30063 | 17242 | 176 |
1938490 | 1938490 | 2021-11-21 | Missoula | Montana | 30063 | 17209 | 176 |
1935240 | 1935240 | 2021-11-20 | Missoula | Montana | 30063 | 17209 | 176 |
1931990 | 1931990 | 2021-11-19 | Missoula | Montana | 30063 | 17209 | 176 |
1928739 | 1928739 | 2021-11-18 | Missoula | Montana | 30063 | 17157 | 174 |
1925489 | 1925489 | 2021-11-17 | Missoula | Montana | 30063 | 17120 | 172 |
1922240 | 1922240 | 2021-11-16 | Missoula | Montana | 30063 | 17090 | 172 |
1918990 | 1918990 | 2021-11-15 | Missoula | Montana | 30063 | 17026 | 170 |
1915740 | 1915740 | 2021-11-14 | Missoula | Montana | 30063 | 16951 | 170 |
1912490 | 1912490 | 2021-11-13 | Missoula | Montana | 30063 | 16951 | 170 |
1909240 | 1909240 | 2021-11-12 | Missoula | Montana | 30063 | 16951 | 170 |
1905991 | 1905991 | 2021-11-11 | Missoula | Montana | 30063 | 16841 | 167 |
1902742 | 1902742 | 2021-11-10 | Missoula | Montana | 30063 | 16841 | 167 |
1899492 | 1899492 | 2021-11-09 | Missoula | Montana | 30063 | 16779 | 165 |
1896242 | 1896242 | 2021-11-08 | Missoula | Montana | 30063 | 16727 | 165 |
1892992 | 1892992 | 2021-11-07 | Missoula | Montana | 30063 | 16637 | 164 |
1889742 | 1889742 | 2021-11-06 | Missoula | Montana | 30063 | 16637 | 164 |
1886492 | 1886492 | 2021-11-05 | Missoula | Montana | 30063 | 16637 | 164 |
1883243 | 1883243 | 2021-11-04 | Missoula | Montana | 30063 | 16573 | 164 |
1879994 | 1879994 | 2021-11-03 | Missoula | Montana | 30063 | 16516 | 164 |
1876745 | 1876745 | 2021-11-02 | Missoula | Montana | 30063 | 16435 | 164 |
1873496 | 1873496 | 2021-11-01 | Missoula | Montana | 30063 | 16346 | 163 |
1870247 | 1870247 | 2021-10-31 | Missoula | Montana | 30063 | 16260 | 162 |
1866998 | 1866998 | 2021-10-30 | Missoula | Montana | 30063 | 16260 | 162 |
1863749 | 1863749 | 2021-10-29 | Missoula | Montana | 30063 | 16260 | 162 |
1860500 | 1860500 | 2021-10-28 | Missoula | Montana | 30063 | 16154 | 162 |
1857251 | 1857251 | 2021-10-27 | Missoula | Montana | 30063 | 16059 | 162 |
1854002 | 1854002 | 2021-10-26 | Missoula | Montana | 30063 | 15981 | 162 |
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);