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 2022-02-19 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2230901 | 2230901 | 2022-02-19 | Adams | Mississippi | 28001 | 7070 | 140 |
2230902 | 2230902 | 2022-02-19 | Alcorn | Mississippi | 28003 | 9816 | 144 |
2230903 | 2230903 | 2022-02-19 | Amite | Mississippi | 28005 | 3202 | 65 |
2230904 | 2230904 | 2022-02-19 | Attala | Mississippi | 28007 | 5181 | 107 |
2230905 | 2230905 | 2022-02-19 | Benton | Mississippi | 28009 | 2248 | 49 |
2230906 | 2230906 | 2022-02-19 | Bolivar | Mississippi | 28011 | 9138 | 170 |
2230907 | 2230907 | 2022-02-19 | Calhoun | Mississippi | 28013 | 4566 | 62 |
2230908 | 2230908 | 2022-02-19 | Carroll | Mississippi | 28015 | 2537 | 50 |
2230909 | 2230909 | 2022-02-19 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2230910 | 2230910 | 2022-02-19 | Choctaw | Mississippi | 28019 | 2101 | 31 |
2230911 | 2230911 | 2022-02-19 | Claiborne | Mississippi | 28021 | 2129 | 46 |
2230912 | 2230912 | 2022-02-19 | Clarke | Mississippi | 28023 | 4181 | 103 |
2230913 | 2230913 | 2022-02-19 | Clay | Mississippi | 28025 | 4917 | 92 |
2230914 | 2230914 | 2022-02-19 | Coahoma | Mississippi | 28027 | 6404 | 119 |
2230915 | 2230915 | 2022-02-19 | Copiah | Mississippi | 28029 | 7057 | 109 |
2230916 | 2230916 | 2022-02-19 | Covington | Mississippi | 28031 | 7012 | 106 |
2230917 | 2230917 | 2022-02-19 | DeSoto | Mississippi | 28033 | 49549 | 528 |
2230918 | 2230918 | 2022-02-19 | Forrest | Mississippi | 28035 | 21776 | 298 |
2230919 | 2230919 | 2022-02-19 | Franklin | Mississippi | 28037 | 1912 | 36 |
2230920 | 2230920 | 2022-02-19 | George | Mississippi | 28039 | 7081 | 84 |
2230921 | 2230921 | 2022-02-19 | Greene | Mississippi | 28041 | 3160 | 55 |
2230922 | 2230922 | 2022-02-19 | Grenada | Mississippi | 28043 | 5463 | 126 |
2230923 | 2230923 | 2022-02-19 | Hancock | Mississippi | 28045 | 12070 | 146 |
2230924 | 2230924 | 2022-02-19 | Harrison | Mississippi | 28047 | 52833 | 637 |
2230925 | 2230925 | 2022-02-19 | Hinds | Mississippi | 28049 | 51700 | 744 |
2230926 | 2230926 | 2022-02-19 | Holmes | Mississippi | 28051 | 4397 | 104 |
2230927 | 2230927 | 2022-02-19 | Humphreys | Mississippi | 28053 | 2002 | 44 |
2230928 | 2230928 | 2022-02-19 | Issaquena | Mississippi | 28055 | 260 | 9 |
2230929 | 2230929 | 2022-02-19 | Itawamba | Mississippi | 28057 | 7310 | 138 |
2230930 | 2230930 | 2022-02-19 | Jackson | Mississippi | 28059 | 36545 | 435 |
2230931 | 2230931 | 2022-02-19 | Jasper | Mississippi | 28061 | 4750 | 70 |
2230932 | 2230932 | 2022-02-19 | Jefferson | Mississippi | 28063 | 1467 | 37 |
2230933 | 2230933 | 2022-02-19 | Jefferson Davis | Mississippi | 28065 | 2828 | 50 |
2230934 | 2230934 | 2022-02-19 | Jones | Mississippi | 28067 | 20993 | 282 |
2230935 | 2230935 | 2022-02-19 | Kemper | Mississippi | 28069 | 2147 | 46 |
2230936 | 2230936 | 2022-02-19 | Lafayette | Mississippi | 28071 | 14976 | 173 |
2230937 | 2230937 | 2022-02-19 | Lamar | Mississippi | 28073 | 17199 | 150 |
2230938 | 2230938 | 2022-02-19 | Lauderdale | Mississippi | 28075 | 18550 | 353 |
2230939 | 2230939 | 2022-02-19 | Lawrence | Mississippi | 28077 | 3547 | 52 |
2230940 | 2230940 | 2022-02-19 | Leake | Mississippi | 28079 | 6313 | 110 |
2230941 | 2230941 | 2022-02-19 | Lee | Mississippi | 28081 | 26296 | 286 |
2230942 | 2230942 | 2022-02-19 | Leflore | Mississippi | 28083 | 7278 | 164 |
2230943 | 2230943 | 2022-02-19 | Lincoln | Mississippi | 28085 | 8203 | 154 |
2230944 | 2230944 | 2022-02-19 | Lowndes | Mississippi | 28087 | 17379 | 224 |
2230945 | 2230945 | 2022-02-19 | Madison | Mississippi | 28089 | 23758 | 314 |
2230946 | 2230946 | 2022-02-19 | Marion | Mississippi | 28091 | 6910 | 132 |
2230947 | 2230947 | 2022-02-19 | Marshall | Mississippi | 28093 | 9822 | 168 |
2230948 | 2230948 | 2022-02-19 | Monroe | Mississippi | 28095 | 10863 | 207 |
2230949 | 2230949 | 2022-02-19 | Montgomery | Mississippi | 28097 | 2921 | 70 |
2230950 | 2230950 | 2022-02-19 | Neshoba | Mississippi | 28099 | 10363 | 228 |
2230951 | 2230951 | 2022-02-19 | Newton | Mississippi | 28101 | 5913 | 94 |
2230952 | 2230952 | 2022-02-19 | Noxubee | Mississippi | 28103 | 2706 | 48 |
2230953 | 2230953 | 2022-02-19 | Oktibbeha | Mississippi | 28105 | 10999 | 157 |
2230954 | 2230954 | 2022-02-19 | Panola | Mississippi | 28107 | 10313 | 159 |
2230955 | 2230955 | 2022-02-19 | Pearl River | Mississippi | 28109 | 14900 | 262 |
2230956 | 2230956 | 2022-02-19 | Perry | Mississippi | 28111 | 3017 | 63 |
2230957 | 2230957 | 2022-02-19 | Pike | Mississippi | 28113 | 9388 | 175 |
2230958 | 2230958 | 2022-02-19 | Pontotoc | Mississippi | 28115 | 10147 | 131 |
2230959 | 2230959 | 2022-02-19 | Prentiss | Mississippi | 28117 | 8086 | 98 |
2230960 | 2230960 | 2022-02-19 | Quitman | Mississippi | 28119 | 1556 | 31 |
2230961 | 2230961 | 2022-02-19 | Rankin | Mississippi | 28121 | 36141 | 465 |
2230962 | 2230962 | 2022-02-19 | Scott | Mississippi | 28123 | 6459 | 111 |
2230963 | 2230963 | 2022-02-19 | Sharkey | Mississippi | 28125 | 946 | 23 |
2230964 | 2230964 | 2022-02-19 | Simpson | Mississippi | 28127 | 6884 | 139 |
2230965 | 2230965 | 2022-02-19 | Smith | Mississippi | 28129 | 4053 | 66 |
2230966 | 2230966 | 2022-02-19 | Stone | Mississippi | 28131 | 5342 | 70 |
2230967 | 2230967 | 2022-02-19 | Sunflower | Mississippi | 28133 | 5711 | 116 |
2230968 | 2230968 | 2022-02-19 | Tallahatchie | Mississippi | 28135 | 3163 | 60 |
2230969 | 2230969 | 2022-02-19 | Tate | Mississippi | 28137 | 7222 | 138 |
2230970 | 2230970 | 2022-02-19 | Tippah | Mississippi | 28139 | 7161 | 104 |
2230971 | 2230971 | 2022-02-19 | Tishomingo | Mississippi | 28141 | 6050 | 119 |
2230972 | 2230972 | 2022-02-19 | Tunica | Mississippi | 28143 | 2499 | 44 |
2230973 | 2230973 | 2022-02-19 | Union | Mississippi | 28145 | 9377 | 115 |
2230974 | 2230974 | 2022-02-19 | Walthall | Mississippi | 28147 | 3560 | 78 |
2230975 | 2230975 | 2022-02-19 | Warren | Mississippi | 28149 | 10144 | 196 |
2230976 | 2230976 | 2022-02-19 | Washington | Mississippi | 28151 | 10083 | 188 |
2230977 | 2230977 | 2022-02-19 | Wayne | Mississippi | 28153 | 5902 | 84 |
2230978 | 2230978 | 2022-02-19 | Webster | Mississippi | 28155 | 3193 | 65 |
2230979 | 2230979 | 2022-02-19 | Wilkinson | Mississippi | 28157 | 1788 | 44 |
2230980 | 2230980 | 2022-02-19 | Winston | Mississippi | 28159 | 5143 | 100 |
2230981 | 2230981 | 2022-02-19 | Yalobusha | Mississippi | 28161 | 4032 | 52 |
2230982 | 2230982 | 2022-02-19 | Yazoo | Mississippi | 28163 | 7973 | 102 |
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);