ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 79 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 |
---|---|---|---|---|---|---|---|
653206 | 653206 | 2020-10-21 | Harrison | Ohio | 39067 | 79 | 3 |
649961 | 649961 | 2020-10-20 | Harrison | Ohio | 39067 | 79 | 3 |
481553 | 481553 | 2020-08-29 | Paulding | Ohio | 39125 | 79 | 0 |
478319 | 478319 | 2020-08-28 | Paulding | Ohio | 39125 | 79 | 0 |
475086 | 475086 | 2020-08-27 | Paulding | Ohio | 39125 | 79 | 0 |
471852 | 471852 | 2020-08-26 | Paulding | Ohio | 39125 | 79 | 0 |
462181 | 462181 | 2020-08-23 | Van Wert | Ohio | 39161 | 79 | 2 |
458925 | 458925 | 2020-08-22 | Meigs | Ohio | 39105 | 79 | 0 |
458953 | 458953 | 2020-08-22 | Van Wert | Ohio | 39161 | 79 | 2 |
452417 | 452417 | 2020-08-20 | Adams | Ohio | 39001 | 79 | 3 |
433096 | 433096 | 2020-08-14 | Jackson | Ohio | 39079 | 79 | 0 |
423448 | 423448 | 2020-08-11 | Pike | Ohio | 39131 | 79 | 0 |
339929 | 339929 | 2020-07-16 | Shelby | Ohio | 39149 | 79 | 4 |
320734 | 320734 | 2020-07-10 | Clinton | Ohio | 39027 | 79 | 1 |
320750 | 320750 | 2020-07-10 | Guernsey | Ohio | 39059 | 79 | 3 |
317580 | 317580 | 2020-07-09 | Hocking | Ohio | 39073 | 79 | 8 |
317587 | 317587 | 2020-07-09 | Lawrence | Ohio | 39087 | 79 | 0 |
314375 | 314375 | 2020-07-08 | Athens | Ohio | 39009 | 79 | 1 |
314407 | 314407 | 2020-07-08 | Hocking | Ohio | 39073 | 79 | 8 |
311230 | 311230 | 2020-07-07 | Hancock | Ohio | 39063 | 79 | 1 |
308061 | 308061 | 2020-07-06 | Hancock | Ohio | 39063 | 79 | 1 |
245248 | 245248 | 2020-06-16 | Huron | Ohio | 39077 | 79 | 1 |
242168 | 242168 | 2020-06-15 | Ross | Ohio | 39141 | 79 | 2 |
239059 | 239059 | 2020-06-14 | Ross | Ohio | 39141 | 79 | 2 |
235951 | 235951 | 2020-06-13 | Ross | Ohio | 39141 | 79 | 2 |
232846 | 232846 | 2020-06-12 | Ross | Ohio | 39141 | 79 | 2 |
204996 | 204996 | 2020-06-03 | Monroe | Ohio | 39111 | 79 | 14 |
201919 | 201919 | 2020-06-02 | Monroe | Ohio | 39111 | 79 | 14 |
198844 | 198844 | 2020-06-01 | Monroe | Ohio | 39111 | 79 | 14 |
195787 | 195787 | 2020-05-31 | Sandusky | Ohio | 39143 | 79 | 11 |
138125 | 138125 | 2020-05-12 | Crawford | Ohio | 39033 | 79 | 1 |
129160 | 129160 | 2020-05-09 | Erie | Ohio | 39043 | 79 | 3 |
123185 | 123185 | 2020-05-07 | Darke | Ohio | 39037 | 79 | 14 |
120208 | 120208 | 2020-05-06 | Darke | Ohio | 39037 | 79 | 14 |
71920 | 71920 | 2020-04-19 | Allen | Ohio | 39003 | 79 | 11 |
72002 | 72002 | 2020-04-19 | Wayne | Ohio | 39169 | 79 | 12 |
47541 | 47541 | 2020-04-10 | Licking | Ohio | 39089 | 79 | 3 |
42319 | 42319 | 2020-04-08 | Delaware | Ohio | 39041 | 79 | 1 |
34793 | 34793 | 2020-04-05 | Lake | Ohio | 39085 | 79 | 3 |
29997 | 29997 | 2020-04-03 | Stark | Ohio | 39151 | 79 | 4 |
17091 | 17091 | 2020-03-28 | Summit | Ohio | 39153 | 79 | 4 |
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);