SidxUriSample
1 row where uri = 436
This data as json, CSV (advanced)
| id ▼ | uri | hash | epoch | http_code | content_type |
|---|---|---|---|---|---|
| 563 | https://developer.download.nvidia.com/compute/cuda/redist/cuda_sandbox_dev/LICENSE.txt 436 | 80 80 | 1745700002 |
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);