ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38055 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 |
---|---|---|---|---|---|---|---|
1279575 | 1279575 | 2021-05-02 | McLean | North Dakota | 38055 | 1266 | 30 |
1276328 | 1276328 | 2021-05-01 | McLean | North Dakota | 38055 | 1264 | 30 |
1273081 | 1273081 | 2021-04-30 | McLean | North Dakota | 38055 | 1263 | 30 |
1269834 | 1269834 | 2021-04-29 | McLean | North Dakota | 38055 | 1262 | 30 |
1266587 | 1266587 | 2021-04-28 | McLean | North Dakota | 38055 | 1261 | 30 |
1263340 | 1263340 | 2021-04-27 | McLean | North Dakota | 38055 | 1261 | 30 |
1260093 | 1260093 | 2021-04-26 | McLean | North Dakota | 38055 | 1261 | 30 |
1256846 | 1256846 | 2021-04-25 | McLean | North Dakota | 38055 | 1261 | 30 |
1253599 | 1253599 | 2021-04-24 | McLean | North Dakota | 38055 | 1261 | 30 |
1250352 | 1250352 | 2021-04-23 | McLean | North Dakota | 38055 | 1261 | 30 |
1247105 | 1247105 | 2021-04-22 | McLean | North Dakota | 38055 | 1260 | 30 |
1243858 | 1243858 | 2021-04-21 | McLean | North Dakota | 38055 | 1255 | 30 |
1240611 | 1240611 | 2021-04-20 | McLean | North Dakota | 38055 | 1253 | 30 |
1237364 | 1237364 | 2021-04-19 | McLean | North Dakota | 38055 | 1253 | 30 |
1234117 | 1234117 | 2021-04-18 | McLean | North Dakota | 38055 | 1253 | 30 |
1230869 | 1230869 | 2021-04-17 | McLean | North Dakota | 38055 | 1253 | 30 |
1227621 | 1227621 | 2021-04-16 | McLean | North Dakota | 38055 | 1252 | 30 |
1224373 | 1224373 | 2021-04-15 | McLean | North Dakota | 38055 | 1252 | 30 |
1221126 | 1221126 | 2021-04-14 | McLean | North Dakota | 38055 | 1251 | 30 |
1217878 | 1217878 | 2021-04-13 | McLean | North Dakota | 38055 | 1251 | 30 |
1214630 | 1214630 | 2021-04-12 | McLean | North Dakota | 38055 | 1249 | 30 |
1211383 | 1211383 | 2021-04-11 | McLean | North Dakota | 38055 | 1247 | 30 |
1208134 | 1208134 | 2021-04-10 | McLean | North Dakota | 38055 | 1247 | 30 |
1204886 | 1204886 | 2021-04-09 | McLean | North Dakota | 38055 | 1246 | 30 |
1201638 | 1201638 | 2021-04-08 | McLean | North Dakota | 38055 | 1244 | 30 |
1198389 | 1198389 | 2021-04-07 | McLean | North Dakota | 38055 | 1243 | 30 |
1195140 | 1195140 | 2021-04-06 | McLean | North Dakota | 38055 | 1243 | 30 |
1191892 | 1191892 | 2021-04-05 | McLean | North Dakota | 38055 | 1243 | 30 |
1188643 | 1188643 | 2021-04-04 | McLean | North Dakota | 38055 | 1243 | 30 |
1185396 | 1185396 | 2021-04-03 | McLean | North Dakota | 38055 | 1241 | 30 |
1182149 | 1182149 | 2021-04-02 | McLean | North Dakota | 38055 | 1241 | 30 |
1178902 | 1178902 | 2021-04-01 | McLean | North Dakota | 38055 | 1240 | 30 |
1175655 | 1175655 | 2021-03-31 | McLean | North Dakota | 38055 | 1239 | 30 |
1172408 | 1172408 | 2021-03-30 | McLean | North Dakota | 38055 | 1239 | 30 |
1169161 | 1169161 | 2021-03-29 | McLean | North Dakota | 38055 | 1236 | 30 |
1165913 | 1165913 | 2021-03-28 | McLean | North Dakota | 38055 | 1236 | 30 |
1162665 | 1162665 | 2021-03-27 | McLean | North Dakota | 38055 | 1236 | 30 |
1159416 | 1159416 | 2021-03-26 | McLean | North Dakota | 38055 | 1235 | 30 |
1156169 | 1156169 | 2021-03-25 | McLean | North Dakota | 38055 | 1233 | 30 |
1152922 | 1152922 | 2021-03-24 | McLean | North Dakota | 38055 | 1233 | 30 |
1149675 | 1149675 | 2021-03-23 | McLean | North Dakota | 38055 | 1234 | 30 |
1146428 | 1146428 | 2021-03-22 | McLean | North Dakota | 38055 | 1233 | 30 |
1143181 | 1143181 | 2021-03-21 | McLean | North Dakota | 38055 | 1232 | 30 |
1139934 | 1139934 | 2021-03-20 | McLean | North Dakota | 38055 | 1232 | 30 |
1136688 | 1136688 | 2021-03-19 | McLean | North Dakota | 38055 | 1231 | 30 |
1133442 | 1133442 | 2021-03-18 | McLean | North Dakota | 38055 | 1231 | 30 |
1130194 | 1130194 | 2021-03-17 | McLean | North Dakota | 38055 | 1229 | 30 |
1126947 | 1126947 | 2021-03-16 | McLean | North Dakota | 38055 | 1228 | 30 |
1123701 | 1123701 | 2021-03-15 | McLean | North Dakota | 38055 | 1226 | 30 |
1120455 | 1120455 | 2021-03-14 | McLean | North Dakota | 38055 | 1226 | 30 |
1117208 | 1117208 | 2021-03-13 | McLean | North Dakota | 38055 | 1226 | 30 |
1113961 | 1113961 | 2021-03-12 | McLean | North Dakota | 38055 | 1222 | 30 |
1110715 | 1110715 | 2021-03-11 | McLean | North Dakota | 38055 | 1220 | 30 |
1107469 | 1107469 | 2021-03-10 | McLean | North Dakota | 38055 | 1217 | 30 |
1104223 | 1104223 | 2021-03-09 | McLean | North Dakota | 38055 | 1216 | 31 |
1100977 | 1100977 | 2021-03-08 | McLean | North Dakota | 38055 | 1216 | 31 |
1097731 | 1097731 | 2021-03-07 | McLean | North Dakota | 38055 | 1216 | 31 |
1094483 | 1094483 | 2021-03-06 | McLean | North Dakota | 38055 | 1216 | 31 |
1091237 | 1091237 | 2021-03-05 | McLean | North Dakota | 38055 | 1215 | 31 |
1087992 | 1087992 | 2021-03-04 | McLean | North Dakota | 38055 | 1212 | 31 |
1084747 | 1084747 | 2021-03-03 | McLean | North Dakota | 38055 | 1212 | 31 |
1081501 | 1081501 | 2021-03-02 | McLean | North Dakota | 38055 | 1212 | 31 |
1078255 | 1078255 | 2021-03-01 | McLean | North Dakota | 38055 | 1212 | 31 |
1075010 | 1075010 | 2021-02-28 | McLean | North Dakota | 38055 | 1212 | 31 |
1071764 | 1071764 | 2021-02-27 | McLean | North Dakota | 38055 | 1210 | 31 |
1068518 | 1068518 | 2021-02-26 | McLean | North Dakota | 38055 | 1209 | 31 |
1065273 | 1065273 | 2021-02-25 | McLean | North Dakota | 38055 | 1206 | 31 |
1062029 | 1062029 | 2021-02-24 | McLean | North Dakota | 38055 | 1206 | 31 |
1058783 | 1058783 | 2021-02-23 | McLean | North Dakota | 38055 | 1205 | 31 |
1055537 | 1055537 | 2021-02-22 | McLean | North Dakota | 38055 | 1205 | 31 |
1052291 | 1052291 | 2021-02-21 | McLean | North Dakota | 38055 | 1205 | 31 |
1049044 | 1049044 | 2021-02-20 | McLean | North Dakota | 38055 | 1205 | 31 |
1045797 | 1045797 | 2021-02-19 | McLean | North Dakota | 38055 | 1205 | 31 |
1042552 | 1042552 | 2021-02-18 | McLean | North Dakota | 38055 | 1201 | 31 |
1039307 | 1039307 | 2021-02-17 | McLean | North Dakota | 38055 | 1200 | 31 |
1036062 | 1036062 | 2021-02-16 | McLean | North Dakota | 38055 | 1199 | 31 |
1032817 | 1032817 | 2021-02-15 | McLean | North Dakota | 38055 | 1198 | 31 |
1029571 | 1029571 | 2021-02-14 | McLean | North Dakota | 38055 | 1197 | 31 |
1026324 | 1026324 | 2021-02-13 | McLean | North Dakota | 38055 | 1197 | 31 |
1023079 | 1023079 | 2021-02-12 | McLean | North Dakota | 38055 | 1196 | 31 |
1019834 | 1019834 | 2021-02-11 | McLean | North Dakota | 38055 | 1192 | 31 |
1016589 | 1016589 | 2021-02-10 | McLean | North Dakota | 38055 | 1188 | 31 |
1013344 | 1013344 | 2021-02-09 | McLean | North Dakota | 38055 | 1189 | 31 |
1010099 | 1010099 | 2021-02-08 | McLean | North Dakota | 38055 | 1183 | 31 |
1006853 | 1006853 | 2021-02-07 | McLean | North Dakota | 38055 | 1183 | 31 |
1003607 | 1003607 | 2021-02-06 | McLean | North Dakota | 38055 | 1183 | 31 |
1000361 | 1000361 | 2021-02-05 | McLean | North Dakota | 38055 | 1183 | 31 |
997115 | 997115 | 2021-02-04 | McLean | North Dakota | 38055 | 1182 | 31 |
993869 | 993869 | 2021-02-03 | McLean | North Dakota | 38055 | 1180 | 31 |
990623 | 990623 | 2021-02-02 | McLean | North Dakota | 38055 | 1174 | 31 |
987377 | 987377 | 2021-02-01 | McLean | North Dakota | 38055 | 1174 | 31 |
984130 | 984130 | 2021-01-31 | McLean | North Dakota | 38055 | 1174 | 31 |
980883 | 980883 | 2021-01-30 | McLean | North Dakota | 38055 | 1174 | 31 |
977637 | 977637 | 2021-01-29 | McLean | North Dakota | 38055 | 1174 | 31 |
974392 | 974392 | 2021-01-28 | McLean | North Dakota | 38055 | 1173 | 31 |
971147 | 971147 | 2021-01-27 | McLean | North Dakota | 38055 | 1167 | 31 |
967902 | 967902 | 2021-01-26 | McLean | North Dakota | 38055 | 1166 | 31 |
964658 | 964658 | 2021-01-25 | McLean | North Dakota | 38055 | 1164 | 31 |
961413 | 961413 | 2021-01-24 | McLean | North Dakota | 38055 | 1162 | 31 |
958168 | 958168 | 2021-01-23 | McLean | North Dakota | 38055 | 1161 | 31 |
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);