ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Grant" and fips = 18053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174926 | 2174926 | 2022-02-02 | Grant | Indiana | 18053 | 17172 | 325 |
2171673 | 2171673 | 2022-02-01 | Grant | Indiana | 18053 | 17085 | 323 |
2168420 | 2168420 | 2022-01-31 | Grant | Indiana | 18053 | 17026 | 321 |
2165165 | 2165165 | 2022-01-30 | Grant | Indiana | 18053 | 16828 | 321 |
2161910 | 2161910 | 2022-01-29 | Grant | Indiana | 18053 | 16828 | 321 |
2158655 | 2158655 | 2022-01-28 | Grant | Indiana | 18053 | 16828 | 321 |
2155401 | 2155401 | 2022-01-27 | Grant | Indiana | 18053 | 16637 | 320 |
2152148 | 2152148 | 2022-01-26 | Grant | Indiana | 18053 | 16532 | 320 |
2148896 | 2148896 | 2022-01-25 | Grant | Indiana | 18053 | 16489 | 318 |
2145644 | 2145644 | 2022-01-24 | Grant | Indiana | 18053 | 16377 | 311 |
2142389 | 2142389 | 2022-01-23 | Grant | Indiana | 18053 | 15976 | 309 |
2139134 | 2139134 | 2022-01-22 | Grant | Indiana | 18053 | 15976 | 309 |
2135878 | 2135878 | 2022-01-21 | Grant | Indiana | 18053 | 15976 | 309 |
2132626 | 2132626 | 2022-01-20 | Grant | Indiana | 18053 | 15774 | 308 |
2129373 | 2129373 | 2022-01-19 | Grant | Indiana | 18053 | 15553 | 306 |
2126119 | 2126119 | 2022-01-18 | Grant | Indiana | 18053 | 15401 | 306 |
2122867 | 2122867 | 2022-01-17 | Grant | Indiana | 18053 | 15308 | 303 |
2119615 | 2119615 | 2022-01-16 | Grant | Indiana | 18053 | 15023 | 302 |
2116363 | 2116363 | 2022-01-15 | Grant | Indiana | 18053 | 15023 | 302 |
2113112 | 2113112 | 2022-01-14 | Grant | Indiana | 18053 | 15023 | 302 |
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 |
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);