ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 38031 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1623711 | 1623711 | 2021-08-16 | Foster | North Dakota | 38031 | 600 | 19 |
1620464 | 1620464 | 2021-08-15 | Foster | North Dakota | 38031 | 600 | 19 |
1617216 | 1617216 | 2021-08-14 | Foster | North Dakota | 38031 | 600 | 19 |
1613968 | 1613968 | 2021-08-13 | Foster | North Dakota | 38031 | 600 | 19 |
1610719 | 1610719 | 2021-08-12 | Foster | North Dakota | 38031 | 600 | 19 |
1607471 | 1607471 | 2021-08-11 | Foster | North Dakota | 38031 | 600 | 19 |
1604222 | 1604222 | 2021-08-10 | Foster | North Dakota | 38031 | 600 | 19 |
1600973 | 1600973 | 2021-08-09 | Foster | North Dakota | 38031 | 600 | 19 |
1597725 | 1597725 | 2021-08-08 | Foster | North Dakota | 38031 | 600 | 19 |
1594476 | 1594476 | 2021-08-07 | Foster | North Dakota | 38031 | 600 | 19 |
1591227 | 1591227 | 2021-08-06 | Foster | North Dakota | 38031 | 600 | 19 |
1587978 | 1587978 | 2021-08-05 | Foster | North Dakota | 38031 | 600 | 19 |
1584728 | 1584728 | 2021-08-04 | Foster | North Dakota | 38031 | 600 | 19 |
1581478 | 1581478 | 2021-08-03 | Foster | North Dakota | 38031 | 600 | 19 |
1578229 | 1578229 | 2021-08-02 | Foster | North Dakota | 38031 | 600 | 19 |
1574981 | 1574981 | 2021-08-01 | Foster | North Dakota | 38031 | 600 | 19 |
1571733 | 1571733 | 2021-07-31 | Foster | North Dakota | 38031 | 600 | 19 |
1568485 | 1568485 | 2021-07-30 | Foster | North Dakota | 38031 | 600 | 19 |
1565237 | 1565237 | 2021-07-29 | Foster | North Dakota | 38031 | 600 | 19 |
1561989 | 1561989 | 2021-07-28 | Foster | North Dakota | 38031 | 601 | 19 |
1558741 | 1558741 | 2021-07-27 | Foster | North Dakota | 38031 | 601 | 19 |
1555494 | 1555494 | 2021-07-26 | Foster | North Dakota | 38031 | 600 | 19 |
1552247 | 1552247 | 2021-07-25 | Foster | North Dakota | 38031 | 600 | 19 |
1549000 | 1549000 | 2021-07-24 | Foster | North Dakota | 38031 | 600 | 19 |
1545753 | 1545753 | 2021-07-23 | Foster | North Dakota | 38031 | 600 | 19 |
1542506 | 1542506 | 2021-07-22 | Foster | North Dakota | 38031 | 600 | 19 |
1539258 | 1539258 | 2021-07-21 | Foster | North Dakota | 38031 | 600 | 19 |
1536011 | 1536011 | 2021-07-20 | Foster | North Dakota | 38031 | 600 | 19 |
1532763 | 1532763 | 2021-07-19 | Foster | North Dakota | 38031 | 600 | 19 |
1529516 | 1529516 | 2021-07-18 | Foster | North Dakota | 38031 | 600 | 19 |
1526269 | 1526269 | 2021-07-17 | Foster | North Dakota | 38031 | 600 | 19 |
1523022 | 1523022 | 2021-07-16 | Foster | North Dakota | 38031 | 600 | 19 |
1519774 | 1519774 | 2021-07-15 | Foster | North Dakota | 38031 | 600 | 19 |
1516526 | 1516526 | 2021-07-14 | Foster | North Dakota | 38031 | 600 | 19 |
1513279 | 1513279 | 2021-07-13 | Foster | North Dakota | 38031 | 600 | 19 |
1510033 | 1510033 | 2021-07-12 | Foster | North Dakota | 38031 | 600 | 19 |
1506786 | 1506786 | 2021-07-11 | Foster | North Dakota | 38031 | 600 | 19 |
1503540 | 1503540 | 2021-07-10 | Foster | North Dakota | 38031 | 600 | 19 |
1500294 | 1500294 | 2021-07-09 | Foster | North Dakota | 38031 | 600 | 19 |
1497048 | 1497048 | 2021-07-08 | Foster | North Dakota | 38031 | 600 | 19 |
1493801 | 1493801 | 2021-07-07 | Foster | North Dakota | 38031 | 600 | 19 |
1490554 | 1490554 | 2021-07-06 | Foster | North Dakota | 38031 | 600 | 19 |
1487307 | 1487307 | 2021-07-05 | Foster | North Dakota | 38031 | 600 | 19 |
1484061 | 1484061 | 2021-07-04 | Foster | North Dakota | 38031 | 600 | 19 |
1480815 | 1480815 | 2021-07-03 | Foster | North Dakota | 38031 | 600 | 19 |
1477568 | 1477568 | 2021-07-02 | Foster | North Dakota | 38031 | 600 | 19 |
1474322 | 1474322 | 2021-07-01 | Foster | North Dakota | 38031 | 600 | 19 |
1471076 | 1471076 | 2021-06-30 | Foster | North Dakota | 38031 | 600 | 19 |
1467831 | 1467831 | 2021-06-29 | Foster | North Dakota | 38031 | 600 | 19 |
1464586 | 1464586 | 2021-06-28 | Foster | North Dakota | 38031 | 600 | 19 |
1461341 | 1461341 | 2021-06-27 | Foster | North Dakota | 38031 | 600 | 19 |
1458096 | 1458096 | 2021-06-26 | Foster | North Dakota | 38031 | 600 | 19 |
1454851 | 1454851 | 2021-06-25 | Foster | North Dakota | 38031 | 600 | 19 |
1451606 | 1451606 | 2021-06-24 | Foster | North Dakota | 38031 | 600 | 19 |
1448360 | 1448360 | 2021-06-23 | Foster | North Dakota | 38031 | 600 | 19 |
1445115 | 1445115 | 2021-06-22 | Foster | North Dakota | 38031 | 600 | 19 |
1441870 | 1441870 | 2021-06-21 | Foster | North Dakota | 38031 | 600 | 19 |
1438625 | 1438625 | 2021-06-20 | Foster | North Dakota | 38031 | 600 | 19 |
1435378 | 1435378 | 2021-06-19 | Foster | North Dakota | 38031 | 600 | 19 |
1432131 | 1432131 | 2021-06-18 | Foster | North Dakota | 38031 | 600 | 19 |
1428885 | 1428885 | 2021-06-17 | Foster | North Dakota | 38031 | 600 | 19 |
1425640 | 1425640 | 2021-06-16 | Foster | North Dakota | 38031 | 600 | 19 |
1422393 | 1422393 | 2021-06-15 | Foster | North Dakota | 38031 | 600 | 19 |
1419147 | 1419147 | 2021-06-14 | Foster | North Dakota | 38031 | 600 | 19 |
1415902 | 1415902 | 2021-06-13 | Foster | North Dakota | 38031 | 600 | 19 |
1412656 | 1412656 | 2021-06-12 | Foster | North Dakota | 38031 | 600 | 19 |
1409411 | 1409411 | 2021-06-11 | Foster | North Dakota | 38031 | 600 | 19 |
1406166 | 1406166 | 2021-06-10 | Foster | North Dakota | 38031 | 600 | 19 |
1402920 | 1402920 | 2021-06-09 | Foster | North Dakota | 38031 | 600 | 19 |
1399675 | 1399675 | 2021-06-08 | Foster | North Dakota | 38031 | 600 | 19 |
1396430 | 1396430 | 2021-06-07 | Foster | North Dakota | 38031 | 600 | 19 |
1393183 | 1393183 | 2021-06-06 | Foster | North Dakota | 38031 | 600 | 19 |
1389938 | 1389938 | 2021-06-05 | Foster | North Dakota | 38031 | 600 | 19 |
1386693 | 1386693 | 2021-06-04 | Foster | North Dakota | 38031 | 600 | 19 |
1383448 | 1383448 | 2021-06-03 | Foster | North Dakota | 38031 | 600 | 19 |
1380202 | 1380202 | 2021-06-02 | Foster | North Dakota | 38031 | 600 | 19 |
1376957 | 1376957 | 2021-06-01 | Foster | North Dakota | 38031 | 600 | 19 |
1373711 | 1373711 | 2021-05-31 | Foster | North Dakota | 38031 | 600 | 19 |
1370466 | 1370466 | 2021-05-30 | Foster | North Dakota | 38031 | 600 | 19 |
1367220 | 1367220 | 2021-05-29 | Foster | North Dakota | 38031 | 600 | 19 |
1363974 | 1363974 | 2021-05-28 | Foster | North Dakota | 38031 | 600 | 19 |
1360728 | 1360728 | 2021-05-27 | Foster | North Dakota | 38031 | 600 | 19 |
1357482 | 1357482 | 2021-05-26 | Foster | North Dakota | 38031 | 600 | 19 |
1354236 | 1354236 | 2021-05-25 | Foster | North Dakota | 38031 | 600 | 19 |
1350990 | 1350990 | 2021-05-24 | Foster | North Dakota | 38031 | 600 | 19 |
1347744 | 1347744 | 2021-05-23 | Foster | North Dakota | 38031 | 600 | 19 |
1344496 | 1344496 | 2021-05-22 | Foster | North Dakota | 38031 | 600 | 19 |
1341248 | 1341248 | 2021-05-21 | Foster | North Dakota | 38031 | 600 | 19 |
1338000 | 1338000 | 2021-05-20 | Foster | North Dakota | 38031 | 599 | 19 |
1334753 | 1334753 | 2021-05-19 | Foster | North Dakota | 38031 | 599 | 19 |
1331506 | 1331506 | 2021-05-18 | Foster | North Dakota | 38031 | 599 | 19 |
1328259 | 1328259 | 2021-05-17 | Foster | North Dakota | 38031 | 599 | 19 |
1325013 | 1325013 | 2021-05-16 | Foster | North Dakota | 38031 | 599 | 19 |
1321767 | 1321767 | 2021-05-15 | Foster | North Dakota | 38031 | 599 | 19 |
1318521 | 1318521 | 2021-05-14 | Foster | North Dakota | 38031 | 598 | 19 |
1315273 | 1315273 | 2021-05-13 | Foster | North Dakota | 38031 | 598 | 19 |
1312027 | 1312027 | 2021-05-12 | Foster | North Dakota | 38031 | 597 | 19 |
1308780 | 1308780 | 2021-05-11 | Foster | North Dakota | 38031 | 597 | 19 |
1305534 | 1305534 | 2021-05-10 | Foster | North Dakota | 38031 | 595 | 19 |
1302288 | 1302288 | 2021-05-09 | Foster | North Dakota | 38031 | 595 | 19 |
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);