ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where county = "McLean", deaths = 31 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 |
---|---|---|---|---|---|---|---|
1578241 | 1578241 | 2021-08-02 | McLean | North Dakota | 38055 | 1314 | 31 |
1574993 | 1574993 | 2021-08-01 | McLean | North Dakota | 38055 | 1314 | 31 |
1571745 | 1571745 | 2021-07-31 | McLean | North Dakota | 38055 | 1314 | 31 |
1568497 | 1568497 | 2021-07-30 | McLean | North Dakota | 38055 | 1314 | 31 |
1565249 | 1565249 | 2021-07-29 | McLean | North Dakota | 38055 | 1310 | 31 |
1562001 | 1562001 | 2021-07-28 | McLean | North Dakota | 38055 | 1305 | 31 |
1558753 | 1558753 | 2021-07-27 | McLean | North Dakota | 38055 | 1304 | 31 |
1555506 | 1555506 | 2021-07-26 | McLean | North Dakota | 38055 | 1305 | 31 |
1552259 | 1552259 | 2021-07-25 | McLean | North Dakota | 38055 | 1304 | 31 |
1549012 | 1549012 | 2021-07-24 | McLean | North Dakota | 38055 | 1303 | 31 |
1545765 | 1545765 | 2021-07-23 | McLean | North Dakota | 38055 | 1302 | 31 |
1542518 | 1542518 | 2021-07-22 | McLean | North Dakota | 38055 | 1300 | 31 |
1539270 | 1539270 | 2021-07-21 | McLean | North Dakota | 38055 | 1298 | 31 |
1536023 | 1536023 | 2021-07-20 | McLean | North Dakota | 38055 | 1297 | 31 |
1532775 | 1532775 | 2021-07-19 | McLean | North Dakota | 38055 | 1298 | 31 |
1529528 | 1529528 | 2021-07-18 | McLean | North Dakota | 38055 | 1298 | 31 |
1526281 | 1526281 | 2021-07-17 | McLean | North Dakota | 38055 | 1297 | 31 |
1523034 | 1523034 | 2021-07-16 | McLean | North Dakota | 38055 | 1297 | 31 |
1519786 | 1519786 | 2021-07-15 | McLean | North Dakota | 38055 | 1297 | 31 |
1516538 | 1516538 | 2021-07-14 | McLean | North Dakota | 38055 | 1296 | 31 |
1513291 | 1513291 | 2021-07-13 | McLean | North Dakota | 38055 | 1295 | 31 |
1510045 | 1510045 | 2021-07-12 | McLean | North Dakota | 38055 | 1295 | 31 |
1506798 | 1506798 | 2021-07-11 | McLean | North Dakota | 38055 | 1295 | 31 |
1503552 | 1503552 | 2021-07-10 | McLean | North Dakota | 38055 | 1295 | 31 |
1500306 | 1500306 | 2021-07-09 | McLean | North Dakota | 38055 | 1295 | 31 |
1497060 | 1497060 | 2021-07-08 | McLean | North Dakota | 38055 | 1295 | 31 |
1493813 | 1493813 | 2021-07-07 | McLean | North Dakota | 38055 | 1295 | 31 |
1490566 | 1490566 | 2021-07-06 | McLean | North Dakota | 38055 | 1294 | 31 |
1487319 | 1487319 | 2021-07-05 | McLean | North Dakota | 38055 | 1294 | 31 |
1484073 | 1484073 | 2021-07-04 | McLean | North Dakota | 38055 | 1293 | 31 |
1480827 | 1480827 | 2021-07-03 | McLean | North Dakota | 38055 | 1293 | 31 |
1477580 | 1477580 | 2021-07-02 | McLean | North Dakota | 38055 | 1293 | 31 |
1474334 | 1474334 | 2021-07-01 | McLean | North Dakota | 38055 | 1293 | 31 |
1471088 | 1471088 | 2021-06-30 | McLean | North Dakota | 38055 | 1293 | 31 |
1467843 | 1467843 | 2021-06-29 | McLean | North Dakota | 38055 | 1293 | 31 |
1464598 | 1464598 | 2021-06-28 | McLean | North Dakota | 38055 | 1293 | 31 |
1461353 | 1461353 | 2021-06-27 | McLean | North Dakota | 38055 | 1292 | 31 |
1458108 | 1458108 | 2021-06-26 | McLean | North Dakota | 38055 | 1292 | 31 |
1454863 | 1454863 | 2021-06-25 | McLean | North Dakota | 38055 | 1292 | 31 |
1451618 | 1451618 | 2021-06-24 | McLean | North Dakota | 38055 | 1292 | 31 |
1104223 | 1104223 | 2021-03-09 | McLean | North Dakota | 38055 | 1216 | 31 |
1100977 | 1100977 | 2021-03-08 | McLean | North Dakota | 38055 | 1216 | 31 |
1097731 | 1097731 | 2021-03-07 | McLean | North Dakota | 38055 | 1216 | 31 |
1094483 | 1094483 | 2021-03-06 | McLean | North Dakota | 38055 | 1216 | 31 |
1091237 | 1091237 | 2021-03-05 | McLean | North Dakota | 38055 | 1215 | 31 |
1087992 | 1087992 | 2021-03-04 | McLean | North Dakota | 38055 | 1212 | 31 |
1084747 | 1084747 | 2021-03-03 | McLean | North Dakota | 38055 | 1212 | 31 |
1081501 | 1081501 | 2021-03-02 | McLean | North Dakota | 38055 | 1212 | 31 |
1078255 | 1078255 | 2021-03-01 | McLean | North Dakota | 38055 | 1212 | 31 |
1075010 | 1075010 | 2021-02-28 | McLean | North Dakota | 38055 | 1212 | 31 |
1071764 | 1071764 | 2021-02-27 | McLean | North Dakota | 38055 | 1210 | 31 |
1068518 | 1068518 | 2021-02-26 | McLean | North Dakota | 38055 | 1209 | 31 |
1065273 | 1065273 | 2021-02-25 | McLean | North Dakota | 38055 | 1206 | 31 |
1062029 | 1062029 | 2021-02-24 | McLean | North Dakota | 38055 | 1206 | 31 |
1058783 | 1058783 | 2021-02-23 | McLean | North Dakota | 38055 | 1205 | 31 |
1055537 | 1055537 | 2021-02-22 | McLean | North Dakota | 38055 | 1205 | 31 |
1052291 | 1052291 | 2021-02-21 | McLean | North Dakota | 38055 | 1205 | 31 |
1049044 | 1049044 | 2021-02-20 | McLean | North Dakota | 38055 | 1205 | 31 |
1045797 | 1045797 | 2021-02-19 | McLean | North Dakota | 38055 | 1205 | 31 |
1042552 | 1042552 | 2021-02-18 | McLean | North Dakota | 38055 | 1201 | 31 |
1039307 | 1039307 | 2021-02-17 | McLean | North Dakota | 38055 | 1200 | 31 |
1036062 | 1036062 | 2021-02-16 | McLean | North Dakota | 38055 | 1199 | 31 |
1032817 | 1032817 | 2021-02-15 | McLean | North Dakota | 38055 | 1198 | 31 |
1029571 | 1029571 | 2021-02-14 | McLean | North Dakota | 38055 | 1197 | 31 |
1026324 | 1026324 | 2021-02-13 | McLean | North Dakota | 38055 | 1197 | 31 |
1023079 | 1023079 | 2021-02-12 | McLean | North Dakota | 38055 | 1196 | 31 |
1019834 | 1019834 | 2021-02-11 | McLean | North Dakota | 38055 | 1192 | 31 |
1016589 | 1016589 | 2021-02-10 | McLean | North Dakota | 38055 | 1188 | 31 |
1013344 | 1013344 | 2021-02-09 | McLean | North Dakota | 38055 | 1189 | 31 |
1010099 | 1010099 | 2021-02-08 | McLean | North Dakota | 38055 | 1183 | 31 |
1006853 | 1006853 | 2021-02-07 | McLean | North Dakota | 38055 | 1183 | 31 |
1003607 | 1003607 | 2021-02-06 | McLean | North Dakota | 38055 | 1183 | 31 |
1000361 | 1000361 | 2021-02-05 | McLean | North Dakota | 38055 | 1183 | 31 |
997115 | 997115 | 2021-02-04 | McLean | North Dakota | 38055 | 1182 | 31 |
993869 | 993869 | 2021-02-03 | McLean | North Dakota | 38055 | 1180 | 31 |
990623 | 990623 | 2021-02-02 | McLean | North Dakota | 38055 | 1174 | 31 |
987377 | 987377 | 2021-02-01 | McLean | North Dakota | 38055 | 1174 | 31 |
984130 | 984130 | 2021-01-31 | McLean | North Dakota | 38055 | 1174 | 31 |
980883 | 980883 | 2021-01-30 | McLean | North Dakota | 38055 | 1174 | 31 |
977637 | 977637 | 2021-01-29 | McLean | North Dakota | 38055 | 1174 | 31 |
974392 | 974392 | 2021-01-28 | McLean | North Dakota | 38055 | 1173 | 31 |
971147 | 971147 | 2021-01-27 | McLean | North Dakota | 38055 | 1167 | 31 |
967902 | 967902 | 2021-01-26 | McLean | North Dakota | 38055 | 1166 | 31 |
964658 | 964658 | 2021-01-25 | McLean | North Dakota | 38055 | 1164 | 31 |
961413 | 961413 | 2021-01-24 | McLean | North Dakota | 38055 | 1162 | 31 |
958168 | 958168 | 2021-01-23 | McLean | North Dakota | 38055 | 1161 | 31 |
954922 | 954922 | 2021-01-22 | McLean | North Dakota | 38055 | 1162 | 31 |
951677 | 951677 | 2021-01-21 | McLean | North Dakota | 38055 | 1161 | 31 |
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);