ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 77 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
653230 | 653230 | 2020-10-21 | Morgan | Ohio | 39115 | 77 | 0 |
468620 | 468620 | 2020-08-25 | Paulding | Ohio | 39125 | 77 | 0 |
465392 | 465392 | 2020-08-24 | Paulding | Ohio | 39125 | 77 | 0 |
462163 | 462163 | 2020-08-23 | Paulding | Ohio | 39125 | 77 | 0 |
455725 | 455725 | 2020-08-21 | Van Wert | Ohio | 39161 | 77 | 2 |
449189 | 449189 | 2020-08-19 | Adams | Ohio | 39001 | 77 | 3 |
426645 | 426645 | 2020-08-12 | Jackson | Ohio | 39079 | 77 | 0 |
420225 | 420225 | 2020-08-10 | Pike | Ohio | 39131 | 77 | 0 |
365482 | 365482 | 2020-07-24 | Brown | Ohio | 39015 | 77 | 1 |
362279 | 362279 | 2020-07-23 | Champaign | Ohio | 39021 | 77 | 1 |
359073 | 359073 | 2020-07-22 | Champaign | Ohio | 39021 | 77 | 1 |
355894 | 355894 | 2020-07-21 | Highland | Ohio | 39071 | 77 | 1 |
352675 | 352675 | 2020-07-20 | Defiance | Ohio | 39039 | 77 | 3 |
339900 | 339900 | 2020-07-16 | Logan | Ohio | 39091 | 77 | 1 |
336733 | 336733 | 2020-07-15 | Shelby | Ohio | 39149 | 77 | 4 |
333550 | 333550 | 2020-07-14 | Williams | Ohio | 39171 | 77 | 2 |
330345 | 330345 | 2020-07-13 | Scioto | Ohio | 39145 | 77 | 0 |
330347 | 330347 | 2020-07-13 | Shelby | Ohio | 39149 | 77 | 4 |
330358 | 330358 | 2020-07-13 | Williams | Ohio | 39171 | 77 | 2 |
289149 | 289149 | 2020-06-30 | Union | Ohio | 39159 | 77 | 1 |
285999 | 285999 | 2020-06-29 | Union | Ohio | 39159 | 77 | 1 |
282854 | 282854 | 2020-06-28 | Union | Ohio | 39159 | 77 | 1 |
242136 | 242136 | 2020-06-15 | Huron | Ohio | 39077 | 77 | 1 |
239027 | 239027 | 2020-06-14 | Huron | Ohio | 39077 | 77 | 1 |
226637 | 226637 | 2020-06-10 | Ross | Ohio | 39141 | 77 | 2 |
223499 | 223499 | 2020-06-09 | Hardin | Ohio | 39065 | 77 | 3 |
211109 | 211109 | 2020-06-05 | Auglaize | Ohio | 39011 | 77 | 3 |
208027 | 208027 | 2020-06-04 | Auglaize | Ohio | 39011 | 77 | 3 |
189637 | 189637 | 2020-05-29 | Monroe | Ohio | 39111 | 77 | 12 |
144168 | 144168 | 2020-05-14 | Putnam | Ohio | 39137 | 77 | 13 |
141173 | 141173 | 2020-05-13 | Putnam | Ohio | 39137 | 77 | 13 |
138177 | 138177 | 2020-05-12 | Putnam | Ohio | 39137 | 77 | 13 |
135135 | 135135 | 2020-05-11 | Crawford | Ohio | 39033 | 77 | 1 |
117247 | 117247 | 2020-05-05 | Darke | Ohio | 39037 | 77 | 14 |
114366 | 114366 | 2020-05-04 | Darke | Ohio | 39037 | 77 | 14 |
111485 | 111485 | 2020-05-03 | Darke | Ohio | 39037 | 77 | 14 |
91510 | 91510 | 2020-04-26 | Clermont | Ohio | 39025 | 77 | 2 |
88694 | 88694 | 2020-04-25 | Clermont | Ohio | 39025 | 77 | 2 |
88751 | 88751 | 2020-04-25 | Richland | Ohio | 39139 | 77 | 1 |
85880 | 85880 | 2020-04-24 | Clermont | Ohio | 39025 | 77 | 2 |
69235 | 69235 | 2020-04-18 | Wayne | Ohio | 39169 | 77 | 12 |
39761 | 39761 | 2020-04-07 | Delaware | Ohio | 39041 | 77 | 1 |
37244 | 37244 | 2020-04-06 | Delaware | Ohio | 39041 | 77 | 1 |
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);