ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 26051 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
869780 | 869780 | 2020-12-27 | Gladwin | Michigan | 26051 | 1154 | 29 |
866535 | 866535 | 2020-12-26 | Gladwin | Michigan | 26051 | 1154 | 29 |
863290 | 863290 | 2020-12-25 | Gladwin | Michigan | 26051 | 1129 | 28 |
860045 | 860045 | 2020-12-24 | Gladwin | Michigan | 26051 | 1129 | 28 |
856800 | 856800 | 2020-12-23 | Gladwin | Michigan | 26051 | 1129 | 28 |
853555 | 853555 | 2020-12-22 | Gladwin | Michigan | 26051 | 1116 | 26 |
850310 | 850310 | 2020-12-21 | Gladwin | Michigan | 26051 | 1106 | 25 |
847065 | 847065 | 2020-12-20 | Gladwin | Michigan | 26051 | 1094 | 23 |
843819 | 843819 | 2020-12-19 | Gladwin | Michigan | 26051 | 1094 | 23 |
840574 | 840574 | 2020-12-18 | Gladwin | Michigan | 26051 | 1088 | 23 |
837329 | 837329 | 2020-12-17 | Gladwin | Michigan | 26051 | 1076 | 22 |
834083 | 834083 | 2020-12-16 | Gladwin | Michigan | 26051 | 1070 | 20 |
830836 | 830836 | 2020-12-15 | Gladwin | Michigan | 26051 | 1060 | 18 |
827590 | 827590 | 2020-12-14 | Gladwin | Michigan | 26051 | 1055 | 16 |
824343 | 824343 | 2020-12-13 | Gladwin | Michigan | 26051 | 1037 | 16 |
821097 | 821097 | 2020-12-12 | Gladwin | Michigan | 26051 | 1037 | 16 |
817851 | 817851 | 2020-12-11 | Gladwin | Michigan | 26051 | 1021 | 14 |
814605 | 814605 | 2020-12-10 | Gladwin | Michigan | 26051 | 1009 | 14 |
811360 | 811360 | 2020-12-09 | Gladwin | Michigan | 26051 | 992 | 14 |
808115 | 808115 | 2020-12-08 | Gladwin | Michigan | 26051 | 964 | 14 |
804870 | 804870 | 2020-12-07 | Gladwin | Michigan | 26051 | 946 | 14 |
801625 | 801625 | 2020-12-06 | Gladwin | Michigan | 26051 | 924 | 14 |
798380 | 798380 | 2020-12-05 | Gladwin | Michigan | 26051 | 924 | 14 |
795135 | 795135 | 2020-12-04 | Gladwin | Michigan | 26051 | 914 | 14 |
791890 | 791890 | 2020-12-03 | Gladwin | Michigan | 26051 | 891 | 14 |
788645 | 788645 | 2020-12-02 | Gladwin | Michigan | 26051 | 869 | 12 |
785400 | 785400 | 2020-12-01 | Gladwin | Michigan | 26051 | 855 | 12 |
782156 | 782156 | 2020-11-30 | Gladwin | Michigan | 26051 | 835 | 12 |
778910 | 778910 | 2020-11-29 | Gladwin | Michigan | 26051 | 800 | 10 |
775665 | 775665 | 2020-11-28 | Gladwin | Michigan | 26051 | 800 | 10 |
772420 | 772420 | 2020-11-27 | Gladwin | Michigan | 26051 | 792 | 10 |
769175 | 769175 | 2020-11-26 | Gladwin | Michigan | 26051 | 732 | 9 |
765929 | 765929 | 2020-11-25 | Gladwin | Michigan | 26051 | 732 | 9 |
762684 | 762684 | 2020-11-24 | Gladwin | Michigan | 26051 | 709 | 9 |
759439 | 759439 | 2020-11-23 | Gladwin | Michigan | 26051 | 689 | 9 |
756192 | 756192 | 2020-11-22 | Gladwin | Michigan | 26051 | 643 | 8 |
752946 | 752946 | 2020-11-21 | Gladwin | Michigan | 26051 | 643 | 8 |
749700 | 749700 | 2020-11-20 | Gladwin | Michigan | 26051 | 626 | 8 |
746454 | 746454 | 2020-11-19 | Gladwin | Michigan | 26051 | 585 | 8 |
743207 | 743207 | 2020-11-18 | Gladwin | Michigan | 26051 | 559 | 8 |
739960 | 739960 | 2020-11-17 | Gladwin | Michigan | 26051 | 538 | 7 |
736716 | 736716 | 2020-11-16 | Gladwin | Michigan | 26051 | 503 | 7 |
733470 | 733470 | 2020-11-15 | Gladwin | Michigan | 26051 | 458 | 6 |
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);