ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2021-11-30 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1967347 | 1967347 | 2021-11-30 | Alcona | Michigan | 26001 | 1320 | 50 |
1967348 | 1967348 | 2021-11-30 | Alger | Michigan | 26003 | 1133 | 9 |
1967349 | 1967349 | 2021-11-30 | Allegan | Michigan | 26005 | 17979 | 220 |
1967350 | 1967350 | 2021-11-30 | Alpena | Michigan | 26007 | 4005 | 81 |
1967351 | 1967351 | 2021-11-30 | Antrim | Michigan | 26009 | 2848 | 42 |
1967352 | 1967352 | 2021-11-30 | Arenac | Michigan | 26011 | 2097 | 44 |
1967353 | 1967353 | 2021-11-30 | Baraga | Michigan | 26013 | 1557 | 47 |
1967354 | 1967354 | 2021-11-30 | Barry | Michigan | 26015 | 9554 | 102 |
1967355 | 1967355 | 2021-11-30 | Bay | Michigan | 26017 | 17224 | 426 |
1967356 | 1967356 | 2021-11-30 | Benzie | Michigan | 26019 | 2104 | 45 |
1967357 | 1967357 | 2021-11-30 | Berrien | Michigan | 26021 | 21725 | 347 |
1967358 | 1967358 | 2021-11-30 | Branch | Michigan | 26023 | 8482 | 146 |
1967359 | 1967359 | 2021-11-30 | Calhoun | Michigan | 26025 | 21794 | 393 |
1967360 | 1967360 | 2021-11-30 | Cass | Michigan | 26027 | 7974 | 101 |
1967361 | 1967361 | 2021-11-30 | Charlevoix | Michigan | 26029 | 3049 | 43 |
1967362 | 1967362 | 2021-11-30 | Cheboygan | Michigan | 26031 | 3283 | 74 |
1967363 | 1967363 | 2021-11-30 | Chippewa | Michigan | 26033 | 7570 | 72 |
1967364 | 1967364 | 2021-11-30 | Clare | Michigan | 26035 | 4556 | 117 |
1967365 | 1967365 | 2021-11-30 | Clinton | Michigan | 26037 | 12370 | 130 |
1967366 | 1967366 | 2021-11-30 | Crawford | Michigan | 26039 | 1734 | 17 |
1967367 | 1967367 | 2021-11-30 | Delta | Michigan | 26041 | 6569 | 122 |
1967368 | 1967368 | 2021-11-30 | Dickinson | Michigan | 26043 | 4599 | 86 |
1967369 | 1967369 | 2021-11-30 | Eaton | Michigan | 26045 | 16039 | 279 |
1967370 | 1967370 | 2021-11-30 | Emmet | Michigan | 26047 | 3985 | 55 |
1967371 | 1967371 | 2021-11-30 | Genesee | Michigan | 26049 | 61265 | 1170 |
1967372 | 1967372 | 2021-11-30 | Gladwin | Michigan | 26051 | 3724 | 83 |
1967373 | 1967373 | 2021-11-30 | Gogebic | Michigan | 26053 | 2101 | 56 |
1967374 | 1967374 | 2021-11-30 | Grand Traverse | Michigan | 26055 | 10849 | 134 |
1967375 | 1967375 | 2021-11-30 | Gratiot | Michigan | 26057 | 9895 | 144 |
1967376 | 1967376 | 2021-11-30 | Hillsdale | Michigan | 26059 | 7368 | 146 |
1967377 | 1967377 | 2021-11-30 | Houghton | Michigan | 26061 | 5190 | 61 |
1967378 | 1967378 | 2021-11-30 | Huron | Michigan | 26063 | 5668 | 102 |
1967379 | 1967379 | 2021-11-30 | Ingham | Michigan | 26065 | 36468 | 499 |
1967380 | 1967380 | 2021-11-30 | Ionia | Michigan | 26067 | 13754 | 118 |
1967381 | 1967381 | 2021-11-30 | Iosco | Michigan | 26069 | 3500 | 103 |
1967382 | 1967382 | 2021-11-30 | Iron | Michigan | 26071 | 1696 | 65 |
1967383 | 1967383 | 2021-11-30 | Isabella | Michigan | 26073 | 10358 | 140 |
1967384 | 1967384 | 2021-11-30 | Jackson | Michigan | 26075 | 30876 | 398 |
1967385 | 1967385 | 2021-11-30 | Kalamazoo | Michigan | 26077 | 34619 | 488 |
1967386 | 1967386 | 2021-11-30 | Kalkaska | Michigan | 26079 | 2124 | 40 |
1967387 | 1967387 | 2021-11-30 | Kent | Michigan | 26081 | 109356 | 1082 |
1967388 | 1967388 | 2021-11-30 | Keweenaw | Michigan | 26083 | 359 | 8 |
1967389 | 1967389 | 2021-11-30 | Lake | Michigan | 26085 | 1182 | 25 |
1967390 | 1967390 | 2021-11-30 | Lapeer | Michigan | 26087 | 14091 | 281 |
1967391 | 1967391 | 2021-11-30 | Leelanau | Michigan | 26089 | 2101 | 34 |
1967392 | 1967392 | 2021-11-30 | Lenawee | Michigan | 26091 | 17320 | 220 |
1967393 | 1967393 | 2021-11-30 | Livingston | Michigan | 26093 | 28509 | 283 |
1967394 | 1967394 | 2021-11-30 | Luce | Michigan | 26095 | 1715 | 6 |
1967395 | 1967395 | 2021-11-30 | Mackinac | Michigan | 26097 | 1485 | 14 |
1967396 | 1967396 | 2021-11-30 | Macomb | Michigan | 26099 | 140609 | 2860 |
1967397 | 1967397 | 2021-11-30 | Manistee | Michigan | 26101 | 2933 | 48 |
1967398 | 1967398 | 2021-11-30 | Marquette | Michigan | 26103 | 9021 | 90 |
1967399 | 1967399 | 2021-11-30 | Mason | Michigan | 26105 | 4096 | 56 |
1967400 | 1967400 | 2021-11-30 | Mecosta | Michigan | 26107 | 5689 | 61 |
1967401 | 1967401 | 2021-11-30 | Menominee | Michigan | 26109 | 3845 | 54 |
1967402 | 1967402 | 2021-11-30 | Midland | Michigan | 26111 | 12029 | 156 |
1967403 | 1967403 | 2021-11-30 | Missaukee | Michigan | 26113 | 2085 | 41 |
1967404 | 1967404 | 2021-11-30 | Monroe | Michigan | 26115 | 23764 | 329 |
1967405 | 1967405 | 2021-11-30 | Montcalm | Michigan | 26117 | 12520 | 151 |
1967406 | 1967406 | 2021-11-30 | Montmorency | Michigan | 26119 | 1238 | 35 |
1967407 | 1967407 | 2021-11-30 | Muskegon | Michigan | 26121 | 28017 | 460 |
1967408 | 1967408 | 2021-11-30 | Newaygo | Michigan | 26123 | 7834 | 97 |
1967409 | 1967409 | 2021-11-30 | Oakland | Michigan | 26125 | 168182 | 2794 |
1967410 | 1967410 | 2021-11-30 | Oceana | Michigan | 26127 | 4435 | 75 |
1967411 | 1967411 | 2021-11-30 | Ogemaw | Michigan | 26129 | 3074 | 71 |
1967412 | 1967412 | 2021-11-30 | Ontonagon | Michigan | 26131 | 688 | 23 |
1967413 | 1967413 | 2021-11-30 | Osceola | Michigan | 26133 | 3543 | 50 |
1967414 | 1967414 | 2021-11-30 | Oscoda | Michigan | 26135 | 1094 | 42 |
1967415 | 1967415 | 2021-11-30 | Otsego | Michigan | 26137 | 3947 | 67 |
1967416 | 1967416 | 2021-11-30 | Ottawa | Michigan | 26139 | 49303 | 562 |
1967417 | 1967417 | 2021-11-30 | Presque Isle | Michigan | 26141 | 1602 | 46 |
1967418 | 1967418 | 2021-11-30 | Roscommon | Michigan | 26143 | 3250 | 80 |
1967419 | 1967419 | 2021-11-30 | Saginaw | Michigan | 26145 | 32814 | 714 |
1967420 | 1967420 | 2021-11-30 | Sanilac | Michigan | 26151 | 5996 | 148 |
1967421 | 1967421 | 2021-11-30 | Schoolcraft | Michigan | 26153 | 992 | 6 |
1967422 | 1967422 | 2021-11-30 | Shiawassee | Michigan | 26155 | 11008 | 148 |
1967423 | 1967423 | 2021-11-30 | St. Clair | Michigan | 26147 | 26387 | 554 |
1967424 | 1967424 | 2021-11-30 | St. Joseph | Michigan | 26149 | 9836 | 133 |
1967425 | 1967425 | 2021-11-30 | Tuscola | Michigan | 26157 | 8792 | 216 |
1967426 | 1967426 | 2021-11-30 | Unknown | Michigan | 1482 | 18 | |
1967427 | 1967427 | 2021-11-30 | Van Buren | Michigan | 26159 | 10949 | 183 |
1967428 | 1967428 | 2021-11-30 | Washtenaw | Michigan | 26161 | 39330 | 349 |
1967429 | 1967429 | 2021-11-30 | Wayne | Michigan | 26163 | 228285 | 5834 |
1967430 | 1967430 | 2021-11-30 | Wexford | Michigan | 26165 | 4496 | 70 |
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);