ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-10-30" 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 |
---|---|---|---|---|---|---|---|
681722 | 681722 | 2020-10-30 | Adams | Mississippi | 28001 | 1106 | 45 |
681723 | 681723 | 2020-10-30 | Alcorn | Mississippi | 28003 | 1061 | 12 |
681724 | 681724 | 2020-10-30 | Amite | Mississippi | 28005 | 435 | 13 |
681725 | 681725 | 2020-10-30 | Attala | Mississippi | 28007 | 811 | 27 |
681726 | 681726 | 2020-10-30 | Benton | Mississippi | 28009 | 370 | 11 |
681727 | 681727 | 2020-10-30 | Bolivar | Mississippi | 28011 | 2062 | 79 |
681728 | 681728 | 2020-10-30 | Calhoun | Mississippi | 28013 | 638 | 13 |
681729 | 681729 | 2020-10-30 | Carroll | Mississippi | 28015 | 515 | 12 |
681730 | 681730 | 2020-10-30 | Chickasaw | Mississippi | 28017 | 875 | 29 |
681731 | 681731 | 2020-10-30 | Choctaw | Mississippi | 28019 | 210 | 6 |
681732 | 681732 | 2020-10-30 | Claiborne | Mississippi | 28021 | 542 | 16 |
681733 | 681733 | 2020-10-30 | Clarke | Mississippi | 28023 | 785 | 53 |
681734 | 681734 | 2020-10-30 | Clay | Mississippi | 28025 | 718 | 22 |
681735 | 681735 | 2020-10-30 | Coahoma | Mississippi | 28027 | 1270 | 37 |
681736 | 681736 | 2020-10-30 | Copiah | Mississippi | 28029 | 1404 | 37 |
681737 | 681737 | 2020-10-30 | Covington | Mississippi | 28031 | 1001 | 29 |
681738 | 681738 | 2020-10-30 | DeSoto | Mississippi | 28033 | 7422 | 80 |
681739 | 681739 | 2020-10-30 | Forrest | Mississippi | 28035 | 3141 | 79 |
681740 | 681740 | 2020-10-30 | Franklin | Mississippi | 28037 | 253 | 3 |
681741 | 681741 | 2020-10-30 | George | Mississippi | 28039 | 1033 | 20 |
681742 | 681742 | 2020-10-30 | Greene | Mississippi | 28041 | 482 | 18 |
681743 | 681743 | 2020-10-30 | Grenada | Mississippi | 28043 | 1239 | 40 |
681744 | 681744 | 2020-10-30 | Hancock | Mississippi | 28045 | 883 | 29 |
681745 | 681745 | 2020-10-30 | Harrison | Mississippi | 28047 | 5566 | 87 |
681746 | 681746 | 2020-10-30 | Hinds | Mississippi | 28049 | 8135 | 180 |
681747 | 681747 | 2020-10-30 | Holmes | Mississippi | 28051 | 1154 | 60 |
681748 | 681748 | 2020-10-30 | Humphreys | Mississippi | 28053 | 468 | 17 |
681749 | 681749 | 2020-10-30 | Issaquena | Mississippi | 28055 | 107 | 4 |
681750 | 681750 | 2020-10-30 | Itawamba | Mississippi | 28057 | 1198 | 28 |
681751 | 681751 | 2020-10-30 | Jackson | Mississippi | 28059 | 4917 | 90 |
681752 | 681752 | 2020-10-30 | Jasper | Mississippi | 28061 | 702 | 17 |
681753 | 681753 | 2020-10-30 | Jefferson | Mississippi | 28063 | 284 | 10 |
681754 | 681754 | 2020-10-30 | Jefferson Davis | Mississippi | 28065 | 426 | 13 |
681755 | 681755 | 2020-10-30 | Jones | Mississippi | 28067 | 2999 | 84 |
681756 | 681756 | 2020-10-30 | Kemper | Mississippi | 28069 | 335 | 15 |
681757 | 681757 | 2020-10-30 | Lafayette | Mississippi | 28071 | 2591 | 43 |
681758 | 681758 | 2020-10-30 | Lamar | Mississippi | 28073 | 2359 | 40 |
681759 | 681759 | 2020-10-30 | Lauderdale | Mississippi | 28075 | 2639 | 135 |
681760 | 681760 | 2020-10-30 | Lawrence | Mississippi | 28077 | 562 | 14 |
681761 | 681761 | 2020-10-30 | Leake | Mississippi | 28079 | 1178 | 42 |
681762 | 681762 | 2020-10-30 | Lee | Mississippi | 28081 | 3708 | 82 |
681763 | 681763 | 2020-10-30 | Leflore | Mississippi | 28083 | 1741 | 88 |
681764 | 681764 | 2020-10-30 | Lincoln | Mississippi | 28085 | 1467 | 59 |
681765 | 681765 | 2020-10-30 | Lowndes | Mississippi | 28087 | 1832 | 62 |
681766 | 681766 | 2020-10-30 | Madison | Mississippi | 28089 | 3894 | 94 |
681767 | 681767 | 2020-10-30 | Marion | Mississippi | 28091 | 972 | 44 |
681768 | 681768 | 2020-10-30 | Marshall | Mississippi | 28093 | 1518 | 31 |
681769 | 681769 | 2020-10-30 | Monroe | Mississippi | 28095 | 1554 | 74 |
681770 | 681770 | 2020-10-30 | Montgomery | Mississippi | 28097 | 569 | 23 |
681771 | 681771 | 2020-10-30 | Neshoba | Mississippi | 28099 | 1894 | 111 |
681772 | 681772 | 2020-10-30 | Newton | Mississippi | 28101 | 884 | 28 |
681773 | 681773 | 2020-10-30 | Noxubee | Mississippi | 28103 | 604 | 17 |
681774 | 681774 | 2020-10-30 | Oktibbeha | Mississippi | 28105 | 2066 | 56 |
681775 | 681775 | 2020-10-30 | Panola | Mississippi | 28107 | 1734 | 41 |
681776 | 681776 | 2020-10-30 | Pearl River | Mississippi | 28109 | 1188 | 60 |
681777 | 681777 | 2020-10-30 | Perry | Mississippi | 28111 | 534 | 23 |
681778 | 681778 | 2020-10-30 | Pike | Mississippi | 28113 | 1412 | 56 |
681779 | 681779 | 2020-10-30 | Pontotoc | Mississippi | 28115 | 1528 | 20 |
681780 | 681780 | 2020-10-30 | Prentiss | Mississippi | 28117 | 1104 | 20 |
681781 | 681781 | 2020-10-30 | Quitman | Mississippi | 28119 | 424 | 6 |
681782 | 681782 | 2020-10-30 | Rankin | Mississippi | 28121 | 4171 | 86 |
681783 | 681783 | 2020-10-30 | Scott | Mississippi | 28123 | 1290 | 29 |
681784 | 681784 | 2020-10-30 | Sharkey | Mississippi | 28125 | 292 | 15 |
681785 | 681785 | 2020-10-30 | Simpson | Mississippi | 28127 | 1249 | 50 |
681786 | 681786 | 2020-10-30 | Smith | Mississippi | 28129 | 608 | 16 |
681787 | 681787 | 2020-10-30 | Stone | Mississippi | 28131 | 506 | 14 |
681788 | 681788 | 2020-10-30 | Sunflower | Mississippi | 28133 | 1665 | 50 |
681789 | 681789 | 2020-10-30 | Tallahatchie | Mississippi | 28135 | 864 | 26 |
681790 | 681790 | 2020-10-30 | Tate | Mississippi | 28137 | 1248 | 39 |
681791 | 681791 | 2020-10-30 | Tippah | Mississippi | 28139 | 962 | 25 |
681792 | 681792 | 2020-10-30 | Tishomingo | Mississippi | 28141 | 833 | 41 |
681793 | 681793 | 2020-10-30 | Tunica | Mississippi | 28143 | 539 | 17 |
681794 | 681794 | 2020-10-30 | Union | Mississippi | 28145 | 1264 | 25 |
681795 | 681795 | 2020-10-30 | Walthall | Mississippi | 28147 | 649 | 27 |
681796 | 681796 | 2020-10-30 | Warren | Mississippi | 28149 | 1571 | 56 |
681797 | 681797 | 2020-10-30 | Washington | Mississippi | 28151 | 2667 | 100 |
681798 | 681798 | 2020-10-30 | Wayne | Mississippi | 28153 | 1035 | 22 |
681799 | 681799 | 2020-10-30 | Webster | Mississippi | 28155 | 383 | 13 |
681800 | 681800 | 2020-10-30 | Wilkinson | Mississippi | 28157 | 343 | 21 |
681801 | 681801 | 2020-10-30 | Winston | Mississippi | 28159 | 870 | 21 |
681802 | 681802 | 2020-10-30 | Yalobusha | Mississippi | 28161 | 570 | 16 |
681803 | 681803 | 2020-10-30 | Yazoo | Mississippi | 28163 | 1254 | 35 |
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);