items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2015-03-30-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 |
|---|---|---|---|---|---|---|---|
| e01a2ab4d223195c3cab469c65e2e580d0d4dd9e | Fees for speeches paid by JLA Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 0 | 2015-03-30-1f359ece-10153-1 |
| ae9ae29efec555507b61923db1bd24ac30851201 | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 1 | 2015-03-30-1f359ece-10153-1 |
| 9527792a19a7264250dc8c64f26c4db18ffb63c9 | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 2 | 2015-03-30-1f359ece-10153-1 |
| 30b6c48bd69f9336bc1fcd6b380ee77e3e3692b5 | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 3 | 2015-03-30-1f359ece-10153-1 |
| 74fb4bf88fcc906a43f79f15a368371544515759 | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 4 | 2015-03-30-1f359ece-10153-1 |
| aa6be0cf0ea374c113f64196b3a117e0ad7224ac | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 5 | 2015-03-30-1f359ece-10153-1 |
| 96c44ab53ee8f1914df6401202b3ff6fde6a666d | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 6 | 2015-03-30-1f359ece-10153-1 |
| 03749f6a20e06414c36416541077c570fd531782 | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 7 | 2015-03-30-1f359ece-10153-1 |
| bc1d5da0be1096835a06351c8a600ab2ea418008 | 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-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 8 | 2015-03-30-1f359ece-10153-1 |
| 324d1377596d00be0f16d2e57ceaf76a5b9981a6 | 6 January 2015, received a fee of £6,800 for speaking at an event organised by Citywire, 87 Vauxhall Walk, London SE11 5HJ. Hours: approx. 3 hrs. (Registered 3 February 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 9 | 2015-03-30-1f359ece-10153-1 |
| 1c5f55d152d2e32da7b0d56b3dad27d3d6957896 | 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. Hours: approx. 4 hrs. (Registered 3 February 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 10 | 2015-03-30-1f359ece-10153-1 |
| 406a3f2c9085eb49c952bbc92cbf57a45177fed3 | 16 March 2015, received a fee of £8,500 for speaking at an event organised by JP Morgan Securities PLC, 25 Bank Street, Canary Wharf, London E14 5JP. Hours: approx. 3 hrs. (Registered 27 March 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Alistair Darling uk.org.publicwhip/member/40241 | Alistair Darling uk.org.publicwhip/person/10153 | 11 | 2015-03-30-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");