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,990 rows where county = "Marshall" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

  • Marshall · 3,990 ✖
Link rowid date ▲ county state fips cases deaths
1082763 1082763 2021-03-03 Marshall Alabama 1095 11439 210
1083374 1083374 2021-03-03 Marshall Illinois 17123 841 17
1083468 1083468 2021-03-03 Marshall Indiana 18099 5435 106
1083574 1083574 2021-03-03 Marshall Iowa 19127 4569 72
1083668 1083668 2021-03-03 Marshall Kansas 20117 1074 23
1083792 1083792 2021-03-03 Marshall Kentucky 21157 2548 48
1084086 1084086 2021-03-03 Marshall Minnesota 27089 780 15
1084177 1084177 2021-03-03 Marshall Mississippi 28093 4035 92
1084908 1084908 2021-03-03 Marshall Oklahoma 40095 1865 12
1085218 1085218 2021-03-03 Marshall South Dakota 46091 323 5
1085298 1085298 2021-03-03 Marshall Tennessee 47117 3912 56
1085836 1085836 2021-03-03 Marshall West Virginia 54051 3016 66
1079517 1079517 2021-03-02 Marshall Alabama 1095 11269 209
1080128 1080128 2021-03-02 Marshall Illinois 17123 841 17
1080222 1080222 2021-03-02 Marshall Indiana 18099 5430 105
1080328 1080328 2021-03-02 Marshall Iowa 19127 4569 72
1080422 1080422 2021-03-02 Marshall Kansas 20117 1074 23
1080546 1080546 2021-03-02 Marshall Kentucky 21157 2542 48
1080840 1080840 2021-03-02 Marshall Minnesota 27089 778 15
1080931 1080931 2021-03-02 Marshall Mississippi 28093 4033 92
1081662 1081662 2021-03-02 Marshall Oklahoma 40095 1862 12
1081972 1081972 2021-03-02 Marshall South Dakota 46091 321 5
1082052 1082052 2021-03-02 Marshall Tennessee 47117 3911 56
1082590 1082590 2021-03-02 Marshall West Virginia 54051 3016 66
1076272 1076272 2021-03-01 Marshall Alabama 1095 11262 209
1076883 1076883 2021-03-01 Marshall Illinois 17123 839 17
1076977 1076977 2021-03-01 Marshall Indiana 18099 5428 105
1077083 1077083 2021-03-01 Marshall Iowa 19127 4569 72
1077177 1077177 2021-03-01 Marshall Kansas 20117 1074 23
1077301 1077301 2021-03-01 Marshall Kentucky 21157 2526 48
1077594 1077594 2021-03-01 Marshall Minnesota 27089 778 15
1077685 1077685 2021-03-01 Marshall Mississippi 28093 4031 92
1078416 1078416 2021-03-01 Marshall Oklahoma 40095 1862 12
1078726 1078726 2021-03-01 Marshall South Dakota 46091 319 5
1078806 1078806 2021-03-01 Marshall Tennessee 47117 3907 56
1079344 1079344 2021-03-01 Marshall West Virginia 54051 3013 66
1073026 1073026 2021-02-28 Marshall Alabama 1095 11261 209
1073637 1073637 2021-02-28 Marshall Illinois 17123 838 17
1073731 1073731 2021-02-28 Marshall Indiana 18099 5426 105
1073837 1073837 2021-02-28 Marshall Iowa 19127 4569 72
1073931 1073931 2021-02-28 Marshall Kansas 20117 1072 23
1074055 1074055 2021-02-28 Marshall Kentucky 21157 2519 48
1074348 1074348 2021-02-28 Marshall Minnesota 27089 778 15
1074439 1074439 2021-02-28 Marshall Mississippi 28093 4031 92
1075171 1075171 2021-02-28 Marshall Oklahoma 40095 1862 12
1075481 1075481 2021-02-28 Marshall South Dakota 46091 318 5
1075561 1075561 2021-02-28 Marshall Tennessee 47117 3907 56
1076099 1076099 2021-02-28 Marshall West Virginia 54051 3008 66
1069780 1069780 2021-02-27 Marshall Alabama 1095 11250 209
1070391 1070391 2021-02-27 Marshall Illinois 17123 838 17
1070485 1070485 2021-02-27 Marshall Indiana 18099 5420 105
1070591 1070591 2021-02-27 Marshall Iowa 19127 4569 72
1070685 1070685 2021-02-27 Marshall Kansas 20117 1072 23
1070809 1070809 2021-02-27 Marshall Kentucky 21157 2517 48
1071102 1071102 2021-02-27 Marshall Minnesota 27089 776 15
1071193 1071193 2021-02-27 Marshall Mississippi 28093 4018 92
1071925 1071925 2021-02-27 Marshall Oklahoma 40095 1861 12
1072235 1072235 2021-02-27 Marshall South Dakota 46091 318 5
1072315 1072315 2021-02-27 Marshall Tennessee 47117 3903 56
1072853 1072853 2021-02-27 Marshall West Virginia 54051 3003 66
1066535 1066535 2021-02-26 Marshall Alabama 1095 11243 208
1067146 1067146 2021-02-26 Marshall Illinois 17123 836 16
1067240 1067240 2021-02-26 Marshall Indiana 18099 5417 105
1067346 1067346 2021-02-26 Marshall Iowa 19127 4569 72
1067440 1067440 2021-02-26 Marshall Kansas 20117 1072 23
1067564 1067564 2021-02-26 Marshall Kentucky 21157 2513 48
1067857 1067857 2021-02-26 Marshall Minnesota 27089 774 15
1067948 1067948 2021-02-26 Marshall Mississippi 28093 4003 92
1068679 1068679 2021-02-26 Marshall Oklahoma 40095 1859 12
1068989 1068989 2021-02-26 Marshall South Dakota 46091 314 5
1069069 1069069 2021-02-26 Marshall Tennessee 47117 3899 55
1069607 1069607 2021-02-26 Marshall West Virginia 54051 2997 66
1063290 1063290 2021-02-25 Marshall Alabama 1095 11226 206
1063901 1063901 2021-02-25 Marshall Illinois 17123 834 16
1063995 1063995 2021-02-25 Marshall Indiana 18099 5409 105
1064101 1064101 2021-02-25 Marshall Iowa 19127 4569 72
1064195 1064195 2021-02-25 Marshall Kansas 20117 1072 23
1064319 1064319 2021-02-25 Marshall Kentucky 21157 2510 48
1064612 1064612 2021-02-25 Marshall Minnesota 27089 770 15
1064703 1064703 2021-02-25 Marshall Mississippi 28093 3994 92
1065434 1065434 2021-02-25 Marshall Oklahoma 40095 1858 12
1065744 1065744 2021-02-25 Marshall South Dakota 46091 310 5
1065824 1065824 2021-02-25 Marshall Tennessee 47117 3892 54
1066362 1066362 2021-02-25 Marshall West Virginia 54051 2995 66
1060045 1060045 2021-02-24 Marshall Alabama 1095 11212 203
1060656 1060656 2021-02-24 Marshall Illinois 17123 832 16
1060750 1060750 2021-02-24 Marshall Indiana 18099 5400 105
1060856 1060856 2021-02-24 Marshall Iowa 19127 4569 72
1060950 1060950 2021-02-24 Marshall Kansas 20117 1068 23
1061074 1061074 2021-02-24 Marshall Kentucky 21157 2497 47
1061368 1061368 2021-02-24 Marshall Minnesota 27089 768 15
1061459 1061459 2021-02-24 Marshall Mississippi 28093 3983 92
1062190 1062190 2021-02-24 Marshall Oklahoma 40095 1856 12
1062499 1062499 2021-02-24 Marshall South Dakota 46091 307 5
1062579 1062579 2021-02-24 Marshall Tennessee 47117 3883 54
1063117 1063117 2021-02-24 Marshall West Virginia 54051 2989 66
1056799 1056799 2021-02-23 Marshall Alabama 1095 11197 202
1057410 1057410 2021-02-23 Marshall Illinois 17123 831 16
1057504 1057504 2021-02-23 Marshall Indiana 18099 5393 105
1057610 1057610 2021-02-23 Marshall Iowa 19127 4569 72

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);