ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40039 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195277 | 1195277 | 2021-04-06 | Custer | Oklahoma | 40039 | 4058 | 73 |
1192029 | 1192029 | 2021-04-05 | Custer | Oklahoma | 40039 | 4058 | 73 |
1188780 | 1188780 | 2021-04-04 | Custer | Oklahoma | 40039 | 4058 | 73 |
1185533 | 1185533 | 2021-04-03 | Custer | Oklahoma | 40039 | 4058 | 73 |
1182286 | 1182286 | 2021-04-02 | Custer | Oklahoma | 40039 | 4058 | 73 |
1179039 | 1179039 | 2021-04-01 | Custer | Oklahoma | 40039 | 4058 | 73 |
1175792 | 1175792 | 2021-03-31 | Custer | Oklahoma | 40039 | 4058 | 73 |
1172545 | 1172545 | 2021-03-30 | Custer | Oklahoma | 40039 | 4053 | 73 |
1169298 | 1169298 | 2021-03-29 | Custer | Oklahoma | 40039 | 4053 | 73 |
1166050 | 1166050 | 2021-03-28 | Custer | Oklahoma | 40039 | 4053 | 73 |
1162802 | 1162802 | 2021-03-27 | Custer | Oklahoma | 40039 | 4053 | 73 |
1159553 | 1159553 | 2021-03-26 | Custer | Oklahoma | 40039 | 4053 | 73 |
1156306 | 1156306 | 2021-03-25 | Custer | Oklahoma | 40039 | 4053 | 73 |
1153059 | 1153059 | 2021-03-24 | Custer | Oklahoma | 40039 | 4053 | 73 |
1149812 | 1149812 | 2021-03-23 | Custer | Oklahoma | 40039 | 4044 | 72 |
1146565 | 1146565 | 2021-03-22 | Custer | Oklahoma | 40039 | 4044 | 72 |
1143318 | 1143318 | 2021-03-21 | Custer | Oklahoma | 40039 | 4044 | 72 |
1140071 | 1140071 | 2021-03-20 | Custer | Oklahoma | 40039 | 4044 | 72 |
1136825 | 1136825 | 2021-03-19 | Custer | Oklahoma | 40039 | 4044 | 72 |
1133579 | 1133579 | 2021-03-18 | Custer | Oklahoma | 40039 | 4044 | 72 |
1130331 | 1130331 | 2021-03-17 | Custer | Oklahoma | 40039 | 4044 | 72 |
1127084 | 1127084 | 2021-03-16 | Custer | Oklahoma | 40039 | 4044 | 72 |
1123838 | 1123838 | 2021-03-15 | Custer | Oklahoma | 40039 | 4044 | 72 |
1120592 | 1120592 | 2021-03-14 | Custer | Oklahoma | 40039 | 4041 | 72 |
1117345 | 1117345 | 2021-03-13 | Custer | Oklahoma | 40039 | 4040 | 72 |
1114098 | 1114098 | 2021-03-12 | Custer | Oklahoma | 40039 | 4038 | 72 |
1110852 | 1110852 | 2021-03-11 | Custer | Oklahoma | 40039 | 4037 | 72 |
1107606 | 1107606 | 2021-03-10 | Custer | Oklahoma | 40039 | 4035 | 72 |
1104360 | 1104360 | 2021-03-09 | Custer | Oklahoma | 40039 | 4033 | 72 |
1101114 | 1101114 | 2021-03-08 | Custer | Oklahoma | 40039 | 4031 | 72 |
1097868 | 1097868 | 2021-03-07 | Custer | Oklahoma | 40039 | 4031 | 72 |
1094620 | 1094620 | 2021-03-06 | Custer | Oklahoma | 40039 | 4030 | 72 |
1091374 | 1091374 | 2021-03-05 | Custer | Oklahoma | 40039 | 4026 | 72 |
1088128 | 1088128 | 2021-03-04 | Custer | Oklahoma | 40039 | 4008 | 72 |
1084883 | 1084883 | 2021-03-03 | Custer | Oklahoma | 40039 | 4008 | 72 |
1081637 | 1081637 | 2021-03-02 | Custer | Oklahoma | 40039 | 4007 | 72 |
1078391 | 1078391 | 2021-03-01 | Custer | Oklahoma | 40039 | 4003 | 70 |
1075146 | 1075146 | 2021-02-28 | Custer | Oklahoma | 40039 | 4000 | 70 |
1071900 | 1071900 | 2021-02-27 | Custer | Oklahoma | 40039 | 3988 | 70 |
1068654 | 1068654 | 2021-02-26 | Custer | Oklahoma | 40039 | 3987 | 67 |
1065409 | 1065409 | 2021-02-25 | Custer | Oklahoma | 40039 | 3970 | 67 |
1062165 | 1062165 | 2021-02-24 | Custer | Oklahoma | 40039 | 3962 | 66 |
1058919 | 1058919 | 2021-02-23 | Custer | Oklahoma | 40039 | 3955 | 65 |
1055673 | 1055673 | 2021-02-22 | Custer | Oklahoma | 40039 | 3954 | 65 |
1052427 | 1052427 | 2021-02-21 | Custer | Oklahoma | 40039 | 3954 | 65 |
1049180 | 1049180 | 2021-02-20 | Custer | Oklahoma | 40039 | 3951 | 65 |
1045933 | 1045933 | 2021-02-19 | Custer | Oklahoma | 40039 | 3948 | 65 |
1042688 | 1042688 | 2021-02-18 | Custer | Oklahoma | 40039 | 3941 | 65 |
1039443 | 1039443 | 2021-02-17 | Custer | Oklahoma | 40039 | 3937 | 65 |
1036198 | 1036198 | 2021-02-16 | Custer | Oklahoma | 40039 | 3931 | 64 |
1032953 | 1032953 | 2021-02-15 | Custer | Oklahoma | 40039 | 3930 | 64 |
1029707 | 1029707 | 2021-02-14 | Custer | Oklahoma | 40039 | 3928 | 63 |
1026460 | 1026460 | 2021-02-13 | Custer | Oklahoma | 40039 | 3920 | 63 |
1023215 | 1023215 | 2021-02-12 | Custer | Oklahoma | 40039 | 3909 | 63 |
1019970 | 1019970 | 2021-02-11 | Custer | Oklahoma | 40039 | 3905 | 63 |
1016725 | 1016725 | 2021-02-10 | Custer | Oklahoma | 40039 | 3894 | 62 |
1013480 | 1013480 | 2021-02-09 | Custer | Oklahoma | 40039 | 3882 | 62 |
1010235 | 1010235 | 2021-02-08 | Custer | Oklahoma | 40039 | 3876 | 62 |
1006989 | 1006989 | 2021-02-07 | Custer | Oklahoma | 40039 | 3872 | 62 |
1003743 | 1003743 | 2021-02-06 | Custer | Oklahoma | 40039 | 3862 | 61 |
1000497 | 1000497 | 2021-02-05 | Custer | Oklahoma | 40039 | 3852 | 60 |
997251 | 997251 | 2021-02-04 | Custer | Oklahoma | 40039 | 3845 | 60 |
994005 | 994005 | 2021-02-03 | Custer | Oklahoma | 40039 | 3804 | 59 |
990759 | 990759 | 2021-02-02 | Custer | Oklahoma | 40039 | 3800 | 59 |
987513 | 987513 | 2021-02-01 | Custer | Oklahoma | 40039 | 3790 | 59 |
984266 | 984266 | 2021-01-31 | Custer | Oklahoma | 40039 | 3788 | 59 |
981019 | 981019 | 2021-01-30 | Custer | Oklahoma | 40039 | 3734 | 57 |
977773 | 977773 | 2021-01-29 | Custer | Oklahoma | 40039 | 3725 | 56 |
974528 | 974528 | 2021-01-28 | Custer | Oklahoma | 40039 | 3706 | 56 |
971283 | 971283 | 2021-01-27 | Custer | Oklahoma | 40039 | 3687 | 56 |
968038 | 968038 | 2021-01-26 | Custer | Oklahoma | 40039 | 3646 | 54 |
964794 | 964794 | 2021-01-25 | Custer | Oklahoma | 40039 | 3639 | 53 |
961549 | 961549 | 2021-01-24 | Custer | Oklahoma | 40039 | 3635 | 53 |
958304 | 958304 | 2021-01-23 | Custer | Oklahoma | 40039 | 3623 | 50 |
955058 | 955058 | 2021-01-22 | Custer | Oklahoma | 40039 | 3596 | 48 |
951813 | 951813 | 2021-01-21 | Custer | Oklahoma | 40039 | 3582 | 44 |
948568 | 948568 | 2021-01-20 | Custer | Oklahoma | 40039 | 3571 | 40 |
945322 | 945322 | 2021-01-19 | Custer | Oklahoma | 40039 | 3563 | 39 |
942075 | 942075 | 2021-01-18 | Custer | Oklahoma | 40039 | 3553 | 39 |
938830 | 938830 | 2021-01-17 | Custer | Oklahoma | 40039 | 3544 | 39 |
935585 | 935585 | 2021-01-16 | Custer | Oklahoma | 40039 | 3527 | 39 |
932340 | 932340 | 2021-01-15 | Custer | Oklahoma | 40039 | 3520 | 39 |
929095 | 929095 | 2021-01-14 | Custer | Oklahoma | 40039 | 3497 | 39 |
925850 | 925850 | 2021-01-13 | Custer | Oklahoma | 40039 | 3485 | 38 |
922604 | 922604 | 2021-01-12 | Custer | Oklahoma | 40039 | 3407 | 38 |
919359 | 919359 | 2021-01-11 | Custer | Oklahoma | 40039 | 3402 | 38 |
916114 | 916114 | 2021-01-10 | Custer | Oklahoma | 40039 | 3368 | 38 |
912869 | 912869 | 2021-01-09 | Custer | Oklahoma | 40039 | 3279 | 38 |
909624 | 909624 | 2021-01-08 | Custer | Oklahoma | 40039 | 3252 | 38 |
906379 | 906379 | 2021-01-07 | Custer | Oklahoma | 40039 | 3226 | 37 |
903133 | 903133 | 2021-01-06 | Custer | Oklahoma | 40039 | 3206 | 35 |
899888 | 899888 | 2021-01-05 | Custer | Oklahoma | 40039 | 3186 | 34 |
896643 | 896643 | 2021-01-04 | Custer | Oklahoma | 40039 | 3180 | 32 |
893397 | 893397 | 2021-01-03 | Custer | Oklahoma | 40039 | 3156 | 31 |
890151 | 890151 | 2021-01-02 | Custer | Oklahoma | 40039 | 3029 | 31 |
886904 | 886904 | 2021-01-01 | Custer | Oklahoma | 40039 | 2981 | 31 |
883659 | 883659 | 2020-12-31 | Custer | Oklahoma | 40039 | 2981 | 31 |
880414 | 880414 | 2020-12-30 | Custer | Oklahoma | 40039 | 2928 | 31 |
877169 | 877169 | 2020-12-29 | Custer | Oklahoma | 40039 | 2895 | 31 |
873924 | 873924 | 2020-12-28 | Custer | Oklahoma | 40039 | 2894 | 31 |
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);