home / regmem

items

Data source: mySociety Data

3 rows where record_id = "2009-12-10-84642823-10290-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
00063100d0ea5ec46174a2062495e95afb491dd7 I receive honorary membership of the Carlton Club. (Registered 6 November 2008) Gifts, benefits and hospitality (UK) 84642823 2009-12-10 uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 0 2009-12-10-84642823-10290-0
f862d6d65ddc1ca2541c52023005d023e21fdedb My wife and I received tickets for the Conservative Party's 'Black and White Party' on 4 February 2009, paid for by Lord Marland. (Registered 10 March 2009) Gifts, benefits and hospitality (UK) 84642823 2009-12-10 uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 1 2009-12-10-84642823-10290-0
d3e47a93fc50d878cf820e473b1056ba58b66791 I receive honorary membership of Buck's Club. (Registered 13 March 2009) Gifts, benefits and hospitality (UK) 84642823 2009-12-10 uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 2 2009-12-10-84642823-10290-0

Advanced export

JSON shape: default, array, 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)
    )
Powered by Datasette · Query took 4.19ms · Data source: mySociety Data