ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

65,202 rows where state = "Michigan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • Michigan · 65,202 ✖
Link rowid date ▲ county state fips cases deaths
2500821 2500821 2022-05-13 Alcona Michigan 26001 1745 71
2500822 2500822 2022-05-13 Alger Michigan 26003 1880 13
2500823 2500823 2022-05-13 Allegan Michigan 26005 27448 348
2500824 2500824 2022-05-13 Alpena Michigan 26007 5809 139
2500825 2500825 2022-05-13 Antrim Michigan 26009 4470 66
2500826 2500826 2022-05-13 Arenac Michigan 26011 3267 67
2500827 2500827 2022-05-13 Baraga Michigan 26013 2222 54
2500828 2500828 2022-05-13 Barry Michigan 26015 14514 169
2500829 2500829 2022-05-13 Bay Michigan 26017 27496 588
2500830 2500830 2022-05-13 Benzie Michigan 26019 3514 68
2500831 2500831 2022-05-13 Berrien Michigan 26021 35344 561
2500832 2500832 2022-05-13 Branch Michigan 26023 12253 206
2500833 2500833 2022-05-13 Calhoun Michigan 26025 35011 575
2500834 2500834 2022-05-13 Cass Michigan 26027 11215 145
2500835 2500835 2022-05-13 Charlevoix Michigan 26029 5014 60
2500836 2500836 2022-05-13 Cheboygan Michigan 26031 4760 104
2500837 2500837 2022-05-13 Chippewa Michigan 26033 11841 120
2500838 2500838 2022-05-13 Clare Michigan 26035 6834 157
2500839 2500839 2022-05-13 Clinton Michigan 26037 22007 208
2500840 2500840 2022-05-13 Crawford Michigan 26039 2629 31
2500841 2500841 2022-05-13 Delta Michigan 26041 10050 157
2500842 2500842 2022-05-13 Dickinson Michigan 26043 7490 110
2500843 2500843 2022-05-13 Eaton Michigan 26045 27518 402
2500844 2500844 2022-05-13 Emmet Michigan 26047 6608 87
2500845 2500845 2022-05-13 Genesee Michigan 26049 103601 1720
2500846 2500846 2022-05-13 Gladwin Michigan 26051 5632 114
2500847 2500847 2022-05-13 Gogebic Michigan 26053 3296 69
2500848 2500848 2022-05-13 Grand Traverse Michigan 26055 17858 236
2500849 2500849 2022-05-13 Gratiot Michigan 26057 13864 191
2500850 2500850 2022-05-13 Hillsdale Michigan 26059 10453 203
2500851 2500851 2022-05-13 Houghton Michigan 26061 7982 92
2500852 2500852 2022-05-13 Huron Michigan 26063 8138 145
2500853 2500853 2022-05-13 Ingham Michigan 26065 66384 769
2500854 2500854 2022-05-13 Ionia Michigan 26067 19843 181
2500855 2500855 2022-05-13 Iosco Michigan 26069 4860 145
2500856 2500856 2022-05-13 Iron Michigan 26071 2673 86
2500857 2500857 2022-05-13 Isabella Michigan 26073 15890 211
2500858 2500858 2022-05-13 Jackson Michigan 26075 45532 590
2500859 2500859 2022-05-13 Kalamazoo Michigan 26077 60792 675
2500860 2500860 2022-05-13 Kalkaska Michigan 26079 3623 61
2500861 2500861 2022-05-13 Kent Michigan 26081 170251 1533
2500862 2500862 2022-05-13 Keweenaw Michigan 26083 523 14
2500863 2500863 2022-05-13 Lake Michigan 26085 1893 37
2500864 2500864 2022-05-13 Lapeer Michigan 26087 21122 427
2500865 2500865 2022-05-13 Leelanau Michigan 26089 3697 55
2500866 2500866 2022-05-13 Lenawee Michigan 26091 26611 331
2500867 2500867 2022-05-13 Livingston Michigan 26093 47690 451
2500868 2500868 2022-05-13 Luce Michigan 26095 2306 14
2500869 2500869 2022-05-13 Mackinac Michigan 26097 2479 31
2500870 2500870 2022-05-13 Macomb Michigan 26099 238947 3970
2500871 2500871 2022-05-13 Manistee Michigan 26101 4550 91
2500872 2500872 2022-05-13 Marquette Michigan 26103 16276 131
2500873 2500873 2022-05-13 Mason Michigan 26105 6873 96
2500874 2500874 2022-05-13 Mecosta Michigan 26107 8784 108
2500875 2500875 2022-05-13 Menominee Michigan 26109 5693 70
2500876 2500876 2022-05-13 Midland Michigan 26111 19428 226
2500877 2500877 2022-05-13 Missaukee Michigan 26113 2946 60
2500878 2500878 2022-05-13 Monroe Michigan 26115 39169 475
2500879 2500879 2022-05-13 Montcalm Michigan 26117 17350 216
2500880 2500880 2022-05-13 Montmorency Michigan 26119 1750 48
2500881 2500881 2022-05-13 Muskegon Michigan 26121 42498 650
2500882 2500882 2022-05-13 Newaygo Michigan 26123 11622 158
2500883 2500883 2022-05-13 Oakland Michigan 26125 300744 3851
2500884 2500884 2022-05-13 Oceana Michigan 26127 6422 90
2500885 2500885 2022-05-13 Ogemaw Michigan 26129 4372 106
2500886 2500886 2022-05-13 Ontonagon Michigan 26131 1008 38
2500887 2500887 2022-05-13 Osceola Michigan 26133 5067 80
2500888 2500888 2022-05-13 Oscoda Michigan 26135 1450 56
2500889 2500889 2022-05-13 Otsego Michigan 26137 5779 101
2500890 2500890 2022-05-13 Ottawa Michigan 26139 76277 785
2500891 2500891 2022-05-13 Presque Isle Michigan 26141 2085 58
2500892 2500892 2022-05-13 Roscommon Michigan 26143 4690 115
2500893 2500893 2022-05-13 Saginaw Michigan 26145 51303 956
2500894 2500894 2022-05-13 Sanilac Michigan 26151 8827 193
2500895 2500895 2022-05-13 Schoolcraft Michigan 26153 1763 16
2500896 2500896 2022-05-13 Shiawassee Michigan 26155 18142 232
2500897 2500897 2022-05-13 St. Clair Michigan 26147 41609 835
2500898 2500898 2022-05-13 St. Joseph Michigan 26149 13812 208
2500899 2500899 2022-05-13 Tuscola Michigan 26157 13350 277
2500900 2500900 2022-05-13 Unknown Michigan   17641 80
2500901 2500901 2022-05-13 Van Buren Michigan 26159 17347 273
2500902 2500902 2022-05-13 Washtenaw Michigan 26161 83317 522
2500903 2500903 2022-05-13 Wayne Michigan 26163 416604 7975
2500904 2500904 2022-05-13 Wexford Michigan 26165 7169 107
2497563 2497563 2022-05-12 Alcona Michigan 26001 1745 71
2497564 2497564 2022-05-12 Alger Michigan 26003 1880 13
2497565 2497565 2022-05-12 Allegan Michigan 26005 27448 348
2497566 2497566 2022-05-12 Alpena Michigan 26007 5809 139
2497567 2497567 2022-05-12 Antrim Michigan 26009 4470 66
2497568 2497568 2022-05-12 Arenac Michigan 26011 3267 67
2497569 2497569 2022-05-12 Baraga Michigan 26013 2222 54
2497570 2497570 2022-05-12 Barry Michigan 26015 14514 169
2497571 2497571 2022-05-12 Bay Michigan 26017 27496 588
2497572 2497572 2022-05-12 Benzie Michigan 26019 3514 68
2497573 2497573 2022-05-12 Berrien Michigan 26021 35344 561
2497574 2497574 2022-05-12 Branch Michigan 26023 12253 206
2497575 2497575 2022-05-12 Calhoun Michigan 26025 35011 575
2497576 2497576 2022-05-12 Cass Michigan 26027 11215 145
2497577 2497577 2022-05-12 Charlevoix Michigan 26029 5014 60
2497578 2497578 2022-05-12 Cheboygan Michigan 26031 4760 104

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);