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
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Illinois 768
- Indiana 768
- Iowa 768
- Kentucky 768
- Mississippi 768
- South Dakota 768
- Tennessee 768
- West Virginia 768
- Alabama 767
- Oklahoma 767
- Minnesota 755
- Kansas 689
fips 12
county 1
- Marshall · 9,122 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
36176 | 36176 | 2020-04-06 | Marshall | Illinois | 17123 | 1 | 0 |
36255 | 36255 | 2020-04-06 | Marshall | Indiana | 18099 | 8 | 0 |
36344 | 36344 | 2020-04-06 | Marshall | Iowa | 19127 | 12 | 0 |
36478 | 36478 | 2020-04-06 | Marshall | Kentucky | 21157 | 1 | 0 |
36809 | 36809 | 2020-04-06 | Marshall | Mississippi | 28093 | 23 | 1 |
37529 | 37529 | 2020-04-06 | Marshall | South Dakota | 46091 | 1 | 0 |
37593 | 37593 | 2020-04-06 | Marshall | Tennessee | 47117 | 9 | 0 |
37987 | 37987 | 2020-04-06 | Marshall | West Virginia | 54051 | 5 | 0 |
38131 | 38131 | 2020-04-07 | Marshall | Alabama | 1095 | 40 | 1 |
38672 | 38672 | 2020-04-07 | Marshall | Illinois | 17123 | 1 | 0 |
38753 | 38753 | 2020-04-07 | Marshall | Indiana | 18099 | 10 | 0 |
38845 | 38845 | 2020-04-07 | Marshall | Iowa | 19127 | 14 | 0 |
38985 | 38985 | 2020-04-07 | Marshall | Kentucky | 21157 | 6 | 0 |
39320 | 39320 | 2020-04-07 | Marshall | Mississippi | 28093 | 24 | 1 |
39857 | 39857 | 2020-04-07 | Marshall | Oklahoma | 40095 | 1 | 0 |
40052 | 40052 | 2020-04-07 | Marshall | South Dakota | 46091 | 1 | 0 |
40116 | 40116 | 2020-04-07 | Marshall | Tennessee | 47117 | 9 | 0 |
40524 | 40524 | 2020-04-07 | Marshall | West Virginia | 54051 | 5 | 0 |
40673 | 40673 | 2020-04-08 | Marshall | Alabama | 1095 | 45 | 1 |
41217 | 41217 | 2020-04-08 | Marshall | Illinois | 17123 | 1 | 0 |
41299 | 41299 | 2020-04-08 | Marshall | Indiana | 18099 | 11 | 0 |
41391 | 41391 | 2020-04-08 | Marshall | Iowa | 19127 | 15 | 0 |
41535 | 41535 | 2020-04-08 | Marshall | Kentucky | 21157 | 8 | 0 |
41874 | 41874 | 2020-04-08 | Marshall | Mississippi | 28093 | 24 | 1 |
42417 | 42417 | 2020-04-08 | Marshall | Oklahoma | 40095 | 1 | 0 |
42612 | 42612 | 2020-04-08 | Marshall | South Dakota | 46091 | 1 | 0 |
42678 | 42678 | 2020-04-08 | Marshall | Tennessee | 47117 | 9 | 0 |
43096 | 43096 | 2020-04-08 | Marshall | West Virginia | 54051 | 5 | 0 |
43246 | 43246 | 2020-04-09 | Marshall | Alabama | 1095 | 64 | 2 |
43791 | 43791 | 2020-04-09 | Marshall | Illinois | 17123 | 1 | 0 |
43875 | 43875 | 2020-04-09 | Marshall | Indiana | 18099 | 11 | 0 |
43967 | 43967 | 2020-04-09 | Marshall | Iowa | 19127 | 18 | 0 |
44111 | 44111 | 2020-04-09 | Marshall | Kentucky | 21157 | 8 | 0 |
44451 | 44451 | 2020-04-09 | Marshall | Mississippi | 28093 | 26 | 1 |
45003 | 45003 | 2020-04-09 | Marshall | Oklahoma | 40095 | 1 | 0 |
45200 | 45200 | 2020-04-09 | Marshall | South Dakota | 46091 | 1 | 0 |
45265 | 45265 | 2020-04-09 | Marshall | Tennessee | 47117 | 9 | 0 |
45692 | 45692 | 2020-04-09 | Marshall | West Virginia | 54051 | 5 | 0 |
45844 | 45844 | 2020-04-10 | Marshall | Alabama | 1095 | 72 | 2 |
46395 | 46395 | 2020-04-10 | Marshall | Illinois | 17123 | 1 | 0 |
46479 | 46479 | 2020-04-10 | Marshall | Indiana | 18099 | 12 | 0 |
46572 | 46572 | 2020-04-10 | Marshall | Iowa | 19127 | 20 | 0 |
46719 | 46719 | 2020-04-10 | Marshall | Kentucky | 21157 | 10 | 0 |
47060 | 47060 | 2020-04-10 | Marshall | Mississippi | 28093 | 28 | 1 |
47618 | 47618 | 2020-04-10 | Marshall | Oklahoma | 40095 | 1 | 0 |
47817 | 47817 | 2020-04-10 | Marshall | South Dakota | 46091 | 1 | 0 |
47883 | 47883 | 2020-04-10 | Marshall | Tennessee | 47117 | 9 | 1 |
48320 | 48320 | 2020-04-10 | Marshall | West Virginia | 54051 | 6 | 0 |
48473 | 48473 | 2020-04-11 | Marshall | Alabama | 1095 | 84 | 2 |
49026 | 49026 | 2020-04-11 | Marshall | Illinois | 17123 | 1 | 0 |
49113 | 49113 | 2020-04-11 | Marshall | Indiana | 18099 | 14 | 0 |
49206 | 49206 | 2020-04-11 | Marshall | Iowa | 19127 | 28 | 0 |
49359 | 49359 | 2020-04-11 | Marshall | Kentucky | 21157 | 11 | 0 |
49706 | 49706 | 2020-04-11 | Marshall | Mississippi | 28093 | 30 | 2 |
50274 | 50274 | 2020-04-11 | Marshall | Oklahoma | 40095 | 1 | 0 |
50474 | 50474 | 2020-04-11 | Marshall | South Dakota | 46091 | 1 | 0 |
50541 | 50541 | 2020-04-11 | Marshall | Tennessee | 47117 | 9 | 1 |
50978 | 50978 | 2020-04-11 | Marshall | West Virginia | 54051 | 6 | 0 |
51135 | 51135 | 2020-04-12 | Marshall | Alabama | 1095 | 99 | 2 |
51688 | 51688 | 2020-04-12 | Marshall | Illinois | 17123 | 1 | 0 |
51776 | 51776 | 2020-04-12 | Marshall | Indiana | 18099 | 19 | 0 |
51870 | 51870 | 2020-04-12 | Marshall | Iowa | 19127 | 31 | 0 |
52025 | 52025 | 2020-04-12 | Marshall | Kentucky | 21157 | 11 | 0 |
52379 | 52379 | 2020-04-12 | Marshall | Mississippi | 28093 | 33 | 2 |
52947 | 52947 | 2020-04-12 | Marshall | Oklahoma | 40095 | 1 | 0 |
53147 | 53147 | 2020-04-12 | Marshall | South Dakota | 46091 | 1 | 0 |
53216 | 53216 | 2020-04-12 | Marshall | Tennessee | 47117 | 9 | 1 |
53654 | 53654 | 2020-04-12 | Marshall | West Virginia | 54051 | 6 | 0 |
53813 | 53813 | 2020-04-13 | Marshall | Alabama | 1095 | 103 | 2 |
54369 | 54369 | 2020-04-13 | Marshall | Illinois | 17123 | 1 | 0 |
54457 | 54457 | 2020-04-13 | Marshall | Indiana | 18099 | 17 | 0 |
54552 | 54552 | 2020-04-13 | Marshall | Iowa | 19127 | 37 | 0 |
54706 | 54706 | 2020-04-13 | Marshall | Kentucky | 21157 | 11 | 0 |
55061 | 55061 | 2020-04-13 | Marshall | Mississippi | 28093 | 34 | 2 |
55632 | 55632 | 2020-04-13 | Marshall | Oklahoma | 40095 | 1 | 0 |
55833 | 55833 | 2020-04-13 | Marshall | South Dakota | 46091 | 1 | 0 |
55903 | 55903 | 2020-04-13 | Marshall | Tennessee | 47117 | 9 | 1 |
56344 | 56344 | 2020-04-13 | Marshall | West Virginia | 54051 | 6 | 0 |
56505 | 56505 | 2020-04-14 | Marshall | Alabama | 1095 | 104 | 2 |
57062 | 57062 | 2020-04-14 | Marshall | Illinois | 17123 | 2 | 0 |
57150 | 57150 | 2020-04-14 | Marshall | Indiana | 18099 | 17 | 0 |
57245 | 57245 | 2020-04-14 | Marshall | Iowa | 19127 | 42 | 0 |
57404 | 57404 | 2020-04-14 | Marshall | Kentucky | 21157 | 12 | 0 |
57759 | 57759 | 2020-04-14 | Marshall | Mississippi | 28093 | 34 | 2 |
58334 | 58334 | 2020-04-14 | Marshall | Oklahoma | 40095 | 1 | 0 |
58536 | 58536 | 2020-04-14 | Marshall | South Dakota | 46091 | 1 | 0 |
58606 | 58606 | 2020-04-14 | Marshall | Tennessee | 47117 | 9 | 1 |
59051 | 59051 | 2020-04-14 | Marshall | West Virginia | 54051 | 7 | 0 |
59213 | 59213 | 2020-04-15 | Marshall | Alabama | 1095 | 109 | 2 |
59769 | 59769 | 2020-04-15 | Marshall | Illinois | 17123 | 2 | 0 |
59858 | 59858 | 2020-04-15 | Marshall | Indiana | 18099 | 19 | 0 |
59953 | 59953 | 2020-04-15 | Marshall | Iowa | 19127 | 44 | 0 |
60113 | 60113 | 2020-04-15 | Marshall | Kentucky | 21157 | 12 | 0 |
60470 | 60470 | 2020-04-15 | Marshall | Mississippi | 28093 | 35 | 2 |
61049 | 61049 | 2020-04-15 | Marshall | Oklahoma | 40095 | 1 | 0 |
61251 | 61251 | 2020-04-15 | Marshall | South Dakota | 46091 | 1 | 0 |
61321 | 61321 | 2020-04-15 | Marshall | Tennessee | 47117 | 9 | 1 |
61770 | 61770 | 2020-04-15 | Marshall | West Virginia | 54051 | 7 | 0 |
61931 | 61931 | 2020-04-16 | Marshall | Alabama | 1095 | 117 | 2 |
62490 | 62490 | 2020-04-16 | Marshall | Illinois | 17123 | 2 | 0 |
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);