ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Wayne" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194433 | 1194433 | 2021-04-06 | Wayne | Michigan | 26163 | 126587 | 4304 |
1191184 | 1191184 | 2021-04-05 | Wayne | Michigan | 26163 | 125421 | 4297 |
1187936 | 1187936 | 2021-04-04 | Wayne | Michigan | 26163 | 123028 | 4291 |
1184689 | 1184689 | 2021-04-03 | Wayne | Michigan | 26163 | 123028 | 4291 |
1181443 | 1181443 | 2021-04-02 | Wayne | Michigan | 26163 | 121182 | 4277 |
1178196 | 1178196 | 2021-04-01 | Wayne | Michigan | 26163 | 120279 | 4266 |
1174949 | 1174949 | 2021-03-31 | Wayne | Michigan | 26163 | 119044 | 4258 |
1171702 | 1171702 | 2021-03-30 | Wayne | Michigan | 26163 | 117815 | 4257 |
1168454 | 1168454 | 2021-03-29 | Wayne | Michigan | 26163 | 116669 | 4247 |
1165206 | 1165206 | 2021-03-28 | Wayne | Michigan | 26163 | 114868 | 4246 |
1161958 | 1161958 | 2021-03-27 | Wayne | Michigan | 26163 | 114868 | 4246 |
1158710 | 1158710 | 2021-03-26 | Wayne | Michigan | 26163 | 113988 | 4245 |
1155463 | 1155463 | 2021-03-25 | Wayne | Michigan | 26163 | 113003 | 4239 |
1152216 | 1152216 | 2021-03-24 | Wayne | Michigan | 26163 | 111968 | 4227 |
1148969 | 1148969 | 2021-03-23 | Wayne | Michigan | 26163 | 111175 | 4224 |
1145722 | 1145722 | 2021-03-22 | Wayne | Michigan | 26163 | 110430 | 4219 |
1142475 | 1142475 | 2021-03-21 | Wayne | Michigan | 26163 | 109293 | 4219 |
1139228 | 1139228 | 2021-03-20 | Wayne | Michigan | 26163 | 109293 | 4219 |
1135982 | 1135982 | 2021-03-19 | Wayne | Michigan | 26163 | 108800 | 4205 |
1132736 | 1132736 | 2021-03-18 | Wayne | Michigan | 26163 | 108045 | 4203 |
1129488 | 1129488 | 2021-03-17 | Wayne | Michigan | 26163 | 107636 | 4199 |
1126241 | 1126241 | 2021-03-16 | Wayne | Michigan | 26163 | 107051 | 4199 |
1122995 | 1122995 | 2021-03-15 | Wayne | Michigan | 26163 | 106614 | 4196 |
1119748 | 1119748 | 2021-03-14 | Wayne | Michigan | 26163 | 105901 | 4193 |
1116501 | 1116501 | 2021-03-13 | Wayne | Michigan | 26163 | 105901 | 4193 |
1113255 | 1113255 | 2021-03-12 | Wayne | Michigan | 26163 | 105618 | 4188 |
1110009 | 1110009 | 2021-03-11 | Wayne | Michigan | 26163 | 105068 | 4187 |
1106763 | 1106763 | 2021-03-10 | Wayne | Michigan | 26163 | 104735 | 4186 |
1103517 | 1103517 | 2021-03-09 | Wayne | Michigan | 26163 | 104256 | 4183 |
1100271 | 1100271 | 2021-03-08 | Wayne | Michigan | 26163 | 104051 | 4174 |
1097024 | 1097024 | 2021-03-07 | Wayne | Michigan | 26163 | 103587 | 4174 |
1093777 | 1093777 | 2021-03-06 | Wayne | Michigan | 26163 | 103587 | 4174 |
1090531 | 1090531 | 2021-03-05 | Wayne | Michigan | 26163 | 103309 | 4158 |
1087286 | 1087286 | 2021-03-04 | Wayne | Michigan | 26163 | 102990 | 4154 |
1084041 | 1084041 | 2021-03-03 | Wayne | Michigan | 26163 | 102721 | 4149 |
1080795 | 1080795 | 2021-03-02 | Wayne | Michigan | 26163 | 102438 | 4149 |
1077549 | 1077549 | 2021-03-01 | Wayne | Michigan | 26163 | 102149 | 4145 |
1074303 | 1074303 | 2021-02-28 | Wayne | Michigan | 26163 | 101804 | 4144 |
1071057 | 1071057 | 2021-02-27 | Wayne | Michigan | 26163 | 101804 | 4144 |
1067812 | 1067812 | 2021-02-26 | Wayne | Michigan | 26163 | 101531 | 4133 |
1064567 | 1064567 | 2021-02-25 | Wayne | Michigan | 26163 | 101370 | 4134 |
1061323 | 1061323 | 2021-02-24 | Wayne | Michigan | 26163 | 101121 | 4127 |
1058077 | 1058077 | 2021-02-23 | Wayne | Michigan | 26163 | 100905 | 4126 |
1054831 | 1054831 | 2021-02-22 | Wayne | Michigan | 26163 | 100669 | 4120 |
1051584 | 1051584 | 2021-02-21 | Wayne | Michigan | 26163 | 100399 | 4120 |
1048337 | 1048337 | 2021-02-20 | Wayne | Michigan | 26163 | 100399 | 4120 |
1045091 | 1045091 | 2021-02-19 | Wayne | Michigan | 26163 | 100266 | 4112 |
1041846 | 1041846 | 2021-02-18 | Wayne | Michigan | 26163 | 100060 | 4107 |
1038601 | 1038601 | 2021-02-17 | Wayne | Michigan | 26163 | 99877 | 4088 |
1035356 | 1035356 | 2021-02-16 | Wayne | Michigan | 26163 | 99724 | 4087 |
1032111 | 1032111 | 2021-02-15 | Wayne | Michigan | 26163 | 99542 | 4086 |
1028864 | 1028864 | 2021-02-14 | Wayne | Michigan | 26163 | 99316 | 4085 |
1025618 | 1025618 | 2021-02-13 | Wayne | Michigan | 26163 | 99316 | 4085 |
1022373 | 1022373 | 2021-02-12 | Wayne | Michigan | 26163 | 99184 | 4065 |
1019128 | 1019128 | 2021-02-11 | Wayne | Michigan | 26163 | 98998 | 4063 |
1015883 | 1015883 | 2021-02-10 | Wayne | Michigan | 26163 | 98810 | 4054 |
1012638 | 1012638 | 2021-02-09 | Wayne | Michigan | 26163 | 98659 | 4053 |
1009393 | 1009393 | 2021-02-08 | Wayne | Michigan | 26163 | 98551 | 4047 |
1006146 | 1006146 | 2021-02-07 | Wayne | Michigan | 26163 | 98157 | 4043 |
1002900 | 1002900 | 2021-02-06 | Wayne | Michigan | 26163 | 98157 | 4043 |
999655 | 999655 | 2021-02-05 | Wayne | Michigan | 26163 | 97943 | 4021 |
996409 | 996409 | 2021-02-04 | Wayne | Michigan | 26163 | 97725 | 4017 |
993163 | 993163 | 2021-02-03 | Wayne | Michigan | 26163 | 97429 | 4002 |
989917 | 989917 | 2021-02-02 | Wayne | Michigan | 26163 | 97255 | 3997 |
986670 | 986670 | 2021-02-01 | Wayne | Michigan | 26163 | 97048 | 3981 |
983423 | 983423 | 2021-01-31 | Wayne | Michigan | 26163 | 96712 | 3984 |
980177 | 980177 | 2021-01-30 | Wayne | Michigan | 26163 | 96712 | 3984 |
976931 | 976931 | 2021-01-29 | Wayne | Michigan | 26163 | 96472 | 3965 |
973686 | 973686 | 2021-01-28 | Wayne | Michigan | 26163 | 96178 | 3966 |
970441 | 970441 | 2021-01-27 | Wayne | Michigan | 26163 | 95874 | 3949 |
967196 | 967196 | 2021-01-26 | Wayne | Michigan | 26163 | 95575 | 3951 |
963952 | 963952 | 2021-01-25 | Wayne | Michigan | 26163 | 95207 | 3936 |
960707 | 960707 | 2021-01-24 | Wayne | Michigan | 26163 | 94716 | 3930 |
957461 | 957461 | 2021-01-23 | Wayne | Michigan | 26163 | 94716 | 3930 |
954216 | 954216 | 2021-01-22 | Wayne | Michigan | 26163 | 94480 | 3901 |
950971 | 950971 | 2021-01-21 | Wayne | Michigan | 26163 | 94118 | 3902 |
947725 | 947725 | 2021-01-20 | Wayne | Michigan | 26163 | 93764 | 3878 |
944478 | 944478 | 2021-01-19 | Wayne | Michigan | 26163 | 93400 | 3868 |
941233 | 941233 | 2021-01-18 | Wayne | Michigan | 26163 | 93003 | 3859 |
937988 | 937988 | 2021-01-17 | Wayne | Michigan | 26163 | 92476 | 3856 |
934743 | 934743 | 2021-01-16 | Wayne | Michigan | 26163 | 92476 | 3856 |
931498 | 931498 | 2021-01-15 | Wayne | Michigan | 26163 | 92074 | 3839 |
928253 | 928253 | 2021-01-14 | Wayne | Michigan | 26163 | 91526 | 3835 |
925007 | 925007 | 2021-01-13 | Wayne | Michigan | 26163 | 91162 | 3813 |
921762 | 921762 | 2021-01-12 | Wayne | Michigan | 26163 | 90704 | 3807 |
918517 | 918517 | 2021-01-11 | Wayne | Michigan | 26163 | 90377 | 3794 |
915272 | 915272 | 2021-01-10 | Wayne | Michigan | 26163 | 89542 | 3789 |
912027 | 912027 | 2021-01-09 | Wayne | Michigan | 26163 | 89542 | 3789 |
908782 | 908782 | 2021-01-08 | Wayne | Michigan | 26163 | 89162 | 3745 |
905536 | 905536 | 2021-01-07 | Wayne | Michigan | 26163 | 88550 | 3742 |
902291 | 902291 | 2021-01-06 | Wayne | Michigan | 26163 | 88055 | 3711 |
899046 | 899046 | 2021-01-05 | Wayne | Michigan | 26163 | 87285 | 3704 |
895801 | 895801 | 2021-01-04 | Wayne | Michigan | 26163 | 86904 | 3684 |
892554 | 892554 | 2021-01-03 | Wayne | Michigan | 26163 | 86022 | 3669 |
889308 | 889308 | 2021-01-02 | Wayne | Michigan | 26163 | 86022 | 3669 |
886062 | 886062 | 2021-01-01 | Wayne | Michigan | 26163 | 84967 | 3626 |
882817 | 882817 | 2020-12-31 | Wayne | Michigan | 26163 | 84967 | 3626 |
879572 | 879572 | 2020-12-30 | Wayne | Michigan | 26163 | 84967 | 3626 |
876327 | 876327 | 2020-12-29 | Wayne | Michigan | 26163 | 84478 | 3618 |
873082 | 873082 | 2020-12-28 | Wayne | Michigan | 26163 | 83927 | 3585 |
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);