ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Grant" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109860 | 2109860 | 2022-01-13 | Grant | Indiana | 18053 | 14903 | 299 |
2106609 | 2106609 | 2022-01-12 | Grant | Indiana | 18053 | 14800 | 298 |
2103358 | 2103358 | 2022-01-11 | Grant | Indiana | 18053 | 14705 | 298 |
2100107 | 2100107 | 2022-01-10 | Grant | Indiana | 18053 | 14613 | 295 |
2096856 | 2096856 | 2022-01-09 | Grant | Indiana | 18053 | 14231 | 291 |
2093604 | 2093604 | 2022-01-08 | Grant | Indiana | 18053 | 14231 | 291 |
2090352 | 2090352 | 2022-01-07 | Grant | Indiana | 18053 | 14231 | 291 |
2087101 | 2087101 | 2022-01-06 | Grant | Indiana | 18053 | 14116 | 289 |
2083849 | 2083849 | 2022-01-05 | Grant | Indiana | 18053 | 14047 | 287 |
2080597 | 2080597 | 2022-01-04 | Grant | Indiana | 18053 | 13958 | 287 |
2077345 | 2077345 | 2022-01-03 | Grant | Indiana | 18053 | 13897 | 282 |
2074094 | 2074094 | 2022-01-02 | Grant | Indiana | 18053 | 13709 | 282 |
2070843 | 2070843 | 2022-01-01 | Grant | Indiana | 18053 | 13709 | 282 |
2067592 | 2067592 | 2021-12-31 | Grant | Indiana | 18053 | 13709 | 282 |
2064341 | 2064341 | 2021-12-30 | Grant | Indiana | 18053 | 13709 | 282 |
2061091 | 2061091 | 2021-12-29 | Grant | Indiana | 18053 | 13638 | 282 |
2057842 | 2057842 | 2021-12-28 | Grant | Indiana | 18053 | 13595 | 281 |
2054593 | 2054593 | 2021-12-27 | Grant | Indiana | 18053 | 13577 | 279 |
2051343 | 2051343 | 2021-12-26 | Grant | Indiana | 18053 | 13413 | 278 |
2048093 | 2048093 | 2021-12-25 | Grant | Indiana | 18053 | 13413 | 278 |
2044843 | 2044843 | 2021-12-24 | Grant | Indiana | 18053 | 13413 | 278 |
2041594 | 2041594 | 2021-12-23 | Grant | Indiana | 18053 | 13413 | 278 |
2038344 | 2038344 | 2021-12-22 | Grant | Indiana | 18053 | 13413 | 278 |
2035094 | 2035094 | 2021-12-21 | Grant | Indiana | 18053 | 13382 | 274 |
2031844 | 2031844 | 2021-12-20 | Grant | Indiana | 18053 | 13343 | 273 |
2028593 | 2028593 | 2021-12-19 | Grant | Indiana | 18053 | 13221 | 270 |
2025342 | 2025342 | 2021-12-18 | Grant | Indiana | 18053 | 13221 | 270 |
2022091 | 2022091 | 2021-12-17 | Grant | Indiana | 18053 | 13221 | 270 |
2018840 | 2018840 | 2021-12-16 | Grant | Indiana | 18053 | 13168 | 269 |
2015590 | 2015590 | 2021-12-15 | Grant | Indiana | 18053 | 13121 | 268 |
2012339 | 2012339 | 2021-12-14 | Grant | Indiana | 18053 | 13081 | 268 |
2009088 | 2009088 | 2021-12-13 | Grant | Indiana | 18053 | 13048 | 266 |
2005837 | 2005837 | 2021-12-12 | Grant | Indiana | 18053 | 12894 | 262 |
2002586 | 2002586 | 2021-12-11 | Grant | Indiana | 18053 | 12894 | 262 |
1999336 | 1999336 | 2021-12-10 | Grant | Indiana | 18053 | 12894 | 262 |
1996085 | 1996085 | 2021-12-09 | Grant | Indiana | 18053 | 12790 | 259 |
1992834 | 1992834 | 2021-12-08 | Grant | Indiana | 18053 | 12733 | 258 |
1989583 | 1989583 | 2021-12-07 | Grant | Indiana | 18053 | 12650 | 257 |
1986333 | 1986333 | 2021-12-06 | Grant | Indiana | 18053 | 12588 | 255 |
1983083 | 1983083 | 2021-12-05 | Grant | Indiana | 18053 | 12405 | 253 |
1979833 | 1979833 | 2021-12-04 | Grant | Indiana | 18053 | 12405 | 253 |
1976583 | 1976583 | 2021-12-03 | Grant | Indiana | 18053 | 12405 | 253 |
1973334 | 1973334 | 2021-12-02 | Grant | Indiana | 18053 | 12308 | 250 |
1970084 | 1970084 | 2021-12-01 | Grant | Indiana | 18053 | 12252 | 249 |
1966834 | 1966834 | 2021-11-30 | Grant | Indiana | 18053 | 12162 | 248 |
1963582 | 1963582 | 2021-11-29 | Grant | Indiana | 18053 | 12107 | 243 |
1960331 | 1960331 | 2021-11-28 | Grant | Indiana | 18053 | 11890 | 241 |
1957080 | 1957080 | 2021-11-27 | Grant | Indiana | 18053 | 11890 | 241 |
1953829 | 1953829 | 2021-11-26 | Grant | Indiana | 18053 | 11890 | 241 |
1950578 | 1950578 | 2021-11-25 | Grant | Indiana | 18053 | 11890 | 241 |
1947327 | 1947327 | 2021-11-24 | Grant | Indiana | 18053 | 11890 | 241 |
1944076 | 1944076 | 2021-11-23 | Grant | Indiana | 18053 | 11843 | 240 |
1940826 | 1940826 | 2021-11-22 | Grant | Indiana | 18053 | 11764 | 239 |
1937576 | 1937576 | 2021-11-21 | Grant | Indiana | 18053 | 11648 | 239 |
1934326 | 1934326 | 2021-11-20 | Grant | Indiana | 18053 | 11648 | 239 |
1931075 | 1931075 | 2021-11-19 | Grant | Indiana | 18053 | 11648 | 239 |
1927824 | 1927824 | 2021-11-18 | Grant | Indiana | 18053 | 11565 | 239 |
1924574 | 1924574 | 2021-11-17 | Grant | Indiana | 18053 | 11509 | 238 |
1921325 | 1921325 | 2021-11-16 | Grant | Indiana | 18053 | 11451 | 238 |
1918075 | 1918075 | 2021-11-15 | Grant | Indiana | 18053 | 11397 | 237 |
1914825 | 1914825 | 2021-11-14 | Grant | Indiana | 18053 | 11285 | 237 |
1911575 | 1911575 | 2021-11-13 | Grant | Indiana | 18053 | 11285 | 237 |
1908326 | 1908326 | 2021-11-12 | Grant | Indiana | 18053 | 11285 | 237 |
1905077 | 1905077 | 2021-11-11 | Grant | Indiana | 18053 | 11230 | 234 |
1901827 | 1901827 | 2021-11-10 | Grant | Indiana | 18053 | 11093 | 234 |
1898577 | 1898577 | 2021-11-09 | Grant | Indiana | 18053 | 11047 | 233 |
1895327 | 1895327 | 2021-11-08 | Grant | Indiana | 18053 | 11008 | 233 |
1892077 | 1892077 | 2021-11-07 | Grant | Indiana | 18053 | 10907 | 233 |
1888827 | 1888827 | 2021-11-06 | Grant | Indiana | 18053 | 10907 | 233 |
1885577 | 1885577 | 2021-11-05 | Grant | Indiana | 18053 | 10907 | 233 |
1882328 | 1882328 | 2021-11-04 | Grant | Indiana | 18053 | 10844 | 233 |
1879079 | 1879079 | 2021-11-03 | Grant | Indiana | 18053 | 10822 | 233 |
1875830 | 1875830 | 2021-11-02 | Grant | Indiana | 18053 | 10791 | 232 |
1872581 | 1872581 | 2021-11-01 | Grant | Indiana | 18053 | 10770 | 232 |
1869332 | 1869332 | 2021-10-31 | Grant | Indiana | 18053 | 10679 | 230 |
1866083 | 1866083 | 2021-10-30 | Grant | Indiana | 18053 | 10679 | 230 |
1862834 | 1862834 | 2021-10-29 | Grant | Indiana | 18053 | 10679 | 230 |
1859585 | 1859585 | 2021-10-28 | Grant | Indiana | 18053 | 10645 | 230 |
1856336 | 1856336 | 2021-10-27 | Grant | Indiana | 18053 | 10602 | 229 |
1853087 | 1853087 | 2021-10-26 | Grant | Indiana | 18053 | 10564 | 228 |
1849838 | 1849838 | 2021-10-25 | Grant | Indiana | 18053 | 10537 | 228 |
1846588 | 1846588 | 2021-10-24 | Grant | Indiana | 18053 | 10489 | 228 |
1843338 | 1843338 | 2021-10-23 | Grant | Indiana | 18053 | 10489 | 228 |
1840088 | 1840088 | 2021-10-22 | Grant | Indiana | 18053 | 10489 | 228 |
1836839 | 1836839 | 2021-10-21 | Grant | Indiana | 18053 | 10458 | 228 |
1833590 | 1833590 | 2021-10-20 | Grant | Indiana | 18053 | 10426 | 227 |
1830341 | 1830341 | 2021-10-19 | Grant | Indiana | 18053 | 10407 | 226 |
1827092 | 1827092 | 2021-10-18 | Grant | Indiana | 18053 | 10371 | 226 |
1823843 | 1823843 | 2021-10-17 | Grant | Indiana | 18053 | 10305 | 225 |
1820594 | 1820594 | 2021-10-16 | Grant | Indiana | 18053 | 10305 | 225 |
1817345 | 1817345 | 2021-10-15 | Grant | Indiana | 18053 | 10305 | 225 |
1814097 | 1814097 | 2021-10-14 | Grant | Indiana | 18053 | 10257 | 224 |
1810848 | 1810848 | 2021-10-13 | Grant | Indiana | 18053 | 10217 | 224 |
1807599 | 1807599 | 2021-10-12 | Grant | Indiana | 18053 | 10180 | 224 |
1804348 | 1804348 | 2021-10-11 | Grant | Indiana | 18053 | 10144 | 224 |
1801099 | 1801099 | 2021-10-10 | Grant | Indiana | 18053 | 10081 | 222 |
1797850 | 1797850 | 2021-10-09 | Grant | Indiana | 18053 | 10081 | 222 |
1794601 | 1794601 | 2021-10-08 | Grant | Indiana | 18053 | 10081 | 222 |
1791353 | 1791353 | 2021-10-07 | Grant | Indiana | 18053 | 10019 | 223 |
1788104 | 1788104 | 2021-10-06 | Grant | Indiana | 18053 | 9989 | 223 |
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);