ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where "date" is on date 2020-03-27 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 69
- 28001 1
- 28007 1
- 28009 1
- 28011 1
- 28013 1
- 28017 1
- 28019 1
- 28025 1
- 28027 1
- 28029 1
- 28033 1
- 28035 1
- 28037 1
- 28039 1
- 28043 1
- 28045 1
- 28047 1
- 28049 1
- 28051 1
- 28053 1
- 28057 1
- 28059 1
- 28063 1
- 28067 1
- 28069 1
- 28071 1
- 28073 1
- 28075 1
- 28077 1
- 28079 1
- 28081 1
- 28083 1
- 28085 1
- 28087 1
- 28089 1
- 28091 1
- 28093 1
- 28095 1
- 28097 1
- 28099 1
- 28101 1
- 28103 1
- 28105 1
- 28107 1
- 28109 1
- 28111 1
- 28113 1
- 28115 1
- 28117 1
- 28119 1
- 28121 1
- 28123 1
- 28125 1
- 28127 1
- 28129 1
- 28133 1
- 28135 1
- 28137 1
- 28139 1
- 28143 1
- 28145 1
- 28147 1
- 28151 1
- 28155 1
- 28157 1
- 28159 1
- 28161 1
- 28163 1
- - 1
county 69
- Adams 1
- Attala 1
- Benton 1
- Bolivar 1
- Calhoun 1
- Chickasaw 1
- Choctaw 1
- Clay 1
- Coahoma 1
- Copiah 1
- DeSoto 1
- Forrest 1
- Franklin 1
- George 1
- Grenada 1
- Hancock 1
- Harrison 1
- Hinds 1
- Holmes 1
- Humphreys 1
- Itawamba 1
- Jackson 1
- Jefferson 1
- Jones 1
- Kemper 1
- Lafayette 1
- Lamar 1
- Lauderdale 1
- Lawrence 1
- Leake 1
- Lee 1
- Leflore 1
- Lincoln 1
- Lowndes 1
- Madison 1
- Marion 1
- Marshall 1
- Monroe 1
- Montgomery 1
- Neshoba 1
- Newton 1
- Noxubee 1
- Oktibbeha 1
- Panola 1
- Pearl River 1
- Perry 1
- Pike 1
- Pontotoc 1
- Prentiss 1
- Quitman 1
- Rankin 1
- Scott 1
- Sharkey 1
- Simpson 1
- Smith 1
- Sunflower 1
- Tallahatchie 1
- Tate 1
- Tippah 1
- Tunica 1
- Union 1
- Unknown 1
- Walthall 1
- Washington 1
- Webster 1
- Wilkinson 1
- Winston 1
- Yalobusha 1
- Yazoo 1
state 1
- Mississippi · 69 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14859 | 14859 | 2020-03-27 | Adams | Mississippi | 28001 | 2 | 0 |
14860 | 14860 | 2020-03-27 | Attala | Mississippi | 28007 | 8 | 0 |
14861 | 14861 | 2020-03-27 | Benton | Mississippi | 28009 | 2 | 0 |
14862 | 14862 | 2020-03-27 | Bolivar | Mississippi | 28011 | 9 | 0 |
14863 | 14863 | 2020-03-27 | Calhoun | Mississippi | 28013 | 3 | 0 |
14864 | 14864 | 2020-03-27 | Chickasaw | Mississippi | 28017 | 9 | 0 |
14865 | 14865 | 2020-03-27 | Choctaw | Mississippi | 28019 | 4 | 0 |
14866 | 14866 | 2020-03-27 | Clay | Mississippi | 28025 | 2 | 0 |
14867 | 14867 | 2020-03-27 | Coahoma | Mississippi | 28027 | 18 | 0 |
14868 | 14868 | 2020-03-27 | Copiah | Mississippi | 28029 | 8 | 0 |
14869 | 14869 | 2020-03-27 | DeSoto | Mississippi | 28033 | 63 | 0 |
14870 | 14870 | 2020-03-27 | Forrest | Mississippi | 28035 | 16 | 0 |
14871 | 14871 | 2020-03-27 | Franklin | Mississippi | 28037 | 3 | 0 |
14872 | 14872 | 2020-03-27 | George | Mississippi | 28039 | 1 | 0 |
14873 | 14873 | 2020-03-27 | Grenada | Mississippi | 28043 | 2 | 0 |
14874 | 14874 | 2020-03-27 | Hancock | Mississippi | 28045 | 9 | 1 |
14875 | 14875 | 2020-03-27 | Harrison | Mississippi | 28047 | 34 | 1 |
14876 | 14876 | 2020-03-27 | Hinds | Mississippi | 28049 | 50 | 0 |
14877 | 14877 | 2020-03-27 | Holmes | Mississippi | 28051 | 10 | 1 |
14878 | 14878 | 2020-03-27 | Humphreys | Mississippi | 28053 | 1 | 0 |
14879 | 14879 | 2020-03-27 | Itawamba | Mississippi | 28057 | 3 | 0 |
14880 | 14880 | 2020-03-27 | Jackson | Mississippi | 28059 | 24 | 0 |
14881 | 14881 | 2020-03-27 | Jefferson | Mississippi | 28063 | 1 | 0 |
14882 | 14882 | 2020-03-27 | Jones | Mississippi | 28067 | 1 | 0 |
14883 | 14883 | 2020-03-27 | Kemper | Mississippi | 28069 | 1 | 0 |
14884 | 14884 | 2020-03-27 | Lafayette | Mississippi | 28071 | 11 | 0 |
14885 | 14885 | 2020-03-27 | Lamar | Mississippi | 28073 | 4 | 0 |
14886 | 14886 | 2020-03-27 | Lauderdale | Mississippi | 28075 | 10 | 0 |
14887 | 14887 | 2020-03-27 | Lawrence | Mississippi | 28077 | 5 | 0 |
14888 | 14888 | 2020-03-27 | Leake | Mississippi | 28079 | 4 | 0 |
14889 | 14889 | 2020-03-27 | Lee | Mississippi | 28081 | 15 | 0 |
14890 | 14890 | 2020-03-27 | Leflore | Mississippi | 28083 | 13 | 0 |
14891 | 14891 | 2020-03-27 | Lincoln | Mississippi | 28085 | 6 | 0 |
14892 | 14892 | 2020-03-27 | Lowndes | Mississippi | 28087 | 9 | 0 |
14893 | 14893 | 2020-03-27 | Madison | Mississippi | 28089 | 25 | 0 |
14894 | 14894 | 2020-03-27 | Marion | Mississippi | 28091 | 1 | 0 |
14895 | 14895 | 2020-03-27 | Marshall | Mississippi | 28093 | 9 | 0 |
14896 | 14896 | 2020-03-27 | Monroe | Mississippi | 28095 | 3 | 0 |
14897 | 14897 | 2020-03-27 | Montgomery | Mississippi | 28097 | 4 | 0 |
14898 | 14898 | 2020-03-27 | Neshoba | Mississippi | 28099 | 1 | 0 |
14899 | 14899 | 2020-03-27 | Newton | Mississippi | 28101 | 1 | 0 |
14900 | 14900 | 2020-03-27 | Noxubee | Mississippi | 28103 | 1 | 0 |
14901 | 14901 | 2020-03-27 | Oktibbeha | Mississippi | 28105 | 12 | 0 |
14902 | 14902 | 2020-03-27 | Panola | Mississippi | 28107 | 4 | 0 |
14903 | 14903 | 2020-03-27 | Pearl River | Mississippi | 28109 | 18 | 0 |
14904 | 14904 | 2020-03-27 | Perry | Mississippi | 28111 | 2 | 0 |
14905 | 14905 | 2020-03-27 | Pike | Mississippi | 28113 | 12 | 0 |
14906 | 14906 | 2020-03-27 | Pontotoc | Mississippi | 28115 | 4 | 0 |
14907 | 14907 | 2020-03-27 | Prentiss | Mississippi | 28117 | 1 | 0 |
14908 | 14908 | 2020-03-27 | Quitman | Mississippi | 28119 | 3 | 0 |
14909 | 14909 | 2020-03-27 | Rankin | Mississippi | 28121 | 29 | 1 |
14910 | 14910 | 2020-03-27 | Scott | Mississippi | 28123 | 6 | 0 |
14911 | 14911 | 2020-03-27 | Sharkey | Mississippi | 28125 | 1 | 0 |
14912 | 14912 | 2020-03-27 | Simpson | Mississippi | 28127 | 1 | 0 |
14913 | 14913 | 2020-03-27 | Smith | Mississippi | 28129 | 1 | 0 |
14914 | 14914 | 2020-03-27 | Sunflower | Mississippi | 28133 | 5 | 0 |
14915 | 14915 | 2020-03-27 | Tallahatchie | Mississippi | 28135 | 2 | 0 |
14916 | 14916 | 2020-03-27 | Tate | Mississippi | 28137 | 8 | 0 |
14917 | 14917 | 2020-03-27 | Tippah | Mississippi | 28139 | 15 | 1 |
14918 | 14918 | 2020-03-27 | Tunica | Mississippi | 28143 | 6 | 1 |
14919 | 14919 | 2020-03-27 | Union | Mississippi | 28145 | 3 | 0 |
14920 | 14920 | 2020-03-27 | Unknown | Mississippi | 3 | 0 | |
14921 | 14921 | 2020-03-27 | Walthall | Mississippi | 28147 | 4 | 0 |
14922 | 14922 | 2020-03-27 | Washington | Mississippi | 28151 | 11 | 0 |
14923 | 14923 | 2020-03-27 | Webster | Mississippi | 28155 | 3 | 1 |
14924 | 14924 | 2020-03-27 | Wilkinson | Mississippi | 28157 | 9 | 1 |
14925 | 14925 | 2020-03-27 | Winston | Mississippi | 28159 | 3 | 0 |
14926 | 14926 | 2020-03-27 | Yalobusha | Mississippi | 28161 | 3 | 0 |
14927 | 14927 | 2020-03-27 | Yazoo | Mississippi | 28163 | 4 | 0 |
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);