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 |
---|---|---|---|---|---|---|---|
536479 | 536479 | 2020-09-15 | Ashtabula | Ohio | 39007 | 633 | 48 |
533243 | 533243 | 2020-09-14 | Ashtabula | Ohio | 39007 | 634 | 47 |
530008 | 530008 | 2020-09-13 | Ashtabula | Ohio | 39007 | 627 | 47 |
526771 | 526771 | 2020-09-12 | Ashtabula | Ohio | 39007 | 624 | 47 |
523535 | 523535 | 2020-09-11 | Ashtabula | Ohio | 39007 | 624 | 47 |
520299 | 520299 | 2020-09-10 | Ashtabula | Ohio | 39007 | 624 | 46 |
517063 | 517063 | 2020-09-09 | Ashtabula | Ohio | 39007 | 623 | 46 |
513828 | 513828 | 2020-09-08 | Ashtabula | Ohio | 39007 | 622 | 46 |
510595 | 510595 | 2020-09-07 | Ashtabula | Ohio | 39007 | 622 | 46 |
507362 | 507362 | 2020-09-06 | Ashtabula | Ohio | 39007 | 622 | 46 |
504130 | 504130 | 2020-09-05 | Ashtabula | Ohio | 39007 | 620 | 46 |
500896 | 500896 | 2020-09-04 | Ashtabula | Ohio | 39007 | 619 | 46 |
497662 | 497662 | 2020-09-03 | Ashtabula | Ohio | 39007 | 616 | 46 |
494429 | 494429 | 2020-09-02 | Ashtabula | Ohio | 39007 | 614 | 46 |
491195 | 491195 | 2020-09-01 | Ashtabula | Ohio | 39007 | 612 | 46 |
487962 | 487962 | 2020-08-31 | Ashtabula | Ohio | 39007 | 611 | 46 |
484729 | 484729 | 2020-08-30 | Ashtabula | Ohio | 39007 | 609 | 46 |
481494 | 481494 | 2020-08-29 | Ashtabula | Ohio | 39007 | 605 | 46 |
478260 | 478260 | 2020-08-28 | Ashtabula | Ohio | 39007 | 602 | 46 |
475027 | 475027 | 2020-08-27 | Ashtabula | Ohio | 39007 | 598 | 46 |
471793 | 471793 | 2020-08-26 | Ashtabula | Ohio | 39007 | 595 | 46 |
468561 | 468561 | 2020-08-25 | Ashtabula | Ohio | 39007 | 595 | 46 |
465333 | 465333 | 2020-08-24 | Ashtabula | Ohio | 39007 | 595 | 46 |
462104 | 462104 | 2020-08-23 | Ashtabula | Ohio | 39007 | 594 | 46 |
458876 | 458876 | 2020-08-22 | Ashtabula | Ohio | 39007 | 592 | 46 |
455648 | 455648 | 2020-08-21 | Ashtabula | Ohio | 39007 | 592 | 46 |
452420 | 452420 | 2020-08-20 | Ashtabula | Ohio | 39007 | 591 | 46 |
449192 | 449192 | 2020-08-19 | Ashtabula | Ohio | 39007 | 590 | 46 |
445964 | 445964 | 2020-08-18 | Ashtabula | Ohio | 39007 | 588 | 46 |
442738 | 442738 | 2020-08-17 | Ashtabula | Ohio | 39007 | 588 | 46 |
439511 | 439511 | 2020-08-16 | Ashtabula | Ohio | 39007 | 588 | 46 |
436286 | 436286 | 2020-08-15 | Ashtabula | Ohio | 39007 | 583 | 46 |
433060 | 433060 | 2020-08-14 | Ashtabula | Ohio | 39007 | 582 | 46 |
429834 | 429834 | 2020-08-13 | Ashtabula | Ohio | 39007 | 580 | 46 |
426609 | 426609 | 2020-08-12 | Ashtabula | Ohio | 39007 | 577 | 46 |
423386 | 423386 | 2020-08-11 | Ashtabula | Ohio | 39007 | 576 | 46 |
420163 | 420163 | 2020-08-10 | Ashtabula | Ohio | 39007 | 574 | 46 |
416943 | 416943 | 2020-08-09 | Ashtabula | Ohio | 39007 | 569 | 46 |
413722 | 413722 | 2020-08-08 | Ashtabula | Ohio | 39007 | 562 | 46 |
410502 | 410502 | 2020-08-07 | Ashtabula | Ohio | 39007 | 559 | 46 |
407282 | 407282 | 2020-08-06 | Ashtabula | Ohio | 39007 | 550 | 45 |
404063 | 404063 | 2020-08-05 | Ashtabula | Ohio | 39007 | 551 | 45 |
400845 | 400845 | 2020-08-04 | Ashtabula | Ohio | 39007 | 544 | 45 |
397630 | 397630 | 2020-08-03 | Ashtabula | Ohio | 39007 | 539 | 45 |
394413 | 394413 | 2020-08-02 | Ashtabula | Ohio | 39007 | 538 | 45 |
391197 | 391197 | 2020-08-01 | Ashtabula | Ohio | 39007 | 537 | 45 |
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 |
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);