SidxUriSample
1 row where hash = 399
This data as json, CSV (advanced)
| id ▼ | uri | hash | epoch | http_code | content_type |
|---|---|---|---|---|---|
| 561 | https://developer.download.nvidia.com/compute/cuda/redist/cuda_nvvp/linux-x86_64/ 434 | blake3-f1XBPbVkZbVZbaWK2y3hgo62lfFVY/24RocLpY4bCa8= 399 | 1745700001 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "SidxUriSample" (
"id" INTEGER,
"uri" INTEGER NOT NULL,
"hash" INTEGER,
"epoch" INTEGER NOT NULL DEFAULT (unixepoch()),
"http_code" INTEGER,
"content_type" INTEGER DEFAULT NULL,
PRIMARY KEY("id"),
FOREIGN KEY("content_type") REFERENCES "Str"("id"),
FOREIGN KEY("hash") REFERENCES "Hash"("id"),
FOREIGN KEY("uri") REFERENCES "Str"("id")
) STRICT;
CREATE INDEX SidxUriHashIdx
ON SidxUriSample(uri, hash, epoch);