ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Midland" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054804 | 1054804 | 2021-02-22 | Midland | Michigan | 26111 | 4910 | 64 |
1051557 | 1051557 | 2021-02-21 | Midland | Michigan | 26111 | 4905 | 64 |
1048310 | 1048310 | 2021-02-20 | Midland | Michigan | 26111 | 4905 | 64 |
1045064 | 1045064 | 2021-02-19 | Midland | Michigan | 26111 | 4903 | 64 |
1041819 | 1041819 | 2021-02-18 | Midland | Michigan | 26111 | 4891 | 64 |
1038574 | 1038574 | 2021-02-17 | Midland | Michigan | 26111 | 4889 | 64 |
1035329 | 1035329 | 2021-02-16 | Midland | Michigan | 26111 | 4886 | 64 |
1032084 | 1032084 | 2021-02-15 | Midland | Michigan | 26111 | 4881 | 64 |
1028837 | 1028837 | 2021-02-14 | Midland | Michigan | 26111 | 4881 | 64 |
1025591 | 1025591 | 2021-02-13 | Midland | Michigan | 26111 | 4881 | 64 |
1022346 | 1022346 | 2021-02-12 | Midland | Michigan | 26111 | 4882 | 63 |
1019101 | 1019101 | 2021-02-11 | Midland | Michigan | 26111 | 4872 | 62 |
1015856 | 1015856 | 2021-02-10 | Midland | Michigan | 26111 | 4865 | 62 |
1012611 | 1012611 | 2021-02-09 | Midland | Michigan | 26111 | 4858 | 61 |
1009366 | 1009366 | 2021-02-08 | Midland | Michigan | 26111 | 4849 | 61 |
1006119 | 1006119 | 2021-02-07 | Midland | Michigan | 26111 | 4822 | 61 |
1002873 | 1002873 | 2021-02-06 | Midland | Michigan | 26111 | 4822 | 61 |
999628 | 999628 | 2021-02-05 | Midland | Michigan | 26111 | 4819 | 59 |
996382 | 996382 | 2021-02-04 | Midland | Michigan | 26111 | 4816 | 57 |
993136 | 993136 | 2021-02-03 | Midland | Michigan | 26111 | 4802 | 57 |
989890 | 989890 | 2021-02-02 | Midland | Michigan | 26111 | 4783 | 57 |
986643 | 986643 | 2021-02-01 | Midland | Michigan | 26111 | 4771 | 56 |
983396 | 983396 | 2021-01-31 | Midland | Michigan | 26111 | 4721 | 56 |
980150 | 980150 | 2021-01-30 | Midland | Michigan | 26111 | 4721 | 56 |
976904 | 976904 | 2021-01-29 | Midland | Michigan | 26111 | 4720 | 56 |
973659 | 973659 | 2021-01-28 | Midland | Michigan | 26111 | 4697 | 56 |
970414 | 970414 | 2021-01-27 | Midland | Michigan | 26111 | 4687 | 55 |
967169 | 967169 | 2021-01-26 | Midland | Michigan | 26111 | 4672 | 55 |
963925 | 963925 | 2021-01-25 | Midland | Michigan | 26111 | 4647 | 55 |
960680 | 960680 | 2021-01-24 | Midland | Michigan | 26111 | 4608 | 55 |
957434 | 957434 | 2021-01-23 | Midland | Michigan | 26111 | 4608 | 55 |
954189 | 954189 | 2021-01-22 | Midland | Michigan | 26111 | 4593 | 53 |
950944 | 950944 | 2021-01-21 | Midland | Michigan | 26111 | 4569 | 53 |
947698 | 947698 | 2021-01-20 | Midland | Michigan | 26111 | 4562 | 53 |
944451 | 944451 | 2021-01-19 | Midland | Michigan | 26111 | 4554 | 52 |
941206 | 941206 | 2021-01-18 | Midland | Michigan | 26111 | 4524 | 52 |
937961 | 937961 | 2021-01-17 | Midland | Michigan | 26111 | 4497 | 53 |
934716 | 934716 | 2021-01-16 | Midland | Michigan | 26111 | 4497 | 53 |
931471 | 931471 | 2021-01-15 | Midland | Michigan | 26111 | 4474 | 53 |
928226 | 928226 | 2021-01-14 | Midland | Michigan | 26111 | 4456 | 53 |
924980 | 924980 | 2021-01-13 | Midland | Michigan | 26111 | 4420 | 51 |
921735 | 921735 | 2021-01-12 | Midland | Michigan | 26111 | 4383 | 51 |
918490 | 918490 | 2021-01-11 | Midland | Michigan | 26111 | 4351 | 49 |
915245 | 915245 | 2021-01-10 | Midland | Michigan | 26111 | 4322 | 49 |
912000 | 912000 | 2021-01-09 | Midland | Michigan | 26111 | 4322 | 49 |
908755 | 908755 | 2021-01-08 | Midland | Michigan | 26111 | 4303 | 49 |
905509 | 905509 | 2021-01-07 | Midland | Michigan | 26111 | 4272 | 49 |
902264 | 902264 | 2021-01-06 | Midland | Michigan | 26111 | 4235 | 49 |
899019 | 899019 | 2021-01-05 | Midland | Michigan | 26111 | 4191 | 51 |
895774 | 895774 | 2021-01-04 | Midland | Michigan | 26111 | 4156 | 47 |
892527 | 892527 | 2021-01-03 | Midland | Michigan | 26111 | 4099 | 46 |
889281 | 889281 | 2021-01-02 | Midland | Michigan | 26111 | 4099 | 46 |
886035 | 886035 | 2021-01-01 | Midland | Michigan | 26111 | 4011 | 44 |
882790 | 882790 | 2020-12-31 | Midland | Michigan | 26111 | 4011 | 44 |
879545 | 879545 | 2020-12-30 | Midland | Michigan | 26111 | 4011 | 44 |
876300 | 876300 | 2020-12-29 | Midland | Michigan | 26111 | 3978 | 44 |
873055 | 873055 | 2020-12-28 | Midland | Michigan | 26111 | 3903 | 45 |
869810 | 869810 | 2020-12-27 | Midland | Michigan | 26111 | 3876 | 44 |
866565 | 866565 | 2020-12-26 | Midland | Michigan | 26111 | 3876 | 44 |
863320 | 863320 | 2020-12-25 | Midland | Michigan | 26111 | 3825 | 41 |
860075 | 860075 | 2020-12-24 | Midland | Michigan | 26111 | 3825 | 41 |
856830 | 856830 | 2020-12-23 | Midland | Michigan | 26111 | 3825 | 41 |
853585 | 853585 | 2020-12-22 | Midland | Michigan | 26111 | 3784 | 40 |
850340 | 850340 | 2020-12-21 | Midland | Michigan | 26111 | 3744 | 38 |
847095 | 847095 | 2020-12-20 | Midland | Michigan | 26111 | 3697 | 36 |
843849 | 843849 | 2020-12-19 | Midland | Michigan | 26111 | 3697 | 36 |
840604 | 840604 | 2020-12-18 | Midland | Michigan | 26111 | 3678 | 37 |
837359 | 837359 | 2020-12-17 | Midland | Michigan | 26111 | 3638 | 36 |
834113 | 834113 | 2020-12-16 | Midland | Michigan | 26111 | 3631 | 34 |
830866 | 830866 | 2020-12-15 | Midland | Michigan | 26111 | 3578 | 34 |
827620 | 827620 | 2020-12-14 | Midland | Michigan | 26111 | 3536 | 32 |
824373 | 824373 | 2020-12-13 | Midland | Michigan | 26111 | 3503 | 32 |
821127 | 821127 | 2020-12-12 | Midland | Michigan | 26111 | 3503 | 32 |
817881 | 817881 | 2020-12-11 | Midland | Michigan | 26111 | 3479 | 31 |
814635 | 814635 | 2020-12-10 | Midland | Michigan | 26111 | 3451 | 31 |
811390 | 811390 | 2020-12-09 | Midland | Michigan | 26111 | 3401 | 32 |
808145 | 808145 | 2020-12-08 | Midland | Michigan | 26111 | 3378 | 32 |
804900 | 804900 | 2020-12-07 | Midland | Michigan | 26111 | 3315 | 31 |
801655 | 801655 | 2020-12-06 | Midland | Michigan | 26111 | 3254 | 31 |
798410 | 798410 | 2020-12-05 | Midland | Michigan | 26111 | 3254 | 31 |
795165 | 795165 | 2020-12-04 | Midland | Michigan | 26111 | 3224 | 30 |
791920 | 791920 | 2020-12-03 | Midland | Michigan | 26111 | 3171 | 28 |
788675 | 788675 | 2020-12-02 | Midland | Michigan | 26111 | 3136 | 28 |
785430 | 785430 | 2020-12-01 | Midland | Michigan | 26111 | 3097 | 28 |
782186 | 782186 | 2020-11-30 | Midland | Michigan | 26111 | 3044 | 27 |
778940 | 778940 | 2020-11-29 | Midland | Michigan | 26111 | 2935 | 27 |
775695 | 775695 | 2020-11-28 | Midland | Michigan | 26111 | 2935 | 27 |
772450 | 772450 | 2020-11-27 | Midland | Michigan | 26111 | 2889 | 27 |
769205 | 769205 | 2020-11-26 | Midland | Michigan | 26111 | 2777 | 27 |
765959 | 765959 | 2020-11-25 | Midland | Michigan | 26111 | 2777 | 27 |
762714 | 762714 | 2020-11-24 | Midland | Michigan | 26111 | 2734 | 26 |
759469 | 759469 | 2020-11-23 | Midland | Michigan | 26111 | 2663 | 24 |
756222 | 756222 | 2020-11-22 | Midland | Michigan | 26111 | 2564 | 23 |
752976 | 752976 | 2020-11-21 | Midland | Michigan | 26111 | 2564 | 23 |
749730 | 749730 | 2020-11-20 | Midland | Michigan | 26111 | 2500 | 23 |
746484 | 746484 | 2020-11-19 | Midland | Michigan | 26111 | 2435 | 22 |
743237 | 743237 | 2020-11-18 | Midland | Michigan | 26111 | 2371 | 19 |
739990 | 739990 | 2020-11-17 | Midland | Michigan | 26111 | 2297 | 18 |
736746 | 736746 | 2020-11-16 | Midland | Michigan | 26111 | 2217 | 18 |
733500 | 733500 | 2020-11-15 | Midland | Michigan | 26111 | 2086 | 16 |
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);