SidxUriSample

1 row where uri = 22

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ uri hash epoch http_code content_type
22 /home/someone/Sources/nixpkgs/pkgs/development/cuda-modules/cuda/manifests/redistrib_12.3.2.json 22 21 21 1745139512    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);