ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26037 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194369 | 1194369 | 2021-04-06 | Clinton | Michigan | 26037 | 6259 | 75 |
1191120 | 1191120 | 2021-04-05 | Clinton | Michigan | 26037 | 6221 | 75 |
1187872 | 1187872 | 2021-04-04 | Clinton | Michigan | 26037 | 6090 | 75 |
1184625 | 1184625 | 2021-04-03 | Clinton | Michigan | 26037 | 6090 | 75 |
1181379 | 1181379 | 2021-04-02 | Clinton | Michigan | 26037 | 6053 | 75 |
1178132 | 1178132 | 2021-04-01 | Clinton | Michigan | 26037 | 5999 | 75 |
1174885 | 1174885 | 2021-03-31 | Clinton | Michigan | 26037 | 5940 | 75 |
1171638 | 1171638 | 2021-03-30 | Clinton | Michigan | 26037 | 5885 | 75 |
1168390 | 1168390 | 2021-03-29 | Clinton | Michigan | 26037 | 5813 | 75 |
1165142 | 1165142 | 2021-03-28 | Clinton | Michigan | 26037 | 5757 | 75 |
1161894 | 1161894 | 2021-03-27 | Clinton | Michigan | 26037 | 5757 | 75 |
1158646 | 1158646 | 2021-03-26 | Clinton | Michigan | 26037 | 5731 | 75 |
1155399 | 1155399 | 2021-03-25 | Clinton | Michigan | 26037 | 5661 | 75 |
1152152 | 1152152 | 2021-03-24 | Clinton | Michigan | 26037 | 5613 | 74 |
1148905 | 1148905 | 2021-03-23 | Clinton | Michigan | 26037 | 5561 | 74 |
1145658 | 1145658 | 2021-03-22 | Clinton | Michigan | 26037 | 5523 | 74 |
1142411 | 1142411 | 2021-03-21 | Clinton | Michigan | 26037 | 5471 | 74 |
1139164 | 1139164 | 2021-03-20 | Clinton | Michigan | 26037 | 5471 | 74 |
1135918 | 1135918 | 2021-03-19 | Clinton | Michigan | 26037 | 5455 | 74 |
1132672 | 1132672 | 2021-03-18 | Clinton | Michigan | 26037 | 5399 | 72 |
1129424 | 1129424 | 2021-03-17 | Clinton | Michigan | 26037 | 5358 | 72 |
1126177 | 1126177 | 2021-03-16 | Clinton | Michigan | 26037 | 5335 | 72 |
1122931 | 1122931 | 2021-03-15 | Clinton | Michigan | 26037 | 5301 | 72 |
1119684 | 1119684 | 2021-03-14 | Clinton | Michigan | 26037 | 5233 | 72 |
1116437 | 1116437 | 2021-03-13 | Clinton | Michigan | 26037 | 5233 | 72 |
1113191 | 1113191 | 2021-03-12 | Clinton | Michigan | 26037 | 5228 | 72 |
1109945 | 1109945 | 2021-03-11 | Clinton | Michigan | 26037 | 5194 | 72 |
1106699 | 1106699 | 2021-03-10 | Clinton | Michigan | 26037 | 5156 | 72 |
1103453 | 1103453 | 2021-03-09 | Clinton | Michigan | 26037 | 5126 | 72 |
1100207 | 1100207 | 2021-03-08 | Clinton | Michigan | 26037 | 5114 | 72 |
1096960 | 1096960 | 2021-03-07 | Clinton | Michigan | 26037 | 5098 | 71 |
1093713 | 1093713 | 2021-03-06 | Clinton | Michigan | 26037 | 5098 | 71 |
1090467 | 1090467 | 2021-03-05 | Clinton | Michigan | 26037 | 5090 | 71 |
1087222 | 1087222 | 2021-03-04 | Clinton | Michigan | 26037 | 5071 | 71 |
1083977 | 1083977 | 2021-03-03 | Clinton | Michigan | 26037 | 5061 | 71 |
1080731 | 1080731 | 2021-03-02 | Clinton | Michigan | 26037 | 5052 | 70 |
1077485 | 1077485 | 2021-03-01 | Clinton | Michigan | 26037 | 5042 | 70 |
1074239 | 1074239 | 2021-02-28 | Clinton | Michigan | 26037 | 5031 | 70 |
1070993 | 1070993 | 2021-02-27 | Clinton | Michigan | 26037 | 5031 | 70 |
1067748 | 1067748 | 2021-02-26 | Clinton | Michigan | 26037 | 5030 | 70 |
1064503 | 1064503 | 2021-02-25 | Clinton | Michigan | 26037 | 5027 | 70 |
1061259 | 1061259 | 2021-02-24 | Clinton | Michigan | 26037 | 5017 | 70 |
1058013 | 1058013 | 2021-02-23 | Clinton | Michigan | 26037 | 5000 | 70 |
1054767 | 1054767 | 2021-02-22 | Clinton | Michigan | 26037 | 4991 | 69 |
1051520 | 1051520 | 2021-02-21 | Clinton | Michigan | 26037 | 4978 | 69 |
1048273 | 1048273 | 2021-02-20 | Clinton | Michigan | 26037 | 4978 | 69 |
1045027 | 1045027 | 2021-02-19 | Clinton | Michigan | 26037 | 4974 | 69 |
1041782 | 1041782 | 2021-02-18 | Clinton | Michigan | 26037 | 4964 | 69 |
1038537 | 1038537 | 2021-02-17 | Clinton | Michigan | 26037 | 4950 | 69 |
1035292 | 1035292 | 2021-02-16 | Clinton | Michigan | 26037 | 4938 | 69 |
1032047 | 1032047 | 2021-02-15 | Clinton | Michigan | 26037 | 4929 | 69 |
1028800 | 1028800 | 2021-02-14 | Clinton | Michigan | 26037 | 4924 | 69 |
1025554 | 1025554 | 2021-02-13 | Clinton | Michigan | 26037 | 4924 | 69 |
1022309 | 1022309 | 2021-02-12 | Clinton | Michigan | 26037 | 4917 | 69 |
1019064 | 1019064 | 2021-02-11 | Clinton | Michigan | 26037 | 4902 | 69 |
1015819 | 1015819 | 2021-02-10 | Clinton | Michigan | 26037 | 4890 | 68 |
1012574 | 1012574 | 2021-02-09 | Clinton | Michigan | 26037 | 4872 | 68 |
1009329 | 1009329 | 2021-02-08 | Clinton | Michigan | 26037 | 4857 | 68 |
1006082 | 1006082 | 2021-02-07 | Clinton | Michigan | 26037 | 4831 | 68 |
1002836 | 1002836 | 2021-02-06 | Clinton | Michigan | 26037 | 4831 | 68 |
999591 | 999591 | 2021-02-05 | Clinton | Michigan | 26037 | 4821 | 67 |
996345 | 996345 | 2021-02-04 | Clinton | Michigan | 26037 | 4802 | 66 |
993099 | 993099 | 2021-02-03 | Clinton | Michigan | 26037 | 4795 | 66 |
989853 | 989853 | 2021-02-02 | Clinton | Michigan | 26037 | 4771 | 66 |
986606 | 986606 | 2021-02-01 | Clinton | Michigan | 26037 | 4759 | 66 |
983359 | 983359 | 2021-01-31 | Clinton | Michigan | 26037 | 4727 | 66 |
980113 | 980113 | 2021-01-30 | Clinton | Michigan | 26037 | 4727 | 66 |
976867 | 976867 | 2021-01-29 | Clinton | Michigan | 26037 | 4701 | 63 |
973622 | 973622 | 2021-01-28 | Clinton | Michigan | 26037 | 4688 | 63 |
970377 | 970377 | 2021-01-27 | Clinton | Michigan | 26037 | 4669 | 62 |
967132 | 967132 | 2021-01-26 | Clinton | Michigan | 26037 | 4648 | 62 |
963888 | 963888 | 2021-01-25 | Clinton | Michigan | 26037 | 4627 | 61 |
960643 | 960643 | 2021-01-24 | Clinton | Michigan | 26037 | 4607 | 59 |
957397 | 957397 | 2021-01-23 | Clinton | Michigan | 26037 | 4607 | 59 |
954152 | 954152 | 2021-01-22 | Clinton | Michigan | 26037 | 4600 | 53 |
950907 | 950907 | 2021-01-21 | Clinton | Michigan | 26037 | 4559 | 53 |
947661 | 947661 | 2021-01-20 | Clinton | Michigan | 26037 | 4542 | 53 |
944414 | 944414 | 2021-01-19 | Clinton | Michigan | 26037 | 4514 | 52 |
941169 | 941169 | 2021-01-18 | Clinton | Michigan | 26037 | 4491 | 52 |
937924 | 937924 | 2021-01-17 | Clinton | Michigan | 26037 | 4455 | 51 |
934679 | 934679 | 2021-01-16 | Clinton | Michigan | 26037 | 4455 | 51 |
931434 | 931434 | 2021-01-15 | Clinton | Michigan | 26037 | 4452 | 50 |
928189 | 928189 | 2021-01-14 | Clinton | Michigan | 26037 | 4423 | 50 |
924943 | 924943 | 2021-01-13 | Clinton | Michigan | 26037 | 4404 | 50 |
921698 | 921698 | 2021-01-12 | Clinton | Michigan | 26037 | 4376 | 50 |
918453 | 918453 | 2021-01-11 | Clinton | Michigan | 26037 | 4344 | 50 |
915208 | 915208 | 2021-01-10 | Clinton | Michigan | 26037 | 4297 | 48 |
911963 | 911963 | 2021-01-09 | Clinton | Michigan | 26037 | 4297 | 48 |
908718 | 908718 | 2021-01-08 | Clinton | Michigan | 26037 | 4270 | 44 |
905472 | 905472 | 2021-01-07 | Clinton | Michigan | 26037 | 4220 | 44 |
902227 | 902227 | 2021-01-06 | Clinton | Michigan | 26037 | 4209 | 44 |
898982 | 898982 | 2021-01-05 | Clinton | Michigan | 26037 | 4167 | 44 |
895737 | 895737 | 2021-01-04 | Clinton | Michigan | 26037 | 4128 | 42 |
892490 | 892490 | 2021-01-03 | Clinton | Michigan | 26037 | 4012 | 41 |
889244 | 889244 | 2021-01-02 | Clinton | Michigan | 26037 | 4012 | 41 |
885998 | 885998 | 2021-01-01 | Clinton | Michigan | 26037 | 3879 | 40 |
882753 | 882753 | 2020-12-31 | Clinton | Michigan | 26037 | 3879 | 40 |
879508 | 879508 | 2020-12-30 | Clinton | Michigan | 26037 | 3879 | 40 |
876263 | 876263 | 2020-12-29 | Clinton | Michigan | 26037 | 3834 | 39 |
873018 | 873018 | 2020-12-28 | Clinton | Michigan | 26037 | 3743 | 40 |
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);