ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 114 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
672718 | 672718 | 2020-10-27 | Vinton | Ohio | 39163 | 114 | 3 |
617537 | 617537 | 2020-10-10 | Monroe | Ohio | 39111 | 114 | 18 |
614295 | 614295 | 2020-10-09 | Monroe | Ohio | 39111 | 114 | 18 |
562455 | 562455 | 2020-09-23 | Van Wert | Ohio | 39161 | 114 | 3 |
559218 | 559218 | 2020-09-22 | Van Wert | Ohio | 39161 | 114 | 3 |
555981 | 555981 | 2020-09-21 | Van Wert | Ohio | 39161 | 114 | 3 |
539713 | 539713 | 2020-09-16 | Adams | Ohio | 39001 | 114 | 4 |
462127 | 462127 | 2020-08-23 | Gallia | Ohio | 39053 | 114 | 2 |
429840 | 429840 | 2020-08-13 | Carroll | Ohio | 39019 | 114 | 5 |
407308 | 407308 | 2020-08-06 | Guernsey | Ohio | 39059 | 114 | 7 |
407315 | 407315 | 2020-08-06 | Hocking | Ohio | 39073 | 114 | 9 |
404096 | 404096 | 2020-08-05 | Hocking | Ohio | 39073 | 114 | 9 |
388022 | 388022 | 2020-07-31 | Logan | Ohio | 39091 | 114 | 1 |
384795 | 384795 | 2020-07-30 | Highland | Ohio | 39071 | 114 | 1 |
384847 | 384847 | 2020-07-30 | Wyandot | Ohio | 39175 | 114 | 5 |
359130 | 359130 | 2020-07-22 | Preble | Ohio | 39135 | 114 | 2 |
289128 | 289128 | 2020-06-30 | Morrow | Ohio | 39117 | 114 | 1 |
285978 | 285978 | 2020-06-29 | Morrow | Ohio | 39117 | 114 | 1 |
279700 | 279700 | 2020-06-27 | Sandusky | Ohio | 39143 | 114 | 13 |
276552 | 276552 | 2020-06-26 | Sandusky | Ohio | 39143 | 114 | 13 |
232837 | 232837 | 2020-06-12 | Ottawa | Ohio | 39123 | 114 | 21 |
220400 | 220400 | 2020-06-08 | Greene | Ohio | 39057 | 114 | 5 |
195732 | 195732 | 2020-05-31 | Crawford | Ohio | 39033 | 114 | 4 |
192662 | 192662 | 2020-05-30 | Crawford | Ohio | 39033 | 114 | 4 |
141116 | 141116 | 2020-05-13 | Clark | Ohio | 39023 | 114 | 3 |
138192 | 138192 | 2020-05-12 | Washington | Ohio | 39167 | 114 | 17 |
135202 | 135202 | 2020-05-11 | Washington | Ohio | 39167 | 114 | 17 |
132211 | 132211 | 2020-05-10 | Washington | Ohio | 39167 | 114 | 17 |
97205 | 97205 | 2020-04-28 | Licking | Ohio | 39089 | 114 | 5 |
94330 | 94330 | 2020-04-27 | Belmont | Ohio | 39013 | 114 | 7 |
94407 | 94407 | 2020-04-27 | Wayne | Ohio | 39169 | 114 | 22 |
91520 | 91520 | 2020-04-26 | Fairfield | Ohio | 39045 | 114 | 2 |
63672 | 63672 | 2020-04-16 | Delaware | Ohio | 39041 | 114 | 3 |
55525 | 55525 | 2020-04-13 | Columbiana | Ohio | 39029 | 114 | 6 |
52868 | 52868 | 2020-04-12 | Lake | Ohio | 39085 | 114 | 6 |
42371 | 42371 | 2020-04-08 | Stark | Ohio | 39151 | 114 | 7 |
21052 | 21052 | 2020-03-30 | Lucas | Ohio | 39095 | 114 | 3 |
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);