ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Bay" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194359 | 1194359 | 2021-04-06 | Bay | Michigan | 26017 | 8665 | 309 |
1191110 | 1191110 | 2021-04-05 | Bay | Michigan | 26017 | 8623 | 309 |
1187862 | 1187862 | 2021-04-04 | Bay | Michigan | 26017 | 8527 | 308 |
1184615 | 1184615 | 2021-04-03 | Bay | Michigan | 26017 | 8527 | 308 |
1181369 | 1181369 | 2021-04-02 | Bay | Michigan | 26017 | 8444 | 307 |
1178122 | 1178122 | 2021-04-01 | Bay | Michigan | 26017 | 8377 | 307 |
1174875 | 1174875 | 2021-03-31 | Bay | Michigan | 26017 | 8303 | 307 |
1171628 | 1171628 | 2021-03-30 | Bay | Michigan | 26017 | 8224 | 306 |
1168380 | 1168380 | 2021-03-29 | Bay | Michigan | 26017 | 8191 | 302 |
1165132 | 1165132 | 2021-03-28 | Bay | Michigan | 26017 | 8134 | 302 |
1161884 | 1161884 | 2021-03-27 | Bay | Michigan | 26017 | 8134 | 302 |
1158636 | 1158636 | 2021-03-26 | Bay | Michigan | 26017 | 8066 | 300 |
1155389 | 1155389 | 2021-03-25 | Bay | Michigan | 26017 | 8024 | 300 |
1152142 | 1152142 | 2021-03-24 | Bay | Michigan | 26017 | 7968 | 300 |
1148895 | 1148895 | 2021-03-23 | Bay | Michigan | 26017 | 7912 | 300 |
1145648 | 1145648 | 2021-03-22 | Bay | Michigan | 26017 | 7888 | 299 |
1142401 | 1142401 | 2021-03-21 | Bay | Michigan | 26017 | 7841 | 299 |
1139154 | 1139154 | 2021-03-20 | Bay | Michigan | 26017 | 7841 | 299 |
1135908 | 1135908 | 2021-03-19 | Bay | Michigan | 26017 | 7817 | 298 |
1132662 | 1132662 | 2021-03-18 | Bay | Michigan | 26017 | 7784 | 298 |
1129414 | 1129414 | 2021-03-17 | Bay | Michigan | 26017 | 7753 | 296 |
1126167 | 1126167 | 2021-03-16 | Bay | Michigan | 26017 | 7710 | 296 |
1122921 | 1122921 | 2021-03-15 | Bay | Michigan | 26017 | 7697 | 297 |
1119674 | 1119674 | 2021-03-14 | Bay | Michigan | 26017 | 7673 | 297 |
1116427 | 1116427 | 2021-03-13 | Bay | Michigan | 26017 | 7673 | 297 |
1113181 | 1113181 | 2021-03-12 | Bay | Michigan | 26017 | 7653 | 297 |
1109935 | 1109935 | 2021-03-11 | Bay | Michigan | 26017 | 7631 | 296 |
1106689 | 1106689 | 2021-03-10 | Bay | Michigan | 26017 | 7617 | 294 |
1103443 | 1103443 | 2021-03-09 | Bay | Michigan | 26017 | 7580 | 294 |
1100197 | 1100197 | 2021-03-08 | Bay | Michigan | 26017 | 7564 | 294 |
1096950 | 1096950 | 2021-03-07 | Bay | Michigan | 26017 | 7549 | 294 |
1093703 | 1093703 | 2021-03-06 | Bay | Michigan | 26017 | 7549 | 294 |
1090457 | 1090457 | 2021-03-05 | Bay | Michigan | 26017 | 7531 | 293 |
1087212 | 1087212 | 2021-03-04 | Bay | Michigan | 26017 | 7508 | 293 |
1083967 | 1083967 | 2021-03-03 | Bay | Michigan | 26017 | 7497 | 292 |
1080721 | 1080721 | 2021-03-02 | Bay | Michigan | 26017 | 7474 | 292 |
1077475 | 1077475 | 2021-03-01 | Bay | Michigan | 26017 | 7464 | 290 |
1074229 | 1074229 | 2021-02-28 | Bay | Michigan | 26017 | 7430 | 288 |
1070983 | 1070983 | 2021-02-27 | Bay | Michigan | 26017 | 7430 | 288 |
1067738 | 1067738 | 2021-02-26 | Bay | Michigan | 26017 | 7415 | 287 |
1064493 | 1064493 | 2021-02-25 | Bay | Michigan | 26017 | 7407 | 287 |
1061249 | 1061249 | 2021-02-24 | Bay | Michigan | 26017 | 7380 | 287 |
1058003 | 1058003 | 2021-02-23 | Bay | Michigan | 26017 | 7357 | 284 |
1054757 | 1054757 | 2021-02-22 | Bay | Michigan | 26017 | 7348 | 284 |
1051510 | 1051510 | 2021-02-21 | Bay | Michigan | 26017 | 7331 | 283 |
1048263 | 1048263 | 2021-02-20 | Bay | Michigan | 26017 | 7331 | 283 |
1045017 | 1045017 | 2021-02-19 | Bay | Michigan | 26017 | 7314 | 283 |
1041772 | 1041772 | 2021-02-18 | Bay | Michigan | 26017 | 7295 | 283 |
1038527 | 1038527 | 2021-02-17 | Bay | Michigan | 26017 | 7292 | 281 |
1035282 | 1035282 | 2021-02-16 | Bay | Michigan | 26017 | 7276 | 281 |
1032037 | 1032037 | 2021-02-15 | Bay | Michigan | 26017 | 7271 | 281 |
1028790 | 1028790 | 2021-02-14 | Bay | Michigan | 26017 | 7261 | 281 |
1025544 | 1025544 | 2021-02-13 | Bay | Michigan | 26017 | 7261 | 281 |
1022299 | 1022299 | 2021-02-12 | Bay | Michigan | 26017 | 7252 | 277 |
1019054 | 1019054 | 2021-02-11 | Bay | Michigan | 26017 | 7238 | 277 |
1015809 | 1015809 | 2021-02-10 | Bay | Michigan | 26017 | 7227 | 275 |
1012564 | 1012564 | 2021-02-09 | Bay | Michigan | 26017 | 7211 | 275 |
1009319 | 1009319 | 2021-02-08 | Bay | Michigan | 26017 | 7214 | 274 |
1006072 | 1006072 | 2021-02-07 | Bay | Michigan | 26017 | 7192 | 274 |
1002826 | 1002826 | 2021-02-06 | Bay | Michigan | 26017 | 7192 | 274 |
999581 | 999581 | 2021-02-05 | Bay | Michigan | 26017 | 7178 | 269 |
996335 | 996335 | 2021-02-04 | Bay | Michigan | 26017 | 7167 | 268 |
993089 | 993089 | 2021-02-03 | Bay | Michigan | 26017 | 7156 | 267 |
989843 | 989843 | 2021-02-02 | Bay | Michigan | 26017 | 7132 | 266 |
986596 | 986596 | 2021-02-01 | Bay | Michigan | 26017 | 7126 | 264 |
983349 | 983349 | 2021-01-31 | Bay | Michigan | 26017 | 7097 | 263 |
980103 | 980103 | 2021-01-30 | Bay | Michigan | 26017 | 7097 | 263 |
976857 | 976857 | 2021-01-29 | Bay | Michigan | 26017 | 7074 | 262 |
973612 | 973612 | 2021-01-28 | Bay | Michigan | 26017 | 7044 | 259 |
970367 | 970367 | 2021-01-27 | Bay | Michigan | 26017 | 7025 | 257 |
967122 | 967122 | 2021-01-26 | Bay | Michigan | 26017 | 7011 | 258 |
963878 | 963878 | 2021-01-25 | Bay | Michigan | 26017 | 7000 | 253 |
960633 | 960633 | 2021-01-24 | Bay | Michigan | 26017 | 6984 | 253 |
957387 | 957387 | 2021-01-23 | Bay | Michigan | 26017 | 6984 | 253 |
954142 | 954142 | 2021-01-22 | Bay | Michigan | 26017 | 6971 | 246 |
950897 | 950897 | 2021-01-21 | Bay | Michigan | 26017 | 6941 | 246 |
947651 | 947651 | 2021-01-20 | Bay | Michigan | 26017 | 6917 | 240 |
944404 | 944404 | 2021-01-19 | Bay | Michigan | 26017 | 6895 | 236 |
941159 | 941159 | 2021-01-18 | Bay | Michigan | 26017 | 6881 | 236 |
937914 | 937914 | 2021-01-17 | Bay | Michigan | 26017 | 6845 | 236 |
934669 | 934669 | 2021-01-16 | Bay | Michigan | 26017 | 6845 | 236 |
931424 | 931424 | 2021-01-15 | Bay | Michigan | 26017 | 6814 | 230 |
928179 | 928179 | 2021-01-14 | Bay | Michigan | 26017 | 6793 | 230 |
924933 | 924933 | 2021-01-13 | Bay | Michigan | 26017 | 6748 | 225 |
921688 | 921688 | 2021-01-12 | Bay | Michigan | 26017 | 6726 | 223 |
918443 | 918443 | 2021-01-11 | Bay | Michigan | 26017 | 6711 | 218 |
915198 | 915198 | 2021-01-10 | Bay | Michigan | 26017 | 6654 | 218 |
911953 | 911953 | 2021-01-09 | Bay | Michigan | 26017 | 6654 | 218 |
908708 | 908708 | 2021-01-08 | Bay | Michigan | 26017 | 6619 | 208 |
905462 | 905462 | 2021-01-07 | Bay | Michigan | 26017 | 6577 | 207 |
902217 | 902217 | 2021-01-06 | Bay | Michigan | 26017 | 6503 | 201 |
898972 | 898972 | 2021-01-05 | Bay | Michigan | 26017 | 6426 | 199 |
895727 | 895727 | 2021-01-04 | Bay | Michigan | 26017 | 6411 | 193 |
892480 | 892480 | 2021-01-03 | Bay | Michigan | 26017 | 6358 | 193 |
889234 | 889234 | 2021-01-02 | Bay | Michigan | 26017 | 6358 | 193 |
885988 | 885988 | 2021-01-01 | Bay | Michigan | 26017 | 6219 | 187 |
882743 | 882743 | 2020-12-31 | Bay | Michigan | 26017 | 6219 | 187 |
879498 | 879498 | 2020-12-30 | Bay | Michigan | 26017 | 6219 | 187 |
876253 | 876253 | 2020-12-29 | Bay | Michigan | 26017 | 6163 | 186 |
873008 | 873008 | 2020-12-28 | Bay | Michigan | 26017 | 6122 | 180 |
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);