ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2022-02-06" 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 |
---|---|---|---|---|---|---|---|
2188620 | 2188620 | 2022-02-06 | Adams | Mississippi | 28001 | 6637 | 133 |
2188621 | 2188621 | 2022-02-06 | Alcorn | Mississippi | 28003 | 9402 | 135 |
2188622 | 2188622 | 2022-02-06 | Amite | Mississippi | 28005 | 3039 | 61 |
2188623 | 2188623 | 2022-02-06 | Attala | Mississippi | 28007 | 4603 | 98 |
2188624 | 2188624 | 2022-02-06 | Benton | Mississippi | 28009 | 2180 | 46 |
2188625 | 2188625 | 2022-02-06 | Bolivar | Mississippi | 28011 | 8711 | 160 |
2188626 | 2188626 | 2022-02-06 | Calhoun | Mississippi | 28013 | 4417 | 56 |
2188627 | 2188627 | 2022-02-06 | Carroll | Mississippi | 28015 | 2452 | 47 |
2188628 | 2188628 | 2022-02-06 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2188629 | 2188629 | 2022-02-06 | Choctaw | Mississippi | 28019 | 1946 | 28 |
2188630 | 2188630 | 2022-02-06 | Claiborne | Mississippi | 28021 | 2080 | 45 |
2188631 | 2188631 | 2022-02-06 | Clarke | Mississippi | 28023 | 3993 | 98 |
2188632 | 2188632 | 2022-02-06 | Clay | Mississippi | 28025 | 4806 | 89 |
2188633 | 2188633 | 2022-02-06 | Coahoma | Mississippi | 28027 | 6150 | 119 |
2188634 | 2188634 | 2022-02-06 | Copiah | Mississippi | 28029 | 6618 | 101 |
2188635 | 2188635 | 2022-02-06 | Covington | Mississippi | 28031 | 6764 | 99 |
2188636 | 2188636 | 2022-02-06 | DeSoto | Mississippi | 28033 | 47659 | 494 |
2188637 | 2188637 | 2022-02-06 | Forrest | Mississippi | 28035 | 20602 | 282 |
2188638 | 2188638 | 2022-02-06 | Franklin | Mississippi | 28037 | 1823 | 35 |
2188639 | 2188639 | 2022-02-06 | George | Mississippi | 28039 | 6799 | 81 |
2188640 | 2188640 | 2022-02-06 | Greene | Mississippi | 28041 | 2977 | 51 |
2188641 | 2188641 | 2022-02-06 | Grenada | Mississippi | 28043 | 5265 | 122 |
2188642 | 2188642 | 2022-02-06 | Hancock | Mississippi | 28045 | 11339 | 145 |
2188643 | 2188643 | 2022-02-06 | Harrison | Mississippi | 28047 | 49407 | 601 |
2188644 | 2188644 | 2022-02-06 | Hinds | Mississippi | 28049 | 50531 | 713 |
2188645 | 2188645 | 2022-02-06 | Holmes | Mississippi | 28051 | 4242 | 98 |
2188646 | 2188646 | 2022-02-06 | Humphreys | Mississippi | 28053 | 1947 | 40 |
2188647 | 2188647 | 2022-02-06 | Issaquena | Mississippi | 28055 | 250 | 9 |
2188648 | 2188648 | 2022-02-06 | Itawamba | Mississippi | 28057 | 7028 | 126 |
2188649 | 2188649 | 2022-02-06 | Jackson | Mississippi | 28059 | 35160 | 409 |
2188650 | 2188650 | 2022-02-06 | Jasper | Mississippi | 28061 | 4575 | 67 |
2188651 | 2188651 | 2022-02-06 | Jefferson | Mississippi | 28063 | 1409 | 35 |
2188652 | 2188652 | 2022-02-06 | Jefferson Davis | Mississippi | 28065 | 2690 | 46 |
2188653 | 2188653 | 2022-02-06 | Jones | Mississippi | 28067 | 20278 | 266 |
2188654 | 2188654 | 2022-02-06 | Kemper | Mississippi | 28069 | 2085 | 44 |
2188655 | 2188655 | 2022-02-06 | Lafayette | Mississippi | 28071 | 14215 | 169 |
2188656 | 2188656 | 2022-02-06 | Lamar | Mississippi | 28073 | 16339 | 145 |
2188657 | 2188657 | 2022-02-06 | Lauderdale | Mississippi | 28075 | 17863 | 337 |
2188658 | 2188658 | 2022-02-06 | Lawrence | Mississippi | 28077 | 3360 | 46 |
2188659 | 2188659 | 2022-02-06 | Leake | Mississippi | 28079 | 5894 | 104 |
2188660 | 2188660 | 2022-02-06 | Lee | Mississippi | 28081 | 25447 | 271 |
2188661 | 2188661 | 2022-02-06 | Leflore | Mississippi | 28083 | 7115 | 156 |
2188662 | 2188662 | 2022-02-06 | Lincoln | Mississippi | 28085 | 7711 | 147 |
2188663 | 2188663 | 2022-02-06 | Lowndes | Mississippi | 28087 | 16628 | 216 |
2188664 | 2188664 | 2022-02-06 | Madison | Mississippi | 28089 | 22994 | 303 |
2188665 | 2188665 | 2022-02-06 | Marion | Mississippi | 28091 | 6687 | 128 |
2188666 | 2188666 | 2022-02-06 | Marshall | Mississippi | 28093 | 9551 | 155 |
2188667 | 2188667 | 2022-02-06 | Monroe | Mississippi | 28095 | 10235 | 197 |
2188668 | 2188668 | 2022-02-06 | Montgomery | Mississippi | 28097 | 2828 | 67 |
2188669 | 2188669 | 2022-02-06 | Neshoba | Mississippi | 28099 | 9922 | 221 |
2188670 | 2188670 | 2022-02-06 | Newton | Mississippi | 28101 | 5677 | 92 |
2188671 | 2188671 | 2022-02-06 | Noxubee | Mississippi | 28103 | 2647 | 47 |
2188672 | 2188672 | 2022-02-06 | Oktibbeha | Mississippi | 28105 | 10286 | 151 |
2188673 | 2188673 | 2022-02-06 | Panola | Mississippi | 28107 | 9913 | 148 |
2188674 | 2188674 | 2022-02-06 | Pearl River | Mississippi | 28109 | 14228 | 251 |
2188675 | 2188675 | 2022-02-06 | Perry | Mississippi | 28111 | 2890 | 58 |
2188676 | 2188676 | 2022-02-06 | Pike | Mississippi | 28113 | 8719 | 168 |
2188677 | 2188677 | 2022-02-06 | Pontotoc | Mississippi | 28115 | 9703 | 125 |
2188678 | 2188678 | 2022-02-06 | Prentiss | Mississippi | 28117 | 7650 | 95 |
2188679 | 2188679 | 2022-02-06 | Quitman | Mississippi | 28119 | 1512 | 29 |
2188680 | 2188680 | 2022-02-06 | Rankin | Mississippi | 28121 | 34795 | 446 |
2188681 | 2188681 | 2022-02-06 | Scott | Mississippi | 28123 | 6353 | 106 |
2188682 | 2188682 | 2022-02-06 | Sharkey | Mississippi | 28125 | 906 | 21 |
2188683 | 2188683 | 2022-02-06 | Simpson | Mississippi | 28127 | 6529 | 133 |
2188684 | 2188684 | 2022-02-06 | Smith | Mississippi | 28129 | 3850 | 65 |
2188685 | 2188685 | 2022-02-06 | Stone | Mississippi | 28131 | 5163 | 67 |
2188686 | 2188686 | 2022-02-06 | Sunflower | Mississippi | 28133 | 5606 | 114 |
2188687 | 2188687 | 2022-02-06 | Tallahatchie | Mississippi | 28135 | 3075 | 55 |
2188688 | 2188688 | 2022-02-06 | Tate | Mississippi | 28137 | 6903 | 131 |
2188689 | 2188689 | 2022-02-06 | Tippah | Mississippi | 28139 | 6779 | 97 |
2188690 | 2188690 | 2022-02-06 | Tishomingo | Mississippi | 28141 | 5732 | 108 |
2188691 | 2188691 | 2022-02-06 | Tunica | Mississippi | 28143 | 2438 | 43 |
2188692 | 2188692 | 2022-02-06 | Union | Mississippi | 28145 | 8985 | 109 |
2188693 | 2188693 | 2022-02-06 | Walthall | Mississippi | 28147 | 3362 | 72 |
2188694 | 2188694 | 2022-02-06 | Warren | Mississippi | 28149 | 9758 | 190 |
2188695 | 2188695 | 2022-02-06 | Washington | Mississippi | 28151 | 9682 | 179 |
2188696 | 2188696 | 2022-02-06 | Wayne | Mississippi | 28153 | 5548 | 79 |
2188697 | 2188697 | 2022-02-06 | Webster | Mississippi | 28155 | 2970 | 58 |
2188698 | 2188698 | 2022-02-06 | Wilkinson | Mississippi | 28157 | 1748 | 42 |
2188699 | 2188699 | 2022-02-06 | Winston | Mississippi | 28159 | 4841 | 98 |
2188700 | 2188700 | 2022-02-06 | Yalobusha | Mississippi | 28161 | 3861 | 50 |
2188701 | 2188701 | 2022-02-06 | Yazoo | Mississippi | 28163 | 7800 | 97 |
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);