SidxUriSample

1 row where uri = 21

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ uri hash epoch http_code content_type
21 /home/someone/Sources/nixpkgs/pkgs/development/cuda-modules/cuda/manifests/redistrib_12.1.1.json 21 blake3-LYY+nWdlvw2/7dZob5vIlpAt7Llwigj4qvfpcfETUHU= 20 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,
	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);