ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Wayne" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054831 | 1054831 | 2021-02-22 | Wayne | Michigan | 26163 | 100669 | 4120 |
1051584 | 1051584 | 2021-02-21 | Wayne | Michigan | 26163 | 100399 | 4120 |
1048337 | 1048337 | 2021-02-20 | Wayne | Michigan | 26163 | 100399 | 4120 |
1045091 | 1045091 | 2021-02-19 | Wayne | Michigan | 26163 | 100266 | 4112 |
1041846 | 1041846 | 2021-02-18 | Wayne | Michigan | 26163 | 100060 | 4107 |
1038601 | 1038601 | 2021-02-17 | Wayne | Michigan | 26163 | 99877 | 4088 |
1035356 | 1035356 | 2021-02-16 | Wayne | Michigan | 26163 | 99724 | 4087 |
1032111 | 1032111 | 2021-02-15 | Wayne | Michigan | 26163 | 99542 | 4086 |
1028864 | 1028864 | 2021-02-14 | Wayne | Michigan | 26163 | 99316 | 4085 |
1025618 | 1025618 | 2021-02-13 | Wayne | Michigan | 26163 | 99316 | 4085 |
1022373 | 1022373 | 2021-02-12 | Wayne | Michigan | 26163 | 99184 | 4065 |
1019128 | 1019128 | 2021-02-11 | Wayne | Michigan | 26163 | 98998 | 4063 |
1015883 | 1015883 | 2021-02-10 | Wayne | Michigan | 26163 | 98810 | 4054 |
1012638 | 1012638 | 2021-02-09 | Wayne | Michigan | 26163 | 98659 | 4053 |
1009393 | 1009393 | 2021-02-08 | Wayne | Michigan | 26163 | 98551 | 4047 |
1006146 | 1006146 | 2021-02-07 | Wayne | Michigan | 26163 | 98157 | 4043 |
1002900 | 1002900 | 2021-02-06 | Wayne | Michigan | 26163 | 98157 | 4043 |
999655 | 999655 | 2021-02-05 | Wayne | Michigan | 26163 | 97943 | 4021 |
996409 | 996409 | 2021-02-04 | Wayne | Michigan | 26163 | 97725 | 4017 |
993163 | 993163 | 2021-02-03 | Wayne | Michigan | 26163 | 97429 | 4002 |
989917 | 989917 | 2021-02-02 | Wayne | Michigan | 26163 | 97255 | 3997 |
986670 | 986670 | 2021-02-01 | Wayne | Michigan | 26163 | 97048 | 3981 |
983423 | 983423 | 2021-01-31 | Wayne | Michigan | 26163 | 96712 | 3984 |
980177 | 980177 | 2021-01-30 | Wayne | Michigan | 26163 | 96712 | 3984 |
976931 | 976931 | 2021-01-29 | Wayne | Michigan | 26163 | 96472 | 3965 |
973686 | 973686 | 2021-01-28 | Wayne | Michigan | 26163 | 96178 | 3966 |
970441 | 970441 | 2021-01-27 | Wayne | Michigan | 26163 | 95874 | 3949 |
967196 | 967196 | 2021-01-26 | Wayne | Michigan | 26163 | 95575 | 3951 |
963952 | 963952 | 2021-01-25 | Wayne | Michigan | 26163 | 95207 | 3936 |
960707 | 960707 | 2021-01-24 | Wayne | Michigan | 26163 | 94716 | 3930 |
957461 | 957461 | 2021-01-23 | Wayne | Michigan | 26163 | 94716 | 3930 |
954216 | 954216 | 2021-01-22 | Wayne | Michigan | 26163 | 94480 | 3901 |
950971 | 950971 | 2021-01-21 | Wayne | Michigan | 26163 | 94118 | 3902 |
947725 | 947725 | 2021-01-20 | Wayne | Michigan | 26163 | 93764 | 3878 |
944478 | 944478 | 2021-01-19 | Wayne | Michigan | 26163 | 93400 | 3868 |
941233 | 941233 | 2021-01-18 | Wayne | Michigan | 26163 | 93003 | 3859 |
937988 | 937988 | 2021-01-17 | Wayne | Michigan | 26163 | 92476 | 3856 |
934743 | 934743 | 2021-01-16 | Wayne | Michigan | 26163 | 92476 | 3856 |
931498 | 931498 | 2021-01-15 | Wayne | Michigan | 26163 | 92074 | 3839 |
928253 | 928253 | 2021-01-14 | Wayne | Michigan | 26163 | 91526 | 3835 |
925007 | 925007 | 2021-01-13 | Wayne | Michigan | 26163 | 91162 | 3813 |
921762 | 921762 | 2021-01-12 | Wayne | Michigan | 26163 | 90704 | 3807 |
918517 | 918517 | 2021-01-11 | Wayne | Michigan | 26163 | 90377 | 3794 |
915272 | 915272 | 2021-01-10 | Wayne | Michigan | 26163 | 89542 | 3789 |
912027 | 912027 | 2021-01-09 | Wayne | Michigan | 26163 | 89542 | 3789 |
908782 | 908782 | 2021-01-08 | Wayne | Michigan | 26163 | 89162 | 3745 |
905536 | 905536 | 2021-01-07 | Wayne | Michigan | 26163 | 88550 | 3742 |
902291 | 902291 | 2021-01-06 | Wayne | Michigan | 26163 | 88055 | 3711 |
899046 | 899046 | 2021-01-05 | Wayne | Michigan | 26163 | 87285 | 3704 |
895801 | 895801 | 2021-01-04 | Wayne | Michigan | 26163 | 86904 | 3684 |
892554 | 892554 | 2021-01-03 | Wayne | Michigan | 26163 | 86022 | 3669 |
889308 | 889308 | 2021-01-02 | Wayne | Michigan | 26163 | 86022 | 3669 |
886062 | 886062 | 2021-01-01 | Wayne | Michigan | 26163 | 84967 | 3626 |
882817 | 882817 | 2020-12-31 | Wayne | Michigan | 26163 | 84967 | 3626 |
879572 | 879572 | 2020-12-30 | Wayne | Michigan | 26163 | 84967 | 3626 |
876327 | 876327 | 2020-12-29 | Wayne | Michigan | 26163 | 84478 | 3618 |
873082 | 873082 | 2020-12-28 | Wayne | Michigan | 26163 | 83927 | 3585 |
869837 | 869837 | 2020-12-27 | Wayne | Michigan | 26163 | 83409 | 3580 |
866592 | 866592 | 2020-12-26 | Wayne | Michigan | 26163 | 83409 | 3580 |
863347 | 863347 | 2020-12-25 | Wayne | Michigan | 26163 | 82242 | 3544 |
860102 | 860102 | 2020-12-24 | Wayne | Michigan | 26163 | 82242 | 3544 |
856857 | 856857 | 2020-12-23 | Wayne | Michigan | 26163 | 82242 | 3544 |
853612 | 853612 | 2020-12-22 | Wayne | Michigan | 26163 | 81769 | 3537 |
850367 | 850367 | 2020-12-21 | Wayne | Michigan | 26163 | 81164 | 3522 |
847122 | 847122 | 2020-12-20 | Wayne | Michigan | 26163 | 80316 | 3517 |
843876 | 843876 | 2020-12-19 | Wayne | Michigan | 26163 | 80316 | 3517 |
840631 | 840631 | 2020-12-18 | Wayne | Michigan | 26163 | 79682 | 3498 |
837386 | 837386 | 2020-12-17 | Wayne | Michigan | 26163 | 79023 | 3497 |
834140 | 834140 | 2020-12-16 | Wayne | Michigan | 26163 | 78357 | 3467 |
830893 | 830893 | 2020-12-15 | Wayne | Michigan | 26163 | 77768 | 3453 |
827647 | 827647 | 2020-12-14 | Wayne | Michigan | 26163 | 76791 | 3428 |
824400 | 824400 | 2020-12-13 | Wayne | Michigan | 26163 | 75824 | 3414 |
821154 | 821154 | 2020-12-12 | Wayne | Michigan | 26163 | 75824 | 3414 |
817908 | 817908 | 2020-12-11 | Wayne | Michigan | 26163 | 75110 | 3386 |
814662 | 814662 | 2020-12-10 | Wayne | Michigan | 26163 | 74404 | 3379 |
811417 | 811417 | 2020-12-09 | Wayne | Michigan | 26163 | 73402 | 3364 |
808172 | 808172 | 2020-12-08 | Wayne | Michigan | 26163 | 72718 | 3356 |
804927 | 804927 | 2020-12-07 | Wayne | Michigan | 26163 | 71527 | 3323 |
801682 | 801682 | 2020-12-06 | Wayne | Michigan | 26163 | 70257 | 3313 |
798437 | 798437 | 2020-12-05 | Wayne | Michigan | 26163 | 70257 | 3313 |
795192 | 795192 | 2020-12-04 | Wayne | Michigan | 26163 | 69408 | 3282 |
791947 | 791947 | 2020-12-03 | Wayne | Michigan | 26163 | 68022 | 3270 |
788702 | 788702 | 2020-12-02 | Wayne | Michigan | 26163 | 67080 | 3244 |
785457 | 785457 | 2020-12-01 | Wayne | Michigan | 26163 | 65878 | 3239 |
782213 | 782213 | 2020-11-30 | Wayne | Michigan | 26163 | 65146 | 3224 |
778967 | 778967 | 2020-11-29 | Wayne | Michigan | 26163 | 63632 | 3216 |
775722 | 775722 | 2020-11-28 | Wayne | Michigan | 26163 | 63632 | 3216 |
772477 | 772477 | 2020-11-27 | Wayne | Michigan | 26163 | 62299 | 3208 |
769232 | 769232 | 2020-11-26 | Wayne | Michigan | 26163 | 59931 | 3191 |
765986 | 765986 | 2020-11-25 | Wayne | Michigan | 26163 | 59931 | 3191 |
762741 | 762741 | 2020-11-24 | Wayne | Michigan | 26163 | 59316 | 3189 |
759496 | 759496 | 2020-11-23 | Wayne | Michigan | 26163 | 58376 | 3161 |
756249 | 756249 | 2020-11-22 | Wayne | Michigan | 26163 | 57116 | 3156 |
753003 | 753003 | 2020-11-21 | Wayne | Michigan | 26163 | 57116 | 3156 |
749757 | 749757 | 2020-11-20 | Wayne | Michigan | 26163 | 56126 | 3148 |
746511 | 746511 | 2020-11-19 | Wayne | Michigan | 26163 | 54747 | 3147 |
743264 | 743264 | 2020-11-18 | Wayne | Michigan | 26163 | 53790 | 3138 |
740017 | 740017 | 2020-11-17 | Wayne | Michigan | 26163 | 52984 | 3134 |
736773 | 736773 | 2020-11-16 | Wayne | Michigan | 26163 | 51982 | 3126 |
733527 | 733527 | 2020-11-15 | Wayne | Michigan | 26163 | 50512 | 3121 |
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);