ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
486 rows where deaths = 34 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2152134 | 2152134 | 2022-01-26 | Crawford | Indiana | 18025 | 2280 | 34 |
2031878 | 2031878 | 2021-12-20 | Parke | Indiana | 18121 | 2629 | 34 |
2028627 | 2028627 | 2021-12-19 | Parke | Indiana | 18121 | 2612 | 34 |
2025376 | 2025376 | 2021-12-18 | Parke | Indiana | 18121 | 2612 | 34 |
2022125 | 2022125 | 2021-12-17 | Parke | Indiana | 18121 | 2612 | 34 |
2018874 | 2018874 | 2021-12-16 | Parke | Indiana | 18121 | 2608 | 34 |
2015624 | 2015624 | 2021-12-15 | Parke | Indiana | 18121 | 2601 | 34 |
2015633 | 2015633 | 2021-12-15 | Rush | Indiana | 18139 | 3363 | 34 |
2012373 | 2012373 | 2021-12-14 | Parke | Indiana | 18121 | 2596 | 34 |
1830322 | 1830322 | 2021-10-19 | Carroll | Indiana | 18015 | 2600 | 34 |
1827073 | 1827073 | 2021-10-18 | Carroll | Indiana | 18015 | 2593 | 34 |
1823824 | 1823824 | 2021-10-17 | Carroll | Indiana | 18015 | 2584 | 34 |
1820575 | 1820575 | 2021-10-16 | Carroll | Indiana | 18015 | 2584 | 34 |
1817326 | 1817326 | 2021-10-15 | Carroll | Indiana | 18015 | 2584 | 34 |
1814078 | 1814078 | 2021-10-14 | Carroll | Indiana | 18015 | 2578 | 34 |
1810829 | 1810829 | 2021-10-13 | Carroll | Indiana | 18015 | 2570 | 34 |
1807580 | 1807580 | 2021-10-12 | Carroll | Indiana | 18015 | 2565 | 34 |
1804329 | 1804329 | 2021-10-11 | Carroll | Indiana | 18015 | 2561 | 34 |
1801080 | 1801080 | 2021-10-10 | Carroll | Indiana | 18015 | 2541 | 34 |
1797831 | 1797831 | 2021-10-09 | Carroll | Indiana | 18015 | 2541 | 34 |
1794582 | 1794582 | 2021-10-08 | Carroll | Indiana | 18015 | 2541 | 34 |
1791334 | 1791334 | 2021-10-07 | Carroll | Indiana | 18015 | 2536 | 34 |
1765336 | 1765336 | 2021-09-29 | Blackford | Indiana | 18009 | 1742 | 34 |
1762087 | 1762087 | 2021-09-28 | Blackford | Indiana | 18009 | 1740 | 34 |
1758839 | 1758839 | 2021-09-27 | Blackford | Indiana | 18009 | 1740 | 34 |
1755591 | 1755591 | 2021-09-26 | Blackford | Indiana | 18009 | 1716 | 34 |
1752343 | 1752343 | 2021-09-25 | Blackford | Indiana | 18009 | 1716 | 34 |
1749094 | 1749094 | 2021-09-24 | Blackford | Indiana | 18009 | 1716 | 34 |
1745844 | 1745844 | 2021-09-23 | Blackford | Indiana | 18009 | 1707 | 34 |
1742595 | 1742595 | 2021-09-22 | Blackford | Indiana | 18009 | 1694 | 34 |
1739346 | 1739346 | 2021-09-21 | Blackford | Indiana | 18009 | 1690 | 34 |
1736097 | 1736097 | 2021-09-20 | Blackford | Indiana | 18009 | 1685 | 34 |
1732847 | 1732847 | 2021-09-19 | Blackford | Indiana | 18009 | 1667 | 34 |
1732915 | 1732915 | 2021-09-19 | Spencer | Indiana | 18147 | 3132 | 34 |
1729597 | 1729597 | 2021-09-18 | Blackford | Indiana | 18009 | 1667 | 34 |
1729665 | 1729665 | 2021-09-18 | Spencer | Indiana | 18147 | 3132 | 34 |
1726347 | 1726347 | 2021-09-17 | Blackford | Indiana | 18009 | 1667 | 34 |
1726415 | 1726415 | 2021-09-17 | Spencer | Indiana | 18147 | 3132 | 34 |
1723098 | 1723098 | 2021-09-16 | Blackford | Indiana | 18009 | 1659 | 34 |
1723166 | 1723166 | 2021-09-16 | Spencer | Indiana | 18147 | 3119 | 34 |
1719849 | 1719849 | 2021-09-15 | Blackford | Indiana | 18009 | 1649 | 34 |
1719917 | 1719917 | 2021-09-15 | Spencer | Indiana | 18147 | 3109 | 34 |
1716601 | 1716601 | 2021-09-14 | Blackford | Indiana | 18009 | 1635 | 34 |
1716669 | 1716669 | 2021-09-14 | Spencer | Indiana | 18147 | 3094 | 34 |
1713355 | 1713355 | 2021-09-13 | Blackford | Indiana | 18009 | 1624 | 34 |
1713423 | 1713423 | 2021-09-13 | Spencer | Indiana | 18147 | 3082 | 34 |
1710108 | 1710108 | 2021-09-12 | Blackford | Indiana | 18009 | 1601 | 34 |
1706861 | 1706861 | 2021-09-11 | Blackford | Indiana | 18009 | 1601 | 34 |
1703613 | 1703613 | 2021-09-10 | Blackford | Indiana | 18009 | 1601 | 34 |
1700363 | 1700363 | 2021-09-09 | Blackford | Indiana | 18009 | 1594 | 34 |
1697114 | 1697114 | 2021-09-08 | Blackford | Indiana | 18009 | 1579 | 34 |
1693866 | 1693866 | 2021-09-07 | Blackford | Indiana | 18009 | 1577 | 34 |
1690617 | 1690617 | 2021-09-06 | Blackford | Indiana | 18009 | 1550 | 34 |
1687367 | 1687367 | 2021-09-05 | Blackford | Indiana | 18009 | 1550 | 34 |
1684117 | 1684117 | 2021-09-04 | Blackford | Indiana | 18009 | 1550 | 34 |
1680866 | 1680866 | 2021-09-03 | Blackford | Indiana | 18009 | 1550 | 34 |
1677618 | 1677618 | 2021-09-02 | Blackford | Indiana | 18009 | 1537 | 34 |
1674371 | 1674371 | 2021-09-01 | Blackford | Indiana | 18009 | 1528 | 34 |
1671122 | 1671122 | 2021-08-31 | Blackford | Indiana | 18009 | 1518 | 34 |
1599719 | 1599719 | 2021-08-09 | Pike | Indiana | 18125 | 1462 | 34 |
1596471 | 1596471 | 2021-08-08 | Pike | Indiana | 18125 | 1448 | 34 |
1593222 | 1593222 | 2021-08-07 | Pike | Indiana | 18125 | 1448 | 34 |
1589973 | 1589973 | 2021-08-06 | Pike | Indiana | 18125 | 1448 | 34 |
1586724 | 1586724 | 2021-08-05 | Pike | Indiana | 18125 | 1444 | 34 |
1583474 | 1583474 | 2021-08-04 | Pike | Indiana | 18125 | 1439 | 34 |
1580224 | 1580224 | 2021-08-03 | Pike | Indiana | 18125 | 1440 | 34 |
1576975 | 1576975 | 2021-08-02 | Pike | Indiana | 18125 | 1437 | 34 |
1573727 | 1573727 | 2021-08-01 | Pike | Indiana | 18125 | 1434 | 34 |
1570479 | 1570479 | 2021-07-31 | Pike | Indiana | 18125 | 1434 | 34 |
1567231 | 1567231 | 2021-07-30 | Pike | Indiana | 18125 | 1434 | 34 |
1563983 | 1563983 | 2021-07-29 | Pike | Indiana | 18125 | 1430 | 34 |
1560735 | 1560735 | 2021-07-28 | Pike | Indiana | 18125 | 1425 | 34 |
1557488 | 1557488 | 2021-07-27 | Pike | Indiana | 18125 | 1417 | 34 |
1554241 | 1554241 | 2021-07-26 | Pike | Indiana | 18125 | 1414 | 34 |
1550994 | 1550994 | 2021-07-25 | Pike | Indiana | 18125 | 1412 | 34 |
1547747 | 1547747 | 2021-07-24 | Pike | Indiana | 18125 | 1412 | 34 |
1544500 | 1544500 | 2021-07-23 | Pike | Indiana | 18125 | 1412 | 34 |
1541252 | 1541252 | 2021-07-22 | Pike | Indiana | 18125 | 1409 | 34 |
1538005 | 1538005 | 2021-07-21 | Pike | Indiana | 18125 | 1406 | 34 |
1534757 | 1534757 | 2021-07-20 | Pike | Indiana | 18125 | 1405 | 34 |
1531510 | 1531510 | 2021-07-19 | Pike | Indiana | 18125 | 1401 | 34 |
1528263 | 1528263 | 2021-07-18 | Pike | Indiana | 18125 | 1396 | 34 |
1525016 | 1525016 | 2021-07-17 | Pike | Indiana | 18125 | 1396 | 34 |
1521768 | 1521768 | 2021-07-16 | Pike | Indiana | 18125 | 1396 | 34 |
1518520 | 1518520 | 2021-07-15 | Pike | Indiana | 18125 | 1394 | 34 |
1515273 | 1515273 | 2021-07-14 | Pike | Indiana | 18125 | 1393 | 34 |
1512027 | 1512027 | 2021-07-13 | Pike | Indiana | 18125 | 1393 | 34 |
1508780 | 1508780 | 2021-07-12 | Pike | Indiana | 18125 | 1392 | 34 |
1505534 | 1505534 | 2021-07-11 | Pike | Indiana | 18125 | 1388 | 34 |
1502288 | 1502288 | 2021-07-10 | Pike | Indiana | 18125 | 1388 | 34 |
1499042 | 1499042 | 2021-07-09 | Pike | Indiana | 18125 | 1388 | 34 |
1495795 | 1495795 | 2021-07-08 | Pike | Indiana | 18125 | 1388 | 34 |
1492549 | 1492549 | 2021-07-07 | Pike | Indiana | 18125 | 1387 | 34 |
1489302 | 1489302 | 2021-07-06 | Pike | Indiana | 18125 | 1387 | 34 |
1486055 | 1486055 | 2021-07-05 | Pike | Indiana | 18125 | 1385 | 34 |
1482809 | 1482809 | 2021-07-04 | Pike | Indiana | 18125 | 1385 | 34 |
1479562 | 1479562 | 2021-07-03 | Pike | Indiana | 18125 | 1385 | 34 |
1476316 | 1476316 | 2021-07-02 | Pike | Indiana | 18125 | 1385 | 34 |
1473070 | 1473070 | 2021-07-01 | Pike | Indiana | 18125 | 1385 | 34 |
1469824 | 1469824 | 2021-06-30 | Pike | Indiana | 18125 | 1385 | 34 |
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);