ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and fips = 39049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
909541 | 909541 | 2021-01-08 | Franklin | Ohio | 39049 | 90416 | 700 |
906296 | 906296 | 2021-01-07 | Franklin | Ohio | 39049 | 89439 | 700 |
903050 | 903050 | 2021-01-06 | Franklin | Ohio | 39049 | 88447 | 700 |
899805 | 899805 | 2021-01-05 | Franklin | Ohio | 39049 | 87784 | 700 |
896560 | 896560 | 2021-01-04 | Franklin | Ohio | 39049 | 87106 | 698 |
893314 | 893314 | 2021-01-03 | Franklin | Ohio | 39049 | 86446 | 698 |
890068 | 890068 | 2021-01-02 | Franklin | Ohio | 39049 | 85553 | 698 |
886821 | 886821 | 2021-01-01 | Franklin | Ohio | 39049 | 84050 | 698 |
883576 | 883576 | 2020-12-31 | Franklin | Ohio | 39049 | 84050 | 698 |
880331 | 880331 | 2020-12-30 | Franklin | Ohio | 39049 | 83105 | 698 |
877086 | 877086 | 2020-12-29 | Franklin | Ohio | 39049 | 82402 | 697 |
873841 | 873841 | 2020-12-28 | Franklin | Ohio | 39049 | 81515 | 697 |
870596 | 870596 | 2020-12-27 | Franklin | Ohio | 39049 | 80939 | 697 |
867351 | 867351 | 2020-12-26 | Franklin | Ohio | 39049 | 79986 | 697 |
864106 | 864106 | 2020-12-25 | Franklin | Ohio | 39049 | 78759 | 696 |
860861 | 860861 | 2020-12-24 | Franklin | Ohio | 39049 | 78759 | 696 |
857616 | 857616 | 2020-12-23 | Franklin | Ohio | 39049 | 77807 | 695 |
854371 | 854371 | 2020-12-22 | Franklin | Ohio | 39049 | 77087 | 695 |
851126 | 851126 | 2020-12-21 | Franklin | Ohio | 39049 | 76188 | 695 |
847881 | 847881 | 2020-12-20 | Franklin | Ohio | 39049 | 75316 | 693 |
844636 | 844636 | 2020-12-19 | Franklin | Ohio | 39049 | 74477 | 693 |
841390 | 841390 | 2020-12-18 | Franklin | Ohio | 39049 | 73651 | 693 |
838145 | 838145 | 2020-12-17 | Franklin | Ohio | 39049 | 72583 | 693 |
834899 | 834899 | 2020-12-16 | Franklin | Ohio | 39049 | 71538 | 693 |
831653 | 831653 | 2020-12-15 | Franklin | Ohio | 39049 | 70879 | 693 |
828406 | 828406 | 2020-12-14 | Franklin | Ohio | 39049 | 69961 | 693 |
825160 | 825160 | 2020-12-13 | Franklin | Ohio | 39049 | 69074 | 693 |
821913 | 821913 | 2020-12-12 | Franklin | Ohio | 39049 | 68157 | 692 |
818667 | 818667 | 2020-12-11 | Franklin | Ohio | 39049 | 67043 | 691 |
815421 | 815421 | 2020-12-10 | Franklin | Ohio | 39049 | 66184 | 690 |
812175 | 812175 | 2020-12-09 | Franklin | Ohio | 39049 | 65094 | 682 |
808931 | 808931 | 2020-12-08 | Franklin | Ohio | 39049 | 64130 | 682 |
805686 | 805686 | 2020-12-07 | Franklin | Ohio | 39049 | 60938 | 682 |
802441 | 802441 | 2020-12-06 | Franklin | Ohio | 39049 | 60093 | 680 |
799196 | 799196 | 2020-12-05 | Franklin | Ohio | 39049 | 59137 | 680 |
795951 | 795951 | 2020-12-04 | Franklin | Ohio | 39049 | 58099 | 678 |
792706 | 792706 | 2020-12-03 | Franklin | Ohio | 39049 | 57040 | 674 |
789461 | 789461 | 2020-12-02 | Franklin | Ohio | 39049 | 56123 | 674 |
786216 | 786216 | 2020-12-01 | Franklin | Ohio | 39049 | 55382 | 672 |
782972 | 782972 | 2020-11-30 | Franklin | Ohio | 39049 | 54467 | 672 |
779726 | 779726 | 2020-11-29 | Franklin | Ohio | 39049 | 53887 | 672 |
776481 | 776481 | 2020-11-28 | Franklin | Ohio | 39049 | 53293 | 672 |
773236 | 773236 | 2020-11-27 | Franklin | Ohio | 39049 | 52652 | 672 |
769991 | 769991 | 2020-11-26 | Franklin | Ohio | 39049 | 51161 | 671 |
766745 | 766745 | 2020-11-25 | Franklin | Ohio | 39049 | 51161 | 671 |
763500 | 763500 | 2020-11-24 | Franklin | Ohio | 39049 | 50231 | 667 |
760255 | 760255 | 2020-11-23 | Franklin | Ohio | 39049 | 49267 | 665 |
757010 | 757010 | 2020-11-22 | Franklin | Ohio | 39049 | 48389 | 665 |
753763 | 753763 | 2020-11-21 | Franklin | Ohio | 39049 | 47321 | 664 |
750517 | 750517 | 2020-11-20 | Franklin | Ohio | 39049 | 46473 | 663 |
747271 | 747271 | 2020-11-19 | Franklin | Ohio | 39049 | 45650 | 658 |
744025 | 744025 | 2020-11-18 | Franklin | Ohio | 39049 | 44809 | 653 |
740778 | 740778 | 2020-11-17 | Franklin | Ohio | 39049 | 44159 | 651 |
737532 | 737532 | 2020-11-16 | Franklin | Ohio | 39049 | 43520 | 651 |
734288 | 734288 | 2020-11-15 | Franklin | Ohio | 39049 | 42896 | 651 |
731042 | 731042 | 2020-11-14 | Franklin | Ohio | 39049 | 42123 | 651 |
727798 | 727798 | 2020-11-13 | Franklin | Ohio | 39049 | 41295 | 651 |
724554 | 724554 | 2020-11-12 | Franklin | Ohio | 39049 | 40621 | 646 |
721311 | 721311 | 2020-11-11 | Franklin | Ohio | 39049 | 39917 | 645 |
718068 | 718068 | 2020-11-10 | Franklin | Ohio | 39049 | 39230 | 643 |
714825 | 714825 | 2020-11-09 | Franklin | Ohio | 39049 | 38504 | 643 |
711581 | 711581 | 2020-11-08 | Franklin | Ohio | 39049 | 38022 | 643 |
708337 | 708337 | 2020-11-07 | Franklin | Ohio | 39049 | 37523 | 643 |
705094 | 705094 | 2020-11-06 | Franklin | Ohio | 39049 | 36812 | 643 |
701851 | 701851 | 2020-11-05 | Franklin | Ohio | 39049 | 36228 | 643 |
698607 | 698607 | 2020-11-04 | Franklin | Ohio | 39049 | 35700 | 643 |
695364 | 695364 | 2020-11-03 | Franklin | Ohio | 39049 | 35292 | 643 |
692122 | 692122 | 2020-11-02 | Franklin | Ohio | 39049 | 34871 | 643 |
688878 | 688878 | 2020-11-01 | Franklin | Ohio | 39049 | 34517 | 643 |
685633 | 685633 | 2020-10-31 | Franklin | Ohio | 39049 | 34104 | 643 |
682390 | 682390 | 2020-10-30 | Franklin | Ohio | 39049 | 33858 | 643 |
679147 | 679147 | 2020-10-29 | Franklin | Ohio | 39049 | 33397 | 643 |
675904 | 675904 | 2020-10-28 | Franklin | Ohio | 39049 | 33084 | 643 |
672661 | 672661 | 2020-10-27 | Franklin | Ohio | 39049 | 32767 | 642 |
669419 | 669419 | 2020-10-26 | Franklin | Ohio | 39049 | 32468 | 642 |
666175 | 666175 | 2020-10-25 | Franklin | Ohio | 39049 | 32241 | 642 |
662930 | 662930 | 2020-10-24 | Franklin | Ohio | 39049 | 31999 | 642 |
659686 | 659686 | 2020-10-23 | Franklin | Ohio | 39049 | 31703 | 640 |
656442 | 656442 | 2020-10-22 | Franklin | Ohio | 39049 | 31466 | 640 |
653197 | 653197 | 2020-10-21 | Franklin | Ohio | 39049 | 31221 | 639 |
649952 | 649952 | 2020-10-20 | Franklin | Ohio | 39049 | 30978 | 635 |
646708 | 646708 | 2020-10-19 | Franklin | Ohio | 39049 | 30777 | 635 |
643462 | 643462 | 2020-10-18 | Franklin | Ohio | 39049 | 30590 | 635 |
640214 | 640214 | 2020-10-17 | Franklin | Ohio | 39049 | 30401 | 635 |
636968 | 636968 | 2020-10-16 | Franklin | Ohio | 39049 | 30157 | 635 |
633722 | 633722 | 2020-10-15 | Franklin | Ohio | 39049 | 29901 | 635 |
630477 | 630477 | 2020-10-14 | Franklin | Ohio | 39049 | 29698 | 635 |
627233 | 627233 | 2020-10-13 | Franklin | Ohio | 39049 | 29507 | 635 |
623991 | 623991 | 2020-10-12 | Franklin | Ohio | 39049 | 29327 | 635 |
620748 | 620748 | 2020-10-11 | Franklin | Ohio | 39049 | 29141 | 635 |
617506 | 617506 | 2020-10-10 | Franklin | Ohio | 39049 | 29005 | 635 |
614264 | 614264 | 2020-10-09 | Franklin | Ohio | 39049 | 28841 | 635 |
611023 | 611023 | 2020-10-08 | Franklin | Ohio | 39049 | 28661 | 633 |
607781 | 607781 | 2020-10-07 | Franklin | Ohio | 39049 | 28520 | 633 |
604538 | 604538 | 2020-10-06 | Franklin | Ohio | 39049 | 28291 | 633 |
601296 | 601296 | 2020-10-05 | Franklin | Ohio | 39049 | 28131 | 631 |
598053 | 598053 | 2020-10-04 | Franklin | Ohio | 39049 | 28014 | 630 |
594810 | 594810 | 2020-10-03 | Franklin | Ohio | 39049 | 27908 | 630 |
591569 | 591569 | 2020-10-02 | Franklin | Ohio | 39049 | 27770 | 629 |
588328 | 588328 | 2020-10-01 | Franklin | Ohio | 39049 | 27600 | 615 |
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);