ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where county = "McLean" and deaths = 30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- North Dakota 119
- Kentucky 15
- Illinois 5
county 1
- McLean · 139 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1713728 | 1713728 | 2021-09-13 | McLean | Kentucky | 21149 | 1243 | 30 |
1710481 | 1710481 | 2021-09-12 | McLean | Kentucky | 21149 | 1223 | 30 |
1707234 | 1707234 | 2021-09-11 | McLean | Kentucky | 21149 | 1223 | 30 |
1703986 | 1703986 | 2021-09-10 | McLean | Kentucky | 21149 | 1223 | 30 |
1700736 | 1700736 | 2021-09-09 | McLean | Kentucky | 21149 | 1210 | 30 |
1697487 | 1697487 | 2021-09-08 | McLean | Kentucky | 21149 | 1202 | 30 |
1694239 | 1694239 | 2021-09-07 | McLean | Kentucky | 21149 | 1195 | 30 |
1690990 | 1690990 | 2021-09-06 | McLean | Kentucky | 21149 | 1182 | 30 |
1687740 | 1687740 | 2021-09-05 | McLean | Kentucky | 21149 | 1182 | 30 |
1684490 | 1684490 | 2021-09-04 | McLean | Kentucky | 21149 | 1182 | 30 |
1681239 | 1681239 | 2021-09-03 | McLean | Kentucky | 21149 | 1182 | 30 |
1677991 | 1677991 | 2021-09-02 | McLean | Kentucky | 21149 | 1172 | 30 |
1674744 | 1674744 | 2021-09-01 | McLean | Kentucky | 21149 | 1162 | 30 |
1671495 | 1671495 | 2021-08-31 | McLean | Kentucky | 21149 | 1154 | 30 |
1668248 | 1668248 | 2021-08-30 | McLean | Kentucky | 21149 | 1146 | 30 |
1448372 | 1448372 | 2021-06-23 | McLean | North Dakota | 38055 | 1292 | 30 |
1445127 | 1445127 | 2021-06-22 | McLean | North Dakota | 38055 | 1292 | 30 |
1441882 | 1441882 | 2021-06-21 | McLean | North Dakota | 38055 | 1292 | 30 |
1438637 | 1438637 | 2021-06-20 | McLean | North Dakota | 38055 | 1292 | 30 |
1435390 | 1435390 | 2021-06-19 | McLean | North Dakota | 38055 | 1292 | 30 |
1432143 | 1432143 | 2021-06-18 | McLean | North Dakota | 38055 | 1292 | 30 |
1428897 | 1428897 | 2021-06-17 | McLean | North Dakota | 38055 | 1291 | 30 |
1425652 | 1425652 | 2021-06-16 | McLean | North Dakota | 38055 | 1291 | 30 |
1422405 | 1422405 | 2021-06-15 | McLean | North Dakota | 38055 | 1291 | 30 |
1419159 | 1419159 | 2021-06-14 | McLean | North Dakota | 38055 | 1290 | 30 |
1415914 | 1415914 | 2021-06-13 | McLean | North Dakota | 38055 | 1289 | 30 |
1412668 | 1412668 | 2021-06-12 | McLean | North Dakota | 38055 | 1289 | 30 |
1409423 | 1409423 | 2021-06-11 | McLean | North Dakota | 38055 | 1289 | 30 |
1406178 | 1406178 | 2021-06-10 | McLean | North Dakota | 38055 | 1289 | 30 |
1402932 | 1402932 | 2021-06-09 | McLean | North Dakota | 38055 | 1289 | 30 |
1399687 | 1399687 | 2021-06-08 | McLean | North Dakota | 38055 | 1288 | 30 |
1396442 | 1396442 | 2021-06-07 | McLean | North Dakota | 38055 | 1287 | 30 |
1393195 | 1393195 | 2021-06-06 | McLean | North Dakota | 38055 | 1287 | 30 |
1389950 | 1389950 | 2021-06-05 | McLean | North Dakota | 38055 | 1286 | 30 |
1386705 | 1386705 | 2021-06-04 | McLean | North Dakota | 38055 | 1286 | 30 |
1383460 | 1383460 | 2021-06-03 | McLean | North Dakota | 38055 | 1285 | 30 |
1380214 | 1380214 | 2021-06-02 | McLean | North Dakota | 38055 | 1285 | 30 |
1376969 | 1376969 | 2021-06-01 | McLean | North Dakota | 38055 | 1284 | 30 |
1373723 | 1373723 | 2021-05-31 | McLean | North Dakota | 38055 | 1284 | 30 |
1370478 | 1370478 | 2021-05-30 | McLean | North Dakota | 38055 | 1284 | 30 |
1367232 | 1367232 | 2021-05-29 | McLean | North Dakota | 38055 | 1284 | 30 |
1363986 | 1363986 | 2021-05-28 | McLean | North Dakota | 38055 | 1284 | 30 |
1360740 | 1360740 | 2021-05-27 | McLean | North Dakota | 38055 | 1284 | 30 |
1357494 | 1357494 | 2021-05-26 | McLean | North Dakota | 38055 | 1284 | 30 |
1354248 | 1354248 | 2021-05-25 | McLean | North Dakota | 38055 | 1284 | 30 |
1351002 | 1351002 | 2021-05-24 | McLean | North Dakota | 38055 | 1283 | 30 |
1347756 | 1347756 | 2021-05-23 | McLean | North Dakota | 38055 | 1282 | 30 |
1344508 | 1344508 | 2021-05-22 | McLean | North Dakota | 38055 | 1283 | 30 |
1341260 | 1341260 | 2021-05-21 | McLean | North Dakota | 38055 | 1283 | 30 |
1338012 | 1338012 | 2021-05-20 | McLean | North Dakota | 38055 | 1283 | 30 |
1334765 | 1334765 | 2021-05-19 | McLean | North Dakota | 38055 | 1281 | 30 |
1331518 | 1331518 | 2021-05-18 | McLean | North Dakota | 38055 | 1279 | 30 |
1328271 | 1328271 | 2021-05-17 | McLean | North Dakota | 38055 | 1277 | 30 |
1325025 | 1325025 | 2021-05-16 | McLean | North Dakota | 38055 | 1277 | 30 |
1321779 | 1321779 | 2021-05-15 | McLean | North Dakota | 38055 | 1275 | 30 |
1318533 | 1318533 | 2021-05-14 | McLean | North Dakota | 38055 | 1274 | 30 |
1315285 | 1315285 | 2021-05-13 | McLean | North Dakota | 38055 | 1274 | 30 |
1312039 | 1312039 | 2021-05-12 | McLean | North Dakota | 38055 | 1273 | 30 |
1308792 | 1308792 | 2021-05-11 | McLean | North Dakota | 38055 | 1273 | 30 |
1305546 | 1305546 | 2021-05-10 | McLean | North Dakota | 38055 | 1271 | 30 |
1302300 | 1302300 | 2021-05-09 | McLean | North Dakota | 38055 | 1269 | 30 |
1299052 | 1299052 | 2021-05-08 | McLean | North Dakota | 38055 | 1269 | 30 |
1295806 | 1295806 | 2021-05-07 | McLean | North Dakota | 38055 | 1268 | 30 |
1292560 | 1292560 | 2021-05-06 | McLean | North Dakota | 38055 | 1268 | 30 |
1289314 | 1289314 | 2021-05-05 | McLean | North Dakota | 38055 | 1268 | 30 |
1286068 | 1286068 | 2021-05-04 | McLean | North Dakota | 38055 | 1267 | 30 |
1282822 | 1282822 | 2021-05-03 | McLean | North Dakota | 38055 | 1266 | 30 |
1279575 | 1279575 | 2021-05-02 | McLean | North Dakota | 38055 | 1266 | 30 |
1276328 | 1276328 | 2021-05-01 | McLean | North Dakota | 38055 | 1264 | 30 |
1273081 | 1273081 | 2021-04-30 | McLean | North Dakota | 38055 | 1263 | 30 |
1269834 | 1269834 | 2021-04-29 | McLean | North Dakota | 38055 | 1262 | 30 |
1266587 | 1266587 | 2021-04-28 | McLean | North Dakota | 38055 | 1261 | 30 |
1263340 | 1263340 | 2021-04-27 | McLean | North Dakota | 38055 | 1261 | 30 |
1260093 | 1260093 | 2021-04-26 | McLean | North Dakota | 38055 | 1261 | 30 |
1256846 | 1256846 | 2021-04-25 | McLean | North Dakota | 38055 | 1261 | 30 |
1253599 | 1253599 | 2021-04-24 | McLean | North Dakota | 38055 | 1261 | 30 |
1250352 | 1250352 | 2021-04-23 | McLean | North Dakota | 38055 | 1261 | 30 |
1247105 | 1247105 | 2021-04-22 | McLean | North Dakota | 38055 | 1260 | 30 |
1243858 | 1243858 | 2021-04-21 | McLean | North Dakota | 38055 | 1255 | 30 |
1240611 | 1240611 | 2021-04-20 | McLean | North Dakota | 38055 | 1253 | 30 |
1237364 | 1237364 | 2021-04-19 | McLean | North Dakota | 38055 | 1253 | 30 |
1234117 | 1234117 | 2021-04-18 | McLean | North Dakota | 38055 | 1253 | 30 |
1230869 | 1230869 | 2021-04-17 | McLean | North Dakota | 38055 | 1253 | 30 |
1227621 | 1227621 | 2021-04-16 | McLean | North Dakota | 38055 | 1252 | 30 |
1224373 | 1224373 | 2021-04-15 | McLean | North Dakota | 38055 | 1252 | 30 |
1221126 | 1221126 | 2021-04-14 | McLean | North Dakota | 38055 | 1251 | 30 |
1217878 | 1217878 | 2021-04-13 | McLean | North Dakota | 38055 | 1251 | 30 |
1214630 | 1214630 | 2021-04-12 | McLean | North Dakota | 38055 | 1249 | 30 |
1211383 | 1211383 | 2021-04-11 | McLean | North Dakota | 38055 | 1247 | 30 |
1208134 | 1208134 | 2021-04-10 | McLean | North Dakota | 38055 | 1247 | 30 |
1204886 | 1204886 | 2021-04-09 | McLean | North Dakota | 38055 | 1246 | 30 |
1201638 | 1201638 | 2021-04-08 | McLean | North Dakota | 38055 | 1244 | 30 |
1198389 | 1198389 | 2021-04-07 | McLean | North Dakota | 38055 | 1243 | 30 |
1195140 | 1195140 | 2021-04-06 | McLean | North Dakota | 38055 | 1243 | 30 |
1191892 | 1191892 | 2021-04-05 | McLean | North Dakota | 38055 | 1243 | 30 |
1188643 | 1188643 | 2021-04-04 | McLean | North Dakota | 38055 | 1243 | 30 |
1185396 | 1185396 | 2021-04-03 | McLean | North Dakota | 38055 | 1241 | 30 |
1182149 | 1182149 | 2021-04-02 | McLean | North Dakota | 38055 | 1241 | 30 |
1178902 | 1178902 | 2021-04-01 | McLean | North Dakota | 38055 | 1240 | 30 |
1175655 | 1175655 | 2021-03-31 | McLean | North Dakota | 38055 | 1239 | 30 |
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);