ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

303 rows where deaths = 64 and state = "Ohio" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips >30

state 1

  • Ohio · 303 ✖
Link rowid date ▲ county state fips cases deaths
2134020 2134020 2022-01-20 Paulding Ohio 39125 4146 64
2130768 2130768 2022-01-19 Paulding Ohio 39125 4090 64
2127514 2127514 2022-01-18 Paulding Ohio 39125 4044 64
2055979 2055979 2021-12-27 Monroe Ohio 39111 2550 64
2052730 2052730 2021-12-26 Monroe Ohio 39111 2547 64
2049480 2049480 2021-12-25 Monroe Ohio 39111 2542 64
2046230 2046230 2021-12-24 Monroe Ohio 39111 2542 64
2042980 2042980 2021-12-23 Monroe Ohio 39111 2536 64
2039731 2039731 2021-12-22 Monroe Ohio 39111 2523 64
2036481 2036481 2021-12-21 Monroe Ohio 39111 2515 64
2033231 2033231 2021-12-20 Monroe Ohio 39111 2509 64
2029981 2029981 2021-12-19 Monroe Ohio 39111 2502 64
2026730 2026730 2021-12-18 Monroe Ohio 39111 2494 64
2023479 2023479 2021-12-17 Monroe Ohio 39111 2478 64
1974723 1974723 2021-12-02 Morrow Ohio 39117 5152 64
1971474 1971474 2021-12-01 Morrow Ohio 39117 5123 64
1968224 1968224 2021-11-30 Morrow Ohio 39117 5093 64
1964973 1964973 2021-11-29 Morrow Ohio 39117 5064 64
1961721 1961721 2021-11-28 Morrow Ohio 39117 5052 64
1958470 1958470 2021-11-27 Morrow Ohio 39117 5044 64
1955219 1955219 2021-11-26 Morrow Ohio 39117 5024 64
1906496 1906496 2021-11-11 Wyandot Ohio 39175 3446 64
1903247 1903247 2021-11-10 Wyandot Ohio 39175 3438 64
1899997 1899997 2021-11-09 Wyandot Ohio 39175 3416 64
1896747 1896747 2021-11-08 Wyandot Ohio 39175 3402 64
1893497 1893497 2021-11-07 Wyandot Ohio 39175 3392 64
1890247 1890247 2021-11-06 Wyandot Ohio 39175 3382 64
1886997 1886997 2021-11-05 Wyandot Ohio 39175 3380 64
1873935 1873935 2021-11-01 Fayette Ohio 39047 4364 64
1870686 1870686 2021-10-31 Fayette Ohio 39047 4362 64
1867437 1867437 2021-10-30 Fayette Ohio 39047 4359 64
1864188 1864188 2021-10-29 Fayette Ohio 39047 4351 64
1860939 1860939 2021-10-28 Fayette Ohio 39047 4341 64
1857690 1857690 2021-10-27 Fayette Ohio 39047 4326 64
1854441 1854441 2021-10-26 Fayette Ohio 39047 4314 64
1782947 1782947 2021-10-04 Champaign Ohio 39021 4754 64
1779698 1779698 2021-10-03 Champaign Ohio 39021 4735 64
1776448 1776448 2021-10-02 Champaign Ohio 39021 4719 64
1773198 1773198 2021-10-01 Champaign Ohio 39021 4698 64
1769948 1769948 2021-09-30 Champaign Ohio 39021 4664 64
1769967 1769967 2021-09-30 Guernsey Ohio 39059 5034 64
1766699 1766699 2021-09-29 Champaign Ohio 39021 4632 64
1766718 1766718 2021-09-29 Guernsey Ohio 39059 4989 64
1763450 1763450 2021-09-28 Champaign Ohio 39021 4605 64
1763469 1763469 2021-09-28 Guernsey Ohio 39059 4942 64
1760201 1760201 2021-09-27 Champaign Ohio 39021 4566 64
1760220 1760220 2021-09-27 Guernsey Ohio 39059 4894 64
1756953 1756953 2021-09-26 Champaign Ohio 39021 4549 64
1756972 1756972 2021-09-26 Guernsey Ohio 39059 4876 64
1753705 1753705 2021-09-25 Champaign Ohio 39021 4542 64
1753724 1753724 2021-09-25 Guernsey Ohio 39059 4843 64
1750457 1750457 2021-09-24 Champaign Ohio 39021 4522 64
1750476 1750476 2021-09-24 Guernsey Ohio 39059 4806 64
1747207 1747207 2021-09-23 Champaign Ohio 39021 4488 64
1747226 1747226 2021-09-23 Guernsey Ohio 39059 4747 64
1743958 1743958 2021-09-22 Champaign Ohio 39021 4459 64
1743977 1743977 2021-09-22 Guernsey Ohio 39059 4703 64
1740709 1740709 2021-09-21 Champaign Ohio 39021 4435 64
1740728 1740728 2021-09-21 Guernsey Ohio 39059 4650 64
1737454 1737454 2021-09-20 Athens Ohio 39009 6882 64
1737460 1737460 2021-09-20 Champaign Ohio 39021 4402 64
1734204 1734204 2021-09-19 Athens Ohio 39009 6855 64
1734210 1734210 2021-09-19 Champaign Ohio 39021 4381 64
1730954 1730954 2021-09-18 Athens Ohio 39009 6810 64
1730960 1730960 2021-09-18 Champaign Ohio 39021 4362 64
1727704 1727704 2021-09-17 Athens Ohio 39009 6755 64
1727710 1727710 2021-09-17 Champaign Ohio 39021 4329 64
1724451 1724451 2021-09-16 Adams Ohio 39001 3430 64
1724466 1724466 2021-09-16 Coshocton Ohio 39031 3484 64
1721202 1721202 2021-09-15 Adams Ohio 39001 3388 64
1721217 1721217 2021-09-15 Coshocton Ohio 39031 3450 64
1717954 1717954 2021-09-14 Adams Ohio 39001 3357 64
1717969 1717969 2021-09-14 Coshocton Ohio 39031 3383 64
1714721 1714721 2021-09-13 Coshocton Ohio 39031 3344 64
1711475 1711475 2021-09-12 Coshocton Ohio 39031 3319 64
1708228 1708228 2021-09-11 Coshocton Ohio 39031 3301 64
1704981 1704981 2021-09-10 Coshocton Ohio 39031 3271 64
1692007 1692007 2021-09-06 Hocking Ohio 39073 2571 64
1688758 1688758 2021-09-05 Hocking Ohio 39073 2558 64
1685508 1685508 2021-09-04 Hocking Ohio 39073 2553 64
1682257 1682257 2021-09-03 Hocking Ohio 39073 2540 64
1646500 1646500 2021-08-23 Brown Ohio 39015 4440 64
1643251 1643251 2021-08-22 Brown Ohio 39015 4424 64
1640001 1640001 2021-08-21 Brown Ohio 39015 4411 64
1636751 1636751 2021-08-20 Brown Ohio 39015 4396 64
1451728 1451728 2021-06-24 Van Wert Ohio 39161 2472 64
1448482 1448482 2021-06-23 Van Wert Ohio 39161 2472 64
1445237 1445237 2021-06-22 Van Wert Ohio 39161 2472 64
1441992 1441992 2021-06-21 Van Wert Ohio 39161 2472 64
1438747 1438747 2021-06-20 Van Wert Ohio 39161 2472 64
1435500 1435500 2021-06-19 Van Wert Ohio 39161 2472 64
1432253 1432253 2021-06-18 Van Wert Ohio 39161 2472 64
1429007 1429007 2021-06-17 Van Wert Ohio 39161 2472 64
1425762 1425762 2021-06-16 Van Wert Ohio 39161 2472 64
1422515 1422515 2021-06-15 Van Wert Ohio 39161 2472 64
1419269 1419269 2021-06-14 Van Wert Ohio 39161 2472 64
1416024 1416024 2021-06-13 Van Wert Ohio 39161 2472 64
1412778 1412778 2021-06-12 Van Wert Ohio 39161 2472 64
1409533 1409533 2021-06-11 Van Wert Ohio 39161 2471 64
1406288 1406288 2021-06-10 Van Wert Ohio 39161 2471 64

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);