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 299
- West Virginia 298
- Illinois 294
- Alabama 293
- Indiana 293
- Iowa 292
- Kentucky 289
- South Dakota 289
- Tennessee 289
- Oklahoma 281
- Minnesota 269
- Kansas 203
fips 12
county 1
- Marshall · 3,389 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921096 | 921096 | 2021-01-12 | Marshall | Illinois | 17123 | 633 | 13 |
921189 | 921189 | 2021-01-12 | Marshall | Indiana | 18099 | 4819 | 84 |
921295 | 921295 | 2021-01-12 | Marshall | Iowa | 19127 | 4219 | 60 |
921389 | 921389 | 2021-01-12 | Marshall | Kansas | 20117 | 930 | 22 |
921513 | 921513 | 2021-01-12 | Marshall | Kentucky | 21157 | 1857 | 25 |
921807 | 921807 | 2021-01-12 | Marshall | Minnesota | 27089 | 696 | 15 |
921898 | 921898 | 2021-01-12 | Marshall | Mississippi | 28093 | 3291 | 64 |
922629 | 922629 | 2021-01-12 | Marshall | Oklahoma | 40095 | 1405 | 7 |
922939 | 922939 | 2021-01-12 | Marshall | South Dakota | 46091 | 270 | 5 |
923019 | 923019 | 2021-01-12 | Marshall | Tennessee | 47117 | 3243 | 34 |
923557 | 923557 | 2021-01-12 | Marshall | West Virginia | 54051 | 2433 | 57 |
917240 | 917240 | 2021-01-11 | Marshall | Alabama | 1095 | 9863 | 92 |
917851 | 917851 | 2021-01-11 | Marshall | Illinois | 17123 | 631 | 13 |
917944 | 917944 | 2021-01-11 | Marshall | Indiana | 18099 | 4806 | 84 |
918050 | 918050 | 2021-01-11 | Marshall | Iowa | 19127 | 4204 | 59 |
918144 | 918144 | 2021-01-11 | Marshall | Kansas | 20117 | 910 | 22 |
918268 | 918268 | 2021-01-11 | Marshall | Kentucky | 21157 | 1845 | 25 |
918562 | 918562 | 2021-01-11 | Marshall | Minnesota | 27089 | 696 | 15 |
918653 | 918653 | 2021-01-11 | Marshall | Mississippi | 28093 | 3264 | 63 |
919384 | 919384 | 2021-01-11 | Marshall | Oklahoma | 40095 | 1396 | 7 |
919694 | 919694 | 2021-01-11 | Marshall | South Dakota | 46091 | 270 | 5 |
919774 | 919774 | 2021-01-11 | Marshall | Tennessee | 47117 | 3223 | 34 |
920312 | 920312 | 2021-01-11 | Marshall | West Virginia | 54051 | 2421 | 57 |
913995 | 913995 | 2021-01-10 | Marshall | Alabama | 1095 | 9854 | 92 |
914606 | 914606 | 2021-01-10 | Marshall | Illinois | 17123 | 626 | 13 |
914699 | 914699 | 2021-01-10 | Marshall | Indiana | 18099 | 4791 | 84 |
914805 | 914805 | 2021-01-10 | Marshall | Iowa | 19127 | 4192 | 59 |
914899 | 914899 | 2021-01-10 | Marshall | Kansas | 20117 | 910 | 22 |
915023 | 915023 | 2021-01-10 | Marshall | Kentucky | 21157 | 1829 | 25 |
915317 | 915317 | 2021-01-10 | Marshall | Minnesota | 27089 | 695 | 15 |
915408 | 915408 | 2021-01-10 | Marshall | Mississippi | 28093 | 3241 | 63 |
916139 | 916139 | 2021-01-10 | Marshall | Oklahoma | 40095 | 1366 | 7 |
916449 | 916449 | 2021-01-10 | Marshall | South Dakota | 46091 | 269 | 5 |
916529 | 916529 | 2021-01-10 | Marshall | Tennessee | 47117 | 3209 | 33 |
917067 | 917067 | 2021-01-10 | Marshall | West Virginia | 54051 | 2391 | 57 |
910750 | 910750 | 2021-01-09 | Marshall | Alabama | 1095 | 9819 | 92 |
911361 | 911361 | 2021-01-09 | Marshall | Illinois | 17123 | 623 | 13 |
911454 | 911454 | 2021-01-09 | Marshall | Indiana | 18099 | 4750 | 84 |
911560 | 911560 | 2021-01-09 | Marshall | Iowa | 19127 | 4185 | 59 |
911654 | 911654 | 2021-01-09 | Marshall | Kansas | 20117 | 910 | 22 |
911778 | 911778 | 2021-01-09 | Marshall | Kentucky | 21157 | 1822 | 25 |
912072 | 912072 | 2021-01-09 | Marshall | Minnesota | 27089 | 695 | 15 |
912163 | 912163 | 2021-01-09 | Marshall | Mississippi | 28093 | 3211 | 63 |
912894 | 912894 | 2021-01-09 | Marshall | Oklahoma | 40095 | 1331 | 7 |
913204 | 913204 | 2021-01-09 | Marshall | South Dakota | 46091 | 267 | 5 |
913284 | 913284 | 2021-01-09 | Marshall | Tennessee | 47117 | 3174 | 33 |
913822 | 913822 | 2021-01-09 | Marshall | West Virginia | 54051 | 2347 | 57 |
907505 | 907505 | 2021-01-08 | Marshall | Alabama | 1095 | 9710 | 92 |
908116 | 908116 | 2021-01-08 | Marshall | Illinois | 17123 | 619 | 13 |
908209 | 908209 | 2021-01-08 | Marshall | Indiana | 18099 | 4722 | 84 |
908315 | 908315 | 2021-01-08 | Marshall | Iowa | 19127 | 4180 | 59 |
908409 | 908409 | 2021-01-08 | Marshall | Kansas | 20117 | 882 | 21 |
908533 | 908533 | 2021-01-08 | Marshall | Kentucky | 21157 | 1809 | 25 |
908827 | 908827 | 2021-01-08 | Marshall | Minnesota | 27089 | 692 | 15 |
908918 | 908918 | 2021-01-08 | Marshall | Mississippi | 28093 | 3144 | 63 |
909649 | 909649 | 2021-01-08 | Marshall | Oklahoma | 40095 | 1290 | 6 |
909959 | 909959 | 2021-01-08 | Marshall | South Dakota | 46091 | 266 | 4 |
910039 | 910039 | 2021-01-08 | Marshall | Tennessee | 47117 | 3138 | 33 |
910577 | 910577 | 2021-01-08 | Marshall | West Virginia | 54051 | 2318 | 56 |
904259 | 904259 | 2021-01-07 | Marshall | Alabama | 1095 | 9616 | 92 |
904870 | 904870 | 2021-01-07 | Marshall | Illinois | 17123 | 610 | 12 |
904963 | 904963 | 2021-01-07 | Marshall | Indiana | 18099 | 4701 | 83 |
905069 | 905069 | 2021-01-07 | Marshall | Iowa | 19127 | 4167 | 58 |
905163 | 905163 | 2021-01-07 | Marshall | Kansas | 20117 | 882 | 21 |
905287 | 905287 | 2021-01-07 | Marshall | Kentucky | 21157 | 1765 | 22 |
905581 | 905581 | 2021-01-07 | Marshall | Minnesota | 27089 | 689 | 15 |
905672 | 905672 | 2021-01-07 | Marshall | Mississippi | 28093 | 3107 | 63 |
906404 | 906404 | 2021-01-07 | Marshall | Oklahoma | 40095 | 1256 | 6 |
906714 | 906714 | 2021-01-07 | Marshall | South Dakota | 46091 | 264 | 4 |
906794 | 906794 | 2021-01-07 | Marshall | Tennessee | 47117 | 3111 | 31 |
907332 | 907332 | 2021-01-07 | Marshall | West Virginia | 54051 | 2290 | 55 |
901014 | 901014 | 2021-01-06 | Marshall | Alabama | 1095 | 9497 | 91 |
901625 | 901625 | 2021-01-06 | Marshall | Illinois | 17123 | 608 | 11 |
901718 | 901718 | 2021-01-06 | Marshall | Indiana | 18099 | 4651 | 82 |
901824 | 901824 | 2021-01-06 | Marshall | Iowa | 19127 | 4151 | 58 |
901918 | 901918 | 2021-01-06 | Marshall | Kansas | 20117 | 882 | 21 |
902042 | 902042 | 2021-01-06 | Marshall | Kentucky | 21157 | 1715 | 22 |
902336 | 902336 | 2021-01-06 | Marshall | Minnesota | 27089 | 687 | 15 |
902427 | 902427 | 2021-01-06 | Marshall | Mississippi | 28093 | 3068 | 63 |
903158 | 903158 | 2021-01-06 | Marshall | Oklahoma | 40095 | 1242 | 6 |
903468 | 903468 | 2021-01-06 | Marshall | South Dakota | 46091 | 263 | 4 |
903548 | 903548 | 2021-01-06 | Marshall | Tennessee | 47117 | 3034 | 30 |
904086 | 904086 | 2021-01-06 | Marshall | West Virginia | 54051 | 2273 | 54 |
897769 | 897769 | 2021-01-05 | Marshall | Alabama | 1095 | 9401 | 86 |
898380 | 898380 | 2021-01-05 | Marshall | Illinois | 17123 | 602 | 11 |
898473 | 898473 | 2021-01-05 | Marshall | Indiana | 18099 | 4631 | 81 |
898579 | 898579 | 2021-01-05 | Marshall | Iowa | 19127 | 4132 | 57 |
898673 | 898673 | 2021-01-05 | Marshall | Kansas | 20117 | 882 | 21 |
898797 | 898797 | 2021-01-05 | Marshall | Kentucky | 21157 | 1664 | 22 |
899091 | 899091 | 2021-01-05 | Marshall | Minnesota | 27089 | 683 | 13 |
899182 | 899182 | 2021-01-05 | Marshall | Mississippi | 28093 | 3027 | 63 |
899913 | 899913 | 2021-01-05 | Marshall | Oklahoma | 40095 | 1214 | 6 |
900223 | 900223 | 2021-01-05 | Marshall | South Dakota | 46091 | 262 | 4 |
900303 | 900303 | 2021-01-05 | Marshall | Tennessee | 47117 | 3012 | 30 |
900841 | 900841 | 2021-01-05 | Marshall | West Virginia | 54051 | 2245 | 54 |
894523 | 894523 | 2021-01-04 | Marshall | Alabama | 1095 | 9340 | 86 |
895135 | 895135 | 2021-01-04 | Marshall | Illinois | 17123 | 598 | 11 |
895228 | 895228 | 2021-01-04 | Marshall | Indiana | 18099 | 4623 | 81 |
895334 | 895334 | 2021-01-04 | Marshall | Iowa | 19127 | 4079 | 57 |
895428 | 895428 | 2021-01-04 | Marshall | Kansas | 20117 | 882 | 21 |
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);