ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38105 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 |
---|---|---|---|---|---|---|---|
1419185 | 1419185 | 2021-06-14 | Williams | North Dakota | 38105 | 5005 | 40 |
1415940 | 1415940 | 2021-06-13 | Williams | North Dakota | 38105 | 5005 | 40 |
1412694 | 1412694 | 2021-06-12 | Williams | North Dakota | 38105 | 5005 | 40 |
1409449 | 1409449 | 2021-06-11 | Williams | North Dakota | 38105 | 4999 | 40 |
1406204 | 1406204 | 2021-06-10 | Williams | North Dakota | 38105 | 4985 | 40 |
1402958 | 1402958 | 2021-06-09 | Williams | North Dakota | 38105 | 4978 | 40 |
1399713 | 1399713 | 2021-06-08 | Williams | North Dakota | 38105 | 4976 | 40 |
1396468 | 1396468 | 2021-06-07 | Williams | North Dakota | 38105 | 4972 | 40 |
1393221 | 1393221 | 2021-06-06 | Williams | North Dakota | 38105 | 4972 | 40 |
1389976 | 1389976 | 2021-06-05 | Williams | North Dakota | 38105 | 4971 | 40 |
1386731 | 1386731 | 2021-06-04 | Williams | North Dakota | 38105 | 4968 | 40 |
1383486 | 1383486 | 2021-06-03 | Williams | North Dakota | 38105 | 4965 | 40 |
1380240 | 1380240 | 2021-06-02 | Williams | North Dakota | 38105 | 4965 | 40 |
1376995 | 1376995 | 2021-06-01 | Williams | North Dakota | 38105 | 4958 | 40 |
1373749 | 1373749 | 2021-05-31 | Williams | North Dakota | 38105 | 4955 | 40 |
1370504 | 1370504 | 2021-05-30 | Williams | North Dakota | 38105 | 4955 | 40 |
1367258 | 1367258 | 2021-05-29 | Williams | North Dakota | 38105 | 4953 | 40 |
1364012 | 1364012 | 2021-05-28 | Williams | North Dakota | 38105 | 4948 | 40 |
1360766 | 1360766 | 2021-05-27 | Williams | North Dakota | 38105 | 4939 | 40 |
1357520 | 1357520 | 2021-05-26 | Williams | North Dakota | 38105 | 4932 | 40 |
1354274 | 1354274 | 2021-05-25 | Williams | North Dakota | 38105 | 4921 | 39 |
1351028 | 1351028 | 2021-05-24 | Williams | North Dakota | 38105 | 4909 | 39 |
1347782 | 1347782 | 2021-05-23 | Williams | North Dakota | 38105 | 4909 | 39 |
1344534 | 1344534 | 2021-05-22 | Williams | North Dakota | 38105 | 4908 | 39 |
1341286 | 1341286 | 2021-05-21 | Williams | North Dakota | 38105 | 4900 | 39 |
1338038 | 1338038 | 2021-05-20 | Williams | North Dakota | 38105 | 4896 | 39 |
1334791 | 1334791 | 2021-05-19 | Williams | North Dakota | 38105 | 4889 | 39 |
1331544 | 1331544 | 2021-05-18 | Williams | North Dakota | 38105 | 4869 | 39 |
1328297 | 1328297 | 2021-05-17 | Williams | North Dakota | 38105 | 4860 | 39 |
1325051 | 1325051 | 2021-05-16 | Williams | North Dakota | 38105 | 4857 | 39 |
1321805 | 1321805 | 2021-05-15 | Williams | North Dakota | 38105 | 4854 | 39 |
1318559 | 1318559 | 2021-05-14 | Williams | North Dakota | 38105 | 4848 | 39 |
1315311 | 1315311 | 2021-05-13 | Williams | North Dakota | 38105 | 4843 | 39 |
1312065 | 1312065 | 2021-05-12 | Williams | North Dakota | 38105 | 4828 | 39 |
1308818 | 1308818 | 2021-05-11 | Williams | North Dakota | 38105 | 4827 | 39 |
1305572 | 1305572 | 2021-05-10 | Williams | North Dakota | 38105 | 4820 | 38 |
1302326 | 1302326 | 2021-05-09 | Williams | North Dakota | 38105 | 4819 | 38 |
1299078 | 1299078 | 2021-05-08 | Williams | North Dakota | 38105 | 4818 | 38 |
1295832 | 1295832 | 2021-05-07 | Williams | North Dakota | 38105 | 4810 | 38 |
1292586 | 1292586 | 2021-05-06 | Williams | North Dakota | 38105 | 4804 | 38 |
1289340 | 1289340 | 2021-05-05 | Williams | North Dakota | 38105 | 4792 | 38 |
1286094 | 1286094 | 2021-05-04 | Williams | North Dakota | 38105 | 4786 | 38 |
1282848 | 1282848 | 2021-05-03 | Williams | North Dakota | 38105 | 4772 | 38 |
1279601 | 1279601 | 2021-05-02 | Williams | North Dakota | 38105 | 4772 | 38 |
1276354 | 1276354 | 2021-05-01 | Williams | North Dakota | 38105 | 4768 | 38 |
1273107 | 1273107 | 2021-04-30 | Williams | North Dakota | 38105 | 4747 | 38 |
1269860 | 1269860 | 2021-04-29 | Williams | North Dakota | 38105 | 4739 | 38 |
1266613 | 1266613 | 2021-04-28 | Williams | North Dakota | 38105 | 4730 | 38 |
1263366 | 1263366 | 2021-04-27 | Williams | North Dakota | 38105 | 4720 | 38 |
1260119 | 1260119 | 2021-04-26 | Williams | North Dakota | 38105 | 4708 | 38 |
1256872 | 1256872 | 2021-04-25 | Williams | North Dakota | 38105 | 4704 | 38 |
1253625 | 1253625 | 2021-04-24 | Williams | North Dakota | 38105 | 4702 | 38 |
1250378 | 1250378 | 2021-04-23 | Williams | North Dakota | 38105 | 4697 | 38 |
1247131 | 1247131 | 2021-04-22 | Williams | North Dakota | 38105 | 4689 | 38 |
1243884 | 1243884 | 2021-04-21 | Williams | North Dakota | 38105 | 4682 | 38 |
1240637 | 1240637 | 2021-04-20 | Williams | North Dakota | 38105 | 4672 | 38 |
1237390 | 1237390 | 2021-04-19 | Williams | North Dakota | 38105 | 4661 | 38 |
1234143 | 1234143 | 2021-04-18 | Williams | North Dakota | 38105 | 4658 | 38 |
1230895 | 1230895 | 2021-04-17 | Williams | North Dakota | 38105 | 4656 | 38 |
1227647 | 1227647 | 2021-04-16 | Williams | North Dakota | 38105 | 4648 | 38 |
1224399 | 1224399 | 2021-04-15 | Williams | North Dakota | 38105 | 4641 | 38 |
1221152 | 1221152 | 2021-04-14 | Williams | North Dakota | 38105 | 4632 | 38 |
1217904 | 1217904 | 2021-04-13 | Williams | North Dakota | 38105 | 4626 | 38 |
1214656 | 1214656 | 2021-04-12 | Williams | North Dakota | 38105 | 4624 | 37 |
1211409 | 1211409 | 2021-04-11 | Williams | North Dakota | 38105 | 4624 | 37 |
1208160 | 1208160 | 2021-04-10 | Williams | North Dakota | 38105 | 4624 | 37 |
1204912 | 1204912 | 2021-04-09 | Williams | North Dakota | 38105 | 4624 | 37 |
1201664 | 1201664 | 2021-04-08 | Williams | North Dakota | 38105 | 4622 | 37 |
1198415 | 1198415 | 2021-04-07 | Williams | North Dakota | 38105 | 4619 | 37 |
1195166 | 1195166 | 2021-04-06 | Williams | North Dakota | 38105 | 4618 | 37 |
1191918 | 1191918 | 2021-04-05 | Williams | North Dakota | 38105 | 4619 | 37 |
1188669 | 1188669 | 2021-04-04 | Williams | North Dakota | 38105 | 4619 | 37 |
1185422 | 1185422 | 2021-04-03 | Williams | North Dakota | 38105 | 4619 | 37 |
1182175 | 1182175 | 2021-04-02 | Williams | North Dakota | 38105 | 4618 | 37 |
1178928 | 1178928 | 2021-04-01 | Williams | North Dakota | 38105 | 4616 | 37 |
1175681 | 1175681 | 2021-03-31 | Williams | North Dakota | 38105 | 4613 | 37 |
1172434 | 1172434 | 2021-03-30 | Williams | North Dakota | 38105 | 4606 | 37 |
1169187 | 1169187 | 2021-03-29 | Williams | North Dakota | 38105 | 4602 | 37 |
1165939 | 1165939 | 2021-03-28 | Williams | North Dakota | 38105 | 4600 | 37 |
1162691 | 1162691 | 2021-03-27 | Williams | North Dakota | 38105 | 4598 | 37 |
1159442 | 1159442 | 2021-03-26 | Williams | North Dakota | 38105 | 4591 | 37 |
1156195 | 1156195 | 2021-03-25 | Williams | North Dakota | 38105 | 4590 | 37 |
1152948 | 1152948 | 2021-03-24 | Williams | North Dakota | 38105 | 4580 | 37 |
1149701 | 1149701 | 2021-03-23 | Williams | North Dakota | 38105 | 4572 | 37 |
1146454 | 1146454 | 2021-03-22 | Williams | North Dakota | 38105 | 4569 | 36 |
1143207 | 1143207 | 2021-03-21 | Williams | North Dakota | 38105 | 4565 | 36 |
1139960 | 1139960 | 2021-03-20 | Williams | North Dakota | 38105 | 4564 | 36 |
1136714 | 1136714 | 2021-03-19 | Williams | North Dakota | 38105 | 4559 | 36 |
1133468 | 1133468 | 2021-03-18 | Williams | North Dakota | 38105 | 4554 | 36 |
1130220 | 1130220 | 2021-03-17 | Williams | North Dakota | 38105 | 4547 | 36 |
1126973 | 1126973 | 2021-03-16 | Williams | North Dakota | 38105 | 4538 | 36 |
1123727 | 1123727 | 2021-03-15 | Williams | North Dakota | 38105 | 4533 | 36 |
1120481 | 1120481 | 2021-03-14 | Williams | North Dakota | 38105 | 4533 | 36 |
1117234 | 1117234 | 2021-03-13 | Williams | North Dakota | 38105 | 4531 | 36 |
1113987 | 1113987 | 2021-03-12 | Williams | North Dakota | 38105 | 4527 | 36 |
1110741 | 1110741 | 2021-03-11 | Williams | North Dakota | 38105 | 4519 | 36 |
1107495 | 1107495 | 2021-03-10 | Williams | North Dakota | 38105 | 4515 | 36 |
1104249 | 1104249 | 2021-03-09 | Williams | North Dakota | 38105 | 4514 | 36 |
1101003 | 1101003 | 2021-03-08 | Williams | North Dakota | 38105 | 4510 | 36 |
1097757 | 1097757 | 2021-03-07 | Williams | North Dakota | 38105 | 4507 | 36 |
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);