ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Genesee" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194375 | 1194375 | 2021-04-06 | Genesee | Michigan | 26049 | 32130 | 789 |
1191126 | 1191126 | 2021-04-05 | Genesee | Michigan | 26049 | 31888 | 787 |
1187878 | 1187878 | 2021-04-04 | Genesee | Michigan | 26049 | 31410 | 787 |
1184631 | 1184631 | 2021-04-03 | Genesee | Michigan | 26049 | 31410 | 787 |
1181385 | 1181385 | 2021-04-02 | Genesee | Michigan | 26049 | 31028 | 783 |
1178138 | 1178138 | 2021-04-01 | Genesee | Michigan | 26049 | 30727 | 783 |
1174891 | 1174891 | 2021-03-31 | Genesee | Michigan | 26049 | 30311 | 779 |
1171644 | 1171644 | 2021-03-30 | Genesee | Michigan | 26049 | 29985 | 779 |
1168396 | 1168396 | 2021-03-29 | Genesee | Michigan | 26049 | 29742 | 774 |
1165148 | 1165148 | 2021-03-28 | Genesee | Michigan | 26049 | 29401 | 774 |
1161900 | 1161900 | 2021-03-27 | Genesee | Michigan | 26049 | 29401 | 774 |
1158652 | 1158652 | 2021-03-26 | Genesee | Michigan | 26049 | 29055 | 774 |
1155405 | 1155405 | 2021-03-25 | Genesee | Michigan | 26049 | 28745 | 774 |
1152158 | 1152158 | 2021-03-24 | Genesee | Michigan | 26049 | 28466 | 772 |
1148911 | 1148911 | 2021-03-23 | Genesee | Michigan | 26049 | 28248 | 770 |
1145664 | 1145664 | 2021-03-22 | Genesee | Michigan | 26049 | 28035 | 768 |
1142417 | 1142417 | 2021-03-21 | Genesee | Michigan | 26049 | 27796 | 768 |
1139170 | 1139170 | 2021-03-20 | Genesee | Michigan | 26049 | 27796 | 768 |
1135924 | 1135924 | 2021-03-19 | Genesee | Michigan | 26049 | 27628 | 767 |
1132678 | 1132678 | 2021-03-18 | Genesee | Michigan | 26049 | 27421 | 766 |
1129430 | 1129430 | 2021-03-17 | Genesee | Michigan | 26049 | 27257 | 765 |
1126183 | 1126183 | 2021-03-16 | Genesee | Michigan | 26049 | 27117 | 764 |
1122937 | 1122937 | 2021-03-15 | Genesee | Michigan | 26049 | 26979 | 762 |
1119690 | 1119690 | 2021-03-14 | Genesee | Michigan | 26049 | 26806 | 762 |
1116443 | 1116443 | 2021-03-13 | Genesee | Michigan | 26049 | 26806 | 762 |
1113197 | 1113197 | 2021-03-12 | Genesee | Michigan | 26049 | 26681 | 761 |
1109951 | 1109951 | 2021-03-11 | Genesee | Michigan | 26049 | 26528 | 760 |
1106705 | 1106705 | 2021-03-10 | Genesee | Michigan | 26049 | 26409 | 759 |
1103459 | 1103459 | 2021-03-09 | Genesee | Michigan | 26049 | 26276 | 759 |
1100213 | 1100213 | 2021-03-08 | Genesee | Michigan | 26049 | 26204 | 757 |
1096966 | 1096966 | 2021-03-07 | Genesee | Michigan | 26049 | 26111 | 757 |
1093719 | 1093719 | 2021-03-06 | Genesee | Michigan | 26049 | 26111 | 757 |
1090473 | 1090473 | 2021-03-05 | Genesee | Michigan | 26049 | 26041 | 756 |
1087228 | 1087228 | 2021-03-04 | Genesee | Michigan | 26049 | 25937 | 756 |
1083983 | 1083983 | 2021-03-03 | Genesee | Michigan | 26049 | 25834 | 755 |
1080737 | 1080737 | 2021-03-02 | Genesee | Michigan | 26049 | 25753 | 755 |
1077491 | 1077491 | 2021-03-01 | Genesee | Michigan | 26049 | 25656 | 754 |
1074245 | 1074245 | 2021-02-28 | Genesee | Michigan | 26049 | 25546 | 754 |
1070999 | 1070999 | 2021-02-27 | Genesee | Michigan | 26049 | 25546 | 754 |
1067754 | 1067754 | 2021-02-26 | Genesee | Michigan | 26049 | 25487 | 752 |
1064509 | 1064509 | 2021-02-25 | Genesee | Michigan | 26049 | 25410 | 752 |
1061265 | 1061265 | 2021-02-24 | Genesee | Michigan | 26049 | 25332 | 750 |
1058019 | 1058019 | 2021-02-23 | Genesee | Michigan | 26049 | 25272 | 750 |
1054773 | 1054773 | 2021-02-22 | Genesee | Michigan | 26049 | 25177 | 750 |
1051526 | 1051526 | 2021-02-21 | Genesee | Michigan | 26049 | 25129 | 750 |
1048279 | 1048279 | 2021-02-20 | Genesee | Michigan | 26049 | 25129 | 750 |
1045033 | 1045033 | 2021-02-19 | Genesee | Michigan | 26049 | 25109 | 746 |
1041788 | 1041788 | 2021-02-18 | Genesee | Michigan | 26049 | 25055 | 746 |
1038543 | 1038543 | 2021-02-17 | Genesee | Michigan | 26049 | 25000 | 744 |
1035298 | 1035298 | 2021-02-16 | Genesee | Michigan | 26049 | 24975 | 744 |
1032053 | 1032053 | 2021-02-15 | Genesee | Michigan | 26049 | 24941 | 742 |
1028806 | 1028806 | 2021-02-14 | Genesee | Michigan | 26049 | 24899 | 741 |
1025560 | 1025560 | 2021-02-13 | Genesee | Michigan | 26049 | 24899 | 741 |
1022315 | 1022315 | 2021-02-12 | Genesee | Michigan | 26049 | 24863 | 737 |
1019070 | 1019070 | 2021-02-11 | Genesee | Michigan | 26049 | 24815 | 737 |
1015825 | 1015825 | 2021-02-10 | Genesee | Michigan | 26049 | 24776 | 737 |
1012580 | 1012580 | 2021-02-09 | Genesee | Michigan | 26049 | 24732 | 736 |
1009335 | 1009335 | 2021-02-08 | Genesee | Michigan | 26049 | 24720 | 733 |
1006088 | 1006088 | 2021-02-07 | Genesee | Michigan | 26049 | 24651 | 734 |
1002842 | 1002842 | 2021-02-06 | Genesee | Michigan | 26049 | 24651 | 734 |
999597 | 999597 | 2021-02-05 | Genesee | Michigan | 26049 | 24621 | 732 |
996351 | 996351 | 2021-02-04 | Genesee | Michigan | 26049 | 24565 | 732 |
993105 | 993105 | 2021-02-03 | Genesee | Michigan | 26049 | 24486 | 731 |
989859 | 989859 | 2021-02-02 | Genesee | Michigan | 26049 | 24445 | 729 |
986612 | 986612 | 2021-02-01 | Genesee | Michigan | 26049 | 24391 | 728 |
983365 | 983365 | 2021-01-31 | Genesee | Michigan | 26049 | 24327 | 728 |
980119 | 980119 | 2021-01-30 | Genesee | Michigan | 26049 | 24327 | 728 |
976873 | 976873 | 2021-01-29 | Genesee | Michigan | 26049 | 24288 | 722 |
973628 | 973628 | 2021-01-28 | Genesee | Michigan | 26049 | 24250 | 722 |
970383 | 970383 | 2021-01-27 | Genesee | Michigan | 26049 | 24198 | 719 |
967138 | 967138 | 2021-01-26 | Genesee | Michigan | 26049 | 24150 | 717 |
963894 | 963894 | 2021-01-25 | Genesee | Michigan | 26049 | 24094 | 708 |
960649 | 960649 | 2021-01-24 | Genesee | Michigan | 26049 | 23981 | 704 |
957403 | 957403 | 2021-01-23 | Genesee | Michigan | 26049 | 23981 | 704 |
954158 | 954158 | 2021-01-22 | Genesee | Michigan | 26049 | 23916 | 690 |
950913 | 950913 | 2021-01-21 | Genesee | Michigan | 26049 | 23839 | 689 |
947667 | 947667 | 2021-01-20 | Genesee | Michigan | 26049 | 23760 | 686 |
944420 | 944420 | 2021-01-19 | Genesee | Michigan | 26049 | 23673 | 684 |
941175 | 941175 | 2021-01-18 | Genesee | Michigan | 26049 | 23602 | 684 |
937930 | 937930 | 2021-01-17 | Genesee | Michigan | 26049 | 23473 | 684 |
934685 | 934685 | 2021-01-16 | Genesee | Michigan | 26049 | 23473 | 684 |
931440 | 931440 | 2021-01-15 | Genesee | Michigan | 26049 | 23383 | 681 |
928195 | 928195 | 2021-01-14 | Genesee | Michigan | 26049 | 23234 | 675 |
924949 | 924949 | 2021-01-13 | Genesee | Michigan | 26049 | 23127 | 664 |
921704 | 921704 | 2021-01-12 | Genesee | Michigan | 26049 | 23009 | 658 |
918459 | 918459 | 2021-01-11 | Genesee | Michigan | 26049 | 22896 | 650 |
915214 | 915214 | 2021-01-10 | Genesee | Michigan | 26049 | 22643 | 648 |
911969 | 911969 | 2021-01-09 | Genesee | Michigan | 26049 | 22643 | 648 |
908724 | 908724 | 2021-01-08 | Genesee | Michigan | 26049 | 22511 | 644 |
905478 | 905478 | 2021-01-07 | Genesee | Michigan | 26049 | 22398 | 644 |
902233 | 902233 | 2021-01-06 | Genesee | Michigan | 26049 | 22270 | 637 |
898988 | 898988 | 2021-01-05 | Genesee | Michigan | 26049 | 22100 | 628 |
895743 | 895743 | 2021-01-04 | Genesee | Michigan | 26049 | 22003 | 616 |
892496 | 892496 | 2021-01-03 | Genesee | Michigan | 26049 | 21821 | 611 |
889250 | 889250 | 2021-01-02 | Genesee | Michigan | 26049 | 21821 | 611 |
886004 | 886004 | 2021-01-01 | Genesee | Michigan | 26049 | 21619 | 596 |
882759 | 882759 | 2020-12-31 | Genesee | Michigan | 26049 | 21619 | 596 |
879514 | 879514 | 2020-12-30 | Genesee | Michigan | 26049 | 21619 | 596 |
876269 | 876269 | 2020-12-29 | Genesee | Michigan | 26049 | 21479 | 591 |
873024 | 873024 | 2020-12-28 | Genesee | Michigan | 26049 | 21306 | 585 |
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);