ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Gladwin" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194376 | 1194376 | 2021-04-06 | Gladwin | Michigan | 26051 | 1724 | 43 |
1191127 | 1191127 | 2021-04-05 | Gladwin | Michigan | 26051 | 1700 | 43 |
1187879 | 1187879 | 2021-04-04 | Gladwin | Michigan | 26051 | 1675 | 43 |
1184632 | 1184632 | 2021-04-03 | Gladwin | Michigan | 26051 | 1675 | 43 |
1181386 | 1181386 | 2021-04-02 | Gladwin | Michigan | 26051 | 1644 | 43 |
1178139 | 1178139 | 2021-04-01 | Gladwin | Michigan | 26051 | 1634 | 43 |
1174892 | 1174892 | 2021-03-31 | Gladwin | Michigan | 26051 | 1622 | 43 |
1171645 | 1171645 | 2021-03-30 | Gladwin | Michigan | 26051 | 1608 | 43 |
1168397 | 1168397 | 2021-03-29 | Gladwin | Michigan | 26051 | 1589 | 43 |
1165149 | 1165149 | 2021-03-28 | Gladwin | Michigan | 26051 | 1586 | 43 |
1161901 | 1161901 | 2021-03-27 | Gladwin | Michigan | 26051 | 1586 | 43 |
1158653 | 1158653 | 2021-03-26 | Gladwin | Michigan | 26051 | 1576 | 43 |
1155406 | 1155406 | 2021-03-25 | Gladwin | Michigan | 26051 | 1569 | 43 |
1152159 | 1152159 | 2021-03-24 | Gladwin | Michigan | 26051 | 1560 | 43 |
1148912 | 1148912 | 2021-03-23 | Gladwin | Michigan | 26051 | 1557 | 43 |
1145665 | 1145665 | 2021-03-22 | Gladwin | Michigan | 26051 | 1548 | 43 |
1142418 | 1142418 | 2021-03-21 | Gladwin | Michigan | 26051 | 1533 | 43 |
1139171 | 1139171 | 2021-03-20 | Gladwin | Michigan | 26051 | 1533 | 43 |
1135925 | 1135925 | 2021-03-19 | Gladwin | Michigan | 26051 | 1528 | 43 |
1132679 | 1132679 | 2021-03-18 | Gladwin | Michigan | 26051 | 1522 | 43 |
1129431 | 1129431 | 2021-03-17 | Gladwin | Michigan | 26051 | 1522 | 43 |
1126184 | 1126184 | 2021-03-16 | Gladwin | Michigan | 26051 | 1515 | 43 |
1122938 | 1122938 | 2021-03-15 | Gladwin | Michigan | 26051 | 1510 | 43 |
1119691 | 1119691 | 2021-03-14 | Gladwin | Michigan | 26051 | 1508 | 43 |
1116444 | 1116444 | 2021-03-13 | Gladwin | Michigan | 26051 | 1508 | 43 |
1113198 | 1113198 | 2021-03-12 | Gladwin | Michigan | 26051 | 1504 | 43 |
1109952 | 1109952 | 2021-03-11 | Gladwin | Michigan | 26051 | 1503 | 43 |
1106706 | 1106706 | 2021-03-10 | Gladwin | Michigan | 26051 | 1500 | 43 |
1103460 | 1103460 | 2021-03-09 | Gladwin | Michigan | 26051 | 1500 | 43 |
1100214 | 1100214 | 2021-03-08 | Gladwin | Michigan | 26051 | 1500 | 43 |
1096967 | 1096967 | 2021-03-07 | Gladwin | Michigan | 26051 | 1500 | 43 |
1093720 | 1093720 | 2021-03-06 | Gladwin | Michigan | 26051 | 1500 | 43 |
1090474 | 1090474 | 2021-03-05 | Gladwin | Michigan | 26051 | 1499 | 43 |
1087229 | 1087229 | 2021-03-04 | Gladwin | Michigan | 26051 | 1493 | 43 |
1083984 | 1083984 | 2021-03-03 | Gladwin | Michigan | 26051 | 1487 | 43 |
1080738 | 1080738 | 2021-03-02 | Gladwin | Michigan | 26051 | 1485 | 43 |
1077492 | 1077492 | 2021-03-01 | Gladwin | Michigan | 26051 | 1484 | 43 |
1074246 | 1074246 | 2021-02-28 | Gladwin | Michigan | 26051 | 1482 | 43 |
1071000 | 1071000 | 2021-02-27 | Gladwin | Michigan | 26051 | 1482 | 43 |
1067755 | 1067755 | 2021-02-26 | Gladwin | Michigan | 26051 | 1480 | 43 |
1064510 | 1064510 | 2021-02-25 | Gladwin | Michigan | 26051 | 1479 | 43 |
1061266 | 1061266 | 2021-02-24 | Gladwin | Michigan | 26051 | 1475 | 43 |
1058020 | 1058020 | 2021-02-23 | Gladwin | Michigan | 26051 | 1471 | 43 |
1054774 | 1054774 | 2021-02-22 | Gladwin | Michigan | 26051 | 1469 | 43 |
1051527 | 1051527 | 2021-02-21 | Gladwin | Michigan | 26051 | 1468 | 43 |
1048280 | 1048280 | 2021-02-20 | Gladwin | Michigan | 26051 | 1468 | 43 |
1045034 | 1045034 | 2021-02-19 | Gladwin | Michigan | 26051 | 1466 | 42 |
1041789 | 1041789 | 2021-02-18 | Gladwin | Michigan | 26051 | 1460 | 42 |
1038544 | 1038544 | 2021-02-17 | Gladwin | Michigan | 26051 | 1459 | 42 |
1035299 | 1035299 | 2021-02-16 | Gladwin | Michigan | 26051 | 1458 | 42 |
1032054 | 1032054 | 2021-02-15 | Gladwin | Michigan | 26051 | 1457 | 42 |
1028807 | 1028807 | 2021-02-14 | Gladwin | Michigan | 26051 | 1456 | 42 |
1025561 | 1025561 | 2021-02-13 | Gladwin | Michigan | 26051 | 1456 | 42 |
1022316 | 1022316 | 2021-02-12 | Gladwin | Michigan | 26051 | 1456 | 42 |
1019071 | 1019071 | 2021-02-11 | Gladwin | Michigan | 26051 | 1455 | 42 |
1015826 | 1015826 | 2021-02-10 | Gladwin | Michigan | 26051 | 1453 | 42 |
1012581 | 1012581 | 2021-02-09 | Gladwin | Michigan | 26051 | 1450 | 42 |
1009336 | 1009336 | 2021-02-08 | Gladwin | Michigan | 26051 | 1448 | 42 |
1006089 | 1006089 | 2021-02-07 | Gladwin | Michigan | 26051 | 1447 | 42 |
1002843 | 1002843 | 2021-02-06 | Gladwin | Michigan | 26051 | 1447 | 42 |
999598 | 999598 | 2021-02-05 | Gladwin | Michigan | 26051 | 1444 | 42 |
996352 | 996352 | 2021-02-04 | Gladwin | Michigan | 26051 | 1443 | 42 |
993106 | 993106 | 2021-02-03 | Gladwin | Michigan | 26051 | 1437 | 42 |
989860 | 989860 | 2021-02-02 | Gladwin | Michigan | 26051 | 1432 | 42 |
986613 | 986613 | 2021-02-01 | Gladwin | Michigan | 26051 | 1430 | 42 |
983366 | 983366 | 2021-01-31 | Gladwin | Michigan | 26051 | 1416 | 42 |
980120 | 980120 | 2021-01-30 | Gladwin | Michigan | 26051 | 1416 | 42 |
976874 | 976874 | 2021-01-29 | Gladwin | Michigan | 26051 | 1416 | 41 |
973629 | 973629 | 2021-01-28 | Gladwin | Michigan | 26051 | 1410 | 41 |
970384 | 970384 | 2021-01-27 | Gladwin | Michigan | 26051 | 1407 | 41 |
967139 | 967139 | 2021-01-26 | Gladwin | Michigan | 26051 | 1403 | 41 |
963895 | 963895 | 2021-01-25 | Gladwin | Michigan | 26051 | 1395 | 41 |
960650 | 960650 | 2021-01-24 | Gladwin | Michigan | 26051 | 1382 | 41 |
957404 | 957404 | 2021-01-23 | Gladwin | Michigan | 26051 | 1382 | 41 |
954159 | 954159 | 2021-01-22 | Gladwin | Michigan | 26051 | 1377 | 38 |
950914 | 950914 | 2021-01-21 | Gladwin | Michigan | 26051 | 1367 | 38 |
947668 | 947668 | 2021-01-20 | Gladwin | Michigan | 26051 | 1362 | 37 |
944421 | 944421 | 2021-01-19 | Gladwin | Michigan | 26051 | 1350 | 37 |
941176 | 941176 | 2021-01-18 | Gladwin | Michigan | 26051 | 1346 | 37 |
937931 | 937931 | 2021-01-17 | Gladwin | Michigan | 26051 | 1334 | 36 |
934686 | 934686 | 2021-01-16 | Gladwin | Michigan | 26051 | 1334 | 36 |
931441 | 931441 | 2021-01-15 | Gladwin | Michigan | 26051 | 1332 | 35 |
928196 | 928196 | 2021-01-14 | Gladwin | Michigan | 26051 | 1324 | 35 |
924950 | 924950 | 2021-01-13 | Gladwin | Michigan | 26051 | 1317 | 35 |
921705 | 921705 | 2021-01-12 | Gladwin | Michigan | 26051 | 1306 | 35 |
918460 | 918460 | 2021-01-11 | Gladwin | Michigan | 26051 | 1296 | 35 |
915215 | 915215 | 2021-01-10 | Gladwin | Michigan | 26051 | 1283 | 35 |
911970 | 911970 | 2021-01-09 | Gladwin | Michigan | 26051 | 1283 | 35 |
908725 | 908725 | 2021-01-08 | Gladwin | Michigan | 26051 | 1276 | 35 |
905479 | 905479 | 2021-01-07 | Gladwin | Michigan | 26051 | 1270 | 35 |
902234 | 902234 | 2021-01-06 | Gladwin | Michigan | 26051 | 1262 | 34 |
898989 | 898989 | 2021-01-05 | Gladwin | Michigan | 26051 | 1249 | 34 |
895744 | 895744 | 2021-01-04 | Gladwin | Michigan | 26051 | 1235 | 33 |
892497 | 892497 | 2021-01-03 | Gladwin | Michigan | 26051 | 1210 | 33 |
889251 | 889251 | 2021-01-02 | Gladwin | Michigan | 26051 | 1210 | 33 |
886005 | 886005 | 2021-01-01 | Gladwin | Michigan | 26051 | 1184 | 32 |
882760 | 882760 | 2020-12-31 | Gladwin | Michigan | 26051 | 1184 | 32 |
879515 | 879515 | 2020-12-30 | Gladwin | Michigan | 26051 | 1184 | 32 |
876270 | 876270 | 2020-12-29 | Gladwin | Michigan | 26051 | 1179 | 33 |
873025 | 873025 | 2020-12-28 | Gladwin | Michigan | 26051 | 1169 | 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);