items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2015-02-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 |
|---|---|---|---|---|---|---|---|
| 965b9342e89ec59ed49ec69c1586889402cd6112 | Fees for speeches paid by JLA Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 0 | 2015-02-09-1f359ece-10153-1 |
| da1fc3fcf9f8d91f88512f6ba8526c3826fc6131 | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 1 | 2015-02-09-1f359ece-10153-1 |
| 99866f4758e0a34182bb5e3ce18b54b32445000a | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 2 | 2015-02-09-1f359ece-10153-1 |
| 21ee06cde3dfc9716ef1fbe98ffd404a84a599ab | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 3 | 2015-02-09-1f359ece-10153-1 |
| 21eeba0ac2917f901c7d9551067ae5458d93567c | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 4 | 2015-02-09-1f359ece-10153-1 |
| c678970056db53821ea96d88133f9f9f89058439 | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 5 | 2015-02-09-1f359ece-10153-1 |
| f664530eea6c5d29a179a6d798fd0789d99bfce8 | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 6 | 2015-02-09-1f359ece-10153-1 |
| d8929d444d43c1a361df3ab59a8213e6b51a124e | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 7 | 2015-02-09-1f359ece-10153-1 |
| 030bd350f99ba6d285acd646ed9f1da84e656417 | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 8 | 2015-02-09-1f359ece-10153-1 |
| 0522939f24baf439890cb3927da30141e177d1b4 | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 9 | 2015-02-09-1f359ece-10153-1 |
| f647d321801722e78326170bf6af6284150bab1e | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 10 | 2015-02-09-1f359ece-10153-1 |
| fc46948d92f1589654a737e2ce2fbbcc2c80585e | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 11 | 2015-02-09-1f359ece-10153-1 |
| deb18add113adeaccc032a0c31d37a592eb3441e | 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-02-09 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 12 | 2015-02-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");