ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 38071 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 |
---|---|---|---|---|---|---|---|
1279583 | 1279583 | 2021-05-02 | Ramsey | North Dakota | 38071 | 1703 | 30 |
1276336 | 1276336 | 2021-05-01 | Ramsey | North Dakota | 38071 | 1703 | 30 |
1273089 | 1273089 | 2021-04-30 | Ramsey | North Dakota | 38071 | 1703 | 30 |
1269842 | 1269842 | 2021-04-29 | Ramsey | North Dakota | 38071 | 1703 | 30 |
1266595 | 1266595 | 2021-04-28 | Ramsey | North Dakota | 38071 | 1703 | 30 |
1263348 | 1263348 | 2021-04-27 | Ramsey | North Dakota | 38071 | 1702 | 30 |
1260101 | 1260101 | 2021-04-26 | Ramsey | North Dakota | 38071 | 1700 | 30 |
1256854 | 1256854 | 2021-04-25 | Ramsey | North Dakota | 38071 | 1700 | 30 |
1253607 | 1253607 | 2021-04-24 | Ramsey | North Dakota | 38071 | 1699 | 30 |
1250360 | 1250360 | 2021-04-23 | Ramsey | North Dakota | 38071 | 1699 | 30 |
1247113 | 1247113 | 2021-04-22 | Ramsey | North Dakota | 38071 | 1695 | 30 |
1243866 | 1243866 | 2021-04-21 | Ramsey | North Dakota | 38071 | 1692 | 30 |
1240619 | 1240619 | 2021-04-20 | Ramsey | North Dakota | 38071 | 1688 | 30 |
1237372 | 1237372 | 2021-04-19 | Ramsey | North Dakota | 38071 | 1683 | 30 |
1234125 | 1234125 | 2021-04-18 | Ramsey | North Dakota | 38071 | 1683 | 30 |
1230877 | 1230877 | 2021-04-17 | Ramsey | North Dakota | 38071 | 1683 | 30 |
1227629 | 1227629 | 2021-04-16 | Ramsey | North Dakota | 38071 | 1682 | 30 |
1224381 | 1224381 | 2021-04-15 | Ramsey | North Dakota | 38071 | 1679 | 30 |
1221134 | 1221134 | 2021-04-14 | Ramsey | North Dakota | 38071 | 1677 | 30 |
1217886 | 1217886 | 2021-04-13 | Ramsey | North Dakota | 38071 | 1675 | 30 |
1214638 | 1214638 | 2021-04-12 | Ramsey | North Dakota | 38071 | 1671 | 30 |
1211391 | 1211391 | 2021-04-11 | Ramsey | North Dakota | 38071 | 1671 | 30 |
1208142 | 1208142 | 2021-04-10 | Ramsey | North Dakota | 38071 | 1670 | 30 |
1204894 | 1204894 | 2021-04-09 | Ramsey | North Dakota | 38071 | 1669 | 30 |
1201646 | 1201646 | 2021-04-08 | Ramsey | North Dakota | 38071 | 1669 | 30 |
1198397 | 1198397 | 2021-04-07 | Ramsey | North Dakota | 38071 | 1668 | 30 |
1195148 | 1195148 | 2021-04-06 | Ramsey | North Dakota | 38071 | 1667 | 30 |
1191900 | 1191900 | 2021-04-05 | Ramsey | North Dakota | 38071 | 1666 | 30 |
1188651 | 1188651 | 2021-04-04 | Ramsey | North Dakota | 38071 | 1666 | 30 |
1185404 | 1185404 | 2021-04-03 | Ramsey | North Dakota | 38071 | 1666 | 30 |
1182157 | 1182157 | 2021-04-02 | Ramsey | North Dakota | 38071 | 1664 | 30 |
1178910 | 1178910 | 2021-04-01 | Ramsey | North Dakota | 38071 | 1663 | 30 |
1175663 | 1175663 | 2021-03-31 | Ramsey | North Dakota | 38071 | 1662 | 30 |
1172416 | 1172416 | 2021-03-30 | Ramsey | North Dakota | 38071 | 1663 | 30 |
1169169 | 1169169 | 2021-03-29 | Ramsey | North Dakota | 38071 | 1657 | 30 |
1165921 | 1165921 | 2021-03-28 | Ramsey | North Dakota | 38071 | 1657 | 30 |
1162673 | 1162673 | 2021-03-27 | Ramsey | North Dakota | 38071 | 1657 | 30 |
1159424 | 1159424 | 2021-03-26 | Ramsey | North Dakota | 38071 | 1655 | 30 |
1156177 | 1156177 | 2021-03-25 | Ramsey | North Dakota | 38071 | 1655 | 30 |
1152930 | 1152930 | 2021-03-24 | Ramsey | North Dakota | 38071 | 1655 | 30 |
1149683 | 1149683 | 2021-03-23 | Ramsey | North Dakota | 38071 | 1651 | 30 |
1146436 | 1146436 | 2021-03-22 | Ramsey | North Dakota | 38071 | 1650 | 30 |
1143189 | 1143189 | 2021-03-21 | Ramsey | North Dakota | 38071 | 1647 | 30 |
1139942 | 1139942 | 2021-03-20 | Ramsey | North Dakota | 38071 | 1646 | 30 |
1136696 | 1136696 | 2021-03-19 | Ramsey | North Dakota | 38071 | 1641 | 30 |
1133450 | 1133450 | 2021-03-18 | Ramsey | North Dakota | 38071 | 1639 | 30 |
1130202 | 1130202 | 2021-03-17 | Ramsey | North Dakota | 38071 | 1635 | 30 |
1126955 | 1126955 | 2021-03-16 | Ramsey | North Dakota | 38071 | 1630 | 30 |
1123709 | 1123709 | 2021-03-15 | Ramsey | North Dakota | 38071 | 1624 | 30 |
1120463 | 1120463 | 2021-03-14 | Ramsey | North Dakota | 38071 | 1624 | 30 |
1117216 | 1117216 | 2021-03-13 | Ramsey | North Dakota | 38071 | 1624 | 30 |
1113969 | 1113969 | 2021-03-12 | Ramsey | North Dakota | 38071 | 1621 | 30 |
1110723 | 1110723 | 2021-03-11 | Ramsey | North Dakota | 38071 | 1620 | 30 |
1107477 | 1107477 | 2021-03-10 | Ramsey | North Dakota | 38071 | 1618 | 30 |
1104231 | 1104231 | 2021-03-09 | Ramsey | North Dakota | 38071 | 1616 | 30 |
1100985 | 1100985 | 2021-03-08 | Ramsey | North Dakota | 38071 | 1614 | 30 |
1097739 | 1097739 | 2021-03-07 | Ramsey | North Dakota | 38071 | 1614 | 30 |
1094491 | 1094491 | 2021-03-06 | Ramsey | North Dakota | 38071 | 1614 | 30 |
1091245 | 1091245 | 2021-03-05 | Ramsey | North Dakota | 38071 | 1612 | 30 |
1088000 | 1088000 | 2021-03-04 | Ramsey | North Dakota | 38071 | 1611 | 30 |
1084755 | 1084755 | 2021-03-03 | Ramsey | North Dakota | 38071 | 1609 | 30 |
1081509 | 1081509 | 2021-03-02 | Ramsey | North Dakota | 38071 | 1607 | 30 |
1078263 | 1078263 | 2021-03-01 | Ramsey | North Dakota | 38071 | 1607 | 30 |
1075018 | 1075018 | 2021-02-28 | Ramsey | North Dakota | 38071 | 1607 | 30 |
1071772 | 1071772 | 2021-02-27 | Ramsey | North Dakota | 38071 | 1607 | 30 |
1068526 | 1068526 | 2021-02-26 | Ramsey | North Dakota | 38071 | 1606 | 30 |
1065281 | 1065281 | 2021-02-25 | Ramsey | North Dakota | 38071 | 1604 | 30 |
1062037 | 1062037 | 2021-02-24 | Ramsey | North Dakota | 38071 | 1602 | 30 |
1058791 | 1058791 | 2021-02-23 | Ramsey | North Dakota | 38071 | 1602 | 30 |
1055545 | 1055545 | 2021-02-22 | Ramsey | North Dakota | 38071 | 1600 | 30 |
1052299 | 1052299 | 2021-02-21 | Ramsey | North Dakota | 38071 | 1600 | 30 |
1049052 | 1049052 | 2021-02-20 | Ramsey | North Dakota | 38071 | 1600 | 30 |
1045805 | 1045805 | 2021-02-19 | Ramsey | North Dakota | 38071 | 1599 | 30 |
1042560 | 1042560 | 2021-02-18 | Ramsey | North Dakota | 38071 | 1598 | 30 |
1039315 | 1039315 | 2021-02-17 | Ramsey | North Dakota | 38071 | 1595 | 30 |
1036070 | 1036070 | 2021-02-16 | Ramsey | North Dakota | 38071 | 1593 | 30 |
1032825 | 1032825 | 2021-02-15 | Ramsey | North Dakota | 38071 | 1592 | 30 |
1029579 | 1029579 | 2021-02-14 | Ramsey | North Dakota | 38071 | 1592 | 30 |
1026332 | 1026332 | 2021-02-13 | Ramsey | North Dakota | 38071 | 1591 | 30 |
1023087 | 1023087 | 2021-02-12 | Ramsey | North Dakota | 38071 | 1589 | 30 |
1019842 | 1019842 | 2021-02-11 | Ramsey | North Dakota | 38071 | 1586 | 30 |
1016597 | 1016597 | 2021-02-10 | Ramsey | North Dakota | 38071 | 1583 | 30 |
1013352 | 1013352 | 2021-02-09 | Ramsey | North Dakota | 38071 | 1585 | 30 |
1010107 | 1010107 | 2021-02-08 | Ramsey | North Dakota | 38071 | 1585 | 30 |
1006861 | 1006861 | 2021-02-07 | Ramsey | North Dakota | 38071 | 1584 | 30 |
1003615 | 1003615 | 2021-02-06 | Ramsey | North Dakota | 38071 | 1582 | 30 |
1000369 | 1000369 | 2021-02-05 | Ramsey | North Dakota | 38071 | 1582 | 30 |
997123 | 997123 | 2021-02-04 | Ramsey | North Dakota | 38071 | 1581 | 30 |
993877 | 993877 | 2021-02-03 | Ramsey | North Dakota | 38071 | 1575 | 30 |
990631 | 990631 | 2021-02-02 | Ramsey | North Dakota | 38071 | 1574 | 30 |
987385 | 987385 | 2021-02-01 | Ramsey | North Dakota | 38071 | 1573 | 30 |
984138 | 984138 | 2021-01-31 | Ramsey | North Dakota | 38071 | 1573 | 30 |
980891 | 980891 | 2021-01-30 | Ramsey | North Dakota | 38071 | 1572 | 30 |
977645 | 977645 | 2021-01-29 | Ramsey | North Dakota | 38071 | 1569 | 30 |
974400 | 974400 | 2021-01-28 | Ramsey | North Dakota | 38071 | 1564 | 30 |
971155 | 971155 | 2021-01-27 | Ramsey | North Dakota | 38071 | 1560 | 30 |
967910 | 967910 | 2021-01-26 | Ramsey | North Dakota | 38071 | 1556 | 30 |
964666 | 964666 | 2021-01-25 | Ramsey | North Dakota | 38071 | 1554 | 30 |
961421 | 961421 | 2021-01-24 | Ramsey | North Dakota | 38071 | 1553 | 30 |
958176 | 958176 | 2021-01-23 | Ramsey | North Dakota | 38071 | 1553 | 30 |
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);