ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40101 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195308 | 1195308 | 2021-04-06 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1192060 | 1192060 | 2021-04-05 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1188811 | 1188811 | 2021-04-04 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1185564 | 1185564 | 2021-04-03 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1182317 | 1182317 | 2021-04-02 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1179070 | 1179070 | 2021-04-01 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1175823 | 1175823 | 2021-03-31 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1172576 | 1172576 | 2021-03-30 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1169329 | 1169329 | 2021-03-29 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1166081 | 1166081 | 2021-03-28 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1162833 | 1162833 | 2021-03-27 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1159584 | 1159584 | 2021-03-26 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1156337 | 1156337 | 2021-03-25 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1153090 | 1153090 | 2021-03-24 | Muskogee | Oklahoma | 40101 | 9214 | 113 |
1149843 | 1149843 | 2021-03-23 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1146596 | 1146596 | 2021-03-22 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1143349 | 1143349 | 2021-03-21 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1140102 | 1140102 | 2021-03-20 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1136856 | 1136856 | 2021-03-19 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1133610 | 1133610 | 2021-03-18 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1130362 | 1130362 | 2021-03-17 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1127115 | 1127115 | 2021-03-16 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1123869 | 1123869 | 2021-03-15 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1120623 | 1120623 | 2021-03-14 | Muskogee | Oklahoma | 40101 | 9178 | 113 |
1117376 | 1117376 | 2021-03-13 | Muskogee | Oklahoma | 40101 | 9176 | 113 |
1114129 | 1114129 | 2021-03-12 | Muskogee | Oklahoma | 40101 | 9156 | 113 |
1110883 | 1110883 | 2021-03-11 | Muskogee | Oklahoma | 40101 | 9152 | 113 |
1107637 | 1107637 | 2021-03-10 | Muskogee | Oklahoma | 40101 | 9149 | 113 |
1104391 | 1104391 | 2021-03-09 | Muskogee | Oklahoma | 40101 | 9140 | 113 |
1101145 | 1101145 | 2021-03-08 | Muskogee | Oklahoma | 40101 | 9138 | 106 |
1097899 | 1097899 | 2021-03-07 | Muskogee | Oklahoma | 40101 | 9138 | 106 |
1094651 | 1094651 | 2021-03-06 | Muskogee | Oklahoma | 40101 | 9132 | 106 |
1091405 | 1091405 | 2021-03-05 | Muskogee | Oklahoma | 40101 | 9117 | 106 |
1088159 | 1088159 | 2021-03-04 | Muskogee | Oklahoma | 40101 | 9106 | 106 |
1084914 | 1084914 | 2021-03-03 | Muskogee | Oklahoma | 40101 | 9104 | 106 |
1081668 | 1081668 | 2021-03-02 | Muskogee | Oklahoma | 40101 | 9100 | 106 |
1078422 | 1078422 | 2021-03-01 | Muskogee | Oklahoma | 40101 | 9094 | 104 |
1075177 | 1075177 | 2021-02-28 | Muskogee | Oklahoma | 40101 | 9090 | 101 |
1071931 | 1071931 | 2021-02-27 | Muskogee | Oklahoma | 40101 | 9089 | 99 |
1068685 | 1068685 | 2021-02-26 | Muskogee | Oklahoma | 40101 | 9083 | 96 |
1065440 | 1065440 | 2021-02-25 | Muskogee | Oklahoma | 40101 | 9068 | 96 |
1062196 | 1062196 | 2021-02-24 | Muskogee | Oklahoma | 40101 | 9050 | 96 |
1058950 | 1058950 | 2021-02-23 | Muskogee | Oklahoma | 40101 | 9047 | 96 |
1055704 | 1055704 | 2021-02-22 | Muskogee | Oklahoma | 40101 | 9046 | 95 |
1052458 | 1052458 | 2021-02-21 | Muskogee | Oklahoma | 40101 | 9039 | 95 |
1049211 | 1049211 | 2021-02-20 | Muskogee | Oklahoma | 40101 | 9035 | 93 |
1045964 | 1045964 | 2021-02-19 | Muskogee | Oklahoma | 40101 | 9027 | 90 |
1042719 | 1042719 | 2021-02-18 | Muskogee | Oklahoma | 40101 | 9008 | 90 |
1039474 | 1039474 | 2021-02-17 | Muskogee | Oklahoma | 40101 | 8998 | 90 |
1036229 | 1036229 | 2021-02-16 | Muskogee | Oklahoma | 40101 | 8978 | 90 |
1032984 | 1032984 | 2021-02-15 | Muskogee | Oklahoma | 40101 | 8976 | 90 |
1029738 | 1029738 | 2021-02-14 | Muskogee | Oklahoma | 40101 | 8954 | 90 |
1026491 | 1026491 | 2021-02-13 | Muskogee | Oklahoma | 40101 | 8943 | 90 |
1023246 | 1023246 | 2021-02-12 | Muskogee | Oklahoma | 40101 | 8931 | 90 |
1020001 | 1020001 | 2021-02-11 | Muskogee | Oklahoma | 40101 | 8915 | 89 |
1016756 | 1016756 | 2021-02-10 | Muskogee | Oklahoma | 40101 | 8866 | 87 |
1013511 | 1013511 | 2021-02-09 | Muskogee | Oklahoma | 40101 | 8838 | 86 |
1010266 | 1010266 | 2021-02-08 | Muskogee | Oklahoma | 40101 | 8813 | 86 |
1007020 | 1007020 | 2021-02-07 | Muskogee | Oklahoma | 40101 | 8792 | 86 |
1003774 | 1003774 | 2021-02-06 | Muskogee | Oklahoma | 40101 | 8736 | 84 |
1000528 | 1000528 | 2021-02-05 | Muskogee | Oklahoma | 40101 | 8707 | 84 |
997282 | 997282 | 2021-02-04 | Muskogee | Oklahoma | 40101 | 8630 | 84 |
994036 | 994036 | 2021-02-03 | Muskogee | Oklahoma | 40101 | 8550 | 83 |
990790 | 990790 | 2021-02-02 | Muskogee | Oklahoma | 40101 | 8530 | 82 |
987544 | 987544 | 2021-02-01 | Muskogee | Oklahoma | 40101 | 8495 | 80 |
984297 | 984297 | 2021-01-31 | Muskogee | Oklahoma | 40101 | 8443 | 78 |
981050 | 981050 | 2021-01-30 | Muskogee | Oklahoma | 40101 | 8414 | 77 |
977804 | 977804 | 2021-01-29 | Muskogee | Oklahoma | 40101 | 8366 | 76 |
974559 | 974559 | 2021-01-28 | Muskogee | Oklahoma | 40101 | 8328 | 73 |
971314 | 971314 | 2021-01-27 | Muskogee | Oklahoma | 40101 | 8267 | 70 |
968069 | 968069 | 2021-01-26 | Muskogee | Oklahoma | 40101 | 8200 | 69 |
964825 | 964825 | 2021-01-25 | Muskogee | Oklahoma | 40101 | 8177 | 66 |
961580 | 961580 | 2021-01-24 | Muskogee | Oklahoma | 40101 | 8140 | 66 |
958335 | 958335 | 2021-01-23 | Muskogee | Oklahoma | 40101 | 8111 | 66 |
955089 | 955089 | 2021-01-22 | Muskogee | Oklahoma | 40101 | 8036 | 66 |
951844 | 951844 | 2021-01-21 | Muskogee | Oklahoma | 40101 | 7994 | 65 |
948599 | 948599 | 2021-01-20 | Muskogee | Oklahoma | 40101 | 7920 | 62 |
945353 | 945353 | 2021-01-19 | Muskogee | Oklahoma | 40101 | 7888 | 60 |
942106 | 942106 | 2021-01-18 | Muskogee | Oklahoma | 40101 | 7872 | 58 |
938861 | 938861 | 2021-01-17 | Muskogee | Oklahoma | 40101 | 7840 | 58 |
935616 | 935616 | 2021-01-16 | Muskogee | Oklahoma | 40101 | 7758 | 58 |
932371 | 932371 | 2021-01-15 | Muskogee | Oklahoma | 40101 | 7692 | 58 |
929126 | 929126 | 2021-01-14 | Muskogee | Oklahoma | 40101 | 7611 | 58 |
925881 | 925881 | 2021-01-13 | Muskogee | Oklahoma | 40101 | 7554 | 57 |
922635 | 922635 | 2021-01-12 | Muskogee | Oklahoma | 40101 | 7475 | 56 |
919390 | 919390 | 2021-01-11 | Muskogee | Oklahoma | 40101 | 7446 | 56 |
916145 | 916145 | 2021-01-10 | Muskogee | Oklahoma | 40101 | 7364 | 56 |
912900 | 912900 | 2021-01-09 | Muskogee | Oklahoma | 40101 | 7179 | 56 |
909655 | 909655 | 2021-01-08 | Muskogee | Oklahoma | 40101 | 7088 | 56 |
906410 | 906410 | 2021-01-07 | Muskogee | Oklahoma | 40101 | 6998 | 56 |
903164 | 903164 | 2021-01-06 | Muskogee | Oklahoma | 40101 | 6928 | 54 |
899919 | 899919 | 2021-01-05 | Muskogee | Oklahoma | 40101 | 6874 | 53 |
896674 | 896674 | 2021-01-04 | Muskogee | Oklahoma | 40101 | 6849 | 53 |
893428 | 893428 | 2021-01-03 | Muskogee | Oklahoma | 40101 | 6802 | 53 |
890182 | 890182 | 2021-01-02 | Muskogee | Oklahoma | 40101 | 6636 | 53 |
886935 | 886935 | 2021-01-01 | Muskogee | Oklahoma | 40101 | 6526 | 48 |
883690 | 883690 | 2020-12-31 | Muskogee | Oklahoma | 40101 | 6526 | 48 |
880445 | 880445 | 2020-12-30 | Muskogee | Oklahoma | 40101 | 6456 | 48 |
877200 | 877200 | 2020-12-29 | Muskogee | Oklahoma | 40101 | 6392 | 48 |
873955 | 873955 | 2020-12-28 | Muskogee | Oklahoma | 40101 | 6346 | 48 |
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);