ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 46093 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718400 | 1718400 | 2021-09-14 | Meade | South Dakota | 46093 | 3831 | 36 |
1715152 | 1715152 | 2021-09-13 | Meade | South Dakota | 46093 | 3766 | 35 |
1711906 | 1711906 | 2021-09-12 | Meade | South Dakota | 46093 | 3728 | 34 |
1708659 | 1708659 | 2021-09-11 | Meade | South Dakota | 46093 | 3728 | 34 |
1705412 | 1705412 | 2021-09-10 | Meade | South Dakota | 46093 | 3728 | 34 |
1702162 | 1702162 | 2021-09-09 | Meade | South Dakota | 46093 | 3692 | 33 |
1698913 | 1698913 | 2021-09-08 | Meade | South Dakota | 46093 | 3666 | 33 |
1695665 | 1695665 | 2021-09-07 | Meade | South Dakota | 46093 | 3591 | 33 |
1692417 | 1692417 | 2021-09-06 | Meade | South Dakota | 46093 | 3559 | 33 |
1689168 | 1689168 | 2021-09-05 | Meade | South Dakota | 46093 | 3559 | 33 |
1685918 | 1685918 | 2021-09-04 | Meade | South Dakota | 46093 | 3559 | 33 |
1682667 | 1682667 | 2021-09-03 | Meade | South Dakota | 46093 | 3559 | 33 |
1679417 | 1679417 | 2021-09-02 | Meade | South Dakota | 46093 | 3515 | 33 |
1676169 | 1676169 | 2021-09-01 | Meade | South Dakota | 46093 | 3472 | 32 |
1672922 | 1672922 | 2021-08-31 | Meade | South Dakota | 46093 | 3432 | 32 |
1669674 | 1669674 | 2021-08-30 | Meade | South Dakota | 46093 | 3335 | 32 |
1666427 | 1666427 | 2021-08-29 | Meade | South Dakota | 46093 | 3301 | 31 |
1663179 | 1663179 | 2021-08-28 | Meade | South Dakota | 46093 | 3301 | 31 |
1659931 | 1659931 | 2021-08-27 | Meade | South Dakota | 46093 | 3301 | 31 |
1656682 | 1656682 | 2021-08-26 | Meade | South Dakota | 46093 | 3249 | 31 |
1653435 | 1653435 | 2021-08-25 | Meade | South Dakota | 46093 | 3206 | 31 |
1650188 | 1650188 | 2021-08-24 | Meade | South Dakota | 46093 | 3168 | 31 |
1646939 | 1646939 | 2021-08-23 | Meade | South Dakota | 46093 | 3086 | 31 |
1643690 | 1643690 | 2021-08-22 | Meade | South Dakota | 46093 | 3028 | 31 |
1640440 | 1640440 | 2021-08-21 | Meade | South Dakota | 46093 | 3028 | 31 |
1637190 | 1637190 | 2021-08-20 | Meade | South Dakota | 46093 | 3028 | 31 |
1633940 | 1633940 | 2021-08-19 | Meade | South Dakota | 46093 | 3000 | 31 |
1630693 | 1630693 | 2021-08-18 | Meade | South Dakota | 46093 | 2974 | 31 |
1627446 | 1627446 | 2021-08-17 | Meade | South Dakota | 46093 | 2922 | 31 |
1624199 | 1624199 | 2021-08-16 | Meade | South Dakota | 46093 | 2886 | 31 |
1620952 | 1620952 | 2021-08-15 | Meade | South Dakota | 46093 | 2875 | 31 |
1617704 | 1617704 | 2021-08-14 | Meade | South Dakota | 46093 | 2875 | 31 |
1614456 | 1614456 | 2021-08-13 | Meade | South Dakota | 46093 | 2875 | 31 |
1611207 | 1611207 | 2021-08-12 | Meade | South Dakota | 46093 | 2873 | 31 |
1607959 | 1607959 | 2021-08-11 | Meade | South Dakota | 46093 | 2867 | 31 |
1604710 | 1604710 | 2021-08-10 | Meade | South Dakota | 46093 | 2838 | 31 |
1601461 | 1601461 | 2021-08-09 | Meade | South Dakota | 46093 | 2838 | 31 |
1598213 | 1598213 | 2021-08-08 | Meade | South Dakota | 46093 | 2838 | 31 |
1594964 | 1594964 | 2021-08-07 | Meade | South Dakota | 46093 | 2838 | 31 |
1591715 | 1591715 | 2021-08-06 | Meade | South Dakota | 46093 | 2838 | 31 |
1588466 | 1588466 | 2021-08-05 | Meade | South Dakota | 46093 | 2838 | 31 |
1585216 | 1585216 | 2021-08-04 | Meade | South Dakota | 46093 | 2838 | 31 |
1581966 | 1581966 | 2021-08-03 | Meade | South Dakota | 46093 | 2823 | 31 |
1578717 | 1578717 | 2021-08-02 | Meade | South Dakota | 46093 | 2823 | 31 |
1575469 | 1575469 | 2021-08-01 | Meade | South Dakota | 46093 | 2823 | 31 |
1572221 | 1572221 | 2021-07-31 | Meade | South Dakota | 46093 | 2823 | 31 |
1568973 | 1568973 | 2021-07-30 | Meade | South Dakota | 46093 | 2823 | 31 |
1565725 | 1565725 | 2021-07-29 | Meade | South Dakota | 46093 | 2823 | 31 |
1562477 | 1562477 | 2021-07-28 | Meade | South Dakota | 46093 | 2823 | 31 |
1559229 | 1559229 | 2021-07-27 | Meade | South Dakota | 46093 | 2818 | 31 |
1555982 | 1555982 | 2021-07-26 | Meade | South Dakota | 46093 | 2818 | 31 |
1552735 | 1552735 | 2021-07-25 | Meade | South Dakota | 46093 | 2818 | 31 |
1549488 | 1549488 | 2021-07-24 | Meade | South Dakota | 46093 | 2818 | 31 |
1546241 | 1546241 | 2021-07-23 | Meade | South Dakota | 46093 | 2818 | 31 |
1542994 | 1542994 | 2021-07-22 | Meade | South Dakota | 46093 | 2818 | 31 |
1539746 | 1539746 | 2021-07-21 | Meade | South Dakota | 46093 | 2818 | 31 |
1536499 | 1536499 | 2021-07-20 | Meade | South Dakota | 46093 | 2809 | 31 |
1533251 | 1533251 | 2021-07-19 | Meade | South Dakota | 46093 | 2809 | 31 |
1530004 | 1530004 | 2021-07-18 | Meade | South Dakota | 46093 | 2809 | 31 |
1526757 | 1526757 | 2021-07-17 | Meade | South Dakota | 46093 | 2809 | 31 |
1523510 | 1523510 | 2021-07-16 | Meade | South Dakota | 46093 | 2809 | 31 |
1520262 | 1520262 | 2021-07-15 | Meade | South Dakota | 46093 | 2809 | 31 |
1517014 | 1517014 | 2021-07-14 | Meade | South Dakota | 46093 | 2809 | 31 |
1513767 | 1513767 | 2021-07-13 | Meade | South Dakota | 46093 | 2805 | 31 |
1510521 | 1510521 | 2021-07-12 | Meade | South Dakota | 46093 | 2805 | 31 |
1507274 | 1507274 | 2021-07-11 | Meade | South Dakota | 46093 | 2805 | 31 |
1504028 | 1504028 | 2021-07-10 | Meade | South Dakota | 46093 | 2805 | 31 |
1500782 | 1500782 | 2021-07-09 | Meade | South Dakota | 46093 | 2805 | 31 |
1497536 | 1497536 | 2021-07-08 | Meade | South Dakota | 46093 | 2805 | 31 |
1494289 | 1494289 | 2021-07-07 | Meade | South Dakota | 46093 | 2805 | 31 |
1491042 | 1491042 | 2021-07-06 | Meade | South Dakota | 46093 | 2801 | 31 |
1487795 | 1487795 | 2021-07-05 | Meade | South Dakota | 46093 | 2801 | 31 |
1484548 | 1484548 | 2021-07-04 | Meade | South Dakota | 46093 | 2801 | 31 |
1481302 | 1481302 | 2021-07-03 | Meade | South Dakota | 46093 | 2801 | 31 |
1478055 | 1478055 | 2021-07-02 | Meade | South Dakota | 46093 | 2801 | 31 |
1474809 | 1474809 | 2021-07-01 | Meade | South Dakota | 46093 | 2801 | 31 |
1471563 | 1471563 | 2021-06-30 | Meade | South Dakota | 46093 | 2801 | 31 |
1468318 | 1468318 | 2021-06-29 | Meade | South Dakota | 46093 | 2798 | 31 |
1465073 | 1465073 | 2021-06-28 | Meade | South Dakota | 46093 | 2798 | 31 |
1461828 | 1461828 | 2021-06-27 | Meade | South Dakota | 46093 | 2797 | 31 |
1458583 | 1458583 | 2021-06-26 | Meade | South Dakota | 46093 | 2797 | 31 |
1455338 | 1455338 | 2021-06-25 | Meade | South Dakota | 46093 | 2797 | 31 |
1452093 | 1452093 | 2021-06-24 | Meade | South Dakota | 46093 | 2794 | 31 |
1448847 | 1448847 | 2021-06-23 | Meade | South Dakota | 46093 | 2794 | 31 |
1445602 | 1445602 | 2021-06-22 | Meade | South Dakota | 46093 | 2794 | 31 |
1442357 | 1442357 | 2021-06-21 | Meade | South Dakota | 46093 | 2795 | 31 |
1439112 | 1439112 | 2021-06-20 | Meade | South Dakota | 46093 | 2795 | 31 |
1435865 | 1435865 | 2021-06-19 | Meade | South Dakota | 46093 | 2795 | 31 |
1432618 | 1432618 | 2021-06-18 | Meade | South Dakota | 46093 | 2795 | 31 |
1429372 | 1429372 | 2021-06-17 | Meade | South Dakota | 46093 | 2795 | 31 |
1426127 | 1426127 | 2021-06-16 | Meade | South Dakota | 46093 | 2794 | 31 |
1422880 | 1422880 | 2021-06-15 | Meade | South Dakota | 46093 | 2796 | 31 |
1419634 | 1419634 | 2021-06-14 | Meade | South Dakota | 46093 | 2794 | 31 |
1416389 | 1416389 | 2021-06-13 | Meade | South Dakota | 46093 | 2794 | 31 |
1413143 | 1413143 | 2021-06-12 | Meade | South Dakota | 46093 | 2792 | 31 |
1409898 | 1409898 | 2021-06-11 | Meade | South Dakota | 46093 | 2792 | 31 |
1406653 | 1406653 | 2021-06-10 | Meade | South Dakota | 46093 | 2791 | 31 |
1403407 | 1403407 | 2021-06-09 | Meade | South Dakota | 46093 | 2790 | 31 |
1400162 | 1400162 | 2021-06-08 | Meade | South Dakota | 46093 | 2790 | 31 |
1396917 | 1396917 | 2021-06-07 | Meade | South Dakota | 46093 | 2788 | 31 |
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);