ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39085 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922539 | 922539 | 2021-01-12 | Lake | Ohio | 39085 | 14621 | 126 |
919294 | 919294 | 2021-01-11 | Lake | Ohio | 39085 | 14461 | 126 |
916049 | 916049 | 2021-01-10 | Lake | Ohio | 39085 | 14319 | 126 |
912804 | 912804 | 2021-01-09 | Lake | Ohio | 39085 | 14201 | 126 |
909559 | 909559 | 2021-01-08 | Lake | Ohio | 39085 | 14050 | 126 |
906314 | 906314 | 2021-01-07 | Lake | Ohio | 39085 | 13887 | 126 |
903068 | 903068 | 2021-01-06 | Lake | Ohio | 39085 | 13670 | 123 |
899823 | 899823 | 2021-01-05 | Lake | Ohio | 39085 | 13478 | 123 |
896578 | 896578 | 2021-01-04 | Lake | Ohio | 39085 | 13317 | 121 |
893332 | 893332 | 2021-01-03 | Lake | Ohio | 39085 | 13156 | 120 |
890086 | 890086 | 2021-01-02 | Lake | Ohio | 39085 | 13013 | 120 |
886839 | 886839 | 2021-01-01 | Lake | Ohio | 39085 | 12756 | 120 |
883594 | 883594 | 2020-12-31 | Lake | Ohio | 39085 | 12756 | 120 |
880349 | 880349 | 2020-12-30 | Lake | Ohio | 39085 | 12569 | 120 |
877104 | 877104 | 2020-12-29 | Lake | Ohio | 39085 | 12428 | 120 |
873859 | 873859 | 2020-12-28 | Lake | Ohio | 39085 | 12282 | 113 |
870614 | 870614 | 2020-12-27 | Lake | Ohio | 39085 | 12157 | 113 |
867369 | 867369 | 2020-12-26 | Lake | Ohio | 39085 | 12034 | 113 |
864124 | 864124 | 2020-12-25 | Lake | Ohio | 39085 | 11854 | 113 |
860879 | 860879 | 2020-12-24 | Lake | Ohio | 39085 | 11854 | 113 |
857634 | 857634 | 2020-12-23 | Lake | Ohio | 39085 | 11674 | 107 |
854389 | 854389 | 2020-12-22 | Lake | Ohio | 39085 | 11501 | 98 |
851144 | 851144 | 2020-12-21 | Lake | Ohio | 39085 | 11314 | 98 |
847899 | 847899 | 2020-12-20 | Lake | Ohio | 39085 | 11200 | 98 |
844654 | 844654 | 2020-12-19 | Lake | Ohio | 39085 | 11034 | 98 |
841408 | 841408 | 2020-12-18 | Lake | Ohio | 39085 | 10899 | 98 |
838163 | 838163 | 2020-12-17 | Lake | Ohio | 39085 | 10743 | 97 |
834917 | 834917 | 2020-12-16 | Lake | Ohio | 39085 | 10560 | 97 |
831671 | 831671 | 2020-12-15 | Lake | Ohio | 39085 | 10490 | 97 |
828424 | 828424 | 2020-12-14 | Lake | Ohio | 39085 | 10332 | 95 |
825178 | 825178 | 2020-12-13 | Lake | Ohio | 39085 | 10207 | 94 |
821931 | 821931 | 2020-12-12 | Lake | Ohio | 39085 | 10032 | 94 |
818685 | 818685 | 2020-12-11 | Lake | Ohio | 39085 | 9860 | 90 |
815439 | 815439 | 2020-12-10 | Lake | Ohio | 39085 | 9734 | 87 |
812193 | 812193 | 2020-12-09 | Lake | Ohio | 39085 | 9517 | 85 |
808949 | 808949 | 2020-12-08 | Lake | Ohio | 39085 | 9338 | 84 |
805704 | 805704 | 2020-12-07 | Lake | Ohio | 39085 | 8953 | 81 |
802459 | 802459 | 2020-12-06 | Lake | Ohio | 39085 | 8803 | 81 |
799214 | 799214 | 2020-12-05 | Lake | Ohio | 39085 | 8699 | 81 |
795969 | 795969 | 2020-12-04 | Lake | Ohio | 39085 | 8558 | 81 |
792724 | 792724 | 2020-12-03 | Lake | Ohio | 39085 | 8408 | 80 |
789479 | 789479 | 2020-12-02 | Lake | Ohio | 39085 | 8333 | 77 |
786234 | 786234 | 2020-12-01 | Lake | Ohio | 39085 | 8212 | 67 |
782990 | 782990 | 2020-11-30 | Lake | Ohio | 39085 | 7994 | 66 |
779744 | 779744 | 2020-11-29 | Lake | Ohio | 39085 | 7890 | 66 |
776499 | 776499 | 2020-11-28 | Lake | Ohio | 39085 | 7706 | 66 |
773254 | 773254 | 2020-11-27 | Lake | Ohio | 39085 | 7525 | 66 |
770009 | 770009 | 2020-11-26 | Lake | Ohio | 39085 | 7100 | 67 |
766763 | 766763 | 2020-11-25 | Lake | Ohio | 39085 | 7100 | 67 |
763518 | 763518 | 2020-11-24 | Lake | Ohio | 39085 | 6826 | 66 |
760273 | 760273 | 2020-11-23 | Lake | Ohio | 39085 | 6627 | 66 |
757028 | 757028 | 2020-11-22 | Lake | Ohio | 39085 | 6254 | 66 |
753781 | 753781 | 2020-11-21 | Lake | Ohio | 39085 | 5991 | 66 |
750535 | 750535 | 2020-11-20 | Lake | Ohio | 39085 | 5861 | 66 |
747289 | 747289 | 2020-11-19 | Lake | Ohio | 39085 | 5665 | 66 |
744043 | 744043 | 2020-11-18 | Lake | Ohio | 39085 | 5413 | 62 |
740796 | 740796 | 2020-11-17 | Lake | Ohio | 39085 | 5197 | 62 |
737550 | 737550 | 2020-11-16 | Lake | Ohio | 39085 | 5001 | 62 |
734306 | 734306 | 2020-11-15 | Lake | Ohio | 39085 | 4721 | 62 |
731060 | 731060 | 2020-11-14 | Lake | Ohio | 39085 | 4469 | 62 |
727816 | 727816 | 2020-11-13 | Lake | Ohio | 39085 | 4264 | 62 |
724572 | 724572 | 2020-11-12 | Lake | Ohio | 39085 | 4006 | 62 |
721329 | 721329 | 2020-11-11 | Lake | Ohio | 39085 | 3743 | 62 |
718086 | 718086 | 2020-11-10 | Lake | Ohio | 39085 | 3599 | 61 |
714843 | 714843 | 2020-11-09 | Lake | Ohio | 39085 | 3409 | 61 |
711599 | 711599 | 2020-11-08 | Lake | Ohio | 39085 | 3277 | 61 |
708355 | 708355 | 2020-11-07 | Lake | Ohio | 39085 | 3144 | 60 |
705112 | 705112 | 2020-11-06 | Lake | Ohio | 39085 | 2976 | 60 |
701869 | 701869 | 2020-11-05 | Lake | Ohio | 39085 | 2834 | 60 |
698625 | 698625 | 2020-11-04 | Lake | Ohio | 39085 | 2681 | 60 |
695382 | 695382 | 2020-11-03 | Lake | Ohio | 39085 | 2580 | 60 |
692140 | 692140 | 2020-11-02 | Lake | Ohio | 39085 | 2486 | 60 |
688896 | 688896 | 2020-11-01 | Lake | Ohio | 39085 | 2411 | 60 |
685651 | 685651 | 2020-10-31 | Lake | Ohio | 39085 | 2357 | 60 |
682408 | 682408 | 2020-10-30 | Lake | Ohio | 39085 | 2294 | 60 |
679165 | 679165 | 2020-10-29 | Lake | Ohio | 39085 | 2221 | 60 |
675922 | 675922 | 2020-10-28 | Lake | Ohio | 39085 | 2135 | 60 |
672679 | 672679 | 2020-10-27 | Lake | Ohio | 39085 | 2089 | 60 |
669437 | 669437 | 2020-10-26 | Lake | Ohio | 39085 | 2069 | 59 |
666193 | 666193 | 2020-10-25 | Lake | Ohio | 39085 | 2033 | 59 |
662948 | 662948 | 2020-10-24 | Lake | Ohio | 39085 | 1994 | 59 |
659704 | 659704 | 2020-10-23 | Lake | Ohio | 39085 | 1966 | 59 |
656460 | 656460 | 2020-10-22 | Lake | Ohio | 39085 | 1936 | 59 |
653215 | 653215 | 2020-10-21 | Lake | Ohio | 39085 | 1911 | 59 |
649970 | 649970 | 2020-10-20 | Lake | Ohio | 39085 | 1883 | 57 |
646726 | 646726 | 2020-10-19 | Lake | Ohio | 39085 | 1869 | 57 |
643480 | 643480 | 2020-10-18 | Lake | Ohio | 39085 | 1847 | 57 |
640232 | 640232 | 2020-10-17 | Lake | Ohio | 39085 | 1831 | 57 |
636986 | 636986 | 2020-10-16 | Lake | Ohio | 39085 | 1811 | 57 |
633740 | 633740 | 2020-10-15 | Lake | Ohio | 39085 | 1798 | 57 |
630495 | 630495 | 2020-10-14 | Lake | Ohio | 39085 | 1777 | 57 |
627251 | 627251 | 2020-10-13 | Lake | Ohio | 39085 | 1772 | 57 |
624009 | 624009 | 2020-10-12 | Lake | Ohio | 39085 | 1763 | 56 |
620766 | 620766 | 2020-10-11 | Lake | Ohio | 39085 | 1752 | 56 |
617524 | 617524 | 2020-10-10 | Lake | Ohio | 39085 | 1748 | 56 |
614282 | 614282 | 2020-10-09 | Lake | Ohio | 39085 | 1739 | 56 |
611041 | 611041 | 2020-10-08 | Lake | Ohio | 39085 | 1729 | 56 |
607799 | 607799 | 2020-10-07 | Lake | Ohio | 39085 | 1717 | 56 |
604556 | 604556 | 2020-10-06 | Lake | Ohio | 39085 | 1711 | 56 |
601314 | 601314 | 2020-10-05 | Lake | Ohio | 39085 | 1701 | 56 |
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);