ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Union" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176339 | 2176339 | 2022-02-02 | Union | Ohio | 39159 | 14964 | 85 |
2173085 | 2173085 | 2022-02-01 | Union | Ohio | 39159 | 14895 | 85 |
2169833 | 2169833 | 2022-01-31 | Union | Ohio | 39159 | 14801 | 84 |
2166578 | 2166578 | 2022-01-30 | Union | Ohio | 39159 | 14742 | 84 |
2163323 | 2163323 | 2022-01-29 | Union | Ohio | 39159 | 14697 | 84 |
2160068 | 2160068 | 2022-01-28 | Union | Ohio | 39159 | 14637 | 84 |
2156813 | 2156813 | 2022-01-27 | Union | Ohio | 39159 | 14545 | 84 |
2153560 | 2153560 | 2022-01-26 | Union | Ohio | 39159 | 14414 | 84 |
2150308 | 2150308 | 2022-01-25 | Union | Ohio | 39159 | 14249 | 84 |
2147056 | 2147056 | 2022-01-24 | Union | Ohio | 39159 | 14195 | 84 |
2143802 | 2143802 | 2022-01-23 | Union | Ohio | 39159 | 14120 | 84 |
2140547 | 2140547 | 2022-01-22 | Union | Ohio | 39159 | 14033 | 84 |
2137291 | 2137291 | 2022-01-21 | Union | Ohio | 39159 | 13931 | 84 |
2134037 | 2134037 | 2022-01-20 | Union | Ohio | 39159 | 13753 | 84 |
2130785 | 2130785 | 2022-01-19 | Union | Ohio | 39159 | 13599 | 84 |
2127531 | 2127531 | 2022-01-18 | Union | Ohio | 39159 | 13409 | 84 |
2124279 | 2124279 | 2022-01-17 | Union | Ohio | 39159 | 13296 | 83 |
2121027 | 2121027 | 2022-01-16 | Union | Ohio | 39159 | 13184 | 83 |
2117775 | 2117775 | 2022-01-15 | Union | Ohio | 39159 | 12988 | 83 |
2114524 | 2114524 | 2022-01-14 | Union | Ohio | 39159 | 12667 | 83 |
2111272 | 2111272 | 2022-01-13 | Union | Ohio | 39159 | 12380 | 82 |
2108020 | 2108020 | 2022-01-12 | Union | Ohio | 39159 | 12186 | 82 |
2104769 | 2104769 | 2022-01-11 | Union | Ohio | 39159 | 12049 | 82 |
2101518 | 2101518 | 2022-01-10 | Union | Ohio | 39159 | 11904 | 81 |
2098267 | 2098267 | 2022-01-09 | Union | Ohio | 39159 | 11803 | 81 |
2095015 | 2095015 | 2022-01-08 | Union | Ohio | 39159 | 11678 | 81 |
2091763 | 2091763 | 2022-01-07 | Union | Ohio | 39159 | 11586 | 81 |
2088511 | 2088511 | 2022-01-06 | Union | Ohio | 39159 | 11458 | 81 |
2085260 | 2085260 | 2022-01-05 | Union | Ohio | 39159 | 11329 | 81 |
2082008 | 2082008 | 2022-01-04 | Union | Ohio | 39159 | 11175 | 81 |
2078756 | 2078756 | 2022-01-03 | Union | Ohio | 39159 | 11068 | 81 |
2075505 | 2075505 | 2022-01-02 | Union | Ohio | 39159 | 11003 | 81 |
2072254 | 2072254 | 2022-01-01 | Union | Ohio | 39159 | 10864 | 81 |
2069003 | 2069003 | 2021-12-31 | Union | Ohio | 39159 | 10864 | 81 |
2065752 | 2065752 | 2021-12-30 | Union | Ohio | 39159 | 10733 | 79 |
2062502 | 2062502 | 2021-12-29 | Union | Ohio | 39159 | 10642 | 79 |
2059252 | 2059252 | 2021-12-28 | Union | Ohio | 39159 | 10549 | 79 |
2056003 | 2056003 | 2021-12-27 | Union | Ohio | 39159 | 10441 | 79 |
2052754 | 2052754 | 2021-12-26 | Union | Ohio | 39159 | 10403 | 79 |
2049504 | 2049504 | 2021-12-25 | Union | Ohio | 39159 | 10358 | 79 |
2046254 | 2046254 | 2021-12-24 | Union | Ohio | 39159 | 10358 | 79 |
2043004 | 2043004 | 2021-12-23 | Union | Ohio | 39159 | 10303 | 78 |
2039755 | 2039755 | 2021-12-22 | Union | Ohio | 39159 | 10247 | 78 |
2036505 | 2036505 | 2021-12-21 | Union | Ohio | 39159 | 10192 | 78 |
2033255 | 2033255 | 2021-12-20 | Union | Ohio | 39159 | 10135 | 77 |
2030005 | 2030005 | 2021-12-19 | Union | Ohio | 39159 | 10112 | 77 |
2026754 | 2026754 | 2021-12-18 | Union | Ohio | 39159 | 10085 | 77 |
2023503 | 2023503 | 2021-12-17 | Union | Ohio | 39159 | 10054 | 77 |
2020252 | 2020252 | 2021-12-16 | Union | Ohio | 39159 | 10008 | 75 |
2017001 | 2017001 | 2021-12-15 | Union | Ohio | 39159 | 9974 | 75 |
2013751 | 2013751 | 2021-12-14 | Union | Ohio | 39159 | 9936 | 75 |
2010500 | 2010500 | 2021-12-13 | Union | Ohio | 39159 | 9896 | 76 |
2007249 | 2007249 | 2021-12-12 | Union | Ohio | 39159 | 9873 | 76 |
2003998 | 2003998 | 2021-12-11 | Union | Ohio | 39159 | 9858 | 76 |
2000747 | 2000747 | 2021-12-10 | Union | Ohio | 39159 | 9819 | 76 |
1997497 | 1997497 | 2021-12-09 | Union | Ohio | 39159 | 9784 | 76 |
1994246 | 1994246 | 2021-12-08 | Union | Ohio | 39159 | 9747 | 76 |
1990995 | 1990995 | 2021-12-07 | Union | Ohio | 39159 | 9703 | 76 |
1987744 | 1987744 | 2021-12-06 | Union | Ohio | 39159 | 9665 | 75 |
1984494 | 1984494 | 2021-12-05 | Union | Ohio | 39159 | 9637 | 75 |
1981244 | 1981244 | 2021-12-04 | Union | Ohio | 39159 | 9606 | 75 |
1977994 | 1977994 | 2021-12-03 | Union | Ohio | 39159 | 9573 | 75 |
1974744 | 1974744 | 2021-12-02 | Union | Ohio | 39159 | 9540 | 75 |
1971495 | 1971495 | 2021-12-01 | Union | Ohio | 39159 | 9503 | 75 |
1968245 | 1968245 | 2021-11-30 | Union | Ohio | 39159 | 9440 | 75 |
1964994 | 1964994 | 2021-11-29 | Union | Ohio | 39159 | 9391 | 75 |
1961742 | 1961742 | 2021-11-28 | Union | Ohio | 39159 | 9354 | 75 |
1958491 | 1958491 | 2021-11-27 | Union | Ohio | 39159 | 9333 | 75 |
1955240 | 1955240 | 2021-11-26 | Union | Ohio | 39159 | 9305 | 75 |
1951989 | 1951989 | 2021-11-25 | Union | Ohio | 39159 | 9268 | 72 |
1948738 | 1948738 | 2021-11-24 | Union | Ohio | 39159 | 9268 | 72 |
1945487 | 1945487 | 2021-11-23 | Union | Ohio | 39159 | 9223 | 72 |
1942236 | 1942236 | 2021-11-22 | Union | Ohio | 39159 | 9177 | 71 |
1938986 | 1938986 | 2021-11-21 | Union | Ohio | 39159 | 9153 | 71 |
1935736 | 1935736 | 2021-11-20 | Union | Ohio | 39159 | 9136 | 71 |
1932486 | 1932486 | 2021-11-19 | Union | Ohio | 39159 | 9096 | 71 |
1929235 | 1929235 | 2021-11-18 | Union | Ohio | 39159 | 9053 | 69 |
1925985 | 1925985 | 2021-11-17 | Union | Ohio | 39159 | 9003 | 69 |
1922735 | 1922735 | 2021-11-16 | Union | Ohio | 39159 | 8961 | 69 |
1919486 | 1919486 | 2021-11-15 | Union | Ohio | 39159 | 8886 | 67 |
1916236 | 1916236 | 2021-11-14 | Union | Ohio | 39159 | 8863 | 67 |
1912986 | 1912986 | 2021-11-13 | Union | Ohio | 39159 | 8855 | 67 |
1909736 | 1909736 | 2021-11-12 | Union | Ohio | 39159 | 8796 | 67 |
1906487 | 1906487 | 2021-11-11 | Union | Ohio | 39159 | 8761 | 66 |
1903238 | 1903238 | 2021-11-10 | Union | Ohio | 39159 | 8718 | 66 |
1899988 | 1899988 | 2021-11-09 | Union | Ohio | 39159 | 8660 | 66 |
1896738 | 1896738 | 2021-11-08 | Union | Ohio | 39159 | 8613 | 66 |
1893488 | 1893488 | 2021-11-07 | Union | Ohio | 39159 | 8596 | 66 |
1890238 | 1890238 | 2021-11-06 | Union | Ohio | 39159 | 8564 | 66 |
1886988 | 1886988 | 2021-11-05 | Union | Ohio | 39159 | 8537 | 66 |
1883738 | 1883738 | 2021-11-04 | Union | Ohio | 39159 | 8495 | 66 |
1880489 | 1880489 | 2021-11-03 | Union | Ohio | 39159 | 8458 | 66 |
1877240 | 1877240 | 2021-11-02 | Union | Ohio | 39159 | 8420 | 66 |
1873991 | 1873991 | 2021-11-01 | Union | Ohio | 39159 | 8393 | 66 |
1870742 | 1870742 | 2021-10-31 | Union | Ohio | 39159 | 8374 | 66 |
1867493 | 1867493 | 2021-10-30 | Union | Ohio | 39159 | 8350 | 66 |
1864244 | 1864244 | 2021-10-29 | Union | Ohio | 39159 | 8320 | 66 |
1860995 | 1860995 | 2021-10-28 | Union | Ohio | 39159 | 8301 | 62 |
1857746 | 1857746 | 2021-10-27 | Union | Ohio | 39159 | 8273 | 62 |
1854497 | 1854497 | 2021-10-26 | Union | Ohio | 39159 | 8254 | 62 |
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);