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-05-30 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1369862 | 1369862 | 2021-05-30 | Adams | Mississippi | 28001 | 2997 | 82 |
1369863 | 1369863 | 2021-05-30 | Alcorn | Mississippi | 28003 | 3160 | 71 |
1369864 | 1369864 | 2021-05-30 | Amite | Mississippi | 28005 | 1247 | 42 |
1369865 | 1369865 | 2021-05-30 | Attala | Mississippi | 28007 | 2146 | 73 |
1369866 | 1369866 | 2021-05-30 | Benton | Mississippi | 28009 | 1018 | 25 |
1369867 | 1369867 | 2021-05-30 | Bolivar | Mississippi | 28011 | 4812 | 133 |
1369868 | 1369868 | 2021-05-30 | Calhoun | Mississippi | 28013 | 1731 | 32 |
1369869 | 1369869 | 2021-05-30 | Carroll | Mississippi | 28015 | 1223 | 30 |
1369870 | 1369870 | 2021-05-30 | Chickasaw | Mississippi | 28017 | 2095 | 59 |
1369871 | 1369871 | 2021-05-30 | Choctaw | Mississippi | 28019 | 788 | 18 |
1369872 | 1369872 | 2021-05-30 | Claiborne | Mississippi | 28021 | 1028 | 30 |
1369873 | 1369873 | 2021-05-30 | Clarke | Mississippi | 28023 | 1788 | 80 |
1369874 | 1369874 | 2021-05-30 | Clay | Mississippi | 28025 | 1861 | 54 |
1369875 | 1369875 | 2021-05-30 | Coahoma | Mississippi | 28027 | 2975 | 81 |
1369876 | 1369876 | 2021-05-30 | Copiah | Mississippi | 28029 | 2988 | 65 |
1369877 | 1369877 | 2021-05-30 | Covington | Mississippi | 28031 | 2643 | 81 |
1369878 | 1369878 | 2021-05-30 | DeSoto | Mississippi | 28033 | 22098 | 261 |
1369879 | 1369879 | 2021-05-30 | Forrest | Mississippi | 28035 | 7765 | 153 |
1369880 | 1369880 | 2021-05-30 | Franklin | Mississippi | 28037 | 846 | 23 |
1369881 | 1369881 | 2021-05-30 | George | Mississippi | 28039 | 2505 | 48 |
1369882 | 1369882 | 2021-05-30 | Greene | Mississippi | 28041 | 1312 | 33 |
1369883 | 1369883 | 2021-05-30 | Grenada | Mississippi | 28043 | 2633 | 87 |
1369884 | 1369884 | 2021-05-30 | Hancock | Mississippi | 28045 | 3834 | 87 |
1369885 | 1369885 | 2021-05-30 | Harrison | Mississippi | 28047 | 18147 | 314 |
1369886 | 1369886 | 2021-05-30 | Hinds | Mississippi | 28049 | 20479 | 418 |
1369887 | 1369887 | 2021-05-30 | Holmes | Mississippi | 28051 | 1896 | 74 |
1369888 | 1369888 | 2021-05-30 | Humphreys | Mississippi | 28053 | 971 | 33 |
1369889 | 1369889 | 2021-05-30 | Issaquena | Mississippi | 28055 | 169 | 6 |
1369890 | 1369890 | 2021-05-30 | Itawamba | Mississippi | 28057 | 3038 | 77 |
1369891 | 1369891 | 2021-05-30 | Jackson | Mississippi | 28059 | 13549 | 248 |
1369892 | 1369892 | 2021-05-30 | Jasper | Mississippi | 28061 | 2214 | 48 |
1369893 | 1369893 | 2021-05-30 | Jefferson | Mississippi | 28063 | 661 | 28 |
1369894 | 1369894 | 2021-05-30 | Jefferson Davis | Mississippi | 28065 | 1073 | 33 |
1369895 | 1369895 | 2021-05-30 | Jones | Mississippi | 28067 | 8421 | 165 |
1369896 | 1369896 | 2021-05-30 | Kemper | Mississippi | 28069 | 962 | 28 |
1369897 | 1369897 | 2021-05-30 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1369898 | 1369898 | 2021-05-30 | Lamar | Mississippi | 28073 | 6283 | 88 |
1369899 | 1369899 | 2021-05-30 | Lauderdale | Mississippi | 28075 | 7226 | 240 |
1369900 | 1369900 | 2021-05-30 | Lawrence | Mississippi | 28077 | 1306 | 24 |
1369901 | 1369901 | 2021-05-30 | Leake | Mississippi | 28079 | 2703 | 74 |
1369902 | 1369902 | 2021-05-30 | Lee | Mississippi | 28081 | 10017 | 175 |
1369903 | 1369903 | 2021-05-30 | Leflore | Mississippi | 28083 | 3504 | 125 |
1369904 | 1369904 | 2021-05-30 | Lincoln | Mississippi | 28085 | 3992 | 111 |
1369905 | 1369905 | 2021-05-30 | Lowndes | Mississippi | 28087 | 6444 | 148 |
1369906 | 1369906 | 2021-05-30 | Madison | Mississippi | 28089 | 10184 | 224 |
1369907 | 1369907 | 2021-05-30 | Marion | Mississippi | 28091 | 2708 | 80 |
1369908 | 1369908 | 2021-05-30 | Marshall | Mississippi | 28093 | 4558 | 105 |
1369909 | 1369909 | 2021-05-30 | Monroe | Mississippi | 28095 | 4141 | 135 |
1369910 | 1369910 | 2021-05-30 | Montgomery | Mississippi | 28097 | 1282 | 43 |
1369911 | 1369911 | 2021-05-30 | Neshoba | Mississippi | 28099 | 4050 | 178 |
1369912 | 1369912 | 2021-05-30 | Newton | Mississippi | 28101 | 2476 | 62 |
1369913 | 1369913 | 2021-05-30 | Noxubee | Mississippi | 28103 | 1275 | 34 |
1369914 | 1369914 | 2021-05-30 | Oktibbeha | Mississippi | 28105 | 4649 | 98 |
1369915 | 1369915 | 2021-05-30 | Panola | Mississippi | 28107 | 4628 | 109 |
1369916 | 1369916 | 2021-05-30 | Pearl River | Mississippi | 28109 | 4550 | 146 |
1369917 | 1369917 | 2021-05-30 | Perry | Mississippi | 28111 | 1265 | 38 |
1369918 | 1369918 | 2021-05-30 | Pike | Mississippi | 28113 | 3352 | 107 |
1369919 | 1369919 | 2021-05-30 | Pontotoc | Mississippi | 28115 | 4230 | 73 |
1369920 | 1369920 | 2021-05-30 | Prentiss | Mississippi | 28117 | 2818 | 60 |
1369921 | 1369921 | 2021-05-30 | Quitman | Mississippi | 28119 | 816 | 16 |
1369922 | 1369922 | 2021-05-30 | Rankin | Mississippi | 28121 | 13787 | 280 |
1369923 | 1369923 | 2021-05-30 | Scott | Mississippi | 28123 | 3183 | 74 |
1369924 | 1369924 | 2021-05-30 | Sharkey | Mississippi | 28125 | 506 | 17 |
1369925 | 1369925 | 2021-05-30 | Simpson | Mississippi | 28127 | 2968 | 89 |
1369926 | 1369926 | 2021-05-30 | Smith | Mississippi | 28129 | 1633 | 34 |
1369927 | 1369927 | 2021-05-30 | Stone | Mississippi | 28131 | 1848 | 33 |
1369928 | 1369928 | 2021-05-30 | Sunflower | Mississippi | 28133 | 3379 | 91 |
1369929 | 1369929 | 2021-05-30 | Tallahatchie | Mississippi | 28135 | 1795 | 41 |
1369930 | 1369930 | 2021-05-30 | Tate | Mississippi | 28137 | 3402 | 85 |
1369931 | 1369931 | 2021-05-30 | Tippah | Mississippi | 28139 | 2901 | 68 |
1369932 | 1369932 | 2021-05-30 | Tishomingo | Mississippi | 28141 | 2298 | 67 |
1369933 | 1369933 | 2021-05-30 | Tunica | Mississippi | 28143 | 1076 | 26 |
1369934 | 1369934 | 2021-05-30 | Union | Mississippi | 28145 | 4139 | 76 |
1369935 | 1369935 | 2021-05-30 | Walthall | Mississippi | 28147 | 1349 | 46 |
1369936 | 1369936 | 2021-05-30 | Warren | Mississippi | 28149 | 4420 | 122 |
1369937 | 1369937 | 2021-05-30 | Washington | Mississippi | 28151 | 5391 | 135 |
1369938 | 1369938 | 2021-05-30 | Wayne | Mississippi | 28153 | 2639 | 42 |
1369939 | 1369939 | 2021-05-30 | Webster | Mississippi | 28155 | 1149 | 32 |
1369940 | 1369940 | 2021-05-30 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1369941 | 1369941 | 2021-05-30 | Winston | Mississippi | 28159 | 2289 | 81 |
1369942 | 1369942 | 2021-05-30 | Yalobusha | Mississippi | 28161 | 1662 | 38 |
1369943 | 1369943 | 2021-05-30 | Yazoo | Mississippi | 28163 | 3125 | 70 |
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);