items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

7 rows where record_id = "2012-07-09-1f359ece-10401-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
38f262ae61dbaafad3c62ccc05d5c810b80b534f 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 0 2012-07-09-1f359ece-10401-0
307f8acedb333a677c684445422bd52b69ef8d9a 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 1 2012-07-09-1f359ece-10401-0
55727023b7e89bc227d8c466637ca94f2f028942 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 2 2012-07-09-1f359ece-10401-0
a86e20cfa0ed2aee8daf6fb9d82ddefe1b8f9fdf 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 3 2012-07-09-1f359ece-10401-0
398105fd81b0df28fa91a386bb8f80da42ec478c 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 4 2012-07-09-1f359ece-10401-0
b28e2c7124870ed9e056be6c2e34c2c52f92ec7a 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 5 2012-07-09-1f359ece-10401-0
e113f458f955beb8359341600018e2ea2b7f750e 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-09 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 6 2012-07-09-1f359ece-10401-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");