ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,222 rows where county = "Marshall" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Mississippi 575
- West Virginia 574
- Alabama 569
- Illinois 569
- Indiana 568
- Iowa 567
- Kentucky 565
- South Dakota 565
- Tennessee 565
- Oklahoma 557
- Minnesota 545
- Kansas 479
fips 12
county 1
- Marshall · 6,698 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1817568 | 1817568 | 2021-10-15 | Marshall | Kansas | 20117 | 1425 | 28 |
1817691 | 1817691 | 2021-10-15 | Marshall | Kentucky | 21157 | 4967 | 76 |
1817985 | 1817985 | 2021-10-15 | Marshall | Minnesota | 27089 | 1314 | 19 |
1818076 | 1818076 | 2021-10-15 | Marshall | Mississippi | 28093 | 6386 | 132 |
1818809 | 1818809 | 2021-10-15 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1819119 | 1819119 | 2021-10-15 | Marshall | South Dakota | 46091 | 427 | 6 |
1819199 | 1819199 | 2021-10-15 | Marshall | Tennessee | 47117 | 6783 | 84 |
1819737 | 1819737 | 2021-10-15 | Marshall | West Virginia | 54051 | 5167 | 106 |
1813413 | 1813413 | 2021-10-14 | Marshall | Alabama | 1095 | 18224 | 298 |
1814026 | 1814026 | 2021-10-14 | Marshall | Illinois | 17123 | 1407 | 23 |
1814120 | 1814120 | 2021-10-14 | Marshall | Indiana | 18099 | 7773 | 138 |
1814226 | 1814226 | 2021-10-14 | Marshall | Iowa | 19127 | 6358 | 84 |
1814320 | 1814320 | 2021-10-14 | Marshall | Kansas | 20117 | 1420 | 28 |
1814443 | 1814443 | 2021-10-14 | Marshall | Kentucky | 21157 | 4956 | 76 |
1814736 | 1814736 | 2021-10-14 | Marshall | Minnesota | 27089 | 1300 | 19 |
1814827 | 1814827 | 2021-10-14 | Marshall | Mississippi | 28093 | 6378 | 132 |
1815560 | 1815560 | 2021-10-14 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1815870 | 1815870 | 2021-10-14 | Marshall | South Dakota | 46091 | 424 | 6 |
1815950 | 1815950 | 2021-10-14 | Marshall | Tennessee | 47117 | 6775 | 83 |
1816488 | 1816488 | 2021-10-14 | Marshall | West Virginia | 54051 | 5154 | 106 |
1810164 | 1810164 | 2021-10-13 | Marshall | Alabama | 1095 | 18214 | 292 |
1810777 | 1810777 | 2021-10-13 | Marshall | Illinois | 17123 | 1405 | 23 |
1810871 | 1810871 | 2021-10-13 | Marshall | Indiana | 18099 | 7745 | 137 |
1810977 | 1810977 | 2021-10-13 | Marshall | Iowa | 19127 | 6358 | 84 |
1811071 | 1811071 | 2021-10-13 | Marshall | Kansas | 20117 | 1420 | 28 |
1811194 | 1811194 | 2021-10-13 | Marshall | Kentucky | 21157 | 4942 | 76 |
1811488 | 1811488 | 2021-10-13 | Marshall | Minnesota | 27089 | 1293 | 19 |
1811579 | 1811579 | 2021-10-13 | Marshall | Mississippi | 28093 | 6365 | 132 |
1812312 | 1812312 | 2021-10-13 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1812622 | 1812622 | 2021-10-13 | Marshall | South Dakota | 46091 | 421 | 6 |
1812702 | 1812702 | 2021-10-13 | Marshall | Tennessee | 47117 | 6764 | 83 |
1813240 | 1813240 | 2021-10-13 | Marshall | West Virginia | 54051 | 5134 | 106 |
1806915 | 1806915 | 2021-10-12 | Marshall | Alabama | 1095 | 18198 | 288 |
1807528 | 1807528 | 2021-10-12 | Marshall | Illinois | 17123 | 1403 | 23 |
1807622 | 1807622 | 2021-10-12 | Marshall | Indiana | 18099 | 7715 | 137 |
1807728 | 1807728 | 2021-10-12 | Marshall | Iowa | 19127 | 6259 | 83 |
1807822 | 1807822 | 2021-10-12 | Marshall | Kansas | 20117 | 1414 | 28 |
1807945 | 1807945 | 2021-10-12 | Marshall | Kentucky | 21157 | 4927 | 76 |
1808239 | 1808239 | 2021-10-12 | Marshall | Minnesota | 27089 | 1284 | 19 |
1808330 | 1808330 | 2021-10-12 | Marshall | Mississippi | 28093 | 6352 | 131 |
1809063 | 1809063 | 2021-10-12 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1809373 | 1809373 | 2021-10-12 | Marshall | South Dakota | 46091 | 421 | 6 |
1809453 | 1809453 | 2021-10-12 | Marshall | Tennessee | 47117 | 6751 | 83 |
1809991 | 1809991 | 2021-10-12 | Marshall | West Virginia | 54051 | 5117 | 106 |
1803664 | 1803664 | 2021-10-11 | Marshall | Alabama | 1095 | 18185 | 288 |
1804277 | 1804277 | 2021-10-11 | Marshall | Illinois | 17123 | 1397 | 23 |
1804371 | 1804371 | 2021-10-11 | Marshall | Indiana | 18099 | 7702 | 137 |
1804477 | 1804477 | 2021-10-11 | Marshall | Iowa | 19127 | 6259 | 83 |
1804571 | 1804571 | 2021-10-11 | Marshall | Kansas | 20117 | 1414 | 28 |
1804694 | 1804694 | 2021-10-11 | Marshall | Kentucky | 21157 | 4915 | 76 |
1804988 | 1804988 | 2021-10-11 | Marshall | Minnesota | 27089 | 1249 | 19 |
1805079 | 1805079 | 2021-10-11 | Marshall | Mississippi | 28093 | 6341 | 130 |
1805813 | 1805813 | 2021-10-11 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1806123 | 1806123 | 2021-10-11 | Marshall | South Dakota | 46091 | 420 | 6 |
1806203 | 1806203 | 2021-10-11 | Marshall | Tennessee | 47117 | 6734 | 83 |
1806742 | 1806742 | 2021-10-11 | Marshall | West Virginia | 54051 | 5109 | 106 |
1800415 | 1800415 | 2021-10-10 | Marshall | Alabama | 1095 | 18174 | 288 |
1801028 | 1801028 | 2021-10-10 | Marshall | Illinois | 17123 | 1397 | 23 |
1801122 | 1801122 | 2021-10-10 | Marshall | Indiana | 18099 | 7667 | 135 |
1801228 | 1801228 | 2021-10-10 | Marshall | Iowa | 19127 | 6259 | 83 |
1801322 | 1801322 | 2021-10-10 | Marshall | Kansas | 20117 | 1408 | 28 |
1801445 | 1801445 | 2021-10-10 | Marshall | Kentucky | 21157 | 4891 | 76 |
1801739 | 1801739 | 2021-10-10 | Marshall | Minnesota | 27089 | 1236 | 19 |
1801830 | 1801830 | 2021-10-10 | Marshall | Mississippi | 28093 | 6311 | 130 |
1802563 | 1802563 | 2021-10-10 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1802873 | 1802873 | 2021-10-10 | Marshall | South Dakota | 46091 | 420 | 6 |
1802953 | 1802953 | 2021-10-10 | Marshall | Tennessee | 47117 | 6697 | 83 |
1803491 | 1803491 | 2021-10-10 | Marshall | West Virginia | 54051 | 5101 | 104 |
1797166 | 1797166 | 2021-10-09 | Marshall | Alabama | 1095 | 18165 | 288 |
1797779 | 1797779 | 2021-10-09 | Marshall | Illinois | 17123 | 1397 | 23 |
1797873 | 1797873 | 2021-10-09 | Marshall | Indiana | 18099 | 7667 | 135 |
1797979 | 1797979 | 2021-10-09 | Marshall | Iowa | 19127 | 6259 | 83 |
1798073 | 1798073 | 2021-10-09 | Marshall | Kansas | 20117 | 1408 | 28 |
1798196 | 1798196 | 2021-10-09 | Marshall | Kentucky | 21157 | 4891 | 76 |
1798490 | 1798490 | 2021-10-09 | Marshall | Minnesota | 27089 | 1236 | 19 |
1798581 | 1798581 | 2021-10-09 | Marshall | Mississippi | 28093 | 6311 | 130 |
1799314 | 1799314 | 2021-10-09 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1799624 | 1799624 | 2021-10-09 | Marshall | South Dakota | 46091 | 420 | 6 |
1799704 | 1799704 | 2021-10-09 | Marshall | Tennessee | 47117 | 6697 | 83 |
1800242 | 1800242 | 2021-10-09 | Marshall | West Virginia | 54051 | 5088 | 104 |
1793917 | 1793917 | 2021-10-08 | Marshall | Alabama | 1095 | 18157 | 285 |
1794530 | 1794530 | 2021-10-08 | Marshall | Illinois | 17123 | 1397 | 23 |
1794624 | 1794624 | 2021-10-08 | Marshall | Indiana | 18099 | 7667 | 135 |
1794730 | 1794730 | 2021-10-08 | Marshall | Iowa | 19127 | 6259 | 83 |
1794824 | 1794824 | 2021-10-08 | Marshall | Kansas | 20117 | 1408 | 28 |
1794947 | 1794947 | 2021-10-08 | Marshall | Kentucky | 21157 | 4891 | 76 |
1795241 | 1795241 | 2021-10-08 | Marshall | Minnesota | 27089 | 1236 | 19 |
1795332 | 1795332 | 2021-10-08 | Marshall | Mississippi | 28093 | 6311 | 130 |
1796065 | 1796065 | 2021-10-08 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1796375 | 1796375 | 2021-10-08 | Marshall | South Dakota | 46091 | 420 | 6 |
1796455 | 1796455 | 2021-10-08 | Marshall | Tennessee | 47117 | 6697 | 83 |
1796993 | 1796993 | 2021-10-08 | Marshall | West Virginia | 54051 | 5066 | 104 |
1790668 | 1790668 | 2021-10-07 | Marshall | Alabama | 1095 | 18136 | 283 |
1791282 | 1791282 | 2021-10-07 | Marshall | Illinois | 17123 | 1396 | 23 |
1791376 | 1791376 | 2021-10-07 | Marshall | Indiana | 18099 | 7636 | 135 |
1791482 | 1791482 | 2021-10-07 | Marshall | Iowa | 19127 | 6259 | 83 |
1791576 | 1791576 | 2021-10-07 | Marshall | Kansas | 20117 | 1399 | 28 |
1791699 | 1791699 | 2021-10-07 | Marshall | Kentucky | 21157 | 4885 | 75 |
1791992 | 1791992 | 2021-10-07 | Marshall | Minnesota | 27089 | 1221 | 19 |
1792083 | 1792083 | 2021-10-07 | Marshall | Mississippi | 28093 | 6302 | 130 |
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);