ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 38101 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 |
---|---|---|---|---|---|---|---|
1279599 | 1279599 | 2021-05-02 | Ward | North Dakota | 38101 | 9642 | 194 |
1276352 | 1276352 | 2021-05-01 | Ward | North Dakota | 38101 | 9636 | 194 |
1273105 | 1273105 | 2021-04-30 | Ward | North Dakota | 38101 | 9628 | 194 |
1269858 | 1269858 | 2021-04-29 | Ward | North Dakota | 38101 | 9601 | 194 |
1266611 | 1266611 | 2021-04-28 | Ward | North Dakota | 38101 | 9591 | 194 |
1263364 | 1263364 | 2021-04-27 | Ward | North Dakota | 38101 | 9582 | 194 |
1260117 | 1260117 | 2021-04-26 | Ward | North Dakota | 38101 | 9563 | 194 |
1256870 | 1256870 | 2021-04-25 | Ward | North Dakota | 38101 | 9550 | 194 |
1253623 | 1253623 | 2021-04-24 | Ward | North Dakota | 38101 | 9547 | 194 |
1250376 | 1250376 | 2021-04-23 | Ward | North Dakota | 38101 | 9537 | 194 |
1247129 | 1247129 | 2021-04-22 | Ward | North Dakota | 38101 | 9519 | 194 |
1243882 | 1243882 | 2021-04-21 | Ward | North Dakota | 38101 | 9510 | 194 |
1240635 | 1240635 | 2021-04-20 | Ward | North Dakota | 38101 | 9502 | 194 |
1237388 | 1237388 | 2021-04-19 | Ward | North Dakota | 38101 | 9487 | 194 |
1234141 | 1234141 | 2021-04-18 | Ward | North Dakota | 38101 | 9483 | 194 |
1230893 | 1230893 | 2021-04-17 | Ward | North Dakota | 38101 | 9481 | 194 |
1227645 | 1227645 | 2021-04-16 | Ward | North Dakota | 38101 | 9477 | 194 |
1224397 | 1224397 | 2021-04-15 | Ward | North Dakota | 38101 | 9469 | 194 |
1221150 | 1221150 | 2021-04-14 | Ward | North Dakota | 38101 | 9464 | 194 |
1217902 | 1217902 | 2021-04-13 | Ward | North Dakota | 38101 | 9461 | 194 |
1214654 | 1214654 | 2021-04-12 | Ward | North Dakota | 38101 | 9454 | 193 |
1211407 | 1211407 | 2021-04-11 | Ward | North Dakota | 38101 | 9450 | 193 |
1208158 | 1208158 | 2021-04-10 | Ward | North Dakota | 38101 | 9446 | 193 |
1204910 | 1204910 | 2021-04-09 | Ward | North Dakota | 38101 | 9434 | 193 |
1201662 | 1201662 | 2021-04-08 | Ward | North Dakota | 38101 | 9428 | 192 |
1198413 | 1198413 | 2021-04-07 | Ward | North Dakota | 38101 | 9419 | 192 |
1195164 | 1195164 | 2021-04-06 | Ward | North Dakota | 38101 | 9415 | 192 |
1191916 | 1191916 | 2021-04-05 | Ward | North Dakota | 38101 | 9397 | 192 |
1188667 | 1188667 | 2021-04-04 | Ward | North Dakota | 38101 | 9397 | 192 |
1185420 | 1185420 | 2021-04-03 | Ward | North Dakota | 38101 | 9394 | 192 |
1182173 | 1182173 | 2021-04-02 | Ward | North Dakota | 38101 | 9387 | 192 |
1178926 | 1178926 | 2021-04-01 | Ward | North Dakota | 38101 | 9374 | 192 |
1175679 | 1175679 | 2021-03-31 | Ward | North Dakota | 38101 | 9369 | 192 |
1172432 | 1172432 | 2021-03-30 | Ward | North Dakota | 38101 | 9363 | 192 |
1169185 | 1169185 | 2021-03-29 | Ward | North Dakota | 38101 | 9349 | 192 |
1165937 | 1165937 | 2021-03-28 | Ward | North Dakota | 38101 | 9346 | 192 |
1162689 | 1162689 | 2021-03-27 | Ward | North Dakota | 38101 | 9343 | 192 |
1159440 | 1159440 | 2021-03-26 | Ward | North Dakota | 38101 | 9341 | 192 |
1156193 | 1156193 | 2021-03-25 | Ward | North Dakota | 38101 | 9331 | 192 |
1152946 | 1152946 | 2021-03-24 | Ward | North Dakota | 38101 | 9328 | 192 |
1149699 | 1149699 | 2021-03-23 | Ward | North Dakota | 38101 | 9326 | 191 |
1146452 | 1146452 | 2021-03-22 | Ward | North Dakota | 38101 | 9319 | 191 |
1143205 | 1143205 | 2021-03-21 | Ward | North Dakota | 38101 | 9319 | 191 |
1139958 | 1139958 | 2021-03-20 | Ward | North Dakota | 38101 | 9315 | 191 |
1136712 | 1136712 | 2021-03-19 | Ward | North Dakota | 38101 | 9312 | 191 |
1133466 | 1133466 | 2021-03-18 | Ward | North Dakota | 38101 | 9302 | 191 |
1130218 | 1130218 | 2021-03-17 | Ward | North Dakota | 38101 | 9293 | 191 |
1126971 | 1126971 | 2021-03-16 | Ward | North Dakota | 38101 | 9290 | 191 |
1123725 | 1123725 | 2021-03-15 | Ward | North Dakota | 38101 | 9277 | 190 |
1120479 | 1120479 | 2021-03-14 | Ward | North Dakota | 38101 | 9276 | 190 |
1117232 | 1117232 | 2021-03-13 | Ward | North Dakota | 38101 | 9267 | 190 |
1113985 | 1113985 | 2021-03-12 | Ward | North Dakota | 38101 | 9257 | 190 |
1110739 | 1110739 | 2021-03-11 | Ward | North Dakota | 38101 | 9247 | 190 |
1107493 | 1107493 | 2021-03-10 | Ward | North Dakota | 38101 | 9240 | 189 |
1104247 | 1104247 | 2021-03-09 | Ward | North Dakota | 38101 | 9236 | 189 |
1101001 | 1101001 | 2021-03-08 | Ward | North Dakota | 38101 | 9230 | 189 |
1097755 | 1097755 | 2021-03-07 | Ward | North Dakota | 38101 | 9227 | 189 |
1094507 | 1094507 | 2021-03-06 | Ward | North Dakota | 38101 | 9221 | 189 |
1091261 | 1091261 | 2021-03-05 | Ward | North Dakota | 38101 | 9211 | 189 |
1088016 | 1088016 | 2021-03-04 | Ward | North Dakota | 38101 | 9193 | 189 |
1084771 | 1084771 | 2021-03-03 | Ward | North Dakota | 38101 | 9187 | 189 |
1081525 | 1081525 | 2021-03-02 | Ward | North Dakota | 38101 | 9175 | 188 |
1078279 | 1078279 | 2021-03-01 | Ward | North Dakota | 38101 | 9166 | 187 |
1075034 | 1075034 | 2021-02-28 | Ward | North Dakota | 38101 | 9161 | 187 |
1071788 | 1071788 | 2021-02-27 | Ward | North Dakota | 38101 | 9153 | 187 |
1068542 | 1068542 | 2021-02-26 | Ward | North Dakota | 38101 | 9150 | 187 |
1065297 | 1065297 | 2021-02-25 | Ward | North Dakota | 38101 | 9135 | 187 |
1062053 | 1062053 | 2021-02-24 | Ward | North Dakota | 38101 | 9128 | 187 |
1058807 | 1058807 | 2021-02-23 | Ward | North Dakota | 38101 | 9121 | 186 |
1055561 | 1055561 | 2021-02-22 | Ward | North Dakota | 38101 | 9114 | 186 |
1052315 | 1052315 | 2021-02-21 | Ward | North Dakota | 38101 | 9110 | 186 |
1049068 | 1049068 | 2021-02-20 | Ward | North Dakota | 38101 | 9097 | 186 |
1045821 | 1045821 | 2021-02-19 | Ward | North Dakota | 38101 | 9092 | 186 |
1042576 | 1042576 | 2021-02-18 | Ward | North Dakota | 38101 | 9074 | 186 |
1039331 | 1039331 | 2021-02-17 | Ward | North Dakota | 38101 | 9068 | 186 |
1036086 | 1036086 | 2021-02-16 | Ward | North Dakota | 38101 | 9062 | 186 |
1032841 | 1032841 | 2021-02-15 | Ward | North Dakota | 38101 | 9042 | 186 |
1029595 | 1029595 | 2021-02-14 | Ward | North Dakota | 38101 | 9035 | 186 |
1026348 | 1026348 | 2021-02-13 | Ward | North Dakota | 38101 | 9028 | 186 |
1023103 | 1023103 | 2021-02-12 | Ward | North Dakota | 38101 | 9021 | 186 |
1019858 | 1019858 | 2021-02-11 | Ward | North Dakota | 38101 | 9012 | 186 |
1016613 | 1016613 | 2021-02-10 | Ward | North Dakota | 38101 | 9000 | 186 |
1013368 | 1013368 | 2021-02-09 | Ward | North Dakota | 38101 | 8987 | 186 |
1010123 | 1010123 | 2021-02-08 | Ward | North Dakota | 38101 | 8992 | 185 |
1006877 | 1006877 | 2021-02-07 | Ward | North Dakota | 38101 | 8992 | 185 |
1003631 | 1003631 | 2021-02-06 | Ward | North Dakota | 38101 | 8986 | 185 |
1000385 | 1000385 | 2021-02-05 | Ward | North Dakota | 38101 | 8975 | 185 |
997139 | 997139 | 2021-02-04 | Ward | North Dakota | 38101 | 8971 | 185 |
993893 | 993893 | 2021-02-03 | Ward | North Dakota | 38101 | 8961 | 185 |
990647 | 990647 | 2021-02-02 | Ward | North Dakota | 38101 | 8947 | 185 |
987401 | 987401 | 2021-02-01 | Ward | North Dakota | 38101 | 8939 | 185 |
984154 | 984154 | 2021-01-31 | Ward | North Dakota | 38101 | 8932 | 185 |
980907 | 980907 | 2021-01-30 | Ward | North Dakota | 38101 | 8922 | 185 |
977661 | 977661 | 2021-01-29 | Ward | North Dakota | 38101 | 8911 | 185 |
974416 | 974416 | 2021-01-28 | Ward | North Dakota | 38101 | 8891 | 185 |
971171 | 971171 | 2021-01-27 | Ward | North Dakota | 38101 | 8881 | 186 |
967926 | 967926 | 2021-01-26 | Ward | North Dakota | 38101 | 8861 | 185 |
964682 | 964682 | 2021-01-25 | Ward | North Dakota | 38101 | 8842 | 185 |
961437 | 961437 | 2021-01-24 | Ward | North Dakota | 38101 | 8841 | 185 |
958192 | 958192 | 2021-01-23 | Ward | North Dakota | 38101 | 8830 | 185 |
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);