items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-06-25-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 |
|---|---|---|---|---|---|---|---|
| 053e0e5e2bd363281c0c81cb0e9271bc6f173b82 | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 0 | 2012-06-25-1f359ece-10401-0 |
| c27ddb7cdcfb1bb6a3959ee0d0dd970f28db0513 | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 1 | 2012-06-25-1f359ece-10401-0 |
| 5d4a9144128db088885265e04a013531f1a1da12 | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 2 | 2012-06-25-1f359ece-10401-0 |
| 7348ffa182e99b8f33b90baec301a1b1cadf3bd4 | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 3 | 2012-06-25-1f359ece-10401-0 |
| 36ad8150fc59159d9fa40f804f85c6420f37b386 | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 4 | 2012-06-25-1f359ece-10401-0 |
| c9e28c84fb2ce8c4778a864e1a22df1365b9a93c | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 5 | 2012-06-25-1f359ece-10401-0 |
| f4b8e277f350c46802df87bd5288915d022bf556 | 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-06-25 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 6 | 2012-06-25-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");