ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Mackinac" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194399 | 1194399 | 2021-04-06 | Mackinac | Michigan | 26097 | 502 | 3 |
1191150 | 1191150 | 2021-04-05 | Mackinac | Michigan | 26097 | 497 | 3 |
1187902 | 1187902 | 2021-04-04 | Mackinac | Michigan | 26097 | 494 | 3 |
1184655 | 1184655 | 2021-04-03 | Mackinac | Michigan | 26097 | 494 | 3 |
1181409 | 1181409 | 2021-04-02 | Mackinac | Michigan | 26097 | 491 | 3 |
1178162 | 1178162 | 2021-04-01 | Mackinac | Michigan | 26097 | 490 | 3 |
1174915 | 1174915 | 2021-03-31 | Mackinac | Michigan | 26097 | 488 | 3 |
1171668 | 1171668 | 2021-03-30 | Mackinac | Michigan | 26097 | 485 | 3 |
1168420 | 1168420 | 2021-03-29 | Mackinac | Michigan | 26097 | 485 | 3 |
1165172 | 1165172 | 2021-03-28 | Mackinac | Michigan | 26097 | 480 | 3 |
1161924 | 1161924 | 2021-03-27 | Mackinac | Michigan | 26097 | 480 | 3 |
1158676 | 1158676 | 2021-03-26 | Mackinac | Michigan | 26097 | 478 | 3 |
1155429 | 1155429 | 2021-03-25 | Mackinac | Michigan | 26097 | 475 | 3 |
1152182 | 1152182 | 2021-03-24 | Mackinac | Michigan | 26097 | 473 | 3 |
1148935 | 1148935 | 2021-03-23 | Mackinac | Michigan | 26097 | 470 | 3 |
1145688 | 1145688 | 2021-03-22 | Mackinac | Michigan | 26097 | 468 | 3 |
1142441 | 1142441 | 2021-03-21 | Mackinac | Michigan | 26097 | 466 | 3 |
1139194 | 1139194 | 2021-03-20 | Mackinac | Michigan | 26097 | 466 | 3 |
1135948 | 1135948 | 2021-03-19 | Mackinac | Michigan | 26097 | 459 | 3 |
1132702 | 1132702 | 2021-03-18 | Mackinac | Michigan | 26097 | 453 | 3 |
1129454 | 1129454 | 2021-03-17 | Mackinac | Michigan | 26097 | 453 | 3 |
1126207 | 1126207 | 2021-03-16 | Mackinac | Michigan | 26097 | 453 | 3 |
1122961 | 1122961 | 2021-03-15 | Mackinac | Michigan | 26097 | 450 | 3 |
1119714 | 1119714 | 2021-03-14 | Mackinac | Michigan | 26097 | 450 | 3 |
1116467 | 1116467 | 2021-03-13 | Mackinac | Michigan | 26097 | 450 | 3 |
1113221 | 1113221 | 2021-03-12 | Mackinac | Michigan | 26097 | 450 | 3 |
1109975 | 1109975 | 2021-03-11 | Mackinac | Michigan | 26097 | 450 | 3 |
1106729 | 1106729 | 2021-03-10 | Mackinac | Michigan | 26097 | 449 | 3 |
1103483 | 1103483 | 2021-03-09 | Mackinac | Michigan | 26097 | 449 | 3 |
1100237 | 1100237 | 2021-03-08 | Mackinac | Michigan | 26097 | 448 | 3 |
1096990 | 1096990 | 2021-03-07 | Mackinac | Michigan | 26097 | 448 | 3 |
1093743 | 1093743 | 2021-03-06 | Mackinac | Michigan | 26097 | 448 | 3 |
1090497 | 1090497 | 2021-03-05 | Mackinac | Michigan | 26097 | 447 | 3 |
1087252 | 1087252 | 2021-03-04 | Mackinac | Michigan | 26097 | 445 | 3 |
1084007 | 1084007 | 2021-03-03 | Mackinac | Michigan | 26097 | 444 | 3 |
1080761 | 1080761 | 2021-03-02 | Mackinac | Michigan | 26097 | 443 | 3 |
1077515 | 1077515 | 2021-03-01 | Mackinac | Michigan | 26097 | 441 | 3 |
1074269 | 1074269 | 2021-02-28 | Mackinac | Michigan | 26097 | 441 | 3 |
1071023 | 1071023 | 2021-02-27 | Mackinac | Michigan | 26097 | 441 | 3 |
1067778 | 1067778 | 2021-02-26 | Mackinac | Michigan | 26097 | 441 | 3 |
1064533 | 1064533 | 2021-02-25 | Mackinac | Michigan | 26097 | 441 | 3 |
1061289 | 1061289 | 2021-02-24 | Mackinac | Michigan | 26097 | 441 | 3 |
1058043 | 1058043 | 2021-02-23 | Mackinac | Michigan | 26097 | 440 | 3 |
1054797 | 1054797 | 2021-02-22 | Mackinac | Michigan | 26097 | 437 | 3 |
1051550 | 1051550 | 2021-02-21 | Mackinac | Michigan | 26097 | 433 | 3 |
1048303 | 1048303 | 2021-02-20 | Mackinac | Michigan | 26097 | 433 | 3 |
1045057 | 1045057 | 2021-02-19 | Mackinac | Michigan | 26097 | 433 | 3 |
1041812 | 1041812 | 2021-02-18 | Mackinac | Michigan | 26097 | 432 | 3 |
1038567 | 1038567 | 2021-02-17 | Mackinac | Michigan | 26097 | 431 | 3 |
1035322 | 1035322 | 2021-02-16 | Mackinac | Michigan | 26097 | 431 | 3 |
1032077 | 1032077 | 2021-02-15 | Mackinac | Michigan | 26097 | 430 | 3 |
1028830 | 1028830 | 2021-02-14 | Mackinac | Michigan | 26097 | 430 | 3 |
1025584 | 1025584 | 2021-02-13 | Mackinac | Michigan | 26097 | 430 | 3 |
1022339 | 1022339 | 2021-02-12 | Mackinac | Michigan | 26097 | 430 | 3 |
1019094 | 1019094 | 2021-02-11 | Mackinac | Michigan | 26097 | 429 | 3 |
1015849 | 1015849 | 2021-02-10 | Mackinac | Michigan | 26097 | 428 | 3 |
1012604 | 1012604 | 2021-02-09 | Mackinac | Michigan | 26097 | 428 | 3 |
1009359 | 1009359 | 2021-02-08 | Mackinac | Michigan | 26097 | 428 | 3 |
1006112 | 1006112 | 2021-02-07 | Mackinac | Michigan | 26097 | 427 | 3 |
1002866 | 1002866 | 2021-02-06 | Mackinac | Michigan | 26097 | 427 | 3 |
999621 | 999621 | 2021-02-05 | Mackinac | Michigan | 26097 | 427 | 3 |
996375 | 996375 | 2021-02-04 | Mackinac | Michigan | 26097 | 425 | 3 |
993129 | 993129 | 2021-02-03 | Mackinac | Michigan | 26097 | 424 | 3 |
989883 | 989883 | 2021-02-02 | Mackinac | Michigan | 26097 | 424 | 3 |
986636 | 986636 | 2021-02-01 | Mackinac | Michigan | 26097 | 422 | 3 |
983389 | 983389 | 2021-01-31 | Mackinac | Michigan | 26097 | 421 | 3 |
980143 | 980143 | 2021-01-30 | Mackinac | Michigan | 26097 | 421 | 3 |
976897 | 976897 | 2021-01-29 | Mackinac | Michigan | 26097 | 421 | 3 |
973652 | 973652 | 2021-01-28 | Mackinac | Michigan | 26097 | 420 | 3 |
970407 | 970407 | 2021-01-27 | Mackinac | Michigan | 26097 | 418 | 3 |
967162 | 967162 | 2021-01-26 | Mackinac | Michigan | 26097 | 418 | 3 |
963918 | 963918 | 2021-01-25 | Mackinac | Michigan | 26097 | 414 | 3 |
960673 | 960673 | 2021-01-24 | Mackinac | Michigan | 26097 | 414 | 3 |
957427 | 957427 | 2021-01-23 | Mackinac | Michigan | 26097 | 414 | 3 |
954182 | 954182 | 2021-01-22 | Mackinac | Michigan | 26097 | 413 | 3 |
950937 | 950937 | 2021-01-21 | Mackinac | Michigan | 26097 | 412 | 3 |
947691 | 947691 | 2021-01-20 | Mackinac | Michigan | 26097 | 411 | 3 |
944444 | 944444 | 2021-01-19 | Mackinac | Michigan | 26097 | 408 | 3 |
941199 | 941199 | 2021-01-18 | Mackinac | Michigan | 26097 | 406 | 3 |
937954 | 937954 | 2021-01-17 | Mackinac | Michigan | 26097 | 402 | 3 |
934709 | 934709 | 2021-01-16 | Mackinac | Michigan | 26097 | 402 | 3 |
931464 | 931464 | 2021-01-15 | Mackinac | Michigan | 26097 | 400 | 3 |
928219 | 928219 | 2021-01-14 | Mackinac | Michigan | 26097 | 400 | 3 |
924973 | 924973 | 2021-01-13 | Mackinac | Michigan | 26097 | 398 | 3 |
921728 | 921728 | 2021-01-12 | Mackinac | Michigan | 26097 | 397 | 3 |
918483 | 918483 | 2021-01-11 | Mackinac | Michigan | 26097 | 397 | 3 |
915238 | 915238 | 2021-01-10 | Mackinac | Michigan | 26097 | 397 | 3 |
911993 | 911993 | 2021-01-09 | Mackinac | Michigan | 26097 | 397 | 3 |
908748 | 908748 | 2021-01-08 | Mackinac | Michigan | 26097 | 396 | 3 |
905502 | 905502 | 2021-01-07 | Mackinac | Michigan | 26097 | 395 | 3 |
902257 | 902257 | 2021-01-06 | Mackinac | Michigan | 26097 | 391 | 3 |
899012 | 899012 | 2021-01-05 | Mackinac | Michigan | 26097 | 387 | 3 |
895767 | 895767 | 2021-01-04 | Mackinac | Michigan | 26097 | 387 | 3 |
892520 | 892520 | 2021-01-03 | Mackinac | Michigan | 26097 | 386 | 2 |
889274 | 889274 | 2021-01-02 | Mackinac | Michigan | 26097 | 386 | 2 |
886028 | 886028 | 2021-01-01 | Mackinac | Michigan | 26097 | 380 | 2 |
882783 | 882783 | 2020-12-31 | Mackinac | Michigan | 26097 | 380 | 2 |
879538 | 879538 | 2020-12-30 | Mackinac | Michigan | 26097 | 380 | 2 |
876293 | 876293 | 2020-12-29 | Mackinac | Michigan | 26097 | 377 | 2 |
873048 | 873048 | 2020-12-28 | Mackinac | Michigan | 26097 | 376 | 2 |
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);