ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Emmet" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636150 | 636150 | 2020-10-16 | Emmet | Michigan | 26047 | 182 | 4 |
632904 | 632904 | 2020-10-15 | Emmet | Michigan | 26047 | 182 | 4 |
629659 | 629659 | 2020-10-14 | Emmet | Michigan | 26047 | 180 | 4 |
626415 | 626415 | 2020-10-13 | Emmet | Michigan | 26047 | 180 | 4 |
623173 | 623173 | 2020-10-12 | Emmet | Michigan | 26047 | 178 | 4 |
619930 | 619930 | 2020-10-11 | Emmet | Michigan | 26047 | 177 | 4 |
616688 | 616688 | 2020-10-10 | Emmet | Michigan | 26047 | 177 | 4 |
613447 | 613447 | 2020-10-09 | Emmet | Michigan | 26047 | 177 | 4 |
610205 | 610205 | 2020-10-08 | Emmet | Michigan | 26047 | 177 | 4 |
606963 | 606963 | 2020-10-07 | Emmet | Michigan | 26047 | 175 | 4 |
603720 | 603720 | 2020-10-06 | Emmet | Michigan | 26047 | 175 | 4 |
600478 | 600478 | 2020-10-05 | Emmet | Michigan | 26047 | 173 | 4 |
597235 | 597235 | 2020-10-04 | Emmet | Michigan | 26047 | 167 | 4 |
593994 | 593994 | 2020-10-03 | Emmet | Michigan | 26047 | 167 | 4 |
590753 | 590753 | 2020-10-02 | Emmet | Michigan | 26047 | 166 | 4 |
587512 | 587512 | 2020-10-01 | Emmet | Michigan | 26047 | 165 | 4 |
584272 | 584272 | 2020-09-30 | Emmet | Michigan | 26047 | 162 | 4 |
581031 | 581031 | 2020-09-29 | Emmet | Michigan | 26047 | 160 | 4 |
577790 | 577790 | 2020-09-28 | Emmet | Michigan | 26047 | 159 | 4 |
574549 | 574549 | 2020-09-27 | Emmet | Michigan | 26047 | 157 | 4 |
571306 | 571306 | 2020-09-26 | Emmet | Michigan | 26047 | 157 | 4 |
568064 | 568064 | 2020-09-25 | Emmet | Michigan | 26047 | 156 | 4 |
564824 | 564824 | 2020-09-24 | Emmet | Michigan | 26047 | 156 | 4 |
561584 | 561584 | 2020-09-23 | Emmet | Michigan | 26047 | 157 | 4 |
558347 | 558347 | 2020-09-22 | Emmet | Michigan | 26047 | 157 | 4 |
555110 | 555110 | 2020-09-21 | Emmet | Michigan | 26047 | 154 | 4 |
551872 | 551872 | 2020-09-20 | Emmet | Michigan | 26047 | 152 | 4 |
548633 | 548633 | 2020-09-19 | Emmet | Michigan | 26047 | 152 | 4 |
545395 | 545395 | 2020-09-18 | Emmet | Michigan | 26047 | 151 | 4 |
542158 | 542158 | 2020-09-17 | Emmet | Michigan | 26047 | 151 | 4 |
538922 | 538922 | 2020-09-16 | Emmet | Michigan | 26047 | 147 | 4 |
535685 | 535685 | 2020-09-15 | Emmet | Michigan | 26047 | 140 | 4 |
532450 | 532450 | 2020-09-14 | Emmet | Michigan | 26047 | 139 | 4 |
529214 | 529214 | 2020-09-13 | Emmet | Michigan | 26047 | 136 | 4 |
525978 | 525978 | 2020-09-12 | Emmet | Michigan | 26047 | 136 | 4 |
522742 | 522742 | 2020-09-11 | Emmet | Michigan | 26047 | 136 | 4 |
519505 | 519505 | 2020-09-10 | Emmet | Michigan | 26047 | 136 | 4 |
516270 | 516270 | 2020-09-09 | Emmet | Michigan | 26047 | 133 | 4 |
513036 | 513036 | 2020-09-08 | Emmet | Michigan | 26047 | 133 | 4 |
509804 | 509804 | 2020-09-07 | Emmet | Michigan | 26047 | 133 | 4 |
506571 | 506571 | 2020-09-06 | Emmet | Michigan | 26047 | 131 | 3 |
503338 | 503338 | 2020-09-05 | Emmet | Michigan | 26047 | 131 | 3 |
500104 | 500104 | 2020-09-04 | Emmet | Michigan | 26047 | 130 | 3 |
496870 | 496870 | 2020-09-03 | Emmet | Michigan | 26047 | 129 | 3 |
493637 | 493637 | 2020-09-02 | Emmet | Michigan | 26047 | 128 | 3 |
490403 | 490403 | 2020-09-01 | Emmet | Michigan | 26047 | 127 | 3 |
487170 | 487170 | 2020-08-31 | Emmet | Michigan | 26047 | 126 | 3 |
483936 | 483936 | 2020-08-30 | Emmet | Michigan | 26047 | 122 | 2 |
480701 | 480701 | 2020-08-29 | Emmet | Michigan | 26047 | 117 | 2 |
477469 | 477469 | 2020-08-28 | Emmet | Michigan | 26047 | 115 | 2 |
474236 | 474236 | 2020-08-27 | Emmet | Michigan | 26047 | 114 | 2 |
471004 | 471004 | 2020-08-26 | Emmet | Michigan | 26047 | 111 | 2 |
467774 | 467774 | 2020-08-25 | Emmet | Michigan | 26047 | 108 | 2 |
464545 | 464545 | 2020-08-24 | Emmet | Michigan | 26047 | 108 | 2 |
461314 | 461314 | 2020-08-23 | Emmet | Michigan | 26047 | 103 | 2 |
458087 | 458087 | 2020-08-22 | Emmet | Michigan | 26047 | 100 | 2 |
454859 | 454859 | 2020-08-21 | Emmet | Michigan | 26047 | 98 | 2 |
451631 | 451631 | 2020-08-20 | Emmet | Michigan | 26047 | 96 | 2 |
448403 | 448403 | 2020-08-19 | Emmet | Michigan | 26047 | 90 | 2 |
445177 | 445177 | 2020-08-18 | Emmet | Michigan | 26047 | 88 | 2 |
441951 | 441951 | 2020-08-17 | Emmet | Michigan | 26047 | 84 | 2 |
438724 | 438724 | 2020-08-16 | Emmet | Michigan | 26047 | 74 | 2 |
435499 | 435499 | 2020-08-15 | Emmet | Michigan | 26047 | 74 | 2 |
432273 | 432273 | 2020-08-14 | Emmet | Michigan | 26047 | 74 | 2 |
429046 | 429046 | 2020-08-13 | Emmet | Michigan | 26047 | 69 | 2 |
425822 | 425822 | 2020-08-12 | Emmet | Michigan | 26047 | 66 | 2 |
422600 | 422600 | 2020-08-11 | Emmet | Michigan | 26047 | 66 | 2 |
419378 | 419378 | 2020-08-10 | Emmet | Michigan | 26047 | 64 | 2 |
416157 | 416157 | 2020-08-09 | Emmet | Michigan | 26047 | 63 | 2 |
412937 | 412937 | 2020-08-08 | Emmet | Michigan | 26047 | 63 | 2 |
409717 | 409717 | 2020-08-07 | Emmet | Michigan | 26047 | 63 | 2 |
406497 | 406497 | 2020-08-06 | Emmet | Michigan | 26047 | 61 | 2 |
403279 | 403279 | 2020-08-05 | Emmet | Michigan | 26047 | 60 | 2 |
400062 | 400062 | 2020-08-04 | Emmet | Michigan | 26047 | 59 | 2 |
396848 | 396848 | 2020-08-03 | Emmet | Michigan | 26047 | 59 | 2 |
393632 | 393632 | 2020-08-02 | Emmet | Michigan | 26047 | 57 | 2 |
390415 | 390415 | 2020-08-01 | Emmet | Michigan | 26047 | 57 | 2 |
387198 | 387198 | 2020-07-31 | Emmet | Michigan | 26047 | 58 | 2 |
383980 | 383980 | 2020-07-30 | Emmet | Michigan | 26047 | 57 | 2 |
380763 | 380763 | 2020-07-29 | Emmet | Michigan | 26047 | 57 | 2 |
377546 | 377546 | 2020-07-28 | Emmet | Michigan | 26047 | 55 | 2 |
374331 | 374331 | 2020-07-27 | Emmet | Michigan | 26047 | 53 | 2 |
371119 | 371119 | 2020-07-26 | Emmet | Michigan | 26047 | 52 | 2 |
367909 | 367909 | 2020-07-25 | Emmet | Michigan | 26047 | 52 | 2 |
364702 | 364702 | 2020-07-24 | Emmet | Michigan | 26047 | 52 | 2 |
361495 | 361495 | 2020-07-23 | Emmet | Michigan | 26047 | 51 | 2 |
358290 | 358290 | 2020-07-22 | Emmet | Michigan | 26047 | 51 | 2 |
355087 | 355087 | 2020-07-21 | Emmet | Michigan | 26047 | 49 | 2 |
351885 | 351885 | 2020-07-20 | Emmet | Michigan | 26047 | 47 | 2 |
348685 | 348685 | 2020-07-19 | Emmet | Michigan | 26047 | 46 | 2 |
345484 | 345484 | 2020-07-18 | Emmet | Michigan | 26047 | 46 | 2 |
342284 | 342284 | 2020-07-17 | Emmet | Michigan | 26047 | 46 | 2 |
339088 | 339088 | 2020-07-16 | Emmet | Michigan | 26047 | 46 | 2 |
335892 | 335892 | 2020-07-15 | Emmet | Michigan | 26047 | 44 | 2 |
332699 | 332699 | 2020-07-14 | Emmet | Michigan | 26047 | 41 | 2 |
329512 | 329512 | 2020-07-13 | Emmet | Michigan | 26047 | 41 | 2 |
326326 | 326326 | 2020-07-12 | Emmet | Michigan | 26047 | 39 | 2 |
323143 | 323143 | 2020-07-11 | Emmet | Michigan | 26047 | 39 | 2 |
319964 | 319964 | 2020-07-10 | Emmet | Michigan | 26047 | 38 | 2 |
316789 | 316789 | 2020-07-09 | Emmet | Michigan | 26047 | 35 | 2 |
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);