items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2015-03-09-1f359ece-10153-1" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| e7a779dcc1b5f43ac0dc5aa009bc7ac4e9698e68 | Fees for speeches paid by JLA Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 0 | 2015-03-09-1f359ece-10153-1 |
| 2af0a29e98810c1ae26a6f63d509b541789392b1 | 13 March 2014, I received a fee of £11,475 for speaking at the annual meeting of Dunedin Capital Partners, Saltire Court, 20 Castle Terrace, Edinburgh EH1 2EN. Time spent approx. 4 hrs. (Registered 27 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 1 | 2015-03-09-1f359ece-10153-1 |
| cc3e187627c557a53ee294efe4e74fb2feae3b08 | 13 March 2014, I received a fee of £7,650 for speaking at an event organised by FIX Protocol Ltd, 5th floor, 6 St Andrew Street, London EC4A 3AE. Time spent approx. 2 hrs. (Registered 27 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 2 | 2015-03-09-1f359ece-10153-1 |
| 654950d0cd490356cf84458c741bbc7931c6761b | 28 March 2014, I received a fee of £9,840 in respect of speaking at a conference organised by Insight Investment Management Ltd, 160 Queen Victoria Street, London EC4V 4LA . Hours: approx. 4 hrs. (Registered 11 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 3 | 2015-03-09-1f359ece-10153-1 |
| a79ef561f47a2ef5ab5716c27b58c63b22cd1e19 | 12 May 2014 I received a payment of £12,750 in respect of speaking at an event organised by Asset Based Finance Association, 3rd Floor, 20 Hill Rise, Richmond, Surrey, TW10 6VA. Hours: approx. 4 hrs. (Registered 23 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 4 | 2015-03-09-1f359ece-10153-1 |
| 251a66dd5938c27004f0b21d6c6befc4c5f468e0 | 27 May 2014 I received a fee of £10,200 in respect of speaking at an event organised by the Association of Corporate Treasurers, 51 Moorgate, London EC2R 6BH. Hours: approx. 4 hrs. (Registered 6 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 5 | 2015-03-09-1f359ece-10153-1 |
| acf86b79d52632e255892c0531ebe9b0535dbcdd | 8 August 2014 I received a fee of £10,200 in respect of an event organised by Macquarie Bank, Ropemakers Place, 28 Ropemaker Street, London EC2Y 9HD, who also met my travel costs of £230.45. Hours: approx. 6 hrs. (Registered 22 August 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 6 | 2015-03-09-1f359ece-10153-1 |
| 1f1d408af8ac1dbe1af8f2f0bf69f9567284fe3d | 8 October 2014, £12,300 received for speaking at an event organised by ICON Infrastructure LLP, London, address 1st floor, Pollen House, 10/12 Cork Street, London, W1S 3NP. Hours: 4 hrs. (Registered 21 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 7 | 2015-03-09-1f359ece-10153-1 |
| 1425f4247ae09be4a71627da1c48840f6e4b6f7d | 17 November 2014 I received a fee of £10,200 for speaking at an event organised by Scor, 10 Lime Street, London EC3M 7AA. Hours: approx. 4 hrs. (Registered 24 November 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 8 | 2015-03-09-1f359ece-10153-1 |
| 34248a5b91ed176c7ff28b94108ab1d52f7794d2 | 25 November 2014, received a fee of £10,200 for speaking at an event organised by White & Case LLP, 5 Old Broad Street, London EC2N 1DW. Hours: approx. 4 hrs. (Registered 15 December 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 9 | 2015-03-09-1f359ece-10153-1 |
| 7ff7502987db750e6c3107d8d95b6c59c0d29f16 | 19 December 2014, received a fee of £8,500 for speaking at an event organised by Ernst & Young LLP, 1 Bridgewater Place, Water Street, Leeds LS11 5QR, who also met my travel costs of £226 and that of my overnight accommodation, worth £187. Hours: approx 15 hours including travel time. (Registered 23 December 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 10 | 2015-03-09-1f359ece-10153-1 |
| 7a0cc9d5b7a2822fa9b732e02c7221a3fc887f8c | 6 January 2015, received a fee of £6,800 for speaking at an event organised by Citywire, 87 Vauxhall Walk, London SE11 5HJ. Time spent approx: 3 hours. (Registered 3 February 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 11 | 2015-03-09-1f359ece-10153-1 |
| c23b4a4c234b134947ed3b871e2dde881ba606b2 | 23 January 2015, received a fee of £1,700 for writing an article for a magazine published by White & Case LLP, 5 Old Broad Street, London EC2N 1DW. Time spent: approx 4 hours. (Registered 3 February 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 12 | 2015-03-09-1f359ece-10153-1 |
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");