ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38023 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 |
---|---|---|---|---|---|---|---|
1279559 | 1279559 | 2021-05-02 | Divide | North Dakota | 38023 | 178 | 2 |
1276312 | 1276312 | 2021-05-01 | Divide | North Dakota | 38023 | 178 | 2 |
1273065 | 1273065 | 2021-04-30 | Divide | North Dakota | 38023 | 175 | 2 |
1269818 | 1269818 | 2021-04-29 | Divide | North Dakota | 38023 | 175 | 2 |
1266571 | 1266571 | 2021-04-28 | Divide | North Dakota | 38023 | 175 | 2 |
1263324 | 1263324 | 2021-04-27 | Divide | North Dakota | 38023 | 175 | 2 |
1260077 | 1260077 | 2021-04-26 | Divide | North Dakota | 38023 | 175 | 2 |
1256830 | 1256830 | 2021-04-25 | Divide | North Dakota | 38023 | 174 | 2 |
1253583 | 1253583 | 2021-04-24 | Divide | North Dakota | 38023 | 174 | 2 |
1250336 | 1250336 | 2021-04-23 | Divide | North Dakota | 38023 | 174 | 2 |
1247089 | 1247089 | 2021-04-22 | Divide | North Dakota | 38023 | 174 | 2 |
1243842 | 1243842 | 2021-04-21 | Divide | North Dakota | 38023 | 174 | 2 |
1240595 | 1240595 | 2021-04-20 | Divide | North Dakota | 38023 | 174 | 2 |
1237348 | 1237348 | 2021-04-19 | Divide | North Dakota | 38023 | 173 | 2 |
1234101 | 1234101 | 2021-04-18 | Divide | North Dakota | 38023 | 173 | 2 |
1230853 | 1230853 | 2021-04-17 | Divide | North Dakota | 38023 | 173 | 2 |
1227605 | 1227605 | 2021-04-16 | Divide | North Dakota | 38023 | 173 | 2 |
1224357 | 1224357 | 2021-04-15 | Divide | North Dakota | 38023 | 173 | 2 |
1221110 | 1221110 | 2021-04-14 | Divide | North Dakota | 38023 | 173 | 2 |
1217862 | 1217862 | 2021-04-13 | Divide | North Dakota | 38023 | 173 | 2 |
1214614 | 1214614 | 2021-04-12 | Divide | North Dakota | 38023 | 173 | 2 |
1211367 | 1211367 | 2021-04-11 | Divide | North Dakota | 38023 | 173 | 2 |
1208118 | 1208118 | 2021-04-10 | Divide | North Dakota | 38023 | 173 | 2 |
1204870 | 1204870 | 2021-04-09 | Divide | North Dakota | 38023 | 173 | 2 |
1201622 | 1201622 | 2021-04-08 | Divide | North Dakota | 38023 | 173 | 2 |
1198373 | 1198373 | 2021-04-07 | Divide | North Dakota | 38023 | 173 | 2 |
1195124 | 1195124 | 2021-04-06 | Divide | North Dakota | 38023 | 173 | 2 |
1191876 | 1191876 | 2021-04-05 | Divide | North Dakota | 38023 | 173 | 2 |
1188627 | 1188627 | 2021-04-04 | Divide | North Dakota | 38023 | 173 | 2 |
1185380 | 1185380 | 2021-04-03 | Divide | North Dakota | 38023 | 173 | 2 |
1182133 | 1182133 | 2021-04-02 | Divide | North Dakota | 38023 | 173 | 2 |
1178886 | 1178886 | 2021-04-01 | Divide | North Dakota | 38023 | 173 | 2 |
1175639 | 1175639 | 2021-03-31 | Divide | North Dakota | 38023 | 173 | 2 |
1172392 | 1172392 | 2021-03-30 | Divide | North Dakota | 38023 | 173 | 2 |
1169145 | 1169145 | 2021-03-29 | Divide | North Dakota | 38023 | 173 | 2 |
1165897 | 1165897 | 2021-03-28 | Divide | North Dakota | 38023 | 173 | 2 |
1162649 | 1162649 | 2021-03-27 | Divide | North Dakota | 38023 | 173 | 2 |
1159400 | 1159400 | 2021-03-26 | Divide | North Dakota | 38023 | 173 | 2 |
1156153 | 1156153 | 2021-03-25 | Divide | North Dakota | 38023 | 173 | 2 |
1152906 | 1152906 | 2021-03-24 | Divide | North Dakota | 38023 | 172 | 2 |
1149659 | 1149659 | 2021-03-23 | Divide | North Dakota | 38023 | 172 | 2 |
1146412 | 1146412 | 2021-03-22 | Divide | North Dakota | 38023 | 172 | 2 |
1143165 | 1143165 | 2021-03-21 | Divide | North Dakota | 38023 | 172 | 2 |
1139918 | 1139918 | 2021-03-20 | Divide | North Dakota | 38023 | 172 | 2 |
1136672 | 1136672 | 2021-03-19 | Divide | North Dakota | 38023 | 172 | 2 |
1133426 | 1133426 | 2021-03-18 | Divide | North Dakota | 38023 | 172 | 2 |
1130178 | 1130178 | 2021-03-17 | Divide | North Dakota | 38023 | 172 | 2 |
1126931 | 1126931 | 2021-03-16 | Divide | North Dakota | 38023 | 172 | 2 |
1123685 | 1123685 | 2021-03-15 | Divide | North Dakota | 38023 | 172 | 2 |
1120439 | 1120439 | 2021-03-14 | Divide | North Dakota | 38023 | 172 | 2 |
1117192 | 1117192 | 2021-03-13 | Divide | North Dakota | 38023 | 172 | 2 |
1113945 | 1113945 | 2021-03-12 | Divide | North Dakota | 38023 | 171 | 2 |
1110699 | 1110699 | 2021-03-11 | Divide | North Dakota | 38023 | 171 | 2 |
1107453 | 1107453 | 2021-03-10 | Divide | North Dakota | 38023 | 169 | 2 |
1104207 | 1104207 | 2021-03-09 | Divide | North Dakota | 38023 | 168 | 2 |
1100961 | 1100961 | 2021-03-08 | Divide | North Dakota | 38023 | 166 | 2 |
1097715 | 1097715 | 2021-03-07 | Divide | North Dakota | 38023 | 166 | 2 |
1094467 | 1094467 | 2021-03-06 | Divide | North Dakota | 38023 | 166 | 2 |
1091221 | 1091221 | 2021-03-05 | Divide | North Dakota | 38023 | 166 | 2 |
1087976 | 1087976 | 2021-03-04 | Divide | North Dakota | 38023 | 164 | 2 |
1084731 | 1084731 | 2021-03-03 | Divide | North Dakota | 38023 | 163 | 2 |
1081485 | 1081485 | 2021-03-02 | Divide | North Dakota | 38023 | 161 | 2 |
1078239 | 1078239 | 2021-03-01 | Divide | North Dakota | 38023 | 159 | 2 |
1074994 | 1074994 | 2021-02-28 | Divide | North Dakota | 38023 | 159 | 2 |
1071748 | 1071748 | 2021-02-27 | Divide | North Dakota | 38023 | 159 | 2 |
1068502 | 1068502 | 2021-02-26 | Divide | North Dakota | 38023 | 158 | 2 |
1065257 | 1065257 | 2021-02-25 | Divide | North Dakota | 38023 | 157 | 2 |
1062013 | 1062013 | 2021-02-24 | Divide | North Dakota | 38023 | 157 | 2 |
1058767 | 1058767 | 2021-02-23 | Divide | North Dakota | 38023 | 156 | 2 |
1055521 | 1055521 | 2021-02-22 | Divide | North Dakota | 38023 | 154 | 2 |
1052275 | 1052275 | 2021-02-21 | Divide | North Dakota | 38023 | 153 | 2 |
1049028 | 1049028 | 2021-02-20 | Divide | North Dakota | 38023 | 152 | 2 |
1045781 | 1045781 | 2021-02-19 | Divide | North Dakota | 38023 | 151 | 2 |
1042536 | 1042536 | 2021-02-18 | Divide | North Dakota | 38023 | 151 | 2 |
1039291 | 1039291 | 2021-02-17 | Divide | North Dakota | 38023 | 150 | 2 |
1036046 | 1036046 | 2021-02-16 | Divide | North Dakota | 38023 | 148 | 2 |
1032801 | 1032801 | 2021-02-15 | Divide | North Dakota | 38023 | 147 | 2 |
1029555 | 1029555 | 2021-02-14 | Divide | North Dakota | 38023 | 147 | 2 |
1026308 | 1026308 | 2021-02-13 | Divide | North Dakota | 38023 | 147 | 2 |
1023063 | 1023063 | 2021-02-12 | Divide | North Dakota | 38023 | 147 | 2 |
1019818 | 1019818 | 2021-02-11 | Divide | North Dakota | 38023 | 147 | 2 |
1016573 | 1016573 | 2021-02-10 | Divide | North Dakota | 38023 | 147 | 2 |
1013328 | 1013328 | 2021-02-09 | Divide | North Dakota | 38023 | 148 | 2 |
1010083 | 1010083 | 2021-02-08 | Divide | North Dakota | 38023 | 148 | 2 |
1006837 | 1006837 | 2021-02-07 | Divide | North Dakota | 38023 | 148 | 2 |
1003591 | 1003591 | 2021-02-06 | Divide | North Dakota | 38023 | 148 | 2 |
1000345 | 1000345 | 2021-02-05 | Divide | North Dakota | 38023 | 148 | 2 |
997099 | 997099 | 2021-02-04 | Divide | North Dakota | 38023 | 148 | 2 |
993853 | 993853 | 2021-02-03 | Divide | North Dakota | 38023 | 148 | 2 |
990607 | 990607 | 2021-02-02 | Divide | North Dakota | 38023 | 147 | 2 |
987361 | 987361 | 2021-02-01 | Divide | North Dakota | 38023 | 147 | 2 |
984114 | 984114 | 2021-01-31 | Divide | North Dakota | 38023 | 147 | 2 |
980867 | 980867 | 2021-01-30 | Divide | North Dakota | 38023 | 147 | 2 |
977621 | 977621 | 2021-01-29 | Divide | North Dakota | 38023 | 147 | 2 |
974376 | 974376 | 2021-01-28 | Divide | North Dakota | 38023 | 147 | 2 |
971131 | 971131 | 2021-01-27 | Divide | North Dakota | 38023 | 147 | 2 |
967886 | 967886 | 2021-01-26 | Divide | North Dakota | 38023 | 147 | 2 |
964642 | 964642 | 2021-01-25 | Divide | North Dakota | 38023 | 147 | 2 |
961397 | 961397 | 2021-01-24 | Divide | North Dakota | 38023 | 147 | 2 |
958152 | 958152 | 2021-01-23 | Divide | North Dakota | 38023 | 147 | 2 |
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);