ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Jackson" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195290 | 1195290 | 2021-04-06 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1192042 | 1192042 | 2021-04-05 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1188793 | 1188793 | 2021-04-04 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1185546 | 1185546 | 2021-04-03 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1182299 | 1182299 | 2021-04-02 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1179052 | 1179052 | 2021-04-01 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1175805 | 1175805 | 2021-03-31 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1172558 | 1172558 | 2021-03-30 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1169311 | 1169311 | 2021-03-29 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1166063 | 1166063 | 2021-03-28 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1162815 | 1162815 | 2021-03-27 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1159566 | 1159566 | 2021-03-26 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1156319 | 1156319 | 2021-03-25 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1153072 | 1153072 | 2021-03-24 | Jackson | Oklahoma | 40065 | 2999 | 47 |
1149825 | 1149825 | 2021-03-23 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1146578 | 1146578 | 2021-03-22 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1143331 | 1143331 | 2021-03-21 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1140084 | 1140084 | 2021-03-20 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1136838 | 1136838 | 2021-03-19 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1133592 | 1133592 | 2021-03-18 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1130344 | 1130344 | 2021-03-17 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1127097 | 1127097 | 2021-03-16 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1123851 | 1123851 | 2021-03-15 | Jackson | Oklahoma | 40065 | 2973 | 45 |
1120605 | 1120605 | 2021-03-14 | Jackson | Oklahoma | 40065 | 2972 | 45 |
1117358 | 1117358 | 2021-03-13 | Jackson | Oklahoma | 40065 | 2968 | 45 |
1114111 | 1114111 | 2021-03-12 | Jackson | Oklahoma | 40065 | 2962 | 45 |
1110865 | 1110865 | 2021-03-11 | Jackson | Oklahoma | 40065 | 2960 | 45 |
1107619 | 1107619 | 2021-03-10 | Jackson | Oklahoma | 40065 | 2959 | 45 |
1104373 | 1104373 | 2021-03-09 | Jackson | Oklahoma | 40065 | 2957 | 45 |
1101127 | 1101127 | 2021-03-08 | Jackson | Oklahoma | 40065 | 2957 | 44 |
1097881 | 1097881 | 2021-03-07 | Jackson | Oklahoma | 40065 | 2957 | 44 |
1094633 | 1094633 | 2021-03-06 | Jackson | Oklahoma | 40065 | 2955 | 44 |
1091387 | 1091387 | 2021-03-05 | Jackson | Oklahoma | 40065 | 2951 | 44 |
1088141 | 1088141 | 2021-03-04 | Jackson | Oklahoma | 40065 | 2936 | 44 |
1084896 | 1084896 | 2021-03-03 | Jackson | Oklahoma | 40065 | 2925 | 44 |
1081650 | 1081650 | 2021-03-02 | Jackson | Oklahoma | 40065 | 2923 | 44 |
1078404 | 1078404 | 2021-03-01 | Jackson | Oklahoma | 40065 | 2918 | 44 |
1075159 | 1075159 | 2021-02-28 | Jackson | Oklahoma | 40065 | 2915 | 44 |
1071913 | 1071913 | 2021-02-27 | Jackson | Oklahoma | 40065 | 2899 | 44 |
1068667 | 1068667 | 2021-02-26 | Jackson | Oklahoma | 40065 | 2894 | 44 |
1065422 | 1065422 | 2021-02-25 | Jackson | Oklahoma | 40065 | 2885 | 44 |
1062178 | 1062178 | 2021-02-24 | Jackson | Oklahoma | 40065 | 2871 | 44 |
1058932 | 1058932 | 2021-02-23 | Jackson | Oklahoma | 40065 | 2868 | 44 |
1055686 | 1055686 | 2021-02-22 | Jackson | Oklahoma | 40065 | 2868 | 44 |
1052440 | 1052440 | 2021-02-21 | Jackson | Oklahoma | 40065 | 2868 | 44 |
1049193 | 1049193 | 2021-02-20 | Jackson | Oklahoma | 40065 | 2868 | 44 |
1045946 | 1045946 | 2021-02-19 | Jackson | Oklahoma | 40065 | 2862 | 44 |
1042701 | 1042701 | 2021-02-18 | Jackson | Oklahoma | 40065 | 2853 | 44 |
1039456 | 1039456 | 2021-02-17 | Jackson | Oklahoma | 40065 | 2847 | 44 |
1036211 | 1036211 | 2021-02-16 | Jackson | Oklahoma | 40065 | 2839 | 44 |
1032966 | 1032966 | 2021-02-15 | Jackson | Oklahoma | 40065 | 2838 | 44 |
1029720 | 1029720 | 2021-02-14 | Jackson | Oklahoma | 40065 | 2833 | 44 |
1026473 | 1026473 | 2021-02-13 | Jackson | Oklahoma | 40065 | 2826 | 43 |
1023228 | 1023228 | 2021-02-12 | Jackson | Oklahoma | 40065 | 2821 | 43 |
1019983 | 1019983 | 2021-02-11 | Jackson | Oklahoma | 40065 | 2810 | 43 |
1016738 | 1016738 | 2021-02-10 | Jackson | Oklahoma | 40065 | 2800 | 43 |
1013493 | 1013493 | 2021-02-09 | Jackson | Oklahoma | 40065 | 2787 | 43 |
1010248 | 1010248 | 2021-02-08 | Jackson | Oklahoma | 40065 | 2784 | 42 |
1007002 | 1007002 | 2021-02-07 | Jackson | Oklahoma | 40065 | 2783 | 42 |
1003756 | 1003756 | 2021-02-06 | Jackson | Oklahoma | 40065 | 2774 | 41 |
1000510 | 1000510 | 2021-02-05 | Jackson | Oklahoma | 40065 | 2759 | 41 |
997264 | 997264 | 2021-02-04 | Jackson | Oklahoma | 40065 | 2748 | 41 |
994018 | 994018 | 2021-02-03 | Jackson | Oklahoma | 40065 | 2719 | 41 |
990772 | 990772 | 2021-02-02 | Jackson | Oklahoma | 40065 | 2708 | 41 |
987526 | 987526 | 2021-02-01 | Jackson | Oklahoma | 40065 | 2708 | 41 |
984279 | 984279 | 2021-01-31 | Jackson | Oklahoma | 40065 | 2708 | 41 |
981032 | 981032 | 2021-01-30 | Jackson | Oklahoma | 40065 | 2706 | 41 |
977786 | 977786 | 2021-01-29 | Jackson | Oklahoma | 40065 | 2700 | 41 |
974541 | 974541 | 2021-01-28 | Jackson | Oklahoma | 40065 | 2695 | 40 |
971296 | 971296 | 2021-01-27 | Jackson | Oklahoma | 40065 | 2688 | 40 |
968051 | 968051 | 2021-01-26 | Jackson | Oklahoma | 40065 | 2673 | 40 |
964807 | 964807 | 2021-01-25 | Jackson | Oklahoma | 40065 | 2667 | 40 |
961562 | 961562 | 2021-01-24 | Jackson | Oklahoma | 40065 | 2664 | 40 |
958317 | 958317 | 2021-01-23 | Jackson | Oklahoma | 40065 | 2643 | 40 |
955071 | 955071 | 2021-01-22 | Jackson | Oklahoma | 40065 | 2624 | 40 |
951826 | 951826 | 2021-01-21 | Jackson | Oklahoma | 40065 | 2622 | 40 |
948581 | 948581 | 2021-01-20 | Jackson | Oklahoma | 40065 | 2612 | 40 |
945335 | 945335 | 2021-01-19 | Jackson | Oklahoma | 40065 | 2609 | 40 |
942088 | 942088 | 2021-01-18 | Jackson | Oklahoma | 40065 | 2607 | 39 |
938843 | 938843 | 2021-01-17 | Jackson | Oklahoma | 40065 | 2598 | 39 |
935598 | 935598 | 2021-01-16 | Jackson | Oklahoma | 40065 | 2575 | 39 |
932353 | 932353 | 2021-01-15 | Jackson | Oklahoma | 40065 | 2559 | 38 |
929108 | 929108 | 2021-01-14 | Jackson | Oklahoma | 40065 | 2553 | 38 |
925863 | 925863 | 2021-01-13 | Jackson | Oklahoma | 40065 | 2548 | 38 |
922617 | 922617 | 2021-01-12 | Jackson | Oklahoma | 40065 | 2529 | 38 |
919372 | 919372 | 2021-01-11 | Jackson | Oklahoma | 40065 | 2523 | 38 |
916127 | 916127 | 2021-01-10 | Jackson | Oklahoma | 40065 | 2492 | 38 |
912882 | 912882 | 2021-01-09 | Jackson | Oklahoma | 40065 | 2441 | 38 |
909637 | 909637 | 2021-01-08 | Jackson | Oklahoma | 40065 | 2419 | 38 |
906392 | 906392 | 2021-01-07 | Jackson | Oklahoma | 40065 | 2403 | 38 |
903146 | 903146 | 2021-01-06 | Jackson | Oklahoma | 40065 | 2397 | 38 |
899901 | 899901 | 2021-01-05 | Jackson | Oklahoma | 40065 | 2385 | 37 |
896656 | 896656 | 2021-01-04 | Jackson | Oklahoma | 40065 | 2379 | 37 |
893410 | 893410 | 2021-01-03 | Jackson | Oklahoma | 40065 | 2379 | 37 |
890164 | 890164 | 2021-01-02 | Jackson | Oklahoma | 40065 | 2355 | 37 |
886917 | 886917 | 2021-01-01 | Jackson | Oklahoma | 40065 | 2336 | 37 |
883672 | 883672 | 2020-12-31 | Jackson | Oklahoma | 40065 | 2336 | 37 |
880427 | 880427 | 2020-12-30 | Jackson | Oklahoma | 40065 | 2323 | 36 |
877182 | 877182 | 2020-12-29 | Jackson | Oklahoma | 40065 | 2315 | 36 |
873937 | 873937 | 2020-12-28 | Jackson | Oklahoma | 40065 | 2315 | 36 |
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);