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-04-23 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
82540 | 82540 | 2020-04-23 | Adams | Mississippi | 28001 | 101 | 7 |
82541 | 82541 | 2020-04-23 | Alcorn | Mississippi | 28003 | 8 | 0 |
82542 | 82542 | 2020-04-23 | Amite | Mississippi | 28005 | 24 | 1 |
82543 | 82543 | 2020-04-23 | Attala | Mississippi | 28007 | 62 | 0 |
82544 | 82544 | 2020-04-23 | Benton | Mississippi | 28009 | 9 | 0 |
82545 | 82545 | 2020-04-23 | Bolivar | Mississippi | 28011 | 89 | 7 |
82546 | 82546 | 2020-04-23 | Calhoun | Mississippi | 28013 | 43 | 2 |
82547 | 82547 | 2020-04-23 | Carroll | Mississippi | 28015 | 15 | 1 |
82548 | 82548 | 2020-04-23 | Chickasaw | Mississippi | 28017 | 52 | 4 |
82549 | 82549 | 2020-04-23 | Choctaw | Mississippi | 28019 | 13 | 1 |
82550 | 82550 | 2020-04-23 | Claiborne | Mississippi | 28021 | 12 | 0 |
82551 | 82551 | 2020-04-23 | Clarke | Mississippi | 28023 | 37 | 3 |
82552 | 82552 | 2020-04-23 | Clay | Mississippi | 28025 | 28 | 2 |
82553 | 82553 | 2020-04-23 | Coahoma | Mississippi | 28027 | 53 | 2 |
82554 | 82554 | 2020-04-23 | Copiah | Mississippi | 28029 | 59 | 1 |
82555 | 82555 | 2020-04-23 | Covington | Mississippi | 28031 | 40 | 0 |
82556 | 82556 | 2020-04-23 | DeSoto | Mississippi | 28033 | 252 | 4 |
82557 | 82557 | 2020-04-23 | Forrest | Mississippi | 28035 | 164 | 6 |
82558 | 82558 | 2020-04-23 | Franklin | Mississippi | 28037 | 17 | 0 |
82559 | 82559 | 2020-04-23 | George | Mississippi | 28039 | 10 | 1 |
82560 | 82560 | 2020-04-23 | Greene | Mississippi | 28041 | 4 | 0 |
82561 | 82561 | 2020-04-23 | Grenada | Mississippi | 28043 | 27 | 0 |
82562 | 82562 | 2020-04-23 | Hancock | Mississippi | 28045 | 55 | 5 |
82563 | 82563 | 2020-04-23 | Harrison | Mississippi | 28047 | 152 | 6 |
82564 | 82564 | 2020-04-23 | Hinds | Mississippi | 28049 | 383 | 6 |
82565 | 82565 | 2020-04-23 | Holmes | Mississippi | 28051 | 83 | 5 |
82566 | 82566 | 2020-04-23 | Humphreys | Mississippi | 28053 | 14 | 3 |
82567 | 82567 | 2020-04-23 | Itawamba | Mississippi | 28057 | 30 | 1 |
82568 | 82568 | 2020-04-23 | Jackson | Mississippi | 28059 | 228 | 6 |
82569 | 82569 | 2020-04-23 | Jasper | Mississippi | 28061 | 27 | 1 |
82570 | 82570 | 2020-04-23 | Jefferson | Mississippi | 28063 | 5 | 0 |
82571 | 82571 | 2020-04-23 | Jefferson Davis | Mississippi | 28065 | 13 | 1 |
82572 | 82572 | 2020-04-23 | Jones | Mississippi | 28067 | 94 | 0 |
82573 | 82573 | 2020-04-23 | Kemper | Mississippi | 28069 | 27 | 0 |
82574 | 82574 | 2020-04-23 | Lafayette | Mississippi | 28071 | 81 | 3 |
82575 | 82575 | 2020-04-23 | Lamar | Mississippi | 28073 | 79 | 2 |
82576 | 82576 | 2020-04-23 | Lauderdale | Mississippi | 28075 | 249 | 18 |
82577 | 82577 | 2020-04-23 | Lawrence | Mississippi | 28077 | 25 | 0 |
82578 | 82578 | 2020-04-23 | Leake | Mississippi | 28079 | 118 | 1 |
82579 | 82579 | 2020-04-23 | Lee | Mississippi | 28081 | 66 | 4 |
82580 | 82580 | 2020-04-23 | Leflore | Mississippi | 28083 | 119 | 13 |
82581 | 82581 | 2020-04-23 | Lincoln | Mississippi | 28085 | 125 | 7 |
82582 | 82582 | 2020-04-23 | Lowndes | Mississippi | 28087 | 36 | 1 |
82583 | 82583 | 2020-04-23 | Madison | Mississippi | 28089 | 165 | 4 |
82584 | 82584 | 2020-04-23 | Marion | Mississippi | 28091 | 53 | 4 |
82585 | 82585 | 2020-04-23 | Marshall | Mississippi | 28093 | 40 | 2 |
82586 | 82586 | 2020-04-23 | Monroe | Mississippi | 28095 | 109 | 9 |
82587 | 82587 | 2020-04-23 | Montgomery | Mississippi | 28097 | 16 | 1 |
82588 | 82588 | 2020-04-23 | Neshoba | Mississippi | 28099 | 102 | 2 |
82589 | 82589 | 2020-04-23 | Newton | Mississippi | 28101 | 45 | 0 |
82590 | 82590 | 2020-04-23 | Noxubee | Mississippi | 28103 | 29 | 0 |
82591 | 82591 | 2020-04-23 | Oktibbeha | Mississippi | 28105 | 45 | 3 |
82592 | 82592 | 2020-04-23 | Panola | Mississippi | 28107 | 38 | 2 |
82593 | 82593 | 2020-04-23 | Pearl River | Mississippi | 28109 | 142 | 11 |
82594 | 82594 | 2020-04-23 | Perry | Mississippi | 28111 | 23 | 1 |
82595 | 82595 | 2020-04-23 | Pike | Mississippi | 28113 | 126 | 3 |
82596 | 82596 | 2020-04-23 | Pontotoc | Mississippi | 28115 | 18 | 2 |
82597 | 82597 | 2020-04-23 | Prentiss | Mississippi | 28117 | 29 | 0 |
82598 | 82598 | 2020-04-23 | Quitman | Mississippi | 28119 | 14 | 0 |
82599 | 82599 | 2020-04-23 | Rankin | Mississippi | 28121 | 153 | 4 |
82600 | 82600 | 2020-04-23 | Scott | Mississippi | 28123 | 177 | 0 |
82601 | 82601 | 2020-04-23 | Sharkey | Mississippi | 28125 | 4 | 0 |
82602 | 82602 | 2020-04-23 | Simpson | Mississippi | 28127 | 33 | 0 |
82603 | 82603 | 2020-04-23 | Smith | Mississippi | 28129 | 53 | 3 |
82604 | 82604 | 2020-04-23 | Stone | Mississippi | 28131 | 22 | 0 |
82605 | 82605 | 2020-04-23 | Sunflower | Mississippi | 28133 | 51 | 2 |
82606 | 82606 | 2020-04-23 | Tallahatchie | Mississippi | 28135 | 9 | 1 |
82607 | 82607 | 2020-04-23 | Tate | Mississippi | 28137 | 35 | 0 |
82608 | 82608 | 2020-04-23 | Tippah | Mississippi | 28139 | 49 | 7 |
82609 | 82609 | 2020-04-23 | Tishomingo | Mississippi | 28141 | 5 | 0 |
82610 | 82610 | 2020-04-23 | Tunica | Mississippi | 28143 | 34 | 1 |
82611 | 82611 | 2020-04-23 | Union | Mississippi | 28145 | 14 | 1 |
82612 | 82612 | 2020-04-23 | Walthall | Mississippi | 28147 | 27 | 0 |
82613 | 82613 | 2020-04-23 | Warren | Mississippi | 28149 | 32 | 2 |
82614 | 82614 | 2020-04-23 | Washington | Mississippi | 28151 | 71 | 3 |
82615 | 82615 | 2020-04-23 | Wayne | Mississippi | 28153 | 17 | 0 |
82616 | 82616 | 2020-04-23 | Webster | Mississippi | 28155 | 16 | 1 |
82617 | 82617 | 2020-04-23 | Wilkinson | Mississippi | 28157 | 65 | 6 |
82618 | 82618 | 2020-04-23 | Winston | Mississippi | 28159 | 37 | 0 |
82619 | 82619 | 2020-04-23 | Yalobusha | Mississippi | 28161 | 17 | 0 |
82620 | 82620 | 2020-04-23 | Yazoo | Mississippi | 28163 | 110 | 1 |
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);