ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26049 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278810 | 1278810 | 2021-05-02 | Genesee | Michigan | 26049 | 39733 | 871 |
1275563 | 1275563 | 2021-05-01 | Genesee | Michigan | 26049 | 39733 | 871 |
1272316 | 1272316 | 2021-04-30 | Genesee | Michigan | 26049 | 39590 | 869 |
1269069 | 1269069 | 2021-04-29 | Genesee | Michigan | 26049 | 39394 | 867 |
1265822 | 1265822 | 2021-04-28 | Genesee | Michigan | 26049 | 39178 | 860 |
1262575 | 1262575 | 2021-04-27 | Genesee | Michigan | 26049 | 38927 | 856 |
1259328 | 1259328 | 2021-04-26 | Genesee | Michigan | 26049 | 38720 | 853 |
1256081 | 1256081 | 2021-04-25 | Genesee | Michigan | 26049 | 38385 | 850 |
1252834 | 1252834 | 2021-04-24 | Genesee | Michigan | 26049 | 38385 | 850 |
1249587 | 1249587 | 2021-04-23 | Genesee | Michigan | 26049 | 38209 | 845 |
1246340 | 1246340 | 2021-04-22 | Genesee | Michigan | 26049 | 37926 | 842 |
1243093 | 1243093 | 2021-04-21 | Genesee | Michigan | 26049 | 37620 | 837 |
1239846 | 1239846 | 2021-04-20 | Genesee | Michigan | 26049 | 37296 | 836 |
1236599 | 1236599 | 2021-04-19 | Genesee | Michigan | 26049 | 36957 | 827 |
1233352 | 1233352 | 2021-04-18 | Genesee | Michigan | 26049 | 36499 | 824 |
1230104 | 1230104 | 2021-04-17 | Genesee | Michigan | 26049 | 36499 | 824 |
1226856 | 1226856 | 2021-04-16 | Genesee | Michigan | 26049 | 36248 | 819 |
1223608 | 1223608 | 2021-04-15 | Genesee | Michigan | 26049 | 35662 | 816 |
1220361 | 1220361 | 2021-04-14 | Genesee | Michigan | 26049 | 35259 | 811 |
1217113 | 1217113 | 2021-04-13 | Genesee | Michigan | 26049 | 34852 | 808 |
1213866 | 1213866 | 2021-04-12 | Genesee | Michigan | 26049 | 34423 | 806 |
1210618 | 1210618 | 2021-04-11 | Genesee | Michigan | 26049 | 33864 | 805 |
1207369 | 1207369 | 2021-04-10 | Genesee | Michigan | 26049 | 33864 | 805 |
1204121 | 1204121 | 2021-04-09 | Genesee | Michigan | 26049 | 33541 | 797 |
1200873 | 1200873 | 2021-04-08 | Genesee | Michigan | 26049 | 33033 | 797 |
1197624 | 1197624 | 2021-04-07 | Genesee | Michigan | 26049 | 32555 | 792 |
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 |
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);