home / wtr

license

6 rows where licensee = 21828

View and edit SQL

Suggested facets: issued

id licensee product tradeable issued status
0014807/1 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0119725/3 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0259228/4 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 2002-08-07 00:00:00 Live
0259229/2 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 2002-08-07 00:00:00 Live
1014610/2 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 2014-11-03 00:00:00 Live
1110495/1 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 2017-02-24 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 109.309ms