ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where county = "Marshall", deaths = 36 and fips = 19127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
690897 | 690897 | 2020-11-02 | Marshall | Iowa | 19127 | 2278 | 36 |
687652 | 687652 | 2020-11-01 | Marshall | Iowa | 19127 | 2246 | 36 |
684408 | 684408 | 2020-10-31 | Marshall | Iowa | 19127 | 2216 | 36 |
681165 | 681165 | 2020-10-30 | Marshall | Iowa | 19127 | 2178 | 36 |
677922 | 677922 | 2020-10-29 | Marshall | Iowa | 19127 | 2123 | 36 |
674679 | 674679 | 2020-10-28 | Marshall | Iowa | 19127 | 2094 | 36 |
671437 | 671437 | 2020-10-27 | Marshall | Iowa | 19127 | 2048 | 36 |
668194 | 668194 | 2020-10-26 | Marshall | Iowa | 19127 | 2020 | 36 |
664950 | 664950 | 2020-10-25 | Marshall | Iowa | 19127 | 2014 | 36 |
661705 | 661705 | 2020-10-24 | Marshall | Iowa | 19127 | 1996 | 36 |
658461 | 658461 | 2020-10-23 | Marshall | Iowa | 19127 | 1987 | 36 |
655216 | 655216 | 2020-10-22 | Marshall | Iowa | 19127 | 1963 | 36 |
651971 | 651971 | 2020-10-21 | Marshall | Iowa | 19127 | 1947 | 36 |
648727 | 648727 | 2020-10-20 | Marshall | Iowa | 19127 | 1937 | 36 |
645482 | 645482 | 2020-10-19 | Marshall | Iowa | 19127 | 1926 | 36 |
642235 | 642235 | 2020-10-18 | Marshall | Iowa | 19127 | 1922 | 36 |
638988 | 638988 | 2020-10-17 | Marshall | Iowa | 19127 | 1914 | 36 |
635742 | 635742 | 2020-10-16 | Marshall | Iowa | 19127 | 1911 | 36 |
632496 | 632496 | 2020-10-15 | Marshall | Iowa | 19127 | 1893 | 36 |
629252 | 629252 | 2020-10-14 | Marshall | Iowa | 19127 | 1883 | 36 |
626009 | 626009 | 2020-10-13 | Marshall | Iowa | 19127 | 1877 | 36 |
622767 | 622767 | 2020-10-12 | Marshall | Iowa | 19127 | 1873 | 36 |
619523 | 619523 | 2020-10-11 | Marshall | Iowa | 19127 | 1868 | 36 |
616281 | 616281 | 2020-10-10 | Marshall | Iowa | 19127 | 1863 | 36 |
613040 | 613040 | 2020-10-09 | Marshall | Iowa | 19127 | 1860 | 36 |
609798 | 609798 | 2020-10-08 | Marshall | Iowa | 19127 | 1854 | 36 |
606555 | 606555 | 2020-10-07 | Marshall | Iowa | 19127 | 1845 | 36 |
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);