ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 39069 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922531 | 922531 | 2021-01-12 | Henry | Ohio | 39069 | 2042 | 47 |
919286 | 919286 | 2021-01-11 | Henry | Ohio | 39069 | 2023 | 47 |
916041 | 916041 | 2021-01-10 | Henry | Ohio | 39069 | 1985 | 47 |
912796 | 912796 | 2021-01-09 | Henry | Ohio | 39069 | 1975 | 47 |
909551 | 909551 | 2021-01-08 | Henry | Ohio | 39069 | 1950 | 47 |
906306 | 906306 | 2021-01-07 | Henry | Ohio | 39069 | 1931 | 46 |
903060 | 903060 | 2021-01-06 | Henry | Ohio | 39069 | 1889 | 45 |
899815 | 899815 | 2021-01-05 | Henry | Ohio | 39069 | 1874 | 45 |
896570 | 896570 | 2021-01-04 | Henry | Ohio | 39069 | 1852 | 45 |
893324 | 893324 | 2021-01-03 | Henry | Ohio | 39069 | 1836 | 45 |
890078 | 890078 | 2021-01-02 | Henry | Ohio | 39069 | 1819 | 45 |
886831 | 886831 | 2021-01-01 | Henry | Ohio | 39069 | 1791 | 45 |
883586 | 883586 | 2020-12-31 | Henry | Ohio | 39069 | 1791 | 45 |
880341 | 880341 | 2020-12-30 | Henry | Ohio | 39069 | 1761 | 41 |
877096 | 877096 | 2020-12-29 | Henry | Ohio | 39069 | 1736 | 36 |
873851 | 873851 | 2020-12-28 | Henry | Ohio | 39069 | 1722 | 35 |
870606 | 870606 | 2020-12-27 | Henry | Ohio | 39069 | 1712 | 35 |
867361 | 867361 | 2020-12-26 | Henry | Ohio | 39069 | 1702 | 35 |
864116 | 864116 | 2020-12-25 | Henry | Ohio | 39069 | 1668 | 35 |
860871 | 860871 | 2020-12-24 | Henry | Ohio | 39069 | 1668 | 35 |
857626 | 857626 | 2020-12-23 | Henry | Ohio | 39069 | 1641 | 35 |
854381 | 854381 | 2020-12-22 | Henry | Ohio | 39069 | 1626 | 35 |
851136 | 851136 | 2020-12-21 | Henry | Ohio | 39069 | 1599 | 35 |
847891 | 847891 | 2020-12-20 | Henry | Ohio | 39069 | 1576 | 35 |
844646 | 844646 | 2020-12-19 | Henry | Ohio | 39069 | 1559 | 35 |
841400 | 841400 | 2020-12-18 | Henry | Ohio | 39069 | 1543 | 35 |
838155 | 838155 | 2020-12-17 | Henry | Ohio | 39069 | 1524 | 35 |
834909 | 834909 | 2020-12-16 | Henry | Ohio | 39069 | 1492 | 35 |
831663 | 831663 | 2020-12-15 | Henry | Ohio | 39069 | 1476 | 35 |
828416 | 828416 | 2020-12-14 | Henry | Ohio | 39069 | 1461 | 35 |
825170 | 825170 | 2020-12-13 | Henry | Ohio | 39069 | 1428 | 35 |
821923 | 821923 | 2020-12-12 | Henry | Ohio | 39069 | 1413 | 35 |
818677 | 818677 | 2020-12-11 | Henry | Ohio | 39069 | 1385 | 35 |
815431 | 815431 | 2020-12-10 | Henry | Ohio | 39069 | 1361 | 30 |
812185 | 812185 | 2020-12-09 | Henry | Ohio | 39069 | 1341 | 30 |
808941 | 808941 | 2020-12-08 | Henry | Ohio | 39069 | 1308 | 29 |
805696 | 805696 | 2020-12-07 | Henry | Ohio | 39069 | 1247 | 29 |
802451 | 802451 | 2020-12-06 | Henry | Ohio | 39069 | 1226 | 29 |
799206 | 799206 | 2020-12-05 | Henry | Ohio | 39069 | 1209 | 29 |
795961 | 795961 | 2020-12-04 | Henry | Ohio | 39069 | 1173 | 29 |
792716 | 792716 | 2020-12-03 | Henry | Ohio | 39069 | 1146 | 29 |
789471 | 789471 | 2020-12-02 | Henry | Ohio | 39069 | 1135 | 29 |
786226 | 786226 | 2020-12-01 | Henry | Ohio | 39069 | 1120 | 23 |
782982 | 782982 | 2020-11-30 | Henry | Ohio | 39069 | 1102 | 23 |
779736 | 779736 | 2020-11-29 | Henry | Ohio | 39069 | 1076 | 23 |
776491 | 776491 | 2020-11-28 | Henry | Ohio | 39069 | 1074 | 23 |
773246 | 773246 | 2020-11-27 | Henry | Ohio | 39069 | 1054 | 23 |
770001 | 770001 | 2020-11-26 | Henry | Ohio | 39069 | 1013 | 23 |
766755 | 766755 | 2020-11-25 | Henry | Ohio | 39069 | 1013 | 23 |
763510 | 763510 | 2020-11-24 | Henry | Ohio | 39069 | 1000 | 23 |
760265 | 760265 | 2020-11-23 | Henry | Ohio | 39069 | 984 | 22 |
757020 | 757020 | 2020-11-22 | Henry | Ohio | 39069 | 944 | 22 |
753773 | 753773 | 2020-11-21 | Henry | Ohio | 39069 | 927 | 22 |
750527 | 750527 | 2020-11-20 | Henry | Ohio | 39069 | 890 | 22 |
747281 | 747281 | 2020-11-19 | Henry | Ohio | 39069 | 863 | 22 |
744035 | 744035 | 2020-11-18 | Henry | Ohio | 39069 | 847 | 21 |
740788 | 740788 | 2020-11-17 | Henry | Ohio | 39069 | 837 | 21 |
737542 | 737542 | 2020-11-16 | Henry | Ohio | 39069 | 830 | 21 |
734298 | 734298 | 2020-11-15 | Henry | Ohio | 39069 | 809 | 21 |
731052 | 731052 | 2020-11-14 | Henry | Ohio | 39069 | 774 | 21 |
727808 | 727808 | 2020-11-13 | Henry | Ohio | 39069 | 766 | 21 |
724564 | 724564 | 2020-11-12 | Henry | Ohio | 39069 | 745 | 20 |
721321 | 721321 | 2020-11-11 | Henry | Ohio | 39069 | 728 | 20 |
718078 | 718078 | 2020-11-10 | Henry | Ohio | 39069 | 717 | 18 |
714835 | 714835 | 2020-11-09 | Henry | Ohio | 39069 | 694 | 18 |
711591 | 711591 | 2020-11-08 | Henry | Ohio | 39069 | 679 | 18 |
708347 | 708347 | 2020-11-07 | Henry | Ohio | 39069 | 664 | 18 |
705104 | 705104 | 2020-11-06 | Henry | Ohio | 39069 | 659 | 18 |
701861 | 701861 | 2020-11-05 | Henry | Ohio | 39069 | 636 | 18 |
698617 | 698617 | 2020-11-04 | Henry | Ohio | 39069 | 628 | 18 |
695374 | 695374 | 2020-11-03 | Henry | Ohio | 39069 | 617 | 18 |
692132 | 692132 | 2020-11-02 | Henry | Ohio | 39069 | 599 | 18 |
688888 | 688888 | 2020-11-01 | Henry | Ohio | 39069 | 584 | 17 |
685643 | 685643 | 2020-10-31 | Henry | Ohio | 39069 | 574 | 17 |
682400 | 682400 | 2020-10-30 | Henry | Ohio | 39069 | 563 | 17 |
679157 | 679157 | 2020-10-29 | Henry | Ohio | 39069 | 553 | 17 |
675914 | 675914 | 2020-10-28 | Henry | Ohio | 39069 | 538 | 17 |
672671 | 672671 | 2020-10-27 | Henry | Ohio | 39069 | 535 | 17 |
669429 | 669429 | 2020-10-26 | Henry | Ohio | 39069 | 531 | 17 |
666185 | 666185 | 2020-10-25 | Henry | Ohio | 39069 | 503 | 17 |
662940 | 662940 | 2020-10-24 | Henry | Ohio | 39069 | 498 | 17 |
659696 | 659696 | 2020-10-23 | Henry | Ohio | 39069 | 488 | 17 |
656452 | 656452 | 2020-10-22 | Henry | Ohio | 39069 | 473 | 17 |
653207 | 653207 | 2020-10-21 | Henry | Ohio | 39069 | 461 | 17 |
649962 | 649962 | 2020-10-20 | Henry | Ohio | 39069 | 453 | 17 |
646718 | 646718 | 2020-10-19 | Henry | Ohio | 39069 | 449 | 17 |
643472 | 643472 | 2020-10-18 | Henry | Ohio | 39069 | 442 | 17 |
640224 | 640224 | 2020-10-17 | Henry | Ohio | 39069 | 435 | 17 |
636978 | 636978 | 2020-10-16 | Henry | Ohio | 39069 | 426 | 17 |
633732 | 633732 | 2020-10-15 | Henry | Ohio | 39069 | 419 | 17 |
630487 | 630487 | 2020-10-14 | Henry | Ohio | 39069 | 417 | 17 |
627243 | 627243 | 2020-10-13 | Henry | Ohio | 39069 | 412 | 17 |
624001 | 624001 | 2020-10-12 | Henry | Ohio | 39069 | 410 | 17 |
620758 | 620758 | 2020-10-11 | Henry | Ohio | 39069 | 398 | 17 |
617516 | 617516 | 2020-10-10 | Henry | Ohio | 39069 | 396 | 17 |
614274 | 614274 | 2020-10-09 | Henry | Ohio | 39069 | 389 | 17 |
611033 | 611033 | 2020-10-08 | Henry | Ohio | 39069 | 382 | 17 |
607791 | 607791 | 2020-10-07 | Henry | Ohio | 39069 | 373 | 17 |
604548 | 604548 | 2020-10-06 | Henry | Ohio | 39069 | 367 | 17 |
601306 | 601306 | 2020-10-05 | Henry | Ohio | 39069 | 364 | 17 |
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);