ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908916 | 908916 | 2021-01-08 | Madison | Mississippi | 28089 | 7723 | 149 |
905670 | 905670 | 2021-01-07 | Madison | Mississippi | 28089 | 7651 | 147 |
902425 | 902425 | 2021-01-06 | Madison | Mississippi | 28089 | 7551 | 146 |
899180 | 899180 | 2021-01-05 | Madison | Mississippi | 28089 | 7447 | 145 |
895935 | 895935 | 2021-01-04 | Madison | Mississippi | 28089 | 7418 | 139 |
892688 | 892688 | 2021-01-03 | Madison | Mississippi | 28089 | 7372 | 138 |
889442 | 889442 | 2021-01-02 | Madison | Mississippi | 28089 | 7342 | 137 |
886196 | 886196 | 2021-01-01 | Madison | Mississippi | 28089 | 7294 | 136 |
882951 | 882951 | 2020-12-31 | Madison | Mississippi | 28089 | 7194 | 136 |
879706 | 879706 | 2020-12-30 | Madison | Mississippi | 28089 | 7079 | 132 |
876461 | 876461 | 2020-12-29 | Madison | Mississippi | 28089 | 6961 | 131 |
873216 | 873216 | 2020-12-28 | Madison | Mississippi | 28089 | 6905 | 129 |
869971 | 869971 | 2020-12-27 | Madison | Mississippi | 28089 | 6859 | 129 |
866726 | 866726 | 2020-12-26 | Madison | Mississippi | 28089 | 6815 | 128 |
863481 | 863481 | 2020-12-25 | Madison | Mississippi | 28089 | 6783 | 128 |
860236 | 860236 | 2020-12-24 | Madison | Mississippi | 28089 | 6733 | 128 |
856991 | 856991 | 2020-12-23 | Madison | Mississippi | 28089 | 6665 | 127 |
853746 | 853746 | 2020-12-22 | Madison | Mississippi | 28089 | 6568 | 127 |
850501 | 850501 | 2020-12-21 | Madison | Mississippi | 28089 | 6517 | 126 |
847256 | 847256 | 2020-12-20 | Madison | Mississippi | 28089 | 6482 | 126 |
844010 | 844010 | 2020-12-19 | Madison | Mississippi | 28089 | 6379 | 126 |
840765 | 840765 | 2020-12-18 | Madison | Mississippi | 28089 | 6327 | 126 |
837520 | 837520 | 2020-12-17 | Madison | Mississippi | 28089 | 6196 | 125 |
834274 | 834274 | 2020-12-16 | Madison | Mississippi | 28089 | 6114 | 123 |
831027 | 831027 | 2020-12-15 | Madison | Mississippi | 28089 | 5997 | 122 |
827781 | 827781 | 2020-12-14 | Madison | Mississippi | 28089 | 5927 | 122 |
824534 | 824534 | 2020-12-13 | Madison | Mississippi | 28089 | 5889 | 122 |
821288 | 821288 | 2020-12-12 | Madison | Mississippi | 28089 | 5836 | 121 |
818042 | 818042 | 2020-12-11 | Madison | Mississippi | 28089 | 5726 | 121 |
814796 | 814796 | 2020-12-10 | Madison | Mississippi | 28089 | 5639 | 119 |
811551 | 811551 | 2020-12-09 | Madison | Mississippi | 28089 | 5532 | 118 |
808306 | 808306 | 2020-12-08 | Madison | Mississippi | 28089 | 5478 | 114 |
805061 | 805061 | 2020-12-07 | Madison | Mississippi | 28089 | 5433 | 113 |
801816 | 801816 | 2020-12-06 | Madison | Mississippi | 28089 | 5408 | 113 |
798571 | 798571 | 2020-12-05 | Madison | Mississippi | 28089 | 5368 | 113 |
795326 | 795326 | 2020-12-04 | Madison | Mississippi | 28089 | 5311 | 112 |
792081 | 792081 | 2020-12-03 | Madison | Mississippi | 28089 | 5202 | 110 |
788836 | 788836 | 2020-12-02 | Madison | Mississippi | 28089 | 5120 | 107 |
785591 | 785591 | 2020-12-01 | Madison | Mississippi | 28089 | 5014 | 107 |
782347 | 782347 | 2020-11-30 | Madison | Mississippi | 28089 | 4964 | 107 |
779101 | 779101 | 2020-11-29 | Madison | Mississippi | 28089 | 4902 | 107 |
775856 | 775856 | 2020-11-28 | Madison | Mississippi | 28089 | 4799 | 106 |
772611 | 772611 | 2020-11-27 | Madison | Mississippi | 28089 | 4734 | 106 |
769366 | 769366 | 2020-11-26 | Madison | Mississippi | 28089 | 4711 | 106 |
766120 | 766120 | 2020-11-25 | Madison | Mississippi | 28089 | 4666 | 106 |
762875 | 762875 | 2020-11-24 | Madison | Mississippi | 28089 | 4633 | 105 |
759630 | 759630 | 2020-11-23 | Madison | Mississippi | 28089 | 4602 | 102 |
756383 | 756383 | 2020-11-22 | Madison | Mississippi | 28089 | 4595 | 102 |
753137 | 753137 | 2020-11-21 | Madison | Mississippi | 28089 | 4573 | 102 |
749891 | 749891 | 2020-11-20 | Madison | Mississippi | 28089 | 4498 | 101 |
746645 | 746645 | 2020-11-19 | Madison | Mississippi | 28089 | 4462 | 99 |
743398 | 743398 | 2020-11-18 | Madison | Mississippi | 28089 | 4402 | 99 |
740151 | 740151 | 2020-11-17 | Madison | Mississippi | 28089 | 4339 | 98 |
736907 | 736907 | 2020-11-16 | Madison | Mississippi | 28089 | 4311 | 97 |
733661 | 733661 | 2020-11-15 | Madison | Mississippi | 28089 | 4300 | 97 |
730416 | 730416 | 2020-11-14 | Madison | Mississippi | 28089 | 4282 | 97 |
727173 | 727173 | 2020-11-13 | Madison | Mississippi | 28089 | 4244 | 97 |
723930 | 723930 | 2020-11-12 | Madison | Mississippi | 28089 | 4201 | 97 |
720687 | 720687 | 2020-11-11 | Madison | Mississippi | 28089 | 4146 | 96 |
717444 | 717444 | 2020-11-10 | Madison | Mississippi | 28089 | 4120 | 96 |
714200 | 714200 | 2020-11-09 | Madison | Mississippi | 28089 | 4098 | 94 |
710956 | 710956 | 2020-11-08 | Madison | Mississippi | 28089 | 4081 | 94 |
707712 | 707712 | 2020-11-07 | Madison | Mississippi | 28089 | 4034 | 94 |
704469 | 704469 | 2020-11-06 | Madison | Mississippi | 28089 | 4005 | 94 |
701227 | 701227 | 2020-11-05 | Madison | Mississippi | 28089 | 3986 | 94 |
697983 | 697983 | 2020-11-04 | Madison | Mississippi | 28089 | 3958 | 94 |
694740 | 694740 | 2020-11-03 | Madison | Mississippi | 28089 | 3930 | 94 |
691498 | 691498 | 2020-11-02 | Madison | Mississippi | 28089 | 3918 | 94 |
688253 | 688253 | 2020-11-01 | Madison | Mississippi | 28089 | 3914 | 94 |
685009 | 685009 | 2020-10-31 | Madison | Mississippi | 28089 | 3909 | 94 |
681766 | 681766 | 2020-10-30 | Madison | Mississippi | 28089 | 3894 | 94 |
678522 | 678522 | 2020-10-29 | Madison | Mississippi | 28089 | 3880 | 94 |
675280 | 675280 | 2020-10-28 | Madison | Mississippi | 28089 | 3861 | 94 |
672037 | 672037 | 2020-10-27 | Madison | Mississippi | 28089 | 3843 | 94 |
668795 | 668795 | 2020-10-26 | Madison | Mississippi | 28089 | 3837 | 94 |
665551 | 665551 | 2020-10-25 | Madison | Mississippi | 28089 | 3831 | 94 |
662306 | 662306 | 2020-10-24 | Madison | Mississippi | 28089 | 3831 | 94 |
659062 | 659062 | 2020-10-23 | Madison | Mississippi | 28089 | 3812 | 93 |
655817 | 655817 | 2020-10-22 | Madison | Mississippi | 28089 | 3779 | 93 |
652572 | 652572 | 2020-10-21 | Madison | Mississippi | 28089 | 3757 | 93 |
649327 | 649327 | 2020-10-20 | Madison | Mississippi | 28089 | 3739 | 93 |
646083 | 646083 | 2020-10-19 | Madison | Mississippi | 28089 | 3717 | 92 |
642836 | 642836 | 2020-10-18 | Madison | Mississippi | 28089 | 3710 | 92 |
639589 | 639589 | 2020-10-17 | Madison | Mississippi | 28089 | 3710 | 92 |
636343 | 636343 | 2020-10-16 | Madison | Mississippi | 28089 | 3683 | 92 |
633097 | 633097 | 2020-10-15 | Madison | Mississippi | 28089 | 3623 | 92 |
629852 | 629852 | 2020-10-14 | Madison | Mississippi | 28089 | 3552 | 92 |
626608 | 626608 | 2020-10-13 | Madison | Mississippi | 28089 | 3526 | 92 |
623366 | 623366 | 2020-10-12 | Madison | Mississippi | 28089 | 3511 | 92 |
620123 | 620123 | 2020-10-11 | Madison | Mississippi | 28089 | 3504 | 92 |
616881 | 616881 | 2020-10-10 | Madison | Mississippi | 28089 | 3501 | 92 |
613640 | 613640 | 2020-10-09 | Madison | Mississippi | 28089 | 3481 | 91 |
610398 | 610398 | 2020-10-08 | Madison | Mississippi | 28089 | 3463 | 91 |
607156 | 607156 | 2020-10-07 | Madison | Mississippi | 28089 | 3451 | 90 |
603913 | 603913 | 2020-10-06 | Madison | Mississippi | 28089 | 3441 | 90 |
600671 | 600671 | 2020-10-05 | Madison | Mississippi | 28089 | 3405 | 90 |
597428 | 597428 | 2020-10-04 | Madison | Mississippi | 28089 | 3389 | 90 |
594187 | 594187 | 2020-10-03 | Madison | Mississippi | 28089 | 3387 | 90 |
590946 | 590946 | 2020-10-02 | Madison | Mississippi | 28089 | 3374 | 90 |
587705 | 587705 | 2020-10-01 | Madison | Mississippi | 28089 | 3363 | 90 |
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);