home / wtr

license

2 rows where licensee = 20680

View and edit SQL

id licensee product tradeable issued status
0020208/1 Irwell Street Metal Company Limited 20680 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0134228/1 Irwell Street Metal Company Limited 20680 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live

Advanced export

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

CSV options:

CREATE TABLE license (
    id TEXT PRIMARY KEY,
    licensee INTEGER NOT NULL,
    product INTEGER,
    tradeable BOOLEAN,
    issued DATE,
    status TEXT,
    FOREIGN KEY (licensee) REFERENCES licensee(id),
    FOREIGN KEY (product) REFERENCES product(id)
    )
Powered by Datasette · Query took 117.121ms