ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "McKenzie" 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 |
---|---|---|---|---|---|---|---|
1279574 | 1279574 | 2021-05-02 | McKenzie | North Dakota | 38053 | 1289 | 12 |
1276327 | 1276327 | 2021-05-01 | McKenzie | North Dakota | 38053 | 1283 | 12 |
1273080 | 1273080 | 2021-04-30 | McKenzie | North Dakota | 38053 | 1280 | 12 |
1269833 | 1269833 | 2021-04-29 | McKenzie | North Dakota | 38053 | 1278 | 12 |
1266586 | 1266586 | 2021-04-28 | McKenzie | North Dakota | 38053 | 1275 | 12 |
1263339 | 1263339 | 2021-04-27 | McKenzie | North Dakota | 38053 | 1268 | 12 |
1260092 | 1260092 | 2021-04-26 | McKenzie | North Dakota | 38053 | 1259 | 12 |
1256845 | 1256845 | 2021-04-25 | McKenzie | North Dakota | 38053 | 1255 | 12 |
1253598 | 1253598 | 2021-04-24 | McKenzie | North Dakota | 38053 | 1255 | 12 |
1250351 | 1250351 | 2021-04-23 | McKenzie | North Dakota | 38053 | 1253 | 12 |
1247104 | 1247104 | 2021-04-22 | McKenzie | North Dakota | 38053 | 1250 | 12 |
1243857 | 1243857 | 2021-04-21 | McKenzie | North Dakota | 38053 | 1246 | 12 |
1240610 | 1240610 | 2021-04-20 | McKenzie | North Dakota | 38053 | 1244 | 12 |
1237363 | 1237363 | 2021-04-19 | McKenzie | North Dakota | 38053 | 1237 | 12 |
1234116 | 1234116 | 2021-04-18 | McKenzie | North Dakota | 38053 | 1233 | 12 |
1230868 | 1230868 | 2021-04-17 | McKenzie | North Dakota | 38053 | 1233 | 12 |
1227620 | 1227620 | 2021-04-16 | McKenzie | North Dakota | 38053 | 1231 | 12 |
1224372 | 1224372 | 2021-04-15 | McKenzie | North Dakota | 38053 | 1227 | 12 |
1221125 | 1221125 | 2021-04-14 | McKenzie | North Dakota | 38053 | 1224 | 12 |
1217877 | 1217877 | 2021-04-13 | McKenzie | North Dakota | 38053 | 1219 | 12 |
1214629 | 1214629 | 2021-04-12 | McKenzie | North Dakota | 38053 | 1217 | 12 |
1211382 | 1211382 | 2021-04-11 | McKenzie | North Dakota | 38053 | 1217 | 12 |
1208133 | 1208133 | 2021-04-10 | McKenzie | North Dakota | 38053 | 1217 | 12 |
1204885 | 1204885 | 2021-04-09 | McKenzie | North Dakota | 38053 | 1215 | 12 |
1201637 | 1201637 | 2021-04-08 | McKenzie | North Dakota | 38053 | 1213 | 12 |
1198388 | 1198388 | 2021-04-07 | McKenzie | North Dakota | 38053 | 1210 | 12 |
1195139 | 1195139 | 2021-04-06 | McKenzie | North Dakota | 38053 | 1206 | 12 |
1191891 | 1191891 | 2021-04-05 | McKenzie | North Dakota | 38053 | 1205 | 12 |
1188642 | 1188642 | 2021-04-04 | McKenzie | North Dakota | 38053 | 1205 | 12 |
1185395 | 1185395 | 2021-04-03 | McKenzie | North Dakota | 38053 | 1205 | 12 |
1182148 | 1182148 | 2021-04-02 | McKenzie | North Dakota | 38053 | 1204 | 12 |
1178901 | 1178901 | 2021-04-01 | McKenzie | North Dakota | 38053 | 1202 | 12 |
1175654 | 1175654 | 2021-03-31 | McKenzie | North Dakota | 38053 | 1200 | 12 |
1172407 | 1172407 | 2021-03-30 | McKenzie | North Dakota | 38053 | 1198 | 12 |
1169160 | 1169160 | 2021-03-29 | McKenzie | North Dakota | 38053 | 1199 | 12 |
1165912 | 1165912 | 2021-03-28 | McKenzie | North Dakota | 38053 | 1197 | 12 |
1162664 | 1162664 | 2021-03-27 | McKenzie | North Dakota | 38053 | 1194 | 12 |
1159415 | 1159415 | 2021-03-26 | McKenzie | North Dakota | 38053 | 1191 | 12 |
1156168 | 1156168 | 2021-03-25 | McKenzie | North Dakota | 38053 | 1188 | 12 |
1152921 | 1152921 | 2021-03-24 | McKenzie | North Dakota | 38053 | 1185 | 12 |
1149674 | 1149674 | 2021-03-23 | McKenzie | North Dakota | 38053 | 1184 | 12 |
1146427 | 1146427 | 2021-03-22 | McKenzie | North Dakota | 38053 | 1183 | 12 |
1143180 | 1143180 | 2021-03-21 | McKenzie | North Dakota | 38053 | 1182 | 12 |
1139933 | 1139933 | 2021-03-20 | McKenzie | North Dakota | 38053 | 1180 | 12 |
1136687 | 1136687 | 2021-03-19 | McKenzie | North Dakota | 38053 | 1180 | 12 |
1133441 | 1133441 | 2021-03-18 | McKenzie | North Dakota | 38053 | 1180 | 12 |
1130193 | 1130193 | 2021-03-17 | McKenzie | North Dakota | 38053 | 1178 | 12 |
1126946 | 1126946 | 2021-03-16 | McKenzie | North Dakota | 38053 | 1176 | 12 |
1123700 | 1123700 | 2021-03-15 | McKenzie | North Dakota | 38053 | 1175 | 12 |
1120454 | 1120454 | 2021-03-14 | McKenzie | North Dakota | 38053 | 1174 | 12 |
1117207 | 1117207 | 2021-03-13 | McKenzie | North Dakota | 38053 | 1174 | 12 |
1113960 | 1113960 | 2021-03-12 | McKenzie | North Dakota | 38053 | 1173 | 12 |
1110714 | 1110714 | 2021-03-11 | McKenzie | North Dakota | 38053 | 1173 | 12 |
1107468 | 1107468 | 2021-03-10 | McKenzie | North Dakota | 38053 | 1173 | 12 |
1104222 | 1104222 | 2021-03-09 | McKenzie | North Dakota | 38053 | 1170 | 12 |
1100976 | 1100976 | 2021-03-08 | McKenzie | North Dakota | 38053 | 1167 | 12 |
1097730 | 1097730 | 2021-03-07 | McKenzie | North Dakota | 38053 | 1167 | 12 |
1094482 | 1094482 | 2021-03-06 | McKenzie | North Dakota | 38053 | 1167 | 12 |
1091236 | 1091236 | 2021-03-05 | McKenzie | North Dakota | 38053 | 1166 | 12 |
1087991 | 1087991 | 2021-03-04 | McKenzie | North Dakota | 38053 | 1166 | 12 |
1084746 | 1084746 | 2021-03-03 | McKenzie | North Dakota | 38053 | 1166 | 12 |
1081500 | 1081500 | 2021-03-02 | McKenzie | North Dakota | 38053 | 1163 | 12 |
1078254 | 1078254 | 2021-03-01 | McKenzie | North Dakota | 38053 | 1159 | 12 |
1075009 | 1075009 | 2021-02-28 | McKenzie | North Dakota | 38053 | 1159 | 12 |
1071763 | 1071763 | 2021-02-27 | McKenzie | North Dakota | 38053 | 1159 | 12 |
1068517 | 1068517 | 2021-02-26 | McKenzie | North Dakota | 38053 | 1159 | 11 |
1065272 | 1065272 | 2021-02-25 | McKenzie | North Dakota | 38053 | 1159 | 11 |
1062028 | 1062028 | 2021-02-24 | McKenzie | North Dakota | 38053 | 1159 | 11 |
1058782 | 1058782 | 2021-02-23 | McKenzie | North Dakota | 38053 | 1158 | 11 |
1055536 | 1055536 | 2021-02-22 | McKenzie | North Dakota | 38053 | 1156 | 11 |
1052290 | 1052290 | 2021-02-21 | McKenzie | North Dakota | 38053 | 1155 | 11 |
1049043 | 1049043 | 2021-02-20 | McKenzie | North Dakota | 38053 | 1155 | 11 |
1045796 | 1045796 | 2021-02-19 | McKenzie | North Dakota | 38053 | 1152 | 11 |
1042551 | 1042551 | 2021-02-18 | McKenzie | North Dakota | 38053 | 1150 | 11 |
1039306 | 1039306 | 2021-02-17 | McKenzie | North Dakota | 38053 | 1150 | 11 |
1036061 | 1036061 | 2021-02-16 | McKenzie | North Dakota | 38053 | 1149 | 11 |
1032816 | 1032816 | 2021-02-15 | McKenzie | North Dakota | 38053 | 1146 | 11 |
1029570 | 1029570 | 2021-02-14 | McKenzie | North Dakota | 38053 | 1146 | 11 |
1026323 | 1026323 | 2021-02-13 | McKenzie | North Dakota | 38053 | 1145 | 11 |
1023078 | 1023078 | 2021-02-12 | McKenzie | North Dakota | 38053 | 1144 | 11 |
1019833 | 1019833 | 2021-02-11 | McKenzie | North Dakota | 38053 | 1142 | 11 |
1016588 | 1016588 | 2021-02-10 | McKenzie | North Dakota | 38053 | 1141 | 11 |
1013343 | 1013343 | 2021-02-09 | McKenzie | North Dakota | 38053 | 1142 | 11 |
1010098 | 1010098 | 2021-02-08 | McKenzie | North Dakota | 38053 | 1142 | 11 |
1006852 | 1006852 | 2021-02-07 | McKenzie | North Dakota | 38053 | 1141 | 11 |
1003606 | 1003606 | 2021-02-06 | McKenzie | North Dakota | 38053 | 1141 | 11 |
1000360 | 1000360 | 2021-02-05 | McKenzie | North Dakota | 38053 | 1141 | 11 |
997114 | 997114 | 2021-02-04 | McKenzie | North Dakota | 38053 | 1139 | 11 |
993868 | 993868 | 2021-02-03 | McKenzie | North Dakota | 38053 | 1138 | 11 |
990622 | 990622 | 2021-02-02 | McKenzie | North Dakota | 38053 | 1135 | 11 |
987376 | 987376 | 2021-02-01 | McKenzie | North Dakota | 38053 | 1133 | 11 |
984129 | 984129 | 2021-01-31 | McKenzie | North Dakota | 38053 | 1133 | 11 |
980882 | 980882 | 2021-01-30 | McKenzie | North Dakota | 38053 | 1131 | 11 |
977636 | 977636 | 2021-01-29 | McKenzie | North Dakota | 38053 | 1129 | 11 |
974391 | 974391 | 2021-01-28 | McKenzie | North Dakota | 38053 | 1126 | 11 |
971146 | 971146 | 2021-01-27 | McKenzie | North Dakota | 38053 | 1123 | 11 |
967901 | 967901 | 2021-01-26 | McKenzie | North Dakota | 38053 | 1120 | 11 |
964657 | 964657 | 2021-01-25 | McKenzie | North Dakota | 38053 | 1116 | 11 |
961412 | 961412 | 2021-01-24 | McKenzie | North Dakota | 38053 | 1116 | 11 |
958167 | 958167 | 2021-01-23 | McKenzie | North Dakota | 38053 | 1114 | 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);