ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Grand Forks" 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 |
---|---|---|---|---|---|---|---|
1623713 | 1623713 | 2021-08-16 | Grand Forks | North Dakota | 38035 | 10877 | 80 |
1620466 | 1620466 | 2021-08-15 | Grand Forks | North Dakota | 38035 | 10870 | 80 |
1617218 | 1617218 | 2021-08-14 | Grand Forks | North Dakota | 38035 | 10860 | 80 |
1613970 | 1613970 | 2021-08-13 | Grand Forks | North Dakota | 38035 | 10848 | 80 |
1610721 | 1610721 | 2021-08-12 | Grand Forks | North Dakota | 38035 | 10836 | 80 |
1607473 | 1607473 | 2021-08-11 | Grand Forks | North Dakota | 38035 | 10830 | 80 |
1604224 | 1604224 | 2021-08-10 | Grand Forks | North Dakota | 38035 | 10819 | 80 |
1600975 | 1600975 | 2021-08-09 | Grand Forks | North Dakota | 38035 | 10804 | 80 |
1597727 | 1597727 | 2021-08-08 | Grand Forks | North Dakota | 38035 | 10804 | 80 |
1594478 | 1594478 | 2021-08-07 | Grand Forks | North Dakota | 38035 | 10801 | 80 |
1591229 | 1591229 | 2021-08-06 | Grand Forks | North Dakota | 38035 | 10795 | 80 |
1587980 | 1587980 | 2021-08-05 | Grand Forks | North Dakota | 38035 | 10790 | 80 |
1584730 | 1584730 | 2021-08-04 | Grand Forks | North Dakota | 38035 | 10786 | 80 |
1581480 | 1581480 | 2021-08-03 | Grand Forks | North Dakota | 38035 | 10778 | 79 |
1578231 | 1578231 | 2021-08-02 | Grand Forks | North Dakota | 38035 | 10770 | 79 |
1574983 | 1574983 | 2021-08-01 | Grand Forks | North Dakota | 38035 | 10767 | 79 |
1571735 | 1571735 | 2021-07-31 | Grand Forks | North Dakota | 38035 | 10761 | 79 |
1568487 | 1568487 | 2021-07-30 | Grand Forks | North Dakota | 38035 | 10754 | 79 |
1565239 | 1565239 | 2021-07-29 | Grand Forks | North Dakota | 38035 | 10750 | 79 |
1561991 | 1561991 | 2021-07-28 | Grand Forks | North Dakota | 38035 | 10747 | 79 |
1558743 | 1558743 | 2021-07-27 | Grand Forks | North Dakota | 38035 | 10742 | 79 |
1555496 | 1555496 | 2021-07-26 | Grand Forks | North Dakota | 38035 | 10736 | 79 |
1552249 | 1552249 | 2021-07-25 | Grand Forks | North Dakota | 38035 | 10736 | 79 |
1549002 | 1549002 | 2021-07-24 | Grand Forks | North Dakota | 38035 | 10736 | 79 |
1545755 | 1545755 | 2021-07-23 | Grand Forks | North Dakota | 38035 | 10736 | 79 |
1542508 | 1542508 | 2021-07-22 | Grand Forks | North Dakota | 38035 | 10733 | 79 |
1539260 | 1539260 | 2021-07-21 | Grand Forks | North Dakota | 38035 | 10732 | 79 |
1536013 | 1536013 | 2021-07-20 | Grand Forks | North Dakota | 38035 | 10731 | 79 |
1532765 | 1532765 | 2021-07-19 | Grand Forks | North Dakota | 38035 | 10729 | 79 |
1529518 | 1529518 | 2021-07-18 | Grand Forks | North Dakota | 38035 | 10729 | 79 |
1526271 | 1526271 | 2021-07-17 | Grand Forks | North Dakota | 38035 | 10728 | 79 |
1523024 | 1523024 | 2021-07-16 | Grand Forks | North Dakota | 38035 | 10727 | 79 |
1519776 | 1519776 | 2021-07-15 | Grand Forks | North Dakota | 38035 | 10726 | 79 |
1516528 | 1516528 | 2021-07-14 | Grand Forks | North Dakota | 38035 | 10725 | 79 |
1513281 | 1513281 | 2021-07-13 | Grand Forks | North Dakota | 38035 | 10724 | 79 |
1510035 | 1510035 | 2021-07-12 | Grand Forks | North Dakota | 38035 | 10724 | 79 |
1506788 | 1506788 | 2021-07-11 | Grand Forks | North Dakota | 38035 | 10724 | 79 |
1503542 | 1503542 | 2021-07-10 | Grand Forks | North Dakota | 38035 | 10724 | 79 |
1500296 | 1500296 | 2021-07-09 | Grand Forks | North Dakota | 38035 | 10723 | 79 |
1497050 | 1497050 | 2021-07-08 | Grand Forks | North Dakota | 38035 | 10723 | 79 |
1493803 | 1493803 | 2021-07-07 | Grand Forks | North Dakota | 38035 | 10723 | 79 |
1490556 | 1490556 | 2021-07-06 | Grand Forks | North Dakota | 38035 | 10721 | 79 |
1487309 | 1487309 | 2021-07-05 | Grand Forks | North Dakota | 38035 | 10721 | 79 |
1484063 | 1484063 | 2021-07-04 | Grand Forks | North Dakota | 38035 | 10721 | 79 |
1480817 | 1480817 | 2021-07-03 | Grand Forks | North Dakota | 38035 | 10721 | 79 |
1477570 | 1477570 | 2021-07-02 | Grand Forks | North Dakota | 38035 | 10721 | 79 |
1474324 | 1474324 | 2021-07-01 | Grand Forks | North Dakota | 38035 | 10721 | 79 |
1471078 | 1471078 | 2021-06-30 | Grand Forks | North Dakota | 38035 | 10720 | 79 |
1467833 | 1467833 | 2021-06-29 | Grand Forks | North Dakota | 38035 | 10719 | 79 |
1464588 | 1464588 | 2021-06-28 | Grand Forks | North Dakota | 38035 | 10719 | 79 |
1461343 | 1461343 | 2021-06-27 | Grand Forks | North Dakota | 38035 | 10719 | 79 |
1458098 | 1458098 | 2021-06-26 | Grand Forks | North Dakota | 38035 | 10718 | 79 |
1454853 | 1454853 | 2021-06-25 | Grand Forks | North Dakota | 38035 | 10717 | 79 |
1451608 | 1451608 | 2021-06-24 | Grand Forks | North Dakota | 38035 | 10716 | 79 |
1448362 | 1448362 | 2021-06-23 | Grand Forks | North Dakota | 38035 | 10716 | 79 |
1445117 | 1445117 | 2021-06-22 | Grand Forks | North Dakota | 38035 | 10716 | 79 |
1441872 | 1441872 | 2021-06-21 | Grand Forks | North Dakota | 38035 | 10714 | 79 |
1438627 | 1438627 | 2021-06-20 | Grand Forks | North Dakota | 38035 | 10714 | 79 |
1435380 | 1435380 | 2021-06-19 | Grand Forks | North Dakota | 38035 | 10714 | 79 |
1432133 | 1432133 | 2021-06-18 | Grand Forks | North Dakota | 38035 | 10713 | 79 |
1428887 | 1428887 | 2021-06-17 | Grand Forks | North Dakota | 38035 | 10712 | 79 |
1425642 | 1425642 | 2021-06-16 | Grand Forks | North Dakota | 38035 | 10710 | 79 |
1422395 | 1422395 | 2021-06-15 | Grand Forks | North Dakota | 38035 | 10707 | 79 |
1419149 | 1419149 | 2021-06-14 | Grand Forks | North Dakota | 38035 | 10704 | 79 |
1415904 | 1415904 | 2021-06-13 | Grand Forks | North Dakota | 38035 | 10704 | 79 |
1412658 | 1412658 | 2021-06-12 | Grand Forks | North Dakota | 38035 | 10705 | 79 |
1409413 | 1409413 | 2021-06-11 | Grand Forks | North Dakota | 38035 | 10704 | 79 |
1406168 | 1406168 | 2021-06-10 | Grand Forks | North Dakota | 38035 | 10704 | 79 |
1402922 | 1402922 | 2021-06-09 | Grand Forks | North Dakota | 38035 | 10701 | 79 |
1399677 | 1399677 | 2021-06-08 | Grand Forks | North Dakota | 38035 | 10699 | 79 |
1396432 | 1396432 | 2021-06-07 | Grand Forks | North Dakota | 38035 | 10692 | 79 |
1393185 | 1393185 | 2021-06-06 | Grand Forks | North Dakota | 38035 | 10692 | 79 |
1389940 | 1389940 | 2021-06-05 | Grand Forks | North Dakota | 38035 | 10691 | 79 |
1386695 | 1386695 | 2021-06-04 | Grand Forks | North Dakota | 38035 | 10689 | 78 |
1383450 | 1383450 | 2021-06-03 | Grand Forks | North Dakota | 38035 | 10687 | 78 |
1380204 | 1380204 | 2021-06-02 | Grand Forks | North Dakota | 38035 | 10685 | 77 |
1376959 | 1376959 | 2021-06-01 | Grand Forks | North Dakota | 38035 | 10684 | 77 |
1373713 | 1373713 | 2021-05-31 | Grand Forks | North Dakota | 38035 | 10683 | 77 |
1370468 | 1370468 | 2021-05-30 | Grand Forks | North Dakota | 38035 | 10683 | 77 |
1367222 | 1367222 | 2021-05-29 | Grand Forks | North Dakota | 38035 | 10682 | 77 |
1363976 | 1363976 | 2021-05-28 | Grand Forks | North Dakota | 38035 | 10679 | 77 |
1360730 | 1360730 | 2021-05-27 | Grand Forks | North Dakota | 38035 | 10677 | 77 |
1357484 | 1357484 | 2021-05-26 | Grand Forks | North Dakota | 38035 | 10677 | 77 |
1354238 | 1354238 | 2021-05-25 | Grand Forks | North Dakota | 38035 | 10672 | 77 |
1350992 | 1350992 | 2021-05-24 | Grand Forks | North Dakota | 38035 | 10664 | 77 |
1347746 | 1347746 | 2021-05-23 | Grand Forks | North Dakota | 38035 | 10663 | 77 |
1344498 | 1344498 | 2021-05-22 | Grand Forks | North Dakota | 38035 | 10660 | 77 |
1341250 | 1341250 | 2021-05-21 | Grand Forks | North Dakota | 38035 | 10654 | 77 |
1338002 | 1338002 | 2021-05-20 | Grand Forks | North Dakota | 38035 | 10655 | 77 |
1334755 | 1334755 | 2021-05-19 | Grand Forks | North Dakota | 38035 | 10654 | 77 |
1331508 | 1331508 | 2021-05-18 | Grand Forks | North Dakota | 38035 | 10642 | 77 |
1328261 | 1328261 | 2021-05-17 | Grand Forks | North Dakota | 38035 | 10635 | 77 |
1325015 | 1325015 | 2021-05-16 | Grand Forks | North Dakota | 38035 | 10632 | 77 |
1321769 | 1321769 | 2021-05-15 | Grand Forks | North Dakota | 38035 | 10630 | 77 |
1318523 | 1318523 | 2021-05-14 | Grand Forks | North Dakota | 38035 | 10628 | 77 |
1315275 | 1315275 | 2021-05-13 | Grand Forks | North Dakota | 38035 | 10623 | 77 |
1312029 | 1312029 | 2021-05-12 | Grand Forks | North Dakota | 38035 | 10613 | 77 |
1308782 | 1308782 | 2021-05-11 | Grand Forks | North Dakota | 38035 | 10601 | 77 |
1305536 | 1305536 | 2021-05-10 | Grand Forks | North Dakota | 38035 | 10589 | 77 |
1302290 | 1302290 | 2021-05-09 | Grand Forks | North Dakota | 38035 | 10584 | 77 |
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);