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 332
- West Virginia 332
- Alabama 327
- Illinois 327
- Indiana 326
- Iowa 325
- South Dakota 323
- Tennessee 323
- Kentucky 322
- Oklahoma 315
- Minnesota 302
- Kansas 236
fips 12
county 1
- Marshall · 3,790 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1032978 | 1032978 | 2021-02-15 | Marshall | Oklahoma | 40095 | 1830 | 12 |
1033288 | 1033288 | 2021-02-15 | Marshall | South Dakota | 46091 | 295 | 5 |
1033368 | 1033368 | 2021-02-15 | Marshall | Tennessee | 47117 | 3850 | 52 |
1033906 | 1033906 | 2021-02-15 | Marshall | West Virginia | 54051 | 2956 | 66 |
1027586 | 1027586 | 2021-02-14 | Marshall | Alabama | 1095 | 11102 | 194 |
1028197 | 1028197 | 2021-02-14 | Marshall | Illinois | 17123 | 821 | 16 |
1028291 | 1028291 | 2021-02-14 | Marshall | Indiana | 18099 | 5352 | 104 |
1028397 | 1028397 | 2021-02-14 | Marshall | Iowa | 19127 | 4527 | 69 |
1028491 | 1028491 | 2021-02-14 | Marshall | Kansas | 20117 | 1061 | 22 |
1028615 | 1028615 | 2021-02-14 | Marshall | Kentucky | 21157 | 2440 | 43 |
1028909 | 1028909 | 2021-02-14 | Marshall | Minnesota | 27089 | 741 | 15 |
1029000 | 1029000 | 2021-02-14 | Marshall | Mississippi | 28093 | 3909 | 90 |
1029732 | 1029732 | 2021-02-14 | Marshall | Oklahoma | 40095 | 1828 | 12 |
1030042 | 1030042 | 2021-02-14 | Marshall | South Dakota | 46091 | 295 | 5 |
1030122 | 1030122 | 2021-02-14 | Marshall | Tennessee | 47117 | 3847 | 52 |
1030660 | 1030660 | 2021-02-14 | Marshall | West Virginia | 54051 | 2950 | 66 |
1024341 | 1024341 | 2021-02-13 | Marshall | Alabama | 1095 | 11090 | 194 |
1024952 | 1024952 | 2021-02-13 | Marshall | Illinois | 17123 | 819 | 16 |
1025046 | 1025046 | 2021-02-13 | Marshall | Indiana | 18099 | 5347 | 104 |
1025152 | 1025152 | 2021-02-13 | Marshall | Iowa | 19127 | 4526 | 69 |
1025246 | 1025246 | 2021-02-13 | Marshall | Kansas | 20117 | 1061 | 22 |
1025370 | 1025370 | 2021-02-13 | Marshall | Kentucky | 21157 | 2436 | 43 |
1025663 | 1025663 | 2021-02-13 | Marshall | Minnesota | 27089 | 735 | 15 |
1025754 | 1025754 | 2021-02-13 | Marshall | Mississippi | 28093 | 3884 | 90 |
1026485 | 1026485 | 2021-02-13 | Marshall | Oklahoma | 40095 | 1824 | 12 |
1026795 | 1026795 | 2021-02-13 | Marshall | South Dakota | 46091 | 294 | 5 |
1026875 | 1026875 | 2021-02-13 | Marshall | Tennessee | 47117 | 3845 | 52 |
1027413 | 1027413 | 2021-02-13 | Marshall | West Virginia | 54051 | 2944 | 65 |
1021096 | 1021096 | 2021-02-12 | Marshall | Alabama | 1095 | 11068 | 194 |
1021707 | 1021707 | 2021-02-12 | Marshall | Illinois | 17123 | 815 | 16 |
1021801 | 1021801 | 2021-02-12 | Marshall | Indiana | 18099 | 5341 | 104 |
1021907 | 1021907 | 2021-02-12 | Marshall | Iowa | 19127 | 4518 | 69 |
1022001 | 1022001 | 2021-02-12 | Marshall | Kansas | 20117 | 1061 | 22 |
1022125 | 1022125 | 2021-02-12 | Marshall | Kentucky | 21157 | 2434 | 43 |
1022418 | 1022418 | 2021-02-12 | Marshall | Minnesota | 27089 | 731 | 15 |
1022509 | 1022509 | 2021-02-12 | Marshall | Mississippi | 28093 | 3878 | 90 |
1023240 | 1023240 | 2021-02-12 | Marshall | Oklahoma | 40095 | 1812 | 12 |
1023550 | 1023550 | 2021-02-12 | Marshall | South Dakota | 46091 | 293 | 5 |
1023630 | 1023630 | 2021-02-12 | Marshall | Tennessee | 47117 | 3835 | 52 |
1024168 | 1024168 | 2021-02-12 | Marshall | West Virginia | 54051 | 2937 | 65 |
1017851 | 1017851 | 2021-02-11 | Marshall | Alabama | 1095 | 11057 | 191 |
1018462 | 1018462 | 2021-02-11 | Marshall | Illinois | 17123 | 804 | 16 |
1018556 | 1018556 | 2021-02-11 | Marshall | Indiana | 18099 | 5328 | 104 |
1018662 | 1018662 | 2021-02-11 | Marshall | Iowa | 19127 | 4509 | 69 |
1018756 | 1018756 | 2021-02-11 | Marshall | Kansas | 20117 | 1061 | 22 |
1018880 | 1018880 | 2021-02-11 | Marshall | Kentucky | 21157 | 2430 | 43 |
1019173 | 1019173 | 2021-02-11 | Marshall | Minnesota | 27089 | 729 | 15 |
1019264 | 1019264 | 2021-02-11 | Marshall | Mississippi | 28093 | 3859 | 89 |
1019995 | 1019995 | 2021-02-11 | Marshall | Oklahoma | 40095 | 1802 | 12 |
1020305 | 1020305 | 2021-02-11 | Marshall | South Dakota | 46091 | 291 | 5 |
1020385 | 1020385 | 2021-02-11 | Marshall | Tennessee | 47117 | 3818 | 52 |
1020923 | 1020923 | 2021-02-11 | Marshall | West Virginia | 54051 | 2941 | 65 |
1014606 | 1014606 | 2021-02-10 | Marshall | Alabama | 1095 | 11032 | 186 |
1015217 | 1015217 | 2021-02-10 | Marshall | Illinois | 17123 | 803 | 16 |
1015311 | 1015311 | 2021-02-10 | Marshall | Indiana | 18099 | 5316 | 102 |
1015417 | 1015417 | 2021-02-10 | Marshall | Iowa | 19127 | 4500 | 69 |
1015511 | 1015511 | 2021-02-10 | Marshall | Kansas | 20117 | 1047 | 22 |
1015635 | 1015635 | 2021-02-10 | Marshall | Kentucky | 21157 | 2403 | 41 |
1015928 | 1015928 | 2021-02-10 | Marshall | Minnesota | 27089 | 726 | 15 |
1016019 | 1016019 | 2021-02-10 | Marshall | Mississippi | 28093 | 3838 | 89 |
1016750 | 1016750 | 2021-02-10 | Marshall | Oklahoma | 40095 | 1791 | 12 |
1017060 | 1017060 | 2021-02-10 | Marshall | South Dakota | 46091 | 290 | 5 |
1017140 | 1017140 | 2021-02-10 | Marshall | Tennessee | 47117 | 3805 | 51 |
1017678 | 1017678 | 2021-02-10 | Marshall | West Virginia | 54051 | 2931 | 65 |
1011361 | 1011361 | 2021-02-09 | Marshall | Alabama | 1095 | 11014 | 178 |
1011972 | 1011972 | 2021-02-09 | Marshall | Illinois | 17123 | 801 | 16 |
1012066 | 1012066 | 2021-02-09 | Marshall | Indiana | 18099 | 5306 | 100 |
1012172 | 1012172 | 2021-02-09 | Marshall | Iowa | 19127 | 4491 | 68 |
1012266 | 1012266 | 2021-02-09 | Marshall | Kansas | 20117 | 1047 | 22 |
1012390 | 1012390 | 2021-02-09 | Marshall | Kentucky | 21157 | 2386 | 41 |
1012683 | 1012683 | 2021-02-09 | Marshall | Minnesota | 27089 | 723 | 15 |
1012774 | 1012774 | 2021-02-09 | Marshall | Mississippi | 28093 | 3828 | 88 |
1013505 | 1013505 | 2021-02-09 | Marshall | Oklahoma | 40095 | 1779 | 12 |
1013815 | 1013815 | 2021-02-09 | Marshall | South Dakota | 46091 | 289 | 5 |
1013895 | 1013895 | 2021-02-09 | Marshall | Tennessee | 47117 | 3788 | 53 |
1014433 | 1014433 | 2021-02-09 | Marshall | West Virginia | 54051 | 2925 | 65 |
1008115 | 1008115 | 2021-02-08 | Marshall | Alabama | 1095 | 10989 | 178 |
1008726 | 1008726 | 2021-02-08 | Marshall | Illinois | 17123 | 798 | 16 |
1008820 | 1008820 | 2021-02-08 | Marshall | Indiana | 18099 | 5300 | 99 |
1008926 | 1008926 | 2021-02-08 | Marshall | Iowa | 19127 | 4478 | 68 |
1009020 | 1009020 | 2021-02-08 | Marshall | Kansas | 20117 | 1047 | 22 |
1009144 | 1009144 | 2021-02-08 | Marshall | Kentucky | 21157 | 2365 | 41 |
1009438 | 1009438 | 2021-02-08 | Marshall | Minnesota | 27089 | 720 | 15 |
1009529 | 1009529 | 2021-02-08 | Marshall | Mississippi | 28093 | 3811 | 87 |
1010260 | 1010260 | 2021-02-08 | Marshall | Oklahoma | 40095 | 1778 | 12 |
1010570 | 1010570 | 2021-02-08 | Marshall | South Dakota | 46091 | 289 | 5 |
1010650 | 1010650 | 2021-02-08 | Marshall | Tennessee | 47117 | 3783 | 51 |
1011188 | 1011188 | 2021-02-08 | Marshall | West Virginia | 54051 | 2914 | 65 |
1004869 | 1004869 | 2021-02-07 | Marshall | Alabama | 1095 | 10986 | 178 |
1005480 | 1005480 | 2021-02-07 | Marshall | Illinois | 17123 | 796 | 16 |
1005574 | 1005574 | 2021-02-07 | Marshall | Indiana | 18099 | 5293 | 97 |
1005680 | 1005680 | 2021-02-07 | Marshall | Iowa | 19127 | 4474 | 68 |
1005774 | 1005774 | 2021-02-07 | Marshall | Kansas | 20117 | 1036 | 22 |
1005898 | 1005898 | 2021-02-07 | Marshall | Kentucky | 21157 | 2352 | 40 |
1006191 | 1006191 | 2021-02-07 | Marshall | Minnesota | 27089 | 718 | 15 |
1006282 | 1006282 | 2021-02-07 | Marshall | Mississippi | 28093 | 3799 | 87 |
1007014 | 1007014 | 2021-02-07 | Marshall | Oklahoma | 40095 | 1767 | 12 |
1007324 | 1007324 | 2021-02-07 | Marshall | South Dakota | 46091 | 289 | 5 |
1007404 | 1007404 | 2021-02-07 | Marshall | Tennessee | 47117 | 3779 | 50 |
1007942 | 1007942 | 2021-02-07 | Marshall | West Virginia | 54051 | 2901 | 65 |
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);