ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,534 rows where county = "Marshall" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);