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 180
- West Virginia 179
- Illinois 175
- Alabama 174
- Indiana 174
- Iowa 173
- Kentucky 170
- South Dakota 170
- Tennessee 170
- Oklahoma 162
- Minnesota 150
- Kansas 84
fips 12
county 1
- Marshall · 1,961 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535079 | 535079 | 2020-09-15 | Marshall | Illinois | 17123 | 76 | 0 |
535173 | 535173 | 2020-09-15 | Marshall | Indiana | 18099 | 966 | 23 |
535279 | 535279 | 2020-09-15 | Marshall | Iowa | 19127 | 1743 | 32 |
535373 | 535373 | 2020-09-15 | Marshall | Kansas | 20117 | 18 | 0 |
535496 | 535496 | 2020-09-15 | Marshall | Kentucky | 21157 | 239 | 2 |
535789 | 535789 | 2020-09-15 | Marshall | Minnesota | 27089 | 49 | 1 |
535880 | 535880 | 2020-09-15 | Marshall | Mississippi | 28093 | 1052 | 14 |
536608 | 536608 | 2020-09-15 | Marshall | Oklahoma | 40095 | 161 | 1 |
536917 | 536917 | 2020-09-15 | Marshall | South Dakota | 46091 | 28 | 0 |
536997 | 536997 | 2020-09-15 | Marshall | Tennessee | 47117 | 658 | 4 |
537533 | 537533 | 2020-09-15 | Marshall | West Virginia | 54051 | 143 | 1 |
531236 | 531236 | 2020-09-14 | Marshall | Alabama | 1095 | 3741 | 42 |
531844 | 531844 | 2020-09-14 | Marshall | Illinois | 17123 | 74 | 0 |
531938 | 531938 | 2020-09-14 | Marshall | Indiana | 18099 | 965 | 23 |
532044 | 532044 | 2020-09-14 | Marshall | Iowa | 19127 | 1741 | 32 |
532138 | 532138 | 2020-09-14 | Marshall | Kansas | 20117 | 18 | 0 |
532261 | 532261 | 2020-09-14 | Marshall | Kentucky | 21157 | 237 | 2 |
532554 | 532554 | 2020-09-14 | Marshall | Minnesota | 27089 | 49 | 1 |
532645 | 532645 | 2020-09-14 | Marshall | Mississippi | 28093 | 1052 | 14 |
533372 | 533372 | 2020-09-14 | Marshall | Oklahoma | 40095 | 157 | 1 |
533681 | 533681 | 2020-09-14 | Marshall | South Dakota | 46091 | 27 | 0 |
533761 | 533761 | 2020-09-14 | Marshall | Tennessee | 47117 | 657 | 4 |
534297 | 534297 | 2020-09-14 | Marshall | West Virginia | 54051 | 140 | 1 |
527999 | 527999 | 2020-09-13 | Marshall | Alabama | 1095 | 3728 | 42 |
528607 | 528607 | 2020-09-13 | Marshall | Illinois | 17123 | 71 | 0 |
528701 | 528701 | 2020-09-13 | Marshall | Indiana | 18099 | 958 | 23 |
528807 | 528807 | 2020-09-13 | Marshall | Iowa | 19127 | 1741 | 32 |
528901 | 528901 | 2020-09-13 | Marshall | Kansas | 20117 | 17 | 0 |
529024 | 529024 | 2020-09-13 | Marshall | Kentucky | 21157 | 236 | 2 |
529318 | 529318 | 2020-09-13 | Marshall | Minnesota | 27089 | 49 | 1 |
529409 | 529409 | 2020-09-13 | Marshall | Mississippi | 28093 | 1053 | 14 |
530137 | 530137 | 2020-09-13 | Marshall | Oklahoma | 40095 | 147 | 1 |
530446 | 530446 | 2020-09-13 | Marshall | South Dakota | 46091 | 26 | 0 |
530526 | 530526 | 2020-09-13 | Marshall | Tennessee | 47117 | 639 | 4 |
531062 | 531062 | 2020-09-13 | Marshall | West Virginia | 54051 | 139 | 1 |
524763 | 524763 | 2020-09-12 | Marshall | Alabama | 1095 | 3718 | 42 |
525371 | 525371 | 2020-09-12 | Marshall | Illinois | 17123 | 67 | 0 |
525465 | 525465 | 2020-09-12 | Marshall | Indiana | 18099 | 951 | 23 |
525571 | 525571 | 2020-09-12 | Marshall | Iowa | 19127 | 1738 | 32 |
525665 | 525665 | 2020-09-12 | Marshall | Kansas | 20117 | 17 | 0 |
525788 | 525788 | 2020-09-12 | Marshall | Kentucky | 21157 | 235 | 2 |
526082 | 526082 | 2020-09-12 | Marshall | Minnesota | 27089 | 46 | 1 |
526173 | 526173 | 2020-09-12 | Marshall | Mississippi | 28093 | 1052 | 14 |
526900 | 526900 | 2020-09-12 | Marshall | Oklahoma | 40095 | 147 | 1 |
527209 | 527209 | 2020-09-12 | Marshall | South Dakota | 46091 | 24 | 0 |
527289 | 527289 | 2020-09-12 | Marshall | Tennessee | 47117 | 624 | 4 |
527825 | 527825 | 2020-09-12 | Marshall | West Virginia | 54051 | 138 | 1 |
521527 | 521527 | 2020-09-11 | Marshall | Alabama | 1095 | 3706 | 42 |
522135 | 522135 | 2020-09-11 | Marshall | Illinois | 17123 | 63 | 0 |
522229 | 522229 | 2020-09-11 | Marshall | Indiana | 18099 | 948 | 23 |
522335 | 522335 | 2020-09-11 | Marshall | Iowa | 19127 | 1737 | 32 |
522429 | 522429 | 2020-09-11 | Marshall | Kansas | 20117 | 17 | 0 |
522552 | 522552 | 2020-09-11 | Marshall | Kentucky | 21157 | 236 | 2 |
522846 | 522846 | 2020-09-11 | Marshall | Minnesota | 27089 | 46 | 1 |
522937 | 522937 | 2020-09-11 | Marshall | Mississippi | 28093 | 1050 | 14 |
523664 | 523664 | 2020-09-11 | Marshall | Oklahoma | 40095 | 144 | 1 |
523973 | 523973 | 2020-09-11 | Marshall | South Dakota | 46091 | 22 | 0 |
524053 | 524053 | 2020-09-11 | Marshall | Tennessee | 47117 | 623 | 4 |
524589 | 524589 | 2020-09-11 | Marshall | West Virginia | 54051 | 139 | 1 |
518290 | 518290 | 2020-09-10 | Marshall | Alabama | 1095 | 3694 | 42 |
518898 | 518898 | 2020-09-10 | Marshall | Illinois | 17123 | 63 | 0 |
518992 | 518992 | 2020-09-10 | Marshall | Indiana | 18099 | 942 | 23 |
519098 | 519098 | 2020-09-10 | Marshall | Iowa | 19127 | 1732 | 32 |
519192 | 519192 | 2020-09-10 | Marshall | Kansas | 20117 | 18 | 0 |
519315 | 519315 | 2020-09-10 | Marshall | Kentucky | 21157 | 225 | 2 |
519609 | 519609 | 2020-09-10 | Marshall | Minnesota | 27089 | 46 | 1 |
519700 | 519700 | 2020-09-10 | Marshall | Mississippi | 28093 | 1034 | 14 |
520428 | 520428 | 2020-09-10 | Marshall | Oklahoma | 40095 | 144 | 1 |
520737 | 520737 | 2020-09-10 | Marshall | South Dakota | 46091 | 22 | 0 |
520817 | 520817 | 2020-09-10 | Marshall | Tennessee | 47117 | 609 | 4 |
521353 | 521353 | 2020-09-10 | Marshall | West Virginia | 54051 | 138 | 1 |
515055 | 515055 | 2020-09-09 | Marshall | Alabama | 1095 | 3681 | 42 |
515663 | 515663 | 2020-09-09 | Marshall | Illinois | 17123 | 60 | 0 |
515757 | 515757 | 2020-09-09 | Marshall | Indiana | 18099 | 938 | 23 |
515863 | 515863 | 2020-09-09 | Marshall | Iowa | 19127 | 1725 | 32 |
515957 | 515957 | 2020-09-09 | Marshall | Kansas | 20117 | 18 | 0 |
516080 | 516080 | 2020-09-09 | Marshall | Kentucky | 21157 | 222 | 2 |
516374 | 516374 | 2020-09-09 | Marshall | Minnesota | 27089 | 44 | 1 |
516465 | 516465 | 2020-09-09 | Marshall | Mississippi | 28093 | 1028 | 14 |
517192 | 517192 | 2020-09-09 | Marshall | Oklahoma | 40095 | 143 | 1 |
517501 | 517501 | 2020-09-09 | Marshall | South Dakota | 46091 | 21 | 0 |
517581 | 517581 | 2020-09-09 | Marshall | Tennessee | 47117 | 601 | 4 |
518116 | 518116 | 2020-09-09 | Marshall | West Virginia | 54051 | 136 | 1 |
511822 | 511822 | 2020-09-08 | Marshall | Alabama | 1095 | 3678 | 42 |
512430 | 512430 | 2020-09-08 | Marshall | Illinois | 17123 | 59 | 0 |
512524 | 512524 | 2020-09-08 | Marshall | Indiana | 18099 | 934 | 23 |
512630 | 512630 | 2020-09-08 | Marshall | Iowa | 19127 | 1723 | 32 |
512724 | 512724 | 2020-09-08 | Marshall | Kansas | 20117 | 18 | 0 |
512847 | 512847 | 2020-09-08 | Marshall | Kentucky | 21157 | 220 | 2 |
513140 | 513140 | 2020-09-08 | Marshall | Minnesota | 27089 | 44 | 1 |
513231 | 513231 | 2020-09-08 | Marshall | Mississippi | 28093 | 1009 | 14 |
513957 | 513957 | 2020-09-08 | Marshall | Oklahoma | 40095 | 140 | 1 |
514266 | 514266 | 2020-09-08 | Marshall | South Dakota | 46091 | 20 | 0 |
514346 | 514346 | 2020-09-08 | Marshall | Tennessee | 47117 | 599 | 4 |
514881 | 514881 | 2020-09-08 | Marshall | West Virginia | 54051 | 134 | 1 |
508589 | 508589 | 2020-09-07 | Marshall | Alabama | 1095 | 3673 | 42 |
509197 | 509197 | 2020-09-07 | Marshall | Illinois | 17123 | 57 | 0 |
509291 | 509291 | 2020-09-07 | Marshall | Indiana | 18099 | 931 | 23 |
509397 | 509397 | 2020-09-07 | Marshall | Iowa | 19127 | 1719 | 32 |
509491 | 509491 | 2020-09-07 | Marshall | Kansas | 20117 | 18 | 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);