ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "Marshall" and deaths = 34 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
- Iowa 14
- Kansas 7
- Oklahoma 7
- Indiana 4
- Mississippi 4
- Tennessee 2
- Alabama 1
- Kentucky 1
- West Virginia 1
county 1
- Marshall · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2218678 | 2218678 | 2022-02-15 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2215427 | 2215427 | 2022-02-14 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2212176 | 2212176 | 2022-02-13 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2208923 | 2208923 | 2022-02-12 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2205670 | 2205670 | 2022-02-11 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2202417 | 2202417 | 2022-02-10 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2199163 | 2199163 | 2022-02-09 | Marshall | Oklahoma | 40095 | 4444 | 34 |
2019063 | 2019063 | 2021-12-16 | Marshall | Kansas | 20117 | 1912 | 34 |
2015813 | 2015813 | 2021-12-15 | Marshall | Kansas | 20117 | 1912 | 34 |
2012562 | 2012562 | 2021-12-14 | Marshall | Kansas | 20117 | 1898 | 34 |
2009311 | 2009311 | 2021-12-13 | Marshall | Kansas | 20117 | 1898 | 34 |
2006060 | 2006060 | 2021-12-12 | Marshall | Kansas | 20117 | 1889 | 34 |
2002809 | 2002809 | 2021-12-11 | Marshall | Kansas | 20117 | 1889 | 34 |
1999559 | 1999559 | 2021-12-10 | Marshall | Kansas | 20117 | 1889 | 34 |
976682 | 976682 | 2021-01-29 | Marshall | Kentucky | 21157 | 2211 | 34 |
923019 | 923019 | 2021-01-12 | Marshall | Tennessee | 47117 | 3243 | 34 |
919774 | 919774 | 2021-01-11 | Marshall | Tennessee | 47117 | 3223 | 34 |
809968 | 809968 | 2020-12-08 | Marshall | West Virginia | 54051 | 1538 | 34 |
736200 | 736200 | 2020-11-16 | Marshall | Indiana | 18099 | 2501 | 34 |
732954 | 732954 | 2020-11-15 | Marshall | Indiana | 18099 | 2452 | 34 |
729709 | 729709 | 2020-11-14 | Marshall | Indiana | 18099 | 2392 | 34 |
726466 | 726466 | 2020-11-13 | Marshall | Indiana | 18099 | 2263 | 34 |
704471 | 704471 | 2020-11-06 | Marshall | Mississippi | 28093 | 1650 | 34 |
701229 | 701229 | 2020-11-05 | Marshall | Mississippi | 28093 | 1639 | 34 |
697985 | 697985 | 2020-11-04 | Marshall | Mississippi | 28093 | 1602 | 34 |
694742 | 694742 | 2020-11-03 | Marshall | Mississippi | 28093 | 1595 | 34 |
580625 | 580625 | 2020-09-29 | Marshall | Iowa | 19127 | 1794 | 34 |
577384 | 577384 | 2020-09-28 | Marshall | Iowa | 19127 | 1791 | 34 |
574142 | 574142 | 2020-09-27 | Marshall | Iowa | 19127 | 1790 | 34 |
570899 | 570899 | 2020-09-26 | Marshall | Iowa | 19127 | 1784 | 34 |
567657 | 567657 | 2020-09-25 | Marshall | Iowa | 19127 | 1777 | 34 |
564417 | 564417 | 2020-09-24 | Marshall | Iowa | 19127 | 1770 | 34 |
561177 | 561177 | 2020-09-23 | Marshall | Iowa | 19127 | 1768 | 34 |
557941 | 557941 | 2020-09-22 | Marshall | Iowa | 19127 | 1764 | 34 |
554704 | 554704 | 2020-09-21 | Marshall | Iowa | 19127 | 1762 | 34 |
551465 | 551465 | 2020-09-20 | Marshall | Iowa | 19127 | 1761 | 34 |
548226 | 548226 | 2020-09-19 | Marshall | Iowa | 19127 | 1759 | 34 |
544988 | 544988 | 2020-09-18 | Marshall | Iowa | 19127 | 1756 | 34 |
541752 | 541752 | 2020-09-17 | Marshall | Iowa | 19127 | 1754 | 34 |
538515 | 538515 | 2020-09-16 | Marshall | Iowa | 19127 | 1749 | 34 |
398853 | 398853 | 2020-08-04 | Marshall | Alabama | 1095 | 3038 | 34 |
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);