ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 39143 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922568 | 922568 | 2021-01-12 | Sandusky | Ohio | 39143 | 4057 | 60 |
919323 | 919323 | 2021-01-11 | Sandusky | Ohio | 39143 | 4036 | 59 |
916078 | 916078 | 2021-01-10 | Sandusky | Ohio | 39143 | 4000 | 59 |
912833 | 912833 | 2021-01-09 | Sandusky | Ohio | 39143 | 3962 | 59 |
909588 | 909588 | 2021-01-08 | Sandusky | Ohio | 39143 | 3910 | 59 |
906343 | 906343 | 2021-01-07 | Sandusky | Ohio | 39143 | 3862 | 59 |
903097 | 903097 | 2021-01-06 | Sandusky | Ohio | 39143 | 3770 | 59 |
899852 | 899852 | 2021-01-05 | Sandusky | Ohio | 39143 | 3740 | 59 |
896607 | 896607 | 2021-01-04 | Sandusky | Ohio | 39143 | 3706 | 59 |
893361 | 893361 | 2021-01-03 | Sandusky | Ohio | 39143 | 3651 | 59 |
890115 | 890115 | 2021-01-02 | Sandusky | Ohio | 39143 | 3613 | 58 |
886868 | 886868 | 2021-01-01 | Sandusky | Ohio | 39143 | 3553 | 56 |
883623 | 883623 | 2020-12-31 | Sandusky | Ohio | 39143 | 3553 | 56 |
880378 | 880378 | 2020-12-30 | Sandusky | Ohio | 39143 | 3485 | 55 |
877133 | 877133 | 2020-12-29 | Sandusky | Ohio | 39143 | 3439 | 55 |
873888 | 873888 | 2020-12-28 | Sandusky | Ohio | 39143 | 3416 | 53 |
870643 | 870643 | 2020-12-27 | Sandusky | Ohio | 39143 | 3375 | 53 |
867398 | 867398 | 2020-12-26 | Sandusky | Ohio | 39143 | 3353 | 53 |
864153 | 864153 | 2020-12-25 | Sandusky | Ohio | 39143 | 3279 | 53 |
860908 | 860908 | 2020-12-24 | Sandusky | Ohio | 39143 | 3279 | 53 |
857663 | 857663 | 2020-12-23 | Sandusky | Ohio | 39143 | 3220 | 52 |
854418 | 854418 | 2020-12-22 | Sandusky | Ohio | 39143 | 3158 | 51 |
851173 | 851173 | 2020-12-21 | Sandusky | Ohio | 39143 | 3102 | 47 |
847928 | 847928 | 2020-12-20 | Sandusky | Ohio | 39143 | 3077 | 47 |
844683 | 844683 | 2020-12-19 | Sandusky | Ohio | 39143 | 3035 | 46 |
841437 | 841437 | 2020-12-18 | Sandusky | Ohio | 39143 | 2981 | 45 |
838192 | 838192 | 2020-12-17 | Sandusky | Ohio | 39143 | 2926 | 44 |
834946 | 834946 | 2020-12-16 | Sandusky | Ohio | 39143 | 2856 | 44 |
831700 | 831700 | 2020-12-15 | Sandusky | Ohio | 39143 | 2794 | 44 |
828453 | 828453 | 2020-12-14 | Sandusky | Ohio | 39143 | 2768 | 40 |
825207 | 825207 | 2020-12-13 | Sandusky | Ohio | 39143 | 2711 | 40 |
821960 | 821960 | 2020-12-12 | Sandusky | Ohio | 39143 | 2679 | 38 |
818714 | 818714 | 2020-12-11 | Sandusky | Ohio | 39143 | 2552 | 38 |
815468 | 815468 | 2020-12-10 | Sandusky | Ohio | 39143 | 2474 | 38 |
812222 | 812222 | 2020-12-09 | Sandusky | Ohio | 39143 | 2409 | 38 |
808978 | 808978 | 2020-12-08 | Sandusky | Ohio | 39143 | 2348 | 37 |
805733 | 805733 | 2020-12-07 | Sandusky | Ohio | 39143 | 2051 | 36 |
802488 | 802488 | 2020-12-06 | Sandusky | Ohio | 39143 | 2007 | 36 |
799243 | 799243 | 2020-12-05 | Sandusky | Ohio | 39143 | 1995 | 35 |
795998 | 795998 | 2020-12-04 | Sandusky | Ohio | 39143 | 1936 | 33 |
792753 | 792753 | 2020-12-03 | Sandusky | Ohio | 39143 | 1892 | 33 |
789508 | 789508 | 2020-12-02 | Sandusky | Ohio | 39143 | 1842 | 32 |
786263 | 786263 | 2020-12-01 | Sandusky | Ohio | 39143 | 1812 | 31 |
783019 | 783019 | 2020-11-30 | Sandusky | Ohio | 39143 | 1786 | 29 |
779773 | 779773 | 2020-11-29 | Sandusky | Ohio | 39143 | 1753 | 29 |
776528 | 776528 | 2020-11-28 | Sandusky | Ohio | 39143 | 1728 | 29 |
773283 | 773283 | 2020-11-27 | Sandusky | Ohio | 39143 | 1664 | 29 |
770038 | 770038 | 2020-11-26 | Sandusky | Ohio | 39143 | 1577 | 29 |
766792 | 766792 | 2020-11-25 | Sandusky | Ohio | 39143 | 1577 | 29 |
763547 | 763547 | 2020-11-24 | Sandusky | Ohio | 39143 | 1542 | 29 |
760302 | 760302 | 2020-11-23 | Sandusky | Ohio | 39143 | 1523 | 27 |
757057 | 757057 | 2020-11-22 | Sandusky | Ohio | 39143 | 1444 | 27 |
753810 | 753810 | 2020-11-21 | Sandusky | Ohio | 39143 | 1409 | 27 |
750564 | 750564 | 2020-11-20 | Sandusky | Ohio | 39143 | 1370 | 27 |
747318 | 747318 | 2020-11-19 | Sandusky | Ohio | 39143 | 1322 | 27 |
744072 | 744072 | 2020-11-18 | Sandusky | Ohio | 39143 | 1285 | 25 |
740825 | 740825 | 2020-11-17 | Sandusky | Ohio | 39143 | 1272 | 25 |
737579 | 737579 | 2020-11-16 | Sandusky | Ohio | 39143 | 1247 | 25 |
734335 | 734335 | 2020-11-15 | Sandusky | Ohio | 39143 | 1231 | 25 |
731089 | 731089 | 2020-11-14 | Sandusky | Ohio | 39143 | 1196 | 25 |
727845 | 727845 | 2020-11-13 | Sandusky | Ohio | 39143 | 1163 | 25 |
724601 | 724601 | 2020-11-12 | Sandusky | Ohio | 39143 | 1099 | 25 |
721358 | 721358 | 2020-11-11 | Sandusky | Ohio | 39143 | 1064 | 25 |
718115 | 718115 | 2020-11-10 | Sandusky | Ohio | 39143 | 1034 | 25 |
714872 | 714872 | 2020-11-09 | Sandusky | Ohio | 39143 | 1017 | 25 |
711628 | 711628 | 2020-11-08 | Sandusky | Ohio | 39143 | 984 | 25 |
708384 | 708384 | 2020-11-07 | Sandusky | Ohio | 39143 | 975 | 24 |
705141 | 705141 | 2020-11-06 | Sandusky | Ohio | 39143 | 936 | 24 |
701898 | 701898 | 2020-11-05 | Sandusky | Ohio | 39143 | 905 | 23 |
698654 | 698654 | 2020-11-04 | Sandusky | Ohio | 39143 | 896 | 22 |
695411 | 695411 | 2020-11-03 | Sandusky | Ohio | 39143 | 863 | 22 |
692169 | 692169 | 2020-11-02 | Sandusky | Ohio | 39143 | 845 | 22 |
688925 | 688925 | 2020-11-01 | Sandusky | Ohio | 39143 | 828 | 22 |
685680 | 685680 | 2020-10-31 | Sandusky | Ohio | 39143 | 803 | 22 |
682437 | 682437 | 2020-10-30 | Sandusky | Ohio | 39143 | 790 | 22 |
679194 | 679194 | 2020-10-29 | Sandusky | Ohio | 39143 | 781 | 22 |
675951 | 675951 | 2020-10-28 | Sandusky | Ohio | 39143 | 758 | 22 |
672708 | 672708 | 2020-10-27 | Sandusky | Ohio | 39143 | 747 | 22 |
669466 | 669466 | 2020-10-26 | Sandusky | Ohio | 39143 | 740 | 22 |
666222 | 666222 | 2020-10-25 | Sandusky | Ohio | 39143 | 729 | 22 |
662977 | 662977 | 2020-10-24 | Sandusky | Ohio | 39143 | 723 | 22 |
659733 | 659733 | 2020-10-23 | Sandusky | Ohio | 39143 | 717 | 22 |
656489 | 656489 | 2020-10-22 | Sandusky | Ohio | 39143 | 711 | 22 |
653244 | 653244 | 2020-10-21 | Sandusky | Ohio | 39143 | 699 | 22 |
649999 | 649999 | 2020-10-20 | Sandusky | Ohio | 39143 | 694 | 22 |
646755 | 646755 | 2020-10-19 | Sandusky | Ohio | 39143 | 691 | 22 |
643509 | 643509 | 2020-10-18 | Sandusky | Ohio | 39143 | 690 | 22 |
640261 | 640261 | 2020-10-17 | Sandusky | Ohio | 39143 | 684 | 22 |
637015 | 637015 | 2020-10-16 | Sandusky | Ohio | 39143 | 677 | 22 |
633769 | 633769 | 2020-10-15 | Sandusky | Ohio | 39143 | 672 | 22 |
630524 | 630524 | 2020-10-14 | Sandusky | Ohio | 39143 | 667 | 22 |
627280 | 627280 | 2020-10-13 | Sandusky | Ohio | 39143 | 655 | 22 |
624038 | 624038 | 2020-10-12 | Sandusky | Ohio | 39143 | 658 | 21 |
620795 | 620795 | 2020-10-11 | Sandusky | Ohio | 39143 | 639 | 21 |
617553 | 617553 | 2020-10-10 | Sandusky | Ohio | 39143 | 631 | 21 |
614311 | 614311 | 2020-10-09 | Sandusky | Ohio | 39143 | 626 | 21 |
611070 | 611070 | 2020-10-08 | Sandusky | Ohio | 39143 | 621 | 21 |
607828 | 607828 | 2020-10-07 | Sandusky | Ohio | 39143 | 618 | 21 |
604585 | 604585 | 2020-10-06 | Sandusky | Ohio | 39143 | 613 | 21 |
601343 | 601343 | 2020-10-05 | Sandusky | Ohio | 39143 | 611 | 21 |
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);