ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Pontotoc" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055715 | 1055715 | 2021-02-22 | Pontotoc | Oklahoma | 40123 | 4860 | 45 |
1052469 | 1052469 | 2021-02-21 | Pontotoc | Oklahoma | 40123 | 4855 | 45 |
1049222 | 1049222 | 2021-02-20 | Pontotoc | Oklahoma | 40123 | 4846 | 45 |
1045975 | 1045975 | 2021-02-19 | Pontotoc | Oklahoma | 40123 | 4844 | 45 |
1042730 | 1042730 | 2021-02-18 | Pontotoc | Oklahoma | 40123 | 4836 | 45 |
1039485 | 1039485 | 2021-02-17 | Pontotoc | Oklahoma | 40123 | 4834 | 44 |
1036240 | 1036240 | 2021-02-16 | Pontotoc | Oklahoma | 40123 | 4818 | 44 |
1032995 | 1032995 | 2021-02-15 | Pontotoc | Oklahoma | 40123 | 4812 | 44 |
1029749 | 1029749 | 2021-02-14 | Pontotoc | Oklahoma | 40123 | 4806 | 44 |
1026502 | 1026502 | 2021-02-13 | Pontotoc | Oklahoma | 40123 | 4784 | 44 |
1023257 | 1023257 | 2021-02-12 | Pontotoc | Oklahoma | 40123 | 4771 | 42 |
1020012 | 1020012 | 2021-02-11 | Pontotoc | Oklahoma | 40123 | 4737 | 42 |
1016767 | 1016767 | 2021-02-10 | Pontotoc | Oklahoma | 40123 | 4699 | 42 |
1013522 | 1013522 | 2021-02-09 | Pontotoc | Oklahoma | 40123 | 4630 | 42 |
1010277 | 1010277 | 2021-02-08 | Pontotoc | Oklahoma | 40123 | 4626 | 42 |
1007031 | 1007031 | 2021-02-07 | Pontotoc | Oklahoma | 40123 | 4614 | 42 |
1003785 | 1003785 | 2021-02-06 | Pontotoc | Oklahoma | 40123 | 4560 | 40 |
1000539 | 1000539 | 2021-02-05 | Pontotoc | Oklahoma | 40123 | 4537 | 39 |
997293 | 997293 | 2021-02-04 | Pontotoc | Oklahoma | 40123 | 4509 | 38 |
994047 | 994047 | 2021-02-03 | Pontotoc | Oklahoma | 40123 | 4489 | 38 |
990801 | 990801 | 2021-02-02 | Pontotoc | Oklahoma | 40123 | 4470 | 38 |
987555 | 987555 | 2021-02-01 | Pontotoc | Oklahoma | 40123 | 4448 | 38 |
984308 | 984308 | 2021-01-31 | Pontotoc | Oklahoma | 40123 | 4438 | 38 |
981061 | 981061 | 2021-01-30 | Pontotoc | Oklahoma | 40123 | 4406 | 38 |
977815 | 977815 | 2021-01-29 | Pontotoc | Oklahoma | 40123 | 4387 | 36 |
974570 | 974570 | 2021-01-28 | Pontotoc | Oklahoma | 40123 | 4337 | 36 |
971325 | 971325 | 2021-01-27 | Pontotoc | Oklahoma | 40123 | 4317 | 36 |
968080 | 968080 | 2021-01-26 | Pontotoc | Oklahoma | 40123 | 4273 | 36 |
964836 | 964836 | 2021-01-25 | Pontotoc | Oklahoma | 40123 | 4220 | 36 |
961591 | 961591 | 2021-01-24 | Pontotoc | Oklahoma | 40123 | 4196 | 36 |
958346 | 958346 | 2021-01-23 | Pontotoc | Oklahoma | 40123 | 4161 | 36 |
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 |
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);