ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2021-06-16" 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 |
---|---|---|---|---|---|---|---|
1425036 | 1425036 | 2021-06-16 | Adams | Mississippi | 28001 | 3058 | 86 |
1425037 | 1425037 | 2021-06-16 | Alcorn | Mississippi | 28003 | 3242 | 72 |
1425038 | 1425038 | 2021-06-16 | Amite | Mississippi | 28005 | 1262 | 42 |
1425039 | 1425039 | 2021-06-16 | Attala | Mississippi | 28007 | 2150 | 73 |
1425040 | 1425040 | 2021-06-16 | Benton | Mississippi | 28009 | 1023 | 25 |
1425041 | 1425041 | 2021-06-16 | Bolivar | Mississippi | 28011 | 4836 | 133 |
1425042 | 1425042 | 2021-06-16 | Calhoun | Mississippi | 28013 | 1740 | 32 |
1425043 | 1425043 | 2021-06-16 | Carroll | Mississippi | 28015 | 1223 | 30 |
1425044 | 1425044 | 2021-06-16 | Chickasaw | Mississippi | 28017 | 2105 | 59 |
1425045 | 1425045 | 2021-06-16 | Choctaw | Mississippi | 28019 | 791 | 18 |
1425046 | 1425046 | 2021-06-16 | Claiborne | Mississippi | 28021 | 1031 | 30 |
1425047 | 1425047 | 2021-06-16 | Clarke | Mississippi | 28023 | 1789 | 80 |
1425048 | 1425048 | 2021-06-16 | Clay | Mississippi | 28025 | 1877 | 54 |
1425049 | 1425049 | 2021-06-16 | Coahoma | Mississippi | 28027 | 2984 | 84 |
1425050 | 1425050 | 2021-06-16 | Copiah | Mississippi | 28029 | 2996 | 66 |
1425051 | 1425051 | 2021-06-16 | Covington | Mississippi | 28031 | 2672 | 83 |
1425052 | 1425052 | 2021-06-16 | DeSoto | Mississippi | 28033 | 22267 | 267 |
1425053 | 1425053 | 2021-06-16 | Forrest | Mississippi | 28035 | 7824 | 153 |
1425054 | 1425054 | 2021-06-16 | Franklin | Mississippi | 28037 | 850 | 23 |
1425055 | 1425055 | 2021-06-16 | George | Mississippi | 28039 | 2520 | 51 |
1425056 | 1425056 | 2021-06-16 | Greene | Mississippi | 28041 | 1318 | 33 |
1425057 | 1425057 | 2021-06-16 | Grenada | Mississippi | 28043 | 2640 | 87 |
1425058 | 1425058 | 2021-06-16 | Hancock | Mississippi | 28045 | 3864 | 87 |
1425059 | 1425059 | 2021-06-16 | Harrison | Mississippi | 28047 | 18401 | 317 |
1425060 | 1425060 | 2021-06-16 | Hinds | Mississippi | 28049 | 20657 | 421 |
1425061 | 1425061 | 2021-06-16 | Holmes | Mississippi | 28051 | 1903 | 74 |
1425062 | 1425062 | 2021-06-16 | Humphreys | Mississippi | 28053 | 975 | 33 |
1425063 | 1425063 | 2021-06-16 | Issaquena | Mississippi | 28055 | 169 | 6 |
1425064 | 1425064 | 2021-06-16 | Itawamba | Mississippi | 28057 | 3050 | 78 |
1425065 | 1425065 | 2021-06-16 | Jackson | Mississippi | 28059 | 13681 | 248 |
1425066 | 1425066 | 2021-06-16 | Jasper | Mississippi | 28061 | 2221 | 48 |
1425067 | 1425067 | 2021-06-16 | Jefferson | Mississippi | 28063 | 662 | 28 |
1425068 | 1425068 | 2021-06-16 | Jefferson Davis | Mississippi | 28065 | 1080 | 33 |
1425069 | 1425069 | 2021-06-16 | Jones | Mississippi | 28067 | 8458 | 167 |
1425070 | 1425070 | 2021-06-16 | Kemper | Mississippi | 28069 | 966 | 29 |
1425071 | 1425071 | 2021-06-16 | Lafayette | Mississippi | 28071 | 6303 | 121 |
1425072 | 1425072 | 2021-06-16 | Lamar | Mississippi | 28073 | 6340 | 88 |
1425073 | 1425073 | 2021-06-16 | Lauderdale | Mississippi | 28075 | 7257 | 242 |
1425074 | 1425074 | 2021-06-16 | Lawrence | Mississippi | 28077 | 1310 | 24 |
1425075 | 1425075 | 2021-06-16 | Leake | Mississippi | 28079 | 2717 | 74 |
1425076 | 1425076 | 2021-06-16 | Lee | Mississippi | 28081 | 10052 | 176 |
1425077 | 1425077 | 2021-06-16 | Leflore | Mississippi | 28083 | 3515 | 125 |
1425078 | 1425078 | 2021-06-16 | Lincoln | Mississippi | 28085 | 4008 | 112 |
1425079 | 1425079 | 2021-06-16 | Lowndes | Mississippi | 28087 | 6501 | 150 |
1425080 | 1425080 | 2021-06-16 | Madison | Mississippi | 28089 | 10239 | 224 |
1425081 | 1425081 | 2021-06-16 | Marion | Mississippi | 28091 | 2712 | 80 |
1425082 | 1425082 | 2021-06-16 | Marshall | Mississippi | 28093 | 4572 | 105 |
1425083 | 1425083 | 2021-06-16 | Monroe | Mississippi | 28095 | 4155 | 135 |
1425084 | 1425084 | 2021-06-16 | Montgomery | Mississippi | 28097 | 1286 | 43 |
1425085 | 1425085 | 2021-06-16 | Neshoba | Mississippi | 28099 | 4059 | 179 |
1425086 | 1425086 | 2021-06-16 | Newton | Mississippi | 28101 | 2486 | 63 |
1425087 | 1425087 | 2021-06-16 | Noxubee | Mississippi | 28103 | 1280 | 34 |
1425088 | 1425088 | 2021-06-16 | Oktibbeha | Mississippi | 28105 | 4660 | 98 |
1425089 | 1425089 | 2021-06-16 | Panola | Mississippi | 28107 | 4665 | 110 |
1425090 | 1425090 | 2021-06-16 | Pearl River | Mississippi | 28109 | 4600 | 147 |
1425091 | 1425091 | 2021-06-16 | Perry | Mississippi | 28111 | 1267 | 38 |
1425092 | 1425092 | 2021-06-16 | Pike | Mississippi | 28113 | 3368 | 111 |
1425093 | 1425093 | 2021-06-16 | Pontotoc | Mississippi | 28115 | 4250 | 73 |
1425094 | 1425094 | 2021-06-16 | Prentiss | Mississippi | 28117 | 2836 | 61 |
1425095 | 1425095 | 2021-06-16 | Quitman | Mississippi | 28119 | 819 | 16 |
1425096 | 1425096 | 2021-06-16 | Rankin | Mississippi | 28121 | 13868 | 282 |
1425097 | 1425097 | 2021-06-16 | Scott | Mississippi | 28123 | 3197 | 74 |
1425098 | 1425098 | 2021-06-16 | Sharkey | Mississippi | 28125 | 509 | 17 |
1425099 | 1425099 | 2021-06-16 | Simpson | Mississippi | 28127 | 2981 | 89 |
1425100 | 1425100 | 2021-06-16 | Smith | Mississippi | 28129 | 1640 | 34 |
1425101 | 1425101 | 2021-06-16 | Stone | Mississippi | 28131 | 1874 | 33 |
1425102 | 1425102 | 2021-06-16 | Sunflower | Mississippi | 28133 | 3393 | 91 |
1425103 | 1425103 | 2021-06-16 | Tallahatchie | Mississippi | 28135 | 1800 | 41 |
1425104 | 1425104 | 2021-06-16 | Tate | Mississippi | 28137 | 3423 | 86 |
1425105 | 1425105 | 2021-06-16 | Tippah | Mississippi | 28139 | 2918 | 68 |
1425106 | 1425106 | 2021-06-16 | Tishomingo | Mississippi | 28141 | 2312 | 68 |
1425107 | 1425107 | 2021-06-16 | Tunica | Mississippi | 28143 | 1080 | 27 |
1425108 | 1425108 | 2021-06-16 | Union | Mississippi | 28145 | 4156 | 77 |
1425109 | 1425109 | 2021-06-16 | Walthall | Mississippi | 28147 | 1353 | 47 |
1425110 | 1425110 | 2021-06-16 | Warren | Mississippi | 28149 | 4440 | 121 |
1425111 | 1425111 | 2021-06-16 | Washington | Mississippi | 28151 | 5419 | 136 |
1425112 | 1425112 | 2021-06-16 | Wayne | Mississippi | 28153 | 2644 | 42 |
1425113 | 1425113 | 2021-06-16 | Webster | Mississippi | 28155 | 1150 | 32 |
1425114 | 1425114 | 2021-06-16 | Wilkinson | Mississippi | 28157 | 694 | 32 |
1425115 | 1425115 | 2021-06-16 | Winston | Mississippi | 28159 | 2299 | 81 |
1425116 | 1425116 | 2021-06-16 | Yalobusha | Mississippi | 28161 | 1678 | 40 |
1425117 | 1425117 | 2021-06-16 | Yazoo | Mississippi | 28163 | 3141 | 71 |
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);