ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
229 rows where county = "Madison", deaths = 1 and fips = 30057 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 |
---|---|---|---|---|---|---|---|
727355 | 727355 | 2020-11-13 | Madison | Montana | 30057 | 297 | 1 |
724112 | 724112 | 2020-11-12 | Madison | Montana | 30057 | 282 | 1 |
720869 | 720869 | 2020-11-11 | Madison | Montana | 30057 | 266 | 1 |
717626 | 717626 | 2020-11-10 | Madison | Montana | 30057 | 267 | 1 |
714382 | 714382 | 2020-11-09 | Madison | Montana | 30057 | 255 | 1 |
711138 | 711138 | 2020-11-08 | Madison | Montana | 30057 | 253 | 1 |
707894 | 707894 | 2020-11-07 | Madison | Montana | 30057 | 249 | 1 |
704651 | 704651 | 2020-11-06 | Madison | Montana | 30057 | 239 | 1 |
701409 | 701409 | 2020-11-05 | Madison | Montana | 30057 | 232 | 1 |
698165 | 698165 | 2020-11-04 | Madison | Montana | 30057 | 216 | 1 |
694922 | 694922 | 2020-11-03 | Madison | Montana | 30057 | 214 | 1 |
691680 | 691680 | 2020-11-02 | Madison | Montana | 30057 | 211 | 1 |
688435 | 688435 | 2020-11-01 | Madison | Montana | 30057 | 205 | 1 |
685191 | 685191 | 2020-10-31 | Madison | Montana | 30057 | 196 | 1 |
681948 | 681948 | 2020-10-30 | Madison | Montana | 30057 | 185 | 1 |
678704 | 678704 | 2020-10-29 | Madison | Montana | 30057 | 177 | 1 |
675462 | 675462 | 2020-10-28 | Madison | Montana | 30057 | 170 | 1 |
672219 | 672219 | 2020-10-27 | Madison | Montana | 30057 | 170 | 1 |
668977 | 668977 | 2020-10-26 | Madison | Montana | 30057 | 165 | 1 |
665733 | 665733 | 2020-10-25 | Madison | Montana | 30057 | 163 | 1 |
662488 | 662488 | 2020-10-24 | Madison | Montana | 30057 | 157 | 1 |
659244 | 659244 | 2020-10-23 | Madison | Montana | 30057 | 154 | 1 |
655999 | 655999 | 2020-10-22 | Madison | Montana | 30057 | 152 | 1 |
652754 | 652754 | 2020-10-21 | Madison | Montana | 30057 | 148 | 1 |
649509 | 649509 | 2020-10-20 | Madison | Montana | 30057 | 142 | 1 |
646265 | 646265 | 2020-10-19 | Madison | Montana | 30057 | 139 | 1 |
643019 | 643019 | 2020-10-18 | Madison | Montana | 30057 | 132 | 1 |
639771 | 639771 | 2020-10-17 | Madison | Montana | 30057 | 131 | 1 |
636525 | 636525 | 2020-10-16 | Madison | Montana | 30057 | 127 | 1 |
633279 | 633279 | 2020-10-15 | Madison | Montana | 30057 | 127 | 1 |
630034 | 630034 | 2020-10-14 | Madison | Montana | 30057 | 126 | 1 |
626790 | 626790 | 2020-10-13 | Madison | Montana | 30057 | 126 | 1 |
623548 | 623548 | 2020-10-12 | Madison | Montana | 30057 | 126 | 1 |
620305 | 620305 | 2020-10-11 | Madison | Montana | 30057 | 123 | 1 |
617063 | 617063 | 2020-10-10 | Madison | Montana | 30057 | 123 | 1 |
613822 | 613822 | 2020-10-09 | Madison | Montana | 30057 | 121 | 1 |
610580 | 610580 | 2020-10-08 | Madison | Montana | 30057 | 120 | 1 |
607338 | 607338 | 2020-10-07 | Madison | Montana | 30057 | 118 | 1 |
604095 | 604095 | 2020-10-06 | Madison | Montana | 30057 | 117 | 1 |
600853 | 600853 | 2020-10-05 | Madison | Montana | 30057 | 117 | 1 |
597610 | 597610 | 2020-10-04 | Madison | Montana | 30057 | 117 | 1 |
594369 | 594369 | 2020-10-03 | Madison | Montana | 30057 | 116 | 1 |
591128 | 591128 | 2020-10-02 | Madison | Montana | 30057 | 113 | 1 |
587887 | 587887 | 2020-10-01 | Madison | Montana | 30057 | 111 | 1 |
584647 | 584647 | 2020-09-30 | Madison | Montana | 30057 | 109 | 1 |
581406 | 581406 | 2020-09-29 | Madison | Montana | 30057 | 110 | 1 |
578165 | 578165 | 2020-09-28 | Madison | Montana | 30057 | 104 | 1 |
574924 | 574924 | 2020-09-27 | Madison | Montana | 30057 | 102 | 1 |
571681 | 571681 | 2020-09-26 | Madison | Montana | 30057 | 100 | 1 |
568439 | 568439 | 2020-09-25 | Madison | Montana | 30057 | 100 | 1 |
565199 | 565199 | 2020-09-24 | Madison | Montana | 30057 | 101 | 1 |
561958 | 561958 | 2020-09-23 | Madison | Montana | 30057 | 97 | 1 |
558721 | 558721 | 2020-09-22 | Madison | Montana | 30057 | 97 | 1 |
555484 | 555484 | 2020-09-21 | Madison | Montana | 30057 | 97 | 1 |
552246 | 552246 | 2020-09-20 | Madison | Montana | 30057 | 97 | 1 |
549007 | 549007 | 2020-09-19 | Madison | Montana | 30057 | 97 | 1 |
545769 | 545769 | 2020-09-18 | Madison | Montana | 30057 | 97 | 1 |
542532 | 542532 | 2020-09-17 | Madison | Montana | 30057 | 97 | 1 |
539296 | 539296 | 2020-09-16 | Madison | Montana | 30057 | 97 | 1 |
536059 | 536059 | 2020-09-15 | Madison | Montana | 30057 | 97 | 1 |
532824 | 532824 | 2020-09-14 | Madison | Montana | 30057 | 97 | 1 |
529588 | 529588 | 2020-09-13 | Madison | Montana | 30057 | 96 | 1 |
526352 | 526352 | 2020-09-12 | Madison | Montana | 30057 | 96 | 1 |
523116 | 523116 | 2020-09-11 | Madison | Montana | 30057 | 96 | 1 |
519879 | 519879 | 2020-09-10 | Madison | Montana | 30057 | 96 | 1 |
516644 | 516644 | 2020-09-09 | Madison | Montana | 30057 | 95 | 1 |
513410 | 513410 | 2020-09-08 | Madison | Montana | 30057 | 95 | 1 |
510178 | 510178 | 2020-09-07 | Madison | Montana | 30057 | 95 | 1 |
506945 | 506945 | 2020-09-06 | Madison | Montana | 30057 | 95 | 1 |
503712 | 503712 | 2020-09-05 | Madison | Montana | 30057 | 95 | 1 |
500478 | 500478 | 2020-09-04 | Madison | Montana | 30057 | 95 | 1 |
497244 | 497244 | 2020-09-03 | Madison | Montana | 30057 | 94 | 1 |
494011 | 494011 | 2020-09-02 | Madison | Montana | 30057 | 93 | 1 |
490777 | 490777 | 2020-09-01 | Madison | Montana | 30057 | 93 | 1 |
487544 | 487544 | 2020-08-31 | Madison | Montana | 30057 | 93 | 1 |
484310 | 484310 | 2020-08-30 | Madison | Montana | 30057 | 93 | 1 |
481075 | 481075 | 2020-08-29 | Madison | Montana | 30057 | 92 | 1 |
477843 | 477843 | 2020-08-28 | Madison | Montana | 30057 | 92 | 1 |
474610 | 474610 | 2020-08-27 | Madison | Montana | 30057 | 92 | 1 |
471378 | 471378 | 2020-08-26 | Madison | Montana | 30057 | 91 | 1 |
468148 | 468148 | 2020-08-25 | Madison | Montana | 30057 | 91 | 1 |
464919 | 464919 | 2020-08-24 | Madison | Montana | 30057 | 91 | 1 |
461688 | 461688 | 2020-08-23 | Madison | Montana | 30057 | 91 | 1 |
458461 | 458461 | 2020-08-22 | Madison | Montana | 30057 | 90 | 1 |
455233 | 455233 | 2020-08-21 | Madison | Montana | 30057 | 90 | 1 |
452005 | 452005 | 2020-08-20 | Madison | Montana | 30057 | 88 | 1 |
448777 | 448777 | 2020-08-19 | Madison | Montana | 30057 | 89 | 1 |
445551 | 445551 | 2020-08-18 | Madison | Montana | 30057 | 87 | 1 |
442325 | 442325 | 2020-08-17 | Madison | Montana | 30057 | 86 | 1 |
439098 | 439098 | 2020-08-16 | Madison | Montana | 30057 | 85 | 1 |
435873 | 435873 | 2020-08-15 | Madison | Montana | 30057 | 84 | 1 |
432647 | 432647 | 2020-08-14 | Madison | Montana | 30057 | 84 | 1 |
429420 | 429420 | 2020-08-13 | Madison | Montana | 30057 | 83 | 1 |
426196 | 426196 | 2020-08-12 | Madison | Montana | 30057 | 83 | 1 |
422974 | 422974 | 2020-08-11 | Madison | Montana | 30057 | 84 | 1 |
419752 | 419752 | 2020-08-10 | Madison | Montana | 30057 | 84 | 1 |
416531 | 416531 | 2020-08-09 | Madison | Montana | 30057 | 84 | 1 |
413311 | 413311 | 2020-08-08 | Madison | Montana | 30057 | 87 | 1 |
410091 | 410091 | 2020-08-07 | Madison | Montana | 30057 | 82 | 1 |
406871 | 406871 | 2020-08-06 | Madison | Montana | 30057 | 79 | 1 |
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);