ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Eaton" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194373 | 1194373 | 2021-04-06 | Eaton | Michigan | 26045 | 8148 | 163 |
1191124 | 1191124 | 2021-04-05 | Eaton | Michigan | 26045 | 8031 | 162 |
1187876 | 1187876 | 2021-04-04 | Eaton | Michigan | 26045 | 7895 | 162 |
1184629 | 1184629 | 2021-04-03 | Eaton | Michigan | 26045 | 7895 | 162 |
1181383 | 1181383 | 2021-04-02 | Eaton | Michigan | 26045 | 7789 | 162 |
1178136 | 1178136 | 2021-04-01 | Eaton | Michigan | 26045 | 7706 | 162 |
1174889 | 1174889 | 2021-03-31 | Eaton | Michigan | 26045 | 7583 | 161 |
1171642 | 1171642 | 2021-03-30 | Eaton | Michigan | 26045 | 7491 | 160 |
1168394 | 1168394 | 2021-03-29 | Eaton | Michigan | 26045 | 7375 | 160 |
1165146 | 1165146 | 2021-03-28 | Eaton | Michigan | 26045 | 7257 | 160 |
1161898 | 1161898 | 2021-03-27 | Eaton | Michigan | 26045 | 7257 | 160 |
1158650 | 1158650 | 2021-03-26 | Eaton | Michigan | 26045 | 7204 | 160 |
1155403 | 1155403 | 2021-03-25 | Eaton | Michigan | 26045 | 7095 | 160 |
1152156 | 1152156 | 2021-03-24 | Eaton | Michigan | 26045 | 7041 | 160 |
1148909 | 1148909 | 2021-03-23 | Eaton | Michigan | 26045 | 6959 | 160 |
1145662 | 1145662 | 2021-03-22 | Eaton | Michigan | 26045 | 6903 | 160 |
1142415 | 1142415 | 2021-03-21 | Eaton | Michigan | 26045 | 6833 | 160 |
1139168 | 1139168 | 2021-03-20 | Eaton | Michigan | 26045 | 6833 | 160 |
1135922 | 1135922 | 2021-03-19 | Eaton | Michigan | 26045 | 6797 | 159 |
1132676 | 1132676 | 2021-03-18 | Eaton | Michigan | 26045 | 6728 | 159 |
1129428 | 1129428 | 2021-03-17 | Eaton | Michigan | 26045 | 6680 | 159 |
1126181 | 1126181 | 2021-03-16 | Eaton | Michigan | 26045 | 6648 | 159 |
1122935 | 1122935 | 2021-03-15 | Eaton | Michigan | 26045 | 6611 | 158 |
1119688 | 1119688 | 2021-03-14 | Eaton | Michigan | 26045 | 6548 | 158 |
1116441 | 1116441 | 2021-03-13 | Eaton | Michigan | 26045 | 6548 | 158 |
1113195 | 1113195 | 2021-03-12 | Eaton | Michigan | 26045 | 6525 | 156 |
1109949 | 1109949 | 2021-03-11 | Eaton | Michigan | 26045 | 6496 | 156 |
1106703 | 1106703 | 2021-03-10 | Eaton | Michigan | 26045 | 6455 | 156 |
1103457 | 1103457 | 2021-03-09 | Eaton | Michigan | 26045 | 6429 | 156 |
1100211 | 1100211 | 2021-03-08 | Eaton | Michigan | 26045 | 6426 | 156 |
1096964 | 1096964 | 2021-03-07 | Eaton | Michigan | 26045 | 6407 | 156 |
1093717 | 1093717 | 2021-03-06 | Eaton | Michigan | 26045 | 6407 | 156 |
1090471 | 1090471 | 2021-03-05 | Eaton | Michigan | 26045 | 6388 | 156 |
1087226 | 1087226 | 2021-03-04 | Eaton | Michigan | 26045 | 6379 | 156 |
1083981 | 1083981 | 2021-03-03 | Eaton | Michigan | 26045 | 6353 | 156 |
1080735 | 1080735 | 2021-03-02 | Eaton | Michigan | 26045 | 6329 | 155 |
1077489 | 1077489 | 2021-03-01 | Eaton | Michigan | 26045 | 6307 | 155 |
1074243 | 1074243 | 2021-02-28 | Eaton | Michigan | 26045 | 6276 | 153 |
1070997 | 1070997 | 2021-02-27 | Eaton | Michigan | 26045 | 6276 | 153 |
1067752 | 1067752 | 2021-02-26 | Eaton | Michigan | 26045 | 6259 | 153 |
1064507 | 1064507 | 2021-02-25 | Eaton | Michigan | 26045 | 6245 | 152 |
1061263 | 1061263 | 2021-02-24 | Eaton | Michigan | 26045 | 6226 | 151 |
1058017 | 1058017 | 2021-02-23 | Eaton | Michigan | 26045 | 6195 | 150 |
1054771 | 1054771 | 2021-02-22 | Eaton | Michigan | 26045 | 6169 | 150 |
1051524 | 1051524 | 2021-02-21 | Eaton | Michigan | 26045 | 6149 | 151 |
1048277 | 1048277 | 2021-02-20 | Eaton | Michigan | 26045 | 6149 | 151 |
1045031 | 1045031 | 2021-02-19 | Eaton | Michigan | 26045 | 6140 | 150 |
1041786 | 1041786 | 2021-02-18 | Eaton | Michigan | 26045 | 6109 | 147 |
1038541 | 1038541 | 2021-02-17 | Eaton | Michigan | 26045 | 6092 | 147 |
1035296 | 1035296 | 2021-02-16 | Eaton | Michigan | 26045 | 6065 | 147 |
1032051 | 1032051 | 2021-02-15 | Eaton | Michigan | 26045 | 6057 | 147 |
1028804 | 1028804 | 2021-02-14 | Eaton | Michigan | 26045 | 6050 | 146 |
1025558 | 1025558 | 2021-02-13 | Eaton | Michigan | 26045 | 6050 | 146 |
1022313 | 1022313 | 2021-02-12 | Eaton | Michigan | 26045 | 6035 | 145 |
1019068 | 1019068 | 2021-02-11 | Eaton | Michigan | 26045 | 6010 | 145 |
1015823 | 1015823 | 2021-02-10 | Eaton | Michigan | 26045 | 5998 | 144 |
1012578 | 1012578 | 2021-02-09 | Eaton | Michigan | 26045 | 5983 | 144 |
1009333 | 1009333 | 2021-02-08 | Eaton | Michigan | 26045 | 5971 | 142 |
1006086 | 1006086 | 2021-02-07 | Eaton | Michigan | 26045 | 5951 | 141 |
1002840 | 1002840 | 2021-02-06 | Eaton | Michigan | 26045 | 5951 | 141 |
999595 | 999595 | 2021-02-05 | Eaton | Michigan | 26045 | 5944 | 142 |
996349 | 996349 | 2021-02-04 | Eaton | Michigan | 26045 | 5925 | 141 |
993103 | 993103 | 2021-02-03 | Eaton | Michigan | 26045 | 5916 | 138 |
989857 | 989857 | 2021-02-02 | Eaton | Michigan | 26045 | 5899 | 138 |
986610 | 986610 | 2021-02-01 | Eaton | Michigan | 26045 | 5871 | 135 |
983363 | 983363 | 2021-01-31 | Eaton | Michigan | 26045 | 5845 | 135 |
980117 | 980117 | 2021-01-30 | Eaton | Michigan | 26045 | 5845 | 135 |
976871 | 976871 | 2021-01-29 | Eaton | Michigan | 26045 | 5825 | 132 |
973626 | 973626 | 2021-01-28 | Eaton | Michigan | 26045 | 5804 | 133 |
970381 | 970381 | 2021-01-27 | Eaton | Michigan | 26045 | 5754 | 132 |
967136 | 967136 | 2021-01-26 | Eaton | Michigan | 26045 | 5716 | 130 |
963892 | 963892 | 2021-01-25 | Eaton | Michigan | 26045 | 5662 | 129 |
960647 | 960647 | 2021-01-24 | Eaton | Michigan | 26045 | 5614 | 129 |
957401 | 957401 | 2021-01-23 | Eaton | Michigan | 26045 | 5614 | 129 |
954156 | 954156 | 2021-01-22 | Eaton | Michigan | 26045 | 5598 | 122 |
950911 | 950911 | 2021-01-21 | Eaton | Michigan | 26045 | 5547 | 122 |
947665 | 947665 | 2021-01-20 | Eaton | Michigan | 26045 | 5503 | 117 |
944418 | 944418 | 2021-01-19 | Eaton | Michigan | 26045 | 5488 | 118 |
941173 | 941173 | 2021-01-18 | Eaton | Michigan | 26045 | 5444 | 117 |
937928 | 937928 | 2021-01-17 | Eaton | Michigan | 26045 | 5388 | 117 |
934683 | 934683 | 2021-01-16 | Eaton | Michigan | 26045 | 5388 | 117 |
931438 | 931438 | 2021-01-15 | Eaton | Michigan | 26045 | 5370 | 117 |
928193 | 928193 | 2021-01-14 | Eaton | Michigan | 26045 | 5315 | 116 |
924947 | 924947 | 2021-01-13 | Eaton | Michigan | 26045 | 5277 | 113 |
921702 | 921702 | 2021-01-12 | Eaton | Michigan | 26045 | 5239 | 111 |
918457 | 918457 | 2021-01-11 | Eaton | Michigan | 26045 | 5186 | 110 |
915212 | 915212 | 2021-01-10 | Eaton | Michigan | 26045 | 5136 | 106 |
911967 | 911967 | 2021-01-09 | Eaton | Michigan | 26045 | 5136 | 106 |
908722 | 908722 | 2021-01-08 | Eaton | Michigan | 26045 | 5072 | 102 |
905476 | 905476 | 2021-01-07 | Eaton | Michigan | 26045 | 5052 | 102 |
902231 | 902231 | 2021-01-06 | Eaton | Michigan | 26045 | 4997 | 100 |
898986 | 898986 | 2021-01-05 | Eaton | Michigan | 26045 | 4938 | 100 |
895741 | 895741 | 2021-01-04 | Eaton | Michigan | 26045 | 4896 | 97 |
892494 | 892494 | 2021-01-03 | Eaton | Michigan | 26045 | 4810 | 95 |
889248 | 889248 | 2021-01-02 | Eaton | Michigan | 26045 | 4810 | 95 |
886002 | 886002 | 2021-01-01 | Eaton | Michigan | 26045 | 4667 | 88 |
882757 | 882757 | 2020-12-31 | Eaton | Michigan | 26045 | 4667 | 88 |
879512 | 879512 | 2020-12-30 | Eaton | Michigan | 26045 | 4667 | 88 |
876267 | 876267 | 2020-12-29 | Eaton | Michigan | 26045 | 4620 | 89 |
873022 | 873022 | 2020-12-28 | Eaton | Michigan | 26045 | 4540 | 87 |
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);