ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where county = "Marshall" and deaths = 37 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Kansas 28
- Iowa 7
- Mississippi 4
- West Virginia 3
- Kentucky 2
- Alabama 1
county 1
- Marshall · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126342 | 2126342 | 2022-01-18 | Marshall | Kansas | 20117 | 2188 | 37 |
2123090 | 2123090 | 2022-01-17 | Marshall | Kansas | 20117 | 2188 | 37 |
2119838 | 2119838 | 2022-01-16 | Marshall | Kansas | 20117 | 2188 | 37 |
2116586 | 2116586 | 2022-01-15 | Marshall | Kansas | 20117 | 2188 | 37 |
2113335 | 2113335 | 2022-01-14 | Marshall | Kansas | 20117 | 2188 | 37 |
2110083 | 2110083 | 2022-01-13 | Marshall | Kansas | 20117 | 2140 | 37 |
2106832 | 2106832 | 2022-01-12 | Marshall | Kansas | 20117 | 2140 | 37 |
2103581 | 2103581 | 2022-01-11 | Marshall | Kansas | 20117 | 2089 | 37 |
2100330 | 2100330 | 2022-01-10 | Marshall | Kansas | 20117 | 2089 | 37 |
2097079 | 2097079 | 2022-01-09 | Marshall | Kansas | 20117 | 2059 | 37 |
2093827 | 2093827 | 2022-01-08 | Marshall | Kansas | 20117 | 2059 | 37 |
2090575 | 2090575 | 2022-01-07 | Marshall | Kansas | 20117 | 2059 | 37 |
2087324 | 2087324 | 2022-01-06 | Marshall | Kansas | 20117 | 2026 | 37 |
2084072 | 2084072 | 2022-01-05 | Marshall | Kansas | 20117 | 2026 | 37 |
2080820 | 2080820 | 2022-01-04 | Marshall | Kansas | 20117 | 1998 | 37 |
2077568 | 2077568 | 2022-01-03 | Marshall | Kansas | 20117 | 1998 | 37 |
2074317 | 2074317 | 2022-01-02 | Marshall | Kansas | 20117 | 1972 | 37 |
2071066 | 2071066 | 2022-01-01 | Marshall | Kansas | 20117 | 1972 | 37 |
2067815 | 2067815 | 2021-12-31 | Marshall | Kansas | 20117 | 1972 | 37 |
2064564 | 2064564 | 2021-12-30 | Marshall | Kansas | 20117 | 1972 | 37 |
2061314 | 2061314 | 2021-12-29 | Marshall | Kansas | 20117 | 1972 | 37 |
2058065 | 2058065 | 2021-12-28 | Marshall | Kansas | 20117 | 1957 | 37 |
2054816 | 2054816 | 2021-12-27 | Marshall | Kansas | 20117 | 1957 | 37 |
2051566 | 2051566 | 2021-12-26 | Marshall | Kansas | 20117 | 1951 | 37 |
2048316 | 2048316 | 2021-12-25 | Marshall | Kansas | 20117 | 1951 | 37 |
2045066 | 2045066 | 2021-12-24 | Marshall | Kansas | 20117 | 1951 | 37 |
2041817 | 2041817 | 2021-12-23 | Marshall | Kansas | 20117 | 1951 | 37 |
2038567 | 2038567 | 2021-12-22 | Marshall | Kansas | 20117 | 1951 | 37 |
996160 | 996160 | 2021-02-04 | Marshall | Kentucky | 21157 | 2323 | 37 |
992914 | 992914 | 2021-02-03 | Marshall | Kentucky | 21157 | 2293 | 37 |
829443 | 829443 | 2020-12-14 | Marshall | West Virginia | 54051 | 1660 | 37 |
826197 | 826197 | 2020-12-13 | Marshall | West Virginia | 54051 | 1643 | 37 |
822950 | 822950 | 2020-12-12 | Marshall | West Virginia | 54051 | 1625 | 37 |
720689 | 720689 | 2020-11-11 | Marshall | Mississippi | 28093 | 1761 | 37 |
717446 | 717446 | 2020-11-10 | Marshall | Mississippi | 28093 | 1731 | 37 |
713599 | 713599 | 2020-11-09 | Marshall | Iowa | 19127 | 2642 | 37 |
714202 | 714202 | 2020-11-09 | Marshall | Mississippi | 28093 | 1709 | 37 |
710355 | 710355 | 2020-11-08 | Marshall | Iowa | 19127 | 2588 | 37 |
710958 | 710958 | 2020-11-08 | Marshall | Mississippi | 28093 | 1684 | 37 |
707111 | 707111 | 2020-11-07 | Marshall | Iowa | 19127 | 2540 | 37 |
703868 | 703868 | 2020-11-06 | Marshall | Iowa | 19127 | 2477 | 37 |
700626 | 700626 | 2020-11-05 | Marshall | Iowa | 19127 | 2422 | 37 |
697382 | 697382 | 2020-11-04 | Marshall | Iowa | 19127 | 2356 | 37 |
694140 | 694140 | 2020-11-03 | Marshall | Iowa | 19127 | 2324 | 37 |
414946 | 414946 | 2020-08-09 | Marshall | Alabama | 1095 | 3253 | 37 |
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);