ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-10-05" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1785368 | 1785368 | 2021-10-05 | Alcona | Michigan | 26001 | 958 | 39 |
1785369 | 1785369 | 2021-10-05 | Alger | Michigan | 26003 | 892 | 7 |
1785370 | 1785370 | 2021-10-05 | Allegan | Michigan | 26005 | 13508 | 179 |
1785371 | 1785371 | 2021-10-05 | Alpena | Michigan | 26007 | 2806 | 69 |
1785372 | 1785372 | 2021-10-05 | Antrim | Michigan | 26009 | 2071 | 35 |
1785373 | 1785373 | 2021-10-05 | Arenac | Michigan | 26011 | 1507 | 31 |
1785374 | 1785374 | 2021-10-05 | Baraga | Michigan | 26013 | 1178 | 45 |
1785375 | 1785375 | 2021-10-05 | Barry | Michigan | 26015 | 7143 | 77 |
1785376 | 1785376 | 2021-10-05 | Bay | Michigan | 26017 | 13327 | 370 |
1785377 | 1785377 | 2021-10-05 | Benzie | Michigan | 26019 | 1520 | 38 |
1785378 | 1785378 | 2021-10-05 | Berrien | Michigan | 26021 | 18303 | 315 |
1785379 | 1785379 | 2021-10-05 | Branch | Michigan | 26023 | 6919 | 134 |
1785380 | 1785380 | 2021-10-05 | Calhoun | Michigan | 26025 | 17314 | 337 |
1785381 | 1785381 | 2021-10-05 | Cass | Michigan | 26027 | 6663 | 86 |
1785382 | 1785382 | 2021-10-05 | Charlevoix | Michigan | 26029 | 2237 | 29 |
1785383 | 1785383 | 2021-10-05 | Cheboygan | Michigan | 26031 | 2481 | 58 |
1785384 | 1785384 | 2021-10-05 | Chippewa | Michigan | 26033 | 6402 | 54 |
1785385 | 1785385 | 2021-10-05 | Clare | Michigan | 26035 | 3188 | 92 |
1785386 | 1785386 | 2021-10-05 | Clinton | Michigan | 26037 | 9076 | 103 |
1785387 | 1785387 | 2021-10-05 | Crawford | Michigan | 26039 | 1163 | 16 |
1785388 | 1785388 | 2021-10-05 | Delta | Michigan | 26041 | 5272 | 102 |
1785389 | 1785389 | 2021-10-05 | Dickinson | Michigan | 26043 | 3642 | 75 |
1785390 | 1785390 | 2021-10-05 | Eaton | Michigan | 26045 | 12093 | 231 |
1785391 | 1785391 | 2021-10-05 | Emmet | Michigan | 26047 | 3055 | 48 |
1785392 | 1785392 | 2021-10-05 | Genesee | Michigan | 26049 | 48009 | 1036 |
1785393 | 1785393 | 2021-10-05 | Gladwin | Michigan | 26051 | 2932 | 66 |
1785394 | 1785394 | 2021-10-05 | Gogebic | Michigan | 26053 | 1643 | 53 |
1785395 | 1785395 | 2021-10-05 | Grand Traverse | Michigan | 26055 | 8097 | 111 |
1785396 | 1785396 | 2021-10-05 | Gratiot | Michigan | 26057 | 7902 | 128 |
1785397 | 1785397 | 2021-10-05 | Hillsdale | Michigan | 26059 | 5616 | 111 |
1785398 | 1785398 | 2021-10-05 | Houghton | Michigan | 26061 | 3616 | 52 |
1785399 | 1785399 | 2021-10-05 | Huron | Michigan | 26063 | 4524 | 88 |
1785400 | 1785400 | 2021-10-05 | Ingham | Michigan | 26065 | 28963 | 435 |
1785401 | 1785401 | 2021-10-05 | Ionia | Michigan | 26067 | 10861 | 94 |
1785402 | 1785402 | 2021-10-05 | Iosco | Michigan | 26069 | 2639 | 86 |
1785403 | 1785403 | 2021-10-05 | Iron | Michigan | 26071 | 1291 | 53 |
1785404 | 1785404 | 2021-10-05 | Isabella | Michigan | 26073 | 8017 | 106 |
1785405 | 1785405 | 2021-10-05 | Jackson | Michigan | 26075 | 24128 | 348 |
1785406 | 1785406 | 2021-10-05 | Kalamazoo | Michigan | 26077 | 27594 | 437 |
1785407 | 1785407 | 2021-10-05 | Kalkaska | Michigan | 26079 | 1546 | 30 |
1785408 | 1785408 | 2021-10-05 | Kent | Michigan | 26081 | 86407 | 945 |
1785409 | 1785409 | 2021-10-05 | Keweenaw | Michigan | 26083 | 221 | 4 |
1785410 | 1785410 | 2021-10-05 | Lake | Michigan | 26085 | 836 | 19 |
1785411 | 1785411 | 2021-10-05 | Lapeer | Michigan | 26087 | 11191 | 238 |
1785412 | 1785412 | 2021-10-05 | Leelanau | Michigan | 26089 | 1520 | 23 |
1785413 | 1785413 | 2021-10-05 | Lenawee | Michigan | 26091 | 13135 | 194 |
1785414 | 1785414 | 2021-10-05 | Livingston | Michigan | 26093 | 20755 | 216 |
1785415 | 1785415 | 2021-10-05 | Luce | Michigan | 26095 | 1473 | 6 |
1785416 | 1785416 | 2021-10-05 | Mackinac | Michigan | 26097 | 1078 | 6 |
1785417 | 1785417 | 2021-10-05 | Macomb | Michigan | 26099 | 114372 | 2609 |
1785418 | 1785418 | 2021-10-05 | Manistee | Michigan | 26101 | 2324 | 33 |
1785419 | 1785419 | 2021-10-05 | Marquette | Michigan | 26103 | 7257 | 72 |
1785420 | 1785420 | 2021-10-05 | Mason | Michigan | 26105 | 2786 | 43 |
1785421 | 1785421 | 2021-10-05 | Mecosta | Michigan | 26107 | 4100 | 41 |
1785422 | 1785422 | 2021-10-05 | Menominee | Michigan | 26109 | 2982 | 48 |
1785423 | 1785423 | 2021-10-05 | Midland | Michigan | 26111 | 9236 | 120 |
1785424 | 1785424 | 2021-10-05 | Missaukee | Michigan | 26113 | 1734 | 30 |
1785425 | 1785425 | 2021-10-05 | Monroe | Michigan | 26115 | 18492 | 290 |
1785426 | 1785426 | 2021-10-05 | Montcalm | Michigan | 26117 | 9597 | 128 |
1785427 | 1785427 | 2021-10-05 | Montmorency | Michigan | 26119 | 802 | 24 |
1785428 | 1785428 | 2021-10-05 | Muskegon | Michigan | 26121 | 21622 | 412 |
1785429 | 1785429 | 2021-10-05 | Newaygo | Michigan | 26123 | 5953 | 73 |
1785430 | 1785430 | 2021-10-05 | Oakland | Michigan | 26125 | 137205 | 2603 |
1785431 | 1785431 | 2021-10-05 | Oceana | Michigan | 26127 | 3370 | 66 |
1785432 | 1785432 | 2021-10-05 | Ogemaw | Michigan | 26129 | 2345 | 46 |
1785433 | 1785433 | 2021-10-05 | Ontonagon | Michigan | 26131 | 572 | 22 |
1785434 | 1785434 | 2021-10-05 | Osceola | Michigan | 26133 | 2544 | 34 |
1785435 | 1785435 | 2021-10-05 | Oscoda | Michigan | 26135 | 839 | 32 |
1785436 | 1785436 | 2021-10-05 | Otsego | Michigan | 26137 | 2915 | 48 |
1785437 | 1785437 | 2021-10-05 | Ottawa | Michigan | 26139 | 38403 | 480 |
1785438 | 1785438 | 2021-10-05 | Presque Isle | Michigan | 26141 | 1260 | 35 |
1785439 | 1785439 | 2021-10-05 | Roscommon | Michigan | 26143 | 2192 | 59 |
1785440 | 1785440 | 2021-10-05 | Saginaw | Michigan | 26145 | 26251 | 662 |
1785441 | 1785441 | 2021-10-05 | Sanilac | Michigan | 26151 | 4648 | 131 |
1785442 | 1785442 | 2021-10-05 | Schoolcraft | Michigan | 26153 | 668 | 5 |
1785443 | 1785443 | 2021-10-05 | Shiawassee | Michigan | 26155 | 7864 | 121 |
1785444 | 1785444 | 2021-10-05 | St. Clair | Michigan | 26147 | 20958 | 493 |
1785445 | 1785445 | 2021-10-05 | St. Joseph | Michigan | 26149 | 7684 | 112 |
1785446 | 1785446 | 2021-10-05 | Tuscola | Michigan | 26157 | 6751 | 185 |
1785447 | 1785447 | 2021-10-05 | Unknown | Michigan | 947 | 18 | |
1785448 | 1785448 | 2021-10-05 | Van Buren | Michigan | 26159 | 8524 | 153 |
1785449 | 1785449 | 2021-10-05 | Washtenaw | Michigan | 26161 | 31687 | 325 |
1785450 | 1785450 | 2021-10-05 | Wayne | Michigan | 26163 | 188385 | 5428 |
1785451 | 1785451 | 2021-10-05 | Wexford | Michigan | 26165 | 3297 | 50 |
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);