ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Pierce" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815105 | 1815105 | 2021-10-14 | Pierce | Nebraska | 31139 | 760 | 21 |
1811857 | 1811857 | 2021-10-13 | Pierce | Nebraska | 31139 | 756 | 21 |
1808608 | 1808608 | 2021-10-12 | Pierce | Nebraska | 31139 | 746 | 21 |
1805357 | 1805357 | 2021-10-11 | Pierce | Nebraska | 31139 | 737 | 21 |
1802108 | 1802108 | 2021-10-10 | Pierce | Nebraska | 31139 | 737 | 21 |
1798859 | 1798859 | 2021-10-09 | Pierce | Nebraska | 31139 | 737 | 21 |
1795610 | 1795610 | 2021-10-08 | Pierce | Nebraska | 31139 | 737 | 21 |
1792361 | 1792361 | 2021-10-07 | Pierce | Nebraska | 31139 | 735 | 21 |
1789112 | 1789112 | 2021-10-06 | Pierce | Nebraska | 31139 | 734 | 21 |
1785864 | 1785864 | 2021-10-05 | Pierce | Nebraska | 31139 | 728 | 21 |
1782615 | 1782615 | 2021-10-04 | Pierce | Nebraska | 31139 | 727 | 21 |
1779365 | 1779365 | 2021-10-03 | Pierce | Nebraska | 31139 | 723 | 21 |
1776115 | 1776115 | 2021-10-02 | Pierce | Nebraska | 31139 | 723 | 21 |
1772865 | 1772865 | 2021-10-01 | Pierce | Nebraska | 31139 | 723 | 21 |
1769616 | 1769616 | 2021-09-30 | Pierce | Nebraska | 31139 | 720 | 21 |
1766367 | 1766367 | 2021-09-29 | Pierce | Nebraska | 31139 | 717 | 21 |
1763118 | 1763118 | 2021-09-28 | Pierce | Nebraska | 31139 | 716 | 21 |
1759869 | 1759869 | 2021-09-27 | Pierce | Nebraska | 31139 | 714 | 21 |
1756621 | 1756621 | 2021-09-26 | Pierce | Nebraska | 31139 | 713 | 21 |
1753373 | 1753373 | 2021-09-25 | Pierce | Nebraska | 31139 | 713 | 21 |
1750125 | 1750125 | 2021-09-24 | Pierce | Nebraska | 31139 | 713 | 21 |
1746875 | 1746875 | 2021-09-23 | Pierce | Nebraska | 31139 | 710 | 21 |
1743626 | 1743626 | 2021-09-22 | Pierce | Nebraska | 31139 | 709 | 21 |
1740377 | 1740377 | 2021-09-21 | Pierce | Nebraska | 31139 | 705 | 21 |
1737128 | 1737128 | 2021-09-20 | Pierce | Nebraska | 31139 | 703 | 21 |
1733878 | 1733878 | 2021-09-19 | Pierce | Nebraska | 31139 | 734 | 21 |
1730628 | 1730628 | 2021-09-18 | Pierce | Nebraska | 31139 | 734 | 21 |
1727378 | 1727378 | 2021-09-17 | Pierce | Nebraska | 31139 | 734 | 21 |
1724129 | 1724129 | 2021-09-16 | Pierce | Nebraska | 31139 | 734 | 21 |
1720880 | 1720880 | 2021-09-15 | Pierce | Nebraska | 31139 | 734 | 21 |
1717632 | 1717632 | 2021-09-14 | Pierce | Nebraska | 31139 | 734 | 21 |
1714384 | 1714384 | 2021-09-13 | Pierce | Nebraska | 31139 | 734 | 21 |
1711138 | 1711138 | 2021-09-12 | Pierce | Nebraska | 31139 | 734 | 21 |
1707891 | 1707891 | 2021-09-11 | Pierce | Nebraska | 31139 | 734 | 21 |
1704644 | 1704644 | 2021-09-10 | Pierce | Nebraska | 31139 | 734 | 21 |
1701394 | 1701394 | 2021-09-09 | Pierce | Nebraska | 31139 | 734 | 21 |
1698145 | 1698145 | 2021-09-08 | Pierce | Nebraska | 31139 | 734 | 21 |
1694897 | 1694897 | 2021-09-07 | Pierce | Nebraska | 31139 | 734 | 21 |
1691648 | 1691648 | 2021-09-06 | Pierce | Nebraska | 31139 | 734 | 21 |
1688398 | 1688398 | 2021-09-05 | Pierce | Nebraska | 31139 | 734 | 21 |
1685148 | 1685148 | 2021-09-04 | Pierce | Nebraska | 31139 | 734 | 21 |
1681897 | 1681897 | 2021-09-03 | Pierce | Nebraska | 31139 | 734 | 21 |
1678649 | 1678649 | 2021-09-02 | Pierce | Nebraska | 31139 | 734 | 21 |
1675401 | 1675401 | 2021-09-01 | Pierce | Nebraska | 31139 | 734 | 21 |
1672153 | 1672153 | 2021-08-31 | Pierce | Nebraska | 31139 | 734 | 21 |
1668906 | 1668906 | 2021-08-30 | Pierce | Nebraska | 31139 | 734 | 21 |
1665659 | 1665659 | 2021-08-29 | Pierce | Nebraska | 31139 | 734 | 21 |
1662411 | 1662411 | 2021-08-28 | Pierce | Nebraska | 31139 | 734 | 21 |
1659163 | 1659163 | 2021-08-27 | Pierce | Nebraska | 31139 | 734 | 21 |
1655914 | 1655914 | 2021-08-26 | Pierce | Nebraska | 31139 | 734 | 21 |
1652667 | 1652667 | 2021-08-25 | Pierce | Nebraska | 31139 | 734 | 21 |
1649419 | 1649419 | 2021-08-24 | Pierce | Nebraska | 31139 | 734 | 21 |
1646170 | 1646170 | 2021-08-23 | Pierce | Nebraska | 31139 | 734 | 21 |
1642921 | 1642921 | 2021-08-22 | Pierce | Nebraska | 31139 | 734 | 21 |
1639671 | 1639671 | 2021-08-21 | Pierce | Nebraska | 31139 | 734 | 21 |
1636421 | 1636421 | 2021-08-20 | Pierce | Nebraska | 31139 | 734 | 21 |
1633171 | 1633171 | 2021-08-19 | Pierce | Nebraska | 31139 | 734 | 21 |
1629924 | 1629924 | 2021-08-18 | Pierce | Nebraska | 31139 | 734 | 21 |
1626677 | 1626677 | 2021-08-17 | Pierce | Nebraska | 31139 | 734 | 21 |
1623430 | 1623430 | 2021-08-16 | Pierce | Nebraska | 31139 | 734 | 21 |
1620183 | 1620183 | 2021-08-15 | Pierce | Nebraska | 31139 | 734 | 21 |
1616935 | 1616935 | 2021-08-14 | Pierce | Nebraska | 31139 | 734 | 21 |
1613687 | 1613687 | 2021-08-13 | Pierce | Nebraska | 31139 | 734 | 21 |
1610438 | 1610438 | 2021-08-12 | Pierce | Nebraska | 31139 | 734 | 21 |
1607190 | 1607190 | 2021-08-11 | Pierce | Nebraska | 31139 | 734 | 21 |
1603941 | 1603941 | 2021-08-10 | Pierce | Nebraska | 31139 | 734 | 21 |
1600692 | 1600692 | 2021-08-09 | Pierce | Nebraska | 31139 | 734 | 21 |
1597444 | 1597444 | 2021-08-08 | Pierce | Nebraska | 31139 | 734 | 21 |
1594195 | 1594195 | 2021-08-07 | Pierce | Nebraska | 31139 | 734 | 21 |
1590946 | 1590946 | 2021-08-06 | Pierce | Nebraska | 31139 | 734 | 21 |
1587697 | 1587697 | 2021-08-05 | Pierce | Nebraska | 31139 | 734 | 21 |
1584446 | 1584446 | 2021-08-04 | Pierce | Nebraska | 31139 | 734 | 21 |
1581197 | 1581197 | 2021-08-03 | Pierce | Nebraska | 31139 | 734 | 21 |
1577948 | 1577948 | 2021-08-02 | Pierce | Nebraska | 31139 | 734 | 21 |
1574700 | 1574700 | 2021-08-01 | Pierce | Nebraska | 31139 | 734 | 21 |
1571452 | 1571452 | 2021-07-31 | Pierce | Nebraska | 31139 | 734 | 21 |
1568204 | 1568204 | 2021-07-30 | Pierce | Nebraska | 31139 | 734 | 21 |
1564956 | 1564956 | 2021-07-29 | Pierce | Nebraska | 31139 | 734 | 21 |
1561708 | 1561708 | 2021-07-28 | Pierce | Nebraska | 31139 | 734 | 21 |
1558460 | 1558460 | 2021-07-27 | Pierce | Nebraska | 31139 | 734 | 21 |
1555213 | 1555213 | 2021-07-26 | Pierce | Nebraska | 31139 | 734 | 21 |
1551966 | 1551966 | 2021-07-25 | Pierce | Nebraska | 31139 | 734 | 21 |
1548719 | 1548719 | 2021-07-24 | Pierce | Nebraska | 31139 | 734 | 21 |
1545472 | 1545472 | 2021-07-23 | Pierce | Nebraska | 31139 | 734 | 21 |
1542224 | 1542224 | 2021-07-22 | Pierce | Nebraska | 31139 | 734 | 21 |
1538977 | 1538977 | 2021-07-21 | Pierce | Nebraska | 31139 | 734 | 21 |
1535730 | 1535730 | 2021-07-20 | Pierce | Nebraska | 31139 | 734 | 21 |
1532482 | 1532482 | 2021-07-19 | Pierce | Nebraska | 31139 | 734 | 21 |
1529235 | 1529235 | 2021-07-18 | Pierce | Nebraska | 31139 | 732 | 20 |
1525988 | 1525988 | 2021-07-17 | Pierce | Nebraska | 31139 | 732 | 20 |
1522741 | 1522741 | 2021-07-16 | Pierce | Nebraska | 31139 | 732 | 20 |
1519492 | 1519492 | 2021-07-15 | Pierce | Nebraska | 31139 | 732 | 20 |
1516245 | 1516245 | 2021-07-14 | Pierce | Nebraska | 31139 | 732 | 20 |
1512999 | 1512999 | 2021-07-13 | Pierce | Nebraska | 31139 | 732 | 20 |
1509752 | 1509752 | 2021-07-12 | Pierce | Nebraska | 31139 | 732 | 20 |
1506506 | 1506506 | 2021-07-11 | Pierce | Nebraska | 31139 | 732 | 20 |
1503260 | 1503260 | 2021-07-10 | Pierce | Nebraska | 31139 | 732 | 20 |
1500014 | 1500014 | 2021-07-09 | Pierce | Nebraska | 31139 | 732 | 20 |
1496768 | 1496768 | 2021-07-08 | Pierce | Nebraska | 31139 | 732 | 20 |
1493521 | 1493521 | 2021-07-07 | Pierce | Nebraska | 31139 | 732 | 20 |
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);