ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Columbiana" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111207 | 2111207 | 2022-01-13 | Columbiana | Ohio | 39029 | 20900 | 395 |
2107955 | 2107955 | 2022-01-12 | Columbiana | Ohio | 39029 | 20778 | 395 |
2104704 | 2104704 | 2022-01-11 | Columbiana | Ohio | 39029 | 20639 | 395 |
2101453 | 2101453 | 2022-01-10 | Columbiana | Ohio | 39029 | 20485 | 385 |
2098202 | 2098202 | 2022-01-09 | Columbiana | Ohio | 39029 | 20328 | 385 |
2094950 | 2094950 | 2022-01-08 | Columbiana | Ohio | 39029 | 20154 | 385 |
2091698 | 2091698 | 2022-01-07 | Columbiana | Ohio | 39029 | 19987 | 385 |
2088446 | 2088446 | 2022-01-06 | Columbiana | Ohio | 39029 | 19888 | 384 |
2085195 | 2085195 | 2022-01-05 | Columbiana | Ohio | 39029 | 19736 | 384 |
2081943 | 2081943 | 2022-01-04 | Columbiana | Ohio | 39029 | 19593 | 384 |
2078691 | 2078691 | 2022-01-03 | Columbiana | Ohio | 39029 | 19471 | 382 |
2075440 | 2075440 | 2022-01-02 | Columbiana | Ohio | 39029 | 19356 | 382 |
2072189 | 2072189 | 2022-01-01 | Columbiana | Ohio | 39029 | 19079 | 382 |
2068938 | 2068938 | 2021-12-31 | Columbiana | Ohio | 39029 | 19079 | 382 |
2065687 | 2065687 | 2021-12-30 | Columbiana | Ohio | 39029 | 18964 | 369 |
2062437 | 2062437 | 2021-12-29 | Columbiana | Ohio | 39029 | 18811 | 369 |
2059187 | 2059187 | 2021-12-28 | Columbiana | Ohio | 39029 | 18651 | 369 |
2055938 | 2055938 | 2021-12-27 | Columbiana | Ohio | 39029 | 18533 | 369 |
2052689 | 2052689 | 2021-12-26 | Columbiana | Ohio | 39029 | 18499 | 369 |
2049439 | 2049439 | 2021-12-25 | Columbiana | Ohio | 39029 | 18403 | 369 |
2046189 | 2046189 | 2021-12-24 | Columbiana | Ohio | 39029 | 18403 | 369 |
2042939 | 2042939 | 2021-12-23 | Columbiana | Ohio | 39029 | 18316 | 361 |
2039690 | 2039690 | 2021-12-22 | Columbiana | Ohio | 39029 | 18221 | 361 |
2036440 | 2036440 | 2021-12-21 | Columbiana | Ohio | 39029 | 18149 | 361 |
2033190 | 2033190 | 2021-12-20 | Columbiana | Ohio | 39029 | 18076 | 359 |
2029940 | 2029940 | 2021-12-19 | Columbiana | Ohio | 39029 | 18008 | 359 |
2026689 | 2026689 | 2021-12-18 | Columbiana | Ohio | 39029 | 17978 | 359 |
2023438 | 2023438 | 2021-12-17 | Columbiana | Ohio | 39029 | 17925 | 359 |
2020187 | 2020187 | 2021-12-16 | Columbiana | Ohio | 39029 | 17846 | 357 |
2016936 | 2016936 | 2021-12-15 | Columbiana | Ohio | 39029 | 17757 | 357 |
2013686 | 2013686 | 2021-12-14 | Columbiana | Ohio | 39029 | 17642 | 357 |
2010435 | 2010435 | 2021-12-13 | Columbiana | Ohio | 39029 | 17550 | 347 |
2007184 | 2007184 | 2021-12-12 | Columbiana | Ohio | 39029 | 17517 | 347 |
2003933 | 2003933 | 2021-12-11 | Columbiana | Ohio | 39029 | 17474 | 347 |
2000682 | 2000682 | 2021-12-10 | Columbiana | Ohio | 39029 | 17390 | 347 |
1997432 | 1997432 | 2021-12-09 | Columbiana | Ohio | 39029 | 17338 | 336 |
1994181 | 1994181 | 2021-12-08 | Columbiana | Ohio | 39029 | 17250 | 336 |
1990930 | 1990930 | 2021-12-07 | Columbiana | Ohio | 39029 | 17162 | 336 |
1987679 | 1987679 | 2021-12-06 | Columbiana | Ohio | 39029 | 17078 | 335 |
1984429 | 1984429 | 2021-12-05 | Columbiana | Ohio | 39029 | 17014 | 335 |
1981179 | 1981179 | 2021-12-04 | Columbiana | Ohio | 39029 | 16987 | 335 |
1977929 | 1977929 | 2021-12-03 | Columbiana | Ohio | 39029 | 16905 | 335 |
1974679 | 1974679 | 2021-12-02 | Columbiana | Ohio | 39029 | 16795 | 332 |
1971430 | 1971430 | 2021-12-01 | Columbiana | Ohio | 39029 | 16689 | 332 |
1968180 | 1968180 | 2021-11-30 | Columbiana | Ohio | 39029 | 16571 | 332 |
1964929 | 1964929 | 2021-11-29 | Columbiana | Ohio | 39029 | 16502 | 331 |
1961677 | 1961677 | 2021-11-28 | Columbiana | Ohio | 39029 | 16443 | 331 |
1958426 | 1958426 | 2021-11-27 | Columbiana | Ohio | 39029 | 16385 | 331 |
1955175 | 1955175 | 2021-11-26 | Columbiana | Ohio | 39029 | 16300 | 331 |
1951924 | 1951924 | 2021-11-25 | Columbiana | Ohio | 39029 | 16188 | 321 |
1948673 | 1948673 | 2021-11-24 | Columbiana | Ohio | 39029 | 16188 | 321 |
1945422 | 1945422 | 2021-11-23 | Columbiana | Ohio | 39029 | 16107 | 321 |
1942171 | 1942171 | 2021-11-22 | Columbiana | Ohio | 39029 | 16030 | 317 |
1938921 | 1938921 | 2021-11-21 | Columbiana | Ohio | 39029 | 15958 | 317 |
1935671 | 1935671 | 2021-11-20 | Columbiana | Ohio | 39029 | 15907 | 317 |
1932421 | 1932421 | 2021-11-19 | Columbiana | Ohio | 39029 | 15808 | 317 |
1929170 | 1929170 | 2021-11-18 | Columbiana | Ohio | 39029 | 15724 | 311 |
1925920 | 1925920 | 2021-11-17 | Columbiana | Ohio | 39029 | 15615 | 311 |
1922670 | 1922670 | 2021-11-16 | Columbiana | Ohio | 39029 | 15537 | 311 |
1919421 | 1919421 | 2021-11-15 | Columbiana | Ohio | 39029 | 15446 | 307 |
1916171 | 1916171 | 2021-11-14 | Columbiana | Ohio | 39029 | 15413 | 307 |
1912921 | 1912921 | 2021-11-13 | Columbiana | Ohio | 39029 | 15356 | 307 |
1909671 | 1909671 | 2021-11-12 | Columbiana | Ohio | 39029 | 15289 | 307 |
1906422 | 1906422 | 2021-11-11 | Columbiana | Ohio | 39029 | 15230 | 302 |
1903173 | 1903173 | 2021-11-10 | Columbiana | Ohio | 39029 | 15165 | 302 |
1899923 | 1899923 | 2021-11-09 | Columbiana | Ohio | 39029 | 15057 | 302 |
1896673 | 1896673 | 2021-11-08 | Columbiana | Ohio | 39029 | 14979 | 301 |
1893423 | 1893423 | 2021-11-07 | Columbiana | Ohio | 39029 | 14939 | 301 |
1890173 | 1890173 | 2021-11-06 | Columbiana | Ohio | 39029 | 14869 | 301 |
1886923 | 1886923 | 2021-11-05 | Columbiana | Ohio | 39029 | 14823 | 301 |
1883673 | 1883673 | 2021-11-04 | Columbiana | Ohio | 39029 | 14754 | 289 |
1880424 | 1880424 | 2021-11-03 | Columbiana | Ohio | 39029 | 14686 | 289 |
1877175 | 1877175 | 2021-11-02 | Columbiana | Ohio | 39029 | 14618 | 289 |
1873926 | 1873926 | 2021-11-01 | Columbiana | Ohio | 39029 | 14556 | 284 |
1870677 | 1870677 | 2021-10-31 | Columbiana | Ohio | 39029 | 14492 | 284 |
1867428 | 1867428 | 2021-10-30 | Columbiana | Ohio | 39029 | 14463 | 284 |
1864179 | 1864179 | 2021-10-29 | Columbiana | Ohio | 39029 | 14383 | 284 |
1860930 | 1860930 | 2021-10-28 | Columbiana | Ohio | 39029 | 14344 | 279 |
1857681 | 1857681 | 2021-10-27 | Columbiana | Ohio | 39029 | 14282 | 279 |
1854432 | 1854432 | 2021-10-26 | Columbiana | Ohio | 39029 | 14195 | 279 |
1851183 | 1851183 | 2021-10-25 | Columbiana | Ohio | 39029 | 14153 | 274 |
1847933 | 1847933 | 2021-10-24 | Columbiana | Ohio | 39029 | 14108 | 274 |
1844683 | 1844683 | 2021-10-23 | Columbiana | Ohio | 39029 | 14080 | 274 |
1841433 | 1841433 | 2021-10-22 | Columbiana | Ohio | 39029 | 14017 | 274 |
1838184 | 1838184 | 2021-10-21 | Columbiana | Ohio | 39029 | 13940 | 269 |
1834935 | 1834935 | 2021-10-20 | Columbiana | Ohio | 39029 | 13872 | 269 |
1831686 | 1831686 | 2021-10-19 | Columbiana | Ohio | 39029 | 13810 | 269 |
1828437 | 1828437 | 2021-10-18 | Columbiana | Ohio | 39029 | 13756 | 263 |
1825188 | 1825188 | 2021-10-17 | Columbiana | Ohio | 39029 | 13703 | 263 |
1821939 | 1821939 | 2021-10-16 | Columbiana | Ohio | 39029 | 13656 | 263 |
1818690 | 1818690 | 2021-10-15 | Columbiana | Ohio | 39029 | 13587 | 263 |
1815441 | 1815441 | 2021-10-14 | Columbiana | Ohio | 39029 | 13496 | 257 |
1812193 | 1812193 | 2021-10-13 | Columbiana | Ohio | 39029 | 13428 | 257 |
1808944 | 1808944 | 2021-10-12 | Columbiana | Ohio | 39029 | 13301 | 257 |
1805694 | 1805694 | 2021-10-11 | Columbiana | Ohio | 39029 | 13242 | 256 |
1802444 | 1802444 | 2021-10-10 | Columbiana | Ohio | 39029 | 13198 | 256 |
1799195 | 1799195 | 2021-10-09 | Columbiana | Ohio | 39029 | 13112 | 256 |
1795946 | 1795946 | 2021-10-08 | Columbiana | Ohio | 39029 | 13068 | 256 |
1792697 | 1792697 | 2021-10-07 | Columbiana | Ohio | 39029 | 12967 | 249 |
1789448 | 1789448 | 2021-10-06 | Columbiana | Ohio | 39029 | 12838 | 249 |
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);