items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
513 rows where member_id = "uk.org.publicwhip/member/1957" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
af8d6b9ce911a95aa7f2c7493d27255f54e7c582 | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-04-12-80ef1083-10552-0 |
4b320fd3e870db1385765a7a8da5f81b50888f0c | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-04-12-80ef1083-10552-0 |
b5c18569568848ef3f2df2977dd7299960a4f843 | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-04-12-80ef1083-10552-0 |
0f58aeb7bf227fe8f7b8c991dc0e69d937a6a547 | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-04-12-80ef1083-10552-0 |
aad48cc7254399583530ca5f25869d5b764e65b9 | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2010-04-12-80ef1083-10552-0 |
8c60984e758bc1065e9bb6f6ad051af720ea3082 | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2010-04-12-80ef1083-10552-0 |
93207b7919fdd85eba3b66007bb34e0507e4bf4f | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-04-12-4f1e6359-10552-0 |
64247a232a28785879fc9351c1ede9bed1dfdd95 | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-04-12-3aff2389-10552-0 |
9eedb5fe2ebde53504d9e7e184ff256299c69c97 | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-04-12-3aff2389-10552-0 |
648b622098723e96bdb4fd865f58e73de3e497e3 | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-04-12-3aff2389-10552-0 |
b2c4e3ad42794226ce5c47d1e2d29bd20cd78c65 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2010-04-12 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-04-12-3aff2389-10552-0 |
66dde601cac4d60c16bfffba2cba63719bec59db | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-03-24-80ef1083-10552-0 |
80c7876caff4ae9d72c57d124c77af2377d205af | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-03-24-80ef1083-10552-0 |
ba6e28cd320dac401365d3c5a69ceac2e3e733f5 | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-03-24-80ef1083-10552-0 |
8b19ead2d7a2c017aa76771832e63fb91d266c52 | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-03-24-80ef1083-10552-0 |
b29fd7b4f19f3b4ca9d454d3b2e3614dffcbe4bb | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2010-03-24-80ef1083-10552-0 |
75b884da8d60ef65321d0d42c07c6a091da73e4f | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2010-03-24-80ef1083-10552-0 |
c0423f24b4dba6bbbcd40ad047297c755a6194a8 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-03-24-4f1e6359-10552-0 |
a2d6bcfa39609eeba56dfb4b13b1ca5a53dce861 | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-03-24-3aff2389-10552-0 |
c1efd48b3a56868ba4da850e70b69d673374eb80 | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-03-24-3aff2389-10552-0 |
79e831043a5646afa2324aa3e2adbe4144aa9b6b | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-03-24-3aff2389-10552-0 |
f7145c723e403119916140753bea0e2ecaf8c440 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2010-03-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-03-24-3aff2389-10552-0 |
767fea254701aa095c578af4728f6f035ee359cd | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-03-10-80ef1083-10552-0 |
814f0ec1555cf99cc06e6cb2b5c3d08515cc9deb | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-03-10-80ef1083-10552-0 |
e790767175b1cf57fef93b5730e58d8983ba3174 | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-03-10-80ef1083-10552-0 |
13b8266215e575277adfbab8b71210a02b044857 | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-03-10-80ef1083-10552-0 |
c68016b48ed1989fa826be8a116896fea7716b5f | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2010-03-10-80ef1083-10552-0 |
f46ad1fbaffefe45ddb1e287e7f0ddcd0111a586 | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2010-03-10-80ef1083-10552-0 |
1f3e35a1e8c0304aeb5fa8a2081fe240d96e1624 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-03-10-4f1e6359-10552-0 |
3b17e48dfa8b9c0ead9dd33d8850b6446d4881df | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-03-10-3aff2389-10552-0 |
64e68f42038efd066c66e6b0f9abf2f746fa73d2 | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-03-10-3aff2389-10552-0 |
b1d928d69a138b2837566e9ef0c4a063a895306a | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-03-10-3aff2389-10552-0 |
5ebdf1e5a769d484bd9c1ad012c2f51d1f6106ae | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2010-03-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-03-10-3aff2389-10552-0 |
744c707c3e5b3642a0baf8059c3a54aa8e35de19 | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-02-24-80ef1083-10552-0 |
ef063b162421ec03c98fdf1aab22760106be4c7b | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-02-24-80ef1083-10552-0 |
863e420a052078f58cba5f29f5b8c9145ae62dff | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-02-24-80ef1083-10552-0 |
53c94fb191f9e450e360c39a33f2c5d5c4ad5f68 | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-02-24-80ef1083-10552-0 |
5d026025df232af9c2becc02f7bcdf5426b954f0 | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2010-02-24-80ef1083-10552-0 |
027409eb00a1e2e8ea6ab6feb3e620e11df46c1d | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2010-02-24-80ef1083-10552-0 |
89af8e4234dc2a147315ecb9e41be530d578191f | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-02-24-4f1e6359-10552-0 |
5f41ecc551ed0c24232b8d59f6ae18bdd50df68a | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-02-24-3aff2389-10552-0 |
7a591aa8a00b3cc8b1347158be761970feca7c4c | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-02-24-3aff2389-10552-0 |
f79696f93d763f61b7218c3c721568359600ec7d | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-02-24-3aff2389-10552-0 |
6b56d10ee596adf0ea0a659e2e17196adc1b5621 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2010-02-24 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-02-24-3aff2389-10552-0 |
fbcdfe942e1a1fa15115f60365967e8bcf559b5b | 26-28 August 2008, to Stavanger, Norway to visit Offshore Northern Seas (ONS) conference and exhibition - joint visit by the British Offshore Oil & Gas Industry All Party Parliamentary Group at Westminster and the Oil & Gas Cross Party Group at Holyrood. Overseas flights, hotel accommodation, local transport and hospitality sponsored by Oil & Gas UK, Shell, Chevron, Statoil Hydro, Wood Group, Conoco Phillips, Exxon Mobil, the Norwegian Embassy and OLF. (Registered 11 September 2008) | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-02-03-80ef1083-10552-0 |
527518988aeee8263b7f248e0e287d1637e74854 | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-02-03-80ef1083-10552-0 |
58662abb9bca11e10b6eeb4f304082ac31aeee00 | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-02-03-80ef1083-10552-0 |
1eb7fb7f33b6b886c71d77fe9edec98bf5f806aa | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-02-03-80ef1083-10552-0 |
5812ffc5639c557ab6935811a70ab9cca270dfb7 | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2010-02-03-80ef1083-10552-0 |
8e40fe4b1df1f208cdfda3fdb72540e00e87aac0 | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2010-02-03-80ef1083-10552-0 |
e9fe3ca5346f9491bc106d350b99d54695ed29bf | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 6 | 2010-02-03-80ef1083-10552-0 |
bda295bf61aa4bc9c93c03168806b26d17467fc5 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-02-03-4f1e6359-10552-0 |
a7ef81125b2008275a4db9ef19cb8a8cbe99765a | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-02-03-3aff2389-10552-0 |
82c869f3c04f79335daf91c1b4662d453f8d2218 | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-02-03-3aff2389-10552-0 |
bdb2eccccf3a0d9aab82878db5b748f6c93ba0af | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-02-03-3aff2389-10552-0 |
b194a200038ba7f415f172d7e7c855a08cdcc011 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2010-02-03 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-02-03-3aff2389-10552-0 |
00f49c48d49d78248397d3b95c44b9b67a43710e | 26-28 August 2008, to Stavanger, Norway to visit Offshore Northern Seas (ONS) conference and exhibition - joint visit by the British Offshore Oil & Gas Industry All Party Parliamentary Group at Westminster and the Oil & Gas Cross Party Group at Holyrood. Overseas flights, hotel accommodation, local transport and hospitality sponsored by Oil & Gas UK, Shell, Chevron, Statoil Hydro, Wood Group, Conoco Phillips, Exxon Mobil, the Norwegian Embassy and OLF. (Registered 11 September 2008) | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-01-06-80ef1083-10552-0 |
da9e53e0f225d431e46180ad34369280fe92afa2 | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-01-06-80ef1083-10552-0 |
de4f9c8d34275185bac45dfa0b3862cd869d2d3a | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-01-06-80ef1083-10552-0 |
dcf73b08180940dd34a51a3db32b78011ba9a648 | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-01-06-80ef1083-10552-0 |
6d966d52edff352e8f6fb84805aa0e6147ed264e | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2010-01-06-80ef1083-10552-0 |
8603539a46e39a5e52c039cbe8946a9ab1cfbfe9 | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2010-01-06-80ef1083-10552-0 |
0332855026d4fde1be35534206cc5c5195a83481 | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 6 | 2010-01-06-80ef1083-10552-0 |
12484ef920774e725a72867151a058931ef3bcf9 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-01-06-4f1e6359-10552-0 |
26610a2b07c9ac9e1cc0164051fd61123d46c998 | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2010-01-06-3aff2389-10552-0 |
547f573a40ca7f5bdc2da997aab7022638e115ef | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2010-01-06-3aff2389-10552-0 |
a2b5be43b1bb77ab56308f9e19ef938eef74add8 | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2010-01-06-3aff2389-10552-0 |
7e46fcf5b1727325b37c26610b7b4983d3cce7c2 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2010-01-06 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2010-01-06-3aff2389-10552-0 |
e5d3a4de4f21e7e03e06a913bfa977533938fa4e | 26-28 August 2008, to Stavanger, Norway to visit Offshore Northern Seas (ONS) conference and exhibition - joint visit by the British Offshore Oil & Gas Industry All Party Parliamentary Group at Westminster and the Oil & Gas Cross Party Group at Holyrood. Overseas flights, hotel accommodation, local transport and hospitality sponsored by Oil & Gas UK, Shell, Chevron, Statoil Hydro, Wood Group, Conoco Phillips, Exxon Mobil, the Norwegian Embassy and OLF. (Registered 11 September 2008) | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-12-10-80ef1083-10552-0 |
2590893e4104da740eb21c4ba4e223406ed7f44c | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2009-12-10-80ef1083-10552-0 |
eb998d8c53420120801b393ab1a36c7494da7f6d | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2009-12-10-80ef1083-10552-0 |
5f372444d78d4cd38bb61409ec9c9abfce2766ad | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2009-12-10-80ef1083-10552-0 |
d2318a1ef301dbdb636f64d2f0ad5da000249eac | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2009-12-10-80ef1083-10552-0 |
ec25fbae865e7133a78f6d9d7207c47a88a20b6f | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2009-12-10-80ef1083-10552-0 |
df245dde300f1154fdf94fae2788802da55baad4 | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 6 | 2009-12-10-80ef1083-10552-0 |
a7514056be58e3d8bc07a158dc63df5d6c65b4f0 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-12-10-4f1e6359-10552-0 |
eb60293c9f21c42227bfa1af22cdb51047e80abc | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-12-10-3aff2389-10552-0 |
12e2c65a55d315d751dbe0baab07453c0a1254cb | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2009-12-10-3aff2389-10552-0 |
7fe911d0fae2fa873ebcc6c8addd2f6b1d329ee6 | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2009-12-10-3aff2389-10552-0 |
34608eac23000744189f26db86cf33787018ded4 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2009-12-10 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2009-12-10-3aff2389-10552-0 |
e8bf408e8f1a373bc7b6b6f2ff152e6094c25e49 | 26-28 August 2008, to Stavanger, Norway to visit Offshore Northern Seas (ONS) conference and exhibition - joint visit by the British Offshore Oil & Gas Industry All Party Parliamentary Group at Westminster and the Oil & Gas Cross Party Group at Holyrood. Overseas flights, hotel accommodation, local transport and hospitality sponsored by Oil & Gas UK, Shell, Chevron, Statoil Hydro, Wood Group, Conoco Phillips, Exxon Mobil, the Norwegian Embassy and OLF. (Registered 11 September 2008) | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-11-25-80ef1083-10552-0 |
3b0d5dc424ca6c812a2ef577b0ce9cba33a6244b | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2009-11-25-80ef1083-10552-0 |
cc1529113f7c7ec88f5ee69832dd7096f777d58d | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2009-11-25-80ef1083-10552-0 |
c3490a238a9b7a1d17c665f892c3de786269c401 | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2009-11-25-80ef1083-10552-0 |
4ec7a81ecba6f2ccdd4992bdf93dbc81fa33ef70 | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2009-11-25-80ef1083-10552-0 |
f988ed4f9a40872f98a10dcb581634ab31a3dcb0 | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2009-11-25-80ef1083-10552-0 |
a117236d3d3c7e036514f15af4262947e03a52cd | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 6 | 2009-11-25-80ef1083-10552-0 |
ac91f9ffc136fe71867b6b433d61d66d4c17f9f5 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-11-25-4f1e6359-10552-0 |
0ca228af73b77bf7fa212e6b83e4955a990b5f78 | Glaxosmithkline; pharmaceuticals. | Registrable shareholdings 3aff2389 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-11-25-3aff2389-10552-0 |
77a2a7f300abad380dc403c105f07a14b5426fed | Legal and General; life assurance. | Registrable shareholdings 3aff2389 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2009-11-25-3aff2389-10552-0 |
a313291c3df36114edb51983b04b0fa68868637b | Rio Tinto; mineral extraction. | Registrable shareholdings 3aff2389 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2009-11-25-3aff2389-10552-0 |
2122df2d4edcf39b160d39768b34eddcbb4a2699 | Shell Transport and Trading; oil-integrated. | Registrable shareholdings 3aff2389 | 2009-11-25 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2009-11-25-3aff2389-10552-0 |
61f889396dfe751eeb0ddb064bddbcda29ff75a7 | 26-28 August 2008, to Stavanger, Norway to visit Offshore Northern Seas (ONS) conference and exhibition - joint visit by the British Offshore Oil & Gas Industry All Party Parliamentary Group at Westminster and the Oil & Gas Cross Party Group at Holyrood. Overseas flights, hotel accommodation, local transport and hospitality sponsored by Oil & Gas UK, Shell, Chevron, Statoil Hydro, Wood Group, Conoco Phillips, Exxon Mobil, the Norwegian Embassy and OLF. (Registered 11 September 2008) | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-11-11-80ef1083-10552-0 |
2c6e031b5034b9a7fc465e3b6df6b7fee7e01c7e | Name of donor: Total E&P UK | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2009-11-11-80ef1083-10552-0 |
6006136f46660c7e6d17e13c1cd721ed0aa4b61a | Address of donor: 33 Cavendish Square, London W1G 0PW | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2009-11-11-80ef1083-10552-0 |
8d298043c03b710a6bd8ad3cd3c6d62908f0efac | Amount of donation (or estimate of the probable value): £1,077 | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2009-11-11-80ef1083-10552-0 |
785edc8b5490d2f758fee848b3c055b74d3d508b | Destination of visit: Lacq, southwest France | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2009-11-11-80ef1083-10552-0 |
c015a51e58c742fb5836998a0c102ecf3cb4be97 | Date of visit: 16-17 July 2009 | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2009-11-11-80ef1083-10552-0 |
1ff7651e4e3ecf79dc9a01d30a66483440e1f93f | Purpose of visit: to visit Total's Carbon Capture and Storage (CCS) demonstration plant in Lacq as a member of the British Offshore Oil and Gas Industry All Party Parliamentary Group. (Registered 20 July 2009) | Overseas visits 80ef1083 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 6 | 2009-11-11-80ef1083-10552-0 |
768617b66365aca5665a58b3179970b2bba454a3 | Farm and cottages in Aberdeenshire, from which rental income is received. | Land and Property 4f1e6359 | 2009-11-11 | Robert Smith uk.org.publicwhip/member/1957 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2009-11-11-4f1e6359-10552-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE items ( hash VARCHAR(40) NOT NULL, item TEXT, category_id TEXT, date TEXT, member_id TEXT, person_id TEXT, sort_order INTEGER, record_id TEXT, PRIMARY KEY (hash), FOREIGN KEY ("category_id") REFERENCES [categories](id), FOREIGN KEY ("member_id") REFERENCES [members](id), FOREIGN KEY ("person_id") REFERENCES [people](id) ); CREATE INDEX items_date ON items("date"); CREATE INDEX items_category_id ON items("category_id"); CREATE INDEX items_member_id ON items("member_id"); CREATE INDEX items_person_id ON items("person_id"); CREATE INDEX items_record_id ON items("record_id");