ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2021-10-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 |
---|---|---|---|---|---|---|---|
1788788 | 1788788 | 2021-10-06 | Adams | Mississippi | 28001 | 4506 | 119 |
1788789 | 1788789 | 2021-10-06 | Alcorn | Mississippi | 28003 | 5558 | 96 |
1788790 | 1788790 | 2021-10-06 | Amite | Mississippi | 28005 | 2015 | 52 |
1788791 | 1788791 | 2021-10-06 | Attala | Mississippi | 28007 | 3277 | 89 |
1788792 | 1788792 | 2021-10-06 | Benton | Mississippi | 28009 | 1460 | 38 |
1788793 | 1788793 | 2021-10-06 | Bolivar | Mississippi | 28011 | 6211 | 145 |
1788794 | 1788794 | 2021-10-06 | Calhoun | Mississippi | 28013 | 2735 | 45 |
1788795 | 1788795 | 2021-10-06 | Carroll | Mississippi | 28015 | 1647 | 38 |
1788796 | 1788796 | 2021-10-06 | Chickasaw | Mississippi | 28017 | 2924 | 67 |
1788797 | 1788797 | 2021-10-06 | Choctaw | Mississippi | 28019 | 1310 | 26 |
1788798 | 1788798 | 2021-10-06 | Claiborne | Mississippi | 28021 | 1285 | 35 |
1788799 | 1788799 | 2021-10-06 | Clarke | Mississippi | 28023 | 2869 | 92 |
1788800 | 1788800 | 2021-10-06 | Clay | Mississippi | 28025 | 3023 | 74 |
1788801 | 1788801 | 2021-10-06 | Coahoma | Mississippi | 28027 | 4070 | 103 |
1788802 | 1788802 | 2021-10-06 | Copiah | Mississippi | 28029 | 4381 | 89 |
1788803 | 1788803 | 2021-10-06 | Covington | Mississippi | 28031 | 4236 | 93 |
1788804 | 1788804 | 2021-10-06 | DeSoto | Mississippi | 28033 | 31429 | 386 |
1788805 | 1788805 | 2021-10-06 | Forrest | Mississippi | 28035 | 13316 | 245 |
1788806 | 1788806 | 2021-10-06 | Franklin | Mississippi | 28037 | 1180 | 28 |
1788807 | 1788807 | 2021-10-06 | George | Mississippi | 28039 | 4846 | 79 |
1788808 | 1788808 | 2021-10-06 | Greene | Mississippi | 28041 | 2122 | 47 |
1788809 | 1788809 | 2021-10-06 | Grenada | Mississippi | 28043 | 3639 | 108 |
1788810 | 1788810 | 2021-10-06 | Hancock | Mississippi | 28045 | 7646 | 125 |
1788811 | 1788811 | 2021-10-06 | Harrison | Mississippi | 28047 | 33728 | 518 |
1788812 | 1788812 | 2021-10-06 | Hinds | Mississippi | 28049 | 31547 | 609 |
1788813 | 1788813 | 2021-10-06 | Holmes | Mississippi | 28051 | 2649 | 87 |
1788814 | 1788814 | 2021-10-06 | Humphreys | Mississippi | 28053 | 1283 | 38 |
1788815 | 1788815 | 2021-10-06 | Issaquena | Mississippi | 28055 | 193 | 7 |
1788816 | 1788816 | 2021-10-06 | Itawamba | Mississippi | 28057 | 4539 | 104 |
1788817 | 1788817 | 2021-10-06 | Jackson | Mississippi | 28059 | 24123 | 365 |
1788818 | 1788818 | 2021-10-06 | Jasper | Mississippi | 28061 | 3219 | 63 |
1788819 | 1788819 | 2021-10-06 | Jefferson | Mississippi | 28063 | 933 | 34 |
1788820 | 1788820 | 2021-10-06 | Jefferson Davis | Mississippi | 28065 | 1696 | 42 |
1788821 | 1788821 | 2021-10-06 | Jones | Mississippi | 28067 | 13650 | 236 |
1788822 | 1788822 | 2021-10-06 | Kemper | Mississippi | 28069 | 1403 | 41 |
1788823 | 1788823 | 2021-10-06 | Lafayette | Mississippi | 28071 | 8362 | 137 |
1788824 | 1788824 | 2021-10-06 | Lamar | Mississippi | 28073 | 10386 | 134 |
1788825 | 1788825 | 2021-10-06 | Lauderdale | Mississippi | 28075 | 11800 | 308 |
1788826 | 1788826 | 2021-10-06 | Lawrence | Mississippi | 28077 | 2088 | 38 |
1788827 | 1788827 | 2021-10-06 | Leake | Mississippi | 28079 | 4050 | 87 |
1788828 | 1788828 | 2021-10-06 | Lee | Mississippi | 28081 | 15267 | 225 |
1788829 | 1788829 | 2021-10-06 | Leflore | Mississippi | 28083 | 4585 | 141 |
1788830 | 1788830 | 2021-10-06 | Lincoln | Mississippi | 28085 | 5370 | 134 |
1788831 | 1788831 | 2021-10-06 | Lowndes | Mississippi | 28087 | 10744 | 182 |
1788832 | 1788832 | 2021-10-06 | Madison | Mississippi | 28089 | 14419 | 277 |
1788833 | 1788833 | 2021-10-06 | Marion | Mississippi | 28091 | 4174 | 106 |
1788834 | 1788834 | 2021-10-06 | Marshall | Mississippi | 28093 | 6271 | 130 |
1788835 | 1788835 | 2021-10-06 | Monroe | Mississippi | 28095 | 6645 | 173 |
1788836 | 1788836 | 2021-10-06 | Montgomery | Mississippi | 28097 | 1761 | 56 |
1788837 | 1788837 | 2021-10-06 | Neshoba | Mississippi | 28099 | 6560 | 203 |
1788838 | 1788838 | 2021-10-06 | Newton | Mississippi | 28101 | 3768 | 78 |
1788839 | 1788839 | 2021-10-06 | Noxubee | Mississippi | 28103 | 1830 | 40 |
1788840 | 1788840 | 2021-10-06 | Oktibbeha | Mississippi | 28105 | 7071 | 126 |
1788841 | 1788841 | 2021-10-06 | Panola | Mississippi | 28107 | 6420 | 128 |
1788842 | 1788842 | 2021-10-06 | Pearl River | Mississippi | 28109 | 9336 | 235 |
1788843 | 1788843 | 2021-10-06 | Perry | Mississippi | 28111 | 2033 | 54 |
1788844 | 1788844 | 2021-10-06 | Pike | Mississippi | 28113 | 5686 | 150 |
1788845 | 1788845 | 2021-10-06 | Pontotoc | Mississippi | 28115 | 6520 | 97 |
1788846 | 1788846 | 2021-10-06 | Prentiss | Mississippi | 28117 | 4599 | 81 |
1788847 | 1788847 | 2021-10-06 | Quitman | Mississippi | 28119 | 1053 | 27 |
1788848 | 1788848 | 2021-10-06 | Rankin | Mississippi | 28121 | 21695 | 384 |
1788849 | 1788849 | 2021-10-06 | Scott | Mississippi | 28123 | 4669 | 96 |
1788850 | 1788850 | 2021-10-06 | Sharkey | Mississippi | 28125 | 635 | 20 |
1788851 | 1788851 | 2021-10-06 | Simpson | Mississippi | 28127 | 4385 | 116 |
1788852 | 1788852 | 2021-10-06 | Smith | Mississippi | 28129 | 2594 | 49 |
1788853 | 1788853 | 2021-10-06 | Stone | Mississippi | 28131 | 3553 | 64 |
1788854 | 1788854 | 2021-10-06 | Sunflower | Mississippi | 28133 | 4203 | 104 |
1788855 | 1788855 | 2021-10-06 | Tallahatchie | Mississippi | 28135 | 2233 | 51 |
1788856 | 1788856 | 2021-10-06 | Tate | Mississippi | 28137 | 4488 | 107 |
1788857 | 1788857 | 2021-10-06 | Tippah | Mississippi | 28139 | 4591 | 81 |
1788858 | 1788858 | 2021-10-06 | Tishomingo | Mississippi | 28141 | 3492 | 89 |
1788859 | 1788859 | 2021-10-06 | Tunica | Mississippi | 28143 | 1560 | 36 |
1788860 | 1788860 | 2021-10-06 | Union | Mississippi | 28145 | 5884 | 93 |
1788861 | 1788861 | 2021-10-06 | Walthall | Mississippi | 28147 | 2140 | 62 |
1788862 | 1788862 | 2021-10-06 | Warren | Mississippi | 28149 | 6576 | 173 |
1788863 | 1788863 | 2021-10-06 | Washington | Mississippi | 28151 | 7311 | 155 |
1788864 | 1788864 | 2021-10-06 | Wayne | Mississippi | 28153 | 4370 | 72 |
1788865 | 1788865 | 2021-10-06 | Webster | Mississippi | 28155 | 2004 | 45 |
1788866 | 1788866 | 2021-10-06 | Wilkinson | Mississippi | 28157 | 1026 | 37 |
1788867 | 1788867 | 2021-10-06 | Winston | Mississippi | 28159 | 3101 | 91 |
1788868 | 1788868 | 2021-10-06 | Yalobusha | Mississippi | 28161 | 2291 | 47 |
1788869 | 1788869 | 2021-10-06 | Yazoo | Mississippi | 28163 | 4311 | 86 |
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);