items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2015-02-23-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 |
|---|---|---|---|---|---|---|---|
| 6fcd77f63e5cd595244dc52590ab56069ffb5128 | Fees for speeches paid by JLA Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2015-02-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 0 | 2015-02-23-1f359ece-10153-1 |
| 3550755aa08bd6722b7ffe2818b49d43f9606d7f | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 1 | 2015-02-23-1f359ece-10153-1 |
| 870de1bdaaf6cb980fe24a6ec879dd4e88efec9a | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 2 | 2015-02-23-1f359ece-10153-1 |
| b4d0cd473ff783f8ba264096fd0b497934da20f9 | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 3 | 2015-02-23-1f359ece-10153-1 |
| c466c8d9e3babad1f21dee6178c8a8d0315501f9 | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 4 | 2015-02-23-1f359ece-10153-1 |
| e7b66fa805e9734d4c75b11e4dc15efda56f79c1 | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 5 | 2015-02-23-1f359ece-10153-1 |
| fbc319bba624ffe0d87292a562cd67a7c3f7c219 | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 6 | 2015-02-23-1f359ece-10153-1 |
| 1737d2ef3abaf34d968118d1e5982e413b1209de | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 7 | 2015-02-23-1f359ece-10153-1 |
| bbee31497aa4e9d6d034b10c816db4c1eafc54ad | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 8 | 2015-02-23-1f359ece-10153-1 |
| 6aa5dc00bd366f2e6395dfabbe51b3973f27814b | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 9 | 2015-02-23-1f359ece-10153-1 |
| ad3b35f4c6a701a0778ff0c9e6ef668109d85605 | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 10 | 2015-02-23-1f359ece-10153-1 |
| 832789ab7a70f7d771bc7cf99568e00e1062a21e | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 11 | 2015-02-23-1f359ece-10153-1 |
| d898b33acce4c2ee8351227983b548177b7fec70 | 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-23 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 12 | 2015-02-23-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");