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 2021-01-20 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 |
---|---|---|---|---|---|---|---|
947815 | 947815 | 2021-01-20 | Adams | Mississippi | 28001 | 2078 | 70 |
947816 | 947816 | 2021-01-20 | Alcorn | Mississippi | 28003 | 2674 | 54 |
947817 | 947817 | 2021-01-20 | Amite | Mississippi | 28005 | 988 | 26 |
947818 | 947818 | 2021-01-20 | Attala | Mississippi | 28007 | 1946 | 59 |
947819 | 947819 | 2021-01-20 | Benton | Mississippi | 28009 | 833 | 23 |
947820 | 947820 | 2021-01-20 | Bolivar | Mississippi | 28011 | 4024 | 109 |
947821 | 947821 | 2021-01-20 | Calhoun | Mississippi | 28013 | 1376 | 21 |
947822 | 947822 | 2021-01-20 | Carroll | Mississippi | 28015 | 1053 | 21 |
947823 | 947823 | 2021-01-20 | Chickasaw | Mississippi | 28017 | 1857 | 44 |
947824 | 947824 | 2021-01-20 | Choctaw | Mississippi | 28019 | 612 | 13 |
947825 | 947825 | 2021-01-20 | Claiborne | Mississippi | 28021 | 866 | 25 |
947826 | 947826 | 2021-01-20 | Clarke | Mississippi | 28023 | 1417 | 62 |
947827 | 947827 | 2021-01-20 | Clay | Mississippi | 28025 | 1613 | 35 |
947828 | 947828 | 2021-01-20 | Coahoma | Mississippi | 28027 | 2422 | 54 |
947829 | 947829 | 2021-01-20 | Copiah | Mississippi | 28029 | 2439 | 49 |
947830 | 947830 | 2021-01-20 | Covington | Mississippi | 28031 | 2150 | 72 |
947831 | 947831 | 2021-01-20 | DeSoto | Mississippi | 28033 | 17331 | 186 |
947832 | 947832 | 2021-01-20 | Forrest | Mississippi | 28035 | 6038 | 120 |
947833 | 947833 | 2021-01-20 | Franklin | Mississippi | 28037 | 671 | 15 |
947834 | 947834 | 2021-01-20 | George | Mississippi | 28039 | 2019 | 39 |
947835 | 947835 | 2021-01-20 | Greene | Mississippi | 28041 | 1110 | 29 |
947836 | 947836 | 2021-01-20 | Grenada | Mississippi | 28043 | 2206 | 71 |
947837 | 947837 | 2021-01-20 | Hancock | Mississippi | 28045 | 2825 | 59 |
947838 | 947838 | 2021-01-20 | Harrison | Mississippi | 28047 | 13731 | 199 |
947839 | 947839 | 2021-01-20 | Hinds | Mississippi | 28049 | 16373 | 328 |
947840 | 947840 | 2021-01-20 | Holmes | Mississippi | 28051 | 1691 | 68 |
947841 | 947841 | 2021-01-20 | Humphreys | Mississippi | 28053 | 833 | 24 |
947842 | 947842 | 2021-01-20 | Issaquena | Mississippi | 28055 | 159 | 6 |
947843 | 947843 | 2021-01-20 | Itawamba | Mississippi | 28057 | 2652 | 60 |
947844 | 947844 | 2021-01-20 | Jackson | Mississippi | 28059 | 10557 | 187 |
947845 | 947845 | 2021-01-20 | Jasper | Mississippi | 28061 | 1744 | 38 |
947846 | 947846 | 2021-01-20 | Jefferson | Mississippi | 28063 | 554 | 19 |
947847 | 947847 | 2021-01-20 | Jefferson Davis | Mississippi | 28065 | 858 | 27 |
947848 | 947848 | 2021-01-20 | Jones | Mississippi | 28067 | 6483 | 112 |
947849 | 947849 | 2021-01-20 | Kemper | Mississippi | 28069 | 784 | 20 |
947850 | 947850 | 2021-01-20 | Lafayette | Mississippi | 28071 | 5031 | 93 |
947851 | 947851 | 2021-01-20 | Lamar | Mississippi | 28073 | 4908 | 65 |
947852 | 947852 | 2021-01-20 | Lauderdale | Mississippi | 28075 | 5965 | 187 |
947853 | 947853 | 2021-01-20 | Lawrence | Mississippi | 28077 | 1032 | 17 |
947854 | 947854 | 2021-01-20 | Leake | Mississippi | 28079 | 2329 | 66 |
947855 | 947855 | 2021-01-20 | Lee | Mississippi | 28081 | 8922 | 141 |
947856 | 947856 | 2021-01-20 | Leflore | Mississippi | 28083 | 3059 | 107 |
947857 | 947857 | 2021-01-20 | Lincoln | Mississippi | 28085 | 2993 | 86 |
947858 | 947858 | 2021-01-20 | Lowndes | Mississippi | 28087 | 5425 | 118 |
947859 | 947859 | 2021-01-20 | Madison | Mississippi | 28089 | 8335 | 166 |
947860 | 947860 | 2021-01-20 | Marion | Mississippi | 28091 | 2150 | 73 |
947861 | 947861 | 2021-01-20 | Marshall | Mississippi | 28093 | 3477 | 69 |
947862 | 947862 | 2021-01-20 | Monroe | Mississippi | 28095 | 3591 | 105 |
947863 | 947863 | 2021-01-20 | Montgomery | Mississippi | 28097 | 1101 | 36 |
947864 | 947864 | 2021-01-20 | Neshoba | Mississippi | 28099 | 3413 | 152 |
947865 | 947865 | 2021-01-20 | Newton | Mississippi | 28101 | 1950 | 44 |
947866 | 947866 | 2021-01-20 | Noxubee | Mississippi | 28103 | 1114 | 23 |
947867 | 947867 | 2021-01-20 | Oktibbeha | Mississippi | 28105 | 3976 | 81 |
947868 | 947868 | 2021-01-20 | Panola | Mississippi | 28107 | 3746 | 80 |
947869 | 947869 | 2021-01-20 | Pearl River | Mississippi | 28109 | 3329 | 103 |
947870 | 947870 | 2021-01-20 | Perry | Mississippi | 28111 | 1028 | 31 |
947871 | 947871 | 2021-01-20 | Pike | Mississippi | 28113 | 2646 | 79 |
947872 | 947872 | 2021-01-20 | Pontotoc | Mississippi | 28115 | 3698 | 55 |
947873 | 947873 | 2021-01-20 | Prentiss | Mississippi | 28117 | 2482 | 52 |
947874 | 947874 | 2021-01-20 | Quitman | Mississippi | 28119 | 696 | 9 |
947875 | 947875 | 2021-01-20 | Rankin | Mississippi | 28121 | 10854 | 217 |
947876 | 947876 | 2021-01-20 | Scott | Mississippi | 28123 | 2508 | 47 |
947877 | 947877 | 2021-01-20 | Sharkey | Mississippi | 28125 | 440 | 17 |
947878 | 947878 | 2021-01-20 | Simpson | Mississippi | 28127 | 2383 | 68 |
947879 | 947879 | 2021-01-20 | Smith | Mississippi | 28129 | 1227 | 25 |
947880 | 947880 | 2021-01-20 | Stone | Mississippi | 28131 | 1459 | 21 |
947881 | 947881 | 2021-01-20 | Sunflower | Mississippi | 28133 | 2882 | 71 |
947882 | 947882 | 2021-01-20 | Tallahatchie | Mississippi | 28135 | 1482 | 35 |
947883 | 947883 | 2021-01-20 | Tate | Mississippi | 28137 | 2743 | 62 |
947884 | 947884 | 2021-01-20 | Tippah | Mississippi | 28139 | 2444 | 50 |
947885 | 947885 | 2021-01-20 | Tishomingo | Mississippi | 28141 | 1916 | 61 |
947886 | 947886 | 2021-01-20 | Tunica | Mississippi | 28143 | 874 | 21 |
947887 | 947887 | 2021-01-20 | Union | Mississippi | 28145 | 3480 | 63 |
947888 | 947888 | 2021-01-20 | Walthall | Mississippi | 28147 | 1128 | 36 |
947889 | 947889 | 2021-01-20 | Warren | Mississippi | 28149 | 3569 | 100 |
947890 | 947890 | 2021-01-20 | Washington | Mississippi | 28151 | 4826 | 124 |
947891 | 947891 | 2021-01-20 | Wayne | Mississippi | 28153 | 2032 | 32 |
947892 | 947892 | 2021-01-20 | Webster | Mississippi | 28155 | 939 | 24 |
947893 | 947893 | 2021-01-20 | Wilkinson | Mississippi | 28157 | 588 | 25 |
947894 | 947894 | 2021-01-20 | Winston | Mississippi | 28159 | 2026 | 67 |
947895 | 947895 | 2021-01-20 | Yalobusha | Mississippi | 28161 | 1191 | 34 |
947896 | 947896 | 2021-01-20 | Yazoo | Mississippi | 28163 | 2473 | 56 |
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);