ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 19013 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109932 | 2109932 | 2022-01-13 | Black Hawk | Iowa | 19013 | 27606 | 417 |
2106681 | 2106681 | 2022-01-12 | Black Hawk | Iowa | 19013 | 27606 | 417 |
2103430 | 2103430 | 2022-01-11 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2100179 | 2100179 | 2022-01-10 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2096928 | 2096928 | 2022-01-09 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2093676 | 2093676 | 2022-01-08 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2090424 | 2090424 | 2022-01-07 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2087173 | 2087173 | 2022-01-06 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2083921 | 2083921 | 2022-01-05 | Black Hawk | Iowa | 19013 | 25566 | 406 |
2080669 | 2080669 | 2022-01-04 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2077417 | 2077417 | 2022-01-03 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2074166 | 2074166 | 2022-01-02 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2070915 | 2070915 | 2022-01-01 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2067664 | 2067664 | 2021-12-31 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2064413 | 2064413 | 2021-12-30 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2061163 | 2061163 | 2021-12-29 | Black Hawk | Iowa | 19013 | 24357 | 399 |
2057914 | 2057914 | 2021-12-28 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2054665 | 2054665 | 2021-12-27 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2051415 | 2051415 | 2021-12-26 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2048165 | 2048165 | 2021-12-25 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2044915 | 2044915 | 2021-12-24 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2041666 | 2041666 | 2021-12-23 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2038416 | 2038416 | 2021-12-22 | Black Hawk | Iowa | 19013 | 23797 | 397 |
2035166 | 2035166 | 2021-12-21 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2031916 | 2031916 | 2021-12-20 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2028665 | 2028665 | 2021-12-19 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2025414 | 2025414 | 2021-12-18 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2022163 | 2022163 | 2021-12-17 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2018912 | 2018912 | 2021-12-16 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2015662 | 2015662 | 2021-12-15 | Black Hawk | Iowa | 19013 | 23355 | 394 |
2012411 | 2012411 | 2021-12-14 | Black Hawk | Iowa | 19013 | 22916 | 387 |
2009160 | 2009160 | 2021-12-13 | Black Hawk | Iowa | 19013 | 22916 | 387 |
2005909 | 2005909 | 2021-12-12 | Black Hawk | Iowa | 19013 | 22916 | 387 |
2002658 | 2002658 | 2021-12-11 | Black Hawk | Iowa | 19013 | 22916 | 387 |
1999408 | 1999408 | 2021-12-10 | Black Hawk | Iowa | 19013 | 22916 | 387 |
1996157 | 1996157 | 2021-12-09 | Black Hawk | Iowa | 19013 | 22916 | 387 |
1992906 | 1992906 | 2021-12-08 | Black Hawk | Iowa | 19013 | 22916 | 387 |
1989655 | 1989655 | 2021-12-07 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1986405 | 1986405 | 2021-12-06 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1983155 | 1983155 | 2021-12-05 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1979905 | 1979905 | 2021-12-04 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1976655 | 1976655 | 2021-12-03 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1973406 | 1973406 | 2021-12-02 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1970156 | 1970156 | 2021-12-01 | Black Hawk | Iowa | 19013 | 22380 | 382 |
1966906 | 1966906 | 2021-11-30 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1963654 | 1963654 | 2021-11-29 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1960403 | 1960403 | 2021-11-28 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1957152 | 1957152 | 2021-11-27 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1953901 | 1953901 | 2021-11-26 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1950650 | 1950650 | 2021-11-25 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1947399 | 1947399 | 2021-11-24 | Black Hawk | Iowa | 19013 | 22020 | 378 |
1944148 | 1944148 | 2021-11-23 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1940898 | 1940898 | 2021-11-22 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1937648 | 1937648 | 2021-11-21 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1934398 | 1934398 | 2021-11-20 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1931147 | 1931147 | 2021-11-19 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1927896 | 1927896 | 2021-11-18 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1924646 | 1924646 | 2021-11-17 | Black Hawk | Iowa | 19013 | 21661 | 371 |
1921397 | 1921397 | 2021-11-16 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1918147 | 1918147 | 2021-11-15 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1914897 | 1914897 | 2021-11-14 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1911647 | 1911647 | 2021-11-13 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1908398 | 1908398 | 2021-11-12 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1905149 | 1905149 | 2021-11-11 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1901899 | 1901899 | 2021-11-10 | Black Hawk | Iowa | 19013 | 21304 | 368 |
1898649 | 1898649 | 2021-11-09 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1895399 | 1895399 | 2021-11-08 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1892149 | 1892149 | 2021-11-07 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1888899 | 1888899 | 2021-11-06 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1885649 | 1885649 | 2021-11-05 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1882400 | 1882400 | 2021-11-04 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1879151 | 1879151 | 2021-11-03 | Black Hawk | Iowa | 19013 | 20992 | 364 |
1875902 | 1875902 | 2021-11-02 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1872653 | 1872653 | 2021-11-01 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1869404 | 1869404 | 2021-10-31 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1866155 | 1866155 | 2021-10-30 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1862906 | 1862906 | 2021-10-29 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1859657 | 1859657 | 2021-10-28 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1856408 | 1856408 | 2021-10-27 | Black Hawk | Iowa | 19013 | 20481 | 363 |
1853159 | 1853159 | 2021-10-26 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1849910 | 1849910 | 2021-10-25 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1846660 | 1846660 | 2021-10-24 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1843410 | 1843410 | 2021-10-23 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1840160 | 1840160 | 2021-10-22 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1836911 | 1836911 | 2021-10-21 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1833662 | 1833662 | 2021-10-20 | Black Hawk | Iowa | 19013 | 20341 | 358 |
1830413 | 1830413 | 2021-10-19 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1827164 | 1827164 | 2021-10-18 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1823915 | 1823915 | 2021-10-17 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1820666 | 1820666 | 2021-10-16 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1817417 | 1817417 | 2021-10-15 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1814169 | 1814169 | 2021-10-14 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1810920 | 1810920 | 2021-10-13 | Black Hawk | Iowa | 19013 | 20150 | 355 |
1807671 | 1807671 | 2021-10-12 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1804420 | 1804420 | 2021-10-11 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1801171 | 1801171 | 2021-10-10 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1797922 | 1797922 | 2021-10-09 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1794673 | 1794673 | 2021-10-08 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1791425 | 1791425 | 2021-10-07 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1788176 | 1788176 | 2021-10-06 | Black Hawk | Iowa | 19013 | 19899 | 345 |
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);