ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 40123 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955100 | 955100 | 2021-01-22 | Pontotoc | Oklahoma | 40123 | 4076 | 36 |
951855 | 951855 | 2021-01-21 | Pontotoc | Oklahoma | 40123 | 4049 | 36 |
948610 | 948610 | 2021-01-20 | Pontotoc | Oklahoma | 40123 | 4027 | 32 |
945364 | 945364 | 2021-01-19 | Pontotoc | Oklahoma | 40123 | 3999 | 31 |
942117 | 942117 | 2021-01-18 | Pontotoc | Oklahoma | 40123 | 3975 | 31 |
938872 | 938872 | 2021-01-17 | Pontotoc | Oklahoma | 40123 | 3943 | 31 |
935627 | 935627 | 2021-01-16 | Pontotoc | Oklahoma | 40123 | 3922 | 31 |
932382 | 932382 | 2021-01-15 | Pontotoc | Oklahoma | 40123 | 3849 | 31 |
929137 | 929137 | 2021-01-14 | Pontotoc | Oklahoma | 40123 | 3815 | 31 |
925892 | 925892 | 2021-01-13 | Pontotoc | Oklahoma | 40123 | 3783 | 28 |
922646 | 922646 | 2021-01-12 | Pontotoc | Oklahoma | 40123 | 3743 | 28 |
919401 | 919401 | 2021-01-11 | Pontotoc | Oklahoma | 40123 | 3677 | 27 |
916156 | 916156 | 2021-01-10 | Pontotoc | Oklahoma | 40123 | 3638 | 27 |
912911 | 912911 | 2021-01-09 | Pontotoc | Oklahoma | 40123 | 3596 | 27 |
909666 | 909666 | 2021-01-08 | Pontotoc | Oklahoma | 40123 | 3533 | 26 |
906421 | 906421 | 2021-01-07 | Pontotoc | Oklahoma | 40123 | 3517 | 26 |
903175 | 903175 | 2021-01-06 | Pontotoc | Oklahoma | 40123 | 3418 | 25 |
899930 | 899930 | 2021-01-05 | Pontotoc | Oklahoma | 40123 | 3353 | 25 |
896685 | 896685 | 2021-01-04 | Pontotoc | Oklahoma | 40123 | 3312 | 25 |
893439 | 893439 | 2021-01-03 | Pontotoc | Oklahoma | 40123 | 3261 | 25 |
890193 | 890193 | 2021-01-02 | Pontotoc | Oklahoma | 40123 | 3186 | 25 |
886946 | 886946 | 2021-01-01 | Pontotoc | Oklahoma | 40123 | 3135 | 25 |
883701 | 883701 | 2020-12-31 | Pontotoc | Oklahoma | 40123 | 3135 | 25 |
880456 | 880456 | 2020-12-30 | Pontotoc | Oklahoma | 40123 | 3045 | 24 |
877211 | 877211 | 2020-12-29 | Pontotoc | Oklahoma | 40123 | 3009 | 24 |
873966 | 873966 | 2020-12-28 | Pontotoc | Oklahoma | 40123 | 2997 | 23 |
870721 | 870721 | 2020-12-27 | Pontotoc | Oklahoma | 40123 | 2945 | 22 |
867476 | 867476 | 2020-12-26 | Pontotoc | Oklahoma | 40123 | 2927 | 22 |
864231 | 864231 | 2020-12-25 | Pontotoc | Oklahoma | 40123 | 2886 | 19 |
860986 | 860986 | 2020-12-24 | Pontotoc | Oklahoma | 40123 | 2886 | 19 |
857741 | 857741 | 2020-12-23 | Pontotoc | Oklahoma | 40123 | 2811 | 17 |
854496 | 854496 | 2020-12-22 | Pontotoc | Oklahoma | 40123 | 2733 | 17 |
851251 | 851251 | 2020-12-21 | Pontotoc | Oklahoma | 40123 | 2703 | 17 |
848006 | 848006 | 2020-12-20 | Pontotoc | Oklahoma | 40123 | 2682 | 17 |
844761 | 844761 | 2020-12-19 | Pontotoc | Oklahoma | 40123 | 2629 | 16 |
841515 | 841515 | 2020-12-18 | Pontotoc | Oklahoma | 40123 | 2566 | 16 |
838270 | 838270 | 2020-12-17 | Pontotoc | Oklahoma | 40123 | 2542 | 16 |
835024 | 835024 | 2020-12-16 | Pontotoc | Oklahoma | 40123 | 2533 | 16 |
831778 | 831778 | 2020-12-15 | Pontotoc | Oklahoma | 40123 | 2452 | 16 |
828531 | 828531 | 2020-12-14 | Pontotoc | Oklahoma | 40123 | 2436 | 16 |
825285 | 825285 | 2020-12-13 | Pontotoc | Oklahoma | 40123 | 2421 | 16 |
822038 | 822038 | 2020-12-12 | Pontotoc | Oklahoma | 40123 | 2365 | 16 |
818792 | 818792 | 2020-12-11 | Pontotoc | Oklahoma | 40123 | 2330 | 16 |
815546 | 815546 | 2020-12-10 | Pontotoc | Oklahoma | 40123 | 2299 | 16 |
812300 | 812300 | 2020-12-09 | Pontotoc | Oklahoma | 40123 | 2273 | 16 |
809056 | 809056 | 2020-12-08 | Pontotoc | Oklahoma | 40123 | 2245 | 15 |
805811 | 805811 | 2020-12-07 | Pontotoc | Oklahoma | 40123 | 2234 | 15 |
802566 | 802566 | 2020-12-06 | Pontotoc | Oklahoma | 40123 | 2221 | 15 |
799321 | 799321 | 2020-12-05 | Pontotoc | Oklahoma | 40123 | 2156 | 15 |
796076 | 796076 | 2020-12-04 | Pontotoc | Oklahoma | 40123 | 2105 | 15 |
792831 | 792831 | 2020-12-03 | Pontotoc | Oklahoma | 40123 | 2075 | 14 |
789586 | 789586 | 2020-12-02 | Pontotoc | Oklahoma | 40123 | 2065 | 13 |
786341 | 786341 | 2020-12-01 | Pontotoc | Oklahoma | 40123 | 2030 | 11 |
783097 | 783097 | 2020-11-30 | Pontotoc | Oklahoma | 40123 | 2001 | 11 |
779851 | 779851 | 2020-11-29 | Pontotoc | Oklahoma | 40123 | 1977 | 11 |
776606 | 776606 | 2020-11-28 | Pontotoc | Oklahoma | 40123 | 1956 | 11 |
773361 | 773361 | 2020-11-27 | Pontotoc | Oklahoma | 40123 | 1912 | 10 |
770116 | 770116 | 2020-11-26 | Pontotoc | Oklahoma | 40123 | 1852 | 10 |
766870 | 766870 | 2020-11-25 | Pontotoc | Oklahoma | 40123 | 1852 | 10 |
763625 | 763625 | 2020-11-24 | Pontotoc | Oklahoma | 40123 | 1782 | 10 |
760380 | 760380 | 2020-11-23 | Pontotoc | Oklahoma | 40123 | 1756 | 10 |
757135 | 757135 | 2020-11-22 | Pontotoc | Oklahoma | 40123 | 1726 | 10 |
753888 | 753888 | 2020-11-21 | Pontotoc | Oklahoma | 40123 | 1644 | 10 |
750642 | 750642 | 2020-11-20 | Pontotoc | Oklahoma | 40123 | 1579 | 10 |
747396 | 747396 | 2020-11-19 | Pontotoc | Oklahoma | 40123 | 1545 | 9 |
744150 | 744150 | 2020-11-18 | Pontotoc | Oklahoma | 40123 | 1495 | 8 |
740903 | 740903 | 2020-11-17 | Pontotoc | Oklahoma | 40123 | 1441 | 8 |
737657 | 737657 | 2020-11-16 | Pontotoc | Oklahoma | 40123 | 1435 | 8 |
734413 | 734413 | 2020-11-15 | Pontotoc | Oklahoma | 40123 | 1411 | 8 |
731167 | 731167 | 2020-11-14 | Pontotoc | Oklahoma | 40123 | 1372 | 8 |
727923 | 727923 | 2020-11-13 | Pontotoc | Oklahoma | 40123 | 1315 | 8 |
724679 | 724679 | 2020-11-12 | Pontotoc | Oklahoma | 40123 | 1275 | 8 |
721436 | 721436 | 2020-11-11 | Pontotoc | Oklahoma | 40123 | 1237 | 6 |
718193 | 718193 | 2020-11-10 | Pontotoc | Oklahoma | 40123 | 1179 | 6 |
714950 | 714950 | 2020-11-09 | Pontotoc | Oklahoma | 40123 | 1154 | 6 |
711706 | 711706 | 2020-11-08 | Pontotoc | Oklahoma | 40123 | 1123 | 5 |
708462 | 708462 | 2020-11-07 | Pontotoc | Oklahoma | 40123 | 1123 | 5 |
705219 | 705219 | 2020-11-06 | Pontotoc | Oklahoma | 40123 | 1026 | 5 |
701976 | 701976 | 2020-11-05 | Pontotoc | Oklahoma | 40123 | 993 | 5 |
698732 | 698732 | 2020-11-04 | Pontotoc | Oklahoma | 40123 | 970 | 5 |
695489 | 695489 | 2020-11-03 | Pontotoc | Oklahoma | 40123 | 936 | 5 |
692247 | 692247 | 2020-11-02 | Pontotoc | Oklahoma | 40123 | 883 | 5 |
689003 | 689003 | 2020-11-01 | Pontotoc | Oklahoma | 40123 | 877 | 5 |
685758 | 685758 | 2020-10-31 | Pontotoc | Oklahoma | 40123 | 869 | 5 |
682515 | 682515 | 2020-10-30 | Pontotoc | Oklahoma | 40123 | 848 | 4 |
679272 | 679272 | 2020-10-29 | Pontotoc | Oklahoma | 40123 | 833 | 4 |
676029 | 676029 | 2020-10-28 | Pontotoc | Oklahoma | 40123 | 814 | 4 |
672786 | 672786 | 2020-10-27 | Pontotoc | Oklahoma | 40123 | 794 | 4 |
669544 | 669544 | 2020-10-26 | Pontotoc | Oklahoma | 40123 | 784 | 4 |
666300 | 666300 | 2020-10-25 | Pontotoc | Oklahoma | 40123 | 775 | 4 |
663055 | 663055 | 2020-10-24 | Pontotoc | Oklahoma | 40123 | 754 | 4 |
659811 | 659811 | 2020-10-23 | Pontotoc | Oklahoma | 40123 | 742 | 4 |
656567 | 656567 | 2020-10-22 | Pontotoc | Oklahoma | 40123 | 722 | 4 |
653322 | 653322 | 2020-10-21 | Pontotoc | Oklahoma | 40123 | 674 | 4 |
650077 | 650077 | 2020-10-20 | Pontotoc | Oklahoma | 40123 | 663 | 4 |
646833 | 646833 | 2020-10-19 | Pontotoc | Oklahoma | 40123 | 645 | 4 |
643587 | 643587 | 2020-10-18 | Pontotoc | Oklahoma | 40123 | 626 | 4 |
640339 | 640339 | 2020-10-17 | Pontotoc | Oklahoma | 40123 | 622 | 4 |
637093 | 637093 | 2020-10-16 | Pontotoc | Oklahoma | 40123 | 610 | 4 |
633847 | 633847 | 2020-10-15 | Pontotoc | Oklahoma | 40123 | 591 | 4 |
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);