ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39109 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922551 | 922551 | 2021-01-12 | Miami | Ohio | 39109 | 8553 | 73 |
919306 | 919306 | 2021-01-11 | Miami | Ohio | 39109 | 8454 | 73 |
916061 | 916061 | 2021-01-10 | Miami | Ohio | 39109 | 8392 | 73 |
912816 | 912816 | 2021-01-09 | Miami | Ohio | 39109 | 8323 | 73 |
909571 | 909571 | 2021-01-08 | Miami | Ohio | 39109 | 8229 | 73 |
906326 | 906326 | 2021-01-07 | Miami | Ohio | 39109 | 8116 | 73 |
903080 | 903080 | 2021-01-06 | Miami | Ohio | 39109 | 8016 | 73 |
899835 | 899835 | 2021-01-05 | Miami | Ohio | 39109 | 7960 | 73 |
896590 | 896590 | 2021-01-04 | Miami | Ohio | 39109 | 7872 | 73 |
893344 | 893344 | 2021-01-03 | Miami | Ohio | 39109 | 7841 | 73 |
890098 | 890098 | 2021-01-02 | Miami | Ohio | 39109 | 7773 | 73 |
886851 | 886851 | 2021-01-01 | Miami | Ohio | 39109 | 7580 | 73 |
883606 | 883606 | 2020-12-31 | Miami | Ohio | 39109 | 7580 | 73 |
880361 | 880361 | 2020-12-30 | Miami | Ohio | 39109 | 7511 | 73 |
877116 | 877116 | 2020-12-29 | Miami | Ohio | 39109 | 7446 | 73 |
873871 | 873871 | 2020-12-28 | Miami | Ohio | 39109 | 7371 | 73 |
870626 | 870626 | 2020-12-27 | Miami | Ohio | 39109 | 7308 | 72 |
867381 | 867381 | 2020-12-26 | Miami | Ohio | 39109 | 7256 | 72 |
864136 | 864136 | 2020-12-25 | Miami | Ohio | 39109 | 7111 | 72 |
860891 | 860891 | 2020-12-24 | Miami | Ohio | 39109 | 7111 | 72 |
857646 | 857646 | 2020-12-23 | Miami | Ohio | 39109 | 7025 | 72 |
854401 | 854401 | 2020-12-22 | Miami | Ohio | 39109 | 6941 | 72 |
851156 | 851156 | 2020-12-21 | Miami | Ohio | 39109 | 6847 | 70 |
847911 | 847911 | 2020-12-20 | Miami | Ohio | 39109 | 6787 | 70 |
844666 | 844666 | 2020-12-19 | Miami | Ohio | 39109 | 6703 | 70 |
841420 | 841420 | 2020-12-18 | Miami | Ohio | 39109 | 6615 | 70 |
838175 | 838175 | 2020-12-17 | Miami | Ohio | 39109 | 6514 | 69 |
834929 | 834929 | 2020-12-16 | Miami | Ohio | 39109 | 6401 | 69 |
831683 | 831683 | 2020-12-15 | Miami | Ohio | 39109 | 6370 | 69 |
828436 | 828436 | 2020-12-14 | Miami | Ohio | 39109 | 6256 | 69 |
825190 | 825190 | 2020-12-13 | Miami | Ohio | 39109 | 6203 | 69 |
821943 | 821943 | 2020-12-12 | Miami | Ohio | 39109 | 6122 | 69 |
818697 | 818697 | 2020-12-11 | Miami | Ohio | 39109 | 6032 | 69 |
815451 | 815451 | 2020-12-10 | Miami | Ohio | 39109 | 5915 | 69 |
812205 | 812205 | 2020-12-09 | Miami | Ohio | 39109 | 5830 | 69 |
808961 | 808961 | 2020-12-08 | Miami | Ohio | 39109 | 5722 | 69 |
805716 | 805716 | 2020-12-07 | Miami | Ohio | 39109 | 5524 | 69 |
802471 | 802471 | 2020-12-06 | Miami | Ohio | 39109 | 5444 | 69 |
799226 | 799226 | 2020-12-05 | Miami | Ohio | 39109 | 5358 | 69 |
795981 | 795981 | 2020-12-04 | Miami | Ohio | 39109 | 5258 | 69 |
792736 | 792736 | 2020-12-03 | Miami | Ohio | 39109 | 5131 | 68 |
789491 | 789491 | 2020-12-02 | Miami | Ohio | 39109 | 5022 | 68 |
786246 | 786246 | 2020-12-01 | Miami | Ohio | 39109 | 4926 | 68 |
783002 | 783002 | 2020-11-30 | Miami | Ohio | 39109 | 4851 | 68 |
779756 | 779756 | 2020-11-29 | Miami | Ohio | 39109 | 4756 | 68 |
776511 | 776511 | 2020-11-28 | Miami | Ohio | 39109 | 4655 | 68 |
773266 | 773266 | 2020-11-27 | Miami | Ohio | 39109 | 4562 | 68 |
770021 | 770021 | 2020-11-26 | Miami | Ohio | 39109 | 4375 | 68 |
766775 | 766775 | 2020-11-25 | Miami | Ohio | 39109 | 4375 | 68 |
763530 | 763530 | 2020-11-24 | Miami | Ohio | 39109 | 4258 | 67 |
760285 | 760285 | 2020-11-23 | Miami | Ohio | 39109 | 4164 | 65 |
757040 | 757040 | 2020-11-22 | Miami | Ohio | 39109 | 3985 | 65 |
753793 | 753793 | 2020-11-21 | Miami | Ohio | 39109 | 3875 | 65 |
750547 | 750547 | 2020-11-20 | Miami | Ohio | 39109 | 3813 | 65 |
747301 | 747301 | 2020-11-19 | Miami | Ohio | 39109 | 3693 | 65 |
744055 | 744055 | 2020-11-18 | Miami | Ohio | 39109 | 3588 | 65 |
740808 | 740808 | 2020-11-17 | Miami | Ohio | 39109 | 3528 | 65 |
737562 | 737562 | 2020-11-16 | Miami | Ohio | 39109 | 3453 | 65 |
734318 | 734318 | 2020-11-15 | Miami | Ohio | 39109 | 3343 | 65 |
731072 | 731072 | 2020-11-14 | Miami | Ohio | 39109 | 3266 | 65 |
727828 | 727828 | 2020-11-13 | Miami | Ohio | 39109 | 3198 | 65 |
724584 | 724584 | 2020-11-12 | Miami | Ohio | 39109 | 3094 | 65 |
721341 | 721341 | 2020-11-11 | Miami | Ohio | 39109 | 2979 | 64 |
718098 | 718098 | 2020-11-10 | Miami | Ohio | 39109 | 2908 | 62 |
714855 | 714855 | 2020-11-09 | Miami | Ohio | 39109 | 2833 | 61 |
711611 | 711611 | 2020-11-08 | Miami | Ohio | 39109 | 2769 | 61 |
708367 | 708367 | 2020-11-07 | Miami | Ohio | 39109 | 2717 | 61 |
705124 | 705124 | 2020-11-06 | Miami | Ohio | 39109 | 2625 | 61 |
701881 | 701881 | 2020-11-05 | Miami | Ohio | 39109 | 2570 | 61 |
698637 | 698637 | 2020-11-04 | Miami | Ohio | 39109 | 2505 | 61 |
695394 | 695394 | 2020-11-03 | Miami | Ohio | 39109 | 2467 | 61 |
692152 | 692152 | 2020-11-02 | Miami | Ohio | 39109 | 2423 | 61 |
688908 | 688908 | 2020-11-01 | Miami | Ohio | 39109 | 2381 | 61 |
685663 | 685663 | 2020-10-31 | Miami | Ohio | 39109 | 2335 | 61 |
682420 | 682420 | 2020-10-30 | Miami | Ohio | 39109 | 2299 | 61 |
679177 | 679177 | 2020-10-29 | Miami | Ohio | 39109 | 2239 | 59 |
675934 | 675934 | 2020-10-28 | Miami | Ohio | 39109 | 2196 | 58 |
672691 | 672691 | 2020-10-27 | Miami | Ohio | 39109 | 2152 | 58 |
669449 | 669449 | 2020-10-26 | Miami | Ohio | 39109 | 2132 | 58 |
666205 | 666205 | 2020-10-25 | Miami | Ohio | 39109 | 2116 | 58 |
662960 | 662960 | 2020-10-24 | Miami | Ohio | 39109 | 2072 | 58 |
659716 | 659716 | 2020-10-23 | Miami | Ohio | 39109 | 2028 | 58 |
656472 | 656472 | 2020-10-22 | Miami | Ohio | 39109 | 1999 | 58 |
653227 | 653227 | 2020-10-21 | Miami | Ohio | 39109 | 1976 | 58 |
649982 | 649982 | 2020-10-20 | Miami | Ohio | 39109 | 1956 | 56 |
646738 | 646738 | 2020-10-19 | Miami | Ohio | 39109 | 1927 | 56 |
643492 | 643492 | 2020-10-18 | Miami | Ohio | 39109 | 1910 | 56 |
640244 | 640244 | 2020-10-17 | Miami | Ohio | 39109 | 1890 | 56 |
636998 | 636998 | 2020-10-16 | Miami | Ohio | 39109 | 1879 | 56 |
633752 | 633752 | 2020-10-15 | Miami | Ohio | 39109 | 1852 | 56 |
630507 | 630507 | 2020-10-14 | Miami | Ohio | 39109 | 1819 | 56 |
627263 | 627263 | 2020-10-13 | Miami | Ohio | 39109 | 1792 | 56 |
624021 | 624021 | 2020-10-12 | Miami | Ohio | 39109 | 1774 | 56 |
620778 | 620778 | 2020-10-11 | Miami | Ohio | 39109 | 1746 | 56 |
617536 | 617536 | 2020-10-10 | Miami | Ohio | 39109 | 1723 | 56 |
614294 | 614294 | 2020-10-09 | Miami | Ohio | 39109 | 1716 | 56 |
611053 | 611053 | 2020-10-08 | Miami | Ohio | 39109 | 1684 | 56 |
607811 | 607811 | 2020-10-07 | Miami | Ohio | 39109 | 1643 | 56 |
604568 | 604568 | 2020-10-06 | Miami | Ohio | 39109 | 1622 | 55 |
601326 | 601326 | 2020-10-05 | Miami | Ohio | 39109 | 1605 | 55 |
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);