ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Mountrail" 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 |
---|---|---|---|---|---|---|---|
1279578 | 1279578 | 2021-05-02 | Mountrail | North Dakota | 38061 | 1314 | 17 |
1276331 | 1276331 | 2021-05-01 | Mountrail | North Dakota | 38061 | 1313 | 17 |
1273084 | 1273084 | 2021-04-30 | Mountrail | North Dakota | 38061 | 1312 | 17 |
1269837 | 1269837 | 2021-04-29 | Mountrail | North Dakota | 38061 | 1312 | 17 |
1266590 | 1266590 | 2021-04-28 | Mountrail | North Dakota | 38061 | 1311 | 17 |
1263343 | 1263343 | 2021-04-27 | Mountrail | North Dakota | 38061 | 1310 | 17 |
1260096 | 1260096 | 2021-04-26 | Mountrail | North Dakota | 38061 | 1310 | 17 |
1256849 | 1256849 | 2021-04-25 | Mountrail | North Dakota | 38061 | 1309 | 17 |
1253602 | 1253602 | 2021-04-24 | Mountrail | North Dakota | 38061 | 1309 | 17 |
1250355 | 1250355 | 2021-04-23 | Mountrail | North Dakota | 38061 | 1305 | 17 |
1247108 | 1247108 | 2021-04-22 | Mountrail | North Dakota | 38061 | 1303 | 17 |
1243861 | 1243861 | 2021-04-21 | Mountrail | North Dakota | 38061 | 1303 | 17 |
1240614 | 1240614 | 2021-04-20 | Mountrail | North Dakota | 38061 | 1303 | 17 |
1237367 | 1237367 | 2021-04-19 | Mountrail | North Dakota | 38061 | 1302 | 17 |
1234120 | 1234120 | 2021-04-18 | Mountrail | North Dakota | 38061 | 1302 | 17 |
1230872 | 1230872 | 2021-04-17 | Mountrail | North Dakota | 38061 | 1301 | 17 |
1227624 | 1227624 | 2021-04-16 | Mountrail | North Dakota | 38061 | 1298 | 17 |
1224376 | 1224376 | 2021-04-15 | Mountrail | North Dakota | 38061 | 1298 | 17 |
1221129 | 1221129 | 2021-04-14 | Mountrail | North Dakota | 38061 | 1297 | 17 |
1217881 | 1217881 | 2021-04-13 | Mountrail | North Dakota | 38061 | 1297 | 17 |
1214633 | 1214633 | 2021-04-12 | Mountrail | North Dakota | 38061 | 1294 | 17 |
1211386 | 1211386 | 2021-04-11 | Mountrail | North Dakota | 38061 | 1294 | 17 |
1208137 | 1208137 | 2021-04-10 | Mountrail | North Dakota | 38061 | 1294 | 17 |
1204889 | 1204889 | 2021-04-09 | Mountrail | North Dakota | 38061 | 1292 | 17 |
1201641 | 1201641 | 2021-04-08 | Mountrail | North Dakota | 38061 | 1291 | 17 |
1198392 | 1198392 | 2021-04-07 | Mountrail | North Dakota | 38061 | 1291 | 17 |
1195143 | 1195143 | 2021-04-06 | Mountrail | North Dakota | 38061 | 1290 | 17 |
1191895 | 1191895 | 2021-04-05 | Mountrail | North Dakota | 38061 | 1288 | 17 |
1188646 | 1188646 | 2021-04-04 | Mountrail | North Dakota | 38061 | 1288 | 17 |
1185399 | 1185399 | 2021-04-03 | Mountrail | North Dakota | 38061 | 1288 | 17 |
1182152 | 1182152 | 2021-04-02 | Mountrail | North Dakota | 38061 | 1287 | 17 |
1178905 | 1178905 | 2021-04-01 | Mountrail | North Dakota | 38061 | 1287 | 17 |
1175658 | 1175658 | 2021-03-31 | Mountrail | North Dakota | 38061 | 1287 | 17 |
1172411 | 1172411 | 2021-03-30 | Mountrail | North Dakota | 38061 | 1285 | 17 |
1169164 | 1169164 | 2021-03-29 | Mountrail | North Dakota | 38061 | 1283 | 17 |
1165916 | 1165916 | 2021-03-28 | Mountrail | North Dakota | 38061 | 1282 | 17 |
1162668 | 1162668 | 2021-03-27 | Mountrail | North Dakota | 38061 | 1282 | 17 |
1159419 | 1159419 | 2021-03-26 | Mountrail | North Dakota | 38061 | 1282 | 17 |
1156172 | 1156172 | 2021-03-25 | Mountrail | North Dakota | 38061 | 1282 | 17 |
1152925 | 1152925 | 2021-03-24 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1149678 | 1149678 | 2021-03-23 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1146431 | 1146431 | 2021-03-22 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1143184 | 1143184 | 2021-03-21 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1139937 | 1139937 | 2021-03-20 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1136691 | 1136691 | 2021-03-19 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1133445 | 1133445 | 2021-03-18 | Mountrail | North Dakota | 38061 | 1281 | 17 |
1130197 | 1130197 | 2021-03-17 | Mountrail | North Dakota | 38061 | 1279 | 17 |
1126950 | 1126950 | 2021-03-16 | Mountrail | North Dakota | 38061 | 1279 | 17 |
1123704 | 1123704 | 2021-03-15 | Mountrail | North Dakota | 38061 | 1277 | 17 |
1120458 | 1120458 | 2021-03-14 | Mountrail | North Dakota | 38061 | 1277 | 17 |
1117211 | 1117211 | 2021-03-13 | Mountrail | North Dakota | 38061 | 1277 | 17 |
1113964 | 1113964 | 2021-03-12 | Mountrail | North Dakota | 38061 | 1277 | 17 |
1110718 | 1110718 | 2021-03-11 | Mountrail | North Dakota | 38061 | 1276 | 17 |
1107472 | 1107472 | 2021-03-10 | Mountrail | North Dakota | 38061 | 1274 | 17 |
1104226 | 1104226 | 2021-03-09 | Mountrail | North Dakota | 38061 | 1274 | 17 |
1100980 | 1100980 | 2021-03-08 | Mountrail | North Dakota | 38061 | 1275 | 17 |
1097734 | 1097734 | 2021-03-07 | Mountrail | North Dakota | 38061 | 1274 | 17 |
1094486 | 1094486 | 2021-03-06 | Mountrail | North Dakota | 38061 | 1274 | 17 |
1091240 | 1091240 | 2021-03-05 | Mountrail | North Dakota | 38061 | 1273 | 17 |
1087995 | 1087995 | 2021-03-04 | Mountrail | North Dakota | 38061 | 1273 | 17 |
1084750 | 1084750 | 2021-03-03 | Mountrail | North Dakota | 38061 | 1272 | 17 |
1081504 | 1081504 | 2021-03-02 | Mountrail | North Dakota | 38061 | 1273 | 17 |
1078258 | 1078258 | 2021-03-01 | Mountrail | North Dakota | 38061 | 1272 | 17 |
1075013 | 1075013 | 2021-02-28 | Mountrail | North Dakota | 38061 | 1270 | 17 |
1071767 | 1071767 | 2021-02-27 | Mountrail | North Dakota | 38061 | 1270 | 17 |
1068521 | 1068521 | 2021-02-26 | Mountrail | North Dakota | 38061 | 1270 | 17 |
1065276 | 1065276 | 2021-02-25 | Mountrail | North Dakota | 38061 | 1270 | 17 |
1062032 | 1062032 | 2021-02-24 | Mountrail | North Dakota | 38061 | 1270 | 17 |
1058786 | 1058786 | 2021-02-23 | Mountrail | North Dakota | 38061 | 1269 | 17 |
1055540 | 1055540 | 2021-02-22 | Mountrail | North Dakota | 38061 | 1265 | 17 |
1052294 | 1052294 | 2021-02-21 | Mountrail | North Dakota | 38061 | 1264 | 17 |
1049047 | 1049047 | 2021-02-20 | Mountrail | North Dakota | 38061 | 1264 | 17 |
1045800 | 1045800 | 2021-02-19 | Mountrail | North Dakota | 38061 | 1263 | 17 |
1042555 | 1042555 | 2021-02-18 | Mountrail | North Dakota | 38061 | 1262 | 17 |
1039310 | 1039310 | 2021-02-17 | Mountrail | North Dakota | 38061 | 1262 | 17 |
1036065 | 1036065 | 2021-02-16 | Mountrail | North Dakota | 38061 | 1261 | 17 |
1032820 | 1032820 | 2021-02-15 | Mountrail | North Dakota | 38061 | 1262 | 17 |
1029574 | 1029574 | 2021-02-14 | Mountrail | North Dakota | 38061 | 1262 | 17 |
1026327 | 1026327 | 2021-02-13 | Mountrail | North Dakota | 38061 | 1262 | 17 |
1023082 | 1023082 | 2021-02-12 | Mountrail | North Dakota | 38061 | 1261 | 17 |
1019837 | 1019837 | 2021-02-11 | Mountrail | North Dakota | 38061 | 1261 | 17 |
1016592 | 1016592 | 2021-02-10 | Mountrail | North Dakota | 38061 | 1259 | 17 |
1013347 | 1013347 | 2021-02-09 | Mountrail | North Dakota | 38061 | 1260 | 17 |
1010102 | 1010102 | 2021-02-08 | Mountrail | North Dakota | 38061 | 1263 | 17 |
1006856 | 1006856 | 2021-02-07 | Mountrail | North Dakota | 38061 | 1263 | 17 |
1003610 | 1003610 | 2021-02-06 | Mountrail | North Dakota | 38061 | 1261 | 17 |
1000364 | 1000364 | 2021-02-05 | Mountrail | North Dakota | 38061 | 1260 | 17 |
997118 | 997118 | 2021-02-04 | Mountrail | North Dakota | 38061 | 1262 | 17 |
993872 | 993872 | 2021-02-03 | Mountrail | North Dakota | 38061 | 1254 | 17 |
990626 | 990626 | 2021-02-02 | Mountrail | North Dakota | 38061 | 1253 | 17 |
987380 | 987380 | 2021-02-01 | Mountrail | North Dakota | 38061 | 1250 | 17 |
984133 | 984133 | 2021-01-31 | Mountrail | North Dakota | 38061 | 1250 | 17 |
980886 | 980886 | 2021-01-30 | Mountrail | North Dakota | 38061 | 1247 | 17 |
977640 | 977640 | 2021-01-29 | Mountrail | North Dakota | 38061 | 1247 | 17 |
974395 | 974395 | 2021-01-28 | Mountrail | North Dakota | 38061 | 1244 | 17 |
971150 | 971150 | 2021-01-27 | Mountrail | North Dakota | 38061 | 1243 | 17 |
967905 | 967905 | 2021-01-26 | Mountrail | North Dakota | 38061 | 1242 | 17 |
964661 | 964661 | 2021-01-25 | Mountrail | North Dakota | 38061 | 1242 | 17 |
961416 | 961416 | 2021-01-24 | Mountrail | North Dakota | 38061 | 1242 | 17 |
958171 | 958171 | 2021-01-23 | Mountrail | North Dakota | 38061 | 1241 | 17 |
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);