ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Sioux" 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 |
---|---|---|---|---|---|---|---|
1279590 | 1279590 | 2021-05-02 | Sioux | North Dakota | 38085 | 656 | 12 |
1276343 | 1276343 | 2021-05-01 | Sioux | North Dakota | 38085 | 656 | 12 |
1273096 | 1273096 | 2021-04-30 | Sioux | North Dakota | 38085 | 654 | 12 |
1269849 | 1269849 | 2021-04-29 | Sioux | North Dakota | 38085 | 654 | 12 |
1266602 | 1266602 | 2021-04-28 | Sioux | North Dakota | 38085 | 653 | 11 |
1263355 | 1263355 | 2021-04-27 | Sioux | North Dakota | 38085 | 653 | 11 |
1260108 | 1260108 | 2021-04-26 | Sioux | North Dakota | 38085 | 653 | 11 |
1256861 | 1256861 | 2021-04-25 | Sioux | North Dakota | 38085 | 652 | 11 |
1253614 | 1253614 | 2021-04-24 | Sioux | North Dakota | 38085 | 652 | 11 |
1250367 | 1250367 | 2021-04-23 | Sioux | North Dakota | 38085 | 652 | 11 |
1247120 | 1247120 | 2021-04-22 | Sioux | North Dakota | 38085 | 651 | 11 |
1243873 | 1243873 | 2021-04-21 | Sioux | North Dakota | 38085 | 651 | 11 |
1240626 | 1240626 | 2021-04-20 | Sioux | North Dakota | 38085 | 650 | 11 |
1237379 | 1237379 | 2021-04-19 | Sioux | North Dakota | 38085 | 649 | 11 |
1234132 | 1234132 | 2021-04-18 | Sioux | North Dakota | 38085 | 648 | 11 |
1230884 | 1230884 | 2021-04-17 | Sioux | North Dakota | 38085 | 648 | 11 |
1227636 | 1227636 | 2021-04-16 | Sioux | North Dakota | 38085 | 648 | 11 |
1224388 | 1224388 | 2021-04-15 | Sioux | North Dakota | 38085 | 648 | 11 |
1221141 | 1221141 | 2021-04-14 | Sioux | North Dakota | 38085 | 646 | 11 |
1217893 | 1217893 | 2021-04-13 | Sioux | North Dakota | 38085 | 645 | 11 |
1214645 | 1214645 | 2021-04-12 | Sioux | North Dakota | 38085 | 644 | 11 |
1211398 | 1211398 | 2021-04-11 | Sioux | North Dakota | 38085 | 643 | 11 |
1208149 | 1208149 | 2021-04-10 | Sioux | North Dakota | 38085 | 643 | 11 |
1204901 | 1204901 | 2021-04-09 | Sioux | North Dakota | 38085 | 643 | 11 |
1201653 | 1201653 | 2021-04-08 | Sioux | North Dakota | 38085 | 643 | 11 |
1198404 | 1198404 | 2021-04-07 | Sioux | North Dakota | 38085 | 643 | 11 |
1195155 | 1195155 | 2021-04-06 | Sioux | North Dakota | 38085 | 642 | 11 |
1191907 | 1191907 | 2021-04-05 | Sioux | North Dakota | 38085 | 642 | 11 |
1188658 | 1188658 | 2021-04-04 | Sioux | North Dakota | 38085 | 642 | 11 |
1185411 | 1185411 | 2021-04-03 | Sioux | North Dakota | 38085 | 642 | 11 |
1182164 | 1182164 | 2021-04-02 | Sioux | North Dakota | 38085 | 642 | 11 |
1178917 | 1178917 | 2021-04-01 | Sioux | North Dakota | 38085 | 642 | 11 |
1175670 | 1175670 | 2021-03-31 | Sioux | North Dakota | 38085 | 642 | 11 |
1172423 | 1172423 | 2021-03-30 | Sioux | North Dakota | 38085 | 642 | 11 |
1169176 | 1169176 | 2021-03-29 | Sioux | North Dakota | 38085 | 642 | 11 |
1165928 | 1165928 | 2021-03-28 | Sioux | North Dakota | 38085 | 642 | 11 |
1162680 | 1162680 | 2021-03-27 | Sioux | North Dakota | 38085 | 642 | 11 |
1159431 | 1159431 | 2021-03-26 | Sioux | North Dakota | 38085 | 642 | 11 |
1156184 | 1156184 | 2021-03-25 | Sioux | North Dakota | 38085 | 642 | 11 |
1152937 | 1152937 | 2021-03-24 | Sioux | North Dakota | 38085 | 642 | 11 |
1149690 | 1149690 | 2021-03-23 | Sioux | North Dakota | 38085 | 642 | 11 |
1146443 | 1146443 | 2021-03-22 | Sioux | North Dakota | 38085 | 642 | 11 |
1143196 | 1143196 | 2021-03-21 | Sioux | North Dakota | 38085 | 642 | 11 |
1139949 | 1139949 | 2021-03-20 | Sioux | North Dakota | 38085 | 642 | 11 |
1136703 | 1136703 | 2021-03-19 | Sioux | North Dakota | 38085 | 642 | 11 |
1133457 | 1133457 | 2021-03-18 | Sioux | North Dakota | 38085 | 641 | 11 |
1130209 | 1130209 | 2021-03-17 | Sioux | North Dakota | 38085 | 641 | 11 |
1126962 | 1126962 | 2021-03-16 | Sioux | North Dakota | 38085 | 641 | 11 |
1123716 | 1123716 | 2021-03-15 | Sioux | North Dakota | 38085 | 641 | 11 |
1120470 | 1120470 | 2021-03-14 | Sioux | North Dakota | 38085 | 641 | 11 |
1117223 | 1117223 | 2021-03-13 | Sioux | North Dakota | 38085 | 641 | 11 |
1113976 | 1113976 | 2021-03-12 | Sioux | North Dakota | 38085 | 641 | 11 |
1110730 | 1110730 | 2021-03-11 | Sioux | North Dakota | 38085 | 641 | 11 |
1107484 | 1107484 | 2021-03-10 | Sioux | North Dakota | 38085 | 641 | 11 |
1104238 | 1104238 | 2021-03-09 | Sioux | North Dakota | 38085 | 641 | 11 |
1100992 | 1100992 | 2021-03-08 | Sioux | North Dakota | 38085 | 641 | 11 |
1097746 | 1097746 | 2021-03-07 | Sioux | North Dakota | 38085 | 641 | 11 |
1094498 | 1094498 | 2021-03-06 | Sioux | North Dakota | 38085 | 641 | 11 |
1091252 | 1091252 | 2021-03-05 | Sioux | North Dakota | 38085 | 641 | 11 |
1088007 | 1088007 | 2021-03-04 | Sioux | North Dakota | 38085 | 641 | 11 |
1084762 | 1084762 | 2021-03-03 | Sioux | North Dakota | 38085 | 641 | 11 |
1081516 | 1081516 | 2021-03-02 | Sioux | North Dakota | 38085 | 641 | 11 |
1078270 | 1078270 | 2021-03-01 | Sioux | North Dakota | 38085 | 642 | 11 |
1075025 | 1075025 | 2021-02-28 | Sioux | North Dakota | 38085 | 641 | 11 |
1071779 | 1071779 | 2021-02-27 | Sioux | North Dakota | 38085 | 641 | 11 |
1068533 | 1068533 | 2021-02-26 | Sioux | North Dakota | 38085 | 642 | 11 |
1065288 | 1065288 | 2021-02-25 | Sioux | North Dakota | 38085 | 642 | 11 |
1062044 | 1062044 | 2021-02-24 | Sioux | North Dakota | 38085 | 642 | 11 |
1058798 | 1058798 | 2021-02-23 | Sioux | North Dakota | 38085 | 641 | 11 |
1055552 | 1055552 | 2021-02-22 | Sioux | North Dakota | 38085 | 641 | 11 |
1052306 | 1052306 | 2021-02-21 | Sioux | North Dakota | 38085 | 641 | 11 |
1049059 | 1049059 | 2021-02-20 | Sioux | North Dakota | 38085 | 641 | 11 |
1045812 | 1045812 | 2021-02-19 | Sioux | North Dakota | 38085 | 641 | 11 |
1042567 | 1042567 | 2021-02-18 | Sioux | North Dakota | 38085 | 641 | 11 |
1039322 | 1039322 | 2021-02-17 | Sioux | North Dakota | 38085 | 640 | 11 |
1036077 | 1036077 | 2021-02-16 | Sioux | North Dakota | 38085 | 640 | 11 |
1032832 | 1032832 | 2021-02-15 | Sioux | North Dakota | 38085 | 641 | 11 |
1029586 | 1029586 | 2021-02-14 | Sioux | North Dakota | 38085 | 641 | 11 |
1026339 | 1026339 | 2021-02-13 | Sioux | North Dakota | 38085 | 640 | 11 |
1023094 | 1023094 | 2021-02-12 | Sioux | North Dakota | 38085 | 640 | 11 |
1019849 | 1019849 | 2021-02-11 | Sioux | North Dakota | 38085 | 640 | 11 |
1016604 | 1016604 | 2021-02-10 | Sioux | North Dakota | 38085 | 640 | 11 |
1013359 | 1013359 | 2021-02-09 | Sioux | North Dakota | 38085 | 640 | 11 |
1010114 | 1010114 | 2021-02-08 | Sioux | North Dakota | 38085 | 642 | 11 |
1006868 | 1006868 | 2021-02-07 | Sioux | North Dakota | 38085 | 642 | 11 |
1003622 | 1003622 | 2021-02-06 | Sioux | North Dakota | 38085 | 642 | 11 |
1000376 | 1000376 | 2021-02-05 | Sioux | North Dakota | 38085 | 642 | 11 |
997130 | 997130 | 2021-02-04 | Sioux | North Dakota | 38085 | 642 | 11 |
993884 | 993884 | 2021-02-03 | Sioux | North Dakota | 38085 | 642 | 11 |
990638 | 990638 | 2021-02-02 | Sioux | North Dakota | 38085 | 642 | 11 |
987392 | 987392 | 2021-02-01 | Sioux | North Dakota | 38085 | 640 | 11 |
984145 | 984145 | 2021-01-31 | Sioux | North Dakota | 38085 | 640 | 11 |
980898 | 980898 | 2021-01-30 | Sioux | North Dakota | 38085 | 640 | 11 |
977652 | 977652 | 2021-01-29 | Sioux | North Dakota | 38085 | 640 | 11 |
974407 | 974407 | 2021-01-28 | Sioux | North Dakota | 38085 | 640 | 11 |
971162 | 971162 | 2021-01-27 | Sioux | North Dakota | 38085 | 641 | 11 |
967917 | 967917 | 2021-01-26 | Sioux | North Dakota | 38085 | 639 | 11 |
964673 | 964673 | 2021-01-25 | Sioux | North Dakota | 38085 | 639 | 11 |
961428 | 961428 | 2021-01-24 | Sioux | North Dakota | 38085 | 639 | 11 |
958183 | 958183 | 2021-01-23 | Sioux | North Dakota | 38085 | 639 | 11 |
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);