ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where county = "McPherson", deaths = 7 and state = "South Dakota" 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 |
---|---|---|---|---|---|---|---|
1962108 | 1962108 | 2021-11-28 | McPherson | South Dakota | 46089 | 352 | 7 |
1958857 | 1958857 | 2021-11-27 | McPherson | South Dakota | 46089 | 352 | 7 |
1955606 | 1955606 | 2021-11-26 | McPherson | South Dakota | 46089 | 352 | 7 |
1952355 | 1952355 | 2021-11-25 | McPherson | South Dakota | 46089 | 352 | 7 |
1949104 | 1949104 | 2021-11-24 | McPherson | South Dakota | 46089 | 352 | 7 |
1945853 | 1945853 | 2021-11-23 | McPherson | South Dakota | 46089 | 351 | 7 |
1942602 | 1942602 | 2021-11-22 | McPherson | South Dakota | 46089 | 350 | 7 |
1939352 | 1939352 | 2021-11-21 | McPherson | South Dakota | 46089 | 348 | 7 |
1936102 | 1936102 | 2021-11-20 | McPherson | South Dakota | 46089 | 348 | 7 |
1932852 | 1932852 | 2021-11-19 | McPherson | South Dakota | 46089 | 348 | 7 |
1929601 | 1929601 | 2021-11-18 | McPherson | South Dakota | 46089 | 348 | 7 |
1926351 | 1926351 | 2021-11-17 | McPherson | South Dakota | 46089 | 347 | 7 |
1923101 | 1923101 | 2021-11-16 | McPherson | South Dakota | 46089 | 345 | 7 |
1919852 | 1919852 | 2021-11-15 | McPherson | South Dakota | 46089 | 345 | 7 |
1916602 | 1916602 | 2021-11-14 | McPherson | South Dakota | 46089 | 343 | 7 |
1913352 | 1913352 | 2021-11-13 | McPherson | South Dakota | 46089 | 343 | 7 |
1910102 | 1910102 | 2021-11-12 | McPherson | South Dakota | 46089 | 343 | 7 |
1906853 | 1906853 | 2021-11-11 | McPherson | South Dakota | 46089 | 339 | 7 |
1903604 | 1903604 | 2021-11-10 | McPherson | South Dakota | 46089 | 339 | 7 |
1900354 | 1900354 | 2021-11-09 | McPherson | South Dakota | 46089 | 338 | 7 |
1897104 | 1897104 | 2021-11-08 | McPherson | South Dakota | 46089 | 336 | 7 |
1893854 | 1893854 | 2021-11-07 | McPherson | South Dakota | 46089 | 333 | 7 |
1890604 | 1890604 | 2021-11-06 | McPherson | South Dakota | 46089 | 333 | 7 |
1887354 | 1887354 | 2021-11-05 | McPherson | South Dakota | 46089 | 333 | 7 |
1884104 | 1884104 | 2021-11-04 | McPherson | South Dakota | 46089 | 331 | 7 |
1880855 | 1880855 | 2021-11-03 | McPherson | South Dakota | 46089 | 330 | 7 |
1877606 | 1877606 | 2021-11-02 | McPherson | South Dakota | 46089 | 325 | 7 |
1874357 | 1874357 | 2021-11-01 | McPherson | South Dakota | 46089 | 324 | 7 |
1871108 | 1871108 | 2021-10-31 | McPherson | South Dakota | 46089 | 324 | 7 |
1867859 | 1867859 | 2021-10-30 | McPherson | South Dakota | 46089 | 324 | 7 |
1864610 | 1864610 | 2021-10-29 | McPherson | South Dakota | 46089 | 324 | 7 |
1861361 | 1861361 | 2021-10-28 | McPherson | South Dakota | 46089 | 323 | 7 |
1858112 | 1858112 | 2021-10-27 | McPherson | South Dakota | 46089 | 321 | 7 |
1854863 | 1854863 | 2021-10-26 | McPherson | South Dakota | 46089 | 320 | 7 |
1851614 | 1851614 | 2021-10-25 | McPherson | South Dakota | 46089 | 315 | 7 |
1848364 | 1848364 | 2021-10-24 | McPherson | South Dakota | 46089 | 315 | 7 |
1845114 | 1845114 | 2021-10-23 | McPherson | South Dakota | 46089 | 315 | 7 |
1841864 | 1841864 | 2021-10-22 | McPherson | South Dakota | 46089 | 315 | 7 |
1838615 | 1838615 | 2021-10-21 | McPherson | South Dakota | 46089 | 313 | 7 |
1835366 | 1835366 | 2021-10-20 | McPherson | South Dakota | 46089 | 313 | 7 |
1832117 | 1832117 | 2021-10-19 | McPherson | South Dakota | 46089 | 313 | 7 |
1828868 | 1828868 | 2021-10-18 | McPherson | South Dakota | 46089 | 313 | 7 |
1825619 | 1825619 | 2021-10-17 | McPherson | South Dakota | 46089 | 312 | 7 |
1822370 | 1822370 | 2021-10-16 | McPherson | South Dakota | 46089 | 312 | 7 |
1819121 | 1819121 | 2021-10-15 | McPherson | South Dakota | 46089 | 312 | 7 |
1815872 | 1815872 | 2021-10-14 | McPherson | South Dakota | 46089 | 310 | 7 |
1812624 | 1812624 | 2021-10-13 | McPherson | South Dakota | 46089 | 308 | 7 |
1809375 | 1809375 | 2021-10-12 | McPherson | South Dakota | 46089 | 307 | 7 |
1806125 | 1806125 | 2021-10-11 | McPherson | South Dakota | 46089 | 307 | 7 |
1802875 | 1802875 | 2021-10-10 | McPherson | South Dakota | 46089 | 307 | 7 |
1799626 | 1799626 | 2021-10-09 | McPherson | South Dakota | 46089 | 307 | 7 |
1796377 | 1796377 | 2021-10-08 | McPherson | South Dakota | 46089 | 307 | 7 |
1793128 | 1793128 | 2021-10-07 | McPherson | South Dakota | 46089 | 307 | 7 |
1789879 | 1789879 | 2021-10-06 | McPherson | South Dakota | 46089 | 307 | 7 |
1786631 | 1786631 | 2021-10-05 | McPherson | South Dakota | 46089 | 306 | 7 |
1783382 | 1783382 | 2021-10-04 | McPherson | South Dakota | 46089 | 305 | 7 |
1780133 | 1780133 | 2021-10-03 | McPherson | South Dakota | 46089 | 302 | 7 |
1776883 | 1776883 | 2021-10-02 | McPherson | South Dakota | 46089 | 302 | 7 |
1773633 | 1773633 | 2021-10-01 | McPherson | South Dakota | 46089 | 302 | 7 |
1770383 | 1770383 | 2021-09-30 | McPherson | South Dakota | 46089 | 301 | 7 |
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);