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 |
---|---|---|---|---|---|---|---|
387980 | 387980 | 2020-07-31 | Ashtabula | Ohio | 39007 | 534 | 45 |
384763 | 384763 | 2020-07-30 | Ashtabula | Ohio | 39007 | 530 | 44 |
381545 | 381545 | 2020-07-29 | Ashtabula | Ohio | 39007 | 525 | 44 |
378328 | 378328 | 2020-07-28 | Ashtabula | Ohio | 39007 | 517 | 44 |
375111 | 375111 | 2020-07-27 | Ashtabula | Ohio | 39007 | 514 | 44 |
371899 | 371899 | 2020-07-26 | Ashtabula | Ohio | 39007 | 510 | 44 |
368687 | 368687 | 2020-07-25 | Ashtabula | Ohio | 39007 | 507 | 44 |
365478 | 365478 | 2020-07-24 | Ashtabula | Ohio | 39007 | 503 | 44 |
362272 | 362272 | 2020-07-23 | Ashtabula | Ohio | 39007 | 497 | 44 |
359066 | 359066 | 2020-07-22 | Ashtabula | Ohio | 39007 | 489 | 44 |
355862 | 355862 | 2020-07-21 | Ashtabula | Ohio | 39007 | 480 | 44 |
352659 | 352659 | 2020-07-20 | Ashtabula | Ohio | 39007 | 478 | 44 |
349456 | 349456 | 2020-07-19 | Ashtabula | Ohio | 39007 | 473 | 44 |
346255 | 346255 | 2020-07-18 | Ashtabula | Ohio | 39007 | 464 | 44 |
343056 | 343056 | 2020-07-17 | Ashtabula | Ohio | 39007 | 462 | 44 |
339858 | 339858 | 2020-07-16 | Ashtabula | Ohio | 39007 | 460 | 44 |
336662 | 336662 | 2020-07-15 | Ashtabula | Ohio | 39007 | 453 | 44 |
333468 | 333468 | 2020-07-14 | Ashtabula | Ohio | 39007 | 452 | 44 |
330276 | 330276 | 2020-07-13 | Ashtabula | Ohio | 39007 | 452 | 44 |
327089 | 327089 | 2020-07-12 | Ashtabula | Ohio | 39007 | 448 | 44 |
323904 | 323904 | 2020-07-11 | Ashtabula | Ohio | 39007 | 447 | 44 |
320724 | 320724 | 2020-07-10 | Ashtabula | Ohio | 39007 | 445 | 44 |
317547 | 317547 | 2020-07-09 | Ashtabula | Ohio | 39007 | 438 | 44 |
314374 | 314374 | 2020-07-08 | Ashtabula | Ohio | 39007 | 437 | 44 |
311202 | 311202 | 2020-07-07 | Ashtabula | Ohio | 39007 | 436 | 44 |
308033 | 308033 | 2020-07-06 | Ashtabula | Ohio | 39007 | 435 | 44 |
304866 | 304866 | 2020-07-05 | Ashtabula | Ohio | 39007 | 433 | 44 |
301703 | 301703 | 2020-07-04 | Ashtabula | Ohio | 39007 | 431 | 44 |
298540 | 298540 | 2020-07-03 | Ashtabula | Ohio | 39007 | 425 | 44 |
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 |
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);