ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39157 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637022 | 637022 | 2020-10-16 | Tuscarawas | Ohio | 39157 | 1142 | 21 |
633776 | 633776 | 2020-10-15 | Tuscarawas | Ohio | 39157 | 1118 | 20 |
630531 | 630531 | 2020-10-14 | Tuscarawas | Ohio | 39157 | 1105 | 20 |
627287 | 627287 | 2020-10-13 | Tuscarawas | Ohio | 39157 | 1083 | 20 |
624045 | 624045 | 2020-10-12 | Tuscarawas | Ohio | 39157 | 1065 | 20 |
620802 | 620802 | 2020-10-11 | Tuscarawas | Ohio | 39157 | 1056 | 20 |
617560 | 617560 | 2020-10-10 | Tuscarawas | Ohio | 39157 | 1050 | 20 |
614318 | 614318 | 2020-10-09 | Tuscarawas | Ohio | 39157 | 1040 | 20 |
611077 | 611077 | 2020-10-08 | Tuscarawas | Ohio | 39157 | 1031 | 20 |
607835 | 607835 | 2020-10-07 | Tuscarawas | Ohio | 39157 | 1013 | 20 |
604592 | 604592 | 2020-10-06 | Tuscarawas | Ohio | 39157 | 994 | 20 |
601350 | 601350 | 2020-10-05 | Tuscarawas | Ohio | 39157 | 985 | 20 |
598107 | 598107 | 2020-10-04 | Tuscarawas | Ohio | 39157 | 980 | 20 |
594864 | 594864 | 2020-10-03 | Tuscarawas | Ohio | 39157 | 973 | 20 |
591623 | 591623 | 2020-10-02 | Tuscarawas | Ohio | 39157 | 964 | 20 |
588382 | 588382 | 2020-10-01 | Tuscarawas | Ohio | 39157 | 959 | 20 |
585142 | 585142 | 2020-09-30 | Tuscarawas | Ohio | 39157 | 950 | 20 |
581902 | 581902 | 2020-09-29 | Tuscarawas | Ohio | 39157 | 943 | 20 |
578662 | 578662 | 2020-09-28 | Tuscarawas | Ohio | 39157 | 941 | 20 |
575421 | 575421 | 2020-09-27 | Tuscarawas | Ohio | 39157 | 936 | 20 |
572177 | 572177 | 2020-09-26 | Tuscarawas | Ohio | 39157 | 931 | 20 |
568935 | 568935 | 2020-09-25 | Tuscarawas | Ohio | 39157 | 930 | 20 |
565694 | 565694 | 2020-09-24 | Tuscarawas | Ohio | 39157 | 928 | 20 |
562453 | 562453 | 2020-09-23 | Tuscarawas | Ohio | 39157 | 920 | 20 |
559216 | 559216 | 2020-09-22 | Tuscarawas | Ohio | 39157 | 916 | 20 |
555979 | 555979 | 2020-09-21 | Tuscarawas | Ohio | 39157 | 917 | 20 |
552742 | 552742 | 2020-09-20 | Tuscarawas | Ohio | 39157 | 912 | 20 |
549503 | 549503 | 2020-09-19 | Tuscarawas | Ohio | 39157 | 910 | 20 |
546264 | 546264 | 2020-09-18 | Tuscarawas | Ohio | 39157 | 908 | 19 |
543027 | 543027 | 2020-09-17 | Tuscarawas | Ohio | 39157 | 907 | 19 |
539791 | 539791 | 2020-09-16 | Tuscarawas | Ohio | 39157 | 903 | 19 |
536554 | 536554 | 2020-09-15 | Tuscarawas | Ohio | 39157 | 899 | 19 |
533318 | 533318 | 2020-09-14 | Tuscarawas | Ohio | 39157 | 892 | 19 |
530083 | 530083 | 2020-09-13 | Tuscarawas | Ohio | 39157 | 887 | 19 |
526846 | 526846 | 2020-09-12 | Tuscarawas | Ohio | 39157 | 885 | 19 |
523610 | 523610 | 2020-09-11 | Tuscarawas | Ohio | 39157 | 883 | 19 |
520374 | 520374 | 2020-09-10 | Tuscarawas | Ohio | 39157 | 882 | 19 |
517138 | 517138 | 2020-09-09 | Tuscarawas | Ohio | 39157 | 880 | 18 |
513903 | 513903 | 2020-09-08 | Tuscarawas | Ohio | 39157 | 877 | 18 |
510670 | 510670 | 2020-09-07 | Tuscarawas | Ohio | 39157 | 877 | 18 |
507437 | 507437 | 2020-09-06 | Tuscarawas | Ohio | 39157 | 878 | 18 |
504205 | 504205 | 2020-09-05 | Tuscarawas | Ohio | 39157 | 877 | 18 |
500971 | 500971 | 2020-09-04 | Tuscarawas | Ohio | 39157 | 872 | 18 |
497737 | 497737 | 2020-09-03 | Tuscarawas | Ohio | 39157 | 872 | 17 |
494504 | 494504 | 2020-09-02 | Tuscarawas | Ohio | 39157 | 868 | 18 |
491270 | 491270 | 2020-09-01 | Tuscarawas | Ohio | 39157 | 865 | 17 |
488037 | 488037 | 2020-08-31 | Tuscarawas | Ohio | 39157 | 859 | 17 |
484804 | 484804 | 2020-08-30 | Tuscarawas | Ohio | 39157 | 858 | 16 |
481569 | 481569 | 2020-08-29 | Tuscarawas | Ohio | 39157 | 857 | 16 |
478335 | 478335 | 2020-08-28 | Tuscarawas | Ohio | 39157 | 853 | 16 |
475102 | 475102 | 2020-08-27 | Tuscarawas | Ohio | 39157 | 848 | 16 |
471868 | 471868 | 2020-08-26 | Tuscarawas | Ohio | 39157 | 846 | 16 |
468636 | 468636 | 2020-08-25 | Tuscarawas | Ohio | 39157 | 840 | 16 |
465408 | 465408 | 2020-08-24 | Tuscarawas | Ohio | 39157 | 834 | 15 |
462179 | 462179 | 2020-08-23 | Tuscarawas | Ohio | 39157 | 829 | 15 |
458951 | 458951 | 2020-08-22 | Tuscarawas | Ohio | 39157 | 828 | 15 |
455723 | 455723 | 2020-08-21 | Tuscarawas | Ohio | 39157 | 822 | 15 |
452495 | 452495 | 2020-08-20 | Tuscarawas | Ohio | 39157 | 818 | 15 |
449267 | 449267 | 2020-08-19 | Tuscarawas | Ohio | 39157 | 818 | 15 |
446039 | 446039 | 2020-08-18 | Tuscarawas | Ohio | 39157 | 818 | 14 |
442813 | 442813 | 2020-08-17 | Tuscarawas | Ohio | 39157 | 816 | 14 |
439586 | 439586 | 2020-08-16 | Tuscarawas | Ohio | 39157 | 812 | 14 |
436361 | 436361 | 2020-08-15 | Tuscarawas | Ohio | 39157 | 808 | 14 |
433135 | 433135 | 2020-08-14 | Tuscarawas | Ohio | 39157 | 806 | 14 |
429909 | 429909 | 2020-08-13 | Tuscarawas | Ohio | 39157 | 801 | 14 |
426684 | 426684 | 2020-08-12 | Tuscarawas | Ohio | 39157 | 797 | 14 |
423461 | 423461 | 2020-08-11 | Tuscarawas | Ohio | 39157 | 793 | 14 |
420238 | 420238 | 2020-08-10 | Tuscarawas | Ohio | 39157 | 788 | 14 |
417018 | 417018 | 2020-08-09 | Tuscarawas | Ohio | 39157 | 782 | 14 |
413797 | 413797 | 2020-08-08 | Tuscarawas | Ohio | 39157 | 781 | 14 |
410577 | 410577 | 2020-08-07 | Tuscarawas | Ohio | 39157 | 772 | 14 |
407357 | 407357 | 2020-08-06 | Tuscarawas | Ohio | 39157 | 762 | 14 |
404138 | 404138 | 2020-08-05 | Tuscarawas | Ohio | 39157 | 759 | 14 |
400920 | 400920 | 2020-08-04 | Tuscarawas | Ohio | 39157 | 756 | 14 |
397705 | 397705 | 2020-08-03 | Tuscarawas | Ohio | 39157 | 747 | 13 |
394488 | 394488 | 2020-08-02 | Tuscarawas | Ohio | 39157 | 746 | 13 |
391272 | 391272 | 2020-08-01 | Tuscarawas | Ohio | 39157 | 743 | 13 |
388055 | 388055 | 2020-07-31 | Tuscarawas | Ohio | 39157 | 736 | 13 |
384838 | 384838 | 2020-07-30 | Tuscarawas | Ohio | 39157 | 730 | 13 |
381620 | 381620 | 2020-07-29 | Tuscarawas | Ohio | 39157 | 730 | 12 |
378403 | 378403 | 2020-07-28 | Tuscarawas | Ohio | 39157 | 726 | 12 |
375186 | 375186 | 2020-07-27 | Tuscarawas | Ohio | 39157 | 723 | 11 |
371974 | 371974 | 2020-07-26 | Tuscarawas | Ohio | 39157 | 722 | 11 |
368762 | 368762 | 2020-07-25 | Tuscarawas | Ohio | 39157 | 717 | 11 |
365553 | 365553 | 2020-07-24 | Tuscarawas | Ohio | 39157 | 713 | 11 |
362347 | 362347 | 2020-07-23 | Tuscarawas | Ohio | 39157 | 706 | 11 |
359141 | 359141 | 2020-07-22 | Tuscarawas | Ohio | 39157 | 694 | 11 |
355937 | 355937 | 2020-07-21 | Tuscarawas | Ohio | 39157 | 691 | 11 |
352734 | 352734 | 2020-07-20 | Tuscarawas | Ohio | 39157 | 685 | 11 |
349531 | 349531 | 2020-07-19 | Tuscarawas | Ohio | 39157 | 682 | 11 |
346330 | 346330 | 2020-07-18 | Tuscarawas | Ohio | 39157 | 677 | 11 |
343131 | 343131 | 2020-07-17 | Tuscarawas | Ohio | 39157 | 662 | 11 |
339933 | 339933 | 2020-07-16 | Tuscarawas | Ohio | 39157 | 655 | 11 |
336737 | 336737 | 2020-07-15 | Tuscarawas | Ohio | 39157 | 641 | 11 |
333543 | 333543 | 2020-07-14 | Tuscarawas | Ohio | 39157 | 628 | 11 |
330351 | 330351 | 2020-07-13 | Tuscarawas | Ohio | 39157 | 621 | 10 |
327164 | 327164 | 2020-07-12 | Tuscarawas | Ohio | 39157 | 609 | 10 |
323979 | 323979 | 2020-07-11 | Tuscarawas | Ohio | 39157 | 604 | 10 |
320799 | 320799 | 2020-07-10 | Tuscarawas | Ohio | 39157 | 601 | 10 |
317622 | 317622 | 2020-07-09 | Tuscarawas | Ohio | 39157 | 590 | 10 |
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);