ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,534 rows where county = "Marshall" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Mississippi 311
- West Virginia 310
- Alabama 306
- Illinois 306
- Indiana 305
- Iowa 304
- Kentucky 301
- South Dakota 301
- Tennessee 301
- Oklahoma 293
- Minnesota 281
- Kansas 215
fips
county
- Marshall · 3,534 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
959510 | 959510 | 2021-01-24 | Marshall | Alabama | 1095 | 10471 | 123 |
960121 | 960121 | 2021-01-24 | Marshall | Illinois | 17123 | 705 | 15 |
960214 | 960214 | 2021-01-24 | Marshall | Indiana | 18099 | 5055 | 84 |
960320 | 960320 | 2021-01-24 | Marshall | Iowa | 19127 | 4311 | 62 |
960414 | 960414 | 2021-01-24 | Marshall | Kansas | 20117 | 972 | 22 |
960538 | 960538 | 2021-01-24 | Marshall | Kentucky | 21157 | 2121 | 32 |
960832 | 960832 | 2021-01-24 | Marshall | Minnesota | 27089 | 703 | 15 |
960923 | 960923 | 2021-01-24 | Marshall | Mississippi | 28093 | 3571 | 70 |
961654 | 961654 | 2021-01-24 | Marshall | Oklahoma | 40095 | 1612 | 11 |
961964 | 961964 | 2021-01-24 | Marshall | South Dakota | 46091 | 283 | 5 |
962044 | 962044 | 2021-01-24 | Marshall | Tennessee | 47117 | 3579 | 39 |
962582 | 962582 | 2021-01-24 | Marshall | West Virginia | 54051 | 2652 | 61 |
956264 | 956264 | 2021-01-23 | Marshall | Alabama | 1095 | 10420 | 123 |
956875 | 956875 | 2021-01-23 | Marshall | Illinois | 17123 | 703 | 15 |
956968 | 956968 | 2021-01-23 | Marshall | Indiana | 18099 | 5041 | 84 |
957074 | 957074 | 2021-01-23 | Marshall | Iowa | 19127 | 4307 | 62 |
957168 | 957168 | 2021-01-23 | Marshall | Kansas | 20117 | 972 | 22 |
957292 | 957292 | 2021-01-23 | Marshall | Kentucky | 21157 | 2104 | 32 |
957586 | 957586 | 2021-01-23 | Marshall | Minnesota | 27089 | 703 | 15 |
957677 | 957677 | 2021-01-23 | Marshall | Mississippi | 28093 | 3552 | 70 |
958409 | 958409 | 2021-01-23 | Marshall | Oklahoma | 40095 | 1607 | 10 |
958719 | 958719 | 2021-01-23 | Marshall | South Dakota | 46091 | 282 | 5 |
958799 | 958799 | 2021-01-23 | Marshall | Tennessee | 47117 | 3565 | 38 |
959337 | 959337 | 2021-01-23 | Marshall | West Virginia | 54051 | 2640 | 60 |
953019 | 953019 | 2021-01-22 | Marshall | Alabama | 1095 | 10357 | 123 |
953630 | 953630 | 2021-01-22 | Marshall | Illinois | 17123 | 693 | 15 |
953723 | 953723 | 2021-01-22 | Marshall | Indiana | 18099 | 5028 | 84 |
953829 | 953829 | 2021-01-22 | Marshall | Iowa | 19127 | 4298 | 62 |
953923 | 953923 | 2021-01-22 | Marshall | Kansas | 20117 | 972 | 22 |
954047 | 954047 | 2021-01-22 | Marshall | Kentucky | 21157 | 2069 | 32 |
954341 | 954341 | 2021-01-22 | Marshall | Minnesota | 27089 | 703 | 15 |
954432 | 954432 | 2021-01-22 | Marshall | Mississippi | 28093 | 3520 | 69 |
955163 | 955163 | 2021-01-22 | Marshall | Oklahoma | 40095 | 1583 | 10 |
955473 | 955473 | 2021-01-22 | Marshall | South Dakota | 46091 | 281 | 5 |
955553 | 955553 | 2021-01-22 | Marshall | Tennessee | 47117 | 3533 | 38 |
956091 | 956091 | 2021-01-22 | Marshall | West Virginia | 54051 | 2624 | 60 |
949774 | 949774 | 2021-01-21 | Marshall | Alabama | 1095 | 10322 | 119 |
950385 | 950385 | 2021-01-21 | Marshall | Illinois | 17123 | 682 | 14 |
950478 | 950478 | 2021-01-21 | Marshall | Indiana | 18099 | 5000 | 84 |
950584 | 950584 | 2021-01-21 | Marshall | Iowa | 19127 | 4292 | 62 |
950678 | 950678 | 2021-01-21 | Marshall | Kansas | 20117 | 972 | 22 |
950802 | 950802 | 2021-01-21 | Marshall | Kentucky | 21157 | 2039 | 32 |
951096 | 951096 | 2021-01-21 | Marshall | Minnesota | 27089 | 703 | 15 |
951187 | 951187 | 2021-01-21 | Marshall | Mississippi | 28093 | 3495 | 69 |
951918 | 951918 | 2021-01-21 | Marshall | Oklahoma | 40095 | 1565 | 10 |
952228 | 952228 | 2021-01-21 | Marshall | South Dakota | 46091 | 281 | 5 |
952308 | 952308 | 2021-01-21 | Marshall | Tennessee | 47117 | 3529 | 38 |
952846 | 952846 | 2021-01-21 | Marshall | West Virginia | 54051 | 2612 | 60 |
946528 | 946528 | 2021-01-20 | Marshall | Alabama | 1095 | 10290 | 113 |
947139 | 947139 | 2021-01-20 | Marshall | Illinois | 17123 | 677 | 14 |
947232 | 947232 | 2021-01-20 | Marshall | Indiana | 18099 | 4979 | 84 |
947338 | 947338 | 2021-01-20 | Marshall | Iowa | 19127 | 4286 | 62 |
947432 | 947432 | 2021-01-20 | Marshall | Kansas | 20117 | 969 | 22 |
947556 | 947556 | 2021-01-20 | Marshall | Kentucky | 21157 | 2006 | 30 |
947850 | 947850 | 2021-01-20 | Marshall | Minnesota | 27089 | 703 | 15 |
947941 | 947941 | 2021-01-20 | Marshall | Mississippi | 28093 | 3477 | 69 |
948673 | 948673 | 2021-01-20 | Marshall | Oklahoma | 40095 | 1537 | 9 |
948983 | 948983 | 2021-01-20 | Marshall | South Dakota | 46091 | 280 | 5 |
949063 | 949063 | 2021-01-20 | Marshall | Tennessee | 47117 | 3492 | 38 |
949601 | 949601 | 2021-01-20 | Marshall | West Virginia | 54051 | 2593 | 60 |
943281 | 943281 | 2021-01-19 | Marshall | Alabama | 1095 | 10236 | 107 |
943892 | 943892 | 2021-01-19 | Marshall | Illinois | 17123 | 670 | 13 |
943985 | 943985 | 2021-01-19 | Marshall | Indiana | 18099 | 4955 | 84 |
944091 | 944091 | 2021-01-19 | Marshall | Iowa | 19127 | 4277 | 61 |
944185 | 944185 | 2021-01-19 | Marshall | Kansas | 20117 | 969 | 22 |
944309 | 944309 | 2021-01-19 | Marshall | Kentucky | 21157 | 2000 | 27 |
944603 | 944603 | 2021-01-19 | Marshall | Minnesota | 27089 | 702 | 15 |
944694 | 944694 | 2021-01-19 | Marshall | Mississippi | 28093 | 3440 | 66 |
945427 | 945427 | 2021-01-19 | Marshall | Oklahoma | 40095 | 1532 | 9 |
945737 | 945737 | 2021-01-19 | Marshall | South Dakota | 46091 | 279 | 5 |
945817 | 945817 | 2021-01-19 | Marshall | Tennessee | 47117 | 3463 | 36 |
946355 | 946355 | 2021-01-19 | Marshall | West Virginia | 54051 | 2586 | 60 |
940036 | 940036 | 2021-01-18 | Marshall | Alabama | 1095 | 10199 | 107 |
940647 | 940647 | 2021-01-18 | Marshall | Illinois | 17123 | 664 | 13 |
940740 | 940740 | 2021-01-18 | Marshall | Indiana | 18099 | 4951 | 84 |
940846 | 940846 | 2021-01-18 | Marshall | Iowa | 19127 | 4265 | 61 |
940940 | 940940 | 2021-01-18 | Marshall | Kansas | 20117 | 944 | 22 |
941064 | 941064 | 2021-01-18 | Marshall | Kentucky | 21157 | 1987 | 27 |
941358 | 941358 | 2021-01-18 | Marshall | Minnesota | 27089 | 703 | 15 |
941449 | 941449 | 2021-01-18 | Marshall | Mississippi | 28093 | 3426 | 65 |
942180 | 942180 | 2021-01-18 | Marshall | Oklahoma | 40095 | 1529 | 8 |
942490 | 942490 | 2021-01-18 | Marshall | South Dakota | 46091 | 278 | 5 |
942570 | 942570 | 2021-01-18 | Marshall | Tennessee | 47117 | 3454 | 36 |
943108 | 943108 | 2021-01-18 | Marshall | West Virginia | 54051 | 2554 | 59 |
936791 | 936791 | 2021-01-17 | Marshall | Alabama | 1095 | 10191 | 107 |
937402 | 937402 | 2021-01-17 | Marshall | Illinois | 17123 | 662 | 13 |
937495 | 937495 | 2021-01-17 | Marshall | Indiana | 18099 | 4943 | 84 |
937601 | 937601 | 2021-01-17 | Marshall | Iowa | 19127 | 4257 | 61 |
937695 | 937695 | 2021-01-17 | Marshall | Kansas | 20117 | 944 | 22 |
937819 | 937819 | 2021-01-17 | Marshall | Kentucky | 21157 | 1958 | 25 |
938113 | 938113 | 2021-01-17 | Marshall | Minnesota | 27089 | 703 | 15 |
938204 | 938204 | 2021-01-17 | Marshall | Mississippi | 28093 | 3416 | 65 |
938935 | 938935 | 2021-01-17 | Marshall | Oklahoma | 40095 | 1522 | 8 |
939245 | 939245 | 2021-01-17 | Marshall | South Dakota | 46091 | 277 | 5 |
939325 | 939325 | 2021-01-17 | Marshall | Tennessee | 47117 | 3435 | 36 |
939863 | 939863 | 2021-01-17 | Marshall | West Virginia | 54051 | 2538 | 59 |
933546 | 933546 | 2021-01-16 | Marshall | Alabama | 1095 | 10158 | 107 |
934157 | 934157 | 2021-01-16 | Marshall | Illinois | 17123 | 657 | 13 |
934250 | 934250 | 2021-01-16 | Marshall | Indiana | 18099 | 4926 | 84 |
934356 | 934356 | 2021-01-16 | Marshall | Iowa | 19127 | 4255 | 61 |
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]);