ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where deaths = 154 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2404017 | 2404017 | 2022-04-13 | Putnam | Ohio | 39137 | 8449 | 154 |
2400762 | 2400762 | 2022-04-12 | Putnam | Ohio | 39137 | 8449 | 154 |
2397507 | 2397507 | 2022-04-11 | Putnam | Ohio | 39137 | 8449 | 154 |
2394252 | 2394252 | 2022-04-10 | Putnam | Ohio | 39137 | 8449 | 154 |
2390996 | 2390996 | 2022-04-09 | Putnam | Ohio | 39137 | 8449 | 154 |
2387740 | 2387740 | 2022-04-08 | Putnam | Ohio | 39137 | 8449 | 154 |
2384485 | 2384485 | 2022-04-07 | Putnam | Ohio | 39137 | 8449 | 154 |
2381230 | 2381230 | 2022-04-06 | Putnam | Ohio | 39137 | 8443 | 154 |
2377975 | 2377975 | 2022-04-05 | Putnam | Ohio | 39137 | 8443 | 154 |
2374721 | 2374721 | 2022-04-04 | Putnam | Ohio | 39137 | 8443 | 154 |
2371469 | 2371469 | 2022-04-03 | Putnam | Ohio | 39137 | 8443 | 154 |
2368216 | 2368216 | 2022-04-02 | Putnam | Ohio | 39137 | 8443 | 154 |
2364963 | 2364963 | 2022-04-01 | Putnam | Ohio | 39137 | 8443 | 154 |
2361710 | 2361710 | 2022-03-31 | Putnam | Ohio | 39137 | 8443 | 154 |
2358456 | 2358456 | 2022-03-30 | Putnam | Ohio | 39137 | 8436 | 154 |
2355202 | 2355202 | 2022-03-29 | Putnam | Ohio | 39137 | 8436 | 154 |
2351949 | 2351949 | 2022-03-28 | Putnam | Ohio | 39137 | 8436 | 154 |
2348697 | 2348697 | 2022-03-27 | Putnam | Ohio | 39137 | 8436 | 154 |
2345444 | 2345444 | 2022-03-26 | Putnam | Ohio | 39137 | 8436 | 154 |
2342191 | 2342191 | 2022-03-25 | Putnam | Ohio | 39137 | 8436 | 154 |
2338938 | 2338938 | 2022-03-24 | Putnam | Ohio | 39137 | 8436 | 154 |
2335684 | 2335684 | 2022-03-23 | Putnam | Ohio | 39137 | 8435 | 154 |
2332430 | 2332430 | 2022-03-22 | Putnam | Ohio | 39137 | 8435 | 154 |
2329177 | 2329177 | 2022-03-21 | Putnam | Ohio | 39137 | 8435 | 154 |
2325925 | 2325925 | 2022-03-20 | Putnam | Ohio | 39137 | 8435 | 154 |
2322672 | 2322672 | 2022-03-19 | Putnam | Ohio | 39137 | 8435 | 154 |
2319418 | 2319418 | 2022-03-18 | Putnam | Ohio | 39137 | 8435 | 154 |
2316164 | 2316164 | 2022-03-17 | Putnam | Ohio | 39137 | 8435 | 154 |
2312858 | 2312858 | 2022-03-16 | Coshocton | Ohio | 39031 | 7930 | 154 |
2309605 | 2309605 | 2022-03-15 | Coshocton | Ohio | 39031 | 7930 | 154 |
2306352 | 2306352 | 2022-03-14 | Coshocton | Ohio | 39031 | 7930 | 154 |
2303101 | 2303101 | 2022-03-13 | Coshocton | Ohio | 39031 | 7930 | 154 |
2299849 | 2299849 | 2022-03-12 | Coshocton | Ohio | 39031 | 7929 | 154 |
2296597 | 2296597 | 2022-03-11 | Coshocton | Ohio | 39031 | 7930 | 154 |
2202291 | 2202291 | 2022-02-10 | Brown | Ohio | 39015 | 10973 | 154 |
2199037 | 2199037 | 2022-02-09 | Brown | Ohio | 39015 | 10952 | 154 |
2195783 | 2195783 | 2022-02-08 | Brown | Ohio | 39015 | 10919 | 154 |
2169789 | 2169789 | 2022-01-31 | Highland | Ohio | 39071 | 10173 | 154 |
2166534 | 2166534 | 2022-01-30 | Highland | Ohio | 39071 | 10145 | 154 |
2163279 | 2163279 | 2022-01-29 | Highland | Ohio | 39071 | 10122 | 154 |
2160024 | 2160024 | 2022-01-28 | Highland | Ohio | 39071 | 10071 | 154 |
2147002 | 2147002 | 2022-01-24 | Fulton | Ohio | 39051 | 9726 | 154 |
2143748 | 2143748 | 2022-01-23 | Fulton | Ohio | 39051 | 9692 | 154 |
2140493 | 2140493 | 2022-01-22 | Fulton | Ohio | 39051 | 9661 | 154 |
2137237 | 2137237 | 2022-01-21 | Fulton | Ohio | 39051 | 9608 | 154 |
2088499 | 2088499 | 2022-01-06 | Preble | Ohio | 39135 | 7291 | 154 |
2085248 | 2085248 | 2022-01-05 | Preble | Ohio | 39135 | 7241 | 154 |
2081996 | 2081996 | 2022-01-04 | Preble | Ohio | 39135 | 7203 | 154 |
2010437 | 2010437 | 2021-12-13 | Crawford | Ohio | 39033 | 7676 | 154 |
2007186 | 2007186 | 2021-12-12 | Crawford | Ohio | 39033 | 7653 | 154 |
2003935 | 2003935 | 2021-12-11 | Crawford | Ohio | 39033 | 7621 | 154 |
2000684 | 2000684 | 2021-12-10 | Crawford | Ohio | 39033 | 7568 | 154 |
1951948 | 1951948 | 2021-11-25 | Huron | Ohio | 39077 | 9480 | 154 |
1948697 | 1948697 | 2021-11-24 | Huron | Ohio | 39077 | 9480 | 154 |
1945446 | 1945446 | 2021-11-23 | Huron | Ohio | 39077 | 9441 | 154 |
1942230 | 1942230 | 2021-11-22 | Seneca | Ohio | 39147 | 8458 | 154 |
1938980 | 1938980 | 2021-11-21 | Seneca | Ohio | 39147 | 8422 | 154 |
1935730 | 1935730 | 2021-11-20 | Seneca | Ohio | 39147 | 8396 | 154 |
1932480 | 1932480 | 2021-11-19 | Seneca | Ohio | 39147 | 8378 | 154 |
1929229 | 1929229 | 2021-11-18 | Seneca | Ohio | 39147 | 8337 | 154 |
1929240 | 1929240 | 2021-11-18 | Washington | Ohio | 39167 | 8408 | 154 |
1925979 | 1925979 | 2021-11-17 | Seneca | Ohio | 39147 | 8281 | 154 |
1925990 | 1925990 | 2021-11-17 | Washington | Ohio | 39167 | 8387 | 154 |
1922729 | 1922729 | 2021-11-16 | Seneca | Ohio | 39147 | 8221 | 154 |
1922740 | 1922740 | 2021-11-16 | Washington | Ohio | 39167 | 8378 | 154 |
1883700 | 1883700 | 2021-11-04 | Knox | Ohio | 39083 | 8059 | 154 |
1880451 | 1880451 | 2021-11-03 | Knox | Ohio | 39083 | 8030 | 154 |
1877202 | 1877202 | 2021-11-02 | Knox | Ohio | 39083 | 7995 | 154 |
1873955 | 1873955 | 2021-11-01 | Lawrence | Ohio | 39087 | 9917 | 154 |
1870706 | 1870706 | 2021-10-31 | Lawrence | Ohio | 39087 | 9904 | 154 |
1867457 | 1867457 | 2021-10-30 | Lawrence | Ohio | 39087 | 9899 | 154 |
1864208 | 1864208 | 2021-10-29 | Lawrence | Ohio | 39087 | 9881 | 154 |
1860959 | 1860959 | 2021-10-28 | Lawrence | Ohio | 39087 | 9855 | 154 |
1857710 | 1857710 | 2021-10-27 | Lawrence | Ohio | 39087 | 9844 | 154 |
1854461 | 1854461 | 2021-10-26 | Lawrence | Ohio | 39087 | 9820 | 154 |
1828495 | 1828495 | 2021-10-18 | Scioto | Ohio | 39145 | 11388 | 154 |
1825246 | 1825246 | 2021-10-17 | Scioto | Ohio | 39145 | 11356 | 154 |
1821997 | 1821997 | 2021-10-16 | Scioto | Ohio | 39145 | 11336 | 154 |
1818748 | 1818748 | 2021-10-15 | Scioto | Ohio | 39145 | 11313 | 154 |
1792703 | 1792703 | 2021-10-07 | Delaware | Ohio | 39041 | 23397 | 154 |
1789454 | 1789454 | 2021-10-06 | Delaware | Ohio | 39041 | 23305 | 154 |
1786206 | 1786206 | 2021-10-05 | Delaware | Ohio | 39041 | 23238 | 154 |
1315335 | 1315335 | 2021-05-13 | Erie | Ohio | 39043 | 7930 | 154 |
1312089 | 1312089 | 2021-05-12 | Erie | Ohio | 39043 | 7923 | 154 |
1308842 | 1308842 | 2021-05-11 | Erie | Ohio | 39043 | 7917 | 154 |
1305596 | 1305596 | 2021-05-10 | Erie | Ohio | 39043 | 7901 | 154 |
1302350 | 1302350 | 2021-05-09 | Erie | Ohio | 39043 | 7895 | 154 |
1299102 | 1299102 | 2021-05-08 | Erie | Ohio | 39043 | 7888 | 154 |
1295856 | 1295856 | 2021-05-07 | Erie | Ohio | 39043 | 7871 | 154 |
1292610 | 1292610 | 2021-05-06 | Erie | Ohio | 39043 | 7859 | 154 |
1289364 | 1289364 | 2021-05-05 | Erie | Ohio | 39043 | 7840 | 154 |
1286118 | 1286118 | 2021-05-04 | Erie | Ohio | 39043 | 7831 | 154 |
1282872 | 1282872 | 2021-05-03 | Erie | Ohio | 39043 | 7819 | 154 |
1279625 | 1279625 | 2021-05-02 | Erie | Ohio | 39043 | 7807 | 154 |
1276378 | 1276378 | 2021-05-01 | Erie | Ohio | 39043 | 7798 | 154 |
1273131 | 1273131 | 2021-04-30 | Erie | Ohio | 39043 | 7785 | 154 |
1269884 | 1269884 | 2021-04-29 | Erie | Ohio | 39043 | 7767 | 154 |
1266637 | 1266637 | 2021-04-28 | Erie | Ohio | 39043 | 7754 | 154 |
1263390 | 1263390 | 2021-04-27 | Erie | Ohio | 39043 | 7738 | 154 |
1260143 | 1260143 | 2021-04-26 | Erie | Ohio | 39043 | 7729 | 154 |
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);