ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Vigo" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109917 | 2109917 | 2022-01-13 | Vigo | Indiana | 18167 | 24043 | 346 |
2106666 | 2106666 | 2022-01-12 | Vigo | Indiana | 18167 | 23685 | 345 |
2103415 | 2103415 | 2022-01-11 | Vigo | Indiana | 18167 | 23554 | 343 |
2100164 | 2100164 | 2022-01-10 | Vigo | Indiana | 18167 | 23307 | 342 |
2096913 | 2096913 | 2022-01-09 | Vigo | Indiana | 18167 | 22525 | 339 |
2093661 | 2093661 | 2022-01-08 | Vigo | Indiana | 18167 | 22525 | 339 |
2090409 | 2090409 | 2022-01-07 | Vigo | Indiana | 18167 | 22525 | 339 |
2087158 | 2087158 | 2022-01-06 | Vigo | Indiana | 18167 | 22289 | 337 |
2083906 | 2083906 | 2022-01-05 | Vigo | Indiana | 18167 | 21976 | 334 |
2080654 | 2080654 | 2022-01-04 | Vigo | Indiana | 18167 | 21690 | 334 |
2077402 | 2077402 | 2022-01-03 | Vigo | Indiana | 18167 | 21565 | 333 |
2074151 | 2074151 | 2022-01-02 | Vigo | Indiana | 18167 | 20959 | 333 |
2070900 | 2070900 | 2022-01-01 | Vigo | Indiana | 18167 | 20959 | 333 |
2067649 | 2067649 | 2021-12-31 | Vigo | Indiana | 18167 | 20959 | 333 |
2064398 | 2064398 | 2021-12-30 | Vigo | Indiana | 18167 | 20959 | 333 |
2061148 | 2061148 | 2021-12-29 | Vigo | Indiana | 18167 | 20773 | 331 |
2057899 | 2057899 | 2021-12-28 | Vigo | Indiana | 18167 | 20680 | 329 |
2054650 | 2054650 | 2021-12-27 | Vigo | Indiana | 18167 | 20637 | 327 |
2051400 | 2051400 | 2021-12-26 | Vigo | Indiana | 18167 | 20245 | 327 |
2048150 | 2048150 | 2021-12-25 | Vigo | Indiana | 18167 | 20245 | 327 |
2044900 | 2044900 | 2021-12-24 | Vigo | Indiana | 18167 | 20245 | 327 |
2041651 | 2041651 | 2021-12-23 | Vigo | Indiana | 18167 | 20245 | 327 |
2038401 | 2038401 | 2021-12-22 | Vigo | Indiana | 18167 | 20245 | 327 |
2035151 | 2035151 | 2021-12-21 | Vigo | Indiana | 18167 | 20206 | 327 |
2031901 | 2031901 | 2021-12-20 | Vigo | Indiana | 18167 | 20165 | 327 |
2028650 | 2028650 | 2021-12-19 | Vigo | Indiana | 18167 | 19960 | 326 |
2025399 | 2025399 | 2021-12-18 | Vigo | Indiana | 18167 | 19960 | 326 |
2022148 | 2022148 | 2021-12-17 | Vigo | Indiana | 18167 | 19960 | 326 |
2018897 | 2018897 | 2021-12-16 | Vigo | Indiana | 18167 | 19912 | 326 |
2015647 | 2015647 | 2021-12-15 | Vigo | Indiana | 18167 | 19801 | 325 |
2012396 | 2012396 | 2021-12-14 | Vigo | Indiana | 18167 | 19752 | 325 |
2009145 | 2009145 | 2021-12-13 | Vigo | Indiana | 18167 | 19704 | 324 |
2005894 | 2005894 | 2021-12-12 | Vigo | Indiana | 18167 | 19523 | 323 |
2002643 | 2002643 | 2021-12-11 | Vigo | Indiana | 18167 | 19523 | 323 |
1999393 | 1999393 | 2021-12-10 | Vigo | Indiana | 18167 | 19523 | 323 |
1996142 | 1996142 | 2021-12-09 | Vigo | Indiana | 18167 | 19476 | 321 |
1992891 | 1992891 | 2021-12-08 | Vigo | Indiana | 18167 | 19385 | 320 |
1989640 | 1989640 | 2021-12-07 | Vigo | Indiana | 18167 | 19303 | 318 |
1986390 | 1986390 | 2021-12-06 | Vigo | Indiana | 18167 | 19257 | 315 |
1983140 | 1983140 | 2021-12-05 | Vigo | Indiana | 18167 | 19072 | 315 |
1979890 | 1979890 | 2021-12-04 | Vigo | Indiana | 18167 | 19072 | 315 |
1976640 | 1976640 | 2021-12-03 | Vigo | Indiana | 18167 | 19072 | 315 |
1973391 | 1973391 | 2021-12-02 | Vigo | Indiana | 18167 | 18979 | 315 |
1970141 | 1970141 | 2021-12-01 | Vigo | Indiana | 18167 | 18918 | 315 |
1966891 | 1966891 | 2021-11-30 | Vigo | Indiana | 18167 | 18851 | 314 |
1963639 | 1963639 | 2021-11-29 | Vigo | Indiana | 18167 | 18777 | 314 |
1960388 | 1960388 | 2021-11-28 | Vigo | Indiana | 18167 | 18622 | 314 |
1957137 | 1957137 | 2021-11-27 | Vigo | Indiana | 18167 | 18622 | 314 |
1953886 | 1953886 | 2021-11-26 | Vigo | Indiana | 18167 | 18622 | 314 |
1950635 | 1950635 | 2021-11-25 | Vigo | Indiana | 18167 | 18622 | 314 |
1947384 | 1947384 | 2021-11-24 | Vigo | Indiana | 18167 | 18622 | 314 |
1944133 | 1944133 | 2021-11-23 | Vigo | Indiana | 18167 | 18592 | 314 |
1940883 | 1940883 | 2021-11-22 | Vigo | Indiana | 18167 | 18537 | 314 |
1937633 | 1937633 | 2021-11-21 | Vigo | Indiana | 18167 | 18434 | 314 |
1934383 | 1934383 | 2021-11-20 | Vigo | Indiana | 18167 | 18434 | 314 |
1931132 | 1931132 | 2021-11-19 | Vigo | Indiana | 18167 | 18434 | 314 |
1927881 | 1927881 | 2021-11-18 | Vigo | Indiana | 18167 | 18339 | 314 |
1924631 | 1924631 | 2021-11-17 | Vigo | Indiana | 18167 | 18302 | 314 |
1921382 | 1921382 | 2021-11-16 | Vigo | Indiana | 18167 | 18265 | 314 |
1918132 | 1918132 | 2021-11-15 | Vigo | Indiana | 18167 | 18226 | 313 |
1914882 | 1914882 | 2021-11-14 | Vigo | Indiana | 18167 | 18191 | 313 |
1911632 | 1911632 | 2021-11-13 | Vigo | Indiana | 18167 | 18191 | 313 |
1908383 | 1908383 | 2021-11-12 | Vigo | Indiana | 18167 | 18191 | 313 |
1905134 | 1905134 | 2021-11-11 | Vigo | Indiana | 18167 | 18173 | 313 |
1901884 | 1901884 | 2021-11-10 | Vigo | Indiana | 18167 | 18044 | 313 |
1898634 | 1898634 | 2021-11-09 | Vigo | Indiana | 18167 | 17995 | 313 |
1895384 | 1895384 | 2021-11-08 | Vigo | Indiana | 18167 | 17945 | 313 |
1892134 | 1892134 | 2021-11-07 | Vigo | Indiana | 18167 | 17880 | 313 |
1888884 | 1888884 | 2021-11-06 | Vigo | Indiana | 18167 | 17880 | 313 |
1885634 | 1885634 | 2021-11-05 | Vigo | Indiana | 18167 | 17880 | 313 |
1882385 | 1882385 | 2021-11-04 | Vigo | Indiana | 18167 | 17827 | 313 |
1879136 | 1879136 | 2021-11-03 | Vigo | Indiana | 18167 | 17781 | 313 |
1875887 | 1875887 | 2021-11-02 | Vigo | Indiana | 18167 | 17766 | 311 |
1872638 | 1872638 | 2021-11-01 | Vigo | Indiana | 18167 | 17733 | 311 |
1869389 | 1869389 | 2021-10-31 | Vigo | Indiana | 18167 | 17658 | 311 |
1866140 | 1866140 | 2021-10-30 | Vigo | Indiana | 18167 | 17658 | 311 |
1862891 | 1862891 | 2021-10-29 | Vigo | Indiana | 18167 | 17658 | 311 |
1859642 | 1859642 | 2021-10-28 | Vigo | Indiana | 18167 | 17633 | 311 |
1856393 | 1856393 | 2021-10-27 | Vigo | Indiana | 18167 | 17591 | 311 |
1853144 | 1853144 | 2021-10-26 | Vigo | Indiana | 18167 | 17575 | 310 |
1849895 | 1849895 | 2021-10-25 | Vigo | Indiana | 18167 | 17543 | 309 |
1846645 | 1846645 | 2021-10-24 | Vigo | Indiana | 18167 | 17492 | 309 |
1843395 | 1843395 | 2021-10-23 | Vigo | Indiana | 18167 | 17492 | 309 |
1840145 | 1840145 | 2021-10-22 | Vigo | Indiana | 18167 | 17492 | 309 |
1836896 | 1836896 | 2021-10-21 | Vigo | Indiana | 18167 | 17462 | 309 |
1833647 | 1833647 | 2021-10-20 | Vigo | Indiana | 18167 | 17406 | 309 |
1830398 | 1830398 | 2021-10-19 | Vigo | Indiana | 18167 | 17392 | 308 |
1827149 | 1827149 | 2021-10-18 | Vigo | Indiana | 18167 | 17360 | 307 |
1823900 | 1823900 | 2021-10-17 | Vigo | Indiana | 18167 | 17287 | 306 |
1820651 | 1820651 | 2021-10-16 | Vigo | Indiana | 18167 | 17287 | 306 |
1817402 | 1817402 | 2021-10-15 | Vigo | Indiana | 18167 | 17287 | 306 |
1814154 | 1814154 | 2021-10-14 | Vigo | Indiana | 18167 | 17240 | 306 |
1810905 | 1810905 | 2021-10-13 | Vigo | Indiana | 18167 | 17166 | 303 |
1807656 | 1807656 | 2021-10-12 | Vigo | Indiana | 18167 | 17139 | 302 |
1804405 | 1804405 | 2021-10-11 | Vigo | Indiana | 18167 | 17108 | 302 |
1801156 | 1801156 | 2021-10-10 | Vigo | Indiana | 18167 | 17035 | 301 |
1797907 | 1797907 | 2021-10-09 | Vigo | Indiana | 18167 | 17035 | 301 |
1794658 | 1794658 | 2021-10-08 | Vigo | Indiana | 18167 | 17035 | 301 |
1791410 | 1791410 | 2021-10-07 | Vigo | Indiana | 18167 | 16934 | 301 |
1788161 | 1788161 | 2021-10-06 | Vigo | Indiana | 18167 | 16906 | 301 |
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);