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

84 rows where "date" is on date 2021-05-25 and state = "Michigan" sorted by date descending

✎ View and edit SQL

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

state 1

  • Michigan · 84 ✖
Link rowid date ▲ county state fips cases deaths
1353459 1353459 2021-05-25 Alcona Michigan 26001 737 32
1353460 1353460 2021-05-25 Alger Michigan 26003 666 6
1353461 1353461 2021-05-25 Allegan Michigan 26005 11032 143
1353462 1353462 2021-05-25 Alpena Michigan 26007 2248 60
1353463 1353463 2021-05-25 Antrim Michigan 26009 1617 28
1353464 1353464 2021-05-25 Arenac Michigan 26011 1199 29
1353465 1353465 2021-05-25 Baraga Michigan 26013 965 38
1353466 1353466 2021-05-25 Barry Michigan 26015 5884 67
1353467 1353467 2021-05-25 Bay Michigan 26017 11188 345
1353468 1353468 2021-05-25 Benzie Michigan 26019 1268 34
1353469 1353469 2021-05-25 Berrien Michigan 26021 15421 283
1353470 1353470 2021-05-25 Branch Michigan 26023 5632 120
1353471 1353471 2021-05-25 Calhoun Michigan 26025 14346 296
1353472 1353472 2021-05-25 Cass Michigan 26027 5431 76
1353473 1353473 2021-05-25 Charlevoix Michigan 26029 1661 21
1353474 1353474 2021-05-25 Cheboygan Michigan 26031 1920 45
1353475 1353475 2021-05-25 Chippewa Michigan 26033 5585 49
1353476 1353476 2021-05-25 Clare Michigan 26035 2445 80
1353477 1353477 2021-05-25 Clinton Michigan 26037 7545 88
1353478 1353478 2021-05-25 Crawford Michigan 26039 987 14
1353479 1353479 2021-05-25 Delta Michigan 26041 4017 93
1353480 1353480 2021-05-25 Dickinson Michigan 26043 2728 74
1353481 1353481 2021-05-25 Eaton Michigan 26045 10064 208
1353482 1353482 2021-05-25 Emmet Michigan 26047 2367 42
1353483 1353483 2021-05-25 Genesee Michigan 26049 41484 943
1353484 1353484 2021-05-25 Gladwin Michigan 26051 2292 58
1353485 1353485 2021-05-25 Gogebic Michigan 26053 1399 50
1353486 1353486 2021-05-25 Grand Traverse Michigan 26055 6422 96
1353487 1353487 2021-05-25 Gratiot Michigan 26057 6936 122
1353488 1353488 2021-05-25 Hillsdale Michigan 26059 4369 92
1353489 1353489 2021-05-25 Houghton Michigan 26061 3121 42
1353490 1353490 2021-05-25 Huron Michigan 26063 4068 77
1353491 1353491 2021-05-25 Ingham Michigan 26065 24668 378
1353492 1353492 2021-05-25 Ionia Michigan 26067 9224 84
1353493 1353493 2021-05-25 Iosco Michigan 26069 1986 72
1353494 1353494 2021-05-25 Iron Michigan 26071 1049 51
1353495 1353495 2021-05-25 Isabella Michigan 26073 6280 94
1353496 1353496 2021-05-25 Jackson Michigan 26075 20905 307
1353497 1353497 2021-05-25 Kalamazoo Michigan 26077 22902 392
1353498 1353498 2021-05-25 Kalkaska Michigan 26079 1114 23
1353499 1353499 2021-05-25 Kent Michigan 26081 72455 838
1353500 1353500 2021-05-25 Keweenaw Michigan 26083 175 2
1353501 1353501 2021-05-25 Lake Michigan 26085 625 15
1353502 1353502 2021-05-25 Lapeer Michigan 26087 9678 205
1353503 1353503 2021-05-25 Leelanau Michigan 26089 1235 18
1353504 1353504 2021-05-25 Lenawee Michigan 26091 10761 167
1353505 1353505 2021-05-25 Livingston Michigan 26093 16630 188
1353506 1353506 2021-05-25 Luce Michigan 26095 1319 5
1353507 1353507 2021-05-25 Mackinac Michigan 26097 703 3
1353508 1353508 2021-05-25 Macomb Michigan 26099 99733 2417
1353509 1353509 2021-05-25 Manistee Michigan 26101 1966 24
1353510 1353510 2021-05-25 Marquette Michigan 26103 5909 62
1353511 1353511 2021-05-25 Mason Michigan 26105 2117 36
1353512 1353512 2021-05-25 Mecosta Michigan 26107 3170 32
1353513 1353513 2021-05-25 Menominee Michigan 26109 2109 42
1353514 1353514 2021-05-25 Midland Michigan 26111 7483 88
1353515 1353515 2021-05-25 Missaukee Michigan 26113 1493 24
1353516 1353516 2021-05-25 Monroe Michigan 26115 15270 258
1353517 1353517 2021-05-25 Montcalm Michigan 26117 8076 116
1353518 1353518 2021-05-25 Montmorency Michigan 26119 605 20
1353519 1353519 2021-05-25 Muskegon Michigan 26121 18114 364
1353520 1353520 2021-05-25 Newaygo Michigan 26123 4808 66
1353521 1353521 2021-05-25 Oakland Michigan 26125 117387 2346
1353522 1353522 2021-05-25 Oceana Michigan 26127 2732 60
1353523 1353523 2021-05-25 Ogemaw Michigan 26129 1719 43
1353524 1353524 2021-05-25 Ontonagon Michigan 26131 473 21
1353525 1353525 2021-05-25 Osceola Michigan 26133 1937 29
1353526 1353526 2021-05-25 Oscoda Michigan 26135 663 29
1353527 1353527 2021-05-25 Otsego Michigan 26137 2338 40
1353528 1353528 2021-05-25 Ottawa Michigan 26139 32548 417
1353529 1353529 2021-05-25 Presque Isle Michigan 26141 1046 34
1353530 1353530 2021-05-25 Roscommon Michigan 26143 1877 50
1353531 1353531 2021-05-25 Saginaw Michigan 26145 22250 606
1353532 1353532 2021-05-25 Sanilac Michigan 26151 4230 118
1353533 1353533 2021-05-25 Schoolcraft Michigan 26153 430 5
1353534 1353534 2021-05-25 Shiawassee Michigan 26155 6368 103
1353535 1353535 2021-05-25 St. Clair Michigan 26147 18291 433
1353536 1353536 2021-05-25 St. Joseph Michigan 26149 6172 98
1353537 1353537 2021-05-25 Tuscola Michigan 26157 5641 174
1353538 1353538 2021-05-25 Unknown Michigan   617 13
1353539 1353539 2021-05-25 Van Buren Michigan 26159 7054 128
1353540 1353540 2021-05-25 Washtenaw Michigan 26161 26958 299
1353541 1353541 2021-05-25 Wayne Michigan 26163 163677 4976
1353542 1353542 2021-05-25 Wexford Michigan 26165 2873 47

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