ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-07-25" 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 |
---|---|---|---|---|---|---|---|
368058 | 368058 | 2020-07-25 | Adams | Mississippi | 28001 | 490 | 22 |
368059 | 368059 | 2020-07-25 | Alcorn | Mississippi | 28003 | 267 | 3 |
368060 | 368060 | 2020-07-25 | Amite | Mississippi | 28005 | 172 | 4 |
368061 | 368061 | 2020-07-25 | Attala | Mississippi | 28007 | 456 | 23 |
368062 | 368062 | 2020-07-25 | Benton | Mississippi | 28009 | 88 | 0 |
368063 | 368063 | 2020-07-25 | Bolivar | Mississippi | 28011 | 741 | 25 |
368064 | 368064 | 2020-07-25 | Calhoun | Mississippi | 28013 | 335 | 8 |
368065 | 368065 | 2020-07-25 | Carroll | Mississippi | 28015 | 231 | 11 |
368066 | 368066 | 2020-07-25 | Chickasaw | Mississippi | 28017 | 385 | 19 |
368067 | 368067 | 2020-07-25 | Choctaw | Mississippi | 28019 | 105 | 4 |
368068 | 368068 | 2020-07-25 | Claiborne | Mississippi | 28021 | 373 | 12 |
368069 | 368069 | 2020-07-25 | Clarke | Mississippi | 28023 | 275 | 25 |
368070 | 368070 | 2020-07-25 | Clay | Mississippi | 28025 | 335 | 13 |
368071 | 368071 | 2020-07-25 | Coahoma | Mississippi | 28027 | 508 | 7 |
368072 | 368072 | 2020-07-25 | Copiah | Mississippi | 28029 | 810 | 21 |
368073 | 368073 | 2020-07-25 | Covington | Mississippi | 28031 | 523 | 8 |
368074 | 368074 | 2020-07-25 | DeSoto | Mississippi | 28033 | 2784 | 23 |
368075 | 368075 | 2020-07-25 | Forrest | Mississippi | 28035 | 1373 | 46 |
368076 | 368076 | 2020-07-25 | Franklin | Mississippi | 28037 | 83 | 2 |
368077 | 368077 | 2020-07-25 | George | Mississippi | 28039 | 233 | 5 |
368078 | 368078 | 2020-07-25 | Greene | Mississippi | 28041 | 187 | 10 |
368079 | 368079 | 2020-07-25 | Grenada | Mississippi | 28043 | 760 | 16 |
368080 | 368080 | 2020-07-25 | Hancock | Mississippi | 28045 | 247 | 14 |
368081 | 368081 | 2020-07-25 | Harrison | Mississippi | 28047 | 1774 | 25 |
368082 | 368082 | 2020-07-25 | Hinds | Mississippi | 28049 | 4413 | 82 |
368083 | 368083 | 2020-07-25 | Holmes | Mississippi | 28051 | 737 | 44 |
368084 | 368084 | 2020-07-25 | Humphreys | Mississippi | 28053 | 241 | 10 |
368085 | 368085 | 2020-07-25 | Issaquena | Mississippi | 28055 | 18 | 1 |
368086 | 368086 | 2020-07-25 | Itawamba | Mississippi | 28057 | 243 | 9 |
368087 | 368087 | 2020-07-25 | Jackson | Mississippi | 28059 | 1552 | 26 |
368088 | 368088 | 2020-07-25 | Jasper | Mississippi | 28061 | 329 | 6 |
368089 | 368089 | 2020-07-25 | Jefferson | Mississippi | 28063 | 158 | 4 |
368090 | 368090 | 2020-07-25 | Jefferson Davis | Mississippi | 28065 | 170 | 5 |
368091 | 368091 | 2020-07-25 | Jones | Mississippi | 28067 | 1522 | 54 |
368092 | 368092 | 2020-07-25 | Kemper | Mississippi | 28069 | 207 | 15 |
368093 | 368093 | 2020-07-25 | Lafayette | Mississippi | 28071 | 700 | 4 |
368094 | 368094 | 2020-07-25 | Lamar | Mississippi | 28073 | 923 | 10 |
368095 | 368095 | 2020-07-25 | Lauderdale | Mississippi | 28075 | 1199 | 84 |
368096 | 368096 | 2020-07-25 | Lawrence | Mississippi | 28077 | 269 | 3 |
368097 | 368097 | 2020-07-25 | Leake | Mississippi | 28079 | 723 | 24 |
368098 | 368098 | 2020-07-25 | Lee | Mississippi | 28081 | 968 | 26 |
368099 | 368099 | 2020-07-25 | Leflore | Mississippi | 28083 | 719 | 57 |
368100 | 368100 | 2020-07-25 | Lincoln | Mississippi | 28085 | 661 | 38 |
368101 | 368101 | 2020-07-25 | Lowndes | Mississippi | 28087 | 794 | 22 |
368102 | 368102 | 2020-07-25 | Madison | Mississippi | 28089 | 2026 | 50 |
368103 | 368103 | 2020-07-25 | Marion | Mississippi | 28091 | 487 | 15 |
368104 | 368104 | 2020-07-25 | Marshall | Mississippi | 28093 | 443 | 5 |
368105 | 368105 | 2020-07-25 | Monroe | Mississippi | 28095 | 572 | 44 |
368106 | 368106 | 2020-07-25 | Montgomery | Mississippi | 28097 | 249 | 3 |
368107 | 368107 | 2020-07-25 | Neshoba | Mississippi | 28099 | 1143 | 82 |
368108 | 368108 | 2020-07-25 | Newton | Mississippi | 28101 | 467 | 10 |
368109 | 368109 | 2020-07-25 | Noxubee | Mississippi | 28103 | 361 | 10 |
368110 | 368110 | 2020-07-25 | Oktibbeha | Mississippi | 28105 | 800 | 31 |
368111 | 368111 | 2020-07-25 | Panola | Mississippi | 28107 | 711 | 9 |
368112 | 368112 | 2020-07-25 | Pearl River | Mississippi | 28109 | 419 | 34 |
368113 | 368113 | 2020-07-25 | Perry | Mississippi | 28111 | 164 | 6 |
368114 | 368114 | 2020-07-25 | Pike | Mississippi | 28113 | 703 | 28 |
368115 | 368115 | 2020-07-25 | Pontotoc | Mississippi | 28115 | 595 | 6 |
368116 | 368116 | 2020-07-25 | Prentiss | Mississippi | 28117 | 245 | 6 |
368117 | 368117 | 2020-07-25 | Quitman | Mississippi | 28119 | 159 | 1 |
368118 | 368118 | 2020-07-25 | Rankin | Mississippi | 28121 | 1763 | 23 |
368119 | 368119 | 2020-07-25 | Scott | Mississippi | 28123 | 926 | 16 |
368120 | 368120 | 2020-07-25 | Sharkey | Mississippi | 28125 | 102 | 0 |
368121 | 368121 | 2020-07-25 | Simpson | Mississippi | 28127 | 613 | 12 |
368122 | 368122 | 2020-07-25 | Smith | Mississippi | 28129 | 347 | 12 |
368123 | 368123 | 2020-07-25 | Stone | Mississippi | 28131 | 121 | 2 |
368124 | 368124 | 2020-07-25 | Sunflower | Mississippi | 28133 | 771 | 14 |
368125 | 368125 | 2020-07-25 | Tallahatchie | Mississippi | 28135 | 344 | 5 |
368126 | 368126 | 2020-07-25 | Tate | Mississippi | 28137 | 550 | 19 |
368127 | 368127 | 2020-07-25 | Tippah | Mississippi | 28139 | 232 | 11 |
368128 | 368128 | 2020-07-25 | Tishomingo | Mississippi | 28141 | 219 | 3 |
368129 | 368129 | 2020-07-25 | Tunica | Mississippi | 28143 | 180 | 4 |
368130 | 368130 | 2020-07-25 | Union | Mississippi | 28145 | 402 | 12 |
368131 | 368131 | 2020-07-25 | Walthall | Mississippi | 28147 | 386 | 15 |
368132 | 368132 | 2020-07-25 | Warren | Mississippi | 28149 | 842 | 23 |
368133 | 368133 | 2020-07-25 | Washington | Mississippi | 28151 | 1261 | 23 |
368134 | 368134 | 2020-07-25 | Wayne | Mississippi | 28153 | 669 | 21 |
368135 | 368135 | 2020-07-25 | Webster | Mississippi | 28155 | 161 | 11 |
368136 | 368136 | 2020-07-25 | Wilkinson | Mississippi | 28157 | 145 | 12 |
368137 | 368137 | 2020-07-25 | Winston | Mississippi | 28159 | 475 | 14 |
368138 | 368138 | 2020-07-25 | Yalobusha | Mississippi | 28161 | 275 | 9 |
368139 | 368139 | 2020-07-25 | Yazoo | Mississippi | 28163 | 688 | 9 |
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);