ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where deaths = 11, fips = 38057 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 |
---|---|---|---|---|---|---|---|
1795904 | 1795904 | 2021-10-08 | Mercer | North Dakota | 38057 | 1593 | 11 |
1792655 | 1792655 | 2021-10-07 | Mercer | North Dakota | 38057 | 1572 | 11 |
1789406 | 1789406 | 2021-10-06 | Mercer | North Dakota | 38057 | 1547 | 11 |
1786158 | 1786158 | 2021-10-05 | Mercer | North Dakota | 38057 | 1528 | 11 |
1782909 | 1782909 | 2021-10-04 | Mercer | North Dakota | 38057 | 1492 | 11 |
1779660 | 1779660 | 2021-10-03 | Mercer | North Dakota | 38057 | 1487 | 11 |
1776410 | 1776410 | 2021-10-02 | Mercer | North Dakota | 38057 | 1475 | 11 |
1773160 | 1773160 | 2021-10-01 | Mercer | North Dakota | 38057 | 1454 | 11 |
1769910 | 1769910 | 2021-09-30 | Mercer | North Dakota | 38057 | 1442 | 11 |
1766661 | 1766661 | 2021-09-29 | Mercer | North Dakota | 38057 | 1429 | 11 |
1763412 | 1763412 | 2021-09-28 | Mercer | North Dakota | 38057 | 1404 | 11 |
1760163 | 1760163 | 2021-09-27 | Mercer | North Dakota | 38057 | 1388 | 11 |
1756915 | 1756915 | 2021-09-26 | Mercer | North Dakota | 38057 | 1384 | 11 |
1753667 | 1753667 | 2021-09-25 | Mercer | North Dakota | 38057 | 1381 | 11 |
1750419 | 1750419 | 2021-09-24 | Mercer | North Dakota | 38057 | 1369 | 11 |
1747169 | 1747169 | 2021-09-23 | Mercer | North Dakota | 38057 | 1362 | 11 |
1743920 | 1743920 | 2021-09-22 | Mercer | North Dakota | 38057 | 1354 | 11 |
1740671 | 1740671 | 2021-09-21 | Mercer | North Dakota | 38057 | 1341 | 11 |
1737422 | 1737422 | 2021-09-20 | Mercer | North Dakota | 38057 | 1328 | 11 |
1734172 | 1734172 | 2021-09-19 | Mercer | North Dakota | 38057 | 1322 | 11 |
1730922 | 1730922 | 2021-09-18 | Mercer | North Dakota | 38057 | 1319 | 11 |
1727672 | 1727672 | 2021-09-17 | Mercer | North Dakota | 38057 | 1306 | 11 |
1724423 | 1724423 | 2021-09-16 | Mercer | North Dakota | 38057 | 1302 | 11 |
1721174 | 1721174 | 2021-09-15 | Mercer | North Dakota | 38057 | 1296 | 11 |
1717926 | 1717926 | 2021-09-14 | Mercer | North Dakota | 38057 | 1286 | 11 |
1714678 | 1714678 | 2021-09-13 | Mercer | North Dakota | 38057 | 1284 | 11 |
1711432 | 1711432 | 2021-09-12 | Mercer | North Dakota | 38057 | 1283 | 11 |
1708185 | 1708185 | 2021-09-11 | Mercer | North Dakota | 38057 | 1282 | 11 |
1704938 | 1704938 | 2021-09-10 | Mercer | North Dakota | 38057 | 1278 | 11 |
1701688 | 1701688 | 2021-09-09 | Mercer | North Dakota | 38057 | 1272 | 11 |
1698439 | 1698439 | 2021-09-08 | Mercer | North Dakota | 38057 | 1262 | 11 |
1695191 | 1695191 | 2021-09-07 | Mercer | North Dakota | 38057 | 1253 | 11 |
1691943 | 1691943 | 2021-09-06 | Mercer | North Dakota | 38057 | 1251 | 11 |
1688693 | 1688693 | 2021-09-05 | Mercer | North Dakota | 38057 | 1250 | 11 |
1685443 | 1685443 | 2021-09-04 | Mercer | North Dakota | 38057 | 1247 | 11 |
1682192 | 1682192 | 2021-09-03 | Mercer | North Dakota | 38057 | 1241 | 11 |
1678943 | 1678943 | 2021-09-02 | Mercer | North Dakota | 38057 | 1238 | 11 |
1675695 | 1675695 | 2021-09-01 | Mercer | North Dakota | 38057 | 1231 | 11 |
1672448 | 1672448 | 2021-08-31 | Mercer | North Dakota | 38057 | 1226 | 11 |
1669200 | 1669200 | 2021-08-30 | Mercer | North Dakota | 38057 | 1222 | 11 |
1665953 | 1665953 | 2021-08-29 | Mercer | North Dakota | 38057 | 1220 | 11 |
1662705 | 1662705 | 2021-08-28 | Mercer | North Dakota | 38057 | 1220 | 11 |
1659457 | 1659457 | 2021-08-27 | Mercer | North Dakota | 38057 | 1216 | 11 |
1656208 | 1656208 | 2021-08-26 | Mercer | North Dakota | 38057 | 1213 | 11 |
1652961 | 1652961 | 2021-08-25 | Mercer | North Dakota | 38057 | 1209 | 11 |
1649713 | 1649713 | 2021-08-24 | Mercer | North Dakota | 38057 | 1206 | 11 |
1646464 | 1646464 | 2021-08-23 | Mercer | North Dakota | 38057 | 1204 | 11 |
1643215 | 1643215 | 2021-08-22 | Mercer | North Dakota | 38057 | 1204 | 11 |
1639965 | 1639965 | 2021-08-21 | Mercer | North Dakota | 38057 | 1204 | 11 |
1636715 | 1636715 | 2021-08-20 | Mercer | North Dakota | 38057 | 1204 | 11 |
1633465 | 1633465 | 2021-08-19 | Mercer | North Dakota | 38057 | 1203 | 11 |
1630218 | 1630218 | 2021-08-18 | Mercer | North Dakota | 38057 | 1201 | 11 |
1626971 | 1626971 | 2021-08-17 | Mercer | North Dakota | 38057 | 1198 | 11 |
1623724 | 1623724 | 2021-08-16 | Mercer | North Dakota | 38057 | 1196 | 11 |
1620477 | 1620477 | 2021-08-15 | Mercer | North Dakota | 38057 | 1195 | 11 |
1617229 | 1617229 | 2021-08-14 | Mercer | North Dakota | 38057 | 1194 | 11 |
1613981 | 1613981 | 2021-08-13 | Mercer | North Dakota | 38057 | 1193 | 11 |
1610732 | 1610732 | 2021-08-12 | Mercer | North Dakota | 38057 | 1193 | 11 |
1607484 | 1607484 | 2021-08-11 | Mercer | North Dakota | 38057 | 1188 | 11 |
1604235 | 1604235 | 2021-08-10 | Mercer | North Dakota | 38057 | 1187 | 11 |
1600986 | 1600986 | 2021-08-09 | Mercer | North Dakota | 38057 | 1183 | 11 |
1597738 | 1597738 | 2021-08-08 | Mercer | North Dakota | 38057 | 1183 | 11 |
1594489 | 1594489 | 2021-08-07 | Mercer | North Dakota | 38057 | 1183 | 11 |
1591240 | 1591240 | 2021-08-06 | Mercer | North Dakota | 38057 | 1181 | 11 |
1587991 | 1587991 | 2021-08-05 | Mercer | North Dakota | 38057 | 1181 | 11 |
1584741 | 1584741 | 2021-08-04 | Mercer | North Dakota | 38057 | 1179 | 11 |
1581491 | 1581491 | 2021-08-03 | Mercer | North Dakota | 38057 | 1178 | 11 |
1578242 | 1578242 | 2021-08-02 | Mercer | North Dakota | 38057 | 1178 | 11 |
1574994 | 1574994 | 2021-08-01 | Mercer | North Dakota | 38057 | 1178 | 11 |
1571746 | 1571746 | 2021-07-31 | Mercer | North Dakota | 38057 | 1178 | 11 |
1568498 | 1568498 | 2021-07-30 | Mercer | North Dakota | 38057 | 1178 | 11 |
1565250 | 1565250 | 2021-07-29 | Mercer | North Dakota | 38057 | 1176 | 11 |
1562002 | 1562002 | 2021-07-28 | Mercer | North Dakota | 38057 | 1176 | 11 |
1558754 | 1558754 | 2021-07-27 | Mercer | North Dakota | 38057 | 1175 | 11 |
1555507 | 1555507 | 2021-07-26 | Mercer | North Dakota | 38057 | 1175 | 11 |
1552260 | 1552260 | 2021-07-25 | Mercer | North Dakota | 38057 | 1175 | 11 |
1549013 | 1549013 | 2021-07-24 | Mercer | North Dakota | 38057 | 1175 | 11 |
1545766 | 1545766 | 2021-07-23 | Mercer | North Dakota | 38057 | 1175 | 11 |
1542519 | 1542519 | 2021-07-22 | Mercer | North Dakota | 38057 | 1175 | 11 |
1539271 | 1539271 | 2021-07-21 | Mercer | North Dakota | 38057 | 1175 | 11 |
1536024 | 1536024 | 2021-07-20 | Mercer | North Dakota | 38057 | 1175 | 11 |
1532776 | 1532776 | 2021-07-19 | Mercer | North Dakota | 38057 | 1173 | 11 |
1529529 | 1529529 | 2021-07-18 | Mercer | North Dakota | 38057 | 1173 | 11 |
1526282 | 1526282 | 2021-07-17 | Mercer | North Dakota | 38057 | 1173 | 11 |
1523035 | 1523035 | 2021-07-16 | Mercer | North Dakota | 38057 | 1173 | 11 |
1519787 | 1519787 | 2021-07-15 | Mercer | North Dakota | 38057 | 1173 | 11 |
1516539 | 1516539 | 2021-07-14 | Mercer | North Dakota | 38057 | 1172 | 11 |
1513292 | 1513292 | 2021-07-13 | Mercer | North Dakota | 38057 | 1172 | 11 |
1510046 | 1510046 | 2021-07-12 | Mercer | North Dakota | 38057 | 1172 | 11 |
1506799 | 1506799 | 2021-07-11 | Mercer | North Dakota | 38057 | 1172 | 11 |
1503553 | 1503553 | 2021-07-10 | Mercer | North Dakota | 38057 | 1172 | 11 |
1500307 | 1500307 | 2021-07-09 | Mercer | North Dakota | 38057 | 1170 | 11 |
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);