ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 39009 and state = "Ohio" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13460 | 13460 | 2020-03-26 | Athens | Ohio | 39009 | 1 | 0 |
15197 | 15197 | 2020-03-27 | Athens | Ohio | 39009 | 1 | 0 |
17038 | 17038 | 2020-03-28 | Athens | Ohio | 39009 | 2 | 0 |
18972 | 18972 | 2020-03-29 | Athens | Ohio | 39009 | 3 | 0 |
21015 | 21015 | 2020-03-30 | Athens | Ohio | 39009 | 3 | 1 |
23147 | 23147 | 2020-03-31 | Athens | Ohio | 39009 | 3 | 1 |
25342 | 25342 | 2020-04-01 | Athens | Ohio | 39009 | 3 | 1 |
27608 | 27608 | 2020-04-02 | Athens | Ohio | 39009 | 3 | 1 |
29937 | 29937 | 2020-04-03 | Athens | Ohio | 39009 | 3 | 1 |
32326 | 32326 | 2020-04-04 | Athens | Ohio | 39009 | 3 | 1 |
34759 | 34759 | 2020-04-05 | Athens | Ohio | 39009 | 3 | 1 |
37228 | 37228 | 2020-04-06 | Athens | Ohio | 39009 | 3 | 1 |
39745 | 39745 | 2020-04-07 | Athens | Ohio | 39009 | 3 | 1 |
42303 | 42303 | 2020-04-08 | Athens | Ohio | 39009 | 3 | 1 |
44888 | 44888 | 2020-04-09 | Athens | Ohio | 39009 | 3 | 1 |
47503 | 47503 | 2020-04-10 | Athens | Ohio | 39009 | 3 | 1 |
50158 | 50158 | 2020-04-11 | Athens | Ohio | 39009 | 3 | 1 |
52831 | 52831 | 2020-04-12 | Athens | Ohio | 39009 | 3 | 1 |
55515 | 55515 | 2020-04-13 | Athens | Ohio | 39009 | 3 | 1 |
58216 | 58216 | 2020-04-14 | Athens | Ohio | 39009 | 3 | 1 |
60930 | 60930 | 2020-04-15 | Athens | Ohio | 39009 | 3 | 1 |
63656 | 63656 | 2020-04-16 | Athens | Ohio | 39009 | 3 | 1 |
66399 | 66399 | 2020-04-17 | Athens | Ohio | 39009 | 3 | 1 |
69156 | 69156 | 2020-04-18 | Athens | Ohio | 39009 | 3 | 1 |
71923 | 71923 | 2020-04-19 | Athens | Ohio | 39009 | 3 | 1 |
74698 | 74698 | 2020-04-20 | Athens | Ohio | 39009 | 3 | 1 |
77479 | 77479 | 2020-04-21 | Athens | Ohio | 39009 | 3 | 1 |
80269 | 80269 | 2020-04-22 | Athens | Ohio | 39009 | 3 | 1 |
83068 | 83068 | 2020-04-23 | Athens | Ohio | 39009 | 4 | 1 |
85872 | 85872 | 2020-04-24 | Athens | Ohio | 39009 | 3 | 1 |
88686 | 88686 | 2020-04-25 | Athens | Ohio | 39009 | 3 | 1 |
91502 | 91502 | 2020-04-26 | Athens | Ohio | 39009 | 3 | 1 |
94328 | 94328 | 2020-04-27 | Athens | Ohio | 39009 | 3 | 1 |
97165 | 97165 | 2020-04-28 | Athens | Ohio | 39009 | 3 | 1 |
100014 | 100014 | 2020-04-29 | Athens | Ohio | 39009 | 3 | 1 |
102867 | 102867 | 2020-04-30 | Athens | Ohio | 39009 | 3 | 1 |
105730 | 105730 | 2020-05-01 | Athens | Ohio | 39009 | 4 | 1 |
108597 | 108597 | 2020-05-02 | Athens | Ohio | 39009 | 4 | 1 |
111471 | 111471 | 2020-05-03 | Athens | Ohio | 39009 | 4 | 1 |
114352 | 114352 | 2020-05-04 | Athens | Ohio | 39009 | 4 | 1 |
117233 | 117233 | 2020-05-05 | Athens | Ohio | 39009 | 4 | 1 |
120194 | 120194 | 2020-05-06 | Athens | Ohio | 39009 | 4 | 1 |
123171 | 123171 | 2020-05-07 | Athens | Ohio | 39009 | 4 | 1 |
126154 | 126154 | 2020-05-08 | Athens | Ohio | 39009 | 4 | 1 |
129143 | 129143 | 2020-05-09 | Athens | Ohio | 39009 | 5 | 1 |
132132 | 132132 | 2020-05-10 | Athens | Ohio | 39009 | 6 | 1 |
135123 | 135123 | 2020-05-11 | Athens | Ohio | 39009 | 6 | 1 |
138113 | 138113 | 2020-05-12 | Athens | Ohio | 39009 | 6 | 1 |
141109 | 141109 | 2020-05-13 | Athens | Ohio | 39009 | 6 | 1 |
144104 | 144104 | 2020-05-14 | Athens | Ohio | 39009 | 6 | 1 |
147105 | 147105 | 2020-05-15 | Athens | Ohio | 39009 | 8 | 1 |
150112 | 150112 | 2020-05-16 | Athens | Ohio | 39009 | 8 | 1 |
153123 | 153123 | 2020-05-17 | Athens | Ohio | 39009 | 8 | 1 |
156140 | 156140 | 2020-05-18 | Athens | Ohio | 39009 | 9 | 1 |
159160 | 159160 | 2020-05-19 | Athens | Ohio | 39009 | 13 | 1 |
162187 | 162187 | 2020-05-20 | Athens | Ohio | 39009 | 13 | 1 |
165216 | 165216 | 2020-05-21 | Athens | Ohio | 39009 | 13 | 1 |
168252 | 168252 | 2020-05-22 | Athens | Ohio | 39009 | 13 | 1 |
171291 | 171291 | 2020-05-23 | Athens | Ohio | 39009 | 13 | 1 |
174333 | 174333 | 2020-05-24 | Athens | Ohio | 39009 | 14 | 1 |
177377 | 177377 | 2020-05-25 | Athens | Ohio | 39009 | 14 | 1 |
180420 | 180420 | 2020-05-26 | Athens | Ohio | 39009 | 18 | 1 |
183469 | 183469 | 2020-05-27 | Athens | Ohio | 39009 | 18 | 1 |
186526 | 186526 | 2020-05-28 | Athens | Ohio | 39009 | 18 | 1 |
189586 | 189586 | 2020-05-29 | Athens | Ohio | 39009 | 18 | 1 |
192650 | 192650 | 2020-05-30 | Athens | Ohio | 39009 | 18 | 1 |
195720 | 195720 | 2020-05-31 | Athens | Ohio | 39009 | 18 | 1 |
198793 | 198793 | 2020-06-01 | Athens | Ohio | 39009 | 18 | 1 |
201868 | 201868 | 2020-06-02 | Athens | Ohio | 39009 | 18 | 1 |
204945 | 204945 | 2020-06-03 | Athens | Ohio | 39009 | 18 | 1 |
208026 | 208026 | 2020-06-04 | Athens | Ohio | 39009 | 18 | 1 |
211108 | 211108 | 2020-06-05 | Athens | Ohio | 39009 | 18 | 1 |
214194 | 214194 | 2020-06-06 | Athens | Ohio | 39009 | 18 | 1 |
217284 | 217284 | 2020-06-07 | Athens | Ohio | 39009 | 18 | 1 |
220376 | 220376 | 2020-06-08 | Athens | Ohio | 39009 | 18 | 1 |
223471 | 223471 | 2020-06-09 | Athens | Ohio | 39009 | 18 | 1 |
226571 | 226571 | 2020-06-10 | Athens | Ohio | 39009 | 22 | 1 |
229675 | 229675 | 2020-06-11 | Athens | Ohio | 39009 | 23 | 1 |
232780 | 232780 | 2020-06-12 | Athens | Ohio | 39009 | 23 | 1 |
235885 | 235885 | 2020-06-13 | Athens | Ohio | 39009 | 23 | 1 |
238993 | 238993 | 2020-06-14 | Athens | Ohio | 39009 | 23 | 1 |
242102 | 242102 | 2020-06-15 | Athens | Ohio | 39009 | 23 | 1 |
245214 | 245214 | 2020-06-16 | Athens | Ohio | 39009 | 23 | 1 |
248327 | 248327 | 2020-06-17 | Athens | Ohio | 39009 | 24 | 1 |
251442 | 251442 | 2020-06-18 | Athens | Ohio | 39009 | 24 | 1 |
254557 | 254557 | 2020-06-19 | Athens | Ohio | 39009 | 24 | 1 |
257682 | 257682 | 2020-06-20 | Athens | Ohio | 39009 | 24 | 1 |
260809 | 260809 | 2020-06-21 | Athens | Ohio | 39009 | 25 | 1 |
263937 | 263937 | 2020-06-22 | Athens | Ohio | 39009 | 25 | 1 |
267065 | 267065 | 2020-06-23 | Athens | Ohio | 39009 | 26 | 1 |
270199 | 270199 | 2020-06-24 | Athens | Ohio | 39009 | 28 | 1 |
273338 | 273338 | 2020-06-25 | Athens | Ohio | 39009 | 29 | 1 |
276485 | 276485 | 2020-06-26 | Athens | Ohio | 39009 | 29 | 1 |
279633 | 279633 | 2020-06-27 | Athens | Ohio | 39009 | 30 | 1 |
282779 | 282779 | 2020-06-28 | Athens | Ohio | 39009 | 30 | 1 |
285924 | 285924 | 2020-06-29 | Athens | Ohio | 39009 | 32 | 1 |
289074 | 289074 | 2020-06-30 | Athens | Ohio | 39009 | 33 | 1 |
292226 | 292226 | 2020-07-01 | Athens | Ohio | 39009 | 37 | 1 |
295381 | 295381 | 2020-07-02 | Athens | Ohio | 39009 | 37 | 1 |
298541 | 298541 | 2020-07-03 | Athens | Ohio | 39009 | 43 | 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);