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 102
- West Virginia 101
- Alabama 96
- Illinois 96
- Indiana 95
- Iowa 94
- Kentucky 92
- South Dakota 92
- Tennessee 92
- Oklahoma 84
- Minnesota 72
- Kansas 5
fips 12
county 1
- Marshall · 1,021 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
284983 | 284983 | 2020-06-29 | Marshall | Kentucky | 21157 | 56 | 2 |
285273 | 285273 | 2020-06-29 | Marshall | Minnesota | 27089 | 12 | 0 |
285364 | 285364 | 2020-06-29 | Marshall | Mississippi | 28093 | 195 | 3 |
286051 | 286051 | 2020-06-29 | Marshall | Oklahoma | 40095 | 26 | 0 |
286352 | 286352 | 2020-06-29 | Marshall | South Dakota | 46091 | 5 | 0 |
286430 | 286430 | 2020-06-29 | Marshall | Tennessee | 47117 | 67 | 1 |
286954 | 286954 | 2020-06-29 | Marshall | West Virginia | 54051 | 42 | 0 |
280835 | 280835 | 2020-06-28 | Marshall | Alabama | 1095 | 1418 | 9 |
281431 | 281431 | 2020-06-28 | Marshall | Illinois | 17123 | 8 | 0 |
281524 | 281524 | 2020-06-28 | Marshall | Indiana | 18099 | 403 | 3 |
281630 | 281630 | 2020-06-28 | Marshall | Iowa | 19127 | 1009 | 18 |
281719 | 281719 | 2020-06-28 | Marshall | Kansas | 20117 | 1 | 0 |
281837 | 281837 | 2020-06-28 | Marshall | Kentucky | 21157 | 55 | 2 |
282128 | 282128 | 2020-06-28 | Marshall | Minnesota | 27089 | 12 | 0 |
282219 | 282219 | 2020-06-28 | Marshall | Mississippi | 28093 | 185 | 3 |
282906 | 282906 | 2020-06-28 | Marshall | Oklahoma | 40095 | 25 | 0 |
283207 | 283207 | 2020-06-28 | Marshall | South Dakota | 46091 | 5 | 0 |
283285 | 283285 | 2020-06-28 | Marshall | Tennessee | 47117 | 60 | 1 |
283808 | 283808 | 2020-06-28 | Marshall | West Virginia | 54051 | 42 | 0 |
277687 | 277687 | 2020-06-27 | Marshall | Alabama | 1095 | 1399 | 9 |
278283 | 278283 | 2020-06-27 | Marshall | Illinois | 17123 | 8 | 0 |
278376 | 278376 | 2020-06-27 | Marshall | Indiana | 18099 | 401 | 3 |
278482 | 278482 | 2020-06-27 | Marshall | Iowa | 19127 | 1009 | 18 |
278571 | 278571 | 2020-06-27 | Marshall | Kansas | 20117 | 1 | 0 |
278689 | 278689 | 2020-06-27 | Marshall | Kentucky | 21157 | 54 | 2 |
278980 | 278980 | 2020-06-27 | Marshall | Minnesota | 27089 | 12 | 0 |
279071 | 279071 | 2020-06-27 | Marshall | Mississippi | 28093 | 171 | 3 |
279760 | 279760 | 2020-06-27 | Marshall | Oklahoma | 40095 | 25 | 0 |
280061 | 280061 | 2020-06-27 | Marshall | South Dakota | 46091 | 5 | 0 |
280139 | 280139 | 2020-06-27 | Marshall | Tennessee | 47117 | 60 | 1 |
280662 | 280662 | 2020-06-27 | Marshall | West Virginia | 54051 | 43 | 0 |
274539 | 274539 | 2020-06-26 | Marshall | Alabama | 1095 | 1336 | 9 |
275135 | 275135 | 2020-06-26 | Marshall | Illinois | 17123 | 7 | 0 |
275228 | 275228 | 2020-06-26 | Marshall | Indiana | 18099 | 393 | 3 |
275334 | 275334 | 2020-06-26 | Marshall | Iowa | 19127 | 1005 | 18 |
275423 | 275423 | 2020-06-26 | Marshall | Kansas | 20117 | 1 | 0 |
275541 | 275541 | 2020-06-26 | Marshall | Kentucky | 21157 | 53 | 2 |
275832 | 275832 | 2020-06-26 | Marshall | Minnesota | 27089 | 12 | 0 |
275923 | 275923 | 2020-06-26 | Marshall | Mississippi | 28093 | 164 | 3 |
276612 | 276612 | 2020-06-26 | Marshall | Oklahoma | 40095 | 25 | 0 |
276913 | 276913 | 2020-06-26 | Marshall | South Dakota | 46091 | 5 | 0 |
276991 | 276991 | 2020-06-26 | Marshall | Tennessee | 47117 | 54 | 1 |
277514 | 277514 | 2020-06-26 | Marshall | West Virginia | 54051 | 41 | 0 |
271399 | 271399 | 2020-06-25 | Marshall | Alabama | 1095 | 1275 | 9 |
271993 | 271993 | 2020-06-25 | Marshall | Illinois | 17123 | 7 | 0 |
272086 | 272086 | 2020-06-25 | Marshall | Indiana | 18099 | 385 | 3 |
272192 | 272192 | 2020-06-25 | Marshall | Iowa | 19127 | 994 | 18 |
272280 | 272280 | 2020-06-25 | Marshall | Kansas | 20117 | 1 | 0 |
272398 | 272398 | 2020-06-25 | Marshall | Kentucky | 21157 | 53 | 2 |
272689 | 272689 | 2020-06-25 | Marshall | Minnesota | 27089 | 12 | 0 |
272780 | 272780 | 2020-06-25 | Marshall | Mississippi | 28093 | 160 | 3 |
273465 | 273465 | 2020-06-25 | Marshall | Oklahoma | 40095 | 25 | 0 |
273766 | 273766 | 2020-06-25 | Marshall | South Dakota | 46091 | 5 | 0 |
273844 | 273844 | 2020-06-25 | Marshall | Tennessee | 47117 | 49 | 1 |
274366 | 274366 | 2020-06-25 | Marshall | West Virginia | 54051 | 39 | 0 |
268265 | 268265 | 2020-06-24 | Marshall | Alabama | 1095 | 1192 | 9 |
268856 | 268856 | 2020-06-24 | Marshall | Illinois | 17123 | 6 | 0 |
268949 | 268949 | 2020-06-24 | Marshall | Indiana | 18099 | 374 | 3 |
269055 | 269055 | 2020-06-24 | Marshall | Iowa | 19127 | 989 | 18 |
269143 | 269143 | 2020-06-24 | Marshall | Kansas | 20117 | 1 | 0 |
269262 | 269262 | 2020-06-24 | Marshall | Kentucky | 21157 | 53 | 2 |
269552 | 269552 | 2020-06-24 | Marshall | Minnesota | 27089 | 12 | 0 |
269642 | 269642 | 2020-06-24 | Marshall | Mississippi | 28093 | 148 | 3 |
270326 | 270326 | 2020-06-24 | Marshall | Oklahoma | 40095 | 25 | 0 |
270627 | 270627 | 2020-06-24 | Marshall | South Dakota | 46091 | 5 | 0 |
270705 | 270705 | 2020-06-24 | Marshall | Tennessee | 47117 | 49 | 1 |
271226 | 271226 | 2020-06-24 | Marshall | West Virginia | 54051 | 39 | 0 |
265136 | 265136 | 2020-06-23 | Marshall | Alabama | 1095 | 1148 | 9 |
265726 | 265726 | 2020-06-23 | Marshall | Illinois | 17123 | 6 | 0 |
265819 | 265819 | 2020-06-23 | Marshall | Indiana | 18099 | 369 | 3 |
265925 | 265925 | 2020-06-23 | Marshall | Iowa | 19127 | 978 | 18 |
266129 | 266129 | 2020-06-23 | Marshall | Kentucky | 21157 | 53 | 2 |
266419 | 266419 | 2020-06-23 | Marshall | Minnesota | 27089 | 12 | 0 |
266509 | 266509 | 2020-06-23 | Marshall | Mississippi | 28093 | 144 | 3 |
267192 | 267192 | 2020-06-23 | Marshall | Oklahoma | 40095 | 25 | 0 |
267493 | 267493 | 2020-06-23 | Marshall | South Dakota | 46091 | 5 | 0 |
267571 | 267571 | 2020-06-23 | Marshall | Tennessee | 47117 | 48 | 1 |
268092 | 268092 | 2020-06-23 | Marshall | West Virginia | 54051 | 39 | 0 |
262007 | 262007 | 2020-06-22 | Marshall | Alabama | 1095 | 1104 | 9 |
262598 | 262598 | 2020-06-22 | Marshall | Illinois | 17123 | 6 | 0 |
262691 | 262691 | 2020-06-22 | Marshall | Indiana | 18099 | 365 | 3 |
262797 | 262797 | 2020-06-22 | Marshall | Iowa | 19127 | 976 | 18 |
263002 | 263002 | 2020-06-22 | Marshall | Kentucky | 21157 | 52 | 2 |
263293 | 263293 | 2020-06-22 | Marshall | Minnesota | 27089 | 12 | 0 |
263383 | 263383 | 2020-06-22 | Marshall | Mississippi | 28093 | 142 | 3 |
264064 | 264064 | 2020-06-22 | Marshall | Oklahoma | 40095 | 23 | 0 |
264365 | 264365 | 2020-06-22 | Marshall | South Dakota | 46091 | 5 | 0 |
264443 | 264443 | 2020-06-22 | Marshall | Tennessee | 47117 | 46 | 1 |
264963 | 264963 | 2020-06-22 | Marshall | West Virginia | 54051 | 39 | 0 |
258880 | 258880 | 2020-06-21 | Marshall | Alabama | 1095 | 1082 | 9 |
259471 | 259471 | 2020-06-21 | Marshall | Illinois | 17123 | 6 | 0 |
259564 | 259564 | 2020-06-21 | Marshall | Indiana | 18099 | 359 | 3 |
259670 | 259670 | 2020-06-21 | Marshall | Iowa | 19127 | 974 | 18 |
259873 | 259873 | 2020-06-21 | Marshall | Kentucky | 21157 | 50 | 2 |
260164 | 260164 | 2020-06-21 | Marshall | Minnesota | 27089 | 12 | 0 |
260254 | 260254 | 2020-06-21 | Marshall | Mississippi | 28093 | 122 | 3 |
260936 | 260936 | 2020-06-21 | Marshall | Oklahoma | 40095 | 22 | 0 |
261237 | 261237 | 2020-06-21 | Marshall | South Dakota | 46091 | 5 | 0 |
261315 | 261315 | 2020-06-21 | Marshall | Tennessee | 47117 | 46 | 1 |
261834 | 261834 | 2020-06-21 | Marshall | West Virginia | 54051 | 37 | 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);