ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40103 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195309 | 1195309 | 2021-04-06 | Noble | Oklahoma | 40103 | 1370 | 16 |
1192061 | 1192061 | 2021-04-05 | Noble | Oklahoma | 40103 | 1370 | 16 |
1188812 | 1188812 | 2021-04-04 | Noble | Oklahoma | 40103 | 1370 | 16 |
1185565 | 1185565 | 2021-04-03 | Noble | Oklahoma | 40103 | 1370 | 16 |
1182318 | 1182318 | 2021-04-02 | Noble | Oklahoma | 40103 | 1370 | 16 |
1179071 | 1179071 | 2021-04-01 | Noble | Oklahoma | 40103 | 1370 | 16 |
1175824 | 1175824 | 2021-03-31 | Noble | Oklahoma | 40103 | 1370 | 16 |
1172577 | 1172577 | 2021-03-30 | Noble | Oklahoma | 40103 | 1369 | 15 |
1169330 | 1169330 | 2021-03-29 | Noble | Oklahoma | 40103 | 1369 | 15 |
1166082 | 1166082 | 2021-03-28 | Noble | Oklahoma | 40103 | 1369 | 15 |
1162834 | 1162834 | 2021-03-27 | Noble | Oklahoma | 40103 | 1369 | 15 |
1159585 | 1159585 | 2021-03-26 | Noble | Oklahoma | 40103 | 1369 | 15 |
1156338 | 1156338 | 2021-03-25 | Noble | Oklahoma | 40103 | 1369 | 15 |
1153091 | 1153091 | 2021-03-24 | Noble | Oklahoma | 40103 | 1369 | 15 |
1149844 | 1149844 | 2021-03-23 | Noble | Oklahoma | 40103 | 1362 | 14 |
1146597 | 1146597 | 2021-03-22 | Noble | Oklahoma | 40103 | 1362 | 14 |
1143350 | 1143350 | 2021-03-21 | Noble | Oklahoma | 40103 | 1362 | 14 |
1140103 | 1140103 | 2021-03-20 | Noble | Oklahoma | 40103 | 1362 | 14 |
1136857 | 1136857 | 2021-03-19 | Noble | Oklahoma | 40103 | 1362 | 14 |
1133611 | 1133611 | 2021-03-18 | Noble | Oklahoma | 40103 | 1362 | 14 |
1130363 | 1130363 | 2021-03-17 | Noble | Oklahoma | 40103 | 1362 | 14 |
1127116 | 1127116 | 2021-03-16 | Noble | Oklahoma | 40103 | 1362 | 14 |
1123870 | 1123870 | 2021-03-15 | Noble | Oklahoma | 40103 | 1362 | 14 |
1120624 | 1120624 | 2021-03-14 | Noble | Oklahoma | 40103 | 1362 | 14 |
1117377 | 1117377 | 2021-03-13 | Noble | Oklahoma | 40103 | 1362 | 14 |
1114130 | 1114130 | 2021-03-12 | Noble | Oklahoma | 40103 | 1361 | 14 |
1110884 | 1110884 | 2021-03-11 | Noble | Oklahoma | 40103 | 1361 | 14 |
1107638 | 1107638 | 2021-03-10 | Noble | Oklahoma | 40103 | 1358 | 14 |
1104392 | 1104392 | 2021-03-09 | Noble | Oklahoma | 40103 | 1358 | 14 |
1101146 | 1101146 | 2021-03-08 | Noble | Oklahoma | 40103 | 1358 | 13 |
1097900 | 1097900 | 2021-03-07 | Noble | Oklahoma | 40103 | 1357 | 13 |
1094652 | 1094652 | 2021-03-06 | Noble | Oklahoma | 40103 | 1356 | 13 |
1091406 | 1091406 | 2021-03-05 | Noble | Oklahoma | 40103 | 1352 | 13 |
1088160 | 1088160 | 2021-03-04 | Noble | Oklahoma | 40103 | 1351 | 13 |
1084915 | 1084915 | 2021-03-03 | Noble | Oklahoma | 40103 | 1350 | 13 |
1081669 | 1081669 | 2021-03-02 | Noble | Oklahoma | 40103 | 1347 | 13 |
1078423 | 1078423 | 2021-03-01 | Noble | Oklahoma | 40103 | 1347 | 13 |
1075178 | 1075178 | 2021-02-28 | Noble | Oklahoma | 40103 | 1347 | 12 |
1071932 | 1071932 | 2021-02-27 | Noble | Oklahoma | 40103 | 1344 | 12 |
1068686 | 1068686 | 2021-02-26 | Noble | Oklahoma | 40103 | 1343 | 12 |
1065441 | 1065441 | 2021-02-25 | Noble | Oklahoma | 40103 | 1341 | 12 |
1062197 | 1062197 | 2021-02-24 | Noble | Oklahoma | 40103 | 1337 | 11 |
1058951 | 1058951 | 2021-02-23 | Noble | Oklahoma | 40103 | 1337 | 11 |
1055705 | 1055705 | 2021-02-22 | Noble | Oklahoma | 40103 | 1337 | 11 |
1052459 | 1052459 | 2021-02-21 | Noble | Oklahoma | 40103 | 1335 | 10 |
1049212 | 1049212 | 2021-02-20 | Noble | Oklahoma | 40103 | 1333 | 10 |
1045965 | 1045965 | 2021-02-19 | Noble | Oklahoma | 40103 | 1333 | 10 |
1042720 | 1042720 | 2021-02-18 | Noble | Oklahoma | 40103 | 1331 | 10 |
1039475 | 1039475 | 2021-02-17 | Noble | Oklahoma | 40103 | 1330 | 10 |
1036230 | 1036230 | 2021-02-16 | Noble | Oklahoma | 40103 | 1326 | 10 |
1032985 | 1032985 | 2021-02-15 | Noble | Oklahoma | 40103 | 1324 | 10 |
1029739 | 1029739 | 2021-02-14 | Noble | Oklahoma | 40103 | 1317 | 10 |
1026492 | 1026492 | 2021-02-13 | Noble | Oklahoma | 40103 | 1309 | 10 |
1023247 | 1023247 | 2021-02-12 | Noble | Oklahoma | 40103 | 1303 | 10 |
1020002 | 1020002 | 2021-02-11 | Noble | Oklahoma | 40103 | 1302 | 10 |
1016757 | 1016757 | 2021-02-10 | Noble | Oklahoma | 40103 | 1301 | 9 |
1013512 | 1013512 | 2021-02-09 | Noble | Oklahoma | 40103 | 1295 | 9 |
1010267 | 1010267 | 2021-02-08 | Noble | Oklahoma | 40103 | 1292 | 9 |
1007021 | 1007021 | 2021-02-07 | Noble | Oklahoma | 40103 | 1291 | 9 |
1003775 | 1003775 | 2021-02-06 | Noble | Oklahoma | 40103 | 1284 | 8 |
1000529 | 1000529 | 2021-02-05 | Noble | Oklahoma | 40103 | 1278 | 8 |
997283 | 997283 | 2021-02-04 | Noble | Oklahoma | 40103 | 1264 | 8 |
994037 | 994037 | 2021-02-03 | Noble | Oklahoma | 40103 | 1259 | 8 |
990791 | 990791 | 2021-02-02 | Noble | Oklahoma | 40103 | 1254 | 8 |
987545 | 987545 | 2021-02-01 | Noble | Oklahoma | 40103 | 1245 | 8 |
984298 | 984298 | 2021-01-31 | Noble | Oklahoma | 40103 | 1240 | 8 |
981051 | 981051 | 2021-01-30 | Noble | Oklahoma | 40103 | 1233 | 8 |
977805 | 977805 | 2021-01-29 | Noble | Oklahoma | 40103 | 1224 | 8 |
974560 | 974560 | 2021-01-28 | Noble | Oklahoma | 40103 | 1214 | 8 |
971315 | 971315 | 2021-01-27 | Noble | Oklahoma | 40103 | 1211 | 8 |
968070 | 968070 | 2021-01-26 | Noble | Oklahoma | 40103 | 1201 | 8 |
964826 | 964826 | 2021-01-25 | Noble | Oklahoma | 40103 | 1202 | 8 |
961581 | 961581 | 2021-01-24 | Noble | Oklahoma | 40103 | 1200 | 8 |
958336 | 958336 | 2021-01-23 | Noble | Oklahoma | 40103 | 1197 | 8 |
955090 | 955090 | 2021-01-22 | Noble | Oklahoma | 40103 | 1191 | 8 |
951845 | 951845 | 2021-01-21 | Noble | Oklahoma | 40103 | 1176 | 8 |
948600 | 948600 | 2021-01-20 | Noble | Oklahoma | 40103 | 1175 | 8 |
945354 | 945354 | 2021-01-19 | Noble | Oklahoma | 40103 | 1165 | 8 |
942107 | 942107 | 2021-01-18 | Noble | Oklahoma | 40103 | 1164 | 7 |
938862 | 938862 | 2021-01-17 | Noble | Oklahoma | 40103 | 1154 | 7 |
935617 | 935617 | 2021-01-16 | Noble | Oklahoma | 40103 | 1148 | 7 |
932372 | 932372 | 2021-01-15 | Noble | Oklahoma | 40103 | 1132 | 7 |
929127 | 929127 | 2021-01-14 | Noble | Oklahoma | 40103 | 1126 | 7 |
925882 | 925882 | 2021-01-13 | Noble | Oklahoma | 40103 | 1118 | 7 |
922636 | 922636 | 2021-01-12 | Noble | Oklahoma | 40103 | 1111 | 7 |
919391 | 919391 | 2021-01-11 | Noble | Oklahoma | 40103 | 1102 | 7 |
916146 | 916146 | 2021-01-10 | Noble | Oklahoma | 40103 | 1098 | 7 |
912901 | 912901 | 2021-01-09 | Noble | Oklahoma | 40103 | 1087 | 7 |
909656 | 909656 | 2021-01-08 | Noble | Oklahoma | 40103 | 1067 | 7 |
906411 | 906411 | 2021-01-07 | Noble | Oklahoma | 40103 | 1058 | 7 |
903165 | 903165 | 2021-01-06 | Noble | Oklahoma | 40103 | 1053 | 7 |
899920 | 899920 | 2021-01-05 | Noble | Oklahoma | 40103 | 1039 | 7 |
896675 | 896675 | 2021-01-04 | Noble | Oklahoma | 40103 | 1036 | 7 |
893429 | 893429 | 2021-01-03 | Noble | Oklahoma | 40103 | 1034 | 7 |
890183 | 890183 | 2021-01-02 | Noble | Oklahoma | 40103 | 1002 | 7 |
886936 | 886936 | 2021-01-01 | Noble | Oklahoma | 40103 | 984 | 7 |
883691 | 883691 | 2020-12-31 | Noble | Oklahoma | 40103 | 984 | 7 |
880446 | 880446 | 2020-12-30 | Noble | Oklahoma | 40103 | 972 | 7 |
877201 | 877201 | 2020-12-29 | Noble | Oklahoma | 40103 | 946 | 7 |
873956 | 873956 | 2020-12-28 | Noble | Oklahoma | 40103 | 946 | 7 |
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);