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 110
- West Virginia 109
- Illinois 105
- Alabama 104
- Indiana 104
- Iowa 103
- Kentucky 100
- South Dakota 100
- Tennessee 100
- Oklahoma 92
- Minnesota 80
- Kansas 14
fips 12
county 1
- Marshall · 1,121 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
309845 | 309845 | 2020-07-07 | Marshall | Illinois | 17123 | 12 | 0 |
309939 | 309939 | 2020-07-07 | Marshall | Indiana | 18099 | 492 | 6 |
310045 | 310045 | 2020-07-07 | Marshall | Iowa | 19127 | 1060 | 19 |
310136 | 310136 | 2020-07-07 | Marshall | Kansas | 20117 | 2 | 0 |
310255 | 310255 | 2020-07-07 | Marshall | Kentucky | 21157 | 65 | 2 |
310548 | 310548 | 2020-07-07 | Marshall | Minnesota | 27089 | 12 | 0 |
310639 | 310639 | 2020-07-07 | Marshall | Mississippi | 28093 | 258 | 3 |
311331 | 311331 | 2020-07-07 | Marshall | Oklahoma | 40095 | 41 | 0 |
311635 | 311635 | 2020-07-07 | Marshall | South Dakota | 46091 | 5 | 0 |
311713 | 311713 | 2020-07-07 | Marshall | Tennessee | 47117 | 98 | 1 |
312239 | 312239 | 2020-07-07 | Marshall | West Virginia | 54051 | 45 | 0 |
306075 | 306075 | 2020-07-06 | Marshall | Alabama | 1095 | 1732 | 10 |
306677 | 306677 | 2020-07-06 | Marshall | Illinois | 17123 | 11 | 0 |
306771 | 306771 | 2020-07-06 | Marshall | Indiana | 18099 | 490 | 4 |
306877 | 306877 | 2020-07-06 | Marshall | Iowa | 19127 | 1049 | 19 |
306968 | 306968 | 2020-07-06 | Marshall | Kansas | 20117 | 2 | 0 |
307087 | 307087 | 2020-07-06 | Marshall | Kentucky | 21157 | 65 | 2 |
307380 | 307380 | 2020-07-06 | Marshall | Minnesota | 27089 | 12 | 0 |
307471 | 307471 | 2020-07-06 | Marshall | Mississippi | 28093 | 234 | 3 |
308162 | 308162 | 2020-07-06 | Marshall | Oklahoma | 40095 | 37 | 0 |
308466 | 308466 | 2020-07-06 | Marshall | South Dakota | 46091 | 5 | 0 |
308544 | 308544 | 2020-07-06 | Marshall | Tennessee | 47117 | 92 | 1 |
309070 | 309070 | 2020-07-06 | Marshall | West Virginia | 54051 | 44 | 0 |
302911 | 302911 | 2020-07-05 | Marshall | Alabama | 1095 | 1719 | 10 |
303512 | 303512 | 2020-07-05 | Marshall | Illinois | 17123 | 10 | 0 |
303606 | 303606 | 2020-07-05 | Marshall | Indiana | 18099 | 492 | 4 |
303712 | 303712 | 2020-07-05 | Marshall | Iowa | 19127 | 1050 | 19 |
303801 | 303801 | 2020-07-05 | Marshall | Kansas | 20117 | 2 | 0 |
303920 | 303920 | 2020-07-05 | Marshall | Kentucky | 21157 | 60 | 2 |
304213 | 304213 | 2020-07-05 | Marshall | Minnesota | 27089 | 12 | 0 |
304304 | 304304 | 2020-07-05 | Marshall | Mississippi | 28093 | 232 | 3 |
304995 | 304995 | 2020-07-05 | Marshall | Oklahoma | 40095 | 37 | 0 |
305298 | 305298 | 2020-07-05 | Marshall | South Dakota | 46091 | 5 | 0 |
305376 | 305376 | 2020-07-05 | Marshall | Tennessee | 47117 | 91 | 1 |
305902 | 305902 | 2020-07-05 | Marshall | West Virginia | 54051 | 44 | 0 |
299747 | 299747 | 2020-07-04 | Marshall | Alabama | 1095 | 1710 | 10 |
300348 | 300348 | 2020-07-04 | Marshall | Illinois | 17123 | 10 | 0 |
300442 | 300442 | 2020-07-04 | Marshall | Indiana | 18099 | 482 | 3 |
300548 | 300548 | 2020-07-04 | Marshall | Iowa | 19127 | 1044 | 19 |
300637 | 300637 | 2020-07-04 | Marshall | Kansas | 20117 | 2 | 0 |
300756 | 300756 | 2020-07-04 | Marshall | Kentucky | 21157 | 60 | 2 |
301049 | 301049 | 2020-07-04 | Marshall | Minnesota | 27089 | 12 | 0 |
301140 | 301140 | 2020-07-04 | Marshall | Mississippi | 28093 | 226 | 3 |
301832 | 301832 | 2020-07-04 | Marshall | Oklahoma | 40095 | 36 | 0 |
302135 | 302135 | 2020-07-04 | Marshall | South Dakota | 46091 | 5 | 0 |
302213 | 302213 | 2020-07-04 | Marshall | Tennessee | 47117 | 89 | 1 |
302738 | 302738 | 2020-07-04 | Marshall | West Virginia | 54051 | 42 | 0 |
296585 | 296585 | 2020-07-03 | Marshall | Alabama | 1095 | 1688 | 10 |
297186 | 297186 | 2020-07-03 | Marshall | Illinois | 17123 | 9 | 0 |
297280 | 297280 | 2020-07-03 | Marshall | Indiana | 18099 | 427 | 3 |
297386 | 297386 | 2020-07-03 | Marshall | Iowa | 19127 | 1041 | 19 |
297475 | 297475 | 2020-07-03 | Marshall | Kansas | 20117 | 2 | 0 |
297594 | 297594 | 2020-07-03 | Marshall | Kentucky | 21157 | 60 | 2 |
297886 | 297886 | 2020-07-03 | Marshall | Minnesota | 27089 | 12 | 0 |
297977 | 297977 | 2020-07-03 | Marshall | Mississippi | 28093 | 217 | 3 |
298669 | 298669 | 2020-07-03 | Marshall | Oklahoma | 40095 | 33 | 0 |
298971 | 298971 | 2020-07-03 | Marshall | South Dakota | 46091 | 5 | 0 |
299049 | 299049 | 2020-07-03 | Marshall | Tennessee | 47117 | 81 | 1 |
299574 | 299574 | 2020-07-03 | Marshall | West Virginia | 54051 | 42 | 0 |
293430 | 293430 | 2020-07-02 | Marshall | Alabama | 1095 | 1631 | 10 |
294029 | 294029 | 2020-07-02 | Marshall | Illinois | 17123 | 9 | 0 |
294122 | 294122 | 2020-07-02 | Marshall | Indiana | 18099 | 418 | 3 |
294228 | 294228 | 2020-07-02 | Marshall | Iowa | 19127 | 1035 | 19 |
294317 | 294317 | 2020-07-02 | Marshall | Kansas | 20117 | 1 | 0 |
294436 | 294436 | 2020-07-02 | Marshall | Kentucky | 21157 | 60 | 2 |
294728 | 294728 | 2020-07-02 | Marshall | Minnesota | 27089 | 12 | 0 |
294819 | 294819 | 2020-07-02 | Marshall | Mississippi | 28093 | 212 | 3 |
295510 | 295510 | 2020-07-02 | Marshall | Oklahoma | 40095 | 33 | 0 |
295811 | 295811 | 2020-07-02 | Marshall | South Dakota | 46091 | 5 | 0 |
295889 | 295889 | 2020-07-02 | Marshall | Tennessee | 47117 | 74 | 1 |
296412 | 296412 | 2020-07-02 | Marshall | West Virginia | 54051 | 41 | 0 |
290277 | 290277 | 2020-07-01 | Marshall | Alabama | 1095 | 1548 | 10 |
290875 | 290875 | 2020-07-01 | Marshall | Illinois | 17123 | 8 | 0 |
290968 | 290968 | 2020-07-01 | Marshall | Indiana | 18099 | 412 | 3 |
291074 | 291074 | 2020-07-01 | Marshall | Iowa | 19127 | 1017 | 18 |
291163 | 291163 | 2020-07-01 | Marshall | Kansas | 20117 | 1 | 0 |
291282 | 291282 | 2020-07-01 | Marshall | Kentucky | 21157 | 59 | 2 |
291574 | 291574 | 2020-07-01 | Marshall | Minnesota | 27089 | 12 | 0 |
291665 | 291665 | 2020-07-01 | Marshall | Mississippi | 28093 | 201 | 3 |
292354 | 292354 | 2020-07-01 | Marshall | Oklahoma | 40095 | 32 | 0 |
292655 | 292655 | 2020-07-01 | Marshall | South Dakota | 46091 | 5 | 0 |
292733 | 292733 | 2020-07-01 | Marshall | Tennessee | 47117 | 73 | 1 |
293257 | 293257 | 2020-07-01 | Marshall | West Virginia | 54051 | 41 | 0 |
287127 | 287127 | 2020-06-30 | Marshall | Alabama | 1095 | 1505 | 9 |
287725 | 287725 | 2020-06-30 | Marshall | Illinois | 17123 | 8 | 0 |
287818 | 287818 | 2020-06-30 | Marshall | Indiana | 18099 | 409 | 3 |
287924 | 287924 | 2020-06-30 | Marshall | Iowa | 19127 | 1012 | 18 |
288013 | 288013 | 2020-06-30 | Marshall | Kansas | 20117 | 1 | 0 |
288132 | 288132 | 2020-06-30 | Marshall | Kentucky | 21157 | 58 | 2 |
288423 | 288423 | 2020-06-30 | Marshall | Minnesota | 27089 | 12 | 0 |
288514 | 288514 | 2020-06-30 | Marshall | Mississippi | 28093 | 196 | 3 |
289201 | 289201 | 2020-06-30 | Marshall | Oklahoma | 40095 | 32 | 0 |
289503 | 289503 | 2020-06-30 | Marshall | South Dakota | 46091 | 5 | 0 |
289581 | 289581 | 2020-06-30 | Marshall | Tennessee | 47117 | 71 | 1 |
290104 | 290104 | 2020-06-30 | Marshall | West Virginia | 54051 | 40 | 0 |
283981 | 283981 | 2020-06-29 | Marshall | Alabama | 1095 | 1463 | 9 |
284576 | 284576 | 2020-06-29 | Marshall | Illinois | 17123 | 8 | 0 |
284669 | 284669 | 2020-06-29 | Marshall | Indiana | 18099 | 407 | 3 |
284775 | 284775 | 2020-06-29 | Marshall | Iowa | 19127 | 1012 | 18 |
284864 | 284864 | 2020-06-29 | Marshall | Kansas | 20117 | 1 | 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);