ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 17 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
426666 | 426666 | 2020-08-12 | Noble | Ohio | 39121 | 17 | 0 |
413779 | 413779 | 2020-08-08 | Noble | Ohio | 39121 | 17 | 0 |
407339 | 407339 | 2020-08-06 | Noble | Ohio | 39121 | 17 | 0 |
397687 | 397687 | 2020-08-03 | Noble | Ohio | 39121 | 17 | 0 |
388034 | 388034 | 2020-07-31 | Morgan | Ohio | 39115 | 17 | 0 |
384817 | 384817 | 2020-07-30 | Morgan | Ohio | 39115 | 17 | 0 |
381599 | 381599 | 2020-07-29 | Morgan | Ohio | 39115 | 17 | 0 |
378358 | 378358 | 2020-07-28 | Harrison | Ohio | 39067 | 17 | 1 |
378382 | 378382 | 2020-07-28 | Morgan | Ohio | 39115 | 17 | 0 |
339907 | 339907 | 2020-07-16 | Meigs | Ohio | 39105 | 17 | 0 |
304889 | 304889 | 2020-07-05 | Gallia | Ohio | 39053 | 17 | 1 |
295416 | 295416 | 2020-07-02 | Jackson | Ohio | 39079 | 17 | 0 |
292261 | 292261 | 2020-07-01 | Jackson | Ohio | 39079 | 17 | 0 |
289109 | 289109 | 2020-06-30 | Jackson | Ohio | 39079 | 17 | 0 |
285959 | 285959 | 2020-06-29 | Jackson | Ohio | 39079 | 17 | 0 |
282814 | 282814 | 2020-06-28 | Jackson | Ohio | 39079 | 17 | 0 |
279668 | 279668 | 2020-06-27 | Jackson | Ohio | 39079 | 17 | 0 |
276520 | 276520 | 2020-06-26 | Jackson | Ohio | 39079 | 17 | 0 |
273373 | 273373 | 2020-06-25 | Jackson | Ohio | 39079 | 17 | 0 |
270260 | 270260 | 2020-06-24 | Pike | Ohio | 39131 | 17 | 0 |
267126 | 267126 | 2020-06-23 | Pike | Ohio | 39131 | 17 | 0 |
263998 | 263998 | 2020-06-22 | Pike | Ohio | 39131 | 17 | 0 |
251500 | 251500 | 2020-06-18 | Paulding | Ohio | 39125 | 17 | 0 |
248323 | 248323 | 2020-06-17 | Adams | Ohio | 39001 | 17 | 1 |
248385 | 248385 | 2020-06-17 | Paulding | Ohio | 39125 | 17 | 0 |
245210 | 245210 | 2020-06-16 | Adams | Ohio | 39001 | 17 | 1 |
245272 | 245272 | 2020-06-16 | Paulding | Ohio | 39125 | 17 | 0 |
211138 | 211138 | 2020-06-05 | Henry | Ohio | 39069 | 17 | 0 |
208056 | 208056 | 2020-06-04 | Henry | Ohio | 39069 | 17 | 0 |
208094 | 208094 | 2020-06-04 | Scioto | Ohio | 39145 | 17 | 0 |
204975 | 204975 | 2020-06-03 | Henry | Ohio | 39069 | 17 | 0 |
205013 | 205013 | 2020-06-03 | Scioto | Ohio | 39145 | 17 | 0 |
201936 | 201936 | 2020-06-02 | Scioto | Ohio | 39145 | 17 | 0 |
174331 | 174331 | 2020-05-24 | Ashland | Ohio | 39005 | 17 | 0 |
171289 | 171289 | 2020-05-23 | Ashland | Ohio | 39005 | 17 | 0 |
171350 | 171350 | 2020-05-23 | Perry | Ohio | 39127 | 17 | 1 |
171360 | 171360 | 2020-05-23 | Seneca | Ohio | 39147 | 17 | 2 |
168250 | 168250 | 2020-05-22 | Ashland | Ohio | 39005 | 17 | 0 |
168311 | 168311 | 2020-05-22 | Perry | Ohio | 39127 | 17 | 1 |
165214 | 165214 | 2020-05-21 | Ashland | Ohio | 39005 | 17 | 0 |
165293 | 165293 | 2020-05-21 | Vinton | Ohio | 39163 | 17 | 0 |
162185 | 162185 | 2020-05-20 | Ashland | Ohio | 39005 | 17 | 0 |
135126 | 135126 | 2020-05-11 | Brown | Ohio | 39015 | 17 | 1 |
132135 | 132135 | 2020-05-10 | Brown | Ohio | 39015 | 17 | 1 |
129149 | 129149 | 2020-05-09 | Champaign | Ohio | 39021 | 17 | 1 |
120205 | 120205 | 2020-05-06 | Coshocton | Ohio | 39031 | 17 | 0 |
117244 | 117244 | 2020-05-05 | Coshocton | Ohio | 39031 | 17 | 0 |
114363 | 114363 | 2020-05-04 | Coshocton | Ohio | 39031 | 17 | 0 |
111482 | 111482 | 2020-05-03 | Coshocton | Ohio | 39031 | 17 | 0 |
111526 | 111526 | 2020-05-03 | Muskingum | Ohio | 39119 | 17 | 0 |
108608 | 108608 | 2020-05-02 | Coshocton | Ohio | 39031 | 17 | 0 |
108616 | 108616 | 2020-05-02 | Fayette | Ohio | 39047 | 17 | 0 |
108652 | 108652 | 2020-05-02 | Muskingum | Ohio | 39119 | 17 | 0 |
105741 | 105741 | 2020-05-01 | Coshocton | Ohio | 39031 | 17 | 0 |
102878 | 102878 | 2020-04-30 | Coshocton | Ohio | 39031 | 17 | 0 |
100025 | 100025 | 2020-04-29 | Coshocton | Ohio | 39031 | 17 | 0 |
97176 | 97176 | 2020-04-28 | Coshocton | Ohio | 39031 | 17 | 0 |
85947 | 85947 | 2020-04-24 | Union | Ohio | 39159 | 17 | 0 |
83083 | 83083 | 2020-04-23 | Defiance | Ohio | 39039 | 17 | 1 |
80284 | 80284 | 2020-04-22 | Defiance | Ohio | 39039 | 17 | 0 |
80336 | 80336 | 2020-04-22 | Sandusky | Ohio | 39143 | 17 | 2 |
77546 | 77546 | 2020-04-21 | Sandusky | Ohio | 39143 | 17 | 2 |
74726 | 74726 | 2020-04-20 | Hardin | Ohio | 39065 | 17 | 0 |
74765 | 74765 | 2020-04-20 | Sandusky | Ohio | 39143 | 17 | 2 |
74780 | 74780 | 2020-04-20 | Wyandot | Ohio | 39175 | 17 | 2 |
71944 | 71944 | 2020-04-19 | Fulton | Ohio | 39051 | 17 | 0 |
71951 | 71951 | 2020-04-19 | Hardin | Ohio | 39065 | 17 | 0 |
72005 | 72005 | 2020-04-19 | Wyandot | Ohio | 39175 | 17 | 2 |
69223 | 69223 | 2020-04-18 | Sandusky | Ohio | 39143 | 17 | 2 |
69238 | 69238 | 2020-04-18 | Wyandot | Ohio | 39175 | 17 | 2 |
63713 | 63713 | 2020-04-16 | Ottawa | Ohio | 39123 | 17 | 0 |
60969 | 60969 | 2020-04-15 | Lawrence | Ohio | 39087 | 17 | 0 |
58254 | 58254 | 2020-04-14 | Lawrence | Ohio | 39087 | 17 | 0 |
58278 | 58278 | 2020-04-14 | Preble | Ohio | 39135 | 17 | 1 |
55527 | 55527 | 2020-04-13 | Crawford | Ohio | 39033 | 17 | 0 |
55553 | 55553 | 2020-04-13 | Lawrence | Ohio | 39087 | 17 | 0 |
52896 | 52896 | 2020-04-12 | Ross | Ohio | 39141 | 17 | 0 |
47530 | 47530 | 2020-04-10 | Hancock | Ohio | 39063 | 17 | 1 |
42330 | 42330 | 2020-04-08 | Hancock | Ohio | 39063 | 17 | 0 |
37268 | 37268 | 2020-04-06 | Madison | Ohio | 39097 | 17 | 2 |
37292 | 37292 | 2020-04-06 | Shelby | Ohio | 39149 | 17 | 0 |
34799 | 34799 | 2020-04-05 | Madison | Ohio | 39097 | 17 | 2 |
34815 | 34815 | 2020-04-05 | Richland | Ohio | 39139 | 17 | 0 |
32328 | 32328 | 2020-04-04 | Belmont | Ohio | 39013 | 17 | 0 |
30000 | 30000 | 2020-04-03 | Tuscarawas | Ohio | 39157 | 17 | 0 |
18994 | 18994 | 2020-03-29 | Geauga | Ohio | 39055 | 17 | 0 |
19004 | 19004 | 2020-03-29 | Licking | Ohio | 39089 | 17 | 0 |
15248 | 15248 | 2020-03-27 | Trumbull | Ohio | 39155 | 17 | 1 |
9096 | 9096 | 2020-03-23 | Butler | Ohio | 39017 | 17 | 0 |
9125 | 9125 | 2020-03-23 | Miami | Ohio | 39109 | 17 | 0 |
7893 | 7893 | 2020-03-22 | Butler | Ohio | 39017 | 17 | 0 |
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);