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-14 and state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|
827737 | 827737 | 2020-12-14 | Adams | Mississippi | 28001 | 1617 | 52 |
827738 | 827738 | 2020-12-14 | Alcorn | Mississippi | 28003 | 1838 | 35 |
827739 | 827739 | 2020-12-14 | Amite | Mississippi | 28005 | 751 | 16 |
827740 | 827740 | 2020-12-14 | Attala | Mississippi | 28007 | 1430 | 40 |
827741 | 827741 | 2020-12-14 | Benton | Mississippi | 28009 | 570 | 19 |
827742 | 827742 | 2020-12-14 | Bolivar | Mississippi | 28011 | 2828 | 89 |
827743 | 827743 | 2020-12-14 | Calhoun | Mississippi | 28013 | 913 | 15 |
827744 | 827744 | 2020-12-14 | Carroll | Mississippi | 28015 | 851 | 17 |
827745 | 827745 | 2020-12-14 | Chickasaw | Mississippi | 28017 | 1287 | 34 |
827746 | 827746 | 2020-12-14 | Choctaw | Mississippi | 28019 | 430 | 10 |
827747 | 827747 | 2020-12-14 | Claiborne | Mississippi | 28021 | 618 | 16 |
827748 | 827748 | 2020-12-14 | Clarke | Mississippi | 28023 | 1046 | 55 |
827749 | 827749 | 2020-12-14 | Clay | Mississippi | 28025 | 1094 | 28 |
827750 | 827750 | 2020-12-14 | Coahoma | Mississippi | 28027 | 1742 | 47 |
827751 | 827751 | 2020-12-14 | Copiah | Mississippi | 28029 | 1948 | 42 |
827752 | 827752 | 2020-12-14 | Covington | Mississippi | 28031 | 1584 | 61 |
827753 | 827753 | 2020-12-14 | DeSoto | Mississippi | 28033 | 12089 | 114 |
827754 | 827754 | 2020-12-14 | Forrest | Mississippi | 28035 | 4503 | 92 |
827755 | 827755 | 2020-12-14 | Franklin | Mississippi | 28037 | 467 | 6 |
827756 | 827756 | 2020-12-14 | George | Mississippi | 28039 | 1487 | 30 |
827757 | 827757 | 2020-12-14 | Greene | Mississippi | 28041 | 869 | 25 |
827758 | 827758 | 2020-12-14 | Grenada | Mississippi | 28043 | 1702 | 51 |
827759 | 827759 | 2020-12-14 | Hancock | Mississippi | 28045 | 1508 | 46 |
827760 | 827760 | 2020-12-14 | Harrison | Mississippi | 28047 | 8709 | 124 |
827761 | 827761 | 2020-12-14 | Hinds | Mississippi | 28049 | 11955 | 222 |
827762 | 827762 | 2020-12-14 | Holmes | Mississippi | 28051 | 1476 | 62 |
827763 | 827763 | 2020-12-14 | Humphreys | Mississippi | 28053 | 632 | 21 |
827764 | 827764 | 2020-12-14 | Issaquena | Mississippi | 28055 | 133 | 4 |
827765 | 827765 | 2020-12-14 | Itawamba | Mississippi | 28057 | 1850 | 43 |
827766 | 827766 | 2020-12-14 | Jackson | Mississippi | 28059 | 7459 | 142 |
827767 | 827767 | 2020-12-14 | Jasper | Mississippi | 28061 | 1059 | 24 |
827768 | 827768 | 2020-12-14 | Jefferson | Mississippi | 28063 | 424 | 12 |
827769 | 827769 | 2020-12-14 | Jefferson Davis | Mississippi | 28065 | 664 | 20 |
827770 | 827770 | 2020-12-14 | Jones | Mississippi | 28067 | 4374 | 91 |
827771 | 827771 | 2020-12-14 | Kemper | Mississippi | 28069 | 602 | 19 |
827772 | 827772 | 2020-12-14 | Lafayette | Mississippi | 28071 | 3671 | 67 |
827773 | 827773 | 2020-12-14 | Lamar | Mississippi | 28073 | 3468 | 52 |
827774 | 827774 | 2020-12-14 | Lauderdale | Mississippi | 28075 | 4220 | 157 |
827775 | 827775 | 2020-12-14 | Lawrence | Mississippi | 28077 | 829 | 15 |
827776 | 827776 | 2020-12-14 | Leake | Mississippi | 28079 | 1635 | 45 |
827777 | 827777 | 2020-12-14 | Lee | Mississippi | 28081 | 6321 | 105 |
827778 | 827778 | 2020-12-14 | Leflore | Mississippi | 28083 | 2324 | 96 |
827779 | 827779 | 2020-12-14 | Lincoln | Mississippi | 28085 | 2216 | 71 |
827780 | 827780 | 2020-12-14 | Lowndes | Mississippi | 28087 | 3235 | 72 |
827781 | 827781 | 2020-12-14 | Madison | Mississippi | 28089 | 5927 | 122 |
827782 | 827782 | 2020-12-14 | Marion | Mississippi | 28091 | 1472 | 54 |
827783 | 827783 | 2020-12-14 | Marshall | Mississippi | 28093 | 2517 | 56 |
827784 | 827784 | 2020-12-14 | Monroe | Mississippi | 28095 | 2459 | 80 |
827785 | 827785 | 2020-12-14 | Montgomery | Mississippi | 28097 | 889 | 30 |
827786 | 827786 | 2020-12-14 | Neshoba | Mississippi | 28099 | 2583 | 132 |
827787 | 827787 | 2020-12-14 | Newton | Mississippi | 28101 | 1327 | 31 |
827788 | 827788 | 2020-12-14 | Noxubee | Mississippi | 28103 | 814 | 17 |
827789 | 827789 | 2020-12-14 | Oktibbeha | Mississippi | 28105 | 2862 | 64 |
827790 | 827790 | 2020-12-14 | Panola | Mississippi | 28107 | 2712 | 65 |
827791 | 827791 | 2020-12-14 | Pearl River | Mississippi | 28109 | 2029 | 73 |
827792 | 827792 | 2020-12-14 | Perry | Mississippi | 28111 | 746 | 27 |
827793 | 827793 | 2020-12-14 | Pike | Mississippi | 28113 | 1896 | 63 |
827794 | 827794 | 2020-12-14 | Pontotoc | Mississippi | 28115 | 2552 | 32 |
827795 | 827795 | 2020-12-14 | Prentiss | Mississippi | 28117 | 1764 | 39 |
827796 | 827796 | 2020-12-14 | Quitman | Mississippi | 28119 | 544 | 7 |
827797 | 827797 | 2020-12-14 | Rankin | Mississippi | 28121 | 7285 | 129 |
827798 | 827798 | 2020-12-14 | Scott | Mississippi | 28123 | 1843 | 31 |
827799 | 827799 | 2020-12-14 | Sharkey | Mississippi | 28125 | 355 | 17 |
827800 | 827800 | 2020-12-14 | Simpson | Mississippi | 28127 | 1705 | 54 |
827801 | 827801 | 2020-12-14 | Smith | Mississippi | 28129 | 859 | 17 |
827802 | 827802 | 2020-12-14 | Stone | Mississippi | 28131 | 973 | 16 |
827803 | 827803 | 2020-12-14 | Sunflower | Mississippi | 28133 | 2121 | 57 |
827804 | 827804 | 2020-12-14 | Tallahatchie | Mississippi | 28135 | 1089 | 28 |
827805 | 827805 | 2020-12-14 | Tate | Mississippi | 28137 | 2090 | 52 |
827806 | 827806 | 2020-12-14 | Tippah | Mississippi | 28139 | 1616 | 36 |
827807 | 827807 | 2020-12-14 | Tishomingo | Mississippi | 28141 | 1323 | 47 |
827808 | 827808 | 2020-12-14 | Tunica | Mississippi | 28143 | 669 | 19 |
827809 | 827809 | 2020-12-14 | Union | Mississippi | 28145 | 2212 | 27 |
827810 | 827810 | 2020-12-14 | Walthall | Mississippi | 28147 | 877 | 32 |
827811 | 827811 | 2020-12-14 | Warren | Mississippi | 28149 | 2162 | 65 |
827812 | 827812 | 2020-12-14 | Washington | Mississippi | 28151 | 3660 | 109 |
827813 | 827813 | 2020-12-14 | Wayne | Mississippi | 28153 | 1455 | 25 |
827814 | 827814 | 2020-12-14 | Webster | Mississippi | 28155 | 611 | 16 |
827815 | 827815 | 2020-12-14 | Wilkinson | Mississippi | 28157 | 482 | 22 |
827816 | 827816 | 2020-12-14 | Winston | Mississippi | 28159 | 1545 | 37 |
827817 | 827817 | 2020-12-14 | Yalobusha | Mississippi | 28161 | 840 | 30 |
827818 | 827818 | 2020-12-14 | Yazoo | Mississippi | 28163 | 1802 | 42 |
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);