ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Hancock" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922528 | 922528 | 2021-01-12 | Hancock | Ohio | 39063 | 5206 | 88 |
919283 | 919283 | 2021-01-11 | Hancock | Ohio | 39063 | 5160 | 85 |
916038 | 916038 | 2021-01-10 | Hancock | Ohio | 39063 | 5120 | 85 |
912793 | 912793 | 2021-01-09 | Hancock | Ohio | 39063 | 5075 | 85 |
909548 | 909548 | 2021-01-08 | Hancock | Ohio | 39063 | 4995 | 85 |
906303 | 906303 | 2021-01-07 | Hancock | Ohio | 39063 | 4951 | 85 |
903057 | 903057 | 2021-01-06 | Hancock | Ohio | 39063 | 4918 | 82 |
899812 | 899812 | 2021-01-05 | Hancock | Ohio | 39063 | 4820 | 82 |
896567 | 896567 | 2021-01-04 | Hancock | Ohio | 39063 | 4784 | 81 |
893321 | 893321 | 2021-01-03 | Hancock | Ohio | 39063 | 4759 | 81 |
890075 | 890075 | 2021-01-02 | Hancock | Ohio | 39063 | 4729 | 81 |
886828 | 886828 | 2021-01-01 | Hancock | Ohio | 39063 | 4593 | 81 |
883583 | 883583 | 2020-12-31 | Hancock | Ohio | 39063 | 4593 | 81 |
880338 | 880338 | 2020-12-30 | Hancock | Ohio | 39063 | 4523 | 81 |
877093 | 877093 | 2020-12-29 | Hancock | Ohio | 39063 | 4464 | 77 |
873848 | 873848 | 2020-12-28 | Hancock | Ohio | 39063 | 4435 | 77 |
870603 | 870603 | 2020-12-27 | Hancock | Ohio | 39063 | 4397 | 77 |
867358 | 867358 | 2020-12-26 | Hancock | Ohio | 39063 | 4342 | 76 |
864113 | 864113 | 2020-12-25 | Hancock | Ohio | 39063 | 4276 | 76 |
860868 | 860868 | 2020-12-24 | Hancock | Ohio | 39063 | 4276 | 76 |
857623 | 857623 | 2020-12-23 | Hancock | Ohio | 39063 | 4208 | 76 |
854378 | 854378 | 2020-12-22 | Hancock | Ohio | 39063 | 4152 | 76 |
851133 | 851133 | 2020-12-21 | Hancock | Ohio | 39063 | 4105 | 71 |
847888 | 847888 | 2020-12-20 | Hancock | Ohio | 39063 | 4057 | 69 |
844643 | 844643 | 2020-12-19 | Hancock | Ohio | 39063 | 3998 | 69 |
841397 | 841397 | 2020-12-18 | Hancock | Ohio | 39063 | 3926 | 69 |
838152 | 838152 | 2020-12-17 | Hancock | Ohio | 39063 | 3866 | 68 |
834906 | 834906 | 2020-12-16 | Hancock | Ohio | 39063 | 3756 | 66 |
831660 | 831660 | 2020-12-15 | Hancock | Ohio | 39063 | 3727 | 66 |
828413 | 828413 | 2020-12-14 | Hancock | Ohio | 39063 | 3660 | 66 |
825167 | 825167 | 2020-12-13 | Hancock | Ohio | 39063 | 3612 | 65 |
821920 | 821920 | 2020-12-12 | Hancock | Ohio | 39063 | 3549 | 65 |
818674 | 818674 | 2020-12-11 | Hancock | Ohio | 39063 | 3496 | 65 |
815428 | 815428 | 2020-12-10 | Hancock | Ohio | 39063 | 3428 | 61 |
812182 | 812182 | 2020-12-09 | Hancock | Ohio | 39063 | 3339 | 61 |
808938 | 808938 | 2020-12-08 | Hancock | Ohio | 39063 | 3309 | 58 |
805693 | 805693 | 2020-12-07 | Hancock | Ohio | 39063 | 3153 | 57 |
802448 | 802448 | 2020-12-06 | Hancock | Ohio | 39063 | 3086 | 53 |
799203 | 799203 | 2020-12-05 | Hancock | Ohio | 39063 | 3033 | 53 |
795958 | 795958 | 2020-12-04 | Hancock | Ohio | 39063 | 2942 | 51 |
792713 | 792713 | 2020-12-03 | Hancock | Ohio | 39063 | 2845 | 46 |
789468 | 789468 | 2020-12-02 | Hancock | Ohio | 39063 | 2799 | 46 |
786223 | 786223 | 2020-12-01 | Hancock | Ohio | 39063 | 2772 | 42 |
782979 | 782979 | 2020-11-30 | Hancock | Ohio | 39063 | 2723 | 42 |
779733 | 779733 | 2020-11-29 | Hancock | Ohio | 39063 | 2665 | 40 |
776488 | 776488 | 2020-11-28 | Hancock | Ohio | 39063 | 2632 | 40 |
773243 | 773243 | 2020-11-27 | Hancock | Ohio | 39063 | 2572 | 40 |
769998 | 769998 | 2020-11-26 | Hancock | Ohio | 39063 | 2459 | 40 |
766752 | 766752 | 2020-11-25 | Hancock | Ohio | 39063 | 2459 | 40 |
763507 | 763507 | 2020-11-24 | Hancock | Ohio | 39063 | 2413 | 37 |
760262 | 760262 | 2020-11-23 | Hancock | Ohio | 39063 | 2327 | 36 |
757017 | 757017 | 2020-11-22 | Hancock | Ohio | 39063 | 2253 | 36 |
753770 | 753770 | 2020-11-21 | Hancock | Ohio | 39063 | 2221 | 36 |
750524 | 750524 | 2020-11-20 | Hancock | Ohio | 39063 | 2093 | 36 |
747278 | 747278 | 2020-11-19 | Hancock | Ohio | 39063 | 2025 | 33 |
744032 | 744032 | 2020-11-18 | Hancock | Ohio | 39063 | 1993 | 33 |
740785 | 740785 | 2020-11-17 | Hancock | Ohio | 39063 | 1941 | 33 |
737539 | 737539 | 2020-11-16 | Hancock | Ohio | 39063 | 1892 | 33 |
734295 | 734295 | 2020-11-15 | Hancock | Ohio | 39063 | 1855 | 33 |
731049 | 731049 | 2020-11-14 | Hancock | Ohio | 39063 | 1791 | 33 |
727805 | 727805 | 2020-11-13 | Hancock | Ohio | 39063 | 1721 | 33 |
724561 | 724561 | 2020-11-12 | Hancock | Ohio | 39063 | 1676 | 32 |
721318 | 721318 | 2020-11-11 | Hancock | Ohio | 39063 | 1647 | 32 |
718075 | 718075 | 2020-11-10 | Hancock | Ohio | 39063 | 1622 | 32 |
714832 | 714832 | 2020-11-09 | Hancock | Ohio | 39063 | 1550 | 32 |
711588 | 711588 | 2020-11-08 | Hancock | Ohio | 39063 | 1523 | 32 |
708344 | 708344 | 2020-11-07 | Hancock | Ohio | 39063 | 1481 | 32 |
705101 | 705101 | 2020-11-06 | Hancock | Ohio | 39063 | 1438 | 31 |
701858 | 701858 | 2020-11-05 | Hancock | Ohio | 39063 | 1408 | 31 |
698614 | 698614 | 2020-11-04 | Hancock | Ohio | 39063 | 1374 | 31 |
695371 | 695371 | 2020-11-03 | Hancock | Ohio | 39063 | 1349 | 30 |
692129 | 692129 | 2020-11-02 | Hancock | Ohio | 39063 | 1298 | 30 |
688885 | 688885 | 2020-11-01 | Hancock | Ohio | 39063 | 1284 | 30 |
685640 | 685640 | 2020-10-31 | Hancock | Ohio | 39063 | 1265 | 30 |
682397 | 682397 | 2020-10-30 | Hancock | Ohio | 39063 | 1232 | 30 |
679154 | 679154 | 2020-10-29 | Hancock | Ohio | 39063 | 1217 | 29 |
675911 | 675911 | 2020-10-28 | Hancock | Ohio | 39063 | 1181 | 29 |
672668 | 672668 | 2020-10-27 | Hancock | Ohio | 39063 | 1159 | 29 |
669426 | 669426 | 2020-10-26 | Hancock | Ohio | 39063 | 1133 | 27 |
666182 | 666182 | 2020-10-25 | Hancock | Ohio | 39063 | 1100 | 26 |
662937 | 662937 | 2020-10-24 | Hancock | Ohio | 39063 | 1078 | 26 |
659693 | 659693 | 2020-10-23 | Hancock | Ohio | 39063 | 1066 | 26 |
656449 | 656449 | 2020-10-22 | Hancock | Ohio | 39063 | 1047 | 25 |
653204 | 653204 | 2020-10-21 | Hancock | Ohio | 39063 | 1040 | 24 |
649959 | 649959 | 2020-10-20 | Hancock | Ohio | 39063 | 1030 | 23 |
646715 | 646715 | 2020-10-19 | Hancock | Ohio | 39063 | 995 | 21 |
643469 | 643469 | 2020-10-18 | Hancock | Ohio | 39063 | 975 | 20 |
640221 | 640221 | 2020-10-17 | Hancock | Ohio | 39063 | 967 | 20 |
636975 | 636975 | 2020-10-16 | Hancock | Ohio | 39063 | 951 | 19 |
633729 | 633729 | 2020-10-15 | Hancock | Ohio | 39063 | 919 | 18 |
630484 | 630484 | 2020-10-14 | Hancock | Ohio | 39063 | 909 | 18 |
627240 | 627240 | 2020-10-13 | Hancock | Ohio | 39063 | 901 | 18 |
623998 | 623998 | 2020-10-12 | Hancock | Ohio | 39063 | 887 | 14 |
620755 | 620755 | 2020-10-11 | Hancock | Ohio | 39063 | 879 | 14 |
617513 | 617513 | 2020-10-10 | Hancock | Ohio | 39063 | 875 | 14 |
614271 | 614271 | 2020-10-09 | Hancock | Ohio | 39063 | 866 | 14 |
611030 | 611030 | 2020-10-08 | Hancock | Ohio | 39063 | 849 | 14 |
607788 | 607788 | 2020-10-07 | Hancock | Ohio | 39063 | 823 | 14 |
604545 | 604545 | 2020-10-06 | Hancock | Ohio | 39063 | 814 | 13 |
601303 | 601303 | 2020-10-05 | Hancock | Ohio | 39063 | 805 | 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);