ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Dunn" 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 |
---|---|---|---|---|---|---|---|
1279560 | 1279560 | 2021-05-02 | Dunn | North Dakota | 38025 | 378 | 7 |
1276313 | 1276313 | 2021-05-01 | Dunn | North Dakota | 38025 | 378 | 7 |
1273066 | 1273066 | 2021-04-30 | Dunn | North Dakota | 38025 | 378 | 7 |
1269819 | 1269819 | 2021-04-29 | Dunn | North Dakota | 38025 | 377 | 7 |
1266572 | 1266572 | 2021-04-28 | Dunn | North Dakota | 38025 | 377 | 7 |
1263325 | 1263325 | 2021-04-27 | Dunn | North Dakota | 38025 | 376 | 7 |
1260078 | 1260078 | 2021-04-26 | Dunn | North Dakota | 38025 | 376 | 7 |
1256831 | 1256831 | 2021-04-25 | Dunn | North Dakota | 38025 | 375 | 7 |
1253584 | 1253584 | 2021-04-24 | Dunn | North Dakota | 38025 | 375 | 7 |
1250337 | 1250337 | 2021-04-23 | Dunn | North Dakota | 38025 | 375 | 7 |
1247090 | 1247090 | 2021-04-22 | Dunn | North Dakota | 38025 | 375 | 7 |
1243843 | 1243843 | 2021-04-21 | Dunn | North Dakota | 38025 | 374 | 7 |
1240596 | 1240596 | 2021-04-20 | Dunn | North Dakota | 38025 | 374 | 7 |
1237349 | 1237349 | 2021-04-19 | Dunn | North Dakota | 38025 | 374 | 7 |
1234102 | 1234102 | 2021-04-18 | Dunn | North Dakota | 38025 | 374 | 7 |
1230854 | 1230854 | 2021-04-17 | Dunn | North Dakota | 38025 | 374 | 7 |
1227606 | 1227606 | 2021-04-16 | Dunn | North Dakota | 38025 | 374 | 7 |
1224358 | 1224358 | 2021-04-15 | Dunn | North Dakota | 38025 | 374 | 7 |
1221111 | 1221111 | 2021-04-14 | Dunn | North Dakota | 38025 | 373 | 7 |
1217863 | 1217863 | 2021-04-13 | Dunn | North Dakota | 38025 | 373 | 7 |
1214615 | 1214615 | 2021-04-12 | Dunn | North Dakota | 38025 | 373 | 7 |
1211368 | 1211368 | 2021-04-11 | Dunn | North Dakota | 38025 | 373 | 7 |
1208119 | 1208119 | 2021-04-10 | Dunn | North Dakota | 38025 | 372 | 7 |
1204871 | 1204871 | 2021-04-09 | Dunn | North Dakota | 38025 | 372 | 7 |
1201623 | 1201623 | 2021-04-08 | Dunn | North Dakota | 38025 | 371 | 7 |
1198374 | 1198374 | 2021-04-07 | Dunn | North Dakota | 38025 | 368 | 7 |
1195125 | 1195125 | 2021-04-06 | Dunn | North Dakota | 38025 | 368 | 7 |
1191877 | 1191877 | 2021-04-05 | Dunn | North Dakota | 38025 | 368 | 7 |
1188628 | 1188628 | 2021-04-04 | Dunn | North Dakota | 38025 | 368 | 7 |
1185381 | 1185381 | 2021-04-03 | Dunn | North Dakota | 38025 | 368 | 7 |
1182134 | 1182134 | 2021-04-02 | Dunn | North Dakota | 38025 | 368 | 7 |
1178887 | 1178887 | 2021-04-01 | Dunn | North Dakota | 38025 | 368 | 7 |
1175640 | 1175640 | 2021-03-31 | Dunn | North Dakota | 38025 | 368 | 7 |
1172393 | 1172393 | 2021-03-30 | Dunn | North Dakota | 38025 | 368 | 7 |
1169146 | 1169146 | 2021-03-29 | Dunn | North Dakota | 38025 | 369 | 7 |
1165898 | 1165898 | 2021-03-28 | Dunn | North Dakota | 38025 | 369 | 7 |
1162650 | 1162650 | 2021-03-27 | Dunn | North Dakota | 38025 | 369 | 7 |
1159401 | 1159401 | 2021-03-26 | Dunn | North Dakota | 38025 | 369 | 7 |
1156154 | 1156154 | 2021-03-25 | Dunn | North Dakota | 38025 | 369 | 7 |
1152907 | 1152907 | 2021-03-24 | Dunn | North Dakota | 38025 | 369 | 7 |
1149660 | 1149660 | 2021-03-23 | Dunn | North Dakota | 38025 | 369 | 7 |
1146413 | 1146413 | 2021-03-22 | Dunn | North Dakota | 38025 | 369 | 7 |
1143166 | 1143166 | 2021-03-21 | Dunn | North Dakota | 38025 | 369 | 7 |
1139919 | 1139919 | 2021-03-20 | Dunn | North Dakota | 38025 | 368 | 7 |
1136673 | 1136673 | 2021-03-19 | Dunn | North Dakota | 38025 | 368 | 7 |
1133427 | 1133427 | 2021-03-18 | Dunn | North Dakota | 38025 | 368 | 7 |
1130179 | 1130179 | 2021-03-17 | Dunn | North Dakota | 38025 | 368 | 7 |
1126932 | 1126932 | 2021-03-16 | Dunn | North Dakota | 38025 | 368 | 7 |
1123686 | 1123686 | 2021-03-15 | Dunn | North Dakota | 38025 | 368 | 7 |
1120440 | 1120440 | 2021-03-14 | Dunn | North Dakota | 38025 | 368 | 7 |
1117193 | 1117193 | 2021-03-13 | Dunn | North Dakota | 38025 | 367 | 7 |
1113946 | 1113946 | 2021-03-12 | Dunn | North Dakota | 38025 | 367 | 7 |
1110700 | 1110700 | 2021-03-11 | Dunn | North Dakota | 38025 | 367 | 7 |
1107454 | 1107454 | 2021-03-10 | Dunn | North Dakota | 38025 | 367 | 7 |
1104208 | 1104208 | 2021-03-09 | Dunn | North Dakota | 38025 | 367 | 7 |
1100962 | 1100962 | 2021-03-08 | Dunn | North Dakota | 38025 | 367 | 7 |
1097716 | 1097716 | 2021-03-07 | Dunn | North Dakota | 38025 | 367 | 7 |
1094468 | 1094468 | 2021-03-06 | Dunn | North Dakota | 38025 | 367 | 7 |
1091222 | 1091222 | 2021-03-05 | Dunn | North Dakota | 38025 | 366 | 7 |
1087977 | 1087977 | 2021-03-04 | Dunn | North Dakota | 38025 | 366 | 7 |
1084732 | 1084732 | 2021-03-03 | Dunn | North Dakota | 38025 | 365 | 7 |
1081486 | 1081486 | 2021-03-02 | Dunn | North Dakota | 38025 | 365 | 7 |
1078240 | 1078240 | 2021-03-01 | Dunn | North Dakota | 38025 | 366 | 7 |
1074995 | 1074995 | 2021-02-28 | Dunn | North Dakota | 38025 | 366 | 7 |
1071749 | 1071749 | 2021-02-27 | Dunn | North Dakota | 38025 | 366 | 7 |
1068503 | 1068503 | 2021-02-26 | Dunn | North Dakota | 38025 | 366 | 7 |
1065258 | 1065258 | 2021-02-25 | Dunn | North Dakota | 38025 | 366 | 7 |
1062014 | 1062014 | 2021-02-24 | Dunn | North Dakota | 38025 | 365 | 7 |
1058768 | 1058768 | 2021-02-23 | Dunn | North Dakota | 38025 | 365 | 7 |
1055522 | 1055522 | 2021-02-22 | Dunn | North Dakota | 38025 | 365 | 7 |
1052276 | 1052276 | 2021-02-21 | Dunn | North Dakota | 38025 | 365 | 7 |
1049029 | 1049029 | 2021-02-20 | Dunn | North Dakota | 38025 | 365 | 7 |
1045782 | 1045782 | 2021-02-19 | Dunn | North Dakota | 38025 | 365 | 7 |
1042537 | 1042537 | 2021-02-18 | Dunn | North Dakota | 38025 | 364 | 7 |
1039292 | 1039292 | 2021-02-17 | Dunn | North Dakota | 38025 | 364 | 7 |
1036047 | 1036047 | 2021-02-16 | Dunn | North Dakota | 38025 | 364 | 7 |
1032802 | 1032802 | 2021-02-15 | Dunn | North Dakota | 38025 | 363 | 7 |
1029556 | 1029556 | 2021-02-14 | Dunn | North Dakota | 38025 | 363 | 7 |
1026309 | 1026309 | 2021-02-13 | Dunn | North Dakota | 38025 | 363 | 7 |
1023064 | 1023064 | 2021-02-12 | Dunn | North Dakota | 38025 | 363 | 7 |
1019819 | 1019819 | 2021-02-11 | Dunn | North Dakota | 38025 | 362 | 7 |
1016574 | 1016574 | 2021-02-10 | Dunn | North Dakota | 38025 | 362 | 7 |
1013329 | 1013329 | 2021-02-09 | Dunn | North Dakota | 38025 | 362 | 7 |
1010084 | 1010084 | 2021-02-08 | Dunn | North Dakota | 38025 | 363 | 7 |
1006838 | 1006838 | 2021-02-07 | Dunn | North Dakota | 38025 | 363 | 7 |
1003592 | 1003592 | 2021-02-06 | Dunn | North Dakota | 38025 | 363 | 7 |
1000346 | 1000346 | 2021-02-05 | Dunn | North Dakota | 38025 | 364 | 7 |
997100 | 997100 | 2021-02-04 | Dunn | North Dakota | 38025 | 364 | 7 |
993854 | 993854 | 2021-02-03 | Dunn | North Dakota | 38025 | 364 | 7 |
990608 | 990608 | 2021-02-02 | Dunn | North Dakota | 38025 | 363 | 7 |
987362 | 987362 | 2021-02-01 | Dunn | North Dakota | 38025 | 363 | 7 |
984115 | 984115 | 2021-01-31 | Dunn | North Dakota | 38025 | 363 | 7 |
980868 | 980868 | 2021-01-30 | Dunn | North Dakota | 38025 | 363 | 7 |
977622 | 977622 | 2021-01-29 | Dunn | North Dakota | 38025 | 363 | 7 |
974377 | 974377 | 2021-01-28 | Dunn | North Dakota | 38025 | 363 | 7 |
971132 | 971132 | 2021-01-27 | Dunn | North Dakota | 38025 | 362 | 7 |
967887 | 967887 | 2021-01-26 | Dunn | North Dakota | 38025 | 362 | 7 |
964643 | 964643 | 2021-01-25 | Dunn | North Dakota | 38025 | 362 | 7 |
961398 | 961398 | 2021-01-24 | Dunn | North Dakota | 38025 | 362 | 7 |
958153 | 958153 | 2021-01-23 | Dunn | North Dakota | 38025 | 362 | 7 |
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);