ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where county = "Marshall", deaths = 32 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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);