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 303
- West Virginia 302
- Alabama 297
- Illinois 297
- Indiana 296
- Iowa 295
- Kentucky 293
- South Dakota 293
- Tennessee 293
- Oklahoma 285
- Minnesota 273
- Kansas 207
fips 12
county 1
- Marshall · 3,434 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934370 | 934370 | 2021-01-16 | Marshall | Kansas | 20117 | 944 | 22 |
934494 | 934494 | 2021-01-16 | Marshall | Kentucky | 21157 | 1947 | 25 |
934788 | 934788 | 2021-01-16 | Marshall | Minnesota | 27089 | 701 | 15 |
934879 | 934879 | 2021-01-16 | Marshall | Mississippi | 28093 | 3391 | 65 |
935610 | 935610 | 2021-01-16 | Marshall | Oklahoma | 40095 | 1494 | 8 |
935920 | 935920 | 2021-01-16 | Marshall | South Dakota | 46091 | 275 | 5 |
936000 | 936000 | 2021-01-16 | Marshall | Tennessee | 47117 | 3403 | 36 |
936538 | 936538 | 2021-01-16 | Marshall | West Virginia | 54051 | 2534 | 57 |
930221 | 930221 | 2021-01-15 | Marshall | Alabama | 1095 | 10108 | 107 |
930832 | 930832 | 2021-01-15 | Marshall | Illinois | 17123 | 652 | 13 |
930925 | 930925 | 2021-01-15 | Marshall | Indiana | 18099 | 4907 | 84 |
931031 | 931031 | 2021-01-15 | Marshall | Iowa | 19127 | 4251 | 61 |
931125 | 931125 | 2021-01-15 | Marshall | Kansas | 20117 | 944 | 22 |
931249 | 931249 | 2021-01-15 | Marshall | Kentucky | 21157 | 1926 | 25 |
931543 | 931543 | 2021-01-15 | Marshall | Minnesota | 27089 | 701 | 15 |
931634 | 931634 | 2021-01-15 | Marshall | Mississippi | 28093 | 3360 | 65 |
932365 | 932365 | 2021-01-15 | Marshall | Oklahoma | 40095 | 1480 | 8 |
932675 | 932675 | 2021-01-15 | Marshall | South Dakota | 46091 | 275 | 5 |
932755 | 932755 | 2021-01-15 | Marshall | Tennessee | 47117 | 3358 | 36 |
933293 | 933293 | 2021-01-15 | Marshall | West Virginia | 54051 | 2492 | 57 |
926976 | 926976 | 2021-01-14 | Marshall | Alabama | 1095 | 10048 | 106 |
927587 | 927587 | 2021-01-14 | Marshall | Illinois | 17123 | 644 | 13 |
927680 | 927680 | 2021-01-14 | Marshall | Indiana | 18099 | 4872 | 84 |
927786 | 927786 | 2021-01-14 | Marshall | Iowa | 19127 | 4245 | 61 |
927880 | 927880 | 2021-01-14 | Marshall | Kansas | 20117 | 944 | 22 |
928004 | 928004 | 2021-01-14 | Marshall | Kentucky | 21157 | 1904 | 25 |
928298 | 928298 | 2021-01-14 | Marshall | Minnesota | 27089 | 701 | 15 |
928389 | 928389 | 2021-01-14 | Marshall | Mississippi | 28093 | 3332 | 64 |
929120 | 929120 | 2021-01-14 | Marshall | Oklahoma | 40095 | 1461 | 8 |
929430 | 929430 | 2021-01-14 | Marshall | South Dakota | 46091 | 274 | 5 |
929510 | 929510 | 2021-01-14 | Marshall | Tennessee | 47117 | 3331 | 36 |
930048 | 930048 | 2021-01-14 | Marshall | West Virginia | 54051 | 2465 | 57 |
923730 | 923730 | 2021-01-13 | Marshall | Alabama | 1095 | 9988 | 106 |
924341 | 924341 | 2021-01-13 | Marshall | Illinois | 17123 | 637 | 13 |
924434 | 924434 | 2021-01-13 | Marshall | Indiana | 18099 | 4850 | 84 |
924540 | 924540 | 2021-01-13 | Marshall | Iowa | 19127 | 4233 | 60 |
924634 | 924634 | 2021-01-13 | Marshall | Kansas | 20117 | 930 | 22 |
924758 | 924758 | 2021-01-13 | Marshall | Kentucky | 21157 | 1869 | 25 |
925052 | 925052 | 2021-01-13 | Marshall | Minnesota | 27089 | 698 | 15 |
925143 | 925143 | 2021-01-13 | Marshall | Mississippi | 28093 | 3315 | 64 |
925875 | 925875 | 2021-01-13 | Marshall | Oklahoma | 40095 | 1438 | 7 |
926185 | 926185 | 2021-01-13 | Marshall | South Dakota | 46091 | 272 | 5 |
926265 | 926265 | 2021-01-13 | Marshall | Tennessee | 47117 | 3285 | 35 |
926803 | 926803 | 2021-01-13 | Marshall | West Virginia | 54051 | 2454 | 57 |
920485 | 920485 | 2021-01-12 | Marshall | Alabama | 1095 | 9907 | 98 |
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 |
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);