items

Table actions

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

5 rows where record_id = "2015-03-09-1f359ece-10658-1" 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
cd70e2ec73efbc262f59161fbd72d62bc33c2bd4 Adviser to Meade Hall & Associates, 1 Meade Mews, Causton Street, London SW1P 4EG, a strategic communications consultancy. I advise on matters relating to the construction of new nuclear power stations in Europe. Remunerated employment, office, profession etc 1f359ece 2015-03-09 Tim Yeo uk.org.publicwhip/member/40554 Tim Yeo uk.org.publicwhip/person/10658 0 2015-03-09-1f359ece-10658-1
113288af416340e96945e99127ace385fe6136bc Payment of £8,000 on 6 October 2014. Hours: 35 hrs. (Registered 14 October 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Tim Yeo uk.org.publicwhip/member/40554 Tim Yeo uk.org.publicwhip/person/10658 1 2015-03-09-1f359ece-10658-1
5bf2bfbe49fd87ac1dec4f8bfc4ed6ba73467b7c Payment of £8,000 on 4 November 2014. Hours: 35 hrs. (Registered 8 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Tim Yeo uk.org.publicwhip/member/40554 Tim Yeo uk.org.publicwhip/person/10658 2 2015-03-09-1f359ece-10658-1
38b952beac9d55a0e69882921cb629c1fc6790dc Payment of £8,000 on 5 December 2014. Hours: 35 hrs. (Registered 8 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Tim Yeo uk.org.publicwhip/member/40554 Tim Yeo uk.org.publicwhip/person/10658 3 2015-03-09-1f359ece-10658-1
a404101698ee92e9748374667c5807a82d6f7fc7 Payment of £8,000 on 12 January 2015. Hours: 35 hrs. (Registered 20 January 2015) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Tim Yeo uk.org.publicwhip/member/40554 Tim Yeo uk.org.publicwhip/person/10658 4 2015-03-09-1f359ece-10658-1

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