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 |
---|---|---|---|---|---|---|---|
1195319 | 1195319 | 2021-04-06 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1192071 | 1192071 | 2021-04-05 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1188822 | 1188822 | 2021-04-04 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1185575 | 1185575 | 2021-04-03 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1182328 | 1182328 | 2021-04-02 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1179081 | 1179081 | 2021-04-01 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1175834 | 1175834 | 2021-03-31 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1172587 | 1172587 | 2021-03-30 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1169340 | 1169340 | 2021-03-29 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1166092 | 1166092 | 2021-03-28 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1162844 | 1162844 | 2021-03-27 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1159595 | 1159595 | 2021-03-26 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1156348 | 1156348 | 2021-03-25 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1153101 | 1153101 | 2021-03-24 | Pontotoc | Oklahoma | 40123 | 5019 | 49 |
1149854 | 1149854 | 2021-03-23 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1146607 | 1146607 | 2021-03-22 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1143360 | 1143360 | 2021-03-21 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1140113 | 1140113 | 2021-03-20 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1136867 | 1136867 | 2021-03-19 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1133621 | 1133621 | 2021-03-18 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1130373 | 1130373 | 2021-03-17 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1127126 | 1127126 | 2021-03-16 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1123880 | 1123880 | 2021-03-15 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1120634 | 1120634 | 2021-03-14 | Pontotoc | Oklahoma | 40123 | 4998 | 49 |
1117387 | 1117387 | 2021-03-13 | Pontotoc | Oklahoma | 40123 | 4990 | 49 |
1114140 | 1114140 | 2021-03-12 | Pontotoc | Oklahoma | 40123 | 4990 | 49 |
1110894 | 1110894 | 2021-03-11 | Pontotoc | Oklahoma | 40123 | 4987 | 49 |
1107648 | 1107648 | 2021-03-10 | Pontotoc | Oklahoma | 40123 | 4987 | 49 |
1104402 | 1104402 | 2021-03-09 | Pontotoc | Oklahoma | 40123 | 4978 | 49 |
1101156 | 1101156 | 2021-03-08 | Pontotoc | Oklahoma | 40123 | 4974 | 48 |
1097910 | 1097910 | 2021-03-07 | Pontotoc | Oklahoma | 40123 | 4973 | 48 |
1094662 | 1094662 | 2021-03-06 | Pontotoc | Oklahoma | 40123 | 4969 | 48 |
1091416 | 1091416 | 2021-03-05 | Pontotoc | Oklahoma | 40123 | 4957 | 48 |
1088170 | 1088170 | 2021-03-04 | Pontotoc | Oklahoma | 40123 | 4955 | 48 |
1084925 | 1084925 | 2021-03-03 | Pontotoc | Oklahoma | 40123 | 4950 | 48 |
1081679 | 1081679 | 2021-03-02 | Pontotoc | Oklahoma | 40123 | 4944 | 48 |
1078433 | 1078433 | 2021-03-01 | Pontotoc | Oklahoma | 40123 | 4935 | 48 |
1075188 | 1075188 | 2021-02-28 | Pontotoc | Oklahoma | 40123 | 4930 | 47 |
1071942 | 1071942 | 2021-02-27 | Pontotoc | Oklahoma | 40123 | 4924 | 47 |
1068696 | 1068696 | 2021-02-26 | Pontotoc | Oklahoma | 40123 | 4912 | 45 |
1065451 | 1065451 | 2021-02-25 | Pontotoc | Oklahoma | 40123 | 4909 | 45 |
1062207 | 1062207 | 2021-02-24 | Pontotoc | Oklahoma | 40123 | 4875 | 45 |
1058961 | 1058961 | 2021-02-23 | Pontotoc | Oklahoma | 40123 | 4863 | 45 |
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 |
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);