ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Walsh" 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 |
---|---|---|---|---|---|---|---|
1279598 | 1279598 | 2021-05-02 | Walsh | North Dakota | 38099 | 1893 | 25 |
1276351 | 1276351 | 2021-05-01 | Walsh | North Dakota | 38099 | 1893 | 25 |
1273104 | 1273104 | 2021-04-30 | Walsh | North Dakota | 38099 | 1890 | 25 |
1269857 | 1269857 | 2021-04-29 | Walsh | North Dakota | 38099 | 1887 | 25 |
1266610 | 1266610 | 2021-04-28 | Walsh | North Dakota | 38099 | 1883 | 25 |
1263363 | 1263363 | 2021-04-27 | Walsh | North Dakota | 38099 | 1881 | 25 |
1260116 | 1260116 | 2021-04-26 | Walsh | North Dakota | 38099 | 1878 | 25 |
1256869 | 1256869 | 2021-04-25 | Walsh | North Dakota | 38099 | 1878 | 25 |
1253622 | 1253622 | 2021-04-24 | Walsh | North Dakota | 38099 | 1877 | 25 |
1250375 | 1250375 | 2021-04-23 | Walsh | North Dakota | 38099 | 1874 | 25 |
1247128 | 1247128 | 2021-04-22 | Walsh | North Dakota | 38099 | 1874 | 25 |
1243881 | 1243881 | 2021-04-21 | Walsh | North Dakota | 38099 | 1870 | 25 |
1240634 | 1240634 | 2021-04-20 | Walsh | North Dakota | 38099 | 1863 | 25 |
1237387 | 1237387 | 2021-04-19 | Walsh | North Dakota | 38099 | 1856 | 24 |
1234140 | 1234140 | 2021-04-18 | Walsh | North Dakota | 38099 | 1854 | 24 |
1230892 | 1230892 | 2021-04-17 | Walsh | North Dakota | 38099 | 1854 | 24 |
1227644 | 1227644 | 2021-04-16 | Walsh | North Dakota | 38099 | 1840 | 24 |
1224396 | 1224396 | 2021-04-15 | Walsh | North Dakota | 38099 | 1835 | 24 |
1221149 | 1221149 | 2021-04-14 | Walsh | North Dakota | 38099 | 1832 | 24 |
1217901 | 1217901 | 2021-04-13 | Walsh | North Dakota | 38099 | 1828 | 24 |
1214653 | 1214653 | 2021-04-12 | Walsh | North Dakota | 38099 | 1822 | 24 |
1211406 | 1211406 | 2021-04-11 | Walsh | North Dakota | 38099 | 1822 | 24 |
1208157 | 1208157 | 2021-04-10 | Walsh | North Dakota | 38099 | 1822 | 24 |
1204909 | 1204909 | 2021-04-09 | Walsh | North Dakota | 38099 | 1821 | 24 |
1201661 | 1201661 | 2021-04-08 | Walsh | North Dakota | 38099 | 1818 | 24 |
1198412 | 1198412 | 2021-04-07 | Walsh | North Dakota | 38099 | 1813 | 24 |
1195163 | 1195163 | 2021-04-06 | Walsh | North Dakota | 38099 | 1810 | 24 |
1191915 | 1191915 | 2021-04-05 | Walsh | North Dakota | 38099 | 1809 | 24 |
1188666 | 1188666 | 2021-04-04 | Walsh | North Dakota | 38099 | 1809 | 24 |
1185419 | 1185419 | 2021-04-03 | Walsh | North Dakota | 38099 | 1803 | 24 |
1182172 | 1182172 | 2021-04-02 | Walsh | North Dakota | 38099 | 1802 | 24 |
1178925 | 1178925 | 2021-04-01 | Walsh | North Dakota | 38099 | 1800 | 24 |
1175678 | 1175678 | 2021-03-31 | Walsh | North Dakota | 38099 | 1800 | 24 |
1172431 | 1172431 | 2021-03-30 | Walsh | North Dakota | 38099 | 1797 | 24 |
1169184 | 1169184 | 2021-03-29 | Walsh | North Dakota | 38099 | 1790 | 24 |
1165936 | 1165936 | 2021-03-28 | Walsh | North Dakota | 38099 | 1790 | 24 |
1162688 | 1162688 | 2021-03-27 | Walsh | North Dakota | 38099 | 1790 | 24 |
1159439 | 1159439 | 2021-03-26 | Walsh | North Dakota | 38099 | 1789 | 24 |
1156192 | 1156192 | 2021-03-25 | Walsh | North Dakota | 38099 | 1786 | 24 |
1152945 | 1152945 | 2021-03-24 | Walsh | North Dakota | 38099 | 1786 | 24 |
1149698 | 1149698 | 2021-03-23 | Walsh | North Dakota | 38099 | 1786 | 24 |
1146451 | 1146451 | 2021-03-22 | Walsh | North Dakota | 38099 | 1785 | 24 |
1143204 | 1143204 | 2021-03-21 | Walsh | North Dakota | 38099 | 1785 | 24 |
1139957 | 1139957 | 2021-03-20 | Walsh | North Dakota | 38099 | 1784 | 24 |
1136711 | 1136711 | 2021-03-19 | Walsh | North Dakota | 38099 | 1782 | 24 |
1133465 | 1133465 | 2021-03-18 | Walsh | North Dakota | 38099 | 1778 | 24 |
1130217 | 1130217 | 2021-03-17 | Walsh | North Dakota | 38099 | 1778 | 24 |
1126970 | 1126970 | 2021-03-16 | Walsh | North Dakota | 38099 | 1777 | 24 |
1123724 | 1123724 | 2021-03-15 | Walsh | North Dakota | 38099 | 1775 | 24 |
1120478 | 1120478 | 2021-03-14 | Walsh | North Dakota | 38099 | 1775 | 24 |
1117231 | 1117231 | 2021-03-13 | Walsh | North Dakota | 38099 | 1774 | 24 |
1113984 | 1113984 | 2021-03-12 | Walsh | North Dakota | 38099 | 1773 | 24 |
1110738 | 1110738 | 2021-03-11 | Walsh | North Dakota | 38099 | 1770 | 24 |
1107492 | 1107492 | 2021-03-10 | Walsh | North Dakota | 38099 | 1769 | 24 |
1104246 | 1104246 | 2021-03-09 | Walsh | North Dakota | 38099 | 1769 | 24 |
1101000 | 1101000 | 2021-03-08 | Walsh | North Dakota | 38099 | 1765 | 24 |
1097754 | 1097754 | 2021-03-07 | Walsh | North Dakota | 38099 | 1765 | 24 |
1094506 | 1094506 | 2021-03-06 | Walsh | North Dakota | 38099 | 1763 | 24 |
1091260 | 1091260 | 2021-03-05 | Walsh | North Dakota | 38099 | 1761 | 24 |
1088015 | 1088015 | 2021-03-04 | Walsh | North Dakota | 38099 | 1761 | 24 |
1084770 | 1084770 | 2021-03-03 | Walsh | North Dakota | 38099 | 1757 | 24 |
1081524 | 1081524 | 2021-03-02 | Walsh | North Dakota | 38099 | 1753 | 24 |
1078278 | 1078278 | 2021-03-01 | Walsh | North Dakota | 38099 | 1751 | 24 |
1075033 | 1075033 | 2021-02-28 | Walsh | North Dakota | 38099 | 1751 | 24 |
1071787 | 1071787 | 2021-02-27 | Walsh | North Dakota | 38099 | 1751 | 24 |
1068541 | 1068541 | 2021-02-26 | Walsh | North Dakota | 38099 | 1750 | 24 |
1065296 | 1065296 | 2021-02-25 | Walsh | North Dakota | 38099 | 1748 | 24 |
1062052 | 1062052 | 2021-02-24 | Walsh | North Dakota | 38099 | 1747 | 24 |
1058806 | 1058806 | 2021-02-23 | Walsh | North Dakota | 38099 | 1747 | 24 |
1055560 | 1055560 | 2021-02-22 | Walsh | North Dakota | 38099 | 1745 | 24 |
1052314 | 1052314 | 2021-02-21 | Walsh | North Dakota | 38099 | 1745 | 24 |
1049067 | 1049067 | 2021-02-20 | Walsh | North Dakota | 38099 | 1745 | 24 |
1045820 | 1045820 | 2021-02-19 | Walsh | North Dakota | 38099 | 1743 | 24 |
1042575 | 1042575 | 2021-02-18 | Walsh | North Dakota | 38099 | 1742 | 24 |
1039330 | 1039330 | 2021-02-17 | Walsh | North Dakota | 38099 | 1738 | 24 |
1036085 | 1036085 | 2021-02-16 | Walsh | North Dakota | 38099 | 1736 | 24 |
1032840 | 1032840 | 2021-02-15 | Walsh | North Dakota | 38099 | 1736 | 24 |
1029594 | 1029594 | 2021-02-14 | Walsh | North Dakota | 38099 | 1735 | 24 |
1026347 | 1026347 | 2021-02-13 | Walsh | North Dakota | 38099 | 1735 | 24 |
1023102 | 1023102 | 2021-02-12 | Walsh | North Dakota | 38099 | 1736 | 24 |
1019857 | 1019857 | 2021-02-11 | Walsh | North Dakota | 38099 | 1735 | 24 |
1016612 | 1016612 | 2021-02-10 | Walsh | North Dakota | 38099 | 1734 | 24 |
1013367 | 1013367 | 2021-02-09 | Walsh | North Dakota | 38099 | 1732 | 24 |
1010122 | 1010122 | 2021-02-08 | Walsh | North Dakota | 38099 | 1735 | 24 |
1006876 | 1006876 | 2021-02-07 | Walsh | North Dakota | 38099 | 1737 | 24 |
1003630 | 1003630 | 2021-02-06 | Walsh | North Dakota | 38099 | 1735 | 24 |
1000384 | 1000384 | 2021-02-05 | Walsh | North Dakota | 38099 | 1735 | 24 |
997138 | 997138 | 2021-02-04 | Walsh | North Dakota | 38099 | 1734 | 24 |
993892 | 993892 | 2021-02-03 | Walsh | North Dakota | 38099 | 1737 | 24 |
990646 | 990646 | 2021-02-02 | Walsh | North Dakota | 38099 | 1736 | 24 |
987400 | 987400 | 2021-02-01 | Walsh | North Dakota | 38099 | 1734 | 24 |
984153 | 984153 | 2021-01-31 | Walsh | North Dakota | 38099 | 1732 | 24 |
980906 | 980906 | 2021-01-30 | Walsh | North Dakota | 38099 | 1732 | 24 |
977660 | 977660 | 2021-01-29 | Walsh | North Dakota | 38099 | 1730 | 24 |
974415 | 974415 | 2021-01-28 | Walsh | North Dakota | 38099 | 1728 | 24 |
971170 | 971170 | 2021-01-27 | Walsh | North Dakota | 38099 | 1728 | 24 |
967925 | 967925 | 2021-01-26 | Walsh | North Dakota | 38099 | 1728 | 24 |
964681 | 964681 | 2021-01-25 | Walsh | North Dakota | 38099 | 1726 | 24 |
961436 | 961436 | 2021-01-24 | Walsh | North Dakota | 38099 | 1726 | 24 |
958191 | 958191 | 2021-01-23 | Walsh | North Dakota | 38099 | 1724 | 24 |
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);