ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where deaths = 99 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Scott 47
- Union 29
- Tishomingo 24
- Marshall 15
- Lincoln 11
- Panola 9
- Washington 7
- Covington 6
- Neshoba 6
- Yazoo 6
- Hancock 5
- DeSoto 4
- Itawamba 3
- Oktibbeha 3
- Winston 3
- Lee 2
- Leflore 2
- Madison 2
- Pearl River 2
- Sunflower 2
- Adams 1
- Attala 1
- Bolivar 1
- Clarke 1
- Jackson 1
- Lamar 1
- Lauderdale 1
- Lowndes 1
- Marion 1
- Pontotoc 1
- …
state 1
- Mississippi · 200 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2240712 | 2240712 | 2022-02-22 | Prentiss | Mississippi | 28117 | 8102 | 99 |
2214727 | 2214727 | 2022-02-14 | Yazoo | Mississippi | 28163 | 7945 | 99 |
2211473 | 2211473 | 2022-02-13 | Winston | Mississippi | 28159 | 5026 | 99 |
2211475 | 2211475 | 2022-02-13 | Yazoo | Mississippi | 28163 | 7918 | 99 |
2208220 | 2208220 | 2022-02-12 | Winston | Mississippi | 28159 | 5026 | 99 |
2208222 | 2208222 | 2022-02-12 | Yazoo | Mississippi | 28163 | 7918 | 99 |
2204967 | 2204967 | 2022-02-11 | Winston | Mississippi | 28159 | 5026 | 99 |
2204969 | 2204969 | 2022-02-11 | Yazoo | Mississippi | 28163 | 7918 | 99 |
2201716 | 2201716 | 2022-02-10 | Yazoo | Mississippi | 28163 | 7887 | 99 |
2198462 | 2198462 | 2022-02-09 | Yazoo | Mississippi | 28163 | 7880 | 99 |
2195130 | 2195130 | 2022-02-08 | Attala | Mississippi | 28007 | 4728 | 99 |
2195138 | 2195138 | 2022-02-08 | Clarke | Mississippi | 28023 | 4089 | 99 |
2191888 | 2191888 | 2022-02-07 | Covington | Mississippi | 28031 | 6871 | 99 |
2188635 | 2188635 | 2022-02-06 | Covington | Mississippi | 28031 | 6764 | 99 |
2185382 | 2185382 | 2022-02-05 | Covington | Mississippi | 28031 | 6764 | 99 |
2182130 | 2182130 | 2022-02-04 | Covington | Mississippi | 28031 | 6764 | 99 |
2178878 | 2178878 | 2022-02-03 | Covington | Mississippi | 28031 | 6707 | 99 |
2175626 | 2175626 | 2022-02-02 | Covington | Mississippi | 28031 | 6664 | 99 |
2156156 | 2156156 | 2022-01-27 | Tishomingo | Mississippi | 28141 | 5405 | 99 |
2152903 | 2152903 | 2022-01-26 | Tishomingo | Mississippi | 28141 | 5335 | 99 |
2149651 | 2149651 | 2022-01-25 | Tishomingo | Mississippi | 28141 | 5277 | 99 |
2146399 | 2146399 | 2022-01-24 | Tishomingo | Mississippi | 28141 | 5210 | 99 |
2143144 | 2143144 | 2022-01-23 | Tishomingo | Mississippi | 28141 | 5080 | 99 |
2139889 | 2139889 | 2022-01-22 | Tishomingo | Mississippi | 28141 | 5080 | 99 |
2136633 | 2136633 | 2022-01-21 | Tishomingo | Mississippi | 28141 | 5080 | 99 |
2133381 | 2133381 | 2022-01-20 | Tishomingo | Mississippi | 28141 | 4990 | 99 |
2130128 | 2130128 | 2022-01-19 | Tishomingo | Mississippi | 28141 | 4889 | 99 |
2126874 | 2126874 | 2022-01-18 | Tishomingo | Mississippi | 28141 | 4787 | 99 |
2123622 | 2123622 | 2022-01-17 | Tishomingo | Mississippi | 28141 | 4543 | 99 |
2120370 | 2120370 | 2022-01-16 | Tishomingo | Mississippi | 28141 | 4543 | 99 |
2117118 | 2117118 | 2022-01-15 | Tishomingo | Mississippi | 28141 | 4543 | 99 |
2113867 | 2113867 | 2022-01-14 | Tishomingo | Mississippi | 28141 | 4543 | 99 |
2110615 | 2110615 | 2022-01-13 | Tishomingo | Mississippi | 28141 | 4466 | 99 |
2107364 | 2107364 | 2022-01-12 | Tishomingo | Mississippi | 28141 | 4397 | 99 |
2104113 | 2104113 | 2022-01-11 | Tishomingo | Mississippi | 28141 | 4344 | 99 |
2100862 | 2100862 | 2022-01-10 | Tishomingo | Mississippi | 28141 | 4301 | 99 |
2097611 | 2097611 | 2022-01-09 | Tishomingo | Mississippi | 28141 | 4247 | 99 |
2094359 | 2094359 | 2022-01-08 | Tishomingo | Mississippi | 28141 | 4247 | 99 |
2091107 | 2091107 | 2022-01-07 | Tishomingo | Mississippi | 28141 | 4247 | 99 |
2087856 | 2087856 | 2022-01-06 | Tishomingo | Mississippi | 28141 | 4227 | 99 |
2084604 | 2084604 | 2022-01-05 | Tishomingo | Mississippi | 28141 | 4205 | 99 |
2081352 | 2081352 | 2022-01-04 | Tishomingo | Mississippi | 28141 | 4183 | 99 |
2078091 | 2078091 | 2022-01-03 | Scott | Mississippi | 28123 | 5120 | 99 |
2078102 | 2078102 | 2022-01-03 | Union | Mississippi | 28145 | 6923 | 99 |
2074840 | 2074840 | 2022-01-02 | Scott | Mississippi | 28123 | 4983 | 99 |
2074851 | 2074851 | 2022-01-02 | Union | Mississippi | 28145 | 6804 | 99 |
2071589 | 2071589 | 2022-01-01 | Scott | Mississippi | 28123 | 4983 | 99 |
2071600 | 2071600 | 2022-01-01 | Union | Mississippi | 28145 | 6804 | 99 |
2068338 | 2068338 | 2021-12-31 | Scott | Mississippi | 28123 | 4983 | 99 |
2068349 | 2068349 | 2021-12-31 | Union | Mississippi | 28145 | 6804 | 99 |
2065087 | 2065087 | 2021-12-30 | Scott | Mississippi | 28123 | 4983 | 99 |
2065098 | 2065098 | 2021-12-30 | Union | Mississippi | 28145 | 6804 | 99 |
2061837 | 2061837 | 2021-12-29 | Scott | Mississippi | 28123 | 4955 | 99 |
2061848 | 2061848 | 2021-12-29 | Union | Mississippi | 28145 | 6769 | 99 |
2058588 | 2058588 | 2021-12-28 | Scott | Mississippi | 28123 | 4929 | 99 |
2058599 | 2058599 | 2021-12-28 | Union | Mississippi | 28145 | 6738 | 99 |
2055339 | 2055339 | 2021-12-27 | Scott | Mississippi | 28123 | 4911 | 99 |
2055350 | 2055350 | 2021-12-27 | Union | Mississippi | 28145 | 6713 | 99 |
2052089 | 2052089 | 2021-12-26 | Scott | Mississippi | 28123 | 4853 | 99 |
2052100 | 2052100 | 2021-12-26 | Union | Mississippi | 28145 | 6635 | 99 |
2048839 | 2048839 | 2021-12-25 | Scott | Mississippi | 28123 | 4853 | 99 |
2048850 | 2048850 | 2021-12-25 | Union | Mississippi | 28145 | 6635 | 99 |
2045589 | 2045589 | 2021-12-24 | Scott | Mississippi | 28123 | 4853 | 99 |
2045600 | 2045600 | 2021-12-24 | Union | Mississippi | 28145 | 6635 | 99 |
2042339 | 2042339 | 2021-12-23 | Scott | Mississippi | 28123 | 4853 | 99 |
2042350 | 2042350 | 2021-12-23 | Union | Mississippi | 28145 | 6635 | 99 |
2039090 | 2039090 | 2021-12-22 | Scott | Mississippi | 28123 | 4853 | 99 |
2039101 | 2039101 | 2021-12-22 | Union | Mississippi | 28145 | 6635 | 99 |
2035840 | 2035840 | 2021-12-21 | Scott | Mississippi | 28123 | 4850 | 99 |
2035851 | 2035851 | 2021-12-21 | Union | Mississippi | 28145 | 6631 | 99 |
2032590 | 2032590 | 2021-12-20 | Scott | Mississippi | 28123 | 4846 | 99 |
2032601 | 2032601 | 2021-12-20 | Union | Mississippi | 28145 | 6617 | 99 |
2029339 | 2029339 | 2021-12-19 | Scott | Mississippi | 28123 | 4839 | 99 |
2029350 | 2029350 | 2021-12-19 | Union | Mississippi | 28145 | 6601 | 99 |
2026088 | 2026088 | 2021-12-18 | Scott | Mississippi | 28123 | 4839 | 99 |
2026099 | 2026099 | 2021-12-18 | Union | Mississippi | 28145 | 6601 | 99 |
2022837 | 2022837 | 2021-12-17 | Scott | Mississippi | 28123 | 4839 | 99 |
2022848 | 2022848 | 2021-12-17 | Union | Mississippi | 28145 | 6601 | 99 |
2019586 | 2019586 | 2021-12-16 | Scott | Mississippi | 28123 | 4829 | 99 |
2019597 | 2019597 | 2021-12-16 | Union | Mississippi | 28145 | 6582 | 99 |
2016336 | 2016336 | 2021-12-15 | Scott | Mississippi | 28123 | 4817 | 99 |
2016347 | 2016347 | 2021-12-15 | Union | Mississippi | 28145 | 6568 | 99 |
2013085 | 2013085 | 2021-12-14 | Scott | Mississippi | 28123 | 4813 | 99 |
2013096 | 2013096 | 2021-12-14 | Union | Mississippi | 28145 | 6557 | 99 |
2009834 | 2009834 | 2021-12-13 | Scott | Mississippi | 28123 | 4811 | 99 |
2009845 | 2009845 | 2021-12-13 | Union | Mississippi | 28145 | 6545 | 99 |
2006583 | 2006583 | 2021-12-12 | Scott | Mississippi | 28123 | 4806 | 99 |
2006594 | 2006594 | 2021-12-12 | Union | Mississippi | 28145 | 6534 | 99 |
2003332 | 2003332 | 2021-12-11 | Scott | Mississippi | 28123 | 4806 | 99 |
2003343 | 2003343 | 2021-12-11 | Union | Mississippi | 28145 | 6534 | 99 |
2000082 | 2000082 | 2021-12-10 | Scott | Mississippi | 28123 | 4806 | 99 |
2000093 | 2000093 | 2021-12-10 | Union | Mississippi | 28145 | 6534 | 99 |
1996831 | 1996831 | 2021-12-09 | Scott | Mississippi | 28123 | 4806 | 99 |
1996842 | 1996842 | 2021-12-09 | Union | Mississippi | 28145 | 6517 | 99 |
1993580 | 1993580 | 2021-12-08 | Scott | Mississippi | 28123 | 4801 | 99 |
1993591 | 1993591 | 2021-12-08 | Union | Mississippi | 28145 | 6505 | 99 |
1990329 | 1990329 | 2021-12-07 | Scott | Mississippi | 28123 | 4795 | 99 |
1990340 | 1990340 | 2021-12-07 | Union | Mississippi | 28145 | 6470 | 99 |
1987079 | 1987079 | 2021-12-06 | Scott | Mississippi | 28123 | 4794 | 99 |
1987090 | 1987090 | 2021-12-06 | Union | Mississippi | 28145 | 6456 | 99 |
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);