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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282778 | 282778 | 2020-06-28 | Ashtabula | Ohio | 39007 | 415 | 43 |
285923 | 285923 | 2020-06-29 | Ashtabula | Ohio | 39007 | 419 | 43 |
289073 | 289073 | 2020-06-30 | Ashtabula | Ohio | 39007 | 420 | 43 |
292225 | 292225 | 2020-07-01 | Ashtabula | Ohio | 39007 | 421 | 44 |
295380 | 295380 | 2020-07-02 | Ashtabula | Ohio | 39007 | 421 | 44 |
298540 | 298540 | 2020-07-03 | Ashtabula | Ohio | 39007 | 425 | 44 |
301703 | 301703 | 2020-07-04 | Ashtabula | Ohio | 39007 | 431 | 44 |
304866 | 304866 | 2020-07-05 | Ashtabula | Ohio | 39007 | 433 | 44 |
308033 | 308033 | 2020-07-06 | Ashtabula | Ohio | 39007 | 435 | 44 |
311202 | 311202 | 2020-07-07 | Ashtabula | Ohio | 39007 | 436 | 44 |
314374 | 314374 | 2020-07-08 | Ashtabula | Ohio | 39007 | 437 | 44 |
317547 | 317547 | 2020-07-09 | Ashtabula | Ohio | 39007 | 438 | 44 |
320724 | 320724 | 2020-07-10 | Ashtabula | Ohio | 39007 | 445 | 44 |
323904 | 323904 | 2020-07-11 | Ashtabula | Ohio | 39007 | 447 | 44 |
327089 | 327089 | 2020-07-12 | Ashtabula | Ohio | 39007 | 448 | 44 |
330276 | 330276 | 2020-07-13 | Ashtabula | Ohio | 39007 | 452 | 44 |
333468 | 333468 | 2020-07-14 | Ashtabula | Ohio | 39007 | 452 | 44 |
336662 | 336662 | 2020-07-15 | Ashtabula | Ohio | 39007 | 453 | 44 |
339858 | 339858 | 2020-07-16 | Ashtabula | Ohio | 39007 | 460 | 44 |
343056 | 343056 | 2020-07-17 | Ashtabula | Ohio | 39007 | 462 | 44 |
346255 | 346255 | 2020-07-18 | Ashtabula | Ohio | 39007 | 464 | 44 |
349456 | 349456 | 2020-07-19 | Ashtabula | Ohio | 39007 | 473 | 44 |
352659 | 352659 | 2020-07-20 | Ashtabula | Ohio | 39007 | 478 | 44 |
355862 | 355862 | 2020-07-21 | Ashtabula | Ohio | 39007 | 480 | 44 |
359066 | 359066 | 2020-07-22 | Ashtabula | Ohio | 39007 | 489 | 44 |
362272 | 362272 | 2020-07-23 | Ashtabula | Ohio | 39007 | 497 | 44 |
365478 | 365478 | 2020-07-24 | Ashtabula | Ohio | 39007 | 503 | 44 |
368687 | 368687 | 2020-07-25 | Ashtabula | Ohio | 39007 | 507 | 44 |
371899 | 371899 | 2020-07-26 | Ashtabula | Ohio | 39007 | 510 | 44 |
375111 | 375111 | 2020-07-27 | Ashtabula | Ohio | 39007 | 514 | 44 |
378328 | 378328 | 2020-07-28 | Ashtabula | Ohio | 39007 | 517 | 44 |
381545 | 381545 | 2020-07-29 | Ashtabula | Ohio | 39007 | 525 | 44 |
384763 | 384763 | 2020-07-30 | Ashtabula | Ohio | 39007 | 530 | 44 |
387980 | 387980 | 2020-07-31 | Ashtabula | Ohio | 39007 | 534 | 45 |
391197 | 391197 | 2020-08-01 | Ashtabula | Ohio | 39007 | 537 | 45 |
394413 | 394413 | 2020-08-02 | Ashtabula | Ohio | 39007 | 538 | 45 |
397630 | 397630 | 2020-08-03 | Ashtabula | Ohio | 39007 | 539 | 45 |
400845 | 400845 | 2020-08-04 | Ashtabula | Ohio | 39007 | 544 | 45 |
404063 | 404063 | 2020-08-05 | Ashtabula | Ohio | 39007 | 551 | 45 |
407282 | 407282 | 2020-08-06 | Ashtabula | Ohio | 39007 | 550 | 45 |
410502 | 410502 | 2020-08-07 | Ashtabula | Ohio | 39007 | 559 | 46 |
413722 | 413722 | 2020-08-08 | Ashtabula | Ohio | 39007 | 562 | 46 |
416943 | 416943 | 2020-08-09 | Ashtabula | Ohio | 39007 | 569 | 46 |
420163 | 420163 | 2020-08-10 | Ashtabula | Ohio | 39007 | 574 | 46 |
423386 | 423386 | 2020-08-11 | Ashtabula | Ohio | 39007 | 576 | 46 |
426609 | 426609 | 2020-08-12 | Ashtabula | Ohio | 39007 | 577 | 46 |
429834 | 429834 | 2020-08-13 | Ashtabula | Ohio | 39007 | 580 | 46 |
433060 | 433060 | 2020-08-14 | Ashtabula | Ohio | 39007 | 582 | 46 |
436286 | 436286 | 2020-08-15 | Ashtabula | Ohio | 39007 | 583 | 46 |
439511 | 439511 | 2020-08-16 | Ashtabula | Ohio | 39007 | 588 | 46 |
442738 | 442738 | 2020-08-17 | Ashtabula | Ohio | 39007 | 588 | 46 |
445964 | 445964 | 2020-08-18 | Ashtabula | Ohio | 39007 | 588 | 46 |
449192 | 449192 | 2020-08-19 | Ashtabula | Ohio | 39007 | 590 | 46 |
452420 | 452420 | 2020-08-20 | Ashtabula | Ohio | 39007 | 591 | 46 |
455648 | 455648 | 2020-08-21 | Ashtabula | Ohio | 39007 | 592 | 46 |
458876 | 458876 | 2020-08-22 | Ashtabula | Ohio | 39007 | 592 | 46 |
462104 | 462104 | 2020-08-23 | Ashtabula | Ohio | 39007 | 594 | 46 |
465333 | 465333 | 2020-08-24 | Ashtabula | Ohio | 39007 | 595 | 46 |
468561 | 468561 | 2020-08-25 | Ashtabula | Ohio | 39007 | 595 | 46 |
471793 | 471793 | 2020-08-26 | Ashtabula | Ohio | 39007 | 595 | 46 |
475027 | 475027 | 2020-08-27 | Ashtabula | Ohio | 39007 | 598 | 46 |
478260 | 478260 | 2020-08-28 | Ashtabula | Ohio | 39007 | 602 | 46 |
481494 | 481494 | 2020-08-29 | Ashtabula | Ohio | 39007 | 605 | 46 |
484729 | 484729 | 2020-08-30 | Ashtabula | Ohio | 39007 | 609 | 46 |
487962 | 487962 | 2020-08-31 | Ashtabula | Ohio | 39007 | 611 | 46 |
491195 | 491195 | 2020-09-01 | Ashtabula | Ohio | 39007 | 612 | 46 |
494429 | 494429 | 2020-09-02 | Ashtabula | Ohio | 39007 | 614 | 46 |
497662 | 497662 | 2020-09-03 | Ashtabula | Ohio | 39007 | 616 | 46 |
500896 | 500896 | 2020-09-04 | Ashtabula | Ohio | 39007 | 619 | 46 |
504130 | 504130 | 2020-09-05 | Ashtabula | Ohio | 39007 | 620 | 46 |
507362 | 507362 | 2020-09-06 | Ashtabula | Ohio | 39007 | 622 | 46 |
510595 | 510595 | 2020-09-07 | Ashtabula | Ohio | 39007 | 622 | 46 |
513828 | 513828 | 2020-09-08 | Ashtabula | Ohio | 39007 | 622 | 46 |
517063 | 517063 | 2020-09-09 | Ashtabula | Ohio | 39007 | 623 | 46 |
520299 | 520299 | 2020-09-10 | Ashtabula | Ohio | 39007 | 624 | 46 |
523535 | 523535 | 2020-09-11 | Ashtabula | Ohio | 39007 | 624 | 47 |
526771 | 526771 | 2020-09-12 | Ashtabula | Ohio | 39007 | 624 | 47 |
530008 | 530008 | 2020-09-13 | Ashtabula | Ohio | 39007 | 627 | 47 |
533243 | 533243 | 2020-09-14 | Ashtabula | Ohio | 39007 | 634 | 47 |
536479 | 536479 | 2020-09-15 | Ashtabula | Ohio | 39007 | 633 | 48 |
539716 | 539716 | 2020-09-16 | Ashtabula | Ohio | 39007 | 634 | 48 |
542952 | 542952 | 2020-09-17 | Ashtabula | Ohio | 39007 | 637 | 48 |
546189 | 546189 | 2020-09-18 | Ashtabula | Ohio | 39007 | 638 | 48 |
549428 | 549428 | 2020-09-19 | Ashtabula | Ohio | 39007 | 641 | 48 |
552667 | 552667 | 2020-09-20 | Ashtabula | Ohio | 39007 | 643 | 48 |
555904 | 555904 | 2020-09-21 | Ashtabula | Ohio | 39007 | 651 | 48 |
559141 | 559141 | 2020-09-22 | Ashtabula | Ohio | 39007 | 651 | 48 |
562378 | 562378 | 2020-09-23 | Ashtabula | Ohio | 39007 | 653 | 48 |
565619 | 565619 | 2020-09-24 | Ashtabula | Ohio | 39007 | 655 | 48 |
568860 | 568860 | 2020-09-25 | Ashtabula | Ohio | 39007 | 657 | 48 |
572102 | 572102 | 2020-09-26 | Ashtabula | Ohio | 39007 | 659 | 48 |
575346 | 575346 | 2020-09-27 | Ashtabula | Ohio | 39007 | 659 | 48 |
578587 | 578587 | 2020-09-28 | Ashtabula | Ohio | 39007 | 660 | 48 |
581827 | 581827 | 2020-09-29 | Ashtabula | Ohio | 39007 | 662 | 48 |
585067 | 585067 | 2020-09-30 | Ashtabula | Ohio | 39007 | 664 | 48 |
588307 | 588307 | 2020-10-01 | Ashtabula | Ohio | 39007 | 667 | 48 |
591548 | 591548 | 2020-10-02 | Ashtabula | Ohio | 39007 | 670 | 48 |
594789 | 594789 | 2020-10-03 | Ashtabula | Ohio | 39007 | 670 | 48 |
598032 | 598032 | 2020-10-04 | Ashtabula | Ohio | 39007 | 673 | 48 |
601275 | 601275 | 2020-10-05 | Ashtabula | Ohio | 39007 | 674 | 48 |
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);