ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where "date" is on date 2020-05-07 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
122617 | 122617 | 2020-05-07 | Adams | Mississippi | 28001 | 157 | 11 |
122618 | 122618 | 2020-05-07 | Alcorn | Mississippi | 28003 | 10 | 1 |
122619 | 122619 | 2020-05-07 | Amite | Mississippi | 28005 | 33 | 0 |
122620 | 122620 | 2020-05-07 | Attala | Mississippi | 28007 | 170 | 3 |
122621 | 122621 | 2020-05-07 | Benton | Mississippi | 28009 | 13 | 0 |
122622 | 122622 | 2020-05-07 | Bolivar | Mississippi | 28011 | 115 | 8 |
122623 | 122623 | 2020-05-07 | Calhoun | Mississippi | 28013 | 57 | 4 |
122624 | 122624 | 2020-05-07 | Carroll | Mississippi | 28015 | 99 | 3 |
122625 | 122625 | 2020-05-07 | Chickasaw | Mississippi | 28017 | 84 | 9 |
122626 | 122626 | 2020-05-07 | Choctaw | Mississippi | 28019 | 14 | 2 |
122627 | 122627 | 2020-05-07 | Claiborne | Mississippi | 28021 | 33 | 0 |
122628 | 122628 | 2020-05-07 | Clarke | Mississippi | 28023 | 71 | 6 |
122629 | 122629 | 2020-05-07 | Clay | Mississippi | 28025 | 63 | 3 |
122630 | 122630 | 2020-05-07 | Coahoma | Mississippi | 28027 | 70 | 3 |
122631 | 122631 | 2020-05-07 | Copiah | Mississippi | 28029 | 141 | 1 |
122632 | 122632 | 2020-05-07 | Covington | Mississippi | 28031 | 84 | 0 |
122633 | 122633 | 2020-05-07 | DeSoto | Mississippi | 28033 | 320 | 5 |
122634 | 122634 | 2020-05-07 | Forrest | Mississippi | 28035 | 283 | 18 |
122635 | 122635 | 2020-05-07 | Franklin | Mississippi | 28037 | 18 | 1 |
122636 | 122636 | 2020-05-07 | George | Mississippi | 28039 | 15 | 1 |
122637 | 122637 | 2020-05-07 | Greene | Mississippi | 28041 | 6 | 1 |
122638 | 122638 | 2020-05-07 | Grenada | Mississippi | 28043 | 45 | 2 |
122639 | 122639 | 2020-05-07 | Hancock | Mississippi | 28045 | 72 | 9 |
122640 | 122640 | 2020-05-07 | Harrison | Mississippi | 28047 | 188 | 6 |
122641 | 122641 | 2020-05-07 | Hinds | Mississippi | 28049 | 600 | 11 |
122642 | 122642 | 2020-05-07 | Holmes | Mississippi | 28051 | 190 | 16 |
122643 | 122643 | 2020-05-07 | Humphreys | Mississippi | 28053 | 28 | 4 |
122644 | 122644 | 2020-05-07 | Itawamba | Mississippi | 28057 | 66 | 6 |
122645 | 122645 | 2020-05-07 | Jackson | Mississippi | 28059 | 272 | 11 |
122646 | 122646 | 2020-05-07 | Jasper | Mississippi | 28061 | 76 | 2 |
122647 | 122647 | 2020-05-07 | Jefferson | Mississippi | 28063 | 30 | 0 |
122648 | 122648 | 2020-05-07 | Jefferson Davis | Mississippi | 28065 | 47 | 1 |
122649 | 122649 | 2020-05-07 | Jones | Mississippi | 28067 | 209 | 4 |
122650 | 122650 | 2020-05-07 | Kemper | Mississippi | 28069 | 84 | 6 |
122651 | 122651 | 2020-05-07 | Lafayette | Mississippi | 28071 | 96 | 3 |
122652 | 122652 | 2020-05-07 | Lamar | Mississippi | 28073 | 136 | 4 |
122653 | 122653 | 2020-05-07 | Lauderdale | Mississippi | 28075 | 450 | 40 |
122654 | 122654 | 2020-05-07 | Lawrence | Mississippi | 28077 | 61 | 0 |
122655 | 122655 | 2020-05-07 | Leake | Mississippi | 28079 | 267 | 2 |
122656 | 122656 | 2020-05-07 | Lee | Mississippi | 28081 | 73 | 4 |
122657 | 122657 | 2020-05-07 | Leflore | Mississippi | 28083 | 180 | 18 |
122658 | 122658 | 2020-05-07 | Lincoln | Mississippi | 28085 | 179 | 12 |
122659 | 122659 | 2020-05-07 | Lowndes | Mississippi | 28087 | 71 | 3 |
122660 | 122660 | 2020-05-07 | Madison | Mississippi | 28089 | 333 | 12 |
122661 | 122661 | 2020-05-07 | Marion | Mississippi | 28091 | 80 | 7 |
122662 | 122662 | 2020-05-07 | Marshall | Mississippi | 28093 | 50 | 2 |
122663 | 122663 | 2020-05-07 | Monroe | Mississippi | 28095 | 188 | 20 |
122664 | 122664 | 2020-05-07 | Montgomery | Mississippi | 28097 | 56 | 1 |
122665 | 122665 | 2020-05-07 | Neshoba | Mississippi | 28099 | 261 | 11 |
122666 | 122666 | 2020-05-07 | Newton | Mississippi | 28101 | 121 | 0 |
122667 | 122667 | 2020-05-07 | Noxubee | Mississippi | 28103 | 97 | 2 |
122668 | 122668 | 2020-05-07 | Oktibbeha | Mississippi | 28105 | 62 | 4 |
122669 | 122669 | 2020-05-07 | Panola | Mississippi | 28107 | 43 | 2 |
122670 | 122670 | 2020-05-07 | Pearl River | Mississippi | 28109 | 188 | 24 |
122671 | 122671 | 2020-05-07 | Perry | Mississippi | 28111 | 33 | 1 |
122672 | 122672 | 2020-05-07 | Pike | Mississippi | 28113 | 162 | 9 |
122673 | 122673 | 2020-05-07 | Pontotoc | Mississippi | 28115 | 22 | 2 |
122674 | 122674 | 2020-05-07 | Prentiss | Mississippi | 28117 | 33 | 2 |
122675 | 122675 | 2020-05-07 | Quitman | Mississippi | 28119 | 16 | 0 |
122676 | 122676 | 2020-05-07 | Rankin | Mississippi | 28121 | 231 | 6 |
122677 | 122677 | 2020-05-07 | Scott | Mississippi | 28123 | 423 | 5 |
122678 | 122678 | 2020-05-07 | Sharkey | Mississippi | 28125 | 5 | 0 |
122679 | 122679 | 2020-05-07 | Simpson | Mississippi | 28127 | 56 | 0 |
122680 | 122680 | 2020-05-07 | Smith | Mississippi | 28129 | 95 | 6 |
122681 | 122681 | 2020-05-07 | Stone | Mississippi | 28131 | 23 | 0 |
122682 | 122682 | 2020-05-07 | Sunflower | Mississippi | 28133 | 61 | 3 |
122683 | 122683 | 2020-05-07 | Tallahatchie | Mississippi | 28135 | 12 | 1 |
122684 | 122684 | 2020-05-07 | Tate | Mississippi | 28137 | 48 | 0 |
122685 | 122685 | 2020-05-07 | Tippah | Mississippi | 28139 | 61 | 10 |
122686 | 122686 | 2020-05-07 | Tishomingo | Mississippi | 28141 | 8 | 0 |
122687 | 122687 | 2020-05-07 | Tunica | Mississippi | 28143 | 39 | 2 |
122688 | 122688 | 2020-05-07 | Union | Mississippi | 28145 | 41 | 3 |
122689 | 122689 | 2020-05-07 | Walthall | Mississippi | 28147 | 36 | 0 |
122690 | 122690 | 2020-05-07 | Warren | Mississippi | 28149 | 90 | 2 |
122691 | 122691 | 2020-05-07 | Washington | Mississippi | 28151 | 78 | 3 |
122692 | 122692 | 2020-05-07 | Wayne | Mississippi | 28153 | 27 | 0 |
122693 | 122693 | 2020-05-07 | Webster | Mississippi | 28155 | 21 | 1 |
122694 | 122694 | 2020-05-07 | Wilkinson | Mississippi | 28157 | 74 | 9 |
122695 | 122695 | 2020-05-07 | Winston | Mississippi | 28159 | 57 | 0 |
122696 | 122696 | 2020-05-07 | Yalobusha | Mississippi | 28161 | 25 | 0 |
122697 | 122697 | 2020-05-07 | Yazoo | Mississippi | 28163 | 154 | 2 |
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);