ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2020-12-18 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
840721 | 840721 | 2020-12-18 | Adams | Mississippi | 28001 | 1669 | 53 |
840722 | 840722 | 2020-12-18 | Alcorn | Mississippi | 28003 | 1915 | 37 |
840723 | 840723 | 2020-12-18 | Amite | Mississippi | 28005 | 777 | 19 |
840724 | 840724 | 2020-12-18 | Attala | Mississippi | 28007 | 1509 | 43 |
840725 | 840725 | 2020-12-18 | Benton | Mississippi | 28009 | 590 | 20 |
840726 | 840726 | 2020-12-18 | Bolivar | Mississippi | 28011 | 2993 | 91 |
840727 | 840727 | 2020-12-18 | Calhoun | Mississippi | 28013 | 972 | 16 |
840728 | 840728 | 2020-12-18 | Carroll | Mississippi | 28015 | 883 | 17 |
840729 | 840729 | 2020-12-18 | Chickasaw | Mississippi | 28017 | 1381 | 35 |
840730 | 840730 | 2020-12-18 | Choctaw | Mississippi | 28019 | 445 | 10 |
840731 | 840731 | 2020-12-18 | Claiborne | Mississippi | 28021 | 640 | 18 |
840732 | 840732 | 2020-12-18 | Clarke | Mississippi | 28023 | 1096 | 55 |
840733 | 840733 | 2020-12-18 | Clay | Mississippi | 28025 | 1158 | 29 |
840734 | 840734 | 2020-12-18 | Coahoma | Mississippi | 28027 | 1795 | 48 |
840735 | 840735 | 2020-12-18 | Copiah | Mississippi | 28029 | 2024 | 42 |
840736 | 840736 | 2020-12-18 | Covington | Mississippi | 28031 | 1656 | 63 |
840737 | 840737 | 2020-12-18 | DeSoto | Mississippi | 28033 | 12746 | 121 |
840738 | 840738 | 2020-12-18 | Forrest | Mississippi | 28035 | 4712 | 93 |
840739 | 840739 | 2020-12-18 | Franklin | Mississippi | 28037 | 501 | 6 |
840740 | 840740 | 2020-12-18 | George | Mississippi | 28039 | 1557 | 32 |
840741 | 840741 | 2020-12-18 | Greene | Mississippi | 28041 | 904 | 25 |
840742 | 840742 | 2020-12-18 | Grenada | Mississippi | 28043 | 1807 | 53 |
840743 | 840743 | 2020-12-18 | Hancock | Mississippi | 28045 | 1644 | 49 |
840744 | 840744 | 2020-12-18 | Harrison | Mississippi | 28047 | 9262 | 133 |
840745 | 840745 | 2020-12-18 | Hinds | Mississippi | 28049 | 12498 | 233 |
840746 | 840746 | 2020-12-18 | Holmes | Mississippi | 28051 | 1505 | 63 |
840747 | 840747 | 2020-12-18 | Humphreys | Mississippi | 28053 | 657 | 21 |
840748 | 840748 | 2020-12-18 | Issaquena | Mississippi | 28055 | 140 | 4 |
840749 | 840749 | 2020-12-18 | Itawamba | Mississippi | 28057 | 1960 | 46 |
840750 | 840750 | 2020-12-18 | Jackson | Mississippi | 28059 | 7779 | 145 |
840751 | 840751 | 2020-12-18 | Jasper | Mississippi | 28061 | 1156 | 24 |
840752 | 840752 | 2020-12-18 | Jefferson | Mississippi | 28063 | 445 | 12 |
840753 | 840753 | 2020-12-18 | Jefferson Davis | Mississippi | 28065 | 701 | 21 |
840754 | 840754 | 2020-12-18 | Jones | Mississippi | 28067 | 4602 | 92 |
840755 | 840755 | 2020-12-18 | Kemper | Mississippi | 28069 | 621 | 19 |
840756 | 840756 | 2020-12-18 | Lafayette | Mississippi | 28071 | 3798 | 70 |
840757 | 840757 | 2020-12-18 | Lamar | Mississippi | 28073 | 3646 | 52 |
840758 | 840758 | 2020-12-18 | Lauderdale | Mississippi | 28075 | 4409 | 161 |
840759 | 840759 | 2020-12-18 | Lawrence | Mississippi | 28077 | 866 | 15 |
840760 | 840760 | 2020-12-18 | Leake | Mississippi | 28079 | 1737 | 45 |
840761 | 840761 | 2020-12-18 | Lee | Mississippi | 28081 | 6675 | 106 |
840762 | 840762 | 2020-12-18 | Leflore | Mississippi | 28083 | 2408 | 98 |
840763 | 840763 | 2020-12-18 | Lincoln | Mississippi | 28085 | 2291 | 73 |
840764 | 840764 | 2020-12-18 | Lowndes | Mississippi | 28087 | 3603 | 76 |
840765 | 840765 | 2020-12-18 | Madison | Mississippi | 28089 | 6327 | 126 |
840766 | 840766 | 2020-12-18 | Marion | Mississippi | 28091 | 1543 | 55 |
840767 | 840767 | 2020-12-18 | Marshall | Mississippi | 28093 | 2610 | 59 |
840768 | 840768 | 2020-12-18 | Monroe | Mississippi | 28095 | 2613 | 83 |
840769 | 840769 | 2020-12-18 | Montgomery | Mississippi | 28097 | 916 | 30 |
840770 | 840770 | 2020-12-18 | Neshoba | Mississippi | 28099 | 2698 | 133 |
840771 | 840771 | 2020-12-18 | Newton | Mississippi | 28101 | 1395 | 32 |
840772 | 840772 | 2020-12-18 | Noxubee | Mississippi | 28103 | 848 | 17 |
840773 | 840773 | 2020-12-18 | Oktibbeha | Mississippi | 28105 | 3018 | 67 |
840774 | 840774 | 2020-12-18 | Panola | Mississippi | 28107 | 2824 | 67 |
840775 | 840775 | 2020-12-18 | Pearl River | Mississippi | 28109 | 2177 | 75 |
840776 | 840776 | 2020-12-18 | Perry | Mississippi | 28111 | 769 | 30 |
840777 | 840777 | 2020-12-18 | Pike | Mississippi | 28113 | 1964 | 65 |
840778 | 840778 | 2020-12-18 | Pontotoc | Mississippi | 28115 | 2717 | 34 |
840779 | 840779 | 2020-12-18 | Prentiss | Mississippi | 28117 | 1846 | 40 |
840780 | 840780 | 2020-12-18 | Quitman | Mississippi | 28119 | 561 | 7 |
840781 | 840781 | 2020-12-18 | Rankin | Mississippi | 28121 | 7741 | 142 |
840782 | 840782 | 2020-12-18 | Scott | Mississippi | 28123 | 1892 | 34 |
840783 | 840783 | 2020-12-18 | Sharkey | Mississippi | 28125 | 368 | 17 |
840784 | 840784 | 2020-12-18 | Simpson | Mississippi | 28127 | 1796 | 57 |
840785 | 840785 | 2020-12-18 | Smith | Mississippi | 28129 | 913 | 17 |
840786 | 840786 | 2020-12-18 | Stone | Mississippi | 28131 | 1023 | 18 |
840787 | 840787 | 2020-12-18 | Sunflower | Mississippi | 28133 | 2190 | 57 |
840788 | 840788 | 2020-12-18 | Tallahatchie | Mississippi | 28135 | 1121 | 29 |
840789 | 840789 | 2020-12-18 | Tate | Mississippi | 28137 | 2174 | 53 |
840790 | 840790 | 2020-12-18 | Tippah | Mississippi | 28139 | 1732 | 37 |
840791 | 840791 | 2020-12-18 | Tishomingo | Mississippi | 28141 | 1389 | 49 |
840792 | 840792 | 2020-12-18 | Tunica | Mississippi | 28143 | 684 | 19 |
840793 | 840793 | 2020-12-18 | Union | Mississippi | 28145 | 2390 | 27 |
840794 | 840794 | 2020-12-18 | Walthall | Mississippi | 28147 | 904 | 32 |
840795 | 840795 | 2020-12-18 | Warren | Mississippi | 28149 | 2269 | 68 |
840796 | 840796 | 2020-12-18 | Washington | Mississippi | 28151 | 3778 | 111 |
840797 | 840797 | 2020-12-18 | Wayne | Mississippi | 28153 | 1522 | 25 |
840798 | 840798 | 2020-12-18 | Webster | Mississippi | 28155 | 642 | 17 |
840799 | 840799 | 2020-12-18 | Wilkinson | Mississippi | 28157 | 494 | 22 |
840800 | 840800 | 2020-12-18 | Winston | Mississippi | 28159 | 1628 | 44 |
840801 | 840801 | 2020-12-18 | Yalobusha | Mississippi | 28161 | 866 | 30 |
840802 | 840802 | 2020-12-18 | Yazoo | Mississippi | 28163 | 1936 | 45 |
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);