items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2012-10-22-1f359ece-10401-0" 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 |
|---|---|---|---|---|---|---|---|
| 98d28d4fdf9b3b4a27dd6caa4e87682d71854e08 | Fee of £87 received for article published on 23 September by Comment is Free, The Guardian, Kings Place, 90 York Way, London N1 9GU (Registered 26 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 0 | 2012-10-22-1f359ece-10401-0 |
| 660f78fdc80ff1dd436a81dcb25550589fc584b9 | Fee of £3,405.45 received for speaking at CEO retreat, December 2011, for AT Kearney, 1300 Wilson Boulevard Suite 1550. Arlington, Virginia : 1 hr. (Registered 22 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 1 | 2012-10-22-1f359ece-10401-0 |
| 97f160514c3ec45d8054816053f10ac0ff07954a | Received payment of £8,110.40 (€10,000) from the American University of Kosovo, Germia Campus Nazim Gafurri 21 10,000 Prishtina, for a talk on 31 October 2011. Hours: one hour linked to recent book on Kosovo based on 15 years work on the Balkans region, plus travel time. (Registered 30 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 2 | 2012-10-22-1f359ece-10401-0 |
| 27f9f983cce1c70546e8500b0b451055b7581b94 | Received on 17 February 2012, fee of £500 for profile in New Statesman of Francois Hollande. Hours: between one and five hours, plus 15 years acquaintance with M Hollande and his colleagues. (Registered 20 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 3 | 2012-10-22-1f359ece-10401-0 |
| c8db03c77a65ada1301535f178c64c90cf0dfd47 | Received on 22 April 2010, £150 for article in New Statesman. Address: John Carpenter House, 7 Carmelite Street, London EC4Y OAN. Hours: 1 hr, but based on years of personal contacts and research. (Registered 18 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 4 | 2012-10-22-1f359ece-10401-0 |
| 44e1ddf93e2b083dc7aa03ef8b429f15790c1d05 | Received on 8 May 2012, £750 for five articles written since November 2011 for Yorkshire Post, Wellington Street, Leeds LS1 1RF. Total hours: 6 hrs 30 mins writing, plus 12 hrs research. (Registered 9 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 5 | 2012-10-22-1f359ece-10401-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");