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 |
---|---|---|---|---|---|---|---|
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 |
731138 | 731138 | 2020-11-14 | Jackson | Oklahoma | 40065 | 1475 | 20 |
727894 | 727894 | 2020-11-13 | Jackson | Oklahoma | 40065 | 1402 | 20 |
724650 | 724650 | 2020-11-12 | Jackson | Oklahoma | 40065 | 1372 | 20 |
721407 | 721407 | 2020-11-11 | Jackson | Oklahoma | 40065 | 1349 | 19 |
718164 | 718164 | 2020-11-10 | Jackson | Oklahoma | 40065 | 1327 | 18 |
714921 | 714921 | 2020-11-09 | Jackson | Oklahoma | 40065 | 1313 | 18 |
711677 | 711677 | 2020-11-08 | Jackson | Oklahoma | 40065 | 1295 | 18 |
708433 | 708433 | 2020-11-07 | Jackson | Oklahoma | 40065 | 1295 | 18 |
705190 | 705190 | 2020-11-06 | Jackson | Oklahoma | 40065 | 1258 | 17 |
701947 | 701947 | 2020-11-05 | Jackson | Oklahoma | 40065 | 1239 | 15 |
698703 | 698703 | 2020-11-04 | Jackson | Oklahoma | 40065 | 1223 | 14 |
695460 | 695460 | 2020-11-03 | Jackson | Oklahoma | 40065 | 1204 | 14 |
692218 | 692218 | 2020-11-02 | Jackson | Oklahoma | 40065 | 1198 | 14 |
688974 | 688974 | 2020-11-01 | Jackson | Oklahoma | 40065 | 1189 | 14 |
685729 | 685729 | 2020-10-31 | Jackson | Oklahoma | 40065 | 1169 | 13 |
682486 | 682486 | 2020-10-30 | Jackson | Oklahoma | 40065 | 1154 | 13 |
679243 | 679243 | 2020-10-29 | Jackson | Oklahoma | 40065 | 1141 | 13 |
676000 | 676000 | 2020-10-28 | Jackson | Oklahoma | 40065 | 1132 | 13 |
672757 | 672757 | 2020-10-27 | Jackson | Oklahoma | 40065 | 1122 | 13 |
669515 | 669515 | 2020-10-26 | Jackson | Oklahoma | 40065 | 1116 | 13 |
666271 | 666271 | 2020-10-25 | Jackson | Oklahoma | 40065 | 1114 | 13 |
663026 | 663026 | 2020-10-24 | Jackson | Oklahoma | 40065 | 1112 | 13 |
659782 | 659782 | 2020-10-23 | Jackson | Oklahoma | 40065 | 1093 | 13 |
656538 | 656538 | 2020-10-22 | Jackson | Oklahoma | 40065 | 1081 | 12 |
653293 | 653293 | 2020-10-21 | Jackson | Oklahoma | 40065 | 1069 | 11 |
650048 | 650048 | 2020-10-20 | Jackson | Oklahoma | 40065 | 1041 | 11 |
646804 | 646804 | 2020-10-19 | Jackson | Oklahoma | 40065 | 1019 | 11 |
643558 | 643558 | 2020-10-18 | Jackson | Oklahoma | 40065 | 1018 | 11 |
640310 | 640310 | 2020-10-17 | Jackson | Oklahoma | 40065 | 1016 | 11 |
637064 | 637064 | 2020-10-16 | Jackson | Oklahoma | 40065 | 991 | 11 |
633818 | 633818 | 2020-10-15 | Jackson | Oklahoma | 40065 | 980 | 11 |
630573 | 630573 | 2020-10-14 | Jackson | Oklahoma | 40065 | 976 | 11 |
627329 | 627329 | 2020-10-13 | Jackson | Oklahoma | 40065 | 961 | 11 |
624087 | 624087 | 2020-10-12 | Jackson | Oklahoma | 40065 | 943 | 10 |
620844 | 620844 | 2020-10-11 | Jackson | Oklahoma | 40065 | 943 | 10 |
617602 | 617602 | 2020-10-10 | Jackson | Oklahoma | 40065 | 937 | 10 |
614360 | 614360 | 2020-10-09 | Jackson | Oklahoma | 40065 | 913 | 10 |
611119 | 611119 | 2020-10-08 | Jackson | Oklahoma | 40065 | 893 | 10 |
607877 | 607877 | 2020-10-07 | Jackson | Oklahoma | 40065 | 870 | 10 |
604634 | 604634 | 2020-10-06 | Jackson | Oklahoma | 40065 | 861 | 10 |
601392 | 601392 | 2020-10-05 | Jackson | Oklahoma | 40065 | 845 | 10 |
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);