ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 39115 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081587 | 1081587 | 2021-03-02 | Morgan | Ohio | 39115 | 1009 | 19 |
1078341 | 1078341 | 2021-03-01 | Morgan | Ohio | 39115 | 1008 | 34 |
1075096 | 1075096 | 2021-02-28 | Morgan | Ohio | 39115 | 1005 | 34 |
1071850 | 1071850 | 2021-02-27 | Morgan | Ohio | 39115 | 1005 | 34 |
1068604 | 1068604 | 2021-02-26 | Morgan | Ohio | 39115 | 1004 | 34 |
1065359 | 1065359 | 2021-02-25 | Morgan | Ohio | 39115 | 999 | 34 |
1062115 | 1062115 | 2021-02-24 | Morgan | Ohio | 39115 | 997 | 34 |
1058869 | 1058869 | 2021-02-23 | Morgan | Ohio | 39115 | 988 | 34 |
1055623 | 1055623 | 2021-02-22 | Morgan | Ohio | 39115 | 980 | 34 |
1052377 | 1052377 | 2021-02-21 | Morgan | Ohio | 39115 | 977 | 34 |
1049130 | 1049130 | 2021-02-20 | Morgan | Ohio | 39115 | 974 | 34 |
1045883 | 1045883 | 2021-02-19 | Morgan | Ohio | 39115 | 966 | 34 |
1042638 | 1042638 | 2021-02-18 | Morgan | Ohio | 39115 | 963 | 34 |
1039393 | 1039393 | 2021-02-17 | Morgan | Ohio | 39115 | 952 | 34 |
1036148 | 1036148 | 2021-02-16 | Morgan | Ohio | 39115 | 943 | 34 |
1032903 | 1032903 | 2021-02-15 | Morgan | Ohio | 39115 | 946 | 33 |
1029657 | 1029657 | 2021-02-14 | Morgan | Ohio | 39115 | 940 | 33 |
1026410 | 1026410 | 2021-02-13 | Morgan | Ohio | 39115 | 939 | 33 |
1023165 | 1023165 | 2021-02-12 | Morgan | Ohio | 39115 | 934 | 32 |
1019920 | 1019920 | 2021-02-11 | Morgan | Ohio | 39115 | 929 | 32 |
1016675 | 1016675 | 2021-02-10 | Morgan | Ohio | 39115 | 926 | 31 |
1013430 | 1013430 | 2021-02-09 | Morgan | Ohio | 39115 | 924 | 31 |
1010185 | 1010185 | 2021-02-08 | Morgan | Ohio | 39115 | 923 | 31 |
1006939 | 1006939 | 2021-02-07 | Morgan | Ohio | 39115 | 922 | 31 |
1003693 | 1003693 | 2021-02-06 | Morgan | Ohio | 39115 | 922 | 31 |
1000447 | 1000447 | 2021-02-05 | Morgan | Ohio | 39115 | 920 | 31 |
997201 | 997201 | 2021-02-04 | Morgan | Ohio | 39115 | 918 | 31 |
993955 | 993955 | 2021-02-03 | Morgan | Ohio | 39115 | 912 | 31 |
990709 | 990709 | 2021-02-02 | Morgan | Ohio | 39115 | 906 | 31 |
987463 | 987463 | 2021-02-01 | Morgan | Ohio | 39115 | 898 | 31 |
984216 | 984216 | 2021-01-31 | Morgan | Ohio | 39115 | 890 | 31 |
980969 | 980969 | 2021-01-30 | Morgan | Ohio | 39115 | 882 | 31 |
977723 | 977723 | 2021-01-29 | Morgan | Ohio | 39115 | 881 | 31 |
974478 | 974478 | 2021-01-28 | Morgan | Ohio | 39115 | 865 | 31 |
971233 | 971233 | 2021-01-27 | Morgan | Ohio | 39115 | 856 | 31 |
967988 | 967988 | 2021-01-26 | Morgan | Ohio | 39115 | 845 | 31 |
964744 | 964744 | 2021-01-25 | Morgan | Ohio | 39115 | 839 | 31 |
961499 | 961499 | 2021-01-24 | Morgan | Ohio | 39115 | 834 | 30 |
958254 | 958254 | 2021-01-23 | Morgan | Ohio | 39115 | 831 | 30 |
955008 | 955008 | 2021-01-22 | Morgan | Ohio | 39115 | 826 | 29 |
951763 | 951763 | 2021-01-21 | Morgan | Ohio | 39115 | 822 | 29 |
948518 | 948518 | 2021-01-20 | Morgan | Ohio | 39115 | 804 | 29 |
945272 | 945272 | 2021-01-19 | Morgan | Ohio | 39115 | 797 | 28 |
942025 | 942025 | 2021-01-18 | Morgan | Ohio | 39115 | 796 | 28 |
938780 | 938780 | 2021-01-17 | Morgan | Ohio | 39115 | 791 | 28 |
935535 | 935535 | 2021-01-16 | Morgan | Ohio | 39115 | 782 | 27 |
932290 | 932290 | 2021-01-15 | Morgan | Ohio | 39115 | 770 | 26 |
929045 | 929045 | 2021-01-14 | Morgan | Ohio | 39115 | 758 | 26 |
925800 | 925800 | 2021-01-13 | Morgan | Ohio | 39115 | 742 | 26 |
922554 | 922554 | 2021-01-12 | Morgan | Ohio | 39115 | 730 | 26 |
919309 | 919309 | 2021-01-11 | Morgan | Ohio | 39115 | 726 | 26 |
916064 | 916064 | 2021-01-10 | Morgan | Ohio | 39115 | 721 | 26 |
912819 | 912819 | 2021-01-09 | Morgan | Ohio | 39115 | 713 | 26 |
909574 | 909574 | 2021-01-08 | Morgan | Ohio | 39115 | 708 | 26 |
906329 | 906329 | 2021-01-07 | Morgan | Ohio | 39115 | 693 | 26 |
903083 | 903083 | 2021-01-06 | Morgan | Ohio | 39115 | 690 | 26 |
899838 | 899838 | 2021-01-05 | Morgan | Ohio | 39115 | 676 | 26 |
896593 | 896593 | 2021-01-04 | Morgan | Ohio | 39115 | 669 | 26 |
893347 | 893347 | 2021-01-03 | Morgan | Ohio | 39115 | 661 | 26 |
890101 | 890101 | 2021-01-02 | Morgan | Ohio | 39115 | 655 | 26 |
886854 | 886854 | 2021-01-01 | Morgan | Ohio | 39115 | 644 | 26 |
883609 | 883609 | 2020-12-31 | Morgan | Ohio | 39115 | 644 | 26 |
880364 | 880364 | 2020-12-30 | Morgan | Ohio | 39115 | 636 | 26 |
877119 | 877119 | 2020-12-29 | Morgan | Ohio | 39115 | 626 | 25 |
873874 | 873874 | 2020-12-28 | Morgan | Ohio | 39115 | 622 | 25 |
870629 | 870629 | 2020-12-27 | Morgan | Ohio | 39115 | 620 | 25 |
867384 | 867384 | 2020-12-26 | Morgan | Ohio | 39115 | 619 | 25 |
864139 | 864139 | 2020-12-25 | Morgan | Ohio | 39115 | 614 | 25 |
860894 | 860894 | 2020-12-24 | Morgan | Ohio | 39115 | 614 | 25 |
857649 | 857649 | 2020-12-23 | Morgan | Ohio | 39115 | 604 | 25 |
854404 | 854404 | 2020-12-22 | Morgan | Ohio | 39115 | 596 | 25 |
851159 | 851159 | 2020-12-21 | Morgan | Ohio | 39115 | 592 | 25 |
847914 | 847914 | 2020-12-20 | Morgan | Ohio | 39115 | 588 | 24 |
844669 | 844669 | 2020-12-19 | Morgan | Ohio | 39115 | 580 | 24 |
841423 | 841423 | 2020-12-18 | Morgan | Ohio | 39115 | 573 | 24 |
838178 | 838178 | 2020-12-17 | Morgan | Ohio | 39115 | 569 | 24 |
834932 | 834932 | 2020-12-16 | Morgan | Ohio | 39115 | 548 | 24 |
831686 | 831686 | 2020-12-15 | Morgan | Ohio | 39115 | 540 | 24 |
828439 | 828439 | 2020-12-14 | Morgan | Ohio | 39115 | 531 | 18 |
825193 | 825193 | 2020-12-13 | Morgan | Ohio | 39115 | 528 | 18 |
821946 | 821946 | 2020-12-12 | Morgan | Ohio | 39115 | 517 | 18 |
818700 | 818700 | 2020-12-11 | Morgan | Ohio | 39115 | 495 | 16 |
815454 | 815454 | 2020-12-10 | Morgan | Ohio | 39115 | 481 | 16 |
812208 | 812208 | 2020-12-09 | Morgan | Ohio | 39115 | 460 | 16 |
808964 | 808964 | 2020-12-08 | Morgan | Ohio | 39115 | 445 | 16 |
805719 | 805719 | 2020-12-07 | Morgan | Ohio | 39115 | 432 | 16 |
802474 | 802474 | 2020-12-06 | Morgan | Ohio | 39115 | 418 | 15 |
799229 | 799229 | 2020-12-05 | Morgan | Ohio | 39115 | 409 | 15 |
795984 | 795984 | 2020-12-04 | Morgan | Ohio | 39115 | 391 | 15 |
792739 | 792739 | 2020-12-03 | Morgan | Ohio | 39115 | 370 | 14 |
789494 | 789494 | 2020-12-02 | Morgan | Ohio | 39115 | 345 | 9 |
786249 | 786249 | 2020-12-01 | Morgan | Ohio | 39115 | 319 | 5 |
783005 | 783005 | 2020-11-30 | Morgan | Ohio | 39115 | 311 | 5 |
779759 | 779759 | 2020-11-29 | Morgan | Ohio | 39115 | 306 | 5 |
776514 | 776514 | 2020-11-28 | Morgan | Ohio | 39115 | 299 | 5 |
773269 | 773269 | 2020-11-27 | Morgan | Ohio | 39115 | 292 | 5 |
770024 | 770024 | 2020-11-26 | Morgan | Ohio | 39115 | 268 | 5 |
766778 | 766778 | 2020-11-25 | Morgan | Ohio | 39115 | 268 | 5 |
763533 | 763533 | 2020-11-24 | Morgan | Ohio | 39115 | 257 | 5 |
760288 | 760288 | 2020-11-23 | Morgan | Ohio | 39115 | 239 | 5 |
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);