ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 26017 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054757 | 1054757 | 2021-02-22 | Bay | Michigan | 26017 | 7348 | 284 |
1051510 | 1051510 | 2021-02-21 | Bay | Michigan | 26017 | 7331 | 283 |
1048263 | 1048263 | 2021-02-20 | Bay | Michigan | 26017 | 7331 | 283 |
1045017 | 1045017 | 2021-02-19 | Bay | Michigan | 26017 | 7314 | 283 |
1041772 | 1041772 | 2021-02-18 | Bay | Michigan | 26017 | 7295 | 283 |
1038527 | 1038527 | 2021-02-17 | Bay | Michigan | 26017 | 7292 | 281 |
1035282 | 1035282 | 2021-02-16 | Bay | Michigan | 26017 | 7276 | 281 |
1032037 | 1032037 | 2021-02-15 | Bay | Michigan | 26017 | 7271 | 281 |
1028790 | 1028790 | 2021-02-14 | Bay | Michigan | 26017 | 7261 | 281 |
1025544 | 1025544 | 2021-02-13 | Bay | Michigan | 26017 | 7261 | 281 |
1022299 | 1022299 | 2021-02-12 | Bay | Michigan | 26017 | 7252 | 277 |
1019054 | 1019054 | 2021-02-11 | Bay | Michigan | 26017 | 7238 | 277 |
1015809 | 1015809 | 2021-02-10 | Bay | Michigan | 26017 | 7227 | 275 |
1012564 | 1012564 | 2021-02-09 | Bay | Michigan | 26017 | 7211 | 275 |
1009319 | 1009319 | 2021-02-08 | Bay | Michigan | 26017 | 7214 | 274 |
1006072 | 1006072 | 2021-02-07 | Bay | Michigan | 26017 | 7192 | 274 |
1002826 | 1002826 | 2021-02-06 | Bay | Michigan | 26017 | 7192 | 274 |
999581 | 999581 | 2021-02-05 | Bay | Michigan | 26017 | 7178 | 269 |
996335 | 996335 | 2021-02-04 | Bay | Michigan | 26017 | 7167 | 268 |
993089 | 993089 | 2021-02-03 | Bay | Michigan | 26017 | 7156 | 267 |
989843 | 989843 | 2021-02-02 | Bay | Michigan | 26017 | 7132 | 266 |
986596 | 986596 | 2021-02-01 | Bay | Michigan | 26017 | 7126 | 264 |
983349 | 983349 | 2021-01-31 | Bay | Michigan | 26017 | 7097 | 263 |
980103 | 980103 | 2021-01-30 | Bay | Michigan | 26017 | 7097 | 263 |
976857 | 976857 | 2021-01-29 | Bay | Michigan | 26017 | 7074 | 262 |
973612 | 973612 | 2021-01-28 | Bay | Michigan | 26017 | 7044 | 259 |
970367 | 970367 | 2021-01-27 | Bay | Michigan | 26017 | 7025 | 257 |
967122 | 967122 | 2021-01-26 | Bay | Michigan | 26017 | 7011 | 258 |
963878 | 963878 | 2021-01-25 | Bay | Michigan | 26017 | 7000 | 253 |
960633 | 960633 | 2021-01-24 | Bay | Michigan | 26017 | 6984 | 253 |
957387 | 957387 | 2021-01-23 | Bay | Michigan | 26017 | 6984 | 253 |
954142 | 954142 | 2021-01-22 | Bay | Michigan | 26017 | 6971 | 246 |
950897 | 950897 | 2021-01-21 | Bay | Michigan | 26017 | 6941 | 246 |
947651 | 947651 | 2021-01-20 | Bay | Michigan | 26017 | 6917 | 240 |
944404 | 944404 | 2021-01-19 | Bay | Michigan | 26017 | 6895 | 236 |
941159 | 941159 | 2021-01-18 | Bay | Michigan | 26017 | 6881 | 236 |
937914 | 937914 | 2021-01-17 | Bay | Michigan | 26017 | 6845 | 236 |
934669 | 934669 | 2021-01-16 | Bay | Michigan | 26017 | 6845 | 236 |
931424 | 931424 | 2021-01-15 | Bay | Michigan | 26017 | 6814 | 230 |
928179 | 928179 | 2021-01-14 | Bay | Michigan | 26017 | 6793 | 230 |
924933 | 924933 | 2021-01-13 | Bay | Michigan | 26017 | 6748 | 225 |
921688 | 921688 | 2021-01-12 | Bay | Michigan | 26017 | 6726 | 223 |
918443 | 918443 | 2021-01-11 | Bay | Michigan | 26017 | 6711 | 218 |
915198 | 915198 | 2021-01-10 | Bay | Michigan | 26017 | 6654 | 218 |
911953 | 911953 | 2021-01-09 | Bay | Michigan | 26017 | 6654 | 218 |
908708 | 908708 | 2021-01-08 | Bay | Michigan | 26017 | 6619 | 208 |
905462 | 905462 | 2021-01-07 | Bay | Michigan | 26017 | 6577 | 207 |
902217 | 902217 | 2021-01-06 | Bay | Michigan | 26017 | 6503 | 201 |
898972 | 898972 | 2021-01-05 | Bay | Michigan | 26017 | 6426 | 199 |
895727 | 895727 | 2021-01-04 | Bay | Michigan | 26017 | 6411 | 193 |
892480 | 892480 | 2021-01-03 | Bay | Michigan | 26017 | 6358 | 193 |
889234 | 889234 | 2021-01-02 | Bay | Michigan | 26017 | 6358 | 193 |
885988 | 885988 | 2021-01-01 | Bay | Michigan | 26017 | 6219 | 187 |
882743 | 882743 | 2020-12-31 | Bay | Michigan | 26017 | 6219 | 187 |
879498 | 879498 | 2020-12-30 | Bay | Michigan | 26017 | 6219 | 187 |
876253 | 876253 | 2020-12-29 | Bay | Michigan | 26017 | 6163 | 186 |
873008 | 873008 | 2020-12-28 | Bay | Michigan | 26017 | 6122 | 180 |
869763 | 869763 | 2020-12-27 | Bay | Michigan | 26017 | 6075 | 180 |
866518 | 866518 | 2020-12-26 | Bay | Michigan | 26017 | 6075 | 180 |
863273 | 863273 | 2020-12-25 | Bay | Michigan | 26017 | 5962 | 173 |
860028 | 860028 | 2020-12-24 | Bay | Michigan | 26017 | 5962 | 173 |
856783 | 856783 | 2020-12-23 | Bay | Michigan | 26017 | 5962 | 173 |
853538 | 853538 | 2020-12-22 | Bay | Michigan | 26017 | 5904 | 173 |
850293 | 850293 | 2020-12-21 | Bay | Michigan | 26017 | 5888 | 164 |
847048 | 847048 | 2020-12-20 | Bay | Michigan | 26017 | 5818 | 164 |
843802 | 843802 | 2020-12-19 | Bay | Michigan | 26017 | 5818 | 164 |
840557 | 840557 | 2020-12-18 | Bay | Michigan | 26017 | 5744 | 159 |
837312 | 837312 | 2020-12-17 | Bay | Michigan | 26017 | 5676 | 157 |
834066 | 834066 | 2020-12-16 | Bay | Michigan | 26017 | 5613 | 154 |
830819 | 830819 | 2020-12-15 | Bay | Michigan | 26017 | 5556 | 150 |
827573 | 827573 | 2020-12-14 | Bay | Michigan | 26017 | 5494 | 146 |
824326 | 824326 | 2020-12-13 | Bay | Michigan | 26017 | 5409 | 141 |
821080 | 821080 | 2020-12-12 | Bay | Michigan | 26017 | 5409 | 141 |
817834 | 817834 | 2020-12-11 | Bay | Michigan | 26017 | 5377 | 133 |
814588 | 814588 | 2020-12-10 | Bay | Michigan | 26017 | 5325 | 133 |
811343 | 811343 | 2020-12-09 | Bay | Michigan | 26017 | 5241 | 128 |
808098 | 808098 | 2020-12-08 | Bay | Michigan | 26017 | 5175 | 127 |
804853 | 804853 | 2020-12-07 | Bay | Michigan | 26017 | 5129 | 120 |
801608 | 801608 | 2020-12-06 | Bay | Michigan | 26017 | 4969 | 119 |
798363 | 798363 | 2020-12-05 | Bay | Michigan | 26017 | 4969 | 119 |
795118 | 795118 | 2020-12-04 | Bay | Michigan | 26017 | 4898 | 111 |
791873 | 791873 | 2020-12-03 | Bay | Michigan | 26017 | 4773 | 111 |
788628 | 788628 | 2020-12-02 | Bay | Michigan | 26017 | 4643 | 107 |
785383 | 785383 | 2020-12-01 | Bay | Michigan | 26017 | 4599 | 98 |
782139 | 782139 | 2020-11-30 | Bay | Michigan | 26017 | 4535 | 92 |
778893 | 778893 | 2020-11-29 | Bay | Michigan | 26017 | 4378 | 91 |
775648 | 775648 | 2020-11-28 | Bay | Michigan | 26017 | 4378 | 91 |
772403 | 772403 | 2020-11-27 | Bay | Michigan | 26017 | 4277 | 89 |
769158 | 769158 | 2020-11-26 | Bay | Michigan | 26017 | 4029 | 89 |
765912 | 765912 | 2020-11-25 | Bay | Michigan | 26017 | 4029 | 89 |
762667 | 762667 | 2020-11-24 | Bay | Michigan | 26017 | 3935 | 88 |
759422 | 759422 | 2020-11-23 | Bay | Michigan | 26017 | 3852 | 83 |
756175 | 756175 | 2020-11-22 | Bay | Michigan | 26017 | 3634 | 81 |
752929 | 752929 | 2020-11-21 | Bay | Michigan | 26017 | 3634 | 81 |
749683 | 749683 | 2020-11-20 | Bay | Michigan | 26017 | 3500 | 80 |
746437 | 746437 | 2020-11-19 | Bay | Michigan | 26017 | 3390 | 80 |
743190 | 743190 | 2020-11-18 | Bay | Michigan | 26017 | 3315 | 79 |
739943 | 739943 | 2020-11-17 | Bay | Michigan | 26017 | 3186 | 79 |
736699 | 736699 | 2020-11-16 | Bay | Michigan | 26017 | 3048 | 78 |
733453 | 733453 | 2020-11-15 | Bay | Michigan | 26017 | 2846 | 80 |
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);