ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39007 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
295380 | 295380 | 2020-07-02 | Ashtabula | Ohio | 39007 | 421 | 44 |
292225 | 292225 | 2020-07-01 | Ashtabula | Ohio | 39007 | 421 | 44 |
289073 | 289073 | 2020-06-30 | Ashtabula | Ohio | 39007 | 420 | 43 |
285923 | 285923 | 2020-06-29 | Ashtabula | Ohio | 39007 | 419 | 43 |
282778 | 282778 | 2020-06-28 | Ashtabula | Ohio | 39007 | 415 | 43 |
279632 | 279632 | 2020-06-27 | Ashtabula | Ohio | 39007 | 412 | 43 |
276484 | 276484 | 2020-06-26 | Ashtabula | Ohio | 39007 | 412 | 43 |
273337 | 273337 | 2020-06-25 | Ashtabula | Ohio | 39007 | 413 | 42 |
270198 | 270198 | 2020-06-24 | Ashtabula | Ohio | 39007 | 412 | 42 |
267064 | 267064 | 2020-06-23 | Ashtabula | Ohio | 39007 | 411 | 42 |
263936 | 263936 | 2020-06-22 | Ashtabula | Ohio | 39007 | 410 | 42 |
260808 | 260808 | 2020-06-21 | Ashtabula | Ohio | 39007 | 407 | 42 |
257681 | 257681 | 2020-06-20 | Ashtabula | Ohio | 39007 | 402 | 42 |
254556 | 254556 | 2020-06-19 | Ashtabula | Ohio | 39007 | 406 | 42 |
251441 | 251441 | 2020-06-18 | Ashtabula | Ohio | 39007 | 402 | 41 |
248326 | 248326 | 2020-06-17 | Ashtabula | Ohio | 39007 | 397 | 41 |
245213 | 245213 | 2020-06-16 | Ashtabula | Ohio | 39007 | 392 | 41 |
242101 | 242101 | 2020-06-15 | Ashtabula | Ohio | 39007 | 390 | 39 |
238992 | 238992 | 2020-06-14 | Ashtabula | Ohio | 39007 | 385 | 39 |
235884 | 235884 | 2020-06-13 | Ashtabula | Ohio | 39007 | 382 | 39 |
232779 | 232779 | 2020-06-12 | Ashtabula | Ohio | 39007 | 381 | 38 |
229674 | 229674 | 2020-06-11 | Ashtabula | Ohio | 39007 | 382 | 38 |
226570 | 226570 | 2020-06-10 | Ashtabula | Ohio | 39007 | 377 | 38 |
223470 | 223470 | 2020-06-09 | Ashtabula | Ohio | 39007 | 375 | 38 |
220375 | 220375 | 2020-06-08 | Ashtabula | Ohio | 39007 | 374 | 38 |
217283 | 217283 | 2020-06-07 | Ashtabula | Ohio | 39007 | 372 | 38 |
214193 | 214193 | 2020-06-06 | Ashtabula | Ohio | 39007 | 372 | 38 |
211107 | 211107 | 2020-06-05 | Ashtabula | Ohio | 39007 | 369 | 38 |
208025 | 208025 | 2020-06-04 | Ashtabula | Ohio | 39007 | 347 | 38 |
204944 | 204944 | 2020-06-03 | Ashtabula | Ohio | 39007 | 345 | 37 |
201867 | 201867 | 2020-06-02 | Ashtabula | Ohio | 39007 | 340 | 35 |
198792 | 198792 | 2020-06-01 | Ashtabula | Ohio | 39007 | 340 | 35 |
195719 | 195719 | 2020-05-31 | Ashtabula | Ohio | 39007 | 339 | 34 |
192649 | 192649 | 2020-05-30 | Ashtabula | Ohio | 39007 | 338 | 34 |
189585 | 189585 | 2020-05-29 | Ashtabula | Ohio | 39007 | 330 | 34 |
186525 | 186525 | 2020-05-28 | Ashtabula | Ohio | 39007 | 324 | 34 |
183468 | 183468 | 2020-05-27 | Ashtabula | Ohio | 39007 | 316 | 33 |
180419 | 180419 | 2020-05-26 | Ashtabula | Ohio | 39007 | 283 | 32 |
177376 | 177376 | 2020-05-25 | Ashtabula | Ohio | 39007 | 281 | 32 |
174332 | 174332 | 2020-05-24 | Ashtabula | Ohio | 39007 | 277 | 32 |
171290 | 171290 | 2020-05-23 | Ashtabula | Ohio | 39007 | 274 | 31 |
168251 | 168251 | 2020-05-22 | Ashtabula | Ohio | 39007 | 272 | 30 |
165215 | 165215 | 2020-05-21 | Ashtabula | Ohio | 39007 | 263 | 28 |
162186 | 162186 | 2020-05-20 | Ashtabula | Ohio | 39007 | 250 | 28 |
159159 | 159159 | 2020-05-19 | Ashtabula | Ohio | 39007 | 244 | 26 |
156139 | 156139 | 2020-05-18 | Ashtabula | Ohio | 39007 | 232 | 26 |
153122 | 153122 | 2020-05-17 | Ashtabula | Ohio | 39007 | 232 | 26 |
150111 | 150111 | 2020-05-16 | Ashtabula | Ohio | 39007 | 229 | 26 |
147104 | 147104 | 2020-05-15 | Ashtabula | Ohio | 39007 | 223 | 26 |
144103 | 144103 | 2020-05-14 | Ashtabula | Ohio | 39007 | 212 | 26 |
141108 | 141108 | 2020-05-13 | Ashtabula | Ohio | 39007 | 208 | 26 |
138112 | 138112 | 2020-05-12 | Ashtabula | Ohio | 39007 | 199 | 24 |
135122 | 135122 | 2020-05-11 | Ashtabula | Ohio | 39007 | 193 | 19 |
132131 | 132131 | 2020-05-10 | Ashtabula | Ohio | 39007 | 192 | 18 |
129142 | 129142 | 2020-05-09 | Ashtabula | Ohio | 39007 | 190 | 18 |
126153 | 126153 | 2020-05-08 | Ashtabula | Ohio | 39007 | 172 | 18 |
123170 | 123170 | 2020-05-07 | Ashtabula | Ohio | 39007 | 169 | 18 |
120193 | 120193 | 2020-05-06 | Ashtabula | Ohio | 39007 | 165 | 17 |
117232 | 117232 | 2020-05-05 | Ashtabula | Ohio | 39007 | 160 | 17 |
114351 | 114351 | 2020-05-04 | Ashtabula | Ohio | 39007 | 149 | 16 |
111470 | 111470 | 2020-05-03 | Ashtabula | Ohio | 39007 | 146 | 15 |
108596 | 108596 | 2020-05-02 | Ashtabula | Ohio | 39007 | 142 | 15 |
105729 | 105729 | 2020-05-01 | Ashtabula | Ohio | 39007 | 136 | 15 |
102866 | 102866 | 2020-04-30 | Ashtabula | Ohio | 39007 | 126 | 15 |
100013 | 100013 | 2020-04-29 | Ashtabula | Ohio | 39007 | 116 | 15 |
97164 | 97164 | 2020-04-28 | Ashtabula | Ohio | 39007 | 113 | 11 |
94327 | 94327 | 2020-04-27 | Ashtabula | Ohio | 39007 | 110 | 11 |
91501 | 91501 | 2020-04-26 | Ashtabula | Ohio | 39007 | 110 | 10 |
88685 | 88685 | 2020-04-25 | Ashtabula | Ohio | 39007 | 107 | 10 |
85871 | 85871 | 2020-04-24 | Ashtabula | Ohio | 39007 | 103 | 8 |
83067 | 83067 | 2020-04-23 | Ashtabula | Ohio | 39007 | 98 | 7 |
80268 | 80268 | 2020-04-22 | Ashtabula | Ohio | 39007 | 80 | 6 |
77478 | 77478 | 2020-04-21 | Ashtabula | Ohio | 39007 | 70 | 6 |
74697 | 74697 | 2020-04-20 | Ashtabula | Ohio | 39007 | 68 | 6 |
71922 | 71922 | 2020-04-19 | Ashtabula | Ohio | 39007 | 66 | 5 |
69155 | 69155 | 2020-04-18 | Ashtabula | Ohio | 39007 | 64 | 4 |
66398 | 66398 | 2020-04-17 | Ashtabula | Ohio | 39007 | 54 | 4 |
63655 | 63655 | 2020-04-16 | Ashtabula | Ohio | 39007 | 45 | 3 |
60929 | 60929 | 2020-04-15 | Ashtabula | Ohio | 39007 | 36 | 3 |
58215 | 58215 | 2020-04-14 | Ashtabula | Ohio | 39007 | 32 | 2 |
55514 | 55514 | 2020-04-13 | Ashtabula | Ohio | 39007 | 31 | 2 |
52830 | 52830 | 2020-04-12 | Ashtabula | Ohio | 39007 | 26 | 2 |
50157 | 50157 | 2020-04-11 | Ashtabula | Ohio | 39007 | 24 | 0 |
47502 | 47502 | 2020-04-10 | Ashtabula | Ohio | 39007 | 19 | 0 |
44887 | 44887 | 2020-04-09 | Ashtabula | Ohio | 39007 | 19 | 0 |
42302 | 42302 | 2020-04-08 | Ashtabula | Ohio | 39007 | 20 | 0 |
39744 | 39744 | 2020-04-07 | Ashtabula | Ohio | 39007 | 18 | 0 |
37227 | 37227 | 2020-04-06 | Ashtabula | Ohio | 39007 | 15 | 0 |
34758 | 34758 | 2020-04-05 | Ashtabula | Ohio | 39007 | 12 | 0 |
32325 | 32325 | 2020-04-04 | Ashtabula | Ohio | 39007 | 11 | 0 |
29936 | 29936 | 2020-04-03 | Ashtabula | Ohio | 39007 | 9 | 0 |
27607 | 27607 | 2020-04-02 | Ashtabula | Ohio | 39007 | 8 | 0 |
25341 | 25341 | 2020-04-01 | Ashtabula | Ohio | 39007 | 6 | 0 |
23146 | 23146 | 2020-03-31 | Ashtabula | Ohio | 39007 | 6 | 0 |
21014 | 21014 | 2020-03-30 | Ashtabula | Ohio | 39007 | 6 | 0 |
18971 | 18971 | 2020-03-29 | Ashtabula | Ohio | 39007 | 6 | 0 |
17037 | 17037 | 2020-03-28 | Ashtabula | Ohio | 39007 | 6 | 0 |
15196 | 15196 | 2020-03-27 | Ashtabula | Ohio | 39007 | 5 | 0 |
13459 | 13459 | 2020-03-26 | Ashtabula | Ohio | 39007 | 3 | 0 |
11853 | 11853 | 2020-03-25 | Ashtabula | Ohio | 39007 | 3 | 0 |
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);