ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18167 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1622479 | 1622479 | 2021-08-16 | Vigo | Indiana | 18167 | 13455 | 263 |
1619232 | 1619232 | 2021-08-15 | Vigo | Indiana | 18167 | 13373 | 262 |
1615984 | 1615984 | 2021-08-14 | Vigo | Indiana | 18167 | 13373 | 262 |
1612735 | 1612735 | 2021-08-13 | Vigo | Indiana | 18167 | 13373 | 262 |
1609487 | 1609487 | 2021-08-12 | Vigo | Indiana | 18167 | 13310 | 262 |
1606238 | 1606238 | 2021-08-11 | Vigo | Indiana | 18167 | 13264 | 262 |
1602989 | 1602989 | 2021-08-10 | Vigo | Indiana | 18167 | 13228 | 262 |
1599740 | 1599740 | 2021-08-09 | Vigo | Indiana | 18167 | 13177 | 261 |
1596492 | 1596492 | 2021-08-08 | Vigo | Indiana | 18167 | 13095 | 261 |
1593243 | 1593243 | 2021-08-07 | Vigo | Indiana | 18167 | 13095 | 261 |
1589994 | 1589994 | 2021-08-06 | Vigo | Indiana | 18167 | 13095 | 261 |
1586745 | 1586745 | 2021-08-05 | Vigo | Indiana | 18167 | 13040 | 261 |
1583495 | 1583495 | 2021-08-04 | Vigo | Indiana | 18167 | 12992 | 261 |
1580245 | 1580245 | 2021-08-03 | Vigo | Indiana | 18167 | 12961 | 261 |
1576996 | 1576996 | 2021-08-02 | Vigo | Indiana | 18167 | 12949 | 261 |
1573748 | 1573748 | 2021-08-01 | Vigo | Indiana | 18167 | 12920 | 261 |
1570500 | 1570500 | 2021-07-31 | Vigo | Indiana | 18167 | 12920 | 261 |
1567252 | 1567252 | 2021-07-30 | Vigo | Indiana | 18167 | 12920 | 261 |
1564004 | 1564004 | 2021-07-29 | Vigo | Indiana | 18167 | 12902 | 261 |
1560756 | 1560756 | 2021-07-28 | Vigo | Indiana | 18167 | 12881 | 261 |
1557509 | 1557509 | 2021-07-27 | Vigo | Indiana | 18167 | 12846 | 261 |
1554262 | 1554262 | 2021-07-26 | Vigo | Indiana | 18167 | 12829 | 260 |
1551015 | 1551015 | 2021-07-25 | Vigo | Indiana | 18167 | 12801 | 260 |
1547768 | 1547768 | 2021-07-24 | Vigo | Indiana | 18167 | 12801 | 260 |
1544521 | 1544521 | 2021-07-23 | Vigo | Indiana | 18167 | 12801 | 260 |
1541273 | 1541273 | 2021-07-22 | Vigo | Indiana | 18167 | 12791 | 260 |
1538026 | 1538026 | 2021-07-21 | Vigo | Indiana | 18167 | 12783 | 260 |
1534778 | 1534778 | 2021-07-20 | Vigo | Indiana | 18167 | 12775 | 260 |
1531531 | 1531531 | 2021-07-19 | Vigo | Indiana | 18167 | 12765 | 260 |
1528284 | 1528284 | 2021-07-18 | Vigo | Indiana | 18167 | 12744 | 260 |
1525037 | 1525037 | 2021-07-17 | Vigo | Indiana | 18167 | 12744 | 260 |
1521789 | 1521789 | 2021-07-16 | Vigo | Indiana | 18167 | 12744 | 260 |
1518541 | 1518541 | 2021-07-15 | Vigo | Indiana | 18167 | 12730 | 260 |
1515294 | 1515294 | 2021-07-14 | Vigo | Indiana | 18167 | 12726 | 260 |
1512048 | 1512048 | 2021-07-13 | Vigo | Indiana | 18167 | 12722 | 260 |
1508801 | 1508801 | 2021-07-12 | Vigo | Indiana | 18167 | 12721 | 260 |
1505555 | 1505555 | 2021-07-11 | Vigo | Indiana | 18167 | 12709 | 259 |
1502309 | 1502309 | 2021-07-10 | Vigo | Indiana | 18167 | 12709 | 259 |
1499063 | 1499063 | 2021-07-09 | Vigo | Indiana | 18167 | 12709 | 259 |
1495816 | 1495816 | 2021-07-08 | Vigo | Indiana | 18167 | 12707 | 259 |
1492570 | 1492570 | 2021-07-07 | Vigo | Indiana | 18167 | 12704 | 259 |
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);