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 194
- West Virginia 194
- Alabama 189
- Illinois 189
- Indiana 188
- Iowa 187
- South Dakota 185
- Tennessee 185
- Kentucky 184
- Oklahoma 176
- Minnesota 164
- Kansas 98
fips 12
county 1
- Marshall · 2,133 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
585505 | 585505 | 2020-09-30 | Marshall | South Dakota | 46091 | 43 | 0 |
585585 | 585585 | 2020-09-30 | Marshall | Tennessee | 47117 | 791 | 5 |
586121 | 586121 | 2020-09-30 | Marshall | West Virginia | 54051 | 179 | 1 |
579816 | 579816 | 2020-09-29 | Marshall | Alabama | 1095 | 3975 | 43 |
580425 | 580425 | 2020-09-29 | Marshall | Illinois | 17123 | 109 | 0 |
580519 | 580519 | 2020-09-29 | Marshall | Indiana | 18099 | 1021 | 24 |
580625 | 580625 | 2020-09-29 | Marshall | Iowa | 19127 | 1794 | 34 |
580719 | 580719 | 2020-09-29 | Marshall | Kansas | 20117 | 26 | 0 |
580842 | 580842 | 2020-09-29 | Marshall | Kentucky | 21157 | 314 | 4 |
581135 | 581135 | 2020-09-29 | Marshall | Minnesota | 27089 | 53 | 1 |
581226 | 581226 | 2020-09-29 | Marshall | Mississippi | 28093 | 1118 | 21 |
581956 | 581956 | 2020-09-29 | Marshall | Oklahoma | 40095 | 183 | 2 |
582265 | 582265 | 2020-09-29 | Marshall | South Dakota | 46091 | 40 | 0 |
582345 | 582345 | 2020-09-29 | Marshall | Tennessee | 47117 | 781 | 5 |
582881 | 582881 | 2020-09-29 | Marshall | West Virginia | 54051 | 179 | 1 |
576575 | 576575 | 2020-09-28 | Marshall | Alabama | 1095 | 3967 | 43 |
577184 | 577184 | 2020-09-28 | Marshall | Illinois | 17123 | 105 | 0 |
577278 | 577278 | 2020-09-28 | Marshall | Indiana | 18099 | 1015 | 24 |
577384 | 577384 | 2020-09-28 | Marshall | Iowa | 19127 | 1791 | 34 |
577478 | 577478 | 2020-09-28 | Marshall | Kansas | 20117 | 26 | 0 |
577601 | 577601 | 2020-09-28 | Marshall | Kentucky | 21157 | 307 | 4 |
577894 | 577894 | 2020-09-28 | Marshall | Minnesota | 27089 | 53 | 1 |
577985 | 577985 | 2020-09-28 | Marshall | Mississippi | 28093 | 1115 | 17 |
578716 | 578716 | 2020-09-28 | Marshall | Oklahoma | 40095 | 181 | 2 |
579025 | 579025 | 2020-09-28 | Marshall | South Dakota | 46091 | 38 | 0 |
579105 | 579105 | 2020-09-28 | Marshall | Tennessee | 47117 | 780 | 5 |
579642 | 579642 | 2020-09-28 | Marshall | West Virginia | 54051 | 178 | 1 |
573331 | 573331 | 2020-09-27 | Marshall | Alabama | 1095 | 3961 | 43 |
573942 | 573942 | 2020-09-27 | Marshall | Illinois | 17123 | 104 | 0 |
574036 | 574036 | 2020-09-27 | Marshall | Indiana | 18099 | 1012 | 24 |
574142 | 574142 | 2020-09-27 | Marshall | Iowa | 19127 | 1790 | 34 |
574236 | 574236 | 2020-09-27 | Marshall | Kansas | 20117 | 23 | 0 |
574359 | 574359 | 2020-09-27 | Marshall | Kentucky | 21157 | 302 | 4 |
574653 | 574653 | 2020-09-27 | Marshall | Minnesota | 27089 | 53 | 1 |
574744 | 574744 | 2020-09-27 | Marshall | Mississippi | 28093 | 1111 | 17 |
575475 | 575475 | 2020-09-27 | Marshall | Oklahoma | 40095 | 180 | 2 |
575784 | 575784 | 2020-09-27 | Marshall | South Dakota | 46091 | 38 | 0 |
575864 | 575864 | 2020-09-27 | Marshall | Tennessee | 47117 | 778 | 5 |
576401 | 576401 | 2020-09-27 | Marshall | West Virginia | 54051 | 173 | 1 |
570089 | 570089 | 2020-09-26 | Marshall | Alabama | 1095 | 3943 | 43 |
570699 | 570699 | 2020-09-26 | Marshall | Illinois | 17123 | 101 | 0 |
570793 | 570793 | 2020-09-26 | Marshall | Indiana | 18099 | 1007 | 24 |
570899 | 570899 | 2020-09-26 | Marshall | Iowa | 19127 | 1784 | 34 |
570993 | 570993 | 2020-09-26 | Marshall | Kansas | 20117 | 23 | 0 |
571116 | 571116 | 2020-09-26 | Marshall | Kentucky | 21157 | 299 | 4 |
571410 | 571410 | 2020-09-26 | Marshall | Minnesota | 27089 | 52 | 1 |
571501 | 571501 | 2020-09-26 | Marshall | Mississippi | 28093 | 1106 | 17 |
572231 | 572231 | 2020-09-26 | Marshall | Oklahoma | 40095 | 180 | 2 |
572540 | 572540 | 2020-09-26 | Marshall | South Dakota | 46091 | 38 | 0 |
572620 | 572620 | 2020-09-26 | Marshall | Tennessee | 47117 | 756 | 5 |
573157 | 573157 | 2020-09-26 | Marshall | West Virginia | 54051 | 172 | 1 |
566848 | 566848 | 2020-09-25 | Marshall | Alabama | 1095 | 3933 | 43 |
567457 | 567457 | 2020-09-25 | Marshall | Illinois | 17123 | 101 | 0 |
567551 | 567551 | 2020-09-25 | Marshall | Indiana | 18099 | 1008 | 24 |
567657 | 567657 | 2020-09-25 | Marshall | Iowa | 19127 | 1777 | 34 |
567751 | 567751 | 2020-09-25 | Marshall | Kansas | 20117 | 23 | 0 |
567874 | 567874 | 2020-09-25 | Marshall | Kentucky | 21157 | 297 | 4 |
568168 | 568168 | 2020-09-25 | Marshall | Minnesota | 27089 | 51 | 1 |
568259 | 568259 | 2020-09-25 | Marshall | Mississippi | 28093 | 1095 | 17 |
568989 | 568989 | 2020-09-25 | Marshall | Oklahoma | 40095 | 180 | 2 |
569298 | 569298 | 2020-09-25 | Marshall | South Dakota | 46091 | 38 | 0 |
569378 | 569378 | 2020-09-25 | Marshall | Tennessee | 47117 | 749 | 5 |
569915 | 569915 | 2020-09-25 | Marshall | West Virginia | 54051 | 170 | 1 |
563607 | 563607 | 2020-09-24 | Marshall | Alabama | 1095 | 3909 | 44 |
564217 | 564217 | 2020-09-24 | Marshall | Illinois | 17123 | 99 | 0 |
564311 | 564311 | 2020-09-24 | Marshall | Indiana | 18099 | 997 | 24 |
564417 | 564417 | 2020-09-24 | Marshall | Iowa | 19127 | 1770 | 34 |
564511 | 564511 | 2020-09-24 | Marshall | Kansas | 20117 | 20 | 0 |
564634 | 564634 | 2020-09-24 | Marshall | Kentucky | 21157 | 290 | 3 |
564928 | 564928 | 2020-09-24 | Marshall | Minnesota | 27089 | 50 | 1 |
565019 | 565019 | 2020-09-24 | Marshall | Mississippi | 28093 | 1092 | 17 |
565748 | 565748 | 2020-09-24 | Marshall | Oklahoma | 40095 | 178 | 1 |
566057 | 566057 | 2020-09-24 | Marshall | South Dakota | 46091 | 37 | 0 |
566137 | 566137 | 2020-09-24 | Marshall | Tennessee | 47117 | 741 | 5 |
566674 | 566674 | 2020-09-24 | Marshall | West Virginia | 54051 | 162 | 1 |
560368 | 560368 | 2020-09-23 | Marshall | Alabama | 1095 | 3892 | 44 |
560977 | 560977 | 2020-09-23 | Marshall | Illinois | 17123 | 98 | 0 |
561071 | 561071 | 2020-09-23 | Marshall | Indiana | 18099 | 994 | 24 |
561177 | 561177 | 2020-09-23 | Marshall | Iowa | 19127 | 1768 | 34 |
561271 | 561271 | 2020-09-23 | Marshall | Kansas | 20117 | 20 | 0 |
561394 | 561394 | 2020-09-23 | Marshall | Kentucky | 21157 | 285 | 3 |
561688 | 561688 | 2020-09-23 | Marshall | Minnesota | 27089 | 50 | 1 |
561779 | 561779 | 2020-09-23 | Marshall | Mississippi | 28093 | 1085 | 16 |
562507 | 562507 | 2020-09-23 | Marshall | Oklahoma | 40095 | 178 | 1 |
562816 | 562816 | 2020-09-23 | Marshall | South Dakota | 46091 | 38 | 0 |
562896 | 562896 | 2020-09-23 | Marshall | Tennessee | 47117 | 733 | 5 |
563433 | 563433 | 2020-09-23 | Marshall | West Virginia | 54051 | 163 | 1 |
557132 | 557132 | 2020-09-22 | Marshall | Alabama | 1095 | 3889 | 43 |
557741 | 557741 | 2020-09-22 | Marshall | Illinois | 17123 | 94 | 0 |
557835 | 557835 | 2020-09-22 | Marshall | Indiana | 18099 | 989 | 24 |
557941 | 557941 | 2020-09-22 | Marshall | Iowa | 19127 | 1764 | 34 |
558035 | 558035 | 2020-09-22 | Marshall | Kansas | 20117 | 19 | 0 |
558158 | 558158 | 2020-09-22 | Marshall | Kentucky | 21157 | 280 | 2 |
558451 | 558451 | 2020-09-22 | Marshall | Minnesota | 27089 | 50 | 1 |
558542 | 558542 | 2020-09-22 | Marshall | Mississippi | 28093 | 1080 | 15 |
559270 | 559270 | 2020-09-22 | Marshall | Oklahoma | 40095 | 173 | 1 |
559579 | 559579 | 2020-09-22 | Marshall | South Dakota | 46091 | 37 | 0 |
559659 | 559659 | 2020-09-22 | Marshall | Tennessee | 47117 | 720 | 5 |
560194 | 560194 | 2020-09-22 | Marshall | West Virginia | 54051 | 160 | 1 |
553895 | 553895 | 2020-09-21 | Marshall | Alabama | 1095 | 3879 | 43 |
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);