ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
493786 | 493786 | 2020-09-02 | Adams | Mississippi | 28001 | 797 | 32 |
493787 | 493787 | 2020-09-02 | Alcorn | Mississippi | 28003 | 654 | 6 |
493788 | 493788 | 2020-09-02 | Amite | Mississippi | 28005 | 279 | 7 |
493789 | 493789 | 2020-09-02 | Attala | Mississippi | 28007 | 592 | 25 |
493790 | 493790 | 2020-09-02 | Benton | Mississippi | 28009 | 196 | 1 |
493791 | 493791 | 2020-09-02 | Bolivar | Mississippi | 28011 | 1556 | 54 |
493792 | 493792 | 2020-09-02 | Calhoun | Mississippi | 28013 | 482 | 11 |
493793 | 493793 | 2020-09-02 | Carroll | Mississippi | 28015 | 294 | 12 |
493794 | 493794 | 2020-09-02 | Chickasaw | Mississippi | 28017 | 600 | 22 |
493795 | 493795 | 2020-09-02 | Choctaw | Mississippi | 28019 | 158 | 4 |
493796 | 493796 | 2020-09-02 | Claiborne | Mississippi | 28021 | 441 | 16 |
493797 | 493797 | 2020-09-02 | Clarke | Mississippi | 28023 | 477 | 30 |
493798 | 493798 | 2020-09-02 | Clay | Mississippi | 28025 | 483 | 16 |
493799 | 493799 | 2020-09-02 | Coahoma | Mississippi | 28027 | 1013 | 20 |
493800 | 493800 | 2020-09-02 | Copiah | Mississippi | 28029 | 1103 | 31 |
493801 | 493801 | 2020-09-02 | Covington | Mississippi | 28031 | 725 | 17 |
493802 | 493802 | 2020-09-02 | DeSoto | Mississippi | 28033 | 4713 | 48 |
493803 | 493803 | 2020-09-02 | Forrest | Mississippi | 28035 | 2165 | 66 |
493804 | 493804 | 2020-09-02 | Franklin | Mississippi | 28037 | 178 | 3 |
493805 | 493805 | 2020-09-02 | George | Mississippi | 28039 | 687 | 13 |
493806 | 493806 | 2020-09-02 | Greene | Mississippi | 28041 | 300 | 14 |
493807 | 493807 | 2020-09-02 | Grenada | Mississippi | 28043 | 966 | 32 |
493808 | 493808 | 2020-09-02 | Hancock | Mississippi | 28045 | 502 | 20 |
493809 | 493809 | 2020-09-02 | Harrison | Mississippi | 28047 | 3375 | 58 |
493810 | 493810 | 2020-09-02 | Hinds | Mississippi | 28049 | 6564 | 140 |
493811 | 493811 | 2020-09-02 | Holmes | Mississippi | 28051 | 1047 | 54 |
493812 | 493812 | 2020-09-02 | Humphreys | Mississippi | 28053 | 342 | 15 |
493813 | 493813 | 2020-09-02 | Issaquena | Mississippi | 28055 | 99 | 3 |
493814 | 493814 | 2020-09-02 | Itawamba | Mississippi | 28057 | 592 | 17 |
493815 | 493815 | 2020-09-02 | Jackson | Mississippi | 28059 | 3073 | 60 |
493816 | 493816 | 2020-09-02 | Jasper | Mississippi | 28061 | 486 | 13 |
493817 | 493817 | 2020-09-02 | Jefferson | Mississippi | 28063 | 222 | 9 |
493818 | 493818 | 2020-09-02 | Jefferson Davis | Mississippi | 28065 | 307 | 9 |
493819 | 493819 | 2020-09-02 | Jones | Mississippi | 28067 | 2178 | 74 |
493820 | 493820 | 2020-09-02 | Kemper | Mississippi | 28069 | 275 | 15 |
493821 | 493821 | 2020-09-02 | Lafayette | Mississippi | 28071 | 1527 | 38 |
493822 | 493822 | 2020-09-02 | Lamar | Mississippi | 28073 | 1447 | 31 |
493823 | 493823 | 2020-09-02 | Lauderdale | Mississippi | 28075 | 1817 | 108 |
493824 | 493824 | 2020-09-02 | Lawrence | Mississippi | 28077 | 406 | 11 |
493825 | 493825 | 2020-09-02 | Leake | Mississippi | 28079 | 890 | 31 |
493826 | 493826 | 2020-09-02 | Lee | Mississippi | 28081 | 2240 | 60 |
493827 | 493827 | 2020-09-02 | Leflore | Mississippi | 28083 | 1248 | 75 |
493828 | 493828 | 2020-09-02 | Lincoln | Mississippi | 28085 | 981 | 51 |
493829 | 493829 | 2020-09-02 | Lowndes | Mississippi | 28087 | 1297 | 55 |
493830 | 493830 | 2020-09-02 | Madison | Mississippi | 28089 | 3009 | 83 |
493831 | 493831 | 2020-09-02 | Marion | Mississippi | 28091 | 787 | 26 |
493832 | 493832 | 2020-09-02 | Marshall | Mississippi | 28093 | 971 | 13 |
493833 | 493833 | 2020-09-02 | Monroe | Mississippi | 28095 | 1059 | 60 |
493834 | 493834 | 2020-09-02 | Montgomery | Mississippi | 28097 | 411 | 18 |
493835 | 493835 | 2020-09-02 | Neshoba | Mississippi | 28099 | 1439 | 101 |
493836 | 493836 | 2020-09-02 | Newton | Mississippi | 28101 | 679 | 18 |
493837 | 493837 | 2020-09-02 | Noxubee | Mississippi | 28103 | 523 | 14 |
493838 | 493838 | 2020-09-02 | Oktibbeha | Mississippi | 28105 | 1497 | 46 |
493839 | 493839 | 2020-09-02 | Panola | Mississippi | 28107 | 1307 | 23 |
493840 | 493840 | 2020-09-02 | Pearl River | Mississippi | 28109 | 758 | 48 |
493841 | 493841 | 2020-09-02 | Perry | Mississippi | 28111 | 321 | 9 |
493842 | 493842 | 2020-09-02 | Pike | Mississippi | 28113 | 1145 | 45 |
493843 | 493843 | 2020-09-02 | Pontotoc | Mississippi | 28115 | 1085 | 13 |
493844 | 493844 | 2020-09-02 | Prentiss | Mississippi | 28117 | 644 | 15 |
493845 | 493845 | 2020-09-02 | Quitman | Mississippi | 28119 | 337 | 4 |
493846 | 493846 | 2020-09-02 | Rankin | Mississippi | 28121 | 2882 | 65 |
493847 | 493847 | 2020-09-02 | Scott | Mississippi | 28123 | 1108 | 22 |
493848 | 493848 | 2020-09-02 | Sharkey | Mississippi | 28125 | 245 | 9 |
493849 | 493849 | 2020-09-02 | Simpson | Mississippi | 28127 | 942 | 39 |
493850 | 493850 | 2020-09-02 | Smith | Mississippi | 28129 | 479 | 13 |
493851 | 493851 | 2020-09-02 | Stone | Mississippi | 28131 | 323 | 10 |
493852 | 493852 | 2020-09-02 | Sunflower | Mississippi | 28133 | 1278 | 39 |
493853 | 493853 | 2020-09-02 | Tallahatchie | Mississippi | 28135 | 647 | 13 |
493854 | 493854 | 2020-09-02 | Tate | Mississippi | 28137 | 864 | 35 |
493855 | 493855 | 2020-09-02 | Tippah | Mississippi | 28139 | 555 | 15 |
493856 | 493856 | 2020-09-02 | Tishomingo | Mississippi | 28141 | 566 | 30 |
493857 | 493857 | 2020-09-02 | Tunica | Mississippi | 28143 | 451 | 12 |
493858 | 493858 | 2020-09-02 | Union | Mississippi | 28145 | 894 | 23 |
493859 | 493859 | 2020-09-02 | Walthall | Mississippi | 28147 | 569 | 24 |
493860 | 493860 | 2020-09-02 | Warren | Mississippi | 28149 | 1317 | 46 |
493861 | 493861 | 2020-09-02 | Washington | Mississippi | 28151 | 2018 | 64 |
493862 | 493862 | 2020-09-02 | Wayne | Mississippi | 28153 | 850 | 21 |
493863 | 493863 | 2020-09-02 | Webster | Mississippi | 28155 | 307 | 13 |
493864 | 493864 | 2020-09-02 | Wilkinson | Mississippi | 28157 | 281 | 17 |
493865 | 493865 | 2020-09-02 | Winston | Mississippi | 28159 | 701 | 19 |
493866 | 493866 | 2020-09-02 | Yalobusha | Mississippi | 28161 | 381 | 13 |
493867 | 493867 | 2020-09-02 | Yazoo | Mississippi | 28163 | 961 | 21 |
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);