ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Clinton" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948474 | 948474 | 2021-01-20 | Clinton | Ohio | 39027 | 2849 | 43 |
945228 | 945228 | 2021-01-19 | Clinton | Ohio | 39027 | 2812 | 43 |
941981 | 941981 | 2021-01-18 | Clinton | Ohio | 39027 | 2796 | 43 |
938736 | 938736 | 2021-01-17 | Clinton | Ohio | 39027 | 2790 | 43 |
935491 | 935491 | 2021-01-16 | Clinton | Ohio | 39027 | 2781 | 43 |
932246 | 932246 | 2021-01-15 | Clinton | Ohio | 39027 | 2753 | 41 |
929001 | 929001 | 2021-01-14 | Clinton | Ohio | 39027 | 2727 | 41 |
925756 | 925756 | 2021-01-13 | Clinton | Ohio | 39027 | 2700 | 41 |
922510 | 922510 | 2021-01-12 | Clinton | Ohio | 39027 | 2673 | 40 |
919265 | 919265 | 2021-01-11 | Clinton | Ohio | 39027 | 2637 | 40 |
916020 | 916020 | 2021-01-10 | Clinton | Ohio | 39027 | 2622 | 40 |
912775 | 912775 | 2021-01-09 | Clinton | Ohio | 39027 | 2611 | 40 |
909530 | 909530 | 2021-01-08 | Clinton | Ohio | 39027 | 2561 | 40 |
906285 | 906285 | 2021-01-07 | Clinton | Ohio | 39027 | 2540 | 40 |
903039 | 903039 | 2021-01-06 | Clinton | Ohio | 39027 | 2506 | 41 |
899794 | 899794 | 2021-01-05 | Clinton | Ohio | 39027 | 2471 | 41 |
896549 | 896549 | 2021-01-04 | Clinton | Ohio | 39027 | 2439 | 39 |
893303 | 893303 | 2021-01-03 | Clinton | Ohio | 39027 | 2424 | 39 |
890057 | 890057 | 2021-01-02 | Clinton | Ohio | 39027 | 2390 | 39 |
886810 | 886810 | 2021-01-01 | Clinton | Ohio | 39027 | 2355 | 39 |
883565 | 883565 | 2020-12-31 | Clinton | Ohio | 39027 | 2355 | 39 |
880320 | 880320 | 2020-12-30 | Clinton | Ohio | 39027 | 2314 | 39 |
877075 | 877075 | 2020-12-29 | Clinton | Ohio | 39027 | 2266 | 38 |
873830 | 873830 | 2020-12-28 | Clinton | Ohio | 39027 | 2233 | 38 |
870585 | 870585 | 2020-12-27 | Clinton | Ohio | 39027 | 2215 | 38 |
867340 | 867340 | 2020-12-26 | Clinton | Ohio | 39027 | 2179 | 38 |
864095 | 864095 | 2020-12-25 | Clinton | Ohio | 39027 | 2150 | 38 |
860850 | 860850 | 2020-12-24 | Clinton | Ohio | 39027 | 2150 | 38 |
857605 | 857605 | 2020-12-23 | Clinton | Ohio | 39027 | 2118 | 38 |
854360 | 854360 | 2020-12-22 | Clinton | Ohio | 39027 | 2081 | 38 |
851115 | 851115 | 2020-12-21 | Clinton | Ohio | 39027 | 2044 | 38 |
847870 | 847870 | 2020-12-20 | Clinton | Ohio | 39027 | 2032 | 36 |
844625 | 844625 | 2020-12-19 | Clinton | Ohio | 39027 | 2009 | 36 |
841379 | 841379 | 2020-12-18 | Clinton | Ohio | 39027 | 1966 | 36 |
838134 | 838134 | 2020-12-17 | Clinton | Ohio | 39027 | 1925 | 36 |
834888 | 834888 | 2020-12-16 | Clinton | Ohio | 39027 | 1881 | 35 |
831642 | 831642 | 2020-12-15 | Clinton | Ohio | 39027 | 1860 | 30 |
828395 | 828395 | 2020-12-14 | Clinton | Ohio | 39027 | 1798 | 28 |
825149 | 825149 | 2020-12-13 | Clinton | Ohio | 39027 | 1784 | 24 |
821902 | 821902 | 2020-12-12 | Clinton | Ohio | 39027 | 1750 | 22 |
818656 | 818656 | 2020-12-11 | Clinton | Ohio | 39027 | 1699 | 22 |
815410 | 815410 | 2020-12-10 | Clinton | Ohio | 39027 | 1661 | 21 |
812164 | 812164 | 2020-12-09 | Clinton | Ohio | 39027 | 1610 | 21 |
808920 | 808920 | 2020-12-08 | Clinton | Ohio | 39027 | 1585 | 21 |
805675 | 805675 | 2020-12-07 | Clinton | Ohio | 39027 | 1388 | 20 |
802430 | 802430 | 2020-12-06 | Clinton | Ohio | 39027 | 1369 | 19 |
799185 | 799185 | 2020-12-05 | Clinton | Ohio | 39027 | 1324 | 19 |
795940 | 795940 | 2020-12-04 | Clinton | Ohio | 39027 | 1291 | 19 |
792695 | 792695 | 2020-12-03 | Clinton | Ohio | 39027 | 1256 | 19 |
789450 | 789450 | 2020-12-02 | Clinton | Ohio | 39027 | 1235 | 19 |
786205 | 786205 | 2020-12-01 | Clinton | Ohio | 39027 | 1220 | 19 |
782961 | 782961 | 2020-11-30 | Clinton | Ohio | 39027 | 1188 | 17 |
779715 | 779715 | 2020-11-29 | Clinton | Ohio | 39027 | 1166 | 17 |
776470 | 776470 | 2020-11-28 | Clinton | Ohio | 39027 | 1156 | 17 |
773225 | 773225 | 2020-11-27 | Clinton | Ohio | 39027 | 1131 | 15 |
769980 | 769980 | 2020-11-26 | Clinton | Ohio | 39027 | 1091 | 15 |
766734 | 766734 | 2020-11-25 | Clinton | Ohio | 39027 | 1091 | 15 |
763489 | 763489 | 2020-11-24 | Clinton | Ohio | 39027 | 1067 | 14 |
760244 | 760244 | 2020-11-23 | Clinton | Ohio | 39027 | 1034 | 14 |
756999 | 756999 | 2020-11-22 | Clinton | Ohio | 39027 | 1003 | 14 |
753752 | 753752 | 2020-11-21 | Clinton | Ohio | 39027 | 990 | 14 |
750506 | 750506 | 2020-11-20 | Clinton | Ohio | 39027 | 964 | 14 |
747260 | 747260 | 2020-11-19 | Clinton | Ohio | 39027 | 940 | 14 |
744014 | 744014 | 2020-11-18 | Clinton | Ohio | 39027 | 919 | 14 |
740767 | 740767 | 2020-11-17 | Clinton | Ohio | 39027 | 898 | 14 |
737521 | 737521 | 2020-11-16 | Clinton | Ohio | 39027 | 868 | 14 |
734277 | 734277 | 2020-11-15 | Clinton | Ohio | 39027 | 849 | 14 |
731031 | 731031 | 2020-11-14 | Clinton | Ohio | 39027 | 819 | 14 |
727787 | 727787 | 2020-11-13 | Clinton | Ohio | 39027 | 801 | 14 |
724543 | 724543 | 2020-11-12 | Clinton | Ohio | 39027 | 786 | 14 |
721300 | 721300 | 2020-11-11 | Clinton | Ohio | 39027 | 771 | 14 |
718057 | 718057 | 2020-11-10 | Clinton | Ohio | 39027 | 742 | 14 |
714814 | 714814 | 2020-11-09 | Clinton | Ohio | 39027 | 727 | 14 |
711570 | 711570 | 2020-11-08 | Clinton | Ohio | 39027 | 708 | 14 |
708326 | 708326 | 2020-11-07 | Clinton | Ohio | 39027 | 690 | 14 |
705083 | 705083 | 2020-11-06 | Clinton | Ohio | 39027 | 670 | 14 |
701840 | 701840 | 2020-11-05 | Clinton | Ohio | 39027 | 659 | 13 |
698596 | 698596 | 2020-11-04 | Clinton | Ohio | 39027 | 643 | 13 |
695353 | 695353 | 2020-11-03 | Clinton | Ohio | 39027 | 629 | 13 |
692111 | 692111 | 2020-11-02 | Clinton | Ohio | 39027 | 607 | 13 |
688867 | 688867 | 2020-11-01 | Clinton | Ohio | 39027 | 575 | 13 |
685622 | 685622 | 2020-10-31 | Clinton | Ohio | 39027 | 565 | 13 |
682379 | 682379 | 2020-10-30 | Clinton | Ohio | 39027 | 547 | 13 |
679136 | 679136 | 2020-10-29 | Clinton | Ohio | 39027 | 539 | 13 |
675893 | 675893 | 2020-10-28 | Clinton | Ohio | 39027 | 524 | 13 |
672650 | 672650 | 2020-10-27 | Clinton | Ohio | 39027 | 509 | 13 |
669408 | 669408 | 2020-10-26 | Clinton | Ohio | 39027 | 506 | 13 |
666164 | 666164 | 2020-10-25 | Clinton | Ohio | 39027 | 502 | 13 |
662919 | 662919 | 2020-10-24 | Clinton | Ohio | 39027 | 493 | 13 |
659675 | 659675 | 2020-10-23 | Clinton | Ohio | 39027 | 472 | 13 |
656431 | 656431 | 2020-10-22 | Clinton | Ohio | 39027 | 464 | 13 |
653186 | 653186 | 2020-10-21 | Clinton | Ohio | 39027 | 451 | 13 |
649941 | 649941 | 2020-10-20 | Clinton | Ohio | 39027 | 436 | 13 |
646697 | 646697 | 2020-10-19 | Clinton | Ohio | 39027 | 426 | 13 |
643451 | 643451 | 2020-10-18 | Clinton | Ohio | 39027 | 420 | 13 |
640203 | 640203 | 2020-10-17 | Clinton | Ohio | 39027 | 410 | 13 |
636957 | 636957 | 2020-10-16 | Clinton | Ohio | 39027 | 398 | 13 |
633711 | 633711 | 2020-10-15 | Clinton | Ohio | 39027 | 387 | 13 |
630466 | 630466 | 2020-10-14 | Clinton | Ohio | 39027 | 377 | 13 |
627222 | 627222 | 2020-10-13 | Clinton | Ohio | 39027 | 372 | 13 |
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);