items

Table actions

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

6 rows where record_id = "2012-10-01-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
587de38b12d9c4edcda7efc9887f872ddd8b86f3 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-01 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 0 2012-10-01-1f359ece-10401-0
4e9465e5d3367da9b90e5f2049f15f59883e7441 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-01 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 1 2012-10-01-1f359ece-10401-0
d0b91c007f64011afd0715c5e96a8b0169c223c4 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-01 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 2 2012-10-01-1f359ece-10401-0
2715bb53b2937553001d70180a431aef66d8df72 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-01 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 3 2012-10-01-1f359ece-10401-0
6f4f1b19a5dc09f23ce113dbe5dd7bcffbf619d8 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-01 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 4 2012-10-01-1f359ece-10401-0
a3d7f397ac9e1217d79408d6fea9f03b921a7ef6 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-01 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 5 2012-10-01-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");