ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Allen" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810823 | 1810823 | 2021-10-13 | Allen | Indiana | 18003 | 56825 | 814 |
1807574 | 1807574 | 2021-10-12 | Allen | Indiana | 18003 | 56648 | 814 |
1804323 | 1804323 | 2021-10-11 | Allen | Indiana | 18003 | 56483 | 813 |
1801074 | 1801074 | 2021-10-10 | Allen | Indiana | 18003 | 56184 | 812 |
1797825 | 1797825 | 2021-10-09 | Allen | Indiana | 18003 | 56184 | 812 |
1794576 | 1794576 | 2021-10-08 | Allen | Indiana | 18003 | 56184 | 812 |
1791328 | 1791328 | 2021-10-07 | Allen | Indiana | 18003 | 55910 | 812 |
1788079 | 1788079 | 2021-10-06 | Allen | Indiana | 18003 | 55794 | 811 |
1784830 | 1784830 | 2021-10-05 | Allen | Indiana | 18003 | 55593 | 805 |
1781581 | 1781581 | 2021-10-04 | Allen | Indiana | 18003 | 55473 | 799 |
1778331 | 1778331 | 2021-10-03 | Allen | Indiana | 18003 | 55073 | 798 |
1775081 | 1775081 | 2021-10-02 | Allen | Indiana | 18003 | 55073 | 798 |
1771831 | 1771831 | 2021-10-01 | Allen | Indiana | 18003 | 55073 | 798 |
1768582 | 1768582 | 2021-09-30 | Allen | Indiana | 18003 | 54906 | 796 |
1765333 | 1765333 | 2021-09-29 | Allen | Indiana | 18003 | 54670 | 795 |
1762084 | 1762084 | 2021-09-28 | Allen | Indiana | 18003 | 54512 | 792 |
1758836 | 1758836 | 2021-09-27 | Allen | Indiana | 18003 | 54383 | 790 |
1755588 | 1755588 | 2021-09-26 | Allen | Indiana | 18003 | 53955 | 785 |
1752340 | 1752340 | 2021-09-25 | Allen | Indiana | 18003 | 53955 | 785 |
1749091 | 1749091 | 2021-09-24 | Allen | Indiana | 18003 | 53955 | 785 |
1745841 | 1745841 | 2021-09-23 | Allen | Indiana | 18003 | 53815 | 784 |
1742592 | 1742592 | 2021-09-22 | Allen | Indiana | 18003 | 53665 | 782 |
1739343 | 1739343 | 2021-09-21 | Allen | Indiana | 18003 | 53449 | 775 |
1736094 | 1736094 | 2021-09-20 | Allen | Indiana | 18003 | 53307 | 772 |
1732844 | 1732844 | 2021-09-19 | Allen | Indiana | 18003 | 52828 | 770 |
1729594 | 1729594 | 2021-09-18 | Allen | Indiana | 18003 | 52828 | 770 |
1726344 | 1726344 | 2021-09-17 | Allen | Indiana | 18003 | 52828 | 770 |
1723095 | 1723095 | 2021-09-16 | Allen | Indiana | 18003 | 52539 | 770 |
1719846 | 1719846 | 2021-09-15 | Allen | Indiana | 18003 | 52357 | 769 |
1716598 | 1716598 | 2021-09-14 | Allen | Indiana | 18003 | 52117 | 768 |
1713352 | 1713352 | 2021-09-13 | Allen | Indiana | 18003 | 51940 | 765 |
1710105 | 1710105 | 2021-09-12 | Allen | Indiana | 18003 | 51279 | 761 |
1706858 | 1706858 | 2021-09-11 | Allen | Indiana | 18003 | 51279 | 761 |
1703610 | 1703610 | 2021-09-10 | Allen | Indiana | 18003 | 51279 | 761 |
1700360 | 1700360 | 2021-09-09 | Allen | Indiana | 18003 | 50983 | 758 |
1697111 | 1697111 | 2021-09-08 | Allen | Indiana | 18003 | 50672 | 756 |
1693863 | 1693863 | 2021-09-07 | Allen | Indiana | 18003 | 50515 | 751 |
1690614 | 1690614 | 2021-09-06 | Allen | Indiana | 18003 | 49750 | 749 |
1687364 | 1687364 | 2021-09-05 | Allen | Indiana | 18003 | 49750 | 749 |
1684114 | 1684114 | 2021-09-04 | Allen | Indiana | 18003 | 49750 | 749 |
1680863 | 1680863 | 2021-09-03 | Allen | Indiana | 18003 | 49750 | 749 |
1677615 | 1677615 | 2021-09-02 | Allen | Indiana | 18003 | 49445 | 747 |
1674368 | 1674368 | 2021-09-01 | Allen | Indiana | 18003 | 49183 | 745 |
1671119 | 1671119 | 2021-08-31 | Allen | Indiana | 18003 | 48857 | 743 |
1667872 | 1667872 | 2021-08-30 | Allen | Indiana | 18003 | 48653 | 739 |
1664625 | 1664625 | 2021-08-29 | Allen | Indiana | 18003 | 47984 | 736 |
1661377 | 1661377 | 2021-08-28 | Allen | Indiana | 18003 | 47984 | 736 |
1658129 | 1658129 | 2021-08-27 | Allen | Indiana | 18003 | 47984 | 736 |
1654881 | 1654881 | 2021-08-26 | Allen | Indiana | 18003 | 47742 | 735 |
1651634 | 1651634 | 2021-08-25 | Allen | Indiana | 18003 | 47442 | 735 |
1648385 | 1648385 | 2021-08-24 | Allen | Indiana | 18003 | 47128 | 735 |
1645137 | 1645137 | 2021-08-23 | Allen | Indiana | 18003 | 46890 | 733 |
1641888 | 1641888 | 2021-08-22 | Allen | Indiana | 18003 | 46336 | 732 |
1638638 | 1638638 | 2021-08-21 | Allen | Indiana | 18003 | 46336 | 732 |
1635388 | 1635388 | 2021-08-20 | Allen | Indiana | 18003 | 46336 | 732 |
1632138 | 1632138 | 2021-08-19 | Allen | Indiana | 18003 | 46109 | 732 |
1628891 | 1628891 | 2021-08-18 | Allen | Indiana | 18003 | 45880 | 730 |
1625644 | 1625644 | 2021-08-17 | Allen | Indiana | 18003 | 45625 | 730 |
1622397 | 1622397 | 2021-08-16 | Allen | Indiana | 18003 | 45467 | 728 |
1619150 | 1619150 | 2021-08-15 | Allen | Indiana | 18003 | 44983 | 728 |
1615902 | 1615902 | 2021-08-14 | Allen | Indiana | 18003 | 44983 | 728 |
1612653 | 1612653 | 2021-08-13 | Allen | Indiana | 18003 | 44983 | 728 |
1609405 | 1609405 | 2021-08-12 | Allen | Indiana | 18003 | 44800 | 727 |
1606156 | 1606156 | 2021-08-11 | Allen | Indiana | 18003 | 44566 | 727 |
1602907 | 1602907 | 2021-08-10 | Allen | Indiana | 18003 | 44418 | 726 |
1599658 | 1599658 | 2021-08-09 | Allen | Indiana | 18003 | 44255 | 723 |
1596410 | 1596410 | 2021-08-08 | Allen | Indiana | 18003 | 43914 | 723 |
1593161 | 1593161 | 2021-08-07 | Allen | Indiana | 18003 | 43914 | 723 |
1589912 | 1589912 | 2021-08-06 | Allen | Indiana | 18003 | 43914 | 723 |
1586663 | 1586663 | 2021-08-05 | Allen | Indiana | 18003 | 43766 | 723 |
1583413 | 1583413 | 2021-08-04 | Allen | Indiana | 18003 | 43648 | 723 |
1580163 | 1580163 | 2021-08-03 | Allen | Indiana | 18003 | 43556 | 723 |
1576914 | 1576914 | 2021-08-02 | Allen | Indiana | 18003 | 43442 | 723 |
1573666 | 1573666 | 2021-08-01 | Allen | Indiana | 18003 | 43249 | 722 |
1570418 | 1570418 | 2021-07-31 | Allen | Indiana | 18003 | 43249 | 722 |
1567170 | 1567170 | 2021-07-30 | Allen | Indiana | 18003 | 43249 | 722 |
1563922 | 1563922 | 2021-07-29 | Allen | Indiana | 18003 | 43168 | 722 |
1560674 | 1560674 | 2021-07-28 | Allen | Indiana | 18003 | 43088 | 721 |
1557427 | 1557427 | 2021-07-27 | Allen | Indiana | 18003 | 42994 | 720 |
1554180 | 1554180 | 2021-07-26 | Allen | Indiana | 18003 | 42914 | 720 |
1550933 | 1550933 | 2021-07-25 | Allen | Indiana | 18003 | 42741 | 720 |
1547686 | 1547686 | 2021-07-24 | Allen | Indiana | 18003 | 42741 | 720 |
1544439 | 1544439 | 2021-07-23 | Allen | Indiana | 18003 | 42741 | 720 |
1541191 | 1541191 | 2021-07-22 | Allen | Indiana | 18003 | 42675 | 720 |
1537944 | 1537944 | 2021-07-21 | Allen | Indiana | 18003 | 42618 | 720 |
1534696 | 1534696 | 2021-07-20 | Allen | Indiana | 18003 | 42531 | 720 |
1531449 | 1531449 | 2021-07-19 | Allen | Indiana | 18003 | 42471 | 719 |
1528202 | 1528202 | 2021-07-18 | Allen | Indiana | 18003 | 42349 | 717 |
1524955 | 1524955 | 2021-07-17 | Allen | Indiana | 18003 | 42349 | 717 |
1521707 | 1521707 | 2021-07-16 | Allen | Indiana | 18003 | 42349 | 717 |
1518459 | 1518459 | 2021-07-15 | Allen | Indiana | 18003 | 42308 | 717 |
1515212 | 1515212 | 2021-07-14 | Allen | Indiana | 18003 | 42258 | 717 |
1511966 | 1511966 | 2021-07-13 | Allen | Indiana | 18003 | 42194 | 716 |
1508719 | 1508719 | 2021-07-12 | Allen | Indiana | 18003 | 42157 | 716 |
1505473 | 1505473 | 2021-07-11 | Allen | Indiana | 18003 | 42075 | 716 |
1502227 | 1502227 | 2021-07-10 | Allen | Indiana | 18003 | 42075 | 716 |
1498981 | 1498981 | 2021-07-09 | Allen | Indiana | 18003 | 42075 | 716 |
1495734 | 1495734 | 2021-07-08 | Allen | Indiana | 18003 | 42038 | 715 |
1492488 | 1492488 | 2021-07-07 | Allen | Indiana | 18003 | 41982 | 715 |
1489241 | 1489241 | 2021-07-06 | Allen | Indiana | 18003 | 41962 | 714 |
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);