ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 39103 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922548 | 922548 | 2021-01-12 | Medina | Ohio | 39103 | 10632 | 155 |
919303 | 919303 | 2021-01-11 | Medina | Ohio | 39103 | 10551 | 167 |
916058 | 916058 | 2021-01-10 | Medina | Ohio | 39103 | 10435 | 121 |
912813 | 912813 | 2021-01-09 | Medina | Ohio | 39103 | 10349 | 121 |
909568 | 909568 | 2021-01-08 | Medina | Ohio | 39103 | 10227 | 121 |
906323 | 906323 | 2021-01-07 | Medina | Ohio | 39103 | 10102 | 118 |
903077 | 903077 | 2021-01-06 | Medina | Ohio | 39103 | 9930 | 117 |
899832 | 899832 | 2021-01-05 | Medina | Ohio | 39103 | 9830 | 116 |
896587 | 896587 | 2021-01-04 | Medina | Ohio | 39103 | 9700 | 115 |
893341 | 893341 | 2021-01-03 | Medina | Ohio | 39103 | 9601 | 114 |
890095 | 890095 | 2021-01-02 | Medina | Ohio | 39103 | 9515 | 114 |
886848 | 886848 | 2021-01-01 | Medina | Ohio | 39103 | 9312 | 114 |
883603 | 883603 | 2020-12-31 | Medina | Ohio | 39103 | 9312 | 114 |
880358 | 880358 | 2020-12-30 | Medina | Ohio | 39103 | 9195 | 103 |
877113 | 877113 | 2020-12-29 | Medina | Ohio | 39103 | 9048 | 102 |
873868 | 873868 | 2020-12-28 | Medina | Ohio | 39103 | 8919 | 99 |
870623 | 870623 | 2020-12-27 | Medina | Ohio | 39103 | 8829 | 98 |
867378 | 867378 | 2020-12-26 | Medina | Ohio | 39103 | 8760 | 93 |
864133 | 864133 | 2020-12-25 | Medina | Ohio | 39103 | 8622 | 93 |
860888 | 860888 | 2020-12-24 | Medina | Ohio | 39103 | 8622 | 93 |
857643 | 857643 | 2020-12-23 | Medina | Ohio | 39103 | 8514 | 93 |
854398 | 854398 | 2020-12-22 | Medina | Ohio | 39103 | 8426 | 91 |
851153 | 851153 | 2020-12-21 | Medina | Ohio | 39103 | 8296 | 91 |
847908 | 847908 | 2020-12-20 | Medina | Ohio | 39103 | 8218 | 91 |
844663 | 844663 | 2020-12-19 | Medina | Ohio | 39103 | 8104 | 89 |
841417 | 841417 | 2020-12-18 | Medina | Ohio | 39103 | 7941 | 84 |
838172 | 838172 | 2020-12-17 | Medina | Ohio | 39103 | 7800 | 81 |
834926 | 834926 | 2020-12-16 | Medina | Ohio | 39103 | 7635 | 76 |
831680 | 831680 | 2020-12-15 | Medina | Ohio | 39103 | 7533 | 75 |
828433 | 828433 | 2020-12-14 | Medina | Ohio | 39103 | 7407 | 72 |
825187 | 825187 | 2020-12-13 | Medina | Ohio | 39103 | 7297 | 72 |
821940 | 821940 | 2020-12-12 | Medina | Ohio | 39103 | 7122 | 72 |
818694 | 818694 | 2020-12-11 | Medina | Ohio | 39103 | 6983 | 70 |
815448 | 815448 | 2020-12-10 | Medina | Ohio | 39103 | 6872 | 67 |
812202 | 812202 | 2020-12-09 | Medina | Ohio | 39103 | 6725 | 66 |
808958 | 808958 | 2020-12-08 | Medina | Ohio | 39103 | 6506 | 63 |
805713 | 805713 | 2020-12-07 | Medina | Ohio | 39103 | 6165 | 63 |
802468 | 802468 | 2020-12-06 | Medina | Ohio | 39103 | 6049 | 62 |
799223 | 799223 | 2020-12-05 | Medina | Ohio | 39103 | 5952 | 62 |
795978 | 795978 | 2020-12-04 | Medina | Ohio | 39103 | 5830 | 61 |
792733 | 792733 | 2020-12-03 | Medina | Ohio | 39103 | 5658 | 58 |
789488 | 789488 | 2020-12-02 | Medina | Ohio | 39103 | 5533 | 57 |
786243 | 786243 | 2020-12-01 | Medina | Ohio | 39103 | 5433 | 57 |
782999 | 782999 | 2020-11-30 | Medina | Ohio | 39103 | 5266 | 57 |
779753 | 779753 | 2020-11-29 | Medina | Ohio | 39103 | 5180 | 57 |
776508 | 776508 | 2020-11-28 | Medina | Ohio | 39103 | 5064 | 57 |
773263 | 773263 | 2020-11-27 | Medina | Ohio | 39103 | 4965 | 57 |
770018 | 770018 | 2020-11-26 | Medina | Ohio | 39103 | 4716 | 57 |
766772 | 766772 | 2020-11-25 | Medina | Ohio | 39103 | 4716 | 57 |
763527 | 763527 | 2020-11-24 | Medina | Ohio | 39103 | 4477 | 56 |
760282 | 760282 | 2020-11-23 | Medina | Ohio | 39103 | 4286 | 54 |
757037 | 757037 | 2020-11-22 | Medina | Ohio | 39103 | 4133 | 54 |
753790 | 753790 | 2020-11-21 | Medina | Ohio | 39103 | 3941 | 54 |
750544 | 750544 | 2020-11-20 | Medina | Ohio | 39103 | 3875 | 54 |
747298 | 747298 | 2020-11-19 | Medina | Ohio | 39103 | 3786 | 53 |
744052 | 744052 | 2020-11-18 | Medina | Ohio | 39103 | 3680 | 52 |
740805 | 740805 | 2020-11-17 | Medina | Ohio | 39103 | 3594 | 51 |
737559 | 737559 | 2020-11-16 | Medina | Ohio | 39103 | 3505 | 51 |
734315 | 734315 | 2020-11-15 | Medina | Ohio | 39103 | 3395 | 51 |
731069 | 731069 | 2020-11-14 | Medina | Ohio | 39103 | 3295 | 51 |
727825 | 727825 | 2020-11-13 | Medina | Ohio | 39103 | 3201 | 49 |
724581 | 724581 | 2020-11-12 | Medina | Ohio | 39103 | 3093 | 49 |
721338 | 721338 | 2020-11-11 | Medina | Ohio | 39103 | 2956 | 46 |
718095 | 718095 | 2020-11-10 | Medina | Ohio | 39103 | 2859 | 46 |
714852 | 714852 | 2020-11-09 | Medina | Ohio | 39103 | 2762 | 46 |
711608 | 711608 | 2020-11-08 | Medina | Ohio | 39103 | 2709 | 46 |
708364 | 708364 | 2020-11-07 | Medina | Ohio | 39103 | 2618 | 46 |
705121 | 705121 | 2020-11-06 | Medina | Ohio | 39103 | 2545 | 46 |
701878 | 701878 | 2020-11-05 | Medina | Ohio | 39103 | 2449 | 46 |
698634 | 698634 | 2020-11-04 | Medina | Ohio | 39103 | 2368 | 44 |
695391 | 695391 | 2020-11-03 | Medina | Ohio | 39103 | 2318 | 44 |
692149 | 692149 | 2020-11-02 | Medina | Ohio | 39103 | 2253 | 44 |
688905 | 688905 | 2020-11-01 | Medina | Ohio | 39103 | 2197 | 44 |
685660 | 685660 | 2020-10-31 | Medina | Ohio | 39103 | 2158 | 43 |
682417 | 682417 | 2020-10-30 | Medina | Ohio | 39103 | 2126 | 43 |
679174 | 679174 | 2020-10-29 | Medina | Ohio | 39103 | 2086 | 43 |
675931 | 675931 | 2020-10-28 | Medina | Ohio | 39103 | 2036 | 43 |
672688 | 672688 | 2020-10-27 | Medina | Ohio | 39103 | 2006 | 43 |
669446 | 669446 | 2020-10-26 | Medina | Ohio | 39103 | 1972 | 42 |
666202 | 666202 | 2020-10-25 | Medina | Ohio | 39103 | 1947 | 42 |
662957 | 662957 | 2020-10-24 | Medina | Ohio | 39103 | 1924 | 42 |
659713 | 659713 | 2020-10-23 | Medina | Ohio | 39103 | 1889 | 42 |
656469 | 656469 | 2020-10-22 | Medina | Ohio | 39103 | 1856 | 42 |
653224 | 653224 | 2020-10-21 | Medina | Ohio | 39103 | 1820 | 42 |
649979 | 649979 | 2020-10-20 | Medina | Ohio | 39103 | 1802 | 42 |
646735 | 646735 | 2020-10-19 | Medina | Ohio | 39103 | 1777 | 42 |
643489 | 643489 | 2020-10-18 | Medina | Ohio | 39103 | 1755 | 42 |
640241 | 640241 | 2020-10-17 | Medina | Ohio | 39103 | 1737 | 42 |
636995 | 636995 | 2020-10-16 | Medina | Ohio | 39103 | 1714 | 42 |
633749 | 633749 | 2020-10-15 | Medina | Ohio | 39103 | 1693 | 42 |
630504 | 630504 | 2020-10-14 | Medina | Ohio | 39103 | 1676 | 42 |
627260 | 627260 | 2020-10-13 | Medina | Ohio | 39103 | 1647 | 42 |
624018 | 624018 | 2020-10-12 | Medina | Ohio | 39103 | 1629 | 42 |
620775 | 620775 | 2020-10-11 | Medina | Ohio | 39103 | 1622 | 42 |
617533 | 617533 | 2020-10-10 | Medina | Ohio | 39103 | 1616 | 42 |
614291 | 614291 | 2020-10-09 | Medina | Ohio | 39103 | 1600 | 42 |
611050 | 611050 | 2020-10-08 | Medina | Ohio | 39103 | 1584 | 41 |
607808 | 607808 | 2020-10-07 | Medina | Ohio | 39103 | 1575 | 41 |
604565 | 604565 | 2020-10-06 | Medina | Ohio | 39103 | 1570 | 41 |
601323 | 601323 | 2020-10-05 | Medina | Ohio | 39103 | 1560 | 41 |
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);