ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Marshall" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174949 | 2174949 | 2022-02-02 | Marshall | Indiana | 18099 | 12045 | 187 |
2171696 | 2171696 | 2022-02-01 | Marshall | Indiana | 18099 | 12003 | 185 |
2168443 | 2168443 | 2022-01-31 | Marshall | Indiana | 18099 | 11984 | 184 |
2165188 | 2165188 | 2022-01-30 | Marshall | Indiana | 18099 | 11854 | 183 |
2161933 | 2161933 | 2022-01-29 | Marshall | Indiana | 18099 | 11854 | 183 |
2158678 | 2158678 | 2022-01-28 | Marshall | Indiana | 18099 | 11854 | 183 |
2155424 | 2155424 | 2022-01-27 | Marshall | Indiana | 18099 | 11761 | 182 |
2152171 | 2152171 | 2022-01-26 | Marshall | Indiana | 18099 | 11697 | 182 |
2148919 | 2148919 | 2022-01-25 | Marshall | Indiana | 18099 | 11671 | 181 |
2145667 | 2145667 | 2022-01-24 | Marshall | Indiana | 18099 | 11637 | 181 |
2142412 | 2142412 | 2022-01-23 | Marshall | Indiana | 18099 | 11456 | 181 |
2139157 | 2139157 | 2022-01-22 | Marshall | Indiana | 18099 | 11456 | 181 |
2135901 | 2135901 | 2022-01-21 | Marshall | Indiana | 18099 | 11456 | 181 |
2132649 | 2132649 | 2022-01-20 | Marshall | Indiana | 18099 | 11349 | 178 |
2129396 | 2129396 | 2022-01-19 | Marshall | Indiana | 18099 | 11270 | 177 |
2126142 | 2126142 | 2022-01-18 | Marshall | Indiana | 18099 | 11127 | 177 |
2122890 | 2122890 | 2022-01-17 | Marshall | Indiana | 18099 | 11053 | 176 |
2119638 | 2119638 | 2022-01-16 | Marshall | Indiana | 18099 | 10892 | 175 |
2116386 | 2116386 | 2022-01-15 | Marshall | Indiana | 18099 | 10892 | 175 |
2113135 | 2113135 | 2022-01-14 | Marshall | Indiana | 18099 | 10892 | 175 |
2109883 | 2109883 | 2022-01-13 | Marshall | Indiana | 18099 | 10835 | 173 |
2106632 | 2106632 | 2022-01-12 | Marshall | Indiana | 18099 | 10760 | 173 |
2103381 | 2103381 | 2022-01-11 | Marshall | Indiana | 18099 | 10663 | 173 |
2100130 | 2100130 | 2022-01-10 | Marshall | Indiana | 18099 | 10622 | 173 |
2096879 | 2096879 | 2022-01-09 | Marshall | Indiana | 18099 | 10435 | 173 |
2093627 | 2093627 | 2022-01-08 | Marshall | Indiana | 18099 | 10435 | 173 |
2090375 | 2090375 | 2022-01-07 | Marshall | Indiana | 18099 | 10435 | 173 |
2087124 | 2087124 | 2022-01-06 | Marshall | Indiana | 18099 | 10348 | 172 |
2083872 | 2083872 | 2022-01-05 | Marshall | Indiana | 18099 | 10304 | 170 |
2080620 | 2080620 | 2022-01-04 | Marshall | Indiana | 18099 | 10232 | 169 |
2077368 | 2077368 | 2022-01-03 | Marshall | Indiana | 18099 | 10199 | 168 |
2074117 | 2074117 | 2022-01-02 | Marshall | Indiana | 18099 | 10086 | 167 |
2070866 | 2070866 | 2022-01-01 | Marshall | Indiana | 18099 | 10086 | 167 |
2067615 | 2067615 | 2021-12-31 | Marshall | Indiana | 18099 | 10086 | 167 |
2064364 | 2064364 | 2021-12-30 | Marshall | Indiana | 18099 | 10086 | 167 |
2061114 | 2061114 | 2021-12-29 | Marshall | Indiana | 18099 | 10032 | 167 |
2057865 | 2057865 | 2021-12-28 | Marshall | Indiana | 18099 | 10005 | 167 |
2054616 | 2054616 | 2021-12-27 | Marshall | Indiana | 18099 | 9989 | 166 |
2051366 | 2051366 | 2021-12-26 | Marshall | Indiana | 18099 | 9878 | 166 |
2048116 | 2048116 | 2021-12-25 | Marshall | Indiana | 18099 | 9878 | 166 |
2044866 | 2044866 | 2021-12-24 | Marshall | Indiana | 18099 | 9878 | 166 |
2041617 | 2041617 | 2021-12-23 | Marshall | Indiana | 18099 | 9878 | 166 |
2038367 | 2038367 | 2021-12-22 | Marshall | Indiana | 18099 | 9878 | 166 |
2035117 | 2035117 | 2021-12-21 | Marshall | Indiana | 18099 | 9838 | 161 |
2031867 | 2031867 | 2021-12-20 | Marshall | Indiana | 18099 | 9819 | 161 |
2028616 | 2028616 | 2021-12-19 | Marshall | Indiana | 18099 | 9729 | 160 |
2025365 | 2025365 | 2021-12-18 | Marshall | Indiana | 18099 | 9729 | 160 |
2022114 | 2022114 | 2021-12-17 | Marshall | Indiana | 18099 | 9729 | 160 |
2018863 | 2018863 | 2021-12-16 | Marshall | Indiana | 18099 | 9685 | 159 |
2015613 | 2015613 | 2021-12-15 | Marshall | Indiana | 18099 | 9641 | 158 |
2012362 | 2012362 | 2021-12-14 | Marshall | Indiana | 18099 | 9576 | 156 |
2009111 | 2009111 | 2021-12-13 | Marshall | Indiana | 18099 | 9550 | 156 |
2005860 | 2005860 | 2021-12-12 | Marshall | Indiana | 18099 | 9461 | 156 |
2002609 | 2002609 | 2021-12-11 | Marshall | Indiana | 18099 | 9461 | 156 |
1999359 | 1999359 | 2021-12-10 | Marshall | Indiana | 18099 | 9461 | 156 |
1996108 | 1996108 | 2021-12-09 | Marshall | Indiana | 18099 | 9415 | 154 |
1992857 | 1992857 | 2021-12-08 | Marshall | Indiana | 18099 | 9365 | 154 |
1989606 | 1989606 | 2021-12-07 | Marshall | Indiana | 18099 | 9331 | 154 |
1986356 | 1986356 | 2021-12-06 | Marshall | Indiana | 18099 | 9304 | 154 |
1983106 | 1983106 | 2021-12-05 | Marshall | Indiana | 18099 | 9161 | 154 |
1979856 | 1979856 | 2021-12-04 | Marshall | Indiana | 18099 | 9161 | 154 |
1976606 | 1976606 | 2021-12-03 | Marshall | Indiana | 18099 | 9161 | 154 |
1973357 | 1973357 | 2021-12-02 | Marshall | Indiana | 18099 | 9070 | 153 |
1970107 | 1970107 | 2021-12-01 | Marshall | Indiana | 18099 | 9010 | 153 |
1966857 | 1966857 | 2021-11-30 | Marshall | Indiana | 18099 | 8940 | 153 |
1963605 | 1963605 | 2021-11-29 | Marshall | Indiana | 18099 | 8915 | 152 |
1960354 | 1960354 | 2021-11-28 | Marshall | Indiana | 18099 | 8799 | 151 |
1957103 | 1957103 | 2021-11-27 | Marshall | Indiana | 18099 | 8799 | 151 |
1953852 | 1953852 | 2021-11-26 | Marshall | Indiana | 18099 | 8799 | 151 |
1950601 | 1950601 | 2021-11-25 | Marshall | Indiana | 18099 | 8799 | 151 |
1947350 | 1947350 | 2021-11-24 | Marshall | Indiana | 18099 | 8799 | 151 |
1944099 | 1944099 | 2021-11-23 | Marshall | Indiana | 18099 | 8745 | 151 |
1940849 | 1940849 | 2021-11-22 | Marshall | Indiana | 18099 | 8727 | 151 |
1937599 | 1937599 | 2021-11-21 | Marshall | Indiana | 18099 | 8665 | 151 |
1934349 | 1934349 | 2021-11-20 | Marshall | Indiana | 18099 | 8665 | 151 |
1931098 | 1931098 | 2021-11-19 | Marshall | Indiana | 18099 | 8665 | 151 |
1927847 | 1927847 | 2021-11-18 | Marshall | Indiana | 18099 | 8620 | 150 |
1924597 | 1924597 | 2021-11-17 | Marshall | Indiana | 18099 | 8590 | 150 |
1921348 | 1921348 | 2021-11-16 | Marshall | Indiana | 18099 | 8536 | 149 |
1918098 | 1918098 | 2021-11-15 | Marshall | Indiana | 18099 | 8529 | 149 |
1914848 | 1914848 | 2021-11-14 | Marshall | Indiana | 18099 | 8472 | 149 |
1911598 | 1911598 | 2021-11-13 | Marshall | Indiana | 18099 | 8472 | 149 |
1908349 | 1908349 | 2021-11-12 | Marshall | Indiana | 18099 | 8472 | 149 |
1905100 | 1905100 | 2021-11-11 | Marshall | Indiana | 18099 | 8431 | 147 |
1901850 | 1901850 | 2021-11-10 | Marshall | Indiana | 18099 | 8353 | 144 |
1898600 | 1898600 | 2021-11-09 | Marshall | Indiana | 18099 | 8318 | 144 |
1895350 | 1895350 | 2021-11-08 | Marshall | Indiana | 18099 | 8298 | 144 |
1892100 | 1892100 | 2021-11-07 | Marshall | Indiana | 18099 | 8246 | 144 |
1888850 | 1888850 | 2021-11-06 | Marshall | Indiana | 18099 | 8246 | 144 |
1885600 | 1885600 | 2021-11-05 | Marshall | Indiana | 18099 | 8246 | 144 |
1882351 | 1882351 | 2021-11-04 | Marshall | Indiana | 18099 | 8214 | 143 |
1879102 | 1879102 | 2021-11-03 | Marshall | Indiana | 18099 | 8187 | 143 |
1875853 | 1875853 | 2021-11-02 | Marshall | Indiana | 18099 | 8155 | 142 |
1872604 | 1872604 | 2021-11-01 | Marshall | Indiana | 18099 | 8145 | 142 |
1869355 | 1869355 | 2021-10-31 | Marshall | Indiana | 18099 | 8098 | 141 |
1866106 | 1866106 | 2021-10-30 | Marshall | Indiana | 18099 | 8098 | 141 |
1862857 | 1862857 | 2021-10-29 | Marshall | Indiana | 18099 | 8098 | 141 |
1859608 | 1859608 | 2021-10-28 | Marshall | Indiana | 18099 | 8061 | 141 |
1856359 | 1856359 | 2021-10-27 | Marshall | Indiana | 18099 | 8033 | 141 |
1853110 | 1853110 | 2021-10-26 | Marshall | Indiana | 18099 | 8002 | 140 |
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);