ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Belmont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176266 | 2176266 | 2022-02-02 | Belmont | Ohio | 39013 | 15046 | 257 |
2173012 | 2173012 | 2022-02-01 | Belmont | Ohio | 39013 | 14975 | 257 |
2169760 | 2169760 | 2022-01-31 | Belmont | Ohio | 39013 | 14894 | 255 |
2166505 | 2166505 | 2022-01-30 | Belmont | Ohio | 39013 | 14835 | 255 |
2163250 | 2163250 | 2022-01-29 | Belmont | Ohio | 39013 | 14795 | 255 |
2159995 | 2159995 | 2022-01-28 | Belmont | Ohio | 39013 | 14699 | 255 |
2156740 | 2156740 | 2022-01-27 | Belmont | Ohio | 39013 | 14607 | 254 |
2153487 | 2153487 | 2022-01-26 | Belmont | Ohio | 39013 | 14472 | 254 |
2150235 | 2150235 | 2022-01-25 | Belmont | Ohio | 39013 | 14343 | 254 |
2146983 | 2146983 | 2022-01-24 | Belmont | Ohio | 39013 | 14236 | 248 |
2143729 | 2143729 | 2022-01-23 | Belmont | Ohio | 39013 | 14132 | 248 |
2140474 | 2140474 | 2022-01-22 | Belmont | Ohio | 39013 | 14033 | 248 |
2137218 | 2137218 | 2022-01-21 | Belmont | Ohio | 39013 | 13936 | 248 |
2133964 | 2133964 | 2022-01-20 | Belmont | Ohio | 39013 | 13767 | 247 |
2130712 | 2130712 | 2022-01-19 | Belmont | Ohio | 39013 | 13554 | 247 |
2127458 | 2127458 | 2022-01-18 | Belmont | Ohio | 39013 | 13369 | 247 |
2124206 | 2124206 | 2022-01-17 | Belmont | Ohio | 39013 | 13255 | 247 |
2120954 | 2120954 | 2022-01-16 | Belmont | Ohio | 39013 | 13174 | 247 |
2117702 | 2117702 | 2022-01-15 | Belmont | Ohio | 39013 | 13084 | 247 |
2114451 | 2114451 | 2022-01-14 | Belmont | Ohio | 39013 | 12939 | 247 |
2111199 | 2111199 | 2022-01-13 | Belmont | Ohio | 39013 | 12756 | 247 |
2107947 | 2107947 | 2022-01-12 | Belmont | Ohio | 39013 | 12602 | 247 |
2104696 | 2104696 | 2022-01-11 | Belmont | Ohio | 39013 | 12471 | 247 |
2101445 | 2101445 | 2022-01-10 | Belmont | Ohio | 39013 | 12318 | 246 |
2098194 | 2098194 | 2022-01-09 | Belmont | Ohio | 39013 | 12262 | 246 |
2094942 | 2094942 | 2022-01-08 | Belmont | Ohio | 39013 | 12195 | 246 |
2091690 | 2091690 | 2022-01-07 | Belmont | Ohio | 39013 | 12125 | 246 |
2088438 | 2088438 | 2022-01-06 | Belmont | Ohio | 39013 | 11991 | 246 |
2085187 | 2085187 | 2022-01-05 | Belmont | Ohio | 39013 | 11842 | 246 |
2081935 | 2081935 | 2022-01-04 | Belmont | Ohio | 39013 | 11731 | 246 |
2078683 | 2078683 | 2022-01-03 | Belmont | Ohio | 39013 | 11616 | 246 |
2075432 | 2075432 | 2022-01-02 | Belmont | Ohio | 39013 | 11580 | 246 |
2072181 | 2072181 | 2022-01-01 | Belmont | Ohio | 39013 | 11473 | 246 |
2068930 | 2068930 | 2021-12-31 | Belmont | Ohio | 39013 | 11473 | 246 |
2065679 | 2065679 | 2021-12-30 | Belmont | Ohio | 39013 | 11422 | 244 |
2062429 | 2062429 | 2021-12-29 | Belmont | Ohio | 39013 | 11338 | 244 |
2059179 | 2059179 | 2021-12-28 | Belmont | Ohio | 39013 | 11255 | 244 |
2055930 | 2055930 | 2021-12-27 | Belmont | Ohio | 39013 | 11182 | 243 |
2052681 | 2052681 | 2021-12-26 | Belmont | Ohio | 39013 | 11155 | 243 |
2049431 | 2049431 | 2021-12-25 | Belmont | Ohio | 39013 | 11133 | 243 |
2046181 | 2046181 | 2021-12-24 | Belmont | Ohio | 39013 | 11133 | 243 |
2042931 | 2042931 | 2021-12-23 | Belmont | Ohio | 39013 | 11106 | 239 |
2039682 | 2039682 | 2021-12-22 | Belmont | Ohio | 39013 | 11069 | 239 |
2036432 | 2036432 | 2021-12-21 | Belmont | Ohio | 39013 | 11029 | 239 |
2033182 | 2033182 | 2021-12-20 | Belmont | Ohio | 39013 | 10980 | 238 |
2029932 | 2029932 | 2021-12-19 | Belmont | Ohio | 39013 | 10950 | 238 |
2026681 | 2026681 | 2021-12-18 | Belmont | Ohio | 39013 | 10930 | 238 |
2023430 | 2023430 | 2021-12-17 | Belmont | Ohio | 39013 | 10911 | 238 |
2020179 | 2020179 | 2021-12-16 | Belmont | Ohio | 39013 | 10885 | 235 |
2016928 | 2016928 | 2021-12-15 | Belmont | Ohio | 39013 | 10844 | 235 |
2013678 | 2013678 | 2021-12-14 | Belmont | Ohio | 39013 | 10820 | 235 |
2010427 | 2010427 | 2021-12-13 | Belmont | Ohio | 39013 | 10778 | 235 |
2007176 | 2007176 | 2021-12-12 | Belmont | Ohio | 39013 | 10744 | 235 |
2003925 | 2003925 | 2021-12-11 | Belmont | Ohio | 39013 | 10710 | 235 |
2000674 | 2000674 | 2021-12-10 | Belmont | Ohio | 39013 | 10690 | 235 |
1997424 | 1997424 | 2021-12-09 | Belmont | Ohio | 39013 | 10643 | 235 |
1994173 | 1994173 | 2021-12-08 | Belmont | Ohio | 39013 | 10624 | 235 |
1990922 | 1990922 | 2021-12-07 | Belmont | Ohio | 39013 | 10598 | 235 |
1987671 | 1987671 | 2021-12-06 | Belmont | Ohio | 39013 | 10548 | 234 |
1984421 | 1984421 | 2021-12-05 | Belmont | Ohio | 39013 | 10509 | 234 |
1981171 | 1981171 | 2021-12-04 | Belmont | Ohio | 39013 | 10485 | 234 |
1977921 | 1977921 | 2021-12-03 | Belmont | Ohio | 39013 | 10459 | 234 |
1974671 | 1974671 | 2021-12-02 | Belmont | Ohio | 39013 | 10416 | 234 |
1971422 | 1971422 | 2021-12-01 | Belmont | Ohio | 39013 | 10373 | 234 |
1968172 | 1968172 | 2021-11-30 | Belmont | Ohio | 39013 | 10304 | 234 |
1964921 | 1964921 | 2021-11-29 | Belmont | Ohio | 39013 | 10259 | 231 |
1961669 | 1961669 | 2021-11-28 | Belmont | Ohio | 39013 | 10218 | 231 |
1958418 | 1958418 | 2021-11-27 | Belmont | Ohio | 39013 | 10200 | 231 |
1955167 | 1955167 | 2021-11-26 | Belmont | Ohio | 39013 | 10188 | 231 |
1951916 | 1951916 | 2021-11-25 | Belmont | Ohio | 39013 | 10152 | 231 |
1948665 | 1948665 | 2021-11-24 | Belmont | Ohio | 39013 | 10152 | 231 |
1945414 | 1945414 | 2021-11-23 | Belmont | Ohio | 39013 | 10107 | 231 |
1942163 | 1942163 | 2021-11-22 | Belmont | Ohio | 39013 | 10068 | 231 |
1938913 | 1938913 | 2021-11-21 | Belmont | Ohio | 39013 | 10044 | 231 |
1935663 | 1935663 | 2021-11-20 | Belmont | Ohio | 39013 | 10022 | 231 |
1932413 | 1932413 | 2021-11-19 | Belmont | Ohio | 39013 | 9997 | 231 |
1929162 | 1929162 | 2021-11-18 | Belmont | Ohio | 39013 | 9953 | 227 |
1925912 | 1925912 | 2021-11-17 | Belmont | Ohio | 39013 | 9908 | 227 |
1922662 | 1922662 | 2021-11-16 | Belmont | Ohio | 39013 | 9881 | 227 |
1919413 | 1919413 | 2021-11-15 | Belmont | Ohio | 39013 | 9832 | 221 |
1916163 | 1916163 | 2021-11-14 | Belmont | Ohio | 39013 | 9811 | 221 |
1912913 | 1912913 | 2021-11-13 | Belmont | Ohio | 39013 | 9788 | 221 |
1909663 | 1909663 | 2021-11-12 | Belmont | Ohio | 39013 | 9754 | 221 |
1906414 | 1906414 | 2021-11-11 | Belmont | Ohio | 39013 | 9721 | 219 |
1903165 | 1903165 | 2021-11-10 | Belmont | Ohio | 39013 | 9711 | 219 |
1899915 | 1899915 | 2021-11-09 | Belmont | Ohio | 39013 | 9664 | 219 |
1896665 | 1896665 | 2021-11-08 | Belmont | Ohio | 39013 | 9639 | 219 |
1893415 | 1893415 | 2021-11-07 | Belmont | Ohio | 39013 | 9610 | 219 |
1890165 | 1890165 | 2021-11-06 | Belmont | Ohio | 39013 | 9593 | 219 |
1886915 | 1886915 | 2021-11-05 | Belmont | Ohio | 39013 | 9580 | 219 |
1883665 | 1883665 | 2021-11-04 | Belmont | Ohio | 39013 | 9536 | 219 |
1880416 | 1880416 | 2021-11-03 | Belmont | Ohio | 39013 | 9516 | 219 |
1877167 | 1877167 | 2021-11-02 | Belmont | Ohio | 39013 | 9492 | 219 |
1873918 | 1873918 | 2021-11-01 | Belmont | Ohio | 39013 | 9459 | 215 |
1870669 | 1870669 | 2021-10-31 | Belmont | Ohio | 39013 | 9442 | 215 |
1867420 | 1867420 | 2021-10-30 | Belmont | Ohio | 39013 | 9440 | 215 |
1864171 | 1864171 | 2021-10-29 | Belmont | Ohio | 39013 | 9424 | 215 |
1860922 | 1860922 | 2021-10-28 | Belmont | Ohio | 39013 | 9399 | 211 |
1857673 | 1857673 | 2021-10-27 | Belmont | Ohio | 39013 | 9391 | 211 |
1854424 | 1854424 | 2021-10-26 | Belmont | Ohio | 39013 | 9360 | 211 |
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);