items

Table actions

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

4 rows where record_id = "2000-11-10-84642823-10165-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
ed8260c1b8f12b95057568a016fb61ebb47a6467 26-28 February 1999, two nights accommodation and meals provided by North West Area Association of Conservative Clubs (ACC) at their annual conference at the Windermere Hydro Hotel, Windermere, in my capacity as National Vice-Chairman of the ACC and President of North West Area ACC. (Registered 1 March 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Stephen Day uk.org.publicwhip/member/165 Stephen Day uk.org.publicwhip/person/10165 0 2000-11-10-84642823-10165-0
e91e100fd2ff663962f2461e92308c911c4868f1 25-26 February 2000, two nights accommodation at the Windermere Hydro Hotel, Windermere, during the North West Conservative Clubs Advisory Council Conference, paid for by the Association of Conservative Clubs (ACC) in my capacity as Chairman of the ACC. (Registered 15 March 2000) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Stephen Day uk.org.publicwhip/member/165 Stephen Day uk.org.publicwhip/person/10165 1 2000-11-10-84642823-10165-0
ef7c26efa6807db3f9d33dcf2eefeba8eb831da3 3-4 March 2000, two nights accommodation at the Livermead Cliff Hotel, Torquay, during the Western Area Conservative Clubs Conference, paid for by the ACC in my capacity as Chairman of the ACC. Return travel from London to Torquay also provided. (Registered 15 March 2000) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Stephen Day uk.org.publicwhip/member/165 Stephen Day uk.org.publicwhip/person/10165 2 2000-11-10-84642823-10165-0
dabf4e8617ed31648f1f5d1dc300d60caa7bae56 April 2000, 00 Scale model of Virgin locomotive in "name" West Coast Rail 250 in glass presentation case, presented to me by Virgin Trains in my capacity as joint chairman of West Coast Main Line All-Party Group following the naming ceremony. (Registered 17 May 2000) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Stephen Day uk.org.publicwhip/member/165 Stephen Day uk.org.publicwhip/person/10165 3 2000-11-10-84642823-10165-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");