ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Johnson" and fips = 31097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1792340 | 1792340 | 2021-10-07 | Johnson | Nebraska | 31097 | 686 | 10 |
1789091 | 1789091 | 2021-10-06 | Johnson | Nebraska | 31097 | 679 | 10 |
1785843 | 1785843 | 2021-10-05 | Johnson | Nebraska | 31097 | 679 | 10 |
1782594 | 1782594 | 2021-10-04 | Johnson | Nebraska | 31097 | 680 | 10 |
1779344 | 1779344 | 2021-10-03 | Johnson | Nebraska | 31097 | 679 | 10 |
1776094 | 1776094 | 2021-10-02 | Johnson | Nebraska | 31097 | 679 | 10 |
1772844 | 1772844 | 2021-10-01 | Johnson | Nebraska | 31097 | 679 | 10 |
1769595 | 1769595 | 2021-09-30 | Johnson | Nebraska | 31097 | 679 | 10 |
1766346 | 1766346 | 2021-09-29 | Johnson | Nebraska | 31097 | 679 | 10 |
1763097 | 1763097 | 2021-09-28 | Johnson | Nebraska | 31097 | 678 | 10 |
1759848 | 1759848 | 2021-09-27 | Johnson | Nebraska | 31097 | 677 | 10 |
1756600 | 1756600 | 2021-09-26 | Johnson | Nebraska | 31097 | 677 | 10 |
1753352 | 1753352 | 2021-09-25 | Johnson | Nebraska | 31097 | 677 | 10 |
1750104 | 1750104 | 2021-09-24 | Johnson | Nebraska | 31097 | 677 | 10 |
1746854 | 1746854 | 2021-09-23 | Johnson | Nebraska | 31097 | 677 | 10 |
1743605 | 1743605 | 2021-09-22 | Johnson | Nebraska | 31097 | 677 | 10 |
1740356 | 1740356 | 2021-09-21 | Johnson | Nebraska | 31097 | 676 | 10 |
1737107 | 1737107 | 2021-09-20 | Johnson | Nebraska | 31097 | 676 | 10 |
1733857 | 1733857 | 2021-09-19 | Johnson | Nebraska | 31097 | 656 | 10 |
1730607 | 1730607 | 2021-09-18 | Johnson | Nebraska | 31097 | 656 | 10 |
1727357 | 1727357 | 2021-09-17 | Johnson | Nebraska | 31097 | 656 | 10 |
1724108 | 1724108 | 2021-09-16 | Johnson | Nebraska | 31097 | 656 | 10 |
1720859 | 1720859 | 2021-09-15 | Johnson | Nebraska | 31097 | 656 | 10 |
1717611 | 1717611 | 2021-09-14 | Johnson | Nebraska | 31097 | 656 | 10 |
1714363 | 1714363 | 2021-09-13 | Johnson | Nebraska | 31097 | 656 | 10 |
1711117 | 1711117 | 2021-09-12 | Johnson | Nebraska | 31097 | 656 | 10 |
1707870 | 1707870 | 2021-09-11 | Johnson | Nebraska | 31097 | 656 | 10 |
1704623 | 1704623 | 2021-09-10 | Johnson | Nebraska | 31097 | 656 | 10 |
1701373 | 1701373 | 2021-09-09 | Johnson | Nebraska | 31097 | 656 | 10 |
1698124 | 1698124 | 2021-09-08 | Johnson | Nebraska | 31097 | 656 | 10 |
1694876 | 1694876 | 2021-09-07 | Johnson | Nebraska | 31097 | 656 | 10 |
1691627 | 1691627 | 2021-09-06 | Johnson | Nebraska | 31097 | 656 | 10 |
1688377 | 1688377 | 2021-09-05 | Johnson | Nebraska | 31097 | 656 | 10 |
1685127 | 1685127 | 2021-09-04 | Johnson | Nebraska | 31097 | 656 | 10 |
1681876 | 1681876 | 2021-09-03 | Johnson | Nebraska | 31097 | 656 | 10 |
1678628 | 1678628 | 2021-09-02 | Johnson | Nebraska | 31097 | 656 | 10 |
1675380 | 1675380 | 2021-09-01 | Johnson | Nebraska | 31097 | 656 | 10 |
1672132 | 1672132 | 2021-08-31 | Johnson | Nebraska | 31097 | 656 | 10 |
1668885 | 1668885 | 2021-08-30 | Johnson | Nebraska | 31097 | 656 | 10 |
1665638 | 1665638 | 2021-08-29 | Johnson | Nebraska | 31097 | 656 | 10 |
1662390 | 1662390 | 2021-08-28 | Johnson | Nebraska | 31097 | 656 | 10 |
1659142 | 1659142 | 2021-08-27 | Johnson | Nebraska | 31097 | 656 | 10 |
1655893 | 1655893 | 2021-08-26 | Johnson | Nebraska | 31097 | 656 | 10 |
1652646 | 1652646 | 2021-08-25 | Johnson | Nebraska | 31097 | 656 | 10 |
1649398 | 1649398 | 2021-08-24 | Johnson | Nebraska | 31097 | 656 | 10 |
1646149 | 1646149 | 2021-08-23 | Johnson | Nebraska | 31097 | 656 | 10 |
1642900 | 1642900 | 2021-08-22 | Johnson | Nebraska | 31097 | 656 | 10 |
1639650 | 1639650 | 2021-08-21 | Johnson | Nebraska | 31097 | 656 | 10 |
1636400 | 1636400 | 2021-08-20 | Johnson | Nebraska | 31097 | 656 | 10 |
1633150 | 1633150 | 2021-08-19 | Johnson | Nebraska | 31097 | 656 | 10 |
1629903 | 1629903 | 2021-08-18 | Johnson | Nebraska | 31097 | 656 | 10 |
1626656 | 1626656 | 2021-08-17 | Johnson | Nebraska | 31097 | 656 | 10 |
1623409 | 1623409 | 2021-08-16 | Johnson | Nebraska | 31097 | 656 | 10 |
1620162 | 1620162 | 2021-08-15 | Johnson | Nebraska | 31097 | 656 | 10 |
1616914 | 1616914 | 2021-08-14 | Johnson | Nebraska | 31097 | 656 | 10 |
1613666 | 1613666 | 2021-08-13 | Johnson | Nebraska | 31097 | 656 | 10 |
1610417 | 1610417 | 2021-08-12 | Johnson | Nebraska | 31097 | 656 | 10 |
1607169 | 1607169 | 2021-08-11 | Johnson | Nebraska | 31097 | 656 | 10 |
1603920 | 1603920 | 2021-08-10 | Johnson | Nebraska | 31097 | 656 | 10 |
1600671 | 1600671 | 2021-08-09 | Johnson | Nebraska | 31097 | 656 | 10 |
1597423 | 1597423 | 2021-08-08 | Johnson | Nebraska | 31097 | 656 | 10 |
1594174 | 1594174 | 2021-08-07 | Johnson | Nebraska | 31097 | 656 | 10 |
1590925 | 1590925 | 2021-08-06 | Johnson | Nebraska | 31097 | 656 | 10 |
1587676 | 1587676 | 2021-08-05 | Johnson | Nebraska | 31097 | 656 | 10 |
1584425 | 1584425 | 2021-08-04 | Johnson | Nebraska | 31097 | 656 | 10 |
1581176 | 1581176 | 2021-08-03 | Johnson | Nebraska | 31097 | 656 | 10 |
1577927 | 1577927 | 2021-08-02 | Johnson | Nebraska | 31097 | 656 | 10 |
1574679 | 1574679 | 2021-08-01 | Johnson | Nebraska | 31097 | 656 | 10 |
1571431 | 1571431 | 2021-07-31 | Johnson | Nebraska | 31097 | 656 | 10 |
1568183 | 1568183 | 2021-07-30 | Johnson | Nebraska | 31097 | 656 | 10 |
1564935 | 1564935 | 2021-07-29 | Johnson | Nebraska | 31097 | 656 | 10 |
1561687 | 1561687 | 2021-07-28 | Johnson | Nebraska | 31097 | 656 | 10 |
1558439 | 1558439 | 2021-07-27 | Johnson | Nebraska | 31097 | 656 | 10 |
1555192 | 1555192 | 2021-07-26 | Johnson | Nebraska | 31097 | 656 | 10 |
1551945 | 1551945 | 2021-07-25 | Johnson | Nebraska | 31097 | 656 | 10 |
1548698 | 1548698 | 2021-07-24 | Johnson | Nebraska | 31097 | 656 | 10 |
1545451 | 1545451 | 2021-07-23 | Johnson | Nebraska | 31097 | 656 | 10 |
1542203 | 1542203 | 2021-07-22 | Johnson | Nebraska | 31097 | 656 | 10 |
1538956 | 1538956 | 2021-07-21 | Johnson | Nebraska | 31097 | 656 | 10 |
1535709 | 1535709 | 2021-07-20 | Johnson | Nebraska | 31097 | 656 | 10 |
1532461 | 1532461 | 2021-07-19 | Johnson | Nebraska | 31097 | 656 | 10 |
1529214 | 1529214 | 2021-07-18 | Johnson | Nebraska | 31097 | 656 | 10 |
1525967 | 1525967 | 2021-07-17 | Johnson | Nebraska | 31097 | 656 | 10 |
1522720 | 1522720 | 2021-07-16 | Johnson | Nebraska | 31097 | 656 | 10 |
1519471 | 1519471 | 2021-07-15 | Johnson | Nebraska | 31097 | 656 | 10 |
1516224 | 1516224 | 2021-07-14 | Johnson | Nebraska | 31097 | 656 | 10 |
1512978 | 1512978 | 2021-07-13 | Johnson | Nebraska | 31097 | 656 | 10 |
1509731 | 1509731 | 2021-07-12 | Johnson | Nebraska | 31097 | 656 | 10 |
1506485 | 1506485 | 2021-07-11 | Johnson | Nebraska | 31097 | 656 | 10 |
1503239 | 1503239 | 2021-07-10 | Johnson | Nebraska | 31097 | 656 | 10 |
1499993 | 1499993 | 2021-07-09 | Johnson | Nebraska | 31097 | 656 | 10 |
1496747 | 1496747 | 2021-07-08 | Johnson | Nebraska | 31097 | 656 | 10 |
1493500 | 1493500 | 2021-07-07 | Johnson | Nebraska | 31097 | 656 | 10 |
1490253 | 1490253 | 2021-07-06 | Johnson | Nebraska | 31097 | 656 | 10 |
1487006 | 1487006 | 2021-07-05 | Johnson | Nebraska | 31097 | 656 | 10 |
1483760 | 1483760 | 2021-07-04 | Johnson | Nebraska | 31097 | 656 | 10 |
1480514 | 1480514 | 2021-07-03 | Johnson | Nebraska | 31097 | 656 | 10 |
1477267 | 1477267 | 2021-07-02 | Johnson | Nebraska | 31097 | 656 | 10 |
1474021 | 1474021 | 2021-07-01 | Johnson | Nebraska | 31097 | 656 | 10 |
1470775 | 1470775 | 2021-06-30 | Johnson | Nebraska | 31097 | 656 | 10 |
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);