ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Jackson" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922536 | 922536 | 2021-01-12 | Jackson | Ohio | 39079 | 2467 | 43 |
919291 | 919291 | 2021-01-11 | Jackson | Ohio | 39079 | 2434 | 37 |
916046 | 916046 | 2021-01-10 | Jackson | Ohio | 39079 | 2411 | 37 |
912801 | 912801 | 2021-01-09 | Jackson | Ohio | 39079 | 2385 | 37 |
909556 | 909556 | 2021-01-08 | Jackson | Ohio | 39079 | 2353 | 37 |
906311 | 906311 | 2021-01-07 | Jackson | Ohio | 39079 | 2322 | 35 |
903065 | 903065 | 2021-01-06 | Jackson | Ohio | 39079 | 2284 | 35 |
899820 | 899820 | 2021-01-05 | Jackson | Ohio | 39079 | 2249 | 34 |
896575 | 896575 | 2021-01-04 | Jackson | Ohio | 39079 | 2235 | 34 |
893329 | 893329 | 2021-01-03 | Jackson | Ohio | 39079 | 2202 | 34 |
890083 | 890083 | 2021-01-02 | Jackson | Ohio | 39079 | 2183 | 34 |
886836 | 886836 | 2021-01-01 | Jackson | Ohio | 39079 | 2138 | 32 |
883591 | 883591 | 2020-12-31 | Jackson | Ohio | 39079 | 2138 | 32 |
880346 | 880346 | 2020-12-30 | Jackson | Ohio | 39079 | 2111 | 30 |
877101 | 877101 | 2020-12-29 | Jackson | Ohio | 39079 | 2065 | 30 |
873856 | 873856 | 2020-12-28 | Jackson | Ohio | 39079 | 2060 | 30 |
870611 | 870611 | 2020-12-27 | Jackson | Ohio | 39079 | 2052 | 30 |
867366 | 867366 | 2020-12-26 | Jackson | Ohio | 39079 | 2029 | 30 |
864121 | 864121 | 2020-12-25 | Jackson | Ohio | 39079 | 1997 | 30 |
860876 | 860876 | 2020-12-24 | Jackson | Ohio | 39079 | 1997 | 30 |
857631 | 857631 | 2020-12-23 | Jackson | Ohio | 39079 | 1974 | 28 |
854386 | 854386 | 2020-12-22 | Jackson | Ohio | 39079 | 1939 | 28 |
851141 | 851141 | 2020-12-21 | Jackson | Ohio | 39079 | 1922 | 20 |
847896 | 847896 | 2020-12-20 | Jackson | Ohio | 39079 | 1907 | 20 |
844651 | 844651 | 2020-12-19 | Jackson | Ohio | 39079 | 1865 | 19 |
841405 | 841405 | 2020-12-18 | Jackson | Ohio | 39079 | 1830 | 17 |
838160 | 838160 | 2020-12-17 | Jackson | Ohio | 39079 | 1803 | 17 |
834914 | 834914 | 2020-12-16 | Jackson | Ohio | 39079 | 1755 | 15 |
831668 | 831668 | 2020-12-15 | Jackson | Ohio | 39079 | 1722 | 13 |
828421 | 828421 | 2020-12-14 | Jackson | Ohio | 39079 | 1697 | 13 |
825175 | 825175 | 2020-12-13 | Jackson | Ohio | 39079 | 1687 | 13 |
821928 | 821928 | 2020-12-12 | Jackson | Ohio | 39079 | 1658 | 13 |
818682 | 818682 | 2020-12-11 | Jackson | Ohio | 39079 | 1617 | 13 |
815436 | 815436 | 2020-12-10 | Jackson | Ohio | 39079 | 1602 | 13 |
812190 | 812190 | 2020-12-09 | Jackson | Ohio | 39079 | 1563 | 13 |
808946 | 808946 | 2020-12-08 | Jackson | Ohio | 39079 | 1501 | 13 |
805701 | 805701 | 2020-12-07 | Jackson | Ohio | 39079 | 1455 | 13 |
802456 | 802456 | 2020-12-06 | Jackson | Ohio | 39079 | 1412 | 13 |
799211 | 799211 | 2020-12-05 | Jackson | Ohio | 39079 | 1365 | 13 |
795966 | 795966 | 2020-12-04 | Jackson | Ohio | 39079 | 1314 | 13 |
792721 | 792721 | 2020-12-03 | Jackson | Ohio | 39079 | 1259 | 13 |
789476 | 789476 | 2020-12-02 | Jackson | Ohio | 39079 | 1190 | 13 |
786231 | 786231 | 2020-12-01 | Jackson | Ohio | 39079 | 1152 | 13 |
782987 | 782987 | 2020-11-30 | Jackson | Ohio | 39079 | 1106 | 13 |
779741 | 779741 | 2020-11-29 | Jackson | Ohio | 39079 | 1074 | 12 |
776496 | 776496 | 2020-11-28 | Jackson | Ohio | 39079 | 1034 | 12 |
773251 | 773251 | 2020-11-27 | Jackson | Ohio | 39079 | 1020 | 12 |
770006 | 770006 | 2020-11-26 | Jackson | Ohio | 39079 | 962 | 12 |
766760 | 766760 | 2020-11-25 | Jackson | Ohio | 39079 | 962 | 12 |
763515 | 763515 | 2020-11-24 | Jackson | Ohio | 39079 | 931 | 12 |
760270 | 760270 | 2020-11-23 | Jackson | Ohio | 39079 | 903 | 12 |
757025 | 757025 | 2020-11-22 | Jackson | Ohio | 39079 | 873 | 12 |
753778 | 753778 | 2020-11-21 | Jackson | Ohio | 39079 | 863 | 12 |
750532 | 750532 | 2020-11-20 | Jackson | Ohio | 39079 | 830 | 12 |
747286 | 747286 | 2020-11-19 | Jackson | Ohio | 39079 | 803 | 11 |
744040 | 744040 | 2020-11-18 | Jackson | Ohio | 39079 | 787 | 11 |
740793 | 740793 | 2020-11-17 | Jackson | Ohio | 39079 | 772 | 10 |
737547 | 737547 | 2020-11-16 | Jackson | Ohio | 39079 | 757 | 10 |
734303 | 734303 | 2020-11-15 | Jackson | Ohio | 39079 | 746 | 10 |
731057 | 731057 | 2020-11-14 | Jackson | Ohio | 39079 | 734 | 10 |
727813 | 727813 | 2020-11-13 | Jackson | Ohio | 39079 | 717 | 10 |
724569 | 724569 | 2020-11-12 | Jackson | Ohio | 39079 | 704 | 10 |
721326 | 721326 | 2020-11-11 | Jackson | Ohio | 39079 | 680 | 10 |
718083 | 718083 | 2020-11-10 | Jackson | Ohio | 39079 | 659 | 10 |
714840 | 714840 | 2020-11-09 | Jackson | Ohio | 39079 | 635 | 10 |
711596 | 711596 | 2020-11-08 | Jackson | Ohio | 39079 | 628 | 10 |
708352 | 708352 | 2020-11-07 | Jackson | Ohio | 39079 | 612 | 10 |
705109 | 705109 | 2020-11-06 | Jackson | Ohio | 39079 | 601 | 9 |
701866 | 701866 | 2020-11-05 | Jackson | Ohio | 39079 | 590 | 9 |
698622 | 698622 | 2020-11-04 | Jackson | Ohio | 39079 | 578 | 9 |
695379 | 695379 | 2020-11-03 | Jackson | Ohio | 39079 | 561 | 9 |
692137 | 692137 | 2020-11-02 | Jackson | Ohio | 39079 | 544 | 8 |
688893 | 688893 | 2020-11-01 | Jackson | Ohio | 39079 | 539 | 8 |
685648 | 685648 | 2020-10-31 | Jackson | Ohio | 39079 | 537 | 8 |
682405 | 682405 | 2020-10-30 | Jackson | Ohio | 39079 | 526 | 8 |
679162 | 679162 | 2020-10-29 | Jackson | Ohio | 39079 | 519 | 8 |
675919 | 675919 | 2020-10-28 | Jackson | Ohio | 39079 | 510 | 8 |
672676 | 672676 | 2020-10-27 | Jackson | Ohio | 39079 | 502 | 8 |
669434 | 669434 | 2020-10-26 | Jackson | Ohio | 39079 | 492 | 8 |
666190 | 666190 | 2020-10-25 | Jackson | Ohio | 39079 | 481 | 8 |
662945 | 662945 | 2020-10-24 | Jackson | Ohio | 39079 | 478 | 8 |
659701 | 659701 | 2020-10-23 | Jackson | Ohio | 39079 | 472 | 8 |
656457 | 656457 | 2020-10-22 | Jackson | Ohio | 39079 | 459 | 8 |
653212 | 653212 | 2020-10-21 | Jackson | Ohio | 39079 | 447 | 8 |
649967 | 649967 | 2020-10-20 | Jackson | Ohio | 39079 | 441 | 7 |
646723 | 646723 | 2020-10-19 | Jackson | Ohio | 39079 | 425 | 7 |
643477 | 643477 | 2020-10-18 | Jackson | Ohio | 39079 | 419 | 7 |
640229 | 640229 | 2020-10-17 | Jackson | Ohio | 39079 | 407 | 7 |
636983 | 636983 | 2020-10-16 | Jackson | Ohio | 39079 | 388 | 7 |
633737 | 633737 | 2020-10-15 | Jackson | Ohio | 39079 | 377 | 7 |
630492 | 630492 | 2020-10-14 | Jackson | Ohio | 39079 | 365 | 7 |
627248 | 627248 | 2020-10-13 | Jackson | Ohio | 39079 | 359 | 7 |
624006 | 624006 | 2020-10-12 | Jackson | Ohio | 39079 | 351 | 7 |
620763 | 620763 | 2020-10-11 | Jackson | Ohio | 39079 | 339 | 7 |
617521 | 617521 | 2020-10-10 | Jackson | Ohio | 39079 | 332 | 7 |
614279 | 614279 | 2020-10-09 | Jackson | Ohio | 39079 | 328 | 7 |
611038 | 611038 | 2020-10-08 | Jackson | Ohio | 39079 | 317 | 7 |
607796 | 607796 | 2020-10-07 | Jackson | Ohio | 39079 | 315 | 7 |
604553 | 604553 | 2020-10-06 | Jackson | Ohio | 39079 | 306 | 7 |
601311 | 601311 | 2020-10-05 | Jackson | Ohio | 39079 | 296 | 7 |
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);