ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,218 rows where county = "Marshall" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: deaths, date (date)

fips

county

  • Marshall · 1,218 ✖
Link rowid date ▲ county state fips cases deaths
334423 334423 2020-07-15 Marshall Alabama 1095 2149 13
335026 335026 2020-07-15 Marshall Illinois 17123 13 0
335120 335120 2020-07-15 Marshall Indiana 18099 601 12
335226 335226 2020-07-15 Marshall Iowa 19127 1125 19
335320 335320 2020-07-15 Marshall Kansas 20117 7 0
335440 335440 2020-07-15 Marshall Kentucky 21157 81 2
335733 335733 2020-07-15 Marshall Minnesota 27089 17 0
335824 335824 2020-07-15 Marshall Mississippi 28093 310 4
336529 336529 2020-07-15 Marshall Oklahoma 40095 49 0
336835 336835 2020-07-15 Marshall South Dakota 46091 5 0
336914 336914 2020-07-15 Marshall Tennessee 47117 141 2
337442 337442 2020-07-15 Marshall West Virginia 54051 72 0
331232 331232 2020-07-14 Marshall Alabama 1095 2105 12
331835 331835 2020-07-14 Marshall Illinois 17123 13 0
331929 331929 2020-07-14 Marshall Indiana 18099 574 12
332035 332035 2020-07-14 Marshall Iowa 19127 1105 19
332129 332129 2020-07-14 Marshall Kansas 20117 6 0
332249 332249 2020-07-14 Marshall Kentucky 21157 74 2
332542 332542 2020-07-14 Marshall Minnesota 27089 16 0
332633 332633 2020-07-14 Marshall Mississippi 28093 307 4
333337 333337 2020-07-14 Marshall Oklahoma 40095 47 0
333643 333643 2020-07-14 Marshall South Dakota 46091 5 0
333722 333722 2020-07-14 Marshall Tennessee 47117 132 2
334249 334249 2020-07-14 Marshall West Virginia 54051 68 0
328048 328048 2020-07-13 Marshall Alabama 1095 2065 12
328650 328650 2020-07-13 Marshall Illinois 17123 12 0
328744 328744 2020-07-13 Marshall Indiana 18099 570 11
328850 328850 2020-07-13 Marshall Iowa 19127 1100 19
328944 328944 2020-07-13 Marshall Kansas 20117 6 0
329064 329064 2020-07-13 Marshall Kentucky 21157 72 2
329357 329357 2020-07-13 Marshall Minnesota 27089 16 0
329448 329448 2020-07-13 Marshall Mississippi 28093 297 3
330147 330147 2020-07-13 Marshall Oklahoma 40095 43 0
330453 330453 2020-07-13 Marshall South Dakota 46091 5 0
330532 330532 2020-07-13 Marshall Tennessee 47117 123 2
331058 331058 2020-07-13 Marshall West Virginia 54051 66 0
324864 324864 2020-07-12 Marshall Alabama 1095 1996 11
325466 325466 2020-07-12 Marshall Illinois 17123 12 0
325560 325560 2020-07-12 Marshall Indiana 18099 557 9
325666 325666 2020-07-12 Marshall Iowa 19127 1100 19
325760 325760 2020-07-12 Marshall Kansas 20117 6 0
325880 325880 2020-07-12 Marshall Kentucky 21157 70 2
326173 326173 2020-07-12 Marshall Minnesota 27089 16 0
326264 326264 2020-07-12 Marshall Mississippi 28093 292 3
326962 326962 2020-07-12 Marshall Oklahoma 40095 43 0
327269 327269 2020-07-12 Marshall South Dakota 46091 5 0
327348 327348 2020-07-12 Marshall Tennessee 47117 118 2
327874 327874 2020-07-12 Marshall West Virginia 54051 65 0
321685 321685 2020-07-11 Marshall Alabama 1095 1942 11
322287 322287 2020-07-11 Marshall Illinois 17123 12 0
322381 322381 2020-07-11 Marshall Indiana 18099 544 9
322487 322487 2020-07-11 Marshall Iowa 19127 1093 19
322579 322579 2020-07-11 Marshall Kansas 20117 2 0
322699 322699 2020-07-11 Marshall Kentucky 21157 69 2
322992 322992 2020-07-11 Marshall Minnesota 27089 13 0
323083 323083 2020-07-11 Marshall Mississippi 28093 277 3
323779 323779 2020-07-11 Marshall Oklahoma 40095 43 0
324086 324086 2020-07-11 Marshall South Dakota 46091 5 0
324165 324165 2020-07-11 Marshall Tennessee 47117 115 2
324690 324690 2020-07-11 Marshall West Virginia 54051 63 0
318508 318508 2020-07-10 Marshall Alabama 1095 1918 11
319110 319110 2020-07-10 Marshall Illinois 17123 12 0
319204 319204 2020-07-10 Marshall Indiana 18099 530 8
319310 319310 2020-07-10 Marshall Iowa 19127 1080 19
319402 319402 2020-07-10 Marshall Kansas 20117 2 0
319522 319522 2020-07-10 Marshall Kentucky 21157 68 2
319815 319815 2020-07-10 Marshall Minnesota 27089 12 0
319906 319906 2020-07-10 Marshall Mississippi 28093 276 3
320601 320601 2020-07-10 Marshall Oklahoma 40095 43 0
320908 320908 2020-07-10 Marshall South Dakota 46091 5 0
320986 320986 2020-07-10 Marshall Tennessee 47117 108 2
321511 321511 2020-07-10 Marshall West Virginia 54051 58 0
315337 315337 2020-07-09 Marshall Alabama 1095 1879 11
315939 315939 2020-07-09 Marshall Illinois 17123 12 0
316033 316033 2020-07-09 Marshall Indiana 18099 521 7
316139 316139 2020-07-09 Marshall Iowa 19127 1068 19
316230 316230 2020-07-09 Marshall Kansas 20117 2 0
316349 316349 2020-07-09 Marshall Kentucky 21157 66 2
316642 316642 2020-07-09 Marshall Minnesota 27089 12 0
316733 316733 2020-07-09 Marshall Mississippi 28093 269 3
317426 317426 2020-07-09 Marshall Oklahoma 40095 43 0
317732 317732 2020-07-09 Marshall South Dakota 46091 5 0
317810 317810 2020-07-09 Marshall Tennessee 47117 104 2
318334 318334 2020-07-09 Marshall West Virginia 54051 55 0
312164 312164 2020-07-08 Marshall Alabama 1095 1826 11
312767 312767 2020-07-08 Marshall Illinois 17123 12 0
312861 312861 2020-07-08 Marshall Indiana 18099 501 6
312967 312967 2020-07-08 Marshall Iowa 19127 1063 19
313058 313058 2020-07-08 Marshall Kansas 20117 2 0
313177 313177 2020-07-08 Marshall Kentucky 21157 66 2
313470 313470 2020-07-08 Marshall Minnesota 27089 12 0
313561 313561 2020-07-08 Marshall Mississippi 28093 264 3
314255 314255 2020-07-08 Marshall Oklahoma 40095 43 0
314561 314561 2020-07-08 Marshall South Dakota 46091 5 0
314639 314639 2020-07-08 Marshall Tennessee 47117 101 1
315163 315163 2020-07-08 Marshall West Virginia 54051 49 0
308997 308997 2020-07-07 Marshall Alabama 1095 1781 11
309599 309599 2020-07-07 Marshall Illinois 17123 12 0
309693 309693 2020-07-07 Marshall Indiana 18099 492 6
309799 309799 2020-07-07 Marshall Iowa 19127 1060 19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1090.422ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette