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

Suggested facets: deaths, date (date)

fips

county

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