SidxUriSample
1 row where uri = 1050
This data as json, CSV (advanced)
| id ▼ | uri | hash | epoch | http_code | content_type |
|---|---|---|---|---|---|
| 1180 | https://developer.download.nvidia.com/compute/cuda/redist/imex/linux-x86_64/imex-linux-x86_64-550.54.15-archive.tar.xz 1050 | 1009 1009 | 1745914536 | 200 |
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 REFERENCES Str(id),
PRIMARY KEY(id),
FOREIGN KEY(uri) REFERENCES Str(id),
FOREIGN KEY(hash) REFERENCES Hash(id)
);
CREATE INDEX SidxUriHashIdx
ON SidxUriSample(uri, hash, epoch);