ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where county = "Marshall", deaths = 79 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716752 | 1716752 | 2021-09-14 | Marshall | Iowa | 19127 | 5501 | 79 |
1713506 | 1713506 | 2021-09-13 | Marshall | Iowa | 19127 | 5501 | 79 |
1710259 | 1710259 | 2021-09-12 | Marshall | Iowa | 19127 | 5501 | 79 |
1707012 | 1707012 | 2021-09-11 | Marshall | Iowa | 19127 | 5501 | 79 |
1703764 | 1703764 | 2021-09-10 | Marshall | Iowa | 19127 | 5501 | 79 |
1700514 | 1700514 | 2021-09-09 | Marshall | Iowa | 19127 | 5501 | 79 |
1697265 | 1697265 | 2021-09-08 | Marshall | Iowa | 19127 | 5501 | 79 |
1694017 | 1694017 | 2021-09-07 | Marshall | Iowa | 19127 | 5370 | 79 |
1690768 | 1690768 | 2021-09-06 | Marshall | Iowa | 19127 | 5370 | 79 |
1687518 | 1687518 | 2021-09-05 | Marshall | Iowa | 19127 | 5370 | 79 |
1684268 | 1684268 | 2021-09-04 | Marshall | Iowa | 19127 | 5370 | 79 |
1681017 | 1681017 | 2021-09-03 | Marshall | Iowa | 19127 | 5370 | 79 |
1677769 | 1677769 | 2021-09-02 | Marshall | Iowa | 19127 | 5370 | 79 |
1674522 | 1674522 | 2021-09-01 | Marshall | Iowa | 19127 | 5370 | 79 |
1671273 | 1671273 | 2021-08-31 | Marshall | Iowa | 19127 | 5241 | 79 |
1668026 | 1668026 | 2021-08-30 | Marshall | Iowa | 19127 | 5241 | 79 |
1664779 | 1664779 | 2021-08-29 | Marshall | Iowa | 19127 | 5241 | 79 |
1661531 | 1661531 | 2021-08-28 | Marshall | Iowa | 19127 | 5241 | 79 |
1658283 | 1658283 | 2021-08-27 | Marshall | Iowa | 19127 | 5241 | 79 |
1655035 | 1655035 | 2021-08-26 | Marshall | Iowa | 19127 | 5241 | 79 |
1651788 | 1651788 | 2021-08-25 | Marshall | Iowa | 19127 | 5241 | 79 |
1648539 | 1648539 | 2021-08-24 | Marshall | Iowa | 19127 | 5138 | 79 |
1645291 | 1645291 | 2021-08-23 | Marshall | Iowa | 19127 | 5138 | 79 |
1642042 | 1642042 | 2021-08-22 | Marshall | Iowa | 19127 | 5138 | 79 |
1638792 | 1638792 | 2021-08-21 | Marshall | Iowa | 19127 | 5138 | 79 |
1635542 | 1635542 | 2021-08-20 | Marshall | Iowa | 19127 | 5138 | 79 |
1632292 | 1632292 | 2021-08-19 | Marshall | Iowa | 19127 | 5138 | 79 |
1629045 | 1629045 | 2021-08-18 | Marshall | Iowa | 19127 | 5138 | 79 |
1625798 | 1625798 | 2021-08-17 | Marshall | Iowa | 19127 | 5035 | 79 |
1622551 | 1622551 | 2021-08-16 | Marshall | Iowa | 19127 | 5035 | 79 |
1619304 | 1619304 | 2021-08-15 | Marshall | Iowa | 19127 | 5035 | 79 |
1616056 | 1616056 | 2021-08-14 | Marshall | Iowa | 19127 | 5035 | 79 |
1612807 | 1612807 | 2021-08-13 | Marshall | Iowa | 19127 | 5035 | 79 |
1609559 | 1609559 | 2021-08-12 | Marshall | Iowa | 19127 | 5035 | 79 |
1606310 | 1606310 | 2021-08-11 | Marshall | Iowa | 19127 | 5035 | 79 |
1603061 | 1603061 | 2021-08-10 | Marshall | Iowa | 19127 | 4967 | 79 |
1599812 | 1599812 | 2021-08-09 | Marshall | Iowa | 19127 | 4967 | 79 |
1596564 | 1596564 | 2021-08-08 | Marshall | Iowa | 19127 | 4967 | 79 |
1593315 | 1593315 | 2021-08-07 | Marshall | Iowa | 19127 | 4967 | 79 |
1590066 | 1590066 | 2021-08-06 | Marshall | Iowa | 19127 | 4967 | 79 |
1586817 | 1586817 | 2021-08-05 | Marshall | Iowa | 19127 | 4967 | 79 |
1583567 | 1583567 | 2021-08-04 | Marshall | Iowa | 19127 | 4967 | 79 |
1580317 | 1580317 | 2021-08-03 | Marshall | Iowa | 19127 | 4936 | 79 |
1577068 | 1577068 | 2021-08-02 | Marshall | Iowa | 19127 | 4936 | 79 |
1573820 | 1573820 | 2021-08-01 | Marshall | Iowa | 19127 | 4936 | 79 |
1570572 | 1570572 | 2021-07-31 | Marshall | Iowa | 19127 | 4936 | 79 |
1567324 | 1567324 | 2021-07-30 | Marshall | Iowa | 19127 | 4936 | 79 |
1564076 | 1564076 | 2021-07-29 | Marshall | Iowa | 19127 | 4936 | 79 |
1560828 | 1560828 | 2021-07-28 | Marshall | Iowa | 19127 | 4936 | 79 |
1557581 | 1557581 | 2021-07-27 | Marshall | Iowa | 19127 | 4914 | 79 |
1554334 | 1554334 | 2021-07-26 | Marshall | Iowa | 19127 | 4914 | 79 |
1551087 | 1551087 | 2021-07-25 | Marshall | Iowa | 19127 | 4914 | 79 |
1547840 | 1547840 | 2021-07-24 | Marshall | Iowa | 19127 | 4914 | 79 |
1544593 | 1544593 | 2021-07-23 | Marshall | Iowa | 19127 | 4914 | 79 |
1541345 | 1541345 | 2021-07-22 | Marshall | Iowa | 19127 | 4914 | 79 |
1538098 | 1538098 | 2021-07-21 | Marshall | Iowa | 19127 | 4914 | 79 |
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);