ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Wexford" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054832 | 1054832 | 2021-02-22 | Wexford | Michigan | 26165 | 1418 | 20 |
1051585 | 1051585 | 2021-02-21 | Wexford | Michigan | 26165 | 1422 | 20 |
1048338 | 1048338 | 2021-02-20 | Wexford | Michigan | 26165 | 1422 | 20 |
1045092 | 1045092 | 2021-02-19 | Wexford | Michigan | 26165 | 1422 | 20 |
1041847 | 1041847 | 2021-02-18 | Wexford | Michigan | 26165 | 1420 | 20 |
1038602 | 1038602 | 2021-02-17 | Wexford | Michigan | 26165 | 1414 | 20 |
1035357 | 1035357 | 2021-02-16 | Wexford | Michigan | 26165 | 1412 | 20 |
1032112 | 1032112 | 2021-02-15 | Wexford | Michigan | 26165 | 1403 | 20 |
1028865 | 1028865 | 2021-02-14 | Wexford | Michigan | 26165 | 1393 | 20 |
1025619 | 1025619 | 2021-02-13 | Wexford | Michigan | 26165 | 1393 | 20 |
1022374 | 1022374 | 2021-02-12 | Wexford | Michigan | 26165 | 1393 | 20 |
1019129 | 1019129 | 2021-02-11 | Wexford | Michigan | 26165 | 1372 | 20 |
1015884 | 1015884 | 2021-02-10 | Wexford | Michigan | 26165 | 1363 | 20 |
1012639 | 1012639 | 2021-02-09 | Wexford | Michigan | 26165 | 1357 | 20 |
1009394 | 1009394 | 2021-02-08 | Wexford | Michigan | 26165 | 1350 | 20 |
1006147 | 1006147 | 2021-02-07 | Wexford | Michigan | 26165 | 1345 | 20 |
1002901 | 1002901 | 2021-02-06 | Wexford | Michigan | 26165 | 1345 | 20 |
999656 | 999656 | 2021-02-05 | Wexford | Michigan | 26165 | 1345 | 20 |
996410 | 996410 | 2021-02-04 | Wexford | Michigan | 26165 | 1344 | 20 |
993164 | 993164 | 2021-02-03 | Wexford | Michigan | 26165 | 1335 | 20 |
989918 | 989918 | 2021-02-02 | Wexford | Michigan | 26165 | 1327 | 20 |
986671 | 986671 | 2021-02-01 | Wexford | Michigan | 26165 | 1322 | 20 |
983424 | 983424 | 2021-01-31 | Wexford | Michigan | 26165 | 1303 | 20 |
980178 | 980178 | 2021-01-30 | Wexford | Michigan | 26165 | 1303 | 20 |
976932 | 976932 | 2021-01-29 | Wexford | Michigan | 26165 | 1303 | 20 |
973687 | 973687 | 2021-01-28 | Wexford | Michigan | 26165 | 1297 | 20 |
970442 | 970442 | 2021-01-27 | Wexford | Michigan | 26165 | 1284 | 20 |
967197 | 967197 | 2021-01-26 | Wexford | Michigan | 26165 | 1267 | 20 |
963953 | 963953 | 2021-01-25 | Wexford | Michigan | 26165 | 1255 | 19 |
960708 | 960708 | 2021-01-24 | Wexford | Michigan | 26165 | 1234 | 19 |
957462 | 957462 | 2021-01-23 | Wexford | Michigan | 26165 | 1234 | 19 |
954217 | 954217 | 2021-01-22 | Wexford | Michigan | 26165 | 1232 | 19 |
950972 | 950972 | 2021-01-21 | Wexford | Michigan | 26165 | 1216 | 20 |
947726 | 947726 | 2021-01-20 | Wexford | Michigan | 26165 | 1211 | 20 |
944479 | 944479 | 2021-01-19 | Wexford | Michigan | 26165 | 1204 | 20 |
941234 | 941234 | 2021-01-18 | Wexford | Michigan | 26165 | 1198 | 20 |
937989 | 937989 | 2021-01-17 | Wexford | Michigan | 26165 | 1167 | 20 |
934744 | 934744 | 2021-01-16 | Wexford | Michigan | 26165 | 1167 | 20 |
931499 | 931499 | 2021-01-15 | Wexford | Michigan | 26165 | 1167 | 20 |
928254 | 928254 | 2021-01-14 | Wexford | Michigan | 26165 | 1154 | 20 |
925008 | 925008 | 2021-01-13 | Wexford | Michigan | 26165 | 1134 | 20 |
921763 | 921763 | 2021-01-12 | Wexford | Michigan | 26165 | 1126 | 20 |
918518 | 918518 | 2021-01-11 | Wexford | Michigan | 26165 | 1123 | 20 |
915273 | 915273 | 2021-01-10 | Wexford | Michigan | 26165 | 1095 | 20 |
912028 | 912028 | 2021-01-09 | Wexford | Michigan | 26165 | 1095 | 20 |
908783 | 908783 | 2021-01-08 | Wexford | Michigan | 26165 | 1095 | 20 |
905537 | 905537 | 2021-01-07 | Wexford | Michigan | 26165 | 1084 | 20 |
902292 | 902292 | 2021-01-06 | Wexford | Michigan | 26165 | 1063 | 20 |
899047 | 899047 | 2021-01-05 | Wexford | Michigan | 26165 | 1040 | 20 |
895802 | 895802 | 2021-01-04 | Wexford | Michigan | 26165 | 1030 | 20 |
892555 | 892555 | 2021-01-03 | Wexford | Michigan | 26165 | 1012 | 20 |
889309 | 889309 | 2021-01-02 | Wexford | Michigan | 26165 | 1012 | 20 |
886063 | 886063 | 2021-01-01 | Wexford | Michigan | 26165 | 994 | 18 |
882818 | 882818 | 2020-12-31 | Wexford | Michigan | 26165 | 994 | 18 |
879573 | 879573 | 2020-12-30 | Wexford | Michigan | 26165 | 994 | 18 |
876328 | 876328 | 2020-12-29 | Wexford | Michigan | 26165 | 990 | 18 |
873083 | 873083 | 2020-12-28 | Wexford | Michigan | 26165 | 977 | 18 |
869838 | 869838 | 2020-12-27 | Wexford | Michigan | 26165 | 971 | 17 |
866593 | 866593 | 2020-12-26 | Wexford | Michigan | 26165 | 971 | 17 |
863348 | 863348 | 2020-12-25 | Wexford | Michigan | 26165 | 968 | 17 |
860103 | 860103 | 2020-12-24 | Wexford | Michigan | 26165 | 968 | 17 |
856858 | 856858 | 2020-12-23 | Wexford | Michigan | 26165 | 968 | 17 |
853613 | 853613 | 2020-12-22 | Wexford | Michigan | 26165 | 961 | 17 |
850368 | 850368 | 2020-12-21 | Wexford | Michigan | 26165 | 947 | 16 |
847123 | 847123 | 2020-12-20 | Wexford | Michigan | 26165 | 940 | 16 |
843877 | 843877 | 2020-12-19 | Wexford | Michigan | 26165 | 940 | 16 |
840632 | 840632 | 2020-12-18 | Wexford | Michigan | 26165 | 932 | 16 |
837387 | 837387 | 2020-12-17 | Wexford | Michigan | 26165 | 915 | 16 |
834141 | 834141 | 2020-12-16 | Wexford | Michigan | 26165 | 896 | 16 |
830894 | 830894 | 2020-12-15 | Wexford | Michigan | 26165 | 881 | 16 |
827648 | 827648 | 2020-12-14 | Wexford | Michigan | 26165 | 868 | 16 |
824401 | 824401 | 2020-12-13 | Wexford | Michigan | 26165 | 851 | 16 |
821155 | 821155 | 2020-12-12 | Wexford | Michigan | 26165 | 851 | 16 |
817909 | 817909 | 2020-12-11 | Wexford | Michigan | 26165 | 841 | 16 |
814663 | 814663 | 2020-12-10 | Wexford | Michigan | 26165 | 811 | 16 |
811418 | 811418 | 2020-12-09 | Wexford | Michigan | 26165 | 800 | 18 |
808173 | 808173 | 2020-12-08 | Wexford | Michigan | 26165 | 784 | 18 |
804928 | 804928 | 2020-12-07 | Wexford | Michigan | 26165 | 772 | 18 |
801683 | 801683 | 2020-12-06 | Wexford | Michigan | 26165 | 748 | 18 |
798438 | 798438 | 2020-12-05 | Wexford | Michigan | 26165 | 748 | 18 |
795193 | 795193 | 2020-12-04 | Wexford | Michigan | 26165 | 737 | 18 |
791948 | 791948 | 2020-12-03 | Wexford | Michigan | 26165 | 713 | 16 |
788703 | 788703 | 2020-12-02 | Wexford | Michigan | 26165 | 706 | 16 |
785458 | 785458 | 2020-12-01 | Wexford | Michigan | 26165 | 686 | 15 |
782214 | 782214 | 2020-11-30 | Wexford | Michigan | 26165 | 670 | 13 |
778968 | 778968 | 2020-11-29 | Wexford | Michigan | 26165 | 617 | 13 |
775723 | 775723 | 2020-11-28 | Wexford | Michigan | 26165 | 617 | 13 |
772478 | 772478 | 2020-11-27 | Wexford | Michigan | 26165 | 608 | 13 |
769233 | 769233 | 2020-11-26 | Wexford | Michigan | 26165 | 557 | 13 |
765987 | 765987 | 2020-11-25 | Wexford | Michigan | 26165 | 557 | 13 |
762742 | 762742 | 2020-11-24 | Wexford | Michigan | 26165 | 541 | 13 |
759497 | 759497 | 2020-11-23 | Wexford | Michigan | 26165 | 529 | 13 |
756250 | 756250 | 2020-11-22 | Wexford | Michigan | 26165 | 471 | 12 |
753004 | 753004 | 2020-11-21 | Wexford | Michigan | 26165 | 471 | 12 |
749758 | 749758 | 2020-11-20 | Wexford | Michigan | 26165 | 465 | 12 |
746512 | 746512 | 2020-11-19 | Wexford | Michigan | 26165 | 449 | 12 |
743265 | 743265 | 2020-11-18 | Wexford | Michigan | 26165 | 432 | 11 |
740018 | 740018 | 2020-11-17 | Wexford | Michigan | 26165 | 421 | 11 |
736774 | 736774 | 2020-11-16 | Wexford | Michigan | 26165 | 402 | 11 |
733528 | 733528 | 2020-11-15 | Wexford | Michigan | 26165 | 341 | 7 |
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);