ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where county = "Marshall" and deaths = 32 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- Kansas 23
- Iowa 18
- Oklahoma 14
- Illinois 13
- Kentucky 7
- West Virginia 4
- Mississippi 2
- Indiana 1
county 1
- Marshall · 82 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278917 | 2278917 | 2022-03-06 | Marshall | Illinois | 17123 | 2734 | 32 |
2275664 | 2275664 | 2022-03-05 | Marshall | Illinois | 17123 | 2734 | 32 |
2272411 | 2272411 | 2022-03-04 | Marshall | Illinois | 17123 | 2734 | 32 |
2269159 | 2269159 | 2022-03-03 | Marshall | Illinois | 17123 | 2732 | 32 |
2265906 | 2265906 | 2022-03-02 | Marshall | Illinois | 17123 | 2728 | 32 |
2262655 | 2262655 | 2022-03-01 | Marshall | Illinois | 17123 | 2726 | 32 |
2259404 | 2259404 | 2022-02-28 | Marshall | Illinois | 17123 | 2724 | 32 |
2256153 | 2256153 | 2022-02-27 | Marshall | Illinois | 17123 | 2719 | 32 |
2252902 | 2252902 | 2022-02-26 | Marshall | Illinois | 17123 | 2719 | 32 |
2249651 | 2249651 | 2022-02-25 | Marshall | Illinois | 17123 | 2719 | 32 |
2246400 | 2246400 | 2022-02-24 | Marshall | Illinois | 17123 | 2717 | 32 |
2243149 | 2243149 | 2022-02-23 | Marshall | Illinois | 17123 | 2712 | 32 |
2239898 | 2239898 | 2022-02-22 | Marshall | Illinois | 17123 | 2707 | 32 |
2195909 | 2195909 | 2022-02-08 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2192655 | 2192655 | 2022-02-07 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2189401 | 2189401 | 2022-02-06 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2186148 | 2186148 | 2022-02-05 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2182896 | 2182896 | 2022-02-04 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2179644 | 2179644 | 2022-02-03 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2176393 | 2176393 | 2022-02-02 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2173139 | 2173139 | 2022-02-01 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2169887 | 2169887 | 2022-01-31 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2166632 | 2166632 | 2022-01-30 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2163377 | 2163377 | 2022-01-29 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2160122 | 2160122 | 2022-01-28 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2156867 | 2156867 | 2022-01-27 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2153614 | 2153614 | 2022-01-26 | Marshall | Oklahoma | 40095 | 4141 | 32 |
1973557 | 1973557 | 2021-12-02 | Marshall | Kansas | 20117 | 1781 | 32 |
1970307 | 1970307 | 2021-12-01 | Marshall | Kansas | 20117 | 1781 | 32 |
1967057 | 1967057 | 2021-11-30 | Marshall | Kansas | 20117 | 1728 | 32 |
1963805 | 1963805 | 2021-11-29 | Marshall | Kansas | 20117 | 1728 | 32 |
1960554 | 1960554 | 2021-11-28 | Marshall | Kansas | 20117 | 1690 | 32 |
1957303 | 1957303 | 2021-11-27 | Marshall | Kansas | 20117 | 1690 | 32 |
1954052 | 1954052 | 2021-11-26 | Marshall | Kansas | 20117 | 1690 | 32 |
1950801 | 1950801 | 2021-11-25 | Marshall | Kansas | 20117 | 1690 | 32 |
1947550 | 1947550 | 2021-11-24 | Marshall | Kansas | 20117 | 1690 | 32 |
1944299 | 1944299 | 2021-11-23 | Marshall | Kansas | 20117 | 1654 | 32 |
1941049 | 1941049 | 2021-11-22 | Marshall | Kansas | 20117 | 1654 | 32 |
1937799 | 1937799 | 2021-11-21 | Marshall | Kansas | 20117 | 1636 | 32 |
1934549 | 1934549 | 2021-11-20 | Marshall | Kansas | 20117 | 1636 | 32 |
1931298 | 1931298 | 2021-11-19 | Marshall | Kansas | 20117 | 1636 | 32 |
1928047 | 1928047 | 2021-11-18 | Marshall | Kansas | 20117 | 1621 | 32 |
1924797 | 1924797 | 2021-11-17 | Marshall | Kansas | 20117 | 1621 | 32 |
1921548 | 1921548 | 2021-11-16 | Marshall | Kansas | 20117 | 1592 | 32 |
1918298 | 1918298 | 2021-11-15 | Marshall | Kansas | 20117 | 1592 | 32 |
1915048 | 1915048 | 2021-11-14 | Marshall | Kansas | 20117 | 1574 | 32 |
1911798 | 1911798 | 2021-11-13 | Marshall | Kansas | 20117 | 1574 | 32 |
1908549 | 1908549 | 2021-11-12 | Marshall | Kansas | 20117 | 1574 | 32 |
1905300 | 1905300 | 2021-11-11 | Marshall | Kansas | 20117 | 1557 | 32 |
1902050 | 1902050 | 2021-11-10 | Marshall | Kansas | 20117 | 1557 | 32 |
970192 | 970192 | 2021-01-27 | Marshall | Kentucky | 21157 | 2168 | 32 |
966948 | 966948 | 2021-01-26 | Marshall | Kentucky | 21157 | 2155 | 32 |
963703 | 963703 | 2021-01-25 | Marshall | Kentucky | 21157 | 2129 | 32 |
960458 | 960458 | 2021-01-24 | Marshall | Kentucky | 21157 | 2121 | 32 |
957212 | 957212 | 2021-01-23 | Marshall | Kentucky | 21157 | 2104 | 32 |
953967 | 953967 | 2021-01-22 | Marshall | Kentucky | 21157 | 2069 | 32 |
950722 | 950722 | 2021-01-21 | Marshall | Kentucky | 21157 | 2039 | 32 |
806723 | 806723 | 2020-12-07 | Marshall | West Virginia | 54051 | 1531 | 32 |
803478 | 803478 | 2020-12-06 | Marshall | West Virginia | 54051 | 1508 | 32 |
800233 | 800233 | 2020-12-05 | Marshall | West Virginia | 54051 | 1468 | 32 |
796988 | 796988 | 2020-12-04 | Marshall | West Virginia | 54051 | 1396 | 32 |
703762 | 703762 | 2020-11-06 | Marshall | Indiana | 18099 | 1872 | 32 |
691500 | 691500 | 2020-11-02 | Marshall | Mississippi | 28093 | 1567 | 32 |
688255 | 688255 | 2020-11-01 | Marshall | Mississippi | 28093 | 1548 | 32 |
535279 | 535279 | 2020-09-15 | Marshall | Iowa | 19127 | 1743 | 32 |
532044 | 532044 | 2020-09-14 | Marshall | Iowa | 19127 | 1741 | 32 |
528807 | 528807 | 2020-09-13 | Marshall | Iowa | 19127 | 1741 | 32 |
525571 | 525571 | 2020-09-12 | Marshall | Iowa | 19127 | 1738 | 32 |
522335 | 522335 | 2020-09-11 | Marshall | Iowa | 19127 | 1737 | 32 |
519098 | 519098 | 2020-09-10 | Marshall | Iowa | 19127 | 1732 | 32 |
515863 | 515863 | 2020-09-09 | Marshall | Iowa | 19127 | 1725 | 32 |
512630 | 512630 | 2020-09-08 | Marshall | Iowa | 19127 | 1723 | 32 |
509397 | 509397 | 2020-09-07 | Marshall | Iowa | 19127 | 1719 | 32 |
506165 | 506165 | 2020-09-06 | Marshall | Iowa | 19127 | 1714 | 32 |
502931 | 502931 | 2020-09-05 | Marshall | Iowa | 19127 | 1713 | 32 |
499697 | 499697 | 2020-09-04 | Marshall | Iowa | 19127 | 1695 | 32 |
496464 | 496464 | 2020-09-03 | Marshall | Iowa | 19127 | 1685 | 32 |
493230 | 493230 | 2020-09-02 | Marshall | Iowa | 19127 | 1667 | 32 |
489997 | 489997 | 2020-09-01 | Marshall | Iowa | 19127 | 1656 | 32 |
486764 | 486764 | 2020-08-31 | Marshall | Iowa | 19127 | 1647 | 32 |
483529 | 483529 | 2020-08-30 | Marshall | Iowa | 19127 | 1639 | 32 |
480295 | 480295 | 2020-08-29 | Marshall | Iowa | 19127 | 1632 | 32 |
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);