home / wtr

license

Data license: OGL · Data source: Ofcom

79,116 rows

View and edit SQL

Suggested facets: tradeable, status

id licensee product tradeable issued status
0000036/1 Robert Bone 21918 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0000042/1 Oxford Sailing Club 19167 CSR Marina 351030 1 1996-09-19 00:00:00 Live
0000049/1 Upper Forth Boat Club 19168 CSR Marina 351030 1 1996-09-19 00:00:00 Live
0000081/1 Norman Brett 18200 BR Tech Assigned 408010 1 1996-09-30 00:00:00 Live
0000120/1 W Cumber & Son (Theale) Limited 22317 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0000155/1 Sidmouth Sailing Club 19118 CSR Marina 351030 1 1996-09-23 00:00:00 Live
0000187/1 Anthony SheppardOFC 23341 BR Tech Assigned 408010 1 1996-10-09 00:00:00 Live
0000242/1 Gould Electronics Two Way Radio Limited 11972 BR Tech Assigned 408010 1 1996-10-02 00:00:00 Live
0000333/1 Fred Grant (Company) 21904 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0000425/1 Turk Launches Limited 18929 CSR UK 351020 1 1996-08-22 00:00:00 Live
0000483/1 John Edward Megginson & Partners 21895 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0000516/1 Norfolk County Council 5682 CSR Marina 351030 1 1996-09-02 00:00:00 Live
0000553/2 Gould Electronics Two Way Radio Limited 11972 BR Tech Assigned 408010 1 1996-10-28 00:00:00 Live
0000583/1 Apex Radio Limited 368 BR Tech Assigned 408010 1 1996-10-25 00:00:00 Live
0000615/1 Felixstowe Chamber Of Trade And Commerce 21896 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0000765/1 Tamar Bridge & Torpoint Ferry Joint Committee 18713 CSR International 351010 1 1996-10-17 00:00:00 Live
0000777/10 Altram Lrt Limited 18337 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0000838/1 Mahmood Hussain 16521 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0014807/1 East And North Hertfordshire NHS Trust 21828 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017541/1 Forth Ports Limited 14725 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017542/1 Forth Ports Limited 14725 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017543/1 Forth Ports Limited 14725 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017561/1 British Gypsum Limited 16222 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017564/1 British Gypsum Limited 16222 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017567/1 British Gypsum Limited 16222 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017579/2 F I Bliss Limited 27297 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017596/1 Wispington Farms Limited 21910 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017612/1 The Treasurer 21917 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017613/1 A & P Falmouth Limited 17655 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017654/1 East Dunbartonshire Toa 21962 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017683/1 L F Papworth Limited 21928 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017809/4 Saltax Limited 27855 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017844/1 Farquharson Farms 21975 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017880/1 William Corbett Farms Limited 21972 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017907/1 J S Dakin & Co 21973 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017908/1 Grinsell's Skip Hire Limited 21974 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0017911/1 Marwell Wildlife 12693 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018093/1 University Of Wales, Bangor 6846 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018161/1 Stanley Charles Stuart And Samier Najieb Bedier 21911 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018289/2 Adur District Council 24056 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018304/1 Dolphin Autos Limited 21930 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018456/1 Colin Guthrie 21929 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018472/2 Wildes Plant Hire Limited 23587 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018477/2 Torbay Taxis Limited 22518 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018487/2 Buckminster Management Limited 24928 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018500/2 Tele Taxis (Dundee) Limited 26056 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018501/2 Tele Taxis (Dundee) Limited 26056 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018506/3 St Nicholas Court Farms Limited 25035 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018529/1 Ibwest Security Services Limited 17078 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018611/1 G H Chennells (Farms) Limited 21956 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018711/5 Southampton City Council 14194 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018713/1 South Lakeland District Council 16927 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018761/1 East Midland Motor Services Limited 21976 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018763/1 Pleasure And Leisure Corporation Plc 17056 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018868/2 Christchurch Borough Council 23273 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0018953/2 Derby City Council 6912 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019069/1 K C And O F Richards 21978 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019073/1 J M Forbes & Son 21980 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019162/3 University of Oxford 734 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019163/2 University of Oxford 734 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019199/1 Mary Goodley 21989 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019200/1 Northern General Hospital NHS Trust 20588 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019203/1 University Hospital Birmingham NHS Trust 19904 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019285/1 Lovie Limited 21947 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019291/1 Malcolm Hutton 21952 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019296/1 Charles Gange 21953 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019388/1 Tyne And Wear Passenger Transport Executive 21885 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019428/4 Citybus Limited 19499 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019449/1 G D Coussens 21893 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019451/1 Freeland Freight Services Limited 21894 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019521/1 Aggregate Industries UK Limited 8003 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019592/3 Friendship Estates Limited 23483 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019635/1 J W Crowther & Son Limited 21981 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019637/1 Apple Central Taxis Ltd 21982 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019666/1 S G Prescott And Sons 21985 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019725/2 Fred Henderson Limited 16664 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019756/1 University Of Kent At Canterbury 17974 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019763/1 Bradgate Park Trust 21901 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019779/1 P Livesey 21902 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019882/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019885/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019887/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019889/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019890/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019892/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019893/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019896/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019901/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019903/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019905/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019910/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019915/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019924/1 Ford Motor Company Limited 14662 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019952/1 W T & E Banks 21926 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019953/1 W T & E Banks 21926 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019972/1 Christine Vipurs 21936 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0019994/2 Bernard Cook, David Bennett & Barry Wolstoncroft 27049 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0020003/1 Cables Taxis Limited 21937 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0020125/1 Bedfordia Farms Limited 19735 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live
0020208/1 Irwell Street Metal Company Limited 20680 BR Tech Assigned 408010 1 1999-07-30 00:00:00 Live

Next page

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 67.249ms · Data license: OGL · Data source: Ofcom