ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where cases = 16 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
423443 | 423443 | 2020-08-11 | Noble | Ohio | 39121 | 16 | 0 |
420220 | 420220 | 2020-08-10 | Noble | Ohio | 39121 | 16 | 0 |
417000 | 417000 | 2020-08-09 | Noble | Ohio | 39121 | 16 | 0 |
410559 | 410559 | 2020-08-07 | Noble | Ohio | 39121 | 16 | 0 |
404120 | 404120 | 2020-08-05 | Noble | Ohio | 39121 | 16 | 0 |
400902 | 400902 | 2020-08-04 | Noble | Ohio | 39121 | 16 | 0 |
394470 | 394470 | 2020-08-02 | Noble | Ohio | 39121 | 16 | 0 |
391254 | 391254 | 2020-08-01 | Noble | Ohio | 39121 | 16 | 0 |
388037 | 388037 | 2020-07-31 | Noble | Ohio | 39121 | 16 | 0 |
384820 | 384820 | 2020-07-30 | Noble | Ohio | 39121 | 16 | 0 |
381602 | 381602 | 2020-07-29 | Noble | Ohio | 39121 | 16 | 0 |
378385 | 378385 | 2020-07-28 | Noble | Ohio | 39121 | 16 | 0 |
375141 | 375141 | 2020-07-27 | Harrison | Ohio | 39067 | 16 | 1 |
375165 | 375165 | 2020-07-27 | Morgan | Ohio | 39115 | 16 | 0 |
375168 | 375168 | 2020-07-27 | Noble | Ohio | 39121 | 16 | 0 |
371929 | 371929 | 2020-07-26 | Harrison | Ohio | 39067 | 16 | 1 |
371953 | 371953 | 2020-07-26 | Morgan | Ohio | 39115 | 16 | 0 |
371956 | 371956 | 2020-07-26 | Noble | Ohio | 39121 | 16 | 0 |
368717 | 368717 | 2020-07-25 | Harrison | Ohio | 39067 | 16 | 1 |
368741 | 368741 | 2020-07-25 | Morgan | Ohio | 39115 | 16 | 0 |
368744 | 368744 | 2020-07-25 | Noble | Ohio | 39121 | 16 | 0 |
365508 | 365508 | 2020-07-24 | Harrison | Ohio | 39067 | 16 | 1 |
365532 | 365532 | 2020-07-24 | Morgan | Ohio | 39115 | 16 | 0 |
365535 | 365535 | 2020-07-24 | Noble | Ohio | 39121 | 16 | 0 |
362326 | 362326 | 2020-07-23 | Morgan | Ohio | 39115 | 16 | 0 |
362329 | 362329 | 2020-07-23 | Noble | Ohio | 39121 | 16 | 0 |
359123 | 359123 | 2020-07-22 | Noble | Ohio | 39121 | 16 | 0 |
355919 | 355919 | 2020-07-21 | Noble | Ohio | 39121 | 16 | 0 |
352689 | 352689 | 2020-07-20 | Harrison | Ohio | 39067 | 16 | 1 |
352716 | 352716 | 2020-07-20 | Noble | Ohio | 39121 | 16 | 0 |
349486 | 349486 | 2020-07-19 | Harrison | Ohio | 39067 | 16 | 1 |
349513 | 349513 | 2020-07-19 | Noble | Ohio | 39121 | 16 | 0 |
346285 | 346285 | 2020-07-18 | Harrison | Ohio | 39067 | 16 | 1 |
343086 | 343086 | 2020-07-17 | Harrison | Ohio | 39067 | 16 | 1 |
339888 | 339888 | 2020-07-16 | Harrison | Ohio | 39067 | 16 | 1 |
301726 | 301726 | 2020-07-04 | Gallia | Ohio | 39053 | 16 | 1 |
270234 | 270234 | 2020-06-24 | Jackson | Ohio | 39079 | 16 | 0 |
267100 | 267100 | 2020-06-23 | Jackson | Ohio | 39079 | 16 | 0 |
263972 | 263972 | 2020-06-22 | Jackson | Ohio | 39079 | 16 | 0 |
264013 | 264013 | 2020-06-22 | Van Wert | Ohio | 39161 | 16 | 0 |
260844 | 260844 | 2020-06-21 | Jackson | Ohio | 39079 | 16 | 0 |
260885 | 260885 | 2020-06-21 | Van Wert | Ohio | 39161 | 16 | 0 |
257717 | 257717 | 2020-06-20 | Jackson | Ohio | 39079 | 16 | 0 |
257759 | 257759 | 2020-06-20 | Van Wert | Ohio | 39161 | 16 | 0 |
254592 | 254592 | 2020-06-19 | Jackson | Ohio | 39079 | 16 | 0 |
251477 | 251477 | 2020-06-18 | Jackson | Ohio | 39079 | 16 | 0 |
248362 | 248362 | 2020-06-17 | Jackson | Ohio | 39079 | 16 | 0 |
245249 | 245249 | 2020-06-16 | Jackson | Ohio | 39079 | 16 | 0 |
242137 | 242137 | 2020-06-15 | Jackson | Ohio | 39079 | 16 | 0 |
242160 | 242160 | 2020-06-15 | Paulding | Ohio | 39125 | 16 | 0 |
239028 | 239028 | 2020-06-14 | Jackson | Ohio | 39079 | 16 | 0 |
235920 | 235920 | 2020-06-13 | Jackson | Ohio | 39079 | 16 | 0 |
232815 | 232815 | 2020-06-12 | Jackson | Ohio | 39079 | 16 | 0 |
229710 | 229710 | 2020-06-11 | Jackson | Ohio | 39079 | 16 | 0 |
226606 | 226606 | 2020-06-10 | Jackson | Ohio | 39079 | 16 | 0 |
223506 | 223506 | 2020-06-09 | Jackson | Ohio | 39079 | 16 | 0 |
201898 | 201898 | 2020-06-02 | Henry | Ohio | 39069 | 16 | 0 |
198823 | 198823 | 2020-06-01 | Henry | Ohio | 39069 | 16 | 0 |
195788 | 195788 | 2020-05-31 | Scioto | Ohio | 39145 | 16 | 0 |
168283 | 168283 | 2020-05-22 | Highland | Ohio | 39071 | 16 | 1 |
168321 | 168321 | 2020-05-22 | Seneca | Ohio | 39147 | 16 | 2 |
165247 | 165247 | 2020-05-21 | Highland | Ohio | 39071 | 16 | 1 |
165275 | 165275 | 2020-05-21 | Perry | Ohio | 39127 | 16 | 1 |
165285 | 165285 | 2020-05-21 | Seneca | Ohio | 39147 | 16 | 2 |
162218 | 162218 | 2020-05-20 | Highland | Ohio | 39071 | 16 | 1 |
162256 | 162256 | 2020-05-20 | Seneca | Ohio | 39147 | 16 | 2 |
162264 | 162264 | 2020-05-20 | Vinton | Ohio | 39163 | 16 | 0 |
159219 | 159219 | 2020-05-19 | Perry | Ohio | 39127 | 16 | 1 |
159237 | 159237 | 2020-05-19 | Vinton | Ohio | 39163 | 16 | 0 |
156217 | 156217 | 2020-05-18 | Vinton | Ohio | 39163 | 16 | 0 |
153154 | 153154 | 2020-05-17 | Highland | Ohio | 39071 | 16 | 1 |
153200 | 153200 | 2020-05-17 | Vinton | Ohio | 39163 | 16 | 0 |
150189 | 150189 | 2020-05-16 | Vinton | Ohio | 39163 | 16 | 0 |
147182 | 147182 | 2020-05-15 | Vinton | Ohio | 39163 | 16 | 0 |
129146 | 129146 | 2020-05-09 | Brown | Ohio | 39015 | 16 | 1 |
126157 | 126157 | 2020-05-08 | Brown | Ohio | 39015 | 16 | 1 |
126160 | 126160 | 2020-05-08 | Champaign | Ohio | 39021 | 16 | 1 |
123174 | 123174 | 2020-05-07 | Brown | Ohio | 39015 | 16 | 1 |
123177 | 123177 | 2020-05-07 | Champaign | Ohio | 39021 | 16 | 1 |
108622 | 108622 | 2020-05-02 | Guernsey | Ohio | 39059 | 16 | 0 |
105749 | 105749 | 2020-05-01 | Fayette | Ohio | 39047 | 16 | 0 |
105767 | 105767 | 2020-05-01 | Knox | Ohio | 39083 | 16 | 1 |
102904 | 102904 | 2020-04-30 | Knox | Ohio | 39083 | 16 | 1 |
100046 | 100046 | 2020-04-29 | Hocking | Ohio | 39073 | 16 | 1 |
100051 | 100051 | 2020-04-29 | Knox | Ohio | 39083 | 16 | 1 |
97197 | 97197 | 2020-04-28 | Hocking | Ohio | 39073 | 16 | 1 |
94339 | 94339 | 2020-04-27 | Coshocton | Ohio | 39031 | 16 | 0 |
94360 | 94360 | 2020-04-27 | Hocking | Ohio | 39073 | 16 | 1 |
91513 | 91513 | 2020-04-26 | Coshocton | Ohio | 39031 | 16 | 0 |
88697 | 88697 | 2020-04-25 | Coshocton | Ohio | 39031 | 16 | 0 |
85883 | 85883 | 2020-04-24 | Coshocton | Ohio | 39031 | 16 | 0 |
85913 | 85913 | 2020-04-24 | Logan | Ohio | 39091 | 16 | 0 |
85921 | 85921 | 2020-04-24 | Mercer | Ohio | 39107 | 16 | 1 |
83079 | 83079 | 2020-04-23 | Coshocton | Ohio | 39031 | 16 | 0 |
83117 | 83117 | 2020-04-23 | Mercer | Ohio | 39107 | 16 | 1 |
83143 | 83143 | 2020-04-23 | Union | Ohio | 39159 | 16 | 0 |
80280 | 80280 | 2020-04-22 | Coshocton | Ohio | 39031 | 16 | 0 |
80344 | 80344 | 2020-04-22 | Union | Ohio | 39159 | 16 | 0 |
80349 | 80349 | 2020-04-22 | Williams | Ohio | 39171 | 16 | 1 |
77484 | 77484 | 2020-04-21 | Carroll | Ohio | 39019 | 16 | 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);