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 686
- West Virginia 685
- Alabama 680
- Illinois 680
- Indiana 679
- Iowa 678
- Kentucky 676
- South Dakota 676
- Tennessee 676
- Oklahoma 668
- Minnesota 656
- Kansas 589
fips 12
county 1
- Marshall · 8,029 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2178525 | 2178525 | 2022-02-03 | Marshall | Kentucky | 21157 | 7910 | 91 |
2178818 | 2178818 | 2022-02-03 | Marshall | Minnesota | 27089 | 1905 | 23 |
2178909 | 2178909 | 2022-02-03 | Marshall | Mississippi | 28093 | 9400 | 155 |
2179644 | 2179644 | 2022-02-03 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2179954 | 2179954 | 2022-02-03 | Marshall | South Dakota | 46091 | 740 | 11 |
2180034 | 2180034 | 2022-02-03 | Marshall | Tennessee | 47117 | 9465 | 108 |
2180572 | 2180572 | 2022-02-03 | Marshall | West Virginia | 54051 | 8140 | 143 |
2174241 | 2174241 | 2022-02-02 | Marshall | Alabama | 1095 | 26135 | 345 |
2174855 | 2174855 | 2022-02-02 | Marshall | Illinois | 17123 | 2639 | 31 |
2174949 | 2174949 | 2022-02-02 | Marshall | Indiana | 18099 | 12045 | 187 |
2175055 | 2175055 | 2022-02-02 | Marshall | Iowa | 19127 | 8993 | 98 |
2175149 | 2175149 | 2022-02-02 | Marshall | Kansas | 20117 | 2479 | 39 |
2175272 | 2175272 | 2022-02-02 | Marshall | Kentucky | 21157 | 7815 | 91 |
2175566 | 2175566 | 2022-02-02 | Marshall | Minnesota | 27089 | 1894 | 23 |
2175657 | 2175657 | 2022-02-02 | Marshall | Mississippi | 28093 | 9226 | 155 |
2176393 | 2176393 | 2022-02-02 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2176703 | 2176703 | 2022-02-02 | Marshall | South Dakota | 46091 | 738 | 11 |
2176783 | 2176783 | 2022-02-02 | Marshall | Tennessee | 47117 | 9465 | 108 |
2177321 | 2177321 | 2022-02-02 | Marshall | West Virginia | 54051 | 8104 | 143 |
2170989 | 2170989 | 2022-02-01 | Marshall | Alabama | 1095 | 26020 | 344 |
2171602 | 2171602 | 2022-02-01 | Marshall | Illinois | 17123 | 2634 | 30 |
2171696 | 2171696 | 2022-02-01 | Marshall | Indiana | 18099 | 12003 | 185 |
2171802 | 2171802 | 2022-02-01 | Marshall | Iowa | 19127 | 8776 | 96 |
2171896 | 2171896 | 2022-02-01 | Marshall | Kansas | 20117 | 2448 | 39 |
2172019 | 2172019 | 2022-02-01 | Marshall | Kentucky | 21157 | 7769 | 91 |
2172313 | 2172313 | 2022-02-01 | Marshall | Minnesota | 27089 | 1884 | 23 |
2172404 | 2172404 | 2022-02-01 | Marshall | Mississippi | 28093 | 9027 | 154 |
2173139 | 2173139 | 2022-02-01 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2173449 | 2173449 | 2022-02-01 | Marshall | South Dakota | 46091 | 731 | 11 |
2173529 | 2173529 | 2022-02-01 | Marshall | Tennessee | 47117 | 8883 | 108 |
2174068 | 2174068 | 2022-02-01 | Marshall | West Virginia | 54051 | 8064 | 143 |
2167736 | 2167736 | 2022-01-31 | Marshall | Alabama | 1095 | 25848 | 343 |
2168349 | 2168349 | 2022-01-31 | Marshall | Illinois | 17123 | 2624 | 30 |
2168443 | 2168443 | 2022-01-31 | Marshall | Indiana | 18099 | 11984 | 184 |
2168549 | 2168549 | 2022-01-31 | Marshall | Iowa | 19127 | 8776 | 96 |
2168643 | 2168643 | 2022-01-31 | Marshall | Kansas | 20117 | 2448 | 39 |
2168766 | 2168766 | 2022-01-31 | Marshall | Kentucky | 21157 | 7724 | 91 |
2169060 | 2169060 | 2022-01-31 | Marshall | Minnesota | 27089 | 1870 | 23 |
2169151 | 2169151 | 2022-01-31 | Marshall | Mississippi | 28093 | 8989 | 154 |
2169887 | 2169887 | 2022-01-31 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2170197 | 2170197 | 2022-01-31 | Marshall | South Dakota | 46091 | 718 | 11 |
2170277 | 2170277 | 2022-01-31 | Marshall | Tennessee | 47117 | 8883 | 108 |
2170816 | 2170816 | 2022-01-31 | Marshall | West Virginia | 54051 | 8015 | 143 |
2164481 | 2164481 | 2022-01-30 | Marshall | Alabama | 1095 | 25777 | 343 |
2165094 | 2165094 | 2022-01-30 | Marshall | Illinois | 17123 | 2598 | 30 |
2165188 | 2165188 | 2022-01-30 | Marshall | Indiana | 18099 | 11854 | 183 |
2165294 | 2165294 | 2022-01-30 | Marshall | Iowa | 19127 | 8776 | 96 |
2165388 | 2165388 | 2022-01-30 | Marshall | Kansas | 20117 | 2432 | 39 |
2165511 | 2165511 | 2022-01-30 | Marshall | Kentucky | 21157 | 7527 | 91 |
2165805 | 2165805 | 2022-01-30 | Marshall | Minnesota | 27089 | 1835 | 23 |
2165896 | 2165896 | 2022-01-30 | Marshall | Mississippi | 28093 | 8891 | 154 |
2166632 | 2166632 | 2022-01-30 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2166943 | 2166943 | 2022-01-30 | Marshall | South Dakota | 46091 | 710 | 9 |
2167023 | 2167023 | 2022-01-30 | Marshall | Tennessee | 47117 | 8883 | 108 |
2167563 | 2167563 | 2022-01-30 | Marshall | West Virginia | 54051 | 8001 | 143 |
2161226 | 2161226 | 2022-01-29 | Marshall | Alabama | 1095 | 25600 | 343 |
2161839 | 2161839 | 2022-01-29 | Marshall | Illinois | 17123 | 2598 | 30 |
2161933 | 2161933 | 2022-01-29 | Marshall | Indiana | 18099 | 11854 | 183 |
2162039 | 2162039 | 2022-01-29 | Marshall | Iowa | 19127 | 8776 | 96 |
2162133 | 2162133 | 2022-01-29 | Marshall | Kansas | 20117 | 2432 | 39 |
2162256 | 2162256 | 2022-01-29 | Marshall | Kentucky | 21157 | 7527 | 91 |
2162550 | 2162550 | 2022-01-29 | Marshall | Minnesota | 27089 | 1835 | 23 |
2162641 | 2162641 | 2022-01-29 | Marshall | Mississippi | 28093 | 8891 | 154 |
2163377 | 2163377 | 2022-01-29 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2163688 | 2163688 | 2022-01-29 | Marshall | South Dakota | 46091 | 710 | 9 |
2163768 | 2163768 | 2022-01-29 | Marshall | Tennessee | 47117 | 8883 | 108 |
2164308 | 2164308 | 2022-01-29 | Marshall | West Virginia | 54051 | 7979 | 143 |
2157970 | 2157970 | 2022-01-28 | Marshall | Alabama | 1095 | 24157 | 335 |
2158584 | 2158584 | 2022-01-28 | Marshall | Illinois | 17123 | 2598 | 30 |
2158678 | 2158678 | 2022-01-28 | Marshall | Indiana | 18099 | 11854 | 183 |
2158784 | 2158784 | 2022-01-28 | Marshall | Iowa | 19127 | 8776 | 96 |
2158878 | 2158878 | 2022-01-28 | Marshall | Kansas | 20117 | 2432 | 39 |
2159001 | 2159001 | 2022-01-28 | Marshall | Kentucky | 21157 | 7527 | 91 |
2159295 | 2159295 | 2022-01-28 | Marshall | Minnesota | 27089 | 1835 | 23 |
2159386 | 2159386 | 2022-01-28 | Marshall | Mississippi | 28093 | 8891 | 154 |
2160122 | 2160122 | 2022-01-28 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2160433 | 2160433 | 2022-01-28 | Marshall | South Dakota | 46091 | 710 | 9 |
2160513 | 2160513 | 2022-01-28 | Marshall | Tennessee | 47117 | 8883 | 108 |
2161053 | 2161053 | 2022-01-28 | Marshall | West Virginia | 54051 | 7941 | 143 |
2154717 | 2154717 | 2022-01-27 | Marshall | Alabama | 1095 | 24157 | 335 |
2155330 | 2155330 | 2022-01-27 | Marshall | Illinois | 17123 | 2579 | 30 |
2155424 | 2155424 | 2022-01-27 | Marshall | Indiana | 18099 | 11761 | 182 |
2155530 | 2155530 | 2022-01-27 | Marshall | Iowa | 19127 | 8776 | 96 |
2155624 | 2155624 | 2022-01-27 | Marshall | Kansas | 20117 | 2409 | 39 |
2155747 | 2155747 | 2022-01-27 | Marshall | Kentucky | 21157 | 7385 | 91 |
2156041 | 2156041 | 2022-01-27 | Marshall | Minnesota | 27089 | 1825 | 23 |
2156132 | 2156132 | 2022-01-27 | Marshall | Mississippi | 28093 | 8844 | 154 |
2156867 | 2156867 | 2022-01-27 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2157177 | 2157177 | 2022-01-27 | Marshall | South Dakota | 46091 | 698 | 9 |
2157257 | 2157257 | 2022-01-27 | Marshall | Tennessee | 47117 | 8883 | 108 |
2157797 | 2157797 | 2022-01-27 | Marshall | West Virginia | 54051 | 7892 | 143 |
2151464 | 2151464 | 2022-01-26 | Marshall | Alabama | 1095 | 24157 | 335 |
2152077 | 2152077 | 2022-01-26 | Marshall | Illinois | 17123 | 2570 | 29 |
2152171 | 2152171 | 2022-01-26 | Marshall | Indiana | 18099 | 11697 | 182 |
2152277 | 2152277 | 2022-01-26 | Marshall | Iowa | 19127 | 8776 | 96 |
2152371 | 2152371 | 2022-01-26 | Marshall | Kansas | 20117 | 2409 | 39 |
2152494 | 2152494 | 2022-01-26 | Marshall | Kentucky | 21157 | 7270 | 91 |
2152788 | 2152788 | 2022-01-26 | Marshall | Minnesota | 27089 | 1804 | 23 |
2152879 | 2152879 | 2022-01-26 | Marshall | Mississippi | 28093 | 8781 | 154 |
2153614 | 2153614 | 2022-01-26 | Marshall | Oklahoma | 40095 | 4141 | 32 |
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);