ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Wexford" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636210 | 636210 | 2020-10-16 | Wexford | Michigan | 26165 | 149 | 4 |
632964 | 632964 | 2020-10-15 | Wexford | Michigan | 26165 | 149 | 4 |
629719 | 629719 | 2020-10-14 | Wexford | Michigan | 26165 | 147 | 4 |
626475 | 626475 | 2020-10-13 | Wexford | Michigan | 26165 | 145 | 4 |
623233 | 623233 | 2020-10-12 | Wexford | Michigan | 26165 | 145 | 4 |
619990 | 619990 | 2020-10-11 | Wexford | Michigan | 26165 | 144 | 4 |
616748 | 616748 | 2020-10-10 | Wexford | Michigan | 26165 | 144 | 4 |
613507 | 613507 | 2020-10-09 | Wexford | Michigan | 26165 | 144 | 4 |
610265 | 610265 | 2020-10-08 | Wexford | Michigan | 26165 | 144 | 4 |
607023 | 607023 | 2020-10-07 | Wexford | Michigan | 26165 | 143 | 4 |
603780 | 603780 | 2020-10-06 | Wexford | Michigan | 26165 | 139 | 4 |
600538 | 600538 | 2020-10-05 | Wexford | Michigan | 26165 | 140 | 4 |
597295 | 597295 | 2020-10-04 | Wexford | Michigan | 26165 | 135 | 4 |
594054 | 594054 | 2020-10-03 | Wexford | Michigan | 26165 | 135 | 4 |
590813 | 590813 | 2020-10-02 | Wexford | Michigan | 26165 | 135 | 4 |
587572 | 587572 | 2020-10-01 | Wexford | Michigan | 26165 | 135 | 4 |
584332 | 584332 | 2020-09-30 | Wexford | Michigan | 26165 | 133 | 4 |
581091 | 581091 | 2020-09-29 | Wexford | Michigan | 26165 | 131 | 4 |
577850 | 577850 | 2020-09-28 | Wexford | Michigan | 26165 | 129 | 4 |
574609 | 574609 | 2020-09-27 | Wexford | Michigan | 26165 | 128 | 4 |
571366 | 571366 | 2020-09-26 | Wexford | Michigan | 26165 | 128 | 4 |
568124 | 568124 | 2020-09-25 | Wexford | Michigan | 26165 | 128 | 4 |
564884 | 564884 | 2020-09-24 | Wexford | Michigan | 26165 | 127 | 4 |
561644 | 561644 | 2020-09-23 | Wexford | Michigan | 26165 | 125 | 4 |
558407 | 558407 | 2020-09-22 | Wexford | Michigan | 26165 | 123 | 4 |
555170 | 555170 | 2020-09-21 | Wexford | Michigan | 26165 | 123 | 4 |
551932 | 551932 | 2020-09-20 | Wexford | Michigan | 26165 | 123 | 4 |
548693 | 548693 | 2020-09-19 | Wexford | Michigan | 26165 | 123 | 4 |
545455 | 545455 | 2020-09-18 | Wexford | Michigan | 26165 | 123 | 4 |
542218 | 542218 | 2020-09-17 | Wexford | Michigan | 26165 | 122 | 4 |
538982 | 538982 | 2020-09-16 | Wexford | Michigan | 26165 | 122 | 4 |
535745 | 535745 | 2020-09-15 | Wexford | Michigan | 26165 | 122 | 4 |
532510 | 532510 | 2020-09-14 | Wexford | Michigan | 26165 | 120 | 4 |
529274 | 529274 | 2020-09-13 | Wexford | Michigan | 26165 | 118 | 4 |
526038 | 526038 | 2020-09-12 | Wexford | Michigan | 26165 | 118 | 4 |
522802 | 522802 | 2020-09-11 | Wexford | Michigan | 26165 | 118 | 4 |
519565 | 519565 | 2020-09-10 | Wexford | Michigan | 26165 | 118 | 4 |
516330 | 516330 | 2020-09-09 | Wexford | Michigan | 26165 | 118 | 4 |
513096 | 513096 | 2020-09-08 | Wexford | Michigan | 26165 | 118 | 4 |
509864 | 509864 | 2020-09-07 | Wexford | Michigan | 26165 | 116 | 4 |
506631 | 506631 | 2020-09-06 | Wexford | Michigan | 26165 | 116 | 4 |
503398 | 503398 | 2020-09-05 | Wexford | Michigan | 26165 | 116 | 4 |
500164 | 500164 | 2020-09-04 | Wexford | Michigan | 26165 | 116 | 4 |
496930 | 496930 | 2020-09-03 | Wexford | Michigan | 26165 | 116 | 4 |
493697 | 493697 | 2020-09-02 | Wexford | Michigan | 26165 | 112 | 4 |
490463 | 490463 | 2020-09-01 | Wexford | Michigan | 26165 | 109 | 4 |
487230 | 487230 | 2020-08-31 | Wexford | Michigan | 26165 | 107 | 4 |
483996 | 483996 | 2020-08-30 | Wexford | Michigan | 26165 | 104 | 4 |
480761 | 480761 | 2020-08-29 | Wexford | Michigan | 26165 | 102 | 4 |
477529 | 477529 | 2020-08-28 | Wexford | Michigan | 26165 | 100 | 4 |
474296 | 474296 | 2020-08-27 | Wexford | Michigan | 26165 | 97 | 4 |
471064 | 471064 | 2020-08-26 | Wexford | Michigan | 26165 | 95 | 4 |
467834 | 467834 | 2020-08-25 | Wexford | Michigan | 26165 | 95 | 4 |
464605 | 464605 | 2020-08-24 | Wexford | Michigan | 26165 | 94 | 4 |
461374 | 461374 | 2020-08-23 | Wexford | Michigan | 26165 | 88 | 4 |
458147 | 458147 | 2020-08-22 | Wexford | Michigan | 26165 | 87 | 4 |
454919 | 454919 | 2020-08-21 | Wexford | Michigan | 26165 | 84 | 4 |
451691 | 451691 | 2020-08-20 | Wexford | Michigan | 26165 | 80 | 4 |
448463 | 448463 | 2020-08-19 | Wexford | Michigan | 26165 | 80 | 4 |
445237 | 445237 | 2020-08-18 | Wexford | Michigan | 26165 | 79 | 4 |
442011 | 442011 | 2020-08-17 | Wexford | Michigan | 26165 | 78 | 4 |
438784 | 438784 | 2020-08-16 | Wexford | Michigan | 26165 | 76 | 4 |
435559 | 435559 | 2020-08-15 | Wexford | Michigan | 26165 | 75 | 4 |
432333 | 432333 | 2020-08-14 | Wexford | Michigan | 26165 | 75 | 4 |
429106 | 429106 | 2020-08-13 | Wexford | Michigan | 26165 | 74 | 4 |
425882 | 425882 | 2020-08-12 | Wexford | Michigan | 26165 | 74 | 4 |
422660 | 422660 | 2020-08-11 | Wexford | Michigan | 26165 | 73 | 4 |
419438 | 419438 | 2020-08-10 | Wexford | Michigan | 26165 | 73 | 4 |
416217 | 416217 | 2020-08-09 | Wexford | Michigan | 26165 | 73 | 4 |
412997 | 412997 | 2020-08-08 | Wexford | Michigan | 26165 | 73 | 4 |
409777 | 409777 | 2020-08-07 | Wexford | Michigan | 26165 | 73 | 4 |
406557 | 406557 | 2020-08-06 | Wexford | Michigan | 26165 | 74 | 4 |
403339 | 403339 | 2020-08-05 | Wexford | Michigan | 26165 | 73 | 4 |
400122 | 400122 | 2020-08-04 | Wexford | Michigan | 26165 | 71 | 4 |
396908 | 396908 | 2020-08-03 | Wexford | Michigan | 26165 | 71 | 4 |
393692 | 393692 | 2020-08-02 | Wexford | Michigan | 26165 | 67 | 4 |
390475 | 390475 | 2020-08-01 | Wexford | Michigan | 26165 | 67 | 4 |
387258 | 387258 | 2020-07-31 | Wexford | Michigan | 26165 | 67 | 4 |
384040 | 384040 | 2020-07-30 | Wexford | Michigan | 26165 | 67 | 4 |
380823 | 380823 | 2020-07-29 | Wexford | Michigan | 26165 | 65 | 4 |
377606 | 377606 | 2020-07-28 | Wexford | Michigan | 26165 | 65 | 4 |
374391 | 374391 | 2020-07-27 | Wexford | Michigan | 26165 | 65 | 4 |
371179 | 371179 | 2020-07-26 | Wexford | Michigan | 26165 | 61 | 4 |
367969 | 367969 | 2020-07-25 | Wexford | Michigan | 26165 | 59 | 4 |
364762 | 364762 | 2020-07-24 | Wexford | Michigan | 26165 | 59 | 4 |
361555 | 361555 | 2020-07-23 | Wexford | Michigan | 26165 | 59 | 4 |
358350 | 358350 | 2020-07-22 | Wexford | Michigan | 26165 | 60 | 4 |
355147 | 355147 | 2020-07-21 | Wexford | Michigan | 26165 | 57 | 4 |
351945 | 351945 | 2020-07-20 | Wexford | Michigan | 26165 | 57 | 4 |
348745 | 348745 | 2020-07-19 | Wexford | Michigan | 26165 | 57 | 4 |
345544 | 345544 | 2020-07-18 | Wexford | Michigan | 26165 | 57 | 4 |
342344 | 342344 | 2020-07-17 | Wexford | Michigan | 26165 | 57 | 4 |
339148 | 339148 | 2020-07-16 | Wexford | Michigan | 26165 | 57 | 4 |
335952 | 335952 | 2020-07-15 | Wexford | Michigan | 26165 | 59 | 4 |
332759 | 332759 | 2020-07-14 | Wexford | Michigan | 26165 | 58 | 4 |
329572 | 329572 | 2020-07-13 | Wexford | Michigan | 26165 | 57 | 4 |
326386 | 326386 | 2020-07-12 | Wexford | Michigan | 26165 | 57 | 4 |
323203 | 323203 | 2020-07-11 | Wexford | Michigan | 26165 | 57 | 4 |
320024 | 320024 | 2020-07-10 | Wexford | Michigan | 26165 | 57 | 4 |
316849 | 316849 | 2020-07-09 | Wexford | Michigan | 26165 | 55 | 4 |
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);