items

Table actions

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

5 rows where member_id = "uk.org.publicwhip/member/45" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item, category_id, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
0ee9ae79f3a41da3bcd1dda93e95b711f0dadbb9 Office provided by Sheffield City Council at an annual charge of £1000 towards rent and rates, together with a one-off £1000 charge towards adaptation costs. Staff, furniture, telephone and cleaning costs are paid by myself; heating and lighting is provided by the Council. Sponsorship or financial or material support 9e46def6 2001-05-14 Clive Betts uk.org.publicwhip/member/45 Clive Betts uk.org.publicwhip/person/10045 0 2001-05-14-9e46def6-10045-0
726268a1c3362dbc8b14781245ead2e115dc84c6 Office provided by Sheffield City Council at an annual charge of £1000 towards rent and rates, together with a one-off £1000 charge towards adaptation costs. Staff, furniture, telephone and cleaning costs are paid by myself; heating and lighting is provided by the Council. Sponsorship or financial or material support 9e46def6 2000-11-10 Clive Betts uk.org.publicwhip/member/45 Clive Betts uk.org.publicwhip/person/10045 0 2000-11-10-9e46def6-10045-0
cc12085b75ff663d27ffec34ac2df676fd44a47b May 1999, tickets and hospitality at the three play-off finals provided by the Football League. (Registered 22 June 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Clive Betts uk.org.publicwhip/member/45 Clive Betts uk.org.publicwhip/person/10045 0 2000-11-10-84642823-10045-0
eaa813e8c4acf7dae77d85cdb3c663482da15df9 September 1999, during the visit of the Hungarian Parliamentary Football Team to the UK, I received hospitality sponsored by Powergen Ltd., Provident Finance and West Ham FC. (Registered 17 December 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Clive Betts uk.org.publicwhip/member/45 Clive Betts uk.org.publicwhip/person/10045 1 2000-11-10-84642823-10045-0
4a6b86dee0fe1f6a5b1a0382786df85359766fd9 10 September 1999, to Portugal with the Parliamentary Football Team, travel costs met by National Express Ltd., cost of football kit met by Spall Sports. (Registered 17 December 1999) Overseas visits 80ef1083 2000-11-10 Clive Betts uk.org.publicwhip/member/45 Clive Betts uk.org.publicwhip/person/10045 0 2000-11-10-80ef1083-10045-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");