home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

9 rows where record_id = "2015-01-06-1f359ece-10761-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
00c0abce63c89a09df1f2e9176546bc5c6564f43 Weekly column for The Independent, 2 Derry Street, London W8 5TT (£30,000-£35,000): Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 0 2015-01-06-1f359ece-10761-0
af03a4cc853babd17220c1fc38847f92019a9ce0 Payment of £2,500 received on 21 December 2013. Hours: 8 hrs. (Registered 3 February 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 1 2015-01-06-1f359ece-10761-0
2faeb03ac34064cf76ca14e5218bffa36382d563 Payment of £1,250 received on 21 January 2014. Hours: 4 hrs. (Registered 3 February 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 2 2015-01-06-1f359ece-10761-0
2dd3e553b8481f359004df6069c6e5232bfc26dd Payments from Doubleday/Transworld Publishers, 20 Vauxhall Bridge Road, London SW1V 2SA (Updated 30 September 2014) : Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 3 2015-01-06-1f359ece-10761-0
b56c631b7c4df6da16abb12276522af26da19561 April 2014 received £15,375 as a further advance for a book to be published in 2014. Hours: an additional 40 hrs. (Registered 28 April 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 4 2015-01-06-1f359ece-10761-0
7b3bd2a4917ddc6cd91ece206838f0c32a821e77 Advance of £16,400 for a new book. Hours: 20 hrs. (Registered 30 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 5 2015-01-06-1f359ece-10761-0
1db6e7671fce07727e7f7be9d8273fb00ddd0aa8 Payments from The Guardian, Kings Place, 90 York Way, London N1 9GU: Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 6 2015-01-06-1f359ece-10761-0
05f41b9b79251d5553d19919f0af9a6a4bc95908 Payment of £90 for an article.  Hours: 30 mins. (Registered 30 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 7 2015-01-06-1f359ece-10761-0
c1568429c655190ae3b04f62a8d316d03a358f33 Payment of £450 for an article. Hours: 4 hrs. (Registered 21 October 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Chris Bryant uk.org.publicwhip/member/40497 Chris Bryant uk.org.publicwhip/person/10761 8 2015-01-06-1f359ece-10761-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");
Powered by Datasette · Queries took 15.953ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette