ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2021-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 |
---|---|---|---|---|---|---|---|
2013024 | 2013024 | 2021-12-14 | Adams | Mississippi | 28001 | 4810 | 125 |
2013025 | 2013025 | 2021-12-14 | Alcorn | Mississippi | 28003 | 6052 | 108 |
2013026 | 2013026 | 2021-12-14 | Amite | Mississippi | 28005 | 2118 | 57 |
2013027 | 2013027 | 2021-12-14 | Attala | Mississippi | 28007 | 3441 | 90 |
2013028 | 2013028 | 2021-12-14 | Benton | Mississippi | 28009 | 1545 | 40 |
2013029 | 2013029 | 2021-12-14 | Bolivar | Mississippi | 28011 | 6518 | 153 |
2013030 | 2013030 | 2021-12-14 | Calhoun | Mississippi | 28013 | 2920 | 51 |
2013031 | 2013031 | 2021-12-14 | Carroll | Mississippi | 28015 | 1774 | 41 |
2013032 | 2013032 | 2021-12-14 | Chickasaw | Mississippi | 28017 | 3275 | 68 |
2013033 | 2013033 | 2021-12-14 | Choctaw | Mississippi | 28019 | 1385 | 27 |
2013034 | 2013034 | 2021-12-14 | Claiborne | Mississippi | 28021 | 1352 | 39 |
2013035 | 2013035 | 2021-12-14 | Clarke | Mississippi | 28023 | 3026 | 95 |
2013036 | 2013036 | 2021-12-14 | Clay | Mississippi | 28025 | 3172 | 78 |
2013037 | 2013037 | 2021-12-14 | Coahoma | Mississippi | 28027 | 4320 | 112 |
2013038 | 2013038 | 2021-12-14 | Copiah | Mississippi | 28029 | 4632 | 95 |
2013039 | 2013039 | 2021-12-14 | Covington | Mississippi | 28031 | 4378 | 95 |
2013040 | 2013040 | 2021-12-14 | DeSoto | Mississippi | 28033 | 33780 | 435 |
2013041 | 2013041 | 2021-12-14 | Forrest | Mississippi | 28035 | 13924 | 261 |
2013042 | 2013042 | 2021-12-14 | Franklin | Mississippi | 28037 | 1278 | 31 |
2013043 | 2013043 | 2021-12-14 | George | Mississippi | 28039 | 5124 | 80 |
2013044 | 2013044 | 2021-12-14 | Greene | Mississippi | 28041 | 2258 | 50 |
2013045 | 2013045 | 2021-12-14 | Grenada | Mississippi | 28043 | 3834 | 109 |
2013046 | 2013046 | 2021-12-14 | Hancock | Mississippi | 28045 | 7870 | 132 |
2013047 | 2013047 | 2021-12-14 | Harrison | Mississippi | 28047 | 35187 | 561 |
2013048 | 2013048 | 2021-12-14 | Hinds | Mississippi | 28049 | 33007 | 648 |
2013049 | 2013049 | 2021-12-14 | Holmes | Mississippi | 28051 | 2746 | 89 |
2013050 | 2013050 | 2021-12-14 | Humphreys | Mississippi | 28053 | 1331 | 39 |
2013051 | 2013051 | 2021-12-14 | Issaquena | Mississippi | 28055 | 195 | 7 |
2013052 | 2013052 | 2021-12-14 | Itawamba | Mississippi | 28057 | 4978 | 107 |
2013053 | 2013053 | 2021-12-14 | Jackson | Mississippi | 28059 | 25017 | 392 |
2013054 | 2013054 | 2021-12-14 | Jasper | Mississippi | 28061 | 3422 | 66 |
2013055 | 2013055 | 2021-12-14 | Jefferson | Mississippi | 28063 | 975 | 34 |
2013056 | 2013056 | 2021-12-14 | Jefferson Davis | Mississippi | 28065 | 1757 | 43 |
2013057 | 2013057 | 2021-12-14 | Jones | Mississippi | 28067 | 14245 | 248 |
2013058 | 2013058 | 2021-12-14 | Kemper | Mississippi | 28069 | 1460 | 41 |
2013059 | 2013059 | 2021-12-14 | Lafayette | Mississippi | 28071 | 8952 | 143 |
2013060 | 2013060 | 2021-12-14 | Lamar | Mississippi | 28073 | 10754 | 140 |
2013061 | 2013061 | 2021-12-14 | Lauderdale | Mississippi | 28075 | 12408 | 323 |
2013062 | 2013062 | 2021-12-14 | Lawrence | Mississippi | 28077 | 2222 | 43 |
2013063 | 2013063 | 2021-12-14 | Leake | Mississippi | 28079 | 4157 | 92 |
2013064 | 2013064 | 2021-12-14 | Lee | Mississippi | 28081 | 16778 | 246 |
2013065 | 2013065 | 2021-12-14 | Leflore | Mississippi | 28083 | 4796 | 144 |
2013066 | 2013066 | 2021-12-14 | Lincoln | Mississippi | 28085 | 5588 | 136 |
2013067 | 2013067 | 2021-12-14 | Lowndes | Mississippi | 28087 | 11468 | 196 |
2013068 | 2013068 | 2021-12-14 | Madison | Mississippi | 28089 | 15077 | 283 |
2013069 | 2013069 | 2021-12-14 | Marion | Mississippi | 28091 | 4339 | 112 |
2013070 | 2013070 | 2021-12-14 | Marshall | Mississippi | 28093 | 6815 | 142 |
2013071 | 2013071 | 2021-12-14 | Monroe | Mississippi | 28095 | 7189 | 180 |
2013072 | 2013072 | 2021-12-14 | Montgomery | Mississippi | 28097 | 1836 | 57 |
2013073 | 2013073 | 2021-12-14 | Neshoba | Mississippi | 28099 | 6776 | 210 |
2013074 | 2013074 | 2021-12-14 | Newton | Mississippi | 28101 | 3980 | 83 |
2013075 | 2013075 | 2021-12-14 | Noxubee | Mississippi | 28103 | 1895 | 44 |
2013076 | 2013076 | 2021-12-14 | Oktibbeha | Mississippi | 28105 | 7276 | 139 |
2013077 | 2013077 | 2021-12-14 | Panola | Mississippi | 28107 | 6862 | 137 |
2013078 | 2013078 | 2021-12-14 | Pearl River | Mississippi | 28109 | 9796 | 244 |
2013079 | 2013079 | 2021-12-14 | Perry | Mississippi | 28111 | 2155 | 56 |
2013080 | 2013080 | 2021-12-14 | Pike | Mississippi | 28113 | 5986 | 157 |
2013081 | 2013081 | 2021-12-14 | Pontotoc | Mississippi | 28115 | 7147 | 110 |
2013082 | 2013082 | 2021-12-14 | Prentiss | Mississippi | 28117 | 5185 | 86 |
2013083 | 2013083 | 2021-12-14 | Quitman | Mississippi | 28119 | 1085 | 28 |
2013084 | 2013084 | 2021-12-14 | Rankin | Mississippi | 28121 | 22740 | 407 |
2013085 | 2013085 | 2021-12-14 | Scott | Mississippi | 28123 | 4813 | 99 |
2013086 | 2013086 | 2021-12-14 | Sharkey | Mississippi | 28125 | 656 | 21 |
2013087 | 2013087 | 2021-12-14 | Simpson | Mississippi | 28127 | 4614 | 117 |
2013088 | 2013088 | 2021-12-14 | Smith | Mississippi | 28129 | 2724 | 52 |
2013089 | 2013089 | 2021-12-14 | Stone | Mississippi | 28131 | 3671 | 66 |
2013090 | 2013090 | 2021-12-14 | Sunflower | Mississippi | 28133 | 4358 | 106 |
2013091 | 2013091 | 2021-12-14 | Tallahatchie | Mississippi | 28135 | 2338 | 53 |
2013092 | 2013092 | 2021-12-14 | Tate | Mississippi | 28137 | 4816 | 118 |
2013093 | 2013093 | 2021-12-14 | Tippah | Mississippi | 28139 | 5036 | 84 |
2013094 | 2013094 | 2021-12-14 | Tishomingo | Mississippi | 28141 | 3960 | 94 |
2013095 | 2013095 | 2021-12-14 | Tunica | Mississippi | 28143 | 1654 | 39 |
2013096 | 2013096 | 2021-12-14 | Union | Mississippi | 28145 | 6557 | 99 |
2013097 | 2013097 | 2021-12-14 | Walthall | Mississippi | 28147 | 2224 | 66 |
2013098 | 2013098 | 2021-12-14 | Warren | Mississippi | 28149 | 6951 | 179 |
2013099 | 2013099 | 2021-12-14 | Washington | Mississippi | 28151 | 7583 | 170 |
2013100 | 2013100 | 2021-12-14 | Wayne | Mississippi | 28153 | 4450 | 72 |
2013101 | 2013101 | 2021-12-14 | Webster | Mississippi | 28155 | 2085 | 49 |
2013102 | 2013102 | 2021-12-14 | Wilkinson | Mississippi | 28157 | 1072 | 39 |
2013103 | 2013103 | 2021-12-14 | Winston | Mississippi | 28159 | 3207 | 92 |
2013104 | 2013104 | 2021-12-14 | Yalobusha | Mississippi | 28161 | 2492 | 47 |
2013105 | 2013105 | 2021-12-14 | Yazoo | Mississippi | 28163 | 4630 | 93 |
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);