ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Jackson" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081569 | 1081569 | 2021-03-02 | Jackson | Ohio | 39079 | 2900 | 45 |
1078323 | 1078323 | 2021-03-01 | Jackson | Ohio | 39079 | 2893 | 56 |
1075078 | 1075078 | 2021-02-28 | Jackson | Ohio | 39079 | 2892 | 56 |
1071832 | 1071832 | 2021-02-27 | Jackson | Ohio | 39079 | 2885 | 56 |
1068586 | 1068586 | 2021-02-26 | Jackson | Ohio | 39079 | 2885 | 56 |
1065341 | 1065341 | 2021-02-25 | Jackson | Ohio | 39079 | 2879 | 56 |
1062097 | 1062097 | 2021-02-24 | Jackson | Ohio | 39079 | 2877 | 56 |
1058851 | 1058851 | 2021-02-23 | Jackson | Ohio | 39079 | 2870 | 56 |
1055605 | 1055605 | 2021-02-22 | Jackson | Ohio | 39079 | 2867 | 53 |
1052359 | 1052359 | 2021-02-21 | Jackson | Ohio | 39079 | 2866 | 53 |
1049112 | 1049112 | 2021-02-20 | Jackson | Ohio | 39079 | 2861 | 53 |
1045865 | 1045865 | 2021-02-19 | Jackson | Ohio | 39079 | 2857 | 53 |
1042620 | 1042620 | 2021-02-18 | Jackson | Ohio | 39079 | 2856 | 54 |
1039375 | 1039375 | 2021-02-17 | Jackson | Ohio | 39079 | 2848 | 54 |
1036130 | 1036130 | 2021-02-16 | Jackson | Ohio | 39079 | 2843 | 53 |
1032885 | 1032885 | 2021-02-15 | Jackson | Ohio | 39079 | 2840 | 53 |
1029639 | 1029639 | 2021-02-14 | Jackson | Ohio | 39079 | 2834 | 53 |
1026392 | 1026392 | 2021-02-13 | Jackson | Ohio | 39079 | 2833 | 53 |
1023147 | 1023147 | 2021-02-12 | Jackson | Ohio | 39079 | 2823 | 51 |
1019902 | 1019902 | 2021-02-11 | Jackson | Ohio | 39079 | 2819 | 50 |
1016657 | 1016657 | 2021-02-10 | Jackson | Ohio | 39079 | 2811 | 49 |
1013412 | 1013412 | 2021-02-09 | Jackson | Ohio | 39079 | 2800 | 48 |
1010167 | 1010167 | 2021-02-08 | Jackson | Ohio | 39079 | 2793 | 47 |
1006921 | 1006921 | 2021-02-07 | Jackson | Ohio | 39079 | 2790 | 46 |
1003675 | 1003675 | 2021-02-06 | Jackson | Ohio | 39079 | 2783 | 46 |
1000429 | 1000429 | 2021-02-05 | Jackson | Ohio | 39079 | 2777 | 46 |
997183 | 997183 | 2021-02-04 | Jackson | Ohio | 39079 | 2765 | 46 |
993937 | 993937 | 2021-02-03 | Jackson | Ohio | 39079 | 2742 | 47 |
990691 | 990691 | 2021-02-02 | Jackson | Ohio | 39079 | 2731 | 47 |
987445 | 987445 | 2021-02-01 | Jackson | Ohio | 39079 | 2721 | 45 |
984198 | 984198 | 2021-01-31 | Jackson | Ohio | 39079 | 2719 | 45 |
980951 | 980951 | 2021-01-30 | Jackson | Ohio | 39079 | 2713 | 45 |
977705 | 977705 | 2021-01-29 | Jackson | Ohio | 39079 | 2701 | 45 |
974460 | 974460 | 2021-01-28 | Jackson | Ohio | 39079 | 2690 | 45 |
971215 | 971215 | 2021-01-27 | Jackson | Ohio | 39079 | 2676 | 45 |
967970 | 967970 | 2021-01-26 | Jackson | Ohio | 39079 | 2661 | 45 |
964726 | 964726 | 2021-01-25 | Jackson | Ohio | 39079 | 2658 | 45 |
961481 | 961481 | 2021-01-24 | Jackson | Ohio | 39079 | 2653 | 45 |
958236 | 958236 | 2021-01-23 | Jackson | Ohio | 39079 | 2638 | 45 |
954990 | 954990 | 2021-01-22 | Jackson | Ohio | 39079 | 2624 | 45 |
951745 | 951745 | 2021-01-21 | Jackson | Ohio | 39079 | 2613 | 45 |
948500 | 948500 | 2021-01-20 | Jackson | Ohio | 39079 | 2605 | 44 |
945254 | 945254 | 2021-01-19 | Jackson | Ohio | 39079 | 2590 | 43 |
942007 | 942007 | 2021-01-18 | Jackson | Ohio | 39079 | 2583 | 43 |
938762 | 938762 | 2021-01-17 | Jackson | Ohio | 39079 | 2569 | 43 |
935517 | 935517 | 2021-01-16 | Jackson | Ohio | 39079 | 2552 | 43 |
932272 | 932272 | 2021-01-15 | Jackson | Ohio | 39079 | 2526 | 43 |
929027 | 929027 | 2021-01-14 | Jackson | Ohio | 39079 | 2507 | 43 |
925782 | 925782 | 2021-01-13 | Jackson | Ohio | 39079 | 2495 | 43 |
922536 | 922536 | 2021-01-12 | Jackson | Ohio | 39079 | 2467 | 43 |
919291 | 919291 | 2021-01-11 | Jackson | Ohio | 39079 | 2434 | 37 |
916046 | 916046 | 2021-01-10 | Jackson | Ohio | 39079 | 2411 | 37 |
912801 | 912801 | 2021-01-09 | Jackson | Ohio | 39079 | 2385 | 37 |
909556 | 909556 | 2021-01-08 | Jackson | Ohio | 39079 | 2353 | 37 |
906311 | 906311 | 2021-01-07 | Jackson | Ohio | 39079 | 2322 | 35 |
903065 | 903065 | 2021-01-06 | Jackson | Ohio | 39079 | 2284 | 35 |
899820 | 899820 | 2021-01-05 | Jackson | Ohio | 39079 | 2249 | 34 |
896575 | 896575 | 2021-01-04 | Jackson | Ohio | 39079 | 2235 | 34 |
893329 | 893329 | 2021-01-03 | Jackson | Ohio | 39079 | 2202 | 34 |
890083 | 890083 | 2021-01-02 | Jackson | Ohio | 39079 | 2183 | 34 |
886836 | 886836 | 2021-01-01 | Jackson | Ohio | 39079 | 2138 | 32 |
883591 | 883591 | 2020-12-31 | Jackson | Ohio | 39079 | 2138 | 32 |
880346 | 880346 | 2020-12-30 | Jackson | Ohio | 39079 | 2111 | 30 |
877101 | 877101 | 2020-12-29 | Jackson | Ohio | 39079 | 2065 | 30 |
873856 | 873856 | 2020-12-28 | Jackson | Ohio | 39079 | 2060 | 30 |
870611 | 870611 | 2020-12-27 | Jackson | Ohio | 39079 | 2052 | 30 |
867366 | 867366 | 2020-12-26 | Jackson | Ohio | 39079 | 2029 | 30 |
864121 | 864121 | 2020-12-25 | Jackson | Ohio | 39079 | 1997 | 30 |
860876 | 860876 | 2020-12-24 | Jackson | Ohio | 39079 | 1997 | 30 |
857631 | 857631 | 2020-12-23 | Jackson | Ohio | 39079 | 1974 | 28 |
854386 | 854386 | 2020-12-22 | Jackson | Ohio | 39079 | 1939 | 28 |
851141 | 851141 | 2020-12-21 | Jackson | Ohio | 39079 | 1922 | 20 |
847896 | 847896 | 2020-12-20 | Jackson | Ohio | 39079 | 1907 | 20 |
844651 | 844651 | 2020-12-19 | Jackson | Ohio | 39079 | 1865 | 19 |
841405 | 841405 | 2020-12-18 | Jackson | Ohio | 39079 | 1830 | 17 |
838160 | 838160 | 2020-12-17 | Jackson | Ohio | 39079 | 1803 | 17 |
834914 | 834914 | 2020-12-16 | Jackson | Ohio | 39079 | 1755 | 15 |
831668 | 831668 | 2020-12-15 | Jackson | Ohio | 39079 | 1722 | 13 |
828421 | 828421 | 2020-12-14 | Jackson | Ohio | 39079 | 1697 | 13 |
825175 | 825175 | 2020-12-13 | Jackson | Ohio | 39079 | 1687 | 13 |
821928 | 821928 | 2020-12-12 | Jackson | Ohio | 39079 | 1658 | 13 |
818682 | 818682 | 2020-12-11 | Jackson | Ohio | 39079 | 1617 | 13 |
815436 | 815436 | 2020-12-10 | Jackson | Ohio | 39079 | 1602 | 13 |
812190 | 812190 | 2020-12-09 | Jackson | Ohio | 39079 | 1563 | 13 |
808946 | 808946 | 2020-12-08 | Jackson | Ohio | 39079 | 1501 | 13 |
805701 | 805701 | 2020-12-07 | Jackson | Ohio | 39079 | 1455 | 13 |
802456 | 802456 | 2020-12-06 | Jackson | Ohio | 39079 | 1412 | 13 |
799211 | 799211 | 2020-12-05 | Jackson | Ohio | 39079 | 1365 | 13 |
795966 | 795966 | 2020-12-04 | Jackson | Ohio | 39079 | 1314 | 13 |
792721 | 792721 | 2020-12-03 | Jackson | Ohio | 39079 | 1259 | 13 |
789476 | 789476 | 2020-12-02 | Jackson | Ohio | 39079 | 1190 | 13 |
786231 | 786231 | 2020-12-01 | Jackson | Ohio | 39079 | 1152 | 13 |
782987 | 782987 | 2020-11-30 | Jackson | Ohio | 39079 | 1106 | 13 |
779741 | 779741 | 2020-11-29 | Jackson | Ohio | 39079 | 1074 | 12 |
776496 | 776496 | 2020-11-28 | Jackson | Ohio | 39079 | 1034 | 12 |
773251 | 773251 | 2020-11-27 | Jackson | Ohio | 39079 | 1020 | 12 |
770006 | 770006 | 2020-11-26 | Jackson | Ohio | 39079 | 962 | 12 |
766760 | 766760 | 2020-11-25 | Jackson | Ohio | 39079 | 962 | 12 |
763515 | 763515 | 2020-11-24 | Jackson | Ohio | 39079 | 931 | 12 |
760270 | 760270 | 2020-11-23 | Jackson | Ohio | 39079 | 903 | 12 |
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);