home / regmem

items

Data source: mySociety Data

8 rows where record_id = "2010-02-24-84642823-11905-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
64ce631f47b6fbdadca0e9d274d30c1516753625 My wife and I received tickets for the Conservative Party's 'Black and White Party' on 4 February 2009, paid for by Mr Charles Barwell, West Midlands. (Registered 4 March 2009) Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 0 2010-02-24-84642823-11905-0
000762984f0fe2067479675699884922d7cbaede Name of donor: John Lewis Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 1 2010-02-24-84642823-11905-0
231828eb24d8a1c5183854116b050ae07a4f8daa Address of donor : private Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 2 2010-02-24-84642823-11905-0
0f12d7f5a21437f7c3de5a20ab26f3be4931cc76 Amount of donation or nature and value if donation in kind: my wife and I received tickets to the Conservative Party's General Election fund raising dinner; value £700 Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 3 2010-02-24-84642823-11905-0
75c5f225e2556184e31f0478f7f7af44395736ee Date of receipt of donation: 1 February 2010 Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 4 2010-02-24-84642823-11905-0
6004105891753e6f3757b3e2beae59b2a007bf90 Date of acceptance of donation: 1 February 2010 Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 5 2010-02-24-84642823-11905-0
588f36c8b316f07ee3e3c1f23646e12d9d20e3e5 Donor status: individual Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 6 2010-02-24-84642823-11905-0
b93d60f800be6deb6e090bcf3d4d52e71d3aaede (Registered 22 February 2010) Gifts, benefits and hospitality (UK) 84642823 2010-02-24 uk.org.publicwhip/member/1905 Ed Vaizey uk.org.publicwhip/person/11905 7 2010-02-24-84642823-11905-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 5.268ms · Data source: mySociety Data