ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 39091 and state = "Ohio" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
9118 | 9118 | 2020-03-23 | Logan | Ohio | 39091 | 1 | 0 |
10434 | 10434 | 2020-03-24 | Logan | Ohio | 39091 | 2 | 0 |
11883 | 11883 | 2020-03-25 | Logan | Ohio | 39091 | 2 | 0 |
13491 | 13491 | 2020-03-26 | Logan | Ohio | 39091 | 2 | 0 |
15229 | 15229 | 2020-03-27 | Logan | Ohio | 39091 | 2 | 0 |
17071 | 17071 | 2020-03-28 | Logan | Ohio | 39091 | 3 | 0 |
19005 | 19005 | 2020-03-29 | Logan | Ohio | 39091 | 3 | 0 |
21050 | 21050 | 2020-03-30 | Logan | Ohio | 39091 | 3 | 0 |
23182 | 23182 | 2020-03-31 | Logan | Ohio | 39091 | 3 | 0 |
25377 | 25377 | 2020-04-01 | Logan | Ohio | 39091 | 3 | 0 |
27645 | 27645 | 2020-04-02 | Logan | Ohio | 39091 | 3 | 0 |
29974 | 29974 | 2020-04-03 | Logan | Ohio | 39091 | 3 | 0 |
32363 | 32363 | 2020-04-04 | Logan | Ohio | 39091 | 3 | 0 |
34796 | 34796 | 2020-04-05 | Logan | Ohio | 39091 | 5 | 0 |
37265 | 37265 | 2020-04-06 | Logan | Ohio | 39091 | 5 | 0 |
39782 | 39782 | 2020-04-07 | Logan | Ohio | 39091 | 5 | 0 |
42342 | 42342 | 2020-04-08 | Logan | Ohio | 39091 | 5 | 0 |
44927 | 44927 | 2020-04-09 | Logan | Ohio | 39091 | 5 | 0 |
47542 | 47542 | 2020-04-10 | Logan | Ohio | 39091 | 7 | 0 |
50198 | 50198 | 2020-04-11 | Logan | Ohio | 39091 | 7 | 0 |
52871 | 52871 | 2020-04-12 | Logan | Ohio | 39091 | 7 | 0 |
55555 | 55555 | 2020-04-13 | Logan | Ohio | 39091 | 8 | 0 |
58256 | 58256 | 2020-04-14 | Logan | Ohio | 39091 | 8 | 0 |
60971 | 60971 | 2020-04-15 | Logan | Ohio | 39091 | 8 | 0 |
63697 | 63697 | 2020-04-16 | Logan | Ohio | 39091 | 8 | 0 |
66440 | 66440 | 2020-04-17 | Logan | Ohio | 39091 | 12 | 0 |
69197 | 69197 | 2020-04-18 | Logan | Ohio | 39091 | 13 | 0 |
71964 | 71964 | 2020-04-19 | Logan | Ohio | 39091 | 13 | 0 |
74739 | 74739 | 2020-04-20 | Logan | Ohio | 39091 | 13 | 0 |
77520 | 77520 | 2020-04-21 | Logan | Ohio | 39091 | 13 | 0 |
80310 | 80310 | 2020-04-22 | Logan | Ohio | 39091 | 14 | 0 |
83109 | 83109 | 2020-04-23 | Logan | Ohio | 39091 | 15 | 0 |
85913 | 85913 | 2020-04-24 | Logan | Ohio | 39091 | 16 | 0 |
88727 | 88727 | 2020-04-25 | Logan | Ohio | 39091 | 18 | 0 |
91543 | 91543 | 2020-04-26 | Logan | Ohio | 39091 | 18 | 0 |
94369 | 94369 | 2020-04-27 | Logan | Ohio | 39091 | 18 | 0 |
97206 | 97206 | 2020-04-28 | Logan | Ohio | 39091 | 18 | 0 |
100055 | 100055 | 2020-04-29 | Logan | Ohio | 39091 | 18 | 0 |
102908 | 102908 | 2020-04-30 | Logan | Ohio | 39091 | 18 | 0 |
105771 | 105771 | 2020-05-01 | Logan | Ohio | 39091 | 18 | 0 |
108638 | 108638 | 2020-05-02 | Logan | Ohio | 39091 | 19 | 0 |
111512 | 111512 | 2020-05-03 | Logan | Ohio | 39091 | 19 | 0 |
114393 | 114393 | 2020-05-04 | Logan | Ohio | 39091 | 19 | 0 |
117274 | 117274 | 2020-05-05 | Logan | Ohio | 39091 | 19 | 0 |
120235 | 120235 | 2020-05-06 | Logan | Ohio | 39091 | 19 | 0 |
123212 | 123212 | 2020-05-07 | Logan | Ohio | 39091 | 23 | 0 |
126195 | 126195 | 2020-05-08 | Logan | Ohio | 39091 | 23 | 0 |
129184 | 129184 | 2020-05-09 | Logan | Ohio | 39091 | 23 | 0 |
132173 | 132173 | 2020-05-10 | Logan | Ohio | 39091 | 23 | 0 |
135164 | 135164 | 2020-05-11 | Logan | Ohio | 39091 | 23 | 0 |
138154 | 138154 | 2020-05-12 | Logan | Ohio | 39091 | 23 | 0 |
141150 | 141150 | 2020-05-13 | Logan | Ohio | 39091 | 23 | 0 |
144145 | 144145 | 2020-05-14 | Logan | Ohio | 39091 | 23 | 0 |
147146 | 147146 | 2020-05-15 | Logan | Ohio | 39091 | 24 | 0 |
150153 | 150153 | 2020-05-16 | Logan | Ohio | 39091 | 24 | 0 |
153164 | 153164 | 2020-05-17 | Logan | Ohio | 39091 | 23 | 0 |
156181 | 156181 | 2020-05-18 | Logan | Ohio | 39091 | 24 | 0 |
159201 | 159201 | 2020-05-19 | Logan | Ohio | 39091 | 24 | 0 |
162228 | 162228 | 2020-05-20 | Logan | Ohio | 39091 | 25 | 0 |
165257 | 165257 | 2020-05-21 | Logan | Ohio | 39091 | 32 | 0 |
168293 | 168293 | 2020-05-22 | Logan | Ohio | 39091 | 33 | 0 |
171332 | 171332 | 2020-05-23 | Logan | Ohio | 39091 | 38 | 0 |
174374 | 174374 | 2020-05-24 | Logan | Ohio | 39091 | 37 | 0 |
177418 | 177418 | 2020-05-25 | Logan | Ohio | 39091 | 37 | 0 |
180461 | 180461 | 2020-05-26 | Logan | Ohio | 39091 | 37 | 0 |
183510 | 183510 | 2020-05-27 | Logan | Ohio | 39091 | 37 | 0 |
186567 | 186567 | 2020-05-28 | Logan | Ohio | 39091 | 37 | 0 |
189627 | 189627 | 2020-05-29 | Logan | Ohio | 39091 | 37 | 0 |
192691 | 192691 | 2020-05-30 | Logan | Ohio | 39091 | 38 | 0 |
195761 | 195761 | 2020-05-31 | Logan | Ohio | 39091 | 39 | 0 |
198834 | 198834 | 2020-06-01 | Logan | Ohio | 39091 | 39 | 0 |
201909 | 201909 | 2020-06-02 | Logan | Ohio | 39091 | 40 | 0 |
204986 | 204986 | 2020-06-03 | Logan | Ohio | 39091 | 40 | 0 |
208067 | 208067 | 2020-06-04 | Logan | Ohio | 39091 | 43 | 0 |
211149 | 211149 | 2020-06-05 | Logan | Ohio | 39091 | 43 | 0 |
214235 | 214235 | 2020-06-06 | Logan | Ohio | 39091 | 43 | 0 |
217325 | 217325 | 2020-06-07 | Logan | Ohio | 39091 | 44 | 0 |
220417 | 220417 | 2020-06-08 | Logan | Ohio | 39091 | 46 | 0 |
223512 | 223512 | 2020-06-09 | Logan | Ohio | 39091 | 46 | 0 |
226612 | 226612 | 2020-06-10 | Logan | Ohio | 39091 | 46 | 0 |
229716 | 229716 | 2020-06-11 | Logan | Ohio | 39091 | 47 | 0 |
232821 | 232821 | 2020-06-12 | Logan | Ohio | 39091 | 47 | 0 |
235926 | 235926 | 2020-06-13 | Logan | Ohio | 39091 | 48 | 0 |
239034 | 239034 | 2020-06-14 | Logan | Ohio | 39091 | 48 | 0 |
242143 | 242143 | 2020-06-15 | Logan | Ohio | 39091 | 48 | 0 |
245255 | 245255 | 2020-06-16 | Logan | Ohio | 39091 | 48 | 0 |
248368 | 248368 | 2020-06-17 | Logan | Ohio | 39091 | 48 | 0 |
251483 | 251483 | 2020-06-18 | Logan | Ohio | 39091 | 48 | 0 |
254598 | 254598 | 2020-06-19 | Logan | Ohio | 39091 | 48 | 0 |
257723 | 257723 | 2020-06-20 | Logan | Ohio | 39091 | 48 | 0 |
260850 | 260850 | 2020-06-21 | Logan | Ohio | 39091 | 48 | 0 |
263978 | 263978 | 2020-06-22 | Logan | Ohio | 39091 | 50 | 0 |
267106 | 267106 | 2020-06-23 | Logan | Ohio | 39091 | 50 | 0 |
270240 | 270240 | 2020-06-24 | Logan | Ohio | 39091 | 50 | 0 |
273379 | 273379 | 2020-06-25 | Logan | Ohio | 39091 | 51 | 0 |
276526 | 276526 | 2020-06-26 | Logan | Ohio | 39091 | 52 | 0 |
279674 | 279674 | 2020-06-27 | Logan | Ohio | 39091 | 54 | 0 |
282820 | 282820 | 2020-06-28 | Logan | Ohio | 39091 | 56 | 0 |
285965 | 285965 | 2020-06-29 | Logan | Ohio | 39091 | 56 | 0 |
289115 | 289115 | 2020-06-30 | Logan | Ohio | 39091 | 58 | 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);