ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
640 rows where county = "Unknown" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195330 | 1195330 | 2021-04-06 | Unknown | Oklahoma | 2289 | 0 | |
1192082 | 1192082 | 2021-04-05 | Unknown | Oklahoma | 2169 | 0 | |
1188833 | 1188833 | 2021-04-04 | Unknown | Oklahoma | 1296 | 0 | |
1185586 | 1185586 | 2021-04-03 | Unknown | Oklahoma | 1296 | 0 | |
1182339 | 1182339 | 2021-04-02 | Unknown | Oklahoma | 1296 | 0 | |
1179092 | 1179092 | 2021-04-01 | Unknown | Oklahoma | 924 | 0 | |
1175845 | 1175845 | 2021-03-31 | Unknown | Oklahoma | 511 | 0 | |
1172598 | 1172598 | 2021-03-30 | Unknown | Oklahoma | 2530 | 0 | |
1169351 | 1169351 | 2021-03-29 | Unknown | Oklahoma | 2409 | 0 | |
1166103 | 1166103 | 2021-03-28 | Unknown | Oklahoma | 1527 | 0 | |
1162855 | 1162855 | 2021-03-27 | Unknown | Oklahoma | 1527 | 0 | |
1159606 | 1159606 | 2021-03-26 | Unknown | Oklahoma | 1527 | 0 | |
1156359 | 1156359 | 2021-03-25 | Unknown | Oklahoma | 1060 | 0 | |
1153112 | 1153112 | 2021-03-24 | Unknown | Oklahoma | 691 | 0 | |
1149865 | 1149865 | 2021-03-23 | Unknown | Oklahoma | 2853 | 0 | |
1146618 | 1146618 | 2021-03-22 | Unknown | Oklahoma | 2669 | 0 | |
1143371 | 1143371 | 2021-03-21 | Unknown | Oklahoma | 1710 | 0 | |
1140124 | 1140124 | 2021-03-20 | Unknown | Oklahoma | 1710 | 0 | |
1136878 | 1136878 | 2021-03-19 | Unknown | Oklahoma | 1710 | 0 | |
1133632 | 1133632 | 2021-03-18 | Unknown | Oklahoma | 1294 | 0 | |
1130384 | 1130384 | 2021-03-17 | Unknown | Oklahoma | 735 | 0 | |
1127137 | 1127137 | 2021-03-16 | Unknown | Oklahoma | 244 | 0 | |
1123891 | 1123891 | 2021-03-15 | Unknown | Oklahoma | 12 | 0 | |
1120645 | 1120645 | 2021-03-14 | Unknown | Oklahoma | 10 | 0 | |
1117398 | 1117398 | 2021-03-13 | Unknown | Oklahoma | 7 | 0 | |
1114151 | 1114151 | 2021-03-12 | Unknown | Oklahoma | 17 | 0 | |
1110905 | 1110905 | 2021-03-11 | Unknown | Oklahoma | 8 | 0 | |
1107659 | 1107659 | 2021-03-10 | Unknown | Oklahoma | 4 | 0 | |
1104413 | 1104413 | 2021-03-09 | Unknown | Oklahoma | 7 | 0 | |
1101167 | 1101167 | 2021-03-08 | Unknown | Oklahoma | 7 | 0 | |
1097921 | 1097921 | 2021-03-07 | Unknown | Oklahoma | 5 | 0 | |
1094673 | 1094673 | 2021-03-06 | Unknown | Oklahoma | 8 | 0 | |
1091427 | 1091427 | 2021-03-05 | Unknown | Oklahoma | 4 | 0 | |
1088181 | 1088181 | 2021-03-04 | Unknown | Oklahoma | 3 | 0 | |
1084936 | 1084936 | 2021-03-03 | Unknown | Oklahoma | 2 | 0 | |
1081690 | 1081690 | 2021-03-02 | Unknown | Oklahoma | 2 | 0 | |
1078444 | 1078444 | 2021-03-01 | Unknown | Oklahoma | 2 | 0 | |
1075199 | 1075199 | 2021-02-28 | Unknown | Oklahoma | 1 | 0 | |
1071953 | 1071953 | 2021-02-27 | Unknown | Oklahoma | 2 | 0 | |
1068707 | 1068707 | 2021-02-26 | Unknown | Oklahoma | 3 | 0 | |
1065462 | 1065462 | 2021-02-25 | Unknown | Oklahoma | 1 | 0 | |
1058972 | 1058972 | 2021-02-23 | Unknown | Oklahoma | 2 | 0 | |
1055726 | 1055726 | 2021-02-22 | Unknown | Oklahoma | 1 | 0 | |
1052480 | 1052480 | 2021-02-21 | Unknown | Oklahoma | 1 | 0 | |
1049233 | 1049233 | 2021-02-20 | Unknown | Oklahoma | 11 | 0 | |
1045986 | 1045986 | 2021-02-19 | Unknown | Oklahoma | 4 | 0 | |
1042741 | 1042741 | 2021-02-18 | Unknown | Oklahoma | 11 | 0 | |
1039496 | 1039496 | 2021-02-17 | Unknown | Oklahoma | 2 | 0 | |
1036251 | 1036251 | 2021-02-16 | Unknown | Oklahoma | 12 | 0 | |
1033006 | 1033006 | 2021-02-15 | Unknown | Oklahoma | 13 | 0 | |
1029760 | 1029760 | 2021-02-14 | Unknown | Oklahoma | 9 | 0 | |
1026513 | 1026513 | 2021-02-13 | Unknown | Oklahoma | 10 | 0 | |
1023268 | 1023268 | 2021-02-12 | Unknown | Oklahoma | 10 | 0 | |
1020023 | 1020023 | 2021-02-11 | Unknown | Oklahoma | 13 | 0 | |
1016778 | 1016778 | 2021-02-10 | Unknown | Oklahoma | 26 | 0 | |
1013533 | 1013533 | 2021-02-09 | Unknown | Oklahoma | 36 | 0 | |
1010288 | 1010288 | 2021-02-08 | Unknown | Oklahoma | 34 | 0 | |
1007042 | 1007042 | 2021-02-07 | Unknown | Oklahoma | 21 | 0 | |
1003796 | 1003796 | 2021-02-06 | Unknown | Oklahoma | 32 | 0 | |
1000550 | 1000550 | 2021-02-05 | Unknown | Oklahoma | 55 | 0 | |
997304 | 997304 | 2021-02-04 | Unknown | Oklahoma | 115 | 0 | |
994058 | 994058 | 2021-02-03 | Unknown | Oklahoma | 139 | 0 | |
990812 | 990812 | 2021-02-02 | Unknown | Oklahoma | 135 | 0 | |
987566 | 987566 | 2021-02-01 | Unknown | Oklahoma | 137 | 0 | |
984319 | 984319 | 2021-01-31 | Unknown | Oklahoma | 134 | 0 | |
981072 | 981072 | 2021-01-30 | Unknown | Oklahoma | 133 | 0 | |
977826 | 977826 | 2021-01-29 | Unknown | Oklahoma | 89 | 0 | |
974581 | 974581 | 2021-01-28 | Unknown | Oklahoma | 89 | 0 | |
971336 | 971336 | 2021-01-27 | Unknown | Oklahoma | 94 | 0 | |
968091 | 968091 | 2021-01-26 | Unknown | Oklahoma | 90 | 0 | |
964847 | 964847 | 2021-01-25 | Unknown | Oklahoma | 90 | 0 | |
961602 | 961602 | 2021-01-24 | Unknown | Oklahoma | 89 | 0 | |
958357 | 958357 | 2021-01-23 | Unknown | Oklahoma | 123 | 0 | |
955111 | 955111 | 2021-01-22 | Unknown | Oklahoma | 144 | 0 | |
951866 | 951866 | 2021-01-21 | Unknown | Oklahoma | 143 | 0 | |
948621 | 948621 | 2021-01-20 | Unknown | Oklahoma | 154 | 0 | |
945375 | 945375 | 2021-01-19 | Unknown | Oklahoma | 146 | 0 | |
942128 | 942128 | 2021-01-18 | Unknown | Oklahoma | 146 | 0 | |
938883 | 938883 | 2021-01-17 | Unknown | Oklahoma | 144 | 0 | |
935638 | 935638 | 2021-01-16 | Unknown | Oklahoma | 143 | 0 | |
932393 | 932393 | 2021-01-15 | Unknown | Oklahoma | 133 | 0 | |
929148 | 929148 | 2021-01-14 | Unknown | Oklahoma | 117 | 0 | |
925903 | 925903 | 2021-01-13 | Unknown | Oklahoma | 115 | 0 | |
922657 | 922657 | 2021-01-12 | Unknown | Oklahoma | 99 | 0 | |
919412 | 919412 | 2021-01-11 | Unknown | Oklahoma | 99 | 0 | |
916167 | 916167 | 2021-01-10 | Unknown | Oklahoma | 100 | 0 | |
912922 | 912922 | 2021-01-09 | Unknown | Oklahoma | 101 | 0 | |
909677 | 909677 | 2021-01-08 | Unknown | Oklahoma | 182 | 0 | |
906432 | 906432 | 2021-01-07 | Unknown | Oklahoma | 423 | 0 | |
903186 | 903186 | 2021-01-06 | Unknown | Oklahoma | 461 | 0 | |
899941 | 899941 | 2021-01-05 | Unknown | Oklahoma | 456 | 0 | |
896696 | 896696 | 2021-01-04 | Unknown | Oklahoma | 456 | 0 | |
893450 | 893450 | 2021-01-03 | Unknown | Oklahoma | 460 | 0 | |
890204 | 890204 | 2021-01-02 | Unknown | Oklahoma | 296 | 0 | |
886957 | 886957 | 2021-01-01 | Unknown | Oklahoma | 236 | 0 | |
883712 | 883712 | 2020-12-31 | Unknown | Oklahoma | 236 | 0 | |
880467 | 880467 | 2020-12-30 | Unknown | Oklahoma | 222 | 0 | |
877222 | 877222 | 2020-12-29 | Unknown | Oklahoma | 209 | 0 | |
873977 | 873977 | 2020-12-28 | Unknown | Oklahoma | 184 | 0 | |
870732 | 870732 | 2020-12-27 | Unknown | Oklahoma | 153 | 0 |
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);