ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Williams" 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 |
---|---|---|---|---|---|---|---|
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 |
1094509 | 1094509 | 2021-03-06 | Williams | North Dakota | 38105 | 4505 | 36 |
1091263 | 1091263 | 2021-03-05 | Williams | North Dakota | 38105 | 4497 | 36 |
1088018 | 1088018 | 2021-03-04 | Williams | North Dakota | 38105 | 4496 | 36 |
1084773 | 1084773 | 2021-03-03 | Williams | North Dakota | 38105 | 4484 | 36 |
1081527 | 1081527 | 2021-03-02 | Williams | North Dakota | 38105 | 4476 | 36 |
1078281 | 1078281 | 2021-03-01 | Williams | North Dakota | 38105 | 4464 | 36 |
1075036 | 1075036 | 2021-02-28 | Williams | North Dakota | 38105 | 4462 | 36 |
1071790 | 1071790 | 2021-02-27 | Williams | North Dakota | 38105 | 4462 | 36 |
1068544 | 1068544 | 2021-02-26 | Williams | North Dakota | 38105 | 4458 | 36 |
1065299 | 1065299 | 2021-02-25 | Williams | North Dakota | 38105 | 4456 | 36 |
1062055 | 1062055 | 2021-02-24 | Williams | North Dakota | 38105 | 4454 | 36 |
1058809 | 1058809 | 2021-02-23 | Williams | North Dakota | 38105 | 4441 | 36 |
1055563 | 1055563 | 2021-02-22 | Williams | North Dakota | 38105 | 4437 | 36 |
1052317 | 1052317 | 2021-02-21 | Williams | North Dakota | 38105 | 4431 | 36 |
1049070 | 1049070 | 2021-02-20 | Williams | North Dakota | 38105 | 4432 | 36 |
1045823 | 1045823 | 2021-02-19 | Williams | North Dakota | 38105 | 4425 | 36 |
1042578 | 1042578 | 2021-02-18 | Williams | North Dakota | 38105 | 4418 | 36 |
1039333 | 1039333 | 2021-02-17 | Williams | North Dakota | 38105 | 4407 | 36 |
1036088 | 1036088 | 2021-02-16 | Williams | North Dakota | 38105 | 4403 | 36 |
1032843 | 1032843 | 2021-02-15 | Williams | North Dakota | 38105 | 4396 | 36 |
1029597 | 1029597 | 2021-02-14 | Williams | North Dakota | 38105 | 4393 | 36 |
1026350 | 1026350 | 2021-02-13 | Williams | North Dakota | 38105 | 4390 | 36 |
1023105 | 1023105 | 2021-02-12 | Williams | North Dakota | 38105 | 4385 | 36 |
1019860 | 1019860 | 2021-02-11 | Williams | North Dakota | 38105 | 4379 | 35 |
1016615 | 1016615 | 2021-02-10 | Williams | North Dakota | 38105 | 4373 | 35 |
1013370 | 1013370 | 2021-02-09 | Williams | North Dakota | 38105 | 4366 | 35 |
1010125 | 1010125 | 2021-02-08 | Williams | North Dakota | 38105 | 4361 | 35 |
1006879 | 1006879 | 2021-02-07 | Williams | North Dakota | 38105 | 4360 | 35 |
1003633 | 1003633 | 2021-02-06 | Williams | North Dakota | 38105 | 4356 | 35 |
1000387 | 1000387 | 2021-02-05 | Williams | North Dakota | 38105 | 4355 | 35 |
997141 | 997141 | 2021-02-04 | Williams | North Dakota | 38105 | 4351 | 35 |
993895 | 993895 | 2021-02-03 | Williams | North Dakota | 38105 | 4328 | 35 |
990649 | 990649 | 2021-02-02 | Williams | North Dakota | 38105 | 4321 | 35 |
987403 | 987403 | 2021-02-01 | Williams | North Dakota | 38105 | 4313 | 35 |
984156 | 984156 | 2021-01-31 | Williams | North Dakota | 38105 | 4311 | 35 |
980909 | 980909 | 2021-01-30 | Williams | North Dakota | 38105 | 4306 | 35 |
977663 | 977663 | 2021-01-29 | Williams | North Dakota | 38105 | 4293 | 35 |
974418 | 974418 | 2021-01-28 | Williams | North Dakota | 38105 | 4287 | 35 |
971173 | 971173 | 2021-01-27 | Williams | North Dakota | 38105 | 4266 | 35 |
967928 | 967928 | 2021-01-26 | Williams | North Dakota | 38105 | 4240 | 35 |
964684 | 964684 | 2021-01-25 | Williams | North Dakota | 38105 | 4225 | 35 |
961439 | 961439 | 2021-01-24 | Williams | North Dakota | 38105 | 4220 | 35 |
958194 | 958194 | 2021-01-23 | Williams | North Dakota | 38105 | 4216 | 35 |
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);