ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marquette" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420318 | 1420318 | 2021-06-14 | Marquette | Wisconsin | 55077 | 1603 | 28 |
1417073 | 1417073 | 2021-06-13 | Marquette | Wisconsin | 55077 | 1598 | 28 |
1413827 | 1413827 | 2021-06-12 | Marquette | Wisconsin | 55077 | 1598 | 28 |
1410582 | 1410582 | 2021-06-11 | Marquette | Wisconsin | 55077 | 1598 | 28 |
1407337 | 1407337 | 2021-06-10 | Marquette | Wisconsin | 55077 | 1598 | 28 |
1404091 | 1404091 | 2021-06-09 | Marquette | Wisconsin | 55077 | 1598 | 28 |
1400846 | 1400846 | 2021-06-08 | Marquette | Wisconsin | 55077 | 1596 | 28 |
1397601 | 1397601 | 2021-06-07 | Marquette | Wisconsin | 55077 | 1594 | 28 |
1394354 | 1394354 | 2021-06-06 | Marquette | Wisconsin | 55077 | 1590 | 28 |
1391109 | 1391109 | 2021-06-05 | Marquette | Wisconsin | 55077 | 1590 | 28 |
1387864 | 1387864 | 2021-06-04 | Marquette | Wisconsin | 55077 | 1590 | 28 |
1384619 | 1384619 | 2021-06-03 | Marquette | Wisconsin | 55077 | 1587 | 28 |
1381373 | 1381373 | 2021-06-02 | Marquette | Wisconsin | 55077 | 1584 | 28 |
1378128 | 1378128 | 2021-06-01 | Marquette | Wisconsin | 55077 | 1583 | 28 |
1374882 | 1374882 | 2021-05-31 | Marquette | Wisconsin | 55077 | 1583 | 28 |
1371637 | 1371637 | 2021-05-30 | Marquette | Wisconsin | 55077 | 1583 | 28 |
1368391 | 1368391 | 2021-05-29 | Marquette | Wisconsin | 55077 | 1583 | 28 |
1365145 | 1365145 | 2021-05-28 | Marquette | Wisconsin | 55077 | 1583 | 28 |
1361899 | 1361899 | 2021-05-27 | Marquette | Wisconsin | 55077 | 1581 | 28 |
1358653 | 1358653 | 2021-05-26 | Marquette | Wisconsin | 55077 | 1580 | 28 |
1355407 | 1355407 | 2021-05-25 | Marquette | Wisconsin | 55077 | 1578 | 28 |
1352161 | 1352161 | 2021-05-24 | Marquette | Wisconsin | 55077 | 1577 | 28 |
1348915 | 1348915 | 2021-05-23 | Marquette | Wisconsin | 55077 | 1576 | 28 |
1345667 | 1345667 | 2021-05-22 | Marquette | Wisconsin | 55077 | 1576 | 28 |
1342419 | 1342419 | 2021-05-21 | Marquette | Wisconsin | 55077 | 1576 | 28 |
1339171 | 1339171 | 2021-05-20 | Marquette | Wisconsin | 55077 | 1573 | 28 |
1335924 | 1335924 | 2021-05-19 | Marquette | Wisconsin | 55077 | 1568 | 28 |
1332677 | 1332677 | 2021-05-18 | Marquette | Wisconsin | 55077 | 1566 | 28 |
1329430 | 1329430 | 2021-05-17 | Marquette | Wisconsin | 55077 | 1565 | 28 |
1326184 | 1326184 | 2021-05-16 | Marquette | Wisconsin | 55077 | 1565 | 28 |
1322938 | 1322938 | 2021-05-15 | Marquette | Wisconsin | 55077 | 1565 | 28 |
1319692 | 1319692 | 2021-05-14 | Marquette | Wisconsin | 55077 | 1564 | 28 |
1316444 | 1316444 | 2021-05-13 | Marquette | Wisconsin | 55077 | 1563 | 28 |
1313198 | 1313198 | 2021-05-12 | Marquette | Wisconsin | 55077 | 1562 | 28 |
1309951 | 1309951 | 2021-05-11 | Marquette | Wisconsin | 55077 | 1562 | 28 |
1306705 | 1306705 | 2021-05-10 | Marquette | Wisconsin | 55077 | 1562 | 28 |
1303459 | 1303459 | 2021-05-09 | Marquette | Wisconsin | 55077 | 1562 | 28 |
1300212 | 1300212 | 2021-05-08 | Marquette | Wisconsin | 55077 | 1562 | 28 |
1296965 | 1296965 | 2021-05-07 | Marquette | Wisconsin | 55077 | 1559 | 28 |
1293719 | 1293719 | 2021-05-06 | Marquette | Wisconsin | 55077 | 1559 | 28 |
1290473 | 1290473 | 2021-05-05 | Marquette | Wisconsin | 55077 | 1559 | 28 |
1287227 | 1287227 | 2021-05-04 | Marquette | Wisconsin | 55077 | 1556 | 28 |
1283981 | 1283981 | 2021-05-03 | Marquette | Wisconsin | 55077 | 1556 | 27 |
1280734 | 1280734 | 2021-05-02 | Marquette | Wisconsin | 55077 | 1556 | 27 |
1277487 | 1277487 | 2021-05-01 | Marquette | Wisconsin | 55077 | 1555 | 27 |
1274240 | 1274240 | 2021-04-30 | Marquette | Wisconsin | 55077 | 1555 | 27 |
1270993 | 1270993 | 2021-04-29 | Marquette | Wisconsin | 55077 | 1554 | 27 |
1267746 | 1267746 | 2021-04-28 | Marquette | Wisconsin | 55077 | 1554 | 27 |
1264499 | 1264499 | 2021-04-27 | Marquette | Wisconsin | 55077 | 1552 | 27 |
1261252 | 1261252 | 2021-04-26 | Marquette | Wisconsin | 55077 | 1549 | 27 |
1258005 | 1258005 | 2021-04-25 | Marquette | Wisconsin | 55077 | 1548 | 27 |
1254758 | 1254758 | 2021-04-24 | Marquette | Wisconsin | 55077 | 1548 | 27 |
1251511 | 1251511 | 2021-04-23 | Marquette | Wisconsin | 55077 | 1547 | 27 |
1248264 | 1248264 | 2021-04-22 | Marquette | Wisconsin | 55077 | 1546 | 27 |
1245017 | 1245017 | 2021-04-21 | Marquette | Wisconsin | 55077 | 1545 | 27 |
1241770 | 1241770 | 2021-04-20 | Marquette | Wisconsin | 55077 | 1545 | 27 |
1238523 | 1238523 | 2021-04-19 | Marquette | Wisconsin | 55077 | 1545 | 27 |
1235276 | 1235276 | 2021-04-18 | Marquette | Wisconsin | 55077 | 1544 | 27 |
1232028 | 1232028 | 2021-04-17 | Marquette | Wisconsin | 55077 | 1543 | 27 |
1228780 | 1228780 | 2021-04-16 | Marquette | Wisconsin | 55077 | 1542 | 27 |
1225532 | 1225532 | 2021-04-15 | Marquette | Wisconsin | 55077 | 1541 | 27 |
1222285 | 1222285 | 2021-04-14 | Marquette | Wisconsin | 55077 | 1540 | 27 |
1219037 | 1219037 | 2021-04-13 | Marquette | Wisconsin | 55077 | 1539 | 27 |
1215789 | 1215789 | 2021-04-12 | Marquette | Wisconsin | 55077 | 1538 | 27 |
1212542 | 1212542 | 2021-04-11 | Marquette | Wisconsin | 55077 | 1535 | 27 |
1209293 | 1209293 | 2021-04-10 | Marquette | Wisconsin | 55077 | 1530 | 27 |
1206045 | 1206045 | 2021-04-09 | Marquette | Wisconsin | 55077 | 1529 | 27 |
1202797 | 1202797 | 2021-04-08 | Marquette | Wisconsin | 55077 | 1528 | 27 |
1199549 | 1199549 | 2021-04-07 | Marquette | Wisconsin | 55077 | 1525 | 27 |
1196300 | 1196300 | 2021-04-06 | Marquette | Wisconsin | 55077 | 1519 | 27 |
1193052 | 1193052 | 2021-04-05 | Marquette | Wisconsin | 55077 | 1517 | 27 |
1189802 | 1189802 | 2021-04-04 | Marquette | Wisconsin | 55077 | 1517 | 27 |
1186555 | 1186555 | 2021-04-03 | Marquette | Wisconsin | 55077 | 1517 | 27 |
1183308 | 1183308 | 2021-04-02 | Marquette | Wisconsin | 55077 | 1512 | 27 |
1180061 | 1180061 | 2021-04-01 | Marquette | Wisconsin | 55077 | 1511 | 27 |
1176814 | 1176814 | 2021-03-31 | Marquette | Wisconsin | 55077 | 1509 | 27 |
1173567 | 1173567 | 2021-03-30 | Marquette | Wisconsin | 55077 | 1509 | 27 |
1170320 | 1170320 | 2021-03-29 | Marquette | Wisconsin | 55077 | 1506 | 27 |
1167072 | 1167072 | 2021-03-28 | Marquette | Wisconsin | 55077 | 1506 | 27 |
1163824 | 1163824 | 2021-03-27 | Marquette | Wisconsin | 55077 | 1506 | 27 |
1160576 | 1160576 | 2021-03-26 | Marquette | Wisconsin | 55077 | 1506 | 27 |
1157328 | 1157328 | 2021-03-25 | Marquette | Wisconsin | 55077 | 1506 | 27 |
1154081 | 1154081 | 2021-03-24 | Marquette | Wisconsin | 55077 | 1505 | 27 |
1150834 | 1150834 | 2021-03-23 | Marquette | Wisconsin | 55077 | 1503 | 27 |
1147587 | 1147587 | 2021-03-22 | Marquette | Wisconsin | 55077 | 1503 | 27 |
1144340 | 1144340 | 2021-03-21 | Marquette | Wisconsin | 55077 | 1503 | 27 |
1141093 | 1141093 | 2021-03-20 | Marquette | Wisconsin | 55077 | 1503 | 27 |
1137847 | 1137847 | 2021-03-19 | Marquette | Wisconsin | 55077 | 1503 | 27 |
1134601 | 1134601 | 2021-03-18 | Marquette | Wisconsin | 55077 | 1502 | 27 |
1131353 | 1131353 | 2021-03-17 | Marquette | Wisconsin | 55077 | 1502 | 26 |
1128106 | 1128106 | 2021-03-16 | Marquette | Wisconsin | 55077 | 1502 | 26 |
1124860 | 1124860 | 2021-03-15 | Marquette | Wisconsin | 55077 | 1502 | 26 |
1121614 | 1121614 | 2021-03-14 | Marquette | Wisconsin | 55077 | 1502 | 26 |
1118367 | 1118367 | 2021-03-13 | Marquette | Wisconsin | 55077 | 1502 | 26 |
1115120 | 1115120 | 2021-03-12 | Marquette | Wisconsin | 55077 | 1501 | 26 |
1111874 | 1111874 | 2021-03-11 | Marquette | Wisconsin | 55077 | 1497 | 26 |
1108628 | 1108628 | 2021-03-10 | Marquette | Wisconsin | 55077 | 1494 | 26 |
1105382 | 1105382 | 2021-03-09 | Marquette | Wisconsin | 55077 | 1494 | 26 |
1102136 | 1102136 | 2021-03-08 | Marquette | Wisconsin | 55077 | 1494 | 26 |
1098890 | 1098890 | 2021-03-07 | Marquette | Wisconsin | 55077 | 1494 | 26 |
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);