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 383
- West Virginia 382
- Alabama 378
- Illinois 378
- Indiana 377
- Iowa 376
- Kentucky 373
- South Dakota 373
- Tennessee 373
- Oklahoma 365
- Minnesota 353
- Kansas 287
fips 12
county 1
- Marshall · 4,398 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193156 | 1193156 | 2021-04-06 | Marshall | Alabama | 1095 | 11903 | 218 |
1193767 | 1193767 | 2021-04-06 | Marshall | Illinois | 17123 | 942 | 19 |
1193861 | 1193861 | 2021-04-06 | Marshall | Indiana | 18099 | 5655 | 109 |
1193967 | 1193967 | 2021-04-06 | Marshall | Iowa | 19127 | 4754 | 74 |
1194061 | 1194061 | 2021-04-06 | Marshall | Kansas | 20117 | 1081 | 23 |
1194185 | 1194185 | 2021-04-06 | Marshall | Kentucky | 21157 | 2671 | 54 |
1194478 | 1194478 | 2021-04-06 | Marshall | Minnesota | 27089 | 828 | 17 |
1194569 | 1194569 | 2021-04-06 | Marshall | Mississippi | 28093 | 4250 | 100 |
1195302 | 1195302 | 2021-04-06 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1195612 | 1195612 | 2021-04-06 | Marshall | South Dakota | 46091 | 364 | 6 |
1195692 | 1195692 | 2021-04-06 | Marshall | Tennessee | 47117 | 4053 | 58 |
1196231 | 1196231 | 2021-04-06 | Marshall | West Virginia | 54051 | 3201 | 73 |
1189906 | 1189906 | 2021-04-05 | Marshall | Alabama | 1095 | 11890 | 218 |
1190517 | 1190517 | 2021-04-05 | Marshall | Illinois | 17123 | 936 | 19 |
1190611 | 1190611 | 2021-04-05 | Marshall | Indiana | 18099 | 5654 | 109 |
1190717 | 1190717 | 2021-04-05 | Marshall | Iowa | 19127 | 4751 | 74 |
1190811 | 1190811 | 2021-04-05 | Marshall | Kansas | 20117 | 1081 | 23 |
1190935 | 1190935 | 2021-04-05 | Marshall | Kentucky | 21157 | 2670 | 54 |
1191229 | 1191229 | 2021-04-05 | Marshall | Minnesota | 27089 | 827 | 17 |
1191320 | 1191320 | 2021-04-05 | Marshall | Mississippi | 28093 | 4248 | 100 |
1192054 | 1192054 | 2021-04-05 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1192364 | 1192364 | 2021-04-05 | Marshall | South Dakota | 46091 | 364 | 6 |
1192444 | 1192444 | 2021-04-05 | Marshall | Tennessee | 47117 | 4050 | 57 |
1192983 | 1192983 | 2021-04-05 | Marshall | West Virginia | 54051 | 3197 | 73 |
1186659 | 1186659 | 2021-04-04 | Marshall | Alabama | 1095 | 11888 | 218 |
1187270 | 1187270 | 2021-04-04 | Marshall | Illinois | 17123 | 935 | 19 |
1187364 | 1187364 | 2021-04-04 | Marshall | Indiana | 18099 | 5651 | 109 |
1187470 | 1187470 | 2021-04-04 | Marshall | Iowa | 19127 | 4745 | 74 |
1187564 | 1187564 | 2021-04-04 | Marshall | Kansas | 20117 | 1081 | 23 |
1187688 | 1187688 | 2021-04-04 | Marshall | Kentucky | 21157 | 2668 | 54 |
1187981 | 1187981 | 2021-04-04 | Marshall | Minnesota | 27089 | 827 | 17 |
1188072 | 1188072 | 2021-04-04 | Marshall | Mississippi | 28093 | 4247 | 100 |
1188805 | 1188805 | 2021-04-04 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1189115 | 1189115 | 2021-04-04 | Marshall | South Dakota | 46091 | 364 | 6 |
1189195 | 1189195 | 2021-04-04 | Marshall | Tennessee | 47117 | 4039 | 57 |
1189733 | 1189733 | 2021-04-04 | Marshall | West Virginia | 54051 | 3191 | 73 |
1183412 | 1183412 | 2021-04-03 | Marshall | Alabama | 1095 | 11885 | 218 |
1184023 | 1184023 | 2021-04-03 | Marshall | Illinois | 17123 | 932 | 19 |
1184117 | 1184117 | 2021-04-03 | Marshall | Indiana | 18099 | 5646 | 109 |
1184223 | 1184223 | 2021-04-03 | Marshall | Iowa | 19127 | 4744 | 74 |
1184317 | 1184317 | 2021-04-03 | Marshall | Kansas | 20117 | 1081 | 23 |
1184441 | 1184441 | 2021-04-03 | Marshall | Kentucky | 21157 | 2668 | 54 |
1184734 | 1184734 | 2021-04-03 | Marshall | Minnesota | 27089 | 827 | 17 |
1184825 | 1184825 | 2021-04-03 | Marshall | Mississippi | 28093 | 4246 | 100 |
1185558 | 1185558 | 2021-04-03 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1185868 | 1185868 | 2021-04-03 | Marshall | South Dakota | 46091 | 364 | 6 |
1185948 | 1185948 | 2021-04-03 | Marshall | Tennessee | 47117 | 4039 | 57 |
1186486 | 1186486 | 2021-04-03 | Marshall | West Virginia | 54051 | 3189 | 73 |
1180165 | 1180165 | 2021-04-02 | Marshall | Alabama | 1095 | 11877 | 217 |
1180776 | 1180776 | 2021-04-02 | Marshall | Illinois | 17123 | 927 | 19 |
1180870 | 1180870 | 2021-04-02 | Marshall | Indiana | 18099 | 5640 | 109 |
1180976 | 1180976 | 2021-04-02 | Marshall | Iowa | 19127 | 4742 | 74 |
1181070 | 1181070 | 2021-04-02 | Marshall | Kansas | 20117 | 1081 | 23 |
1181194 | 1181194 | 2021-04-02 | Marshall | Kentucky | 21157 | 2666 | 54 |
1181488 | 1181488 | 2021-04-02 | Marshall | Minnesota | 27089 | 827 | 17 |
1181579 | 1181579 | 2021-04-02 | Marshall | Mississippi | 28093 | 4246 | 99 |
1182311 | 1182311 | 2021-04-02 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1182621 | 1182621 | 2021-04-02 | Marshall | South Dakota | 46091 | 364 | 6 |
1182701 | 1182701 | 2021-04-02 | Marshall | Tennessee | 47117 | 4039 | 57 |
1183239 | 1183239 | 2021-04-02 | Marshall | West Virginia | 54051 | 3183 | 73 |
1176918 | 1176918 | 2021-04-01 | Marshall | Alabama | 1095 | 11865 | 217 |
1177529 | 1177529 | 2021-04-01 | Marshall | Illinois | 17123 | 925 | 19 |
1177623 | 1177623 | 2021-04-01 | Marshall | Indiana | 18099 | 5632 | 108 |
1177729 | 1177729 | 2021-04-01 | Marshall | Iowa | 19127 | 4741 | 74 |
1177823 | 1177823 | 2021-04-01 | Marshall | Kansas | 20117 | 1081 | 23 |
1177947 | 1177947 | 2021-04-01 | Marshall | Kentucky | 21157 | 2663 | 54 |
1178241 | 1178241 | 2021-04-01 | Marshall | Minnesota | 27089 | 826 | 17 |
1178332 | 1178332 | 2021-04-01 | Marshall | Mississippi | 28093 | 4234 | 99 |
1179064 | 1179064 | 2021-04-01 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1179374 | 1179374 | 2021-04-01 | Marshall | South Dakota | 46091 | 364 | 6 |
1179454 | 1179454 | 2021-04-01 | Marshall | Tennessee | 47117 | 4039 | 57 |
1179992 | 1179992 | 2021-04-01 | Marshall | West Virginia | 54051 | 3176 | 73 |
1173671 | 1173671 | 2021-03-31 | Marshall | Alabama | 1095 | 11854 | 217 |
1174282 | 1174282 | 2021-03-31 | Marshall | Illinois | 17123 | 919 | 19 |
1174376 | 1174376 | 2021-03-31 | Marshall | Indiana | 18099 | 5616 | 108 |
1174482 | 1174482 | 2021-03-31 | Marshall | Iowa | 19127 | 4738 | 74 |
1174576 | 1174576 | 2021-03-31 | Marshall | Kansas | 20117 | 1079 | 23 |
1174700 | 1174700 | 2021-03-31 | Marshall | Kentucky | 21157 | 2653 | 54 |
1174994 | 1174994 | 2021-03-31 | Marshall | Minnesota | 27089 | 825 | 16 |
1175085 | 1175085 | 2021-03-31 | Marshall | Mississippi | 28093 | 4228 | 99 |
1175817 | 1175817 | 2021-03-31 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1176127 | 1176127 | 2021-03-31 | Marshall | South Dakota | 46091 | 364 | 6 |
1176207 | 1176207 | 2021-03-31 | Marshall | Tennessee | 47117 | 4035 | 57 |
1176745 | 1176745 | 2021-03-31 | Marshall | West Virginia | 54051 | 3175 | 73 |
1170424 | 1170424 | 2021-03-30 | Marshall | Alabama | 1095 | 11851 | 217 |
1171035 | 1171035 | 2021-03-30 | Marshall | Illinois | 17123 | 918 | 19 |
1171129 | 1171129 | 2021-03-30 | Marshall | Indiana | 18099 | 5602 | 108 |
1171235 | 1171235 | 2021-03-30 | Marshall | Iowa | 19127 | 4736 | 74 |
1171329 | 1171329 | 2021-03-30 | Marshall | Kansas | 20117 | 1079 | 23 |
1171453 | 1171453 | 2021-03-30 | Marshall | Kentucky | 21157 | 2641 | 53 |
1171747 | 1171747 | 2021-03-30 | Marshall | Minnesota | 27089 | 823 | 16 |
1171838 | 1171838 | 2021-03-30 | Marshall | Mississippi | 28093 | 4225 | 99 |
1172570 | 1172570 | 2021-03-30 | Marshall | Oklahoma | 40095 | 1947 | 13 |
1172880 | 1172880 | 2021-03-30 | Marshall | South Dakota | 46091 | 364 | 6 |
1172960 | 1172960 | 2021-03-30 | Marshall | Tennessee | 47117 | 4026 | 57 |
1173498 | 1173498 | 2021-03-30 | Marshall | West Virginia | 54051 | 3171 | 72 |
1167176 | 1167176 | 2021-03-29 | Marshall | Alabama | 1095 | 11842 | 217 |
1167787 | 1167787 | 2021-03-29 | Marshall | Illinois | 17123 | 914 | 19 |
1167881 | 1167881 | 2021-03-29 | Marshall | Indiana | 18099 | 5599 | 108 |
1167987 | 1167987 | 2021-03-29 | Marshall | Iowa | 19127 | 4733 | 74 |
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);