ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Adams" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948461 | 948461 | 2021-01-20 | Adams | Ohio | 39001 | 1695 | 15 |
945215 | 945215 | 2021-01-19 | Adams | Ohio | 39001 | 1674 | 15 |
941968 | 941968 | 2021-01-18 | Adams | Ohio | 39001 | 1658 | 15 |
938723 | 938723 | 2021-01-17 | Adams | Ohio | 39001 | 1656 | 15 |
935478 | 935478 | 2021-01-16 | Adams | Ohio | 39001 | 1655 | 15 |
932233 | 932233 | 2021-01-15 | Adams | Ohio | 39001 | 1618 | 15 |
928988 | 928988 | 2021-01-14 | Adams | Ohio | 39001 | 1608 | 15 |
925743 | 925743 | 2021-01-13 | Adams | Ohio | 39001 | 1592 | 15 |
922497 | 922497 | 2021-01-12 | Adams | Ohio | 39001 | 1586 | 15 |
919252 | 919252 | 2021-01-11 | Adams | Ohio | 39001 | 1562 | 15 |
916007 | 916007 | 2021-01-10 | Adams | Ohio | 39001 | 1561 | 15 |
912762 | 912762 | 2021-01-09 | Adams | Ohio | 39001 | 1552 | 15 |
909517 | 909517 | 2021-01-08 | Adams | Ohio | 39001 | 1531 | 15 |
906272 | 906272 | 2021-01-07 | Adams | Ohio | 39001 | 1502 | 14 |
903026 | 903026 | 2021-01-06 | Adams | Ohio | 39001 | 1466 | 14 |
899781 | 899781 | 2021-01-05 | Adams | Ohio | 39001 | 1446 | 14 |
896536 | 896536 | 2021-01-04 | Adams | Ohio | 39001 | 1423 | 14 |
893290 | 893290 | 2021-01-03 | Adams | Ohio | 39001 | 1410 | 14 |
890044 | 890044 | 2021-01-02 | Adams | Ohio | 39001 | 1395 | 14 |
886797 | 886797 | 2021-01-01 | Adams | Ohio | 39001 | 1367 | 14 |
883552 | 883552 | 2020-12-31 | Adams | Ohio | 39001 | 1367 | 14 |
880307 | 880307 | 2020-12-30 | Adams | Ohio | 39001 | 1336 | 14 |
877062 | 877062 | 2020-12-29 | Adams | Ohio | 39001 | 1322 | 14 |
873817 | 873817 | 2020-12-28 | Adams | Ohio | 39001 | 1294 | 14 |
870572 | 870572 | 2020-12-27 | Adams | Ohio | 39001 | 1284 | 14 |
867327 | 867327 | 2020-12-26 | Adams | Ohio | 39001 | 1269 | 14 |
864082 | 864082 | 2020-12-25 | Adams | Ohio | 39001 | 1259 | 14 |
860837 | 860837 | 2020-12-24 | Adams | Ohio | 39001 | 1259 | 14 |
857592 | 857592 | 2020-12-23 | Adams | Ohio | 39001 | 1245 | 14 |
854347 | 854347 | 2020-12-22 | Adams | Ohio | 39001 | 1223 | 14 |
851102 | 851102 | 2020-12-21 | Adams | Ohio | 39001 | 1179 | 14 |
847857 | 847857 | 2020-12-20 | Adams | Ohio | 39001 | 1163 | 14 |
844612 | 844612 | 2020-12-19 | Adams | Ohio | 39001 | 1159 | 14 |
841366 | 841366 | 2020-12-18 | Adams | Ohio | 39001 | 1145 | 14 |
838121 | 838121 | 2020-12-17 | Adams | Ohio | 39001 | 1132 | 14 |
834875 | 834875 | 2020-12-16 | Adams | Ohio | 39001 | 1113 | 14 |
831629 | 831629 | 2020-12-15 | Adams | Ohio | 39001 | 1100 | 14 |
828382 | 828382 | 2020-12-14 | Adams | Ohio | 39001 | 1082 | 13 |
825136 | 825136 | 2020-12-13 | Adams | Ohio | 39001 | 1075 | 13 |
821889 | 821889 | 2020-12-12 | Adams | Ohio | 39001 | 1069 | 13 |
818643 | 818643 | 2020-12-11 | Adams | Ohio | 39001 | 1056 | 13 |
815397 | 815397 | 2020-12-10 | Adams | Ohio | 39001 | 1032 | 13 |
812151 | 812151 | 2020-12-09 | Adams | Ohio | 39001 | 1013 | 13 |
808907 | 808907 | 2020-12-08 | Adams | Ohio | 39001 | 989 | 13 |
805662 | 805662 | 2020-12-07 | Adams | Ohio | 39001 | 944 | 13 |
802417 | 802417 | 2020-12-06 | Adams | Ohio | 39001 | 938 | 13 |
799172 | 799172 | 2020-12-05 | Adams | Ohio | 39001 | 936 | 13 |
795927 | 795927 | 2020-12-04 | Adams | Ohio | 39001 | 930 | 13 |
792682 | 792682 | 2020-12-03 | Adams | Ohio | 39001 | 915 | 13 |
789437 | 789437 | 2020-12-02 | Adams | Ohio | 39001 | 903 | 13 |
786192 | 786192 | 2020-12-01 | Adams | Ohio | 39001 | 892 | 13 |
782948 | 782948 | 2020-11-30 | Adams | Ohio | 39001 | 877 | 13 |
779702 | 779702 | 2020-11-29 | Adams | Ohio | 39001 | 869 | 13 |
776457 | 776457 | 2020-11-28 | Adams | Ohio | 39001 | 847 | 13 |
773212 | 773212 | 2020-11-27 | Adams | Ohio | 39001 | 838 | 13 |
769967 | 769967 | 2020-11-26 | Adams | Ohio | 39001 | 803 | 13 |
766721 | 766721 | 2020-11-25 | Adams | Ohio | 39001 | 803 | 13 |
763476 | 763476 | 2020-11-24 | Adams | Ohio | 39001 | 783 | 13 |
760231 | 760231 | 2020-11-23 | Adams | Ohio | 39001 | 750 | 12 |
756986 | 756986 | 2020-11-22 | Adams | Ohio | 39001 | 706 | 11 |
753739 | 753739 | 2020-11-21 | Adams | Ohio | 39001 | 700 | 11 |
750493 | 750493 | 2020-11-20 | Adams | Ohio | 39001 | 678 | 11 |
747247 | 747247 | 2020-11-19 | Adams | Ohio | 39001 | 637 | 10 |
744001 | 744001 | 2020-11-18 | Adams | Ohio | 39001 | 618 | 10 |
740754 | 740754 | 2020-11-17 | Adams | Ohio | 39001 | 586 | 9 |
737508 | 737508 | 2020-11-16 | Adams | Ohio | 39001 | 537 | 8 |
734264 | 734264 | 2020-11-15 | Adams | Ohio | 39001 | 510 | 7 |
731018 | 731018 | 2020-11-14 | Adams | Ohio | 39001 | 501 | 7 |
727774 | 727774 | 2020-11-13 | Adams | Ohio | 39001 | 479 | 7 |
724530 | 724530 | 2020-11-12 | Adams | Ohio | 39001 | 438 | 7 |
721287 | 721287 | 2020-11-11 | Adams | Ohio | 39001 | 422 | 7 |
718044 | 718044 | 2020-11-10 | Adams | Ohio | 39001 | 404 | 6 |
714801 | 714801 | 2020-11-09 | Adams | Ohio | 39001 | 353 | 6 |
711557 | 711557 | 2020-11-08 | Adams | Ohio | 39001 | 341 | 6 |
708313 | 708313 | 2020-11-07 | Adams | Ohio | 39001 | 338 | 6 |
705070 | 705070 | 2020-11-06 | Adams | Ohio | 39001 | 324 | 6 |
701827 | 701827 | 2020-11-05 | Adams | Ohio | 39001 | 312 | 6 |
698583 | 698583 | 2020-11-04 | Adams | Ohio | 39001 | 301 | 6 |
695340 | 695340 | 2020-11-03 | Adams | Ohio | 39001 | 290 | 6 |
692098 | 692098 | 2020-11-02 | Adams | Ohio | 39001 | 281 | 6 |
688854 | 688854 | 2020-11-01 | Adams | Ohio | 39001 | 270 | 6 |
685609 | 685609 | 2020-10-31 | Adams | Ohio | 39001 | 265 | 6 |
682366 | 682366 | 2020-10-30 | Adams | Ohio | 39001 | 260 | 6 |
679123 | 679123 | 2020-10-29 | Adams | Ohio | 39001 | 254 | 6 |
675880 | 675880 | 2020-10-28 | Adams | Ohio | 39001 | 244 | 6 |
672637 | 672637 | 2020-10-27 | Adams | Ohio | 39001 | 233 | 6 |
669395 | 669395 | 2020-10-26 | Adams | Ohio | 39001 | 226 | 6 |
666151 | 666151 | 2020-10-25 | Adams | Ohio | 39001 | 215 | 6 |
662906 | 662906 | 2020-10-24 | Adams | Ohio | 39001 | 214 | 6 |
659662 | 659662 | 2020-10-23 | Adams | Ohio | 39001 | 212 | 6 |
656418 | 656418 | 2020-10-22 | Adams | Ohio | 39001 | 209 | 6 |
653173 | 653173 | 2020-10-21 | Adams | Ohio | 39001 | 204 | 6 |
649928 | 649928 | 2020-10-20 | Adams | Ohio | 39001 | 203 | 6 |
646684 | 646684 | 2020-10-19 | Adams | Ohio | 39001 | 195 | 6 |
643438 | 643438 | 2020-10-18 | Adams | Ohio | 39001 | 193 | 6 |
640190 | 640190 | 2020-10-17 | Adams | Ohio | 39001 | 187 | 6 |
636944 | 636944 | 2020-10-16 | Adams | Ohio | 39001 | 187 | 6 |
633698 | 633698 | 2020-10-15 | Adams | Ohio | 39001 | 183 | 6 |
630453 | 630453 | 2020-10-14 | Adams | Ohio | 39001 | 180 | 6 |
627209 | 627209 | 2020-10-13 | Adams | Ohio | 39001 | 178 | 4 |
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);