items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-07-30-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 |
|---|---|---|---|---|---|---|---|
| 213d893abde0f079d8fee82fb07ae63bc124408b | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 0 | 2012-07-30-1f359ece-10401-0 |
| c884c3383acf94670ea2b3751f70a645b6684e7f | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 1 | 2012-07-30-1f359ece-10401-0 |
| 41b4c85f9f19f466e0aea82ad6d2f91803dc5040 | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 2 | 2012-07-30-1f359ece-10401-0 |
| e2d14ee7500415b92ec227f46157ab4d29e37e54 | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 3 | 2012-07-30-1f359ece-10401-0 |
| 80a0052e2b0bfe957fe8ca32fab1793b73ce4e37 | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 4 | 2012-07-30-1f359ece-10401-0 |
| 3d6b9123904629157fd3ef89a600a64ad76c04b5 | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 5 | 2012-07-30-1f359ece-10401-0 |
| 0cd5ab1c60b1773d3d13c9fc3725f8373eed5e8e | 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-07-30 | Denis MacShane uk.org.publicwhip/member/40509 | Denis MacShane uk.org.publicwhip/person/10401 | 6 | 2012-07-30-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");