items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-09-03-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 |
|---|---|---|---|---|---|---|---|
| e36e2e767fbdd223a0180b1c201c7bf29d76ef45 | Fee of £150 from Yorkshire Post, Wellington Street, Leeds LS1 1RF, for an article published on 17 August 2011. (Registered 6 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 0 | 2012-09-03-1f359ece-10401-0 |
| 67dd022735a20262bf422771d14d8cc86ea836fb | 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-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 1 | 2012-09-03-1f359ece-10401-0 |
| dd6df0d3a7cd97b64fabcd3afea6a40a7f5f9165 | 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-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 2 | 2012-09-03-1f359ece-10401-0 |
| ffa6f9966abe14c0efb5866c7b320caaed45b146 | 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-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 3 | 2012-09-03-1f359ece-10401-0 |
| e3b0429136f27591c66579ff55c1ae06edb09fcc | 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-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 4 | 2012-09-03-1f359ece-10401-0 |
| 48d90fe9d43a740c9388de4506cf5c4ef2b5c5a4 | 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-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 5 | 2012-09-03-1f359ece-10401-0 |
| 3204f319b0c2a856e3943244950f31e7ad393577 | 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-09-03 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 6 | 2012-09-03-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");