ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Monroe" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054806 | 1054806 | 2021-02-22 | Monroe | Michigan | 26115 | 9639 | 198 |
1051559 | 1051559 | 2021-02-21 | Monroe | Michigan | 26115 | 9614 | 198 |
1048312 | 1048312 | 2021-02-20 | Monroe | Michigan | 26115 | 9614 | 198 |
1045066 | 1045066 | 2021-02-19 | Monroe | Michigan | 26115 | 9600 | 198 |
1041821 | 1041821 | 2021-02-18 | Monroe | Michigan | 26115 | 9567 | 198 |
1038576 | 1038576 | 2021-02-17 | Monroe | Michigan | 26115 | 9561 | 197 |
1035331 | 1035331 | 2021-02-16 | Monroe | Michigan | 26115 | 9533 | 197 |
1032086 | 1032086 | 2021-02-15 | Monroe | Michigan | 26115 | 9516 | 195 |
1028839 | 1028839 | 2021-02-14 | Monroe | Michigan | 26115 | 9490 | 195 |
1025593 | 1025593 | 2021-02-13 | Monroe | Michigan | 26115 | 9490 | 195 |
1022348 | 1022348 | 2021-02-12 | Monroe | Michigan | 26115 | 9479 | 192 |
1019103 | 1019103 | 2021-02-11 | Monroe | Michigan | 26115 | 9464 | 192 |
1015858 | 1015858 | 2021-02-10 | Monroe | Michigan | 26115 | 9423 | 187 |
1012613 | 1012613 | 2021-02-09 | Monroe | Michigan | 26115 | 9405 | 187 |
1009368 | 1009368 | 2021-02-08 | Monroe | Michigan | 26115 | 9384 | 187 |
1006121 | 1006121 | 2021-02-07 | Monroe | Michigan | 26115 | 9345 | 187 |
1002875 | 1002875 | 2021-02-06 | Monroe | Michigan | 26115 | 9345 | 187 |
999630 | 999630 | 2021-02-05 | Monroe | Michigan | 26115 | 9328 | 185 |
996384 | 996384 | 2021-02-04 | Monroe | Michigan | 26115 | 9305 | 185 |
993138 | 993138 | 2021-02-03 | Monroe | Michigan | 26115 | 9279 | 184 |
989892 | 989892 | 2021-02-02 | Monroe | Michigan | 26115 | 9249 | 183 |
986645 | 986645 | 2021-02-01 | Monroe | Michigan | 26115 | 9220 | 182 |
983398 | 983398 | 2021-01-31 | Monroe | Michigan | 26115 | 9168 | 181 |
980152 | 980152 | 2021-01-30 | Monroe | Michigan | 26115 | 9168 | 181 |
976906 | 976906 | 2021-01-29 | Monroe | Michigan | 26115 | 9135 | 181 |
973661 | 973661 | 2021-01-28 | Monroe | Michigan | 26115 | 9097 | 181 |
970416 | 970416 | 2021-01-27 | Monroe | Michigan | 26115 | 9044 | 180 |
967171 | 967171 | 2021-01-26 | Monroe | Michigan | 26115 | 9004 | 179 |
963927 | 963927 | 2021-01-25 | Monroe | Michigan | 26115 | 8959 | 176 |
960682 | 960682 | 2021-01-24 | Monroe | Michigan | 26115 | 8909 | 176 |
957436 | 957436 | 2021-01-23 | Monroe | Michigan | 26115 | 8909 | 176 |
954191 | 954191 | 2021-01-22 | Monroe | Michigan | 26115 | 8876 | 173 |
950946 | 950946 | 2021-01-21 | Monroe | Michigan | 26115 | 8825 | 171 |
947700 | 947700 | 2021-01-20 | Monroe | Michigan | 26115 | 8774 | 172 |
944453 | 944453 | 2021-01-19 | Monroe | Michigan | 26115 | 8722 | 173 |
941208 | 941208 | 2021-01-18 | Monroe | Michigan | 26115 | 8690 | 173 |
937963 | 937963 | 2021-01-17 | Monroe | Michigan | 26115 | 8603 | 174 |
934718 | 934718 | 2021-01-16 | Monroe | Michigan | 26115 | 8603 | 174 |
931473 | 931473 | 2021-01-15 | Monroe | Michigan | 26115 | 8570 | 173 |
928228 | 928228 | 2021-01-14 | Monroe | Michigan | 26115 | 8522 | 173 |
924982 | 924982 | 2021-01-13 | Monroe | Michigan | 26115 | 8456 | 172 |
921737 | 921737 | 2021-01-12 | Monroe | Michigan | 26115 | 8384 | 172 |
918492 | 918492 | 2021-01-11 | Monroe | Michigan | 26115 | 8325 | 170 |
915247 | 915247 | 2021-01-10 | Monroe | Michigan | 26115 | 8249 | 167 |
912002 | 912002 | 2021-01-09 | Monroe | Michigan | 26115 | 8249 | 167 |
908757 | 908757 | 2021-01-08 | Monroe | Michigan | 26115 | 8195 | 165 |
905511 | 905511 | 2021-01-07 | Monroe | Michigan | 26115 | 8147 | 164 |
902266 | 902266 | 2021-01-06 | Monroe | Michigan | 26115 | 8099 | 159 |
899021 | 899021 | 2021-01-05 | Monroe | Michigan | 26115 | 7992 | 160 |
895776 | 895776 | 2021-01-04 | Monroe | Michigan | 26115 | 7912 | 156 |
892529 | 892529 | 2021-01-03 | Monroe | Michigan | 26115 | 7808 | 154 |
889283 | 889283 | 2021-01-02 | Monroe | Michigan | 26115 | 7808 | 154 |
886037 | 886037 | 2021-01-01 | Monroe | Michigan | 26115 | 7595 | 149 |
882792 | 882792 | 2020-12-31 | Monroe | Michigan | 26115 | 7595 | 149 |
879547 | 879547 | 2020-12-30 | Monroe | Michigan | 26115 | 7595 | 149 |
876302 | 876302 | 2020-12-29 | Monroe | Michigan | 26115 | 7535 | 147 |
873057 | 873057 | 2020-12-28 | Monroe | Michigan | 26115 | 7471 | 139 |
869812 | 869812 | 2020-12-27 | Monroe | Michigan | 26115 | 7412 | 139 |
866567 | 866567 | 2020-12-26 | Monroe | Michigan | 26115 | 7412 | 139 |
863322 | 863322 | 2020-12-25 | Monroe | Michigan | 26115 | 7324 | 136 |
860077 | 860077 | 2020-12-24 | Monroe | Michigan | 26115 | 7324 | 136 |
856832 | 856832 | 2020-12-23 | Monroe | Michigan | 26115 | 7324 | 136 |
853587 | 853587 | 2020-12-22 | Monroe | Michigan | 26115 | 7259 | 134 |
850342 | 850342 | 2020-12-21 | Monroe | Michigan | 26115 | 7210 | 132 |
847097 | 847097 | 2020-12-20 | Monroe | Michigan | 26115 | 7105 | 130 |
843851 | 843851 | 2020-12-19 | Monroe | Michigan | 26115 | 7105 | 130 |
840606 | 840606 | 2020-12-18 | Monroe | Michigan | 26115 | 7057 | 123 |
837361 | 837361 | 2020-12-17 | Monroe | Michigan | 26115 | 6984 | 122 |
834115 | 834115 | 2020-12-16 | Monroe | Michigan | 26115 | 6924 | 122 |
830868 | 830868 | 2020-12-15 | Monroe | Michigan | 26115 | 6867 | 120 |
827622 | 827622 | 2020-12-14 | Monroe | Michigan | 26115 | 6787 | 117 |
824375 | 824375 | 2020-12-13 | Monroe | Michigan | 26115 | 6645 | 116 |
821129 | 821129 | 2020-12-12 | Monroe | Michigan | 26115 | 6645 | 116 |
817883 | 817883 | 2020-12-11 | Monroe | Michigan | 26115 | 6548 | 115 |
814637 | 814637 | 2020-12-10 | Monroe | Michigan | 26115 | 6458 | 114 |
811392 | 811392 | 2020-12-09 | Monroe | Michigan | 26115 | 6375 | 110 |
808147 | 808147 | 2020-12-08 | Monroe | Michigan | 26115 | 6301 | 104 |
804902 | 804902 | 2020-12-07 | Monroe | Michigan | 26115 | 6134 | 98 |
801657 | 801657 | 2020-12-06 | Monroe | Michigan | 26115 | 5976 | 96 |
798412 | 798412 | 2020-12-05 | Monroe | Michigan | 26115 | 5976 | 96 |
795167 | 795167 | 2020-12-04 | Monroe | Michigan | 26115 | 5859 | 90 |
791922 | 791922 | 2020-12-03 | Monroe | Michigan | 26115 | 5711 | 90 |
788677 | 788677 | 2020-12-02 | Monroe | Michigan | 26115 | 5625 | 87 |
785432 | 785432 | 2020-12-01 | Monroe | Michigan | 26115 | 5530 | 86 |
782188 | 782188 | 2020-11-30 | Monroe | Michigan | 26115 | 5403 | 81 |
778942 | 778942 | 2020-11-29 | Monroe | Michigan | 26115 | 5204 | 76 |
775697 | 775697 | 2020-11-28 | Monroe | Michigan | 26115 | 5204 | 76 |
772452 | 772452 | 2020-11-27 | Monroe | Michigan | 26115 | 5061 | 73 |
769207 | 769207 | 2020-11-26 | Monroe | Michigan | 26115 | 4808 | 68 |
765961 | 765961 | 2020-11-25 | Monroe | Michigan | 26115 | 4808 | 68 |
762716 | 762716 | 2020-11-24 | Monroe | Michigan | 26115 | 4740 | 66 |
759471 | 759471 | 2020-11-23 | Monroe | Michigan | 26115 | 4504 | 61 |
756224 | 756224 | 2020-11-22 | Monroe | Michigan | 26115 | 4351 | 60 |
752978 | 752978 | 2020-11-21 | Monroe | Michigan | 26115 | 4351 | 60 |
749732 | 749732 | 2020-11-20 | Monroe | Michigan | 26115 | 4217 | 56 |
746486 | 746486 | 2020-11-19 | Monroe | Michigan | 26115 | 4056 | 56 |
743239 | 743239 | 2020-11-18 | Monroe | Michigan | 26115 | 3892 | 55 |
739992 | 739992 | 2020-11-17 | Monroe | Michigan | 26115 | 3754 | 55 |
736748 | 736748 | 2020-11-16 | Monroe | Michigan | 26115 | 3612 | 53 |
733502 | 733502 | 2020-11-15 | Monroe | Michigan | 26115 | 3452 | 51 |
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);