ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39029 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922511 | 922511 | 2021-01-12 | Columbiana | Ohio | 39029 | 6780 | 122 |
919266 | 919266 | 2021-01-11 | Columbiana | Ohio | 39029 | 6699 | 122 |
916021 | 916021 | 2021-01-10 | Columbiana | Ohio | 39029 | 6651 | 122 |
912776 | 912776 | 2021-01-09 | Columbiana | Ohio | 39029 | 6626 | 122 |
909531 | 909531 | 2021-01-08 | Columbiana | Ohio | 39029 | 6579 | 122 |
906286 | 906286 | 2021-01-07 | Columbiana | Ohio | 39029 | 6498 | 120 |
903040 | 903040 | 2021-01-06 | Columbiana | Ohio | 39029 | 6430 | 120 |
899795 | 899795 | 2021-01-05 | Columbiana | Ohio | 39029 | 6375 | 120 |
896550 | 896550 | 2021-01-04 | Columbiana | Ohio | 39029 | 6309 | 119 |
893304 | 893304 | 2021-01-03 | Columbiana | Ohio | 39029 | 6260 | 119 |
890058 | 890058 | 2021-01-02 | Columbiana | Ohio | 39029 | 6239 | 119 |
886811 | 886811 | 2021-01-01 | Columbiana | Ohio | 39029 | 6147 | 119 |
883566 | 883566 | 2020-12-31 | Columbiana | Ohio | 39029 | 6147 | 119 |
880321 | 880321 | 2020-12-30 | Columbiana | Ohio | 39029 | 6074 | 119 |
877076 | 877076 | 2020-12-29 | Columbiana | Ohio | 39029 | 6015 | 119 |
873831 | 873831 | 2020-12-28 | Columbiana | Ohio | 39029 | 5936 | 119 |
870586 | 870586 | 2020-12-27 | Columbiana | Ohio | 39029 | 5892 | 119 |
867341 | 867341 | 2020-12-26 | Columbiana | Ohio | 39029 | 5863 | 119 |
864096 | 864096 | 2020-12-25 | Columbiana | Ohio | 39029 | 5780 | 119 |
860851 | 860851 | 2020-12-24 | Columbiana | Ohio | 39029 | 5780 | 119 |
857606 | 857606 | 2020-12-23 | Columbiana | Ohio | 39029 | 5672 | 118 |
854361 | 854361 | 2020-12-22 | Columbiana | Ohio | 39029 | 5598 | 117 |
851116 | 851116 | 2020-12-21 | Columbiana | Ohio | 39029 | 5538 | 116 |
847871 | 847871 | 2020-12-20 | Columbiana | Ohio | 39029 | 5496 | 116 |
844626 | 844626 | 2020-12-19 | Columbiana | Ohio | 39029 | 5443 | 116 |
841380 | 841380 | 2020-12-18 | Columbiana | Ohio | 39029 | 5396 | 115 |
838135 | 838135 | 2020-12-17 | Columbiana | Ohio | 39029 | 5340 | 113 |
834889 | 834889 | 2020-12-16 | Columbiana | Ohio | 39029 | 5212 | 113 |
831643 | 831643 | 2020-12-15 | Columbiana | Ohio | 39029 | 5168 | 113 |
828396 | 828396 | 2020-12-14 | Columbiana | Ohio | 39029 | 5118 | 110 |
825150 | 825150 | 2020-12-13 | Columbiana | Ohio | 39029 | 5048 | 110 |
821903 | 821903 | 2020-12-12 | Columbiana | Ohio | 39029 | 4988 | 110 |
818657 | 818657 | 2020-12-11 | Columbiana | Ohio | 39029 | 4915 | 110 |
815411 | 815411 | 2020-12-10 | Columbiana | Ohio | 39029 | 4837 | 109 |
812165 | 812165 | 2020-12-09 | Columbiana | Ohio | 39029 | 4732 | 107 |
808921 | 808921 | 2020-12-08 | Columbiana | Ohio | 39029 | 4650 | 107 |
805676 | 805676 | 2020-12-07 | Columbiana | Ohio | 39029 | 4480 | 104 |
802431 | 802431 | 2020-12-06 | Columbiana | Ohio | 39029 | 4411 | 104 |
799186 | 799186 | 2020-12-05 | Columbiana | Ohio | 39029 | 4353 | 104 |
795941 | 795941 | 2020-12-04 | Columbiana | Ohio | 39029 | 4233 | 104 |
792696 | 792696 | 2020-12-03 | Columbiana | Ohio | 39029 | 4131 | 103 |
789451 | 789451 | 2020-12-02 | Columbiana | Ohio | 39029 | 4012 | 102 |
786206 | 786206 | 2020-12-01 | Columbiana | Ohio | 39029 | 3952 | 100 |
782962 | 782962 | 2020-11-30 | Columbiana | Ohio | 39029 | 3902 | 99 |
779716 | 779716 | 2020-11-29 | Columbiana | Ohio | 39029 | 3852 | 99 |
776471 | 776471 | 2020-11-28 | Columbiana | Ohio | 39029 | 3789 | 99 |
773226 | 773226 | 2020-11-27 | Columbiana | Ohio | 39029 | 3765 | 99 |
769981 | 769981 | 2020-11-26 | Columbiana | Ohio | 39029 | 3576 | 98 |
766735 | 766735 | 2020-11-25 | Columbiana | Ohio | 39029 | 3576 | 98 |
763490 | 763490 | 2020-11-24 | Columbiana | Ohio | 39029 | 3472 | 97 |
760245 | 760245 | 2020-11-23 | Columbiana | Ohio | 39029 | 3395 | 97 |
757000 | 757000 | 2020-11-22 | Columbiana | Ohio | 39029 | 3284 | 96 |
753753 | 753753 | 2020-11-21 | Columbiana | Ohio | 39029 | 3240 | 95 |
750507 | 750507 | 2020-11-20 | Columbiana | Ohio | 39029 | 3165 | 95 |
747261 | 747261 | 2020-11-19 | Columbiana | Ohio | 39029 | 3052 | 95 |
744015 | 744015 | 2020-11-18 | Columbiana | Ohio | 39029 | 2948 | 93 |
740768 | 740768 | 2020-11-17 | Columbiana | Ohio | 39029 | 2891 | 93 |
737522 | 737522 | 2020-11-16 | Columbiana | Ohio | 39029 | 2859 | 92 |
734278 | 734278 | 2020-11-15 | Columbiana | Ohio | 39029 | 2811 | 92 |
731032 | 731032 | 2020-11-14 | Columbiana | Ohio | 39029 | 2738 | 92 |
727788 | 727788 | 2020-11-13 | Columbiana | Ohio | 39029 | 2695 | 92 |
724544 | 724544 | 2020-11-12 | Columbiana | Ohio | 39029 | 2612 | 91 |
721301 | 721301 | 2020-11-11 | Columbiana | Ohio | 39029 | 2569 | 88 |
718058 | 718058 | 2020-11-10 | Columbiana | Ohio | 39029 | 2546 | 88 |
714815 | 714815 | 2020-11-09 | Columbiana | Ohio | 39029 | 2514 | 88 |
711571 | 711571 | 2020-11-08 | Columbiana | Ohio | 39029 | 2463 | 88 |
708327 | 708327 | 2020-11-07 | Columbiana | Ohio | 39029 | 2436 | 88 |
705084 | 705084 | 2020-11-06 | Columbiana | Ohio | 39029 | 2416 | 88 |
701841 | 701841 | 2020-11-05 | Columbiana | Ohio | 39029 | 2379 | 88 |
698597 | 698597 | 2020-11-04 | Columbiana | Ohio | 39029 | 2336 | 88 |
695354 | 695354 | 2020-11-03 | Columbiana | Ohio | 39029 | 2315 | 88 |
692112 | 692112 | 2020-11-02 | Columbiana | Ohio | 39029 | 2303 | 88 |
688868 | 688868 | 2020-11-01 | Columbiana | Ohio | 39029 | 2269 | 88 |
685623 | 685623 | 2020-10-31 | Columbiana | Ohio | 39029 | 2252 | 88 |
682380 | 682380 | 2020-10-30 | Columbiana | Ohio | 39029 | 2246 | 88 |
679137 | 679137 | 2020-10-29 | Columbiana | Ohio | 39029 | 2227 | 88 |
675894 | 675894 | 2020-10-28 | Columbiana | Ohio | 39029 | 2204 | 88 |
672651 | 672651 | 2020-10-27 | Columbiana | Ohio | 39029 | 2190 | 88 |
669409 | 669409 | 2020-10-26 | Columbiana | Ohio | 39029 | 2185 | 88 |
666165 | 666165 | 2020-10-25 | Columbiana | Ohio | 39029 | 2162 | 88 |
662920 | 662920 | 2020-10-24 | Columbiana | Ohio | 39029 | 2146 | 88 |
659676 | 659676 | 2020-10-23 | Columbiana | Ohio | 39029 | 2133 | 87 |
656432 | 656432 | 2020-10-22 | Columbiana | Ohio | 39029 | 2128 | 87 |
653187 | 653187 | 2020-10-21 | Columbiana | Ohio | 39029 | 2114 | 87 |
649942 | 649942 | 2020-10-20 | Columbiana | Ohio | 39029 | 2101 | 87 |
646698 | 646698 | 2020-10-19 | Columbiana | Ohio | 39029 | 2096 | 87 |
643452 | 643452 | 2020-10-18 | Columbiana | Ohio | 39029 | 2078 | 87 |
640204 | 640204 | 2020-10-17 | Columbiana | Ohio | 39029 | 2071 | 87 |
636958 | 636958 | 2020-10-16 | Columbiana | Ohio | 39029 | 2062 | 87 |
633712 | 633712 | 2020-10-15 | Columbiana | Ohio | 39029 | 2053 | 86 |
630467 | 630467 | 2020-10-14 | Columbiana | Ohio | 39029 | 2042 | 86 |
627223 | 627223 | 2020-10-13 | Columbiana | Ohio | 39029 | 2027 | 86 |
623981 | 623981 | 2020-10-12 | Columbiana | Ohio | 39029 | 2024 | 86 |
620738 | 620738 | 2020-10-11 | Columbiana | Ohio | 39029 | 2014 | 86 |
617496 | 617496 | 2020-10-10 | Columbiana | Ohio | 39029 | 2010 | 86 |
614254 | 614254 | 2020-10-09 | Columbiana | Ohio | 39029 | 2006 | 86 |
611013 | 611013 | 2020-10-08 | Columbiana | Ohio | 39029 | 2003 | 86 |
607771 | 607771 | 2020-10-07 | Columbiana | Ohio | 39029 | 1998 | 85 |
604528 | 604528 | 2020-10-06 | Columbiana | Ohio | 39029 | 1993 | 83 |
601286 | 601286 | 2020-10-05 | Columbiana | Ohio | 39029 | 1991 | 82 |
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);