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 324
- West Virginia 323
- Alabama 319
- Illinois 319
- Indiana 318
- Iowa 317
- Kentucky 314
- South Dakota 314
- Tennessee 314
- Oklahoma 306
- Minnesota 294
- Kansas 228
fips 12
county 1
- Marshall · 3,690 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1001623 | 1001623 | 2021-02-06 | Marshall | Alabama | 1095 | 10959 | 178 |
1002234 | 1002234 | 2021-02-06 | Marshall | Illinois | 17123 | 795 | 16 |
1002328 | 1002328 | 2021-02-06 | Marshall | Indiana | 18099 | 5270 | 97 |
1002434 | 1002434 | 2021-02-06 | Marshall | Iowa | 19127 | 4470 | 68 |
1002528 | 1002528 | 2021-02-06 | Marshall | Kansas | 20117 | 1036 | 22 |
1002652 | 1002652 | 2021-02-06 | Marshall | Kentucky | 21157 | 2350 | 40 |
1002945 | 1002945 | 2021-02-06 | Marshall | Minnesota | 27089 | 715 | 15 |
1003036 | 1003036 | 2021-02-06 | Marshall | Mississippi | 28093 | 3788 | 87 |
1003768 | 1003768 | 2021-02-06 | Marshall | Oklahoma | 40095 | 1758 | 12 |
1004078 | 1004078 | 2021-02-06 | Marshall | South Dakota | 46091 | 289 | 5 |
1004158 | 1004158 | 2021-02-06 | Marshall | Tennessee | 47117 | 3765 | 50 |
1004696 | 1004696 | 2021-02-06 | Marshall | West Virginia | 54051 | 2890 | 64 |
998377 | 998377 | 2021-02-05 | Marshall | Alabama | 1095 | 10928 | 177 |
998988 | 998988 | 2021-02-05 | Marshall | Illinois | 17123 | 793 | 16 |
999082 | 999082 | 2021-02-05 | Marshall | Indiana | 18099 | 5251 | 97 |
999188 | 999188 | 2021-02-05 | Marshall | Iowa | 19127 | 4460 | 68 |
999282 | 999282 | 2021-02-05 | Marshall | Kansas | 20117 | 1036 | 22 |
999406 | 999406 | 2021-02-05 | Marshall | Kentucky | 21157 | 2338 | 38 |
999700 | 999700 | 2021-02-05 | Marshall | Minnesota | 27089 | 711 | 15 |
999791 | 999791 | 2021-02-05 | Marshall | Mississippi | 28093 | 3781 | 87 |
1000522 | 1000522 | 2021-02-05 | Marshall | Oklahoma | 40095 | 1748 | 12 |
1000832 | 1000832 | 2021-02-05 | Marshall | South Dakota | 46091 | 289 | 5 |
1000912 | 1000912 | 2021-02-05 | Marshall | Tennessee | 47117 | 3734 | 50 |
1001450 | 1001450 | 2021-02-05 | Marshall | West Virginia | 54051 | 2874 | 63 |
995131 | 995131 | 2021-02-04 | Marshall | Alabama | 1095 | 10905 | 176 |
995742 | 995742 | 2021-02-04 | Marshall | Illinois | 17123 | 765 | 15 |
995836 | 995836 | 2021-02-04 | Marshall | Indiana | 18099 | 5228 | 97 |
995942 | 995942 | 2021-02-04 | Marshall | Iowa | 19127 | 4451 | 68 |
996036 | 996036 | 2021-02-04 | Marshall | Kansas | 20117 | 1036 | 22 |
996160 | 996160 | 2021-02-04 | Marshall | Kentucky | 21157 | 2323 | 37 |
996454 | 996454 | 2021-02-04 | Marshall | Minnesota | 27089 | 709 | 15 |
996545 | 996545 | 2021-02-04 | Marshall | Mississippi | 28093 | 3760 | 83 |
997276 | 997276 | 2021-02-04 | Marshall | Oklahoma | 40095 | 1723 | 12 |
997586 | 997586 | 2021-02-04 | Marshall | South Dakota | 46091 | 289 | 5 |
997666 | 997666 | 2021-02-04 | Marshall | Tennessee | 47117 | 3710 | 46 |
998204 | 998204 | 2021-02-04 | Marshall | West Virginia | 54051 | 2864 | 63 |
991885 | 991885 | 2021-02-03 | Marshall | Alabama | 1095 | 10860 | 172 |
992496 | 992496 | 2021-02-03 | Marshall | Illinois | 17123 | 756 | 15 |
992590 | 992590 | 2021-02-03 | Marshall | Indiana | 18099 | 5211 | 84 |
992696 | 992696 | 2021-02-03 | Marshall | Iowa | 19127 | 4436 | 68 |
992790 | 992790 | 2021-02-03 | Marshall | Kansas | 20117 | 1023 | 22 |
992914 | 992914 | 2021-02-03 | Marshall | Kentucky | 21157 | 2293 | 37 |
993208 | 993208 | 2021-02-03 | Marshall | Minnesota | 27089 | 708 | 15 |
993299 | 993299 | 2021-02-03 | Marshall | Mississippi | 28093 | 3738 | 81 |
994030 | 994030 | 2021-02-03 | Marshall | Oklahoma | 40095 | 1712 | 12 |
994340 | 994340 | 2021-02-03 | Marshall | South Dakota | 46091 | 289 | 5 |
994420 | 994420 | 2021-02-03 | Marshall | Tennessee | 47117 | 3701 | 46 |
994958 | 994958 | 2021-02-03 | Marshall | West Virginia | 54051 | 2855 | 63 |
988639 | 988639 | 2021-02-02 | Marshall | Alabama | 1095 | 10827 | 160 |
989250 | 989250 | 2021-02-02 | Marshall | Illinois | 17123 | 752 | 15 |
989344 | 989344 | 2021-02-02 | Marshall | Indiana | 18099 | 5195 | 84 |
989450 | 989450 | 2021-02-02 | Marshall | Iowa | 19127 | 4424 | 68 |
989544 | 989544 | 2021-02-02 | Marshall | Kansas | 20117 | 1020 | 22 |
989668 | 989668 | 2021-02-02 | Marshall | Kentucky | 21157 | 2257 | 35 |
989962 | 989962 | 2021-02-02 | Marshall | Minnesota | 27089 | 709 | 15 |
990053 | 990053 | 2021-02-02 | Marshall | Mississippi | 28093 | 3728 | 81 |
990784 | 990784 | 2021-02-02 | Marshall | Oklahoma | 40095 | 1704 | 12 |
991094 | 991094 | 2021-02-02 | Marshall | South Dakota | 46091 | 287 | 5 |
991174 | 991174 | 2021-02-02 | Marshall | Tennessee | 47117 | 3692 | 46 |
991712 | 991712 | 2021-02-02 | Marshall | West Virginia | 54051 | 2838 | 63 |
985392 | 985392 | 2021-02-01 | Marshall | Alabama | 1095 | 10789 | 152 |
986003 | 986003 | 2021-02-01 | Marshall | Illinois | 17123 | 753 | 15 |
986097 | 986097 | 2021-02-01 | Marshall | Indiana | 18099 | 5187 | 84 |
986203 | 986203 | 2021-02-01 | Marshall | Iowa | 19127 | 4397 | 68 |
986297 | 986297 | 2021-02-01 | Marshall | Kansas | 20117 | 1020 | 22 |
986421 | 986421 | 2021-02-01 | Marshall | Kentucky | 21157 | 2251 | 35 |
986715 | 986715 | 2021-02-01 | Marshall | Minnesota | 27089 | 709 | 15 |
986806 | 986806 | 2021-02-01 | Marshall | Mississippi | 28093 | 3720 | 78 |
987538 | 987538 | 2021-02-01 | Marshall | Oklahoma | 40095 | 1696 | 12 |
987848 | 987848 | 2021-02-01 | Marshall | South Dakota | 46091 | 287 | 5 |
987928 | 987928 | 2021-02-01 | Marshall | Tennessee | 47117 | 3683 | 46 |
988466 | 988466 | 2021-02-01 | Marshall | West Virginia | 54051 | 2823 | 63 |
982145 | 982145 | 2021-01-31 | Marshall | Alabama | 1095 | 10780 | 152 |
982756 | 982756 | 2021-01-31 | Marshall | Illinois | 17123 | 748 | 15 |
982850 | 982850 | 2021-01-31 | Marshall | Indiana | 18099 | 5172 | 84 |
982956 | 982956 | 2021-01-31 | Marshall | Iowa | 19127 | 4385 | 68 |
983050 | 983050 | 2021-01-31 | Marshall | Kansas | 20117 | 999 | 22 |
983174 | 983174 | 2021-01-31 | Marshall | Kentucky | 21157 | 2244 | 35 |
983468 | 983468 | 2021-01-31 | Marshall | Minnesota | 27089 | 708 | 15 |
983559 | 983559 | 2021-01-31 | Marshall | Mississippi | 28093 | 3710 | 77 |
984291 | 984291 | 2021-01-31 | Marshall | Oklahoma | 40095 | 1687 | 12 |
984601 | 984601 | 2021-01-31 | Marshall | South Dakota | 46091 | 287 | 5 |
984681 | 984681 | 2021-01-31 | Marshall | Tennessee | 47117 | 3683 | 45 |
985219 | 985219 | 2021-01-31 | Marshall | West Virginia | 54051 | 2816 | 63 |
978899 | 978899 | 2021-01-30 | Marshall | Alabama | 1095 | 10714 | 144 |
979510 | 979510 | 2021-01-30 | Marshall | Illinois | 17123 | 745 | 15 |
979604 | 979604 | 2021-01-30 | Marshall | Indiana | 18099 | 5165 | 84 |
979710 | 979710 | 2021-01-30 | Marshall | Iowa | 19127 | 4381 | 65 |
979804 | 979804 | 2021-01-30 | Marshall | Kansas | 20117 | 999 | 22 |
979928 | 979928 | 2021-01-30 | Marshall | Kentucky | 21157 | 2229 | 35 |
980222 | 980222 | 2021-01-30 | Marshall | Minnesota | 27089 | 708 | 15 |
980313 | 980313 | 2021-01-30 | Marshall | Mississippi | 28093 | 3682 | 76 |
981044 | 981044 | 2021-01-30 | Marshall | Oklahoma | 40095 | 1673 | 12 |
981354 | 981354 | 2021-01-30 | Marshall | South Dakota | 46091 | 286 | 5 |
981434 | 981434 | 2021-01-30 | Marshall | Tennessee | 47117 | 3667 | 45 |
981972 | 981972 | 2021-01-30 | Marshall | West Virginia | 54051 | 2796 | 63 |
975654 | 975654 | 2021-01-29 | Marshall | Alabama | 1095 | 10714 | 144 |
976265 | 976265 | 2021-01-29 | Marshall | Illinois | 17123 | 738 | 15 |
976358 | 976358 | 2021-01-29 | Marshall | Indiana | 18099 | 5138 | 84 |
976464 | 976464 | 2021-01-29 | Marshall | Iowa | 19127 | 4363 | 64 |
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);