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 |
---|---|---|---|---|---|---|---|
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 |
1784912 | 1784912 | 2021-10-05 | Vigo | Indiana | 18167 | 16871 | 300 |
1781663 | 1781663 | 2021-10-04 | Vigo | Indiana | 18167 | 16826 | 297 |
1778413 | 1778413 | 2021-10-03 | Vigo | Indiana | 18167 | 16758 | 294 |
1775163 | 1775163 | 2021-10-02 | Vigo | Indiana | 18167 | 16758 | 294 |
1771913 | 1771913 | 2021-10-01 | Vigo | Indiana | 18167 | 16758 | 294 |
1768664 | 1768664 | 2021-09-30 | Vigo | Indiana | 18167 | 16679 | 293 |
1765415 | 1765415 | 2021-09-29 | Vigo | Indiana | 18167 | 16607 | 292 |
1762166 | 1762166 | 2021-09-28 | Vigo | Indiana | 18167 | 16542 | 291 |
1758918 | 1758918 | 2021-09-27 | Vigo | Indiana | 18167 | 16477 | 290 |
1755670 | 1755670 | 2021-09-26 | Vigo | Indiana | 18167 | 16314 | 290 |
1752422 | 1752422 | 2021-09-25 | Vigo | Indiana | 18167 | 16314 | 290 |
1749173 | 1749173 | 2021-09-24 | Vigo | Indiana | 18167 | 16314 | 290 |
1745923 | 1745923 | 2021-09-23 | Vigo | Indiana | 18167 | 16221 | 289 |
1742674 | 1742674 | 2021-09-22 | Vigo | Indiana | 18167 | 16120 | 286 |
1739425 | 1739425 | 2021-09-21 | Vigo | Indiana | 18167 | 16058 | 281 |
1736176 | 1736176 | 2021-09-20 | Vigo | Indiana | 18167 | 16003 | 279 |
1732926 | 1732926 | 2021-09-19 | Vigo | Indiana | 18167 | 15827 | 278 |
1729676 | 1729676 | 2021-09-18 | Vigo | Indiana | 18167 | 15827 | 278 |
1726426 | 1726426 | 2021-09-17 | Vigo | Indiana | 18167 | 15827 | 278 |
1723177 | 1723177 | 2021-09-16 | Vigo | Indiana | 18167 | 15727 | 277 |
1719928 | 1719928 | 2021-09-15 | Vigo | Indiana | 18167 | 15574 | 277 |
1716680 | 1716680 | 2021-09-14 | Vigo | Indiana | 18167 | 15471 | 275 |
1713434 | 1713434 | 2021-09-13 | Vigo | Indiana | 18167 | 15398 | 274 |
1710187 | 1710187 | 2021-09-12 | Vigo | Indiana | 18167 | 15148 | 272 |
1706940 | 1706940 | 2021-09-11 | Vigo | Indiana | 18167 | 15148 | 272 |
1703692 | 1703692 | 2021-09-10 | Vigo | Indiana | 18167 | 15148 | 272 |
1700442 | 1700442 | 2021-09-09 | Vigo | Indiana | 18167 | 15030 | 272 |
1697193 | 1697193 | 2021-09-08 | Vigo | Indiana | 18167 | 14945 | 272 |
1693945 | 1693945 | 2021-09-07 | Vigo | Indiana | 18167 | 14886 | 271 |
1690696 | 1690696 | 2021-09-06 | Vigo | Indiana | 18167 | 14592 | 271 |
1687446 | 1687446 | 2021-09-05 | Vigo | Indiana | 18167 | 14592 | 271 |
1684196 | 1684196 | 2021-09-04 | Vigo | Indiana | 18167 | 14592 | 271 |
1680945 | 1680945 | 2021-09-03 | Vigo | Indiana | 18167 | 14592 | 271 |
1677697 | 1677697 | 2021-09-02 | Vigo | Indiana | 18167 | 14497 | 268 |
1674450 | 1674450 | 2021-09-01 | Vigo | Indiana | 18167 | 14387 | 268 |
1671201 | 1671201 | 2021-08-31 | Vigo | Indiana | 18167 | 14301 | 267 |
1667954 | 1667954 | 2021-08-30 | Vigo | Indiana | 18167 | 14238 | 267 |
1664707 | 1664707 | 2021-08-29 | Vigo | Indiana | 18167 | 14057 | 267 |
1661459 | 1661459 | 2021-08-28 | Vigo | Indiana | 18167 | 14057 | 267 |
1658211 | 1658211 | 2021-08-27 | Vigo | Indiana | 18167 | 14057 | 267 |
1654963 | 1654963 | 2021-08-26 | Vigo | Indiana | 18167 | 13992 | 266 |
1651716 | 1651716 | 2021-08-25 | Vigo | Indiana | 18167 | 13890 | 266 |
1648467 | 1648467 | 2021-08-24 | Vigo | Indiana | 18167 | 13805 | 266 |
1645219 | 1645219 | 2021-08-23 | Vigo | Indiana | 18167 | 13757 | 265 |
1641970 | 1641970 | 2021-08-22 | Vigo | Indiana | 18167 | 13643 | 265 |
1638720 | 1638720 | 2021-08-21 | Vigo | Indiana | 18167 | 13643 | 265 |
1635470 | 1635470 | 2021-08-20 | Vigo | Indiana | 18167 | 13643 | 265 |
1632220 | 1632220 | 2021-08-19 | Vigo | Indiana | 18167 | 13562 | 265 |
1628973 | 1628973 | 2021-08-18 | Vigo | Indiana | 18167 | 13525 | 265 |
1625726 | 1625726 | 2021-08-17 | Vigo | Indiana | 18167 | 13507 | 265 |
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);