ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
242 rows where deaths = 28, fips = 38079 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1740682 | 1740682 | 2021-09-21 | Rolette | North Dakota | 38079 | 2416 | 28 |
1737433 | 1737433 | 2021-09-20 | Rolette | North Dakota | 38079 | 2407 | 28 |
1734183 | 1734183 | 2021-09-19 | Rolette | North Dakota | 38079 | 2400 | 28 |
1730933 | 1730933 | 2021-09-18 | Rolette | North Dakota | 38079 | 2397 | 28 |
1727683 | 1727683 | 2021-09-17 | Rolette | North Dakota | 38079 | 2386 | 28 |
1724434 | 1724434 | 2021-09-16 | Rolette | North Dakota | 38079 | 2375 | 28 |
1721185 | 1721185 | 2021-09-15 | Rolette | North Dakota | 38079 | 2366 | 28 |
1717937 | 1717937 | 2021-09-14 | Rolette | North Dakota | 38079 | 2344 | 28 |
1714689 | 1714689 | 2021-09-13 | Rolette | North Dakota | 38079 | 2332 | 28 |
1711443 | 1711443 | 2021-09-12 | Rolette | North Dakota | 38079 | 2330 | 28 |
1708196 | 1708196 | 2021-09-11 | Rolette | North Dakota | 38079 | 2326 | 28 |
1704949 | 1704949 | 2021-09-10 | Rolette | North Dakota | 38079 | 2307 | 28 |
1701699 | 1701699 | 2021-09-09 | Rolette | North Dakota | 38079 | 2304 | 28 |
1698450 | 1698450 | 2021-09-08 | Rolette | North Dakota | 38079 | 2285 | 28 |
1695202 | 1695202 | 2021-09-07 | Rolette | North Dakota | 38079 | 2280 | 28 |
1691954 | 1691954 | 2021-09-06 | Rolette | North Dakota | 38079 | 2280 | 28 |
1688704 | 1688704 | 2021-09-05 | Rolette | North Dakota | 38079 | 2279 | 28 |
1685454 | 1685454 | 2021-09-04 | Rolette | North Dakota | 38079 | 2279 | 28 |
1682203 | 1682203 | 2021-09-03 | Rolette | North Dakota | 38079 | 2272 | 28 |
1678954 | 1678954 | 2021-09-02 | Rolette | North Dakota | 38079 | 2269 | 28 |
1675706 | 1675706 | 2021-09-01 | Rolette | North Dakota | 38079 | 2259 | 28 |
1672459 | 1672459 | 2021-08-31 | Rolette | North Dakota | 38079 | 2250 | 28 |
1669211 | 1669211 | 2021-08-30 | Rolette | North Dakota | 38079 | 2249 | 28 |
1665964 | 1665964 | 2021-08-29 | Rolette | North Dakota | 38079 | 2248 | 28 |
1662716 | 1662716 | 2021-08-28 | Rolette | North Dakota | 38079 | 2248 | 28 |
1659468 | 1659468 | 2021-08-27 | Rolette | North Dakota | 38079 | 2242 | 28 |
1656219 | 1656219 | 2021-08-26 | Rolette | North Dakota | 38079 | 2239 | 28 |
1652972 | 1652972 | 2021-08-25 | Rolette | North Dakota | 38079 | 2236 | 28 |
1649724 | 1649724 | 2021-08-24 | Rolette | North Dakota | 38079 | 2232 | 28 |
1646475 | 1646475 | 2021-08-23 | Rolette | North Dakota | 38079 | 2223 | 28 |
1643226 | 1643226 | 2021-08-22 | Rolette | North Dakota | 38079 | 2222 | 28 |
1639976 | 1639976 | 2021-08-21 | Rolette | North Dakota | 38079 | 2217 | 28 |
1636726 | 1636726 | 2021-08-20 | Rolette | North Dakota | 38079 | 2209 | 28 |
1633476 | 1633476 | 2021-08-19 | Rolette | North Dakota | 38079 | 2194 | 28 |
1630229 | 1630229 | 2021-08-18 | Rolette | North Dakota | 38079 | 2194 | 28 |
1626982 | 1626982 | 2021-08-17 | Rolette | North Dakota | 38079 | 2189 | 28 |
1623735 | 1623735 | 2021-08-16 | Rolette | North Dakota | 38079 | 2182 | 28 |
1620488 | 1620488 | 2021-08-15 | Rolette | North Dakota | 38079 | 2182 | 28 |
1617240 | 1617240 | 2021-08-14 | Rolette | North Dakota | 38079 | 2182 | 28 |
1613992 | 1613992 | 2021-08-13 | Rolette | North Dakota | 38079 | 2179 | 28 |
1610743 | 1610743 | 2021-08-12 | Rolette | North Dakota | 38079 | 2177 | 28 |
1607495 | 1607495 | 2021-08-11 | Rolette | North Dakota | 38079 | 2175 | 28 |
1604246 | 1604246 | 2021-08-10 | Rolette | North Dakota | 38079 | 2173 | 28 |
1600997 | 1600997 | 2021-08-09 | Rolette | North Dakota | 38079 | 2166 | 28 |
1597749 | 1597749 | 2021-08-08 | Rolette | North Dakota | 38079 | 2166 | 28 |
1594500 | 1594500 | 2021-08-07 | Rolette | North Dakota | 38079 | 2164 | 28 |
1591251 | 1591251 | 2021-08-06 | Rolette | North Dakota | 38079 | 2164 | 28 |
1588002 | 1588002 | 2021-08-05 | Rolette | North Dakota | 38079 | 2163 | 28 |
1584752 | 1584752 | 2021-08-04 | Rolette | North Dakota | 38079 | 2163 | 28 |
1581502 | 1581502 | 2021-08-03 | Rolette | North Dakota | 38079 | 2163 | 28 |
1578253 | 1578253 | 2021-08-02 | Rolette | North Dakota | 38079 | 2162 | 28 |
1575005 | 1575005 | 2021-08-01 | Rolette | North Dakota | 38079 | 2162 | 28 |
1571757 | 1571757 | 2021-07-31 | Rolette | North Dakota | 38079 | 2162 | 28 |
1568509 | 1568509 | 2021-07-30 | Rolette | North Dakota | 38079 | 2162 | 28 |
1565261 | 1565261 | 2021-07-29 | Rolette | North Dakota | 38079 | 2162 | 28 |
1562013 | 1562013 | 2021-07-28 | Rolette | North Dakota | 38079 | 2162 | 28 |
1558765 | 1558765 | 2021-07-27 | Rolette | North Dakota | 38079 | 2162 | 28 |
1555518 | 1555518 | 2021-07-26 | Rolette | North Dakota | 38079 | 2162 | 28 |
1552271 | 1552271 | 2021-07-25 | Rolette | North Dakota | 38079 | 2162 | 28 |
1549024 | 1549024 | 2021-07-24 | Rolette | North Dakota | 38079 | 2162 | 28 |
1545777 | 1545777 | 2021-07-23 | Rolette | North Dakota | 38079 | 2162 | 28 |
1542530 | 1542530 | 2021-07-22 | Rolette | North Dakota | 38079 | 2162 | 28 |
1539282 | 1539282 | 2021-07-21 | Rolette | North Dakota | 38079 | 2162 | 28 |
1536035 | 1536035 | 2021-07-20 | Rolette | North Dakota | 38079 | 2162 | 28 |
1532787 | 1532787 | 2021-07-19 | Rolette | North Dakota | 38079 | 2162 | 28 |
1529540 | 1529540 | 2021-07-18 | Rolette | North Dakota | 38079 | 2162 | 28 |
1526293 | 1526293 | 2021-07-17 | Rolette | North Dakota | 38079 | 2162 | 28 |
1523046 | 1523046 | 2021-07-16 | Rolette | North Dakota | 38079 | 2162 | 28 |
1519798 | 1519798 | 2021-07-15 | Rolette | North Dakota | 38079 | 2161 | 28 |
1516550 | 1516550 | 2021-07-14 | Rolette | North Dakota | 38079 | 2161 | 28 |
1513303 | 1513303 | 2021-07-13 | Rolette | North Dakota | 38079 | 2161 | 28 |
1510057 | 1510057 | 2021-07-12 | Rolette | North Dakota | 38079 | 2161 | 28 |
1506810 | 1506810 | 2021-07-11 | Rolette | North Dakota | 38079 | 2161 | 28 |
1503564 | 1503564 | 2021-07-10 | Rolette | North Dakota | 38079 | 2161 | 28 |
1500318 | 1500318 | 2021-07-09 | Rolette | North Dakota | 38079 | 2161 | 28 |
1497072 | 1497072 | 2021-07-08 | Rolette | North Dakota | 38079 | 2161 | 28 |
1493825 | 1493825 | 2021-07-07 | Rolette | North Dakota | 38079 | 2161 | 28 |
1490578 | 1490578 | 2021-07-06 | Rolette | North Dakota | 38079 | 2161 | 28 |
1487331 | 1487331 | 2021-07-05 | Rolette | North Dakota | 38079 | 2161 | 28 |
1484085 | 1484085 | 2021-07-04 | Rolette | North Dakota | 38079 | 2161 | 28 |
1480839 | 1480839 | 2021-07-03 | Rolette | North Dakota | 38079 | 2161 | 28 |
1477592 | 1477592 | 2021-07-02 | Rolette | North Dakota | 38079 | 2161 | 28 |
1474346 | 1474346 | 2021-07-01 | Rolette | North Dakota | 38079 | 2161 | 28 |
1471100 | 1471100 | 2021-06-30 | Rolette | North Dakota | 38079 | 2161 | 28 |
1467855 | 1467855 | 2021-06-29 | Rolette | North Dakota | 38079 | 2161 | 28 |
1464610 | 1464610 | 2021-06-28 | Rolette | North Dakota | 38079 | 2161 | 28 |
1461365 | 1461365 | 2021-06-27 | Rolette | North Dakota | 38079 | 2161 | 28 |
1458120 | 1458120 | 2021-06-26 | Rolette | North Dakota | 38079 | 2161 | 28 |
1454875 | 1454875 | 2021-06-25 | Rolette | North Dakota | 38079 | 2161 | 28 |
1451630 | 1451630 | 2021-06-24 | Rolette | North Dakota | 38079 | 2161 | 28 |
1448384 | 1448384 | 2021-06-23 | Rolette | North Dakota | 38079 | 2161 | 28 |
1445139 | 1445139 | 2021-06-22 | Rolette | North Dakota | 38079 | 2161 | 28 |
1441894 | 1441894 | 2021-06-21 | Rolette | North Dakota | 38079 | 2161 | 28 |
1438649 | 1438649 | 2021-06-20 | Rolette | North Dakota | 38079 | 2161 | 28 |
1435402 | 1435402 | 2021-06-19 | Rolette | North Dakota | 38079 | 2161 | 28 |
1432155 | 1432155 | 2021-06-18 | Rolette | North Dakota | 38079 | 2161 | 28 |
1428909 | 1428909 | 2021-06-17 | Rolette | North Dakota | 38079 | 2161 | 28 |
1425664 | 1425664 | 2021-06-16 | Rolette | North Dakota | 38079 | 2161 | 28 |
1422417 | 1422417 | 2021-06-15 | Rolette | North Dakota | 38079 | 2161 | 28 |
1419171 | 1419171 | 2021-06-14 | Rolette | North Dakota | 38079 | 2160 | 28 |
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);