ny_times_us_counties

Table actions
⚠️ 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

9,222 rows where county = "Marshall" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 12

fips 12

county 1

  • Marshall · 9,222 ✖
Link rowid date ▲ county state fips cases deaths
2499622 2499622 2022-05-13 Marshall Alabama 1095 27438 394
2500235 2500235 2022-05-13 Marshall Illinois 17123 2809 33
2500329 2500329 2022-05-13 Marshall Indiana 18099 12437 197
2500436 2500436 2022-05-13 Marshall Iowa 19127 9488 112
2500530 2500530 2022-05-13 Marshall Kansas 20117 2559 42
2500654 2500654 2022-05-13 Marshall Kentucky 21157 8421 112
2500948 2500948 2022-05-13 Marshall Minnesota 27089 2122 23
2501039 2501039 2022-05-13 Marshall Mississippi 28093 9941 174
2501777 2501777 2022-05-13 Marshall Oklahoma 40095 4603 46
2502087 2502087 2022-05-13 Marshall South Dakota 46091 796 13
2502167 2502167 2022-05-13 Marshall Tennessee 47117 10403 124
2502707 2502707 2022-05-13 Marshall West Virginia 54051 9085 155
2496364 2496364 2022-05-12 Marshall Alabama 1095 27430 394
2496977 2496977 2022-05-12 Marshall Illinois 17123 2806 33
2497071 2497071 2022-05-12 Marshall Indiana 18099 12427 197
2497178 2497178 2022-05-12 Marshall Iowa 19127 9488 112
2497272 2497272 2022-05-12 Marshall Kansas 20117 2559 42
2497396 2497396 2022-05-12 Marshall Kentucky 21157 8421 112
2497690 2497690 2022-05-12 Marshall Minnesota 27089 2120 23
2497781 2497781 2022-05-12 Marshall Mississippi 28093 9941 174
2498519 2498519 2022-05-12 Marshall Oklahoma 40095 4603 46
2498829 2498829 2022-05-12 Marshall South Dakota 46091 796 13
2498909 2498909 2022-05-12 Marshall Tennessee 47117 10403 124
2499449 2499449 2022-05-12 Marshall West Virginia 54051 9075 155
2493106 2493106 2022-05-11 Marshall Alabama 1095 27418 393
2493719 2493719 2022-05-11 Marshall Illinois 17123 2804 33
2493813 2493813 2022-05-11 Marshall Indiana 18099 12427 197
2493920 2493920 2022-05-11 Marshall Iowa 19127 9488 112
2494014 2494014 2022-05-11 Marshall Kansas 20117 2559 42
2494138 2494138 2022-05-11 Marshall Kentucky 21157 8421 112
2494432 2494432 2022-05-11 Marshall Minnesota 27089 2115 23
2494523 2494523 2022-05-11 Marshall Mississippi 28093 9941 174
2495261 2495261 2022-05-11 Marshall Oklahoma 40095 4604 46
2495571 2495571 2022-05-11 Marshall South Dakota 46091 796 13
2495651 2495651 2022-05-11 Marshall Tennessee 47117 10403 124
2496191 2496191 2022-05-11 Marshall West Virginia 54051 9070 155
2489848 2489848 2022-05-10 Marshall Alabama 1095 27414 393
2490461 2490461 2022-05-10 Marshall Illinois 17123 2803 33
2490555 2490555 2022-05-10 Marshall Indiana 18099 12415 197
2490662 2490662 2022-05-10 Marshall Iowa 19127 9456 111
2490756 2490756 2022-05-10 Marshall Kansas 20117 2559 42
2490880 2490880 2022-05-10 Marshall Kentucky 21157 8421 112
2491174 2491174 2022-05-10 Marshall Minnesota 27089 2115 23
2491265 2491265 2022-05-10 Marshall Mississippi 28093 9941 174
2492003 2492003 2022-05-10 Marshall Oklahoma 40095 4604 46
2492313 2492313 2022-05-10 Marshall South Dakota 46091 793 13
2492393 2492393 2022-05-10 Marshall Tennessee 47117 10385 124
2492933 2492933 2022-05-10 Marshall West Virginia 54051 9065 154
2486591 2486591 2022-05-09 Marshall Alabama 1095 27405 393
2487204 2487204 2022-05-09 Marshall Illinois 17123 2799 33
2487298 2487298 2022-05-09 Marshall Indiana 18099 12415 197
2487405 2487405 2022-05-09 Marshall Iowa 19127 9456 111
2487499 2487499 2022-05-09 Marshall Kansas 20117 2559 42
2487623 2487623 2022-05-09 Marshall Kentucky 21157 8421 112
2487917 2487917 2022-05-09 Marshall Minnesota 27089 2112 23
2488008 2488008 2022-05-09 Marshall Mississippi 28093 9941 174
2488745 2488745 2022-05-09 Marshall Oklahoma 40095 4604 46
2489055 2489055 2022-05-09 Marshall South Dakota 46091 793 13
2489135 2489135 2022-05-09 Marshall Tennessee 47117 10385 124
2489675 2489675 2022-05-09 Marshall West Virginia 54051 9065 154
2483333 2483333 2022-05-08 Marshall Alabama 1095 27399 393
2483946 2483946 2022-05-08 Marshall Illinois 17123 2795 33
2484040 2484040 2022-05-08 Marshall Indiana 18099 12400 197
2484147 2484147 2022-05-08 Marshall Iowa 19127 9456 111
2484241 2484241 2022-05-08 Marshall Kansas 20117 2559 42
2484365 2484365 2022-05-08 Marshall Kentucky 21157 8416 106
2484659 2484659 2022-05-08 Marshall Minnesota 27089 2110 23
2484750 2484750 2022-05-08 Marshall Mississippi 28093 9922 174
2485488 2485488 2022-05-08 Marshall Oklahoma 40095 4604 46
2485798 2485798 2022-05-08 Marshall South Dakota 46091 793 13
2485878 2485878 2022-05-08 Marshall Tennessee 47117 10385 124
2486418 2486418 2022-05-08 Marshall West Virginia 54051 9050 154
2480075 2480075 2022-05-07 Marshall Alabama 1095 27399 393
2480688 2480688 2022-05-07 Marshall Illinois 17123 2795 33
2480782 2480782 2022-05-07 Marshall Indiana 18099 12400 197
2480889 2480889 2022-05-07 Marshall Iowa 19127 9456 111
2480983 2480983 2022-05-07 Marshall Kansas 20117 2559 42
2481107 2481107 2022-05-07 Marshall Kentucky 21157 8416 106
2481401 2481401 2022-05-07 Marshall Minnesota 27089 2110 23
2481492 2481492 2022-05-07 Marshall Mississippi 28093 9922 174
2482230 2482230 2022-05-07 Marshall Oklahoma 40095 4604 46
2482540 2482540 2022-05-07 Marshall South Dakota 46091 793 13
2482620 2482620 2022-05-07 Marshall Tennessee 47117 10385 124
2483160 2483160 2022-05-07 Marshall West Virginia 54051 9050 154
2476817 2476817 2022-05-06 Marshall Alabama 1095 27399 393
2477430 2477430 2022-05-06 Marshall Illinois 17123 2795 33
2477524 2477524 2022-05-06 Marshall Indiana 18099 12400 197
2477631 2477631 2022-05-06 Marshall Iowa 19127 9456 111
2477725 2477725 2022-05-06 Marshall Kansas 20117 2559 42
2477849 2477849 2022-05-06 Marshall Kentucky 21157 8416 106
2478143 2478143 2022-05-06 Marshall Minnesota 27089 2110 23
2478234 2478234 2022-05-06 Marshall Mississippi 28093 9922 174
2478972 2478972 2022-05-06 Marshall Oklahoma 40095 4604 46
2479282 2479282 2022-05-06 Marshall South Dakota 46091 793 13
2479362 2479362 2022-05-06 Marshall Tennessee 47117 10385 124
2479902 2479902 2022-05-06 Marshall West Virginia 54051 9050 154
2473559 2473559 2022-05-05 Marshall Alabama 1095 27398 393
2474172 2474172 2022-05-05 Marshall Illinois 17123 2791 33
2474266 2474266 2022-05-05 Marshall Indiana 18099 12400 197
2474373 2474373 2022-05-05 Marshall Iowa 19127 9456 111

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
);
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);