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 |
---|---|---|---|---|---|---|---|
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 |
870692 | 870692 | 2020-12-27 | Jackson | Oklahoma | 40065 | 2307 | 36 |
867447 | 867447 | 2020-12-26 | Jackson | Oklahoma | 40065 | 2300 | 36 |
864202 | 864202 | 2020-12-25 | Jackson | Oklahoma | 40065 | 2279 | 36 |
860957 | 860957 | 2020-12-24 | Jackson | Oklahoma | 40065 | 2279 | 36 |
857712 | 857712 | 2020-12-23 | Jackson | Oklahoma | 40065 | 2265 | 36 |
854467 | 854467 | 2020-12-22 | Jackson | Oklahoma | 40065 | 2240 | 36 |
851222 | 851222 | 2020-12-21 | Jackson | Oklahoma | 40065 | 2237 | 35 |
847977 | 847977 | 2020-12-20 | Jackson | Oklahoma | 40065 | 2230 | 35 |
844732 | 844732 | 2020-12-19 | Jackson | Oklahoma | 40065 | 2211 | 35 |
841486 | 841486 | 2020-12-18 | Jackson | Oklahoma | 40065 | 2204 | 35 |
838241 | 838241 | 2020-12-17 | Jackson | Oklahoma | 40065 | 2184 | 35 |
834995 | 834995 | 2020-12-16 | Jackson | Oklahoma | 40065 | 2177 | 35 |
831749 | 831749 | 2020-12-15 | Jackson | Oklahoma | 40065 | 2169 | 35 |
828502 | 828502 | 2020-12-14 | Jackson | Oklahoma | 40065 | 2159 | 35 |
825256 | 825256 | 2020-12-13 | Jackson | Oklahoma | 40065 | 2157 | 35 |
822009 | 822009 | 2020-12-12 | Jackson | Oklahoma | 40065 | 2093 | 35 |
818763 | 818763 | 2020-12-11 | Jackson | Oklahoma | 40065 | 2072 | 35 |
815517 | 815517 | 2020-12-10 | Jackson | Oklahoma | 40065 | 2061 | 35 |
812271 | 812271 | 2020-12-09 | Jackson | Oklahoma | 40065 | 2051 | 35 |
809027 | 809027 | 2020-12-08 | Jackson | Oklahoma | 40065 | 2038 | 35 |
805782 | 805782 | 2020-12-07 | Jackson | Oklahoma | 40065 | 2040 | 35 |
802537 | 802537 | 2020-12-06 | Jackson | Oklahoma | 40065 | 2034 | 35 |
799292 | 799292 | 2020-12-05 | Jackson | Oklahoma | 40065 | 2002 | 35 |
796047 | 796047 | 2020-12-04 | Jackson | Oklahoma | 40065 | 1966 | 35 |
792802 | 792802 | 2020-12-03 | Jackson | Oklahoma | 40065 | 1946 | 34 |
789557 | 789557 | 2020-12-02 | Jackson | Oklahoma | 40065 | 1938 | 32 |
786312 | 786312 | 2020-12-01 | Jackson | Oklahoma | 40065 | 1918 | 32 |
783068 | 783068 | 2020-11-30 | Jackson | Oklahoma | 40065 | 1911 | 31 |
779822 | 779822 | 2020-11-29 | Jackson | Oklahoma | 40065 | 1863 | 31 |
776577 | 776577 | 2020-11-28 | Jackson | Oklahoma | 40065 | 1856 | 30 |
773332 | 773332 | 2020-11-27 | Jackson | Oklahoma | 40065 | 1814 | 30 |
770087 | 770087 | 2020-11-26 | Jackson | Oklahoma | 40065 | 1782 | 30 |
766841 | 766841 | 2020-11-25 | Jackson | Oklahoma | 40065 | 1782 | 30 |
763596 | 763596 | 2020-11-24 | Jackson | Oklahoma | 40065 | 1736 | 30 |
760351 | 760351 | 2020-11-23 | Jackson | Oklahoma | 40065 | 1730 | 27 |
757106 | 757106 | 2020-11-22 | Jackson | Oklahoma | 40065 | 1688 | 27 |
753859 | 753859 | 2020-11-21 | Jackson | Oklahoma | 40065 | 1638 | 26 |
750613 | 750613 | 2020-11-20 | Jackson | Oklahoma | 40065 | 1612 | 25 |
747367 | 747367 | 2020-11-19 | Jackson | Oklahoma | 40065 | 1603 | 24 |
744121 | 744121 | 2020-11-18 | Jackson | Oklahoma | 40065 | 1585 | 24 |
740874 | 740874 | 2020-11-17 | Jackson | Oklahoma | 40065 | 1551 | 22 |
737628 | 737628 | 2020-11-16 | Jackson | Oklahoma | 40065 | 1534 | 22 |
734384 | 734384 | 2020-11-15 | Jackson | Oklahoma | 40065 | 1499 | 22 |
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);