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 777
- West Virginia 776
- Alabama 771
- Illinois 771
- Indiana 770
- Iowa 769
- Kentucky 767
- South Dakota 767
- Tennessee 767
- Oklahoma 759
- Minnesota 747
- Kansas 681
fips 12
county 1
- Marshall · 9,122 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474467 | 2474467 | 2022-05-05 | Marshall | Kansas | 20117 | 2557 | 42 |
2474591 | 2474591 | 2022-05-05 | Marshall | Kentucky | 21157 | 8416 | 106 |
2474885 | 2474885 | 2022-05-05 | Marshall | Minnesota | 27089 | 2109 | 23 |
2474976 | 2474976 | 2022-05-05 | Marshall | Mississippi | 28093 | 9922 | 174 |
2475714 | 2475714 | 2022-05-05 | Marshall | Oklahoma | 40095 | 4604 | 46 |
2476024 | 2476024 | 2022-05-05 | Marshall | South Dakota | 46091 | 793 | 13 |
2476104 | 2476104 | 2022-05-05 | Marshall | Tennessee | 47117 | 10385 | 124 |
2476644 | 2476644 | 2022-05-05 | Marshall | West Virginia | 54051 | 9048 | 154 |
2470302 | 2470302 | 2022-05-04 | Marshall | Alabama | 1095 | 27396 | 393 |
2470915 | 2470915 | 2022-05-04 | Marshall | Illinois | 17123 | 2792 | 33 |
2471009 | 2471009 | 2022-05-04 | Marshall | Indiana | 18099 | 12400 | 197 |
2471116 | 2471116 | 2022-05-04 | Marshall | Iowa | 19127 | 9456 | 111 |
2471210 | 2471210 | 2022-05-04 | Marshall | Kansas | 20117 | 2557 | 42 |
2471334 | 2471334 | 2022-05-04 | Marshall | Kentucky | 21157 | 8416 | 106 |
2471628 | 2471628 | 2022-05-04 | Marshall | Minnesota | 27089 | 2110 | 23 |
2471719 | 2471719 | 2022-05-04 | Marshall | Mississippi | 28093 | 9922 | 174 |
2472457 | 2472457 | 2022-05-04 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2472767 | 2472767 | 2022-05-04 | Marshall | South Dakota | 46091 | 793 | 13 |
2472847 | 2472847 | 2022-05-04 | Marshall | Tennessee | 47117 | 10385 | 124 |
2473386 | 2473386 | 2022-05-04 | Marshall | West Virginia | 54051 | 9043 | 154 |
2467046 | 2467046 | 2022-05-03 | Marshall | Alabama | 1095 | 27388 | 393 |
2467659 | 2467659 | 2022-05-03 | Marshall | Illinois | 17123 | 2791 | 33 |
2467753 | 2467753 | 2022-05-03 | Marshall | Indiana | 18099 | 12395 | 197 |
2467860 | 2467860 | 2022-05-03 | Marshall | Iowa | 19127 | 9433 | 111 |
2467954 | 2467954 | 2022-05-03 | Marshall | Kansas | 20117 | 2557 | 42 |
2468078 | 2468078 | 2022-05-03 | Marshall | Kentucky | 21157 | 8416 | 106 |
2468372 | 2468372 | 2022-05-03 | Marshall | Minnesota | 27089 | 2109 | 23 |
2468463 | 2468463 | 2022-05-03 | Marshall | Mississippi | 28093 | 9922 | 174 |
2469201 | 2469201 | 2022-05-03 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2469511 | 2469511 | 2022-05-03 | Marshall | South Dakota | 46091 | 788 | 13 |
2469591 | 2469591 | 2022-05-03 | Marshall | Tennessee | 47117 | 10375 | 124 |
2470129 | 2470129 | 2022-05-03 | Marshall | West Virginia | 54051 | 9037 | 154 |
2463791 | 2463791 | 2022-05-02 | Marshall | Alabama | 1095 | 27380 | 392 |
2464404 | 2464404 | 2022-05-02 | Marshall | Illinois | 17123 | 2787 | 33 |
2464498 | 2464498 | 2022-05-02 | Marshall | Indiana | 18099 | 12395 | 197 |
2464605 | 2464605 | 2022-05-02 | Marshall | Iowa | 19127 | 9433 | 111 |
2464699 | 2464699 | 2022-05-02 | Marshall | Kansas | 20117 | 2557 | 42 |
2464823 | 2464823 | 2022-05-02 | Marshall | Kentucky | 21157 | 8416 | 106 |
2465117 | 2465117 | 2022-05-02 | Marshall | Minnesota | 27089 | 2106 | 23 |
2465208 | 2465208 | 2022-05-02 | Marshall | Mississippi | 28093 | 9922 | 174 |
2465945 | 2465945 | 2022-05-02 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2466255 | 2466255 | 2022-05-02 | Marshall | South Dakota | 46091 | 788 | 13 |
2466335 | 2466335 | 2022-05-02 | Marshall | Tennessee | 47117 | 10375 | 124 |
2466873 | 2466873 | 2022-05-02 | Marshall | West Virginia | 54051 | 9031 | 154 |
2460535 | 2460535 | 2022-05-01 | Marshall | Alabama | 1095 | 27377 | 392 |
2461148 | 2461148 | 2022-05-01 | Marshall | Illinois | 17123 | 2781 | 33 |
2461242 | 2461242 | 2022-05-01 | Marshall | Indiana | 18099 | 12394 | 197 |
2461349 | 2461349 | 2022-05-01 | Marshall | Iowa | 19127 | 9433 | 111 |
2461443 | 2461443 | 2022-05-01 | Marshall | Kansas | 20117 | 2557 | 42 |
2461567 | 2461567 | 2022-05-01 | Marshall | Kentucky | 21157 | 8401 | 104 |
2461861 | 2461861 | 2022-05-01 | Marshall | Minnesota | 27089 | 2106 | 23 |
2461952 | 2461952 | 2022-05-01 | Marshall | Mississippi | 28093 | 9916 | 174 |
2462690 | 2462690 | 2022-05-01 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2463000 | 2463000 | 2022-05-01 | Marshall | South Dakota | 46091 | 788 | 13 |
2463080 | 2463080 | 2022-05-01 | Marshall | Tennessee | 47117 | 10375 | 124 |
2463618 | 2463618 | 2022-05-01 | Marshall | West Virginia | 54051 | 9022 | 154 |
2457279 | 2457279 | 2022-04-30 | Marshall | Alabama | 1095 | 27377 | 392 |
2457892 | 2457892 | 2022-04-30 | Marshall | Illinois | 17123 | 2781 | 33 |
2457986 | 2457986 | 2022-04-30 | Marshall | Indiana | 18099 | 12394 | 197 |
2458093 | 2458093 | 2022-04-30 | Marshall | Iowa | 19127 | 9433 | 111 |
2458187 | 2458187 | 2022-04-30 | Marshall | Kansas | 20117 | 2557 | 42 |
2458311 | 2458311 | 2022-04-30 | Marshall | Kentucky | 21157 | 8401 | 104 |
2458605 | 2458605 | 2022-04-30 | Marshall | Minnesota | 27089 | 2106 | 23 |
2458696 | 2458696 | 2022-04-30 | Marshall | Mississippi | 28093 | 9916 | 174 |
2459434 | 2459434 | 2022-04-30 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2459744 | 2459744 | 2022-04-30 | Marshall | South Dakota | 46091 | 788 | 13 |
2459824 | 2459824 | 2022-04-30 | Marshall | Tennessee | 47117 | 10375 | 124 |
2460362 | 2460362 | 2022-04-30 | Marshall | West Virginia | 54051 | 9022 | 154 |
2454023 | 2454023 | 2022-04-29 | Marshall | Alabama | 1095 | 27377 | 392 |
2454636 | 2454636 | 2022-04-29 | Marshall | Illinois | 17123 | 2781 | 33 |
2454730 | 2454730 | 2022-04-29 | Marshall | Indiana | 18099 | 12394 | 197 |
2454837 | 2454837 | 2022-04-29 | Marshall | Iowa | 19127 | 9433 | 111 |
2454931 | 2454931 | 2022-04-29 | Marshall | Kansas | 20117 | 2557 | 42 |
2455055 | 2455055 | 2022-04-29 | Marshall | Kentucky | 21157 | 8401 | 104 |
2455349 | 2455349 | 2022-04-29 | Marshall | Minnesota | 27089 | 2106 | 23 |
2455440 | 2455440 | 2022-04-29 | Marshall | Mississippi | 28093 | 9916 | 174 |
2456178 | 2456178 | 2022-04-29 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2456488 | 2456488 | 2022-04-29 | Marshall | South Dakota | 46091 | 788 | 13 |
2456568 | 2456568 | 2022-04-29 | Marshall | Tennessee | 47117 | 10375 | 124 |
2457106 | 2457106 | 2022-04-29 | Marshall | West Virginia | 54051 | 9022 | 154 |
2450767 | 2450767 | 2022-04-28 | Marshall | Alabama | 1095 | 27368 | 392 |
2451380 | 2451380 | 2022-04-28 | Marshall | Illinois | 17123 | 2781 | 33 |
2451474 | 2451474 | 2022-04-28 | Marshall | Indiana | 18099 | 12386 | 197 |
2451581 | 2451581 | 2022-04-28 | Marshall | Iowa | 19127 | 9433 | 111 |
2451675 | 2451675 | 2022-04-28 | Marshall | Kansas | 20117 | 2554 | 42 |
2451799 | 2451799 | 2022-04-28 | Marshall | Kentucky | 21157 | 8401 | 104 |
2452093 | 2452093 | 2022-04-28 | Marshall | Minnesota | 27089 | 2100 | 23 |
2452184 | 2452184 | 2022-04-28 | Marshall | Mississippi | 28093 | 9916 | 174 |
2452922 | 2452922 | 2022-04-28 | Marshall | Oklahoma | 40095 | 4602 | 44 |
2453232 | 2453232 | 2022-04-28 | Marshall | South Dakota | 46091 | 788 | 13 |
2453312 | 2453312 | 2022-04-28 | Marshall | Tennessee | 47117 | 10375 | 124 |
2453850 | 2453850 | 2022-04-28 | Marshall | West Virginia | 54051 | 9015 | 154 |
2447511 | 2447511 | 2022-04-27 | Marshall | Alabama | 1095 | 27366 | 392 |
2448124 | 2448124 | 2022-04-27 | Marshall | Illinois | 17123 | 2777 | 33 |
2448218 | 2448218 | 2022-04-27 | Marshall | Indiana | 18099 | 12386 | 197 |
2448325 | 2448325 | 2022-04-27 | Marshall | Iowa | 19127 | 9433 | 111 |
2448419 | 2448419 | 2022-04-27 | Marshall | Kansas | 20117 | 2554 | 42 |
2448543 | 2448543 | 2022-04-27 | Marshall | Kentucky | 21157 | 8401 | 104 |
2448837 | 2448837 | 2022-04-27 | Marshall | Minnesota | 27089 | 2098 | 23 |
2448928 | 2448928 | 2022-04-27 | Marshall | Mississippi | 28093 | 9916 | 174 |
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);