home / regmem

items

Data source: mySociety Data

16 rows where record_id = "2013-11-11-8f616a6e-11377-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
2a486d95d9b88fc974ccdba1d1e45a4861ad2374 Support in the capacity as an MP: Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 0 2013-11-11-8f616a6e-11377-0
0002c63905f397b4a7b1bfb429cd8784785cc3b5 Financial support towards my office costs from the following: Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 1 2013-11-11-8f616a6e-11377-0
1e9851d755bab25e162600d3380053c665d8daf5 Name of donor: John Chatfeild-Roberts Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 2 2013-11-11-8f616a6e-11377-0
a571b810e544ce270ecf132db2673b435f9f286e Address of donor: private Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 3 2013-11-11-8f616a6e-11377-0
0dfd0cad794566d782df22bc0616040394ca8418 Amount of donation or nature and value if donation in kind: £5,000 for financial support towards office costs Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 4 2013-11-11-8f616a6e-11377-0
b5748ef978549dd4849de43248d0c142d0e6e0d7 Date of receipt: 18 June 2013 Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 5 2013-11-11-8f616a6e-11377-0
90048c282d3d79b8436e0ac1fe45cbd9bffd81c5 Date of acceptance: 20 June 2013 Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 6 2013-11-11-8f616a6e-11377-0
d9539562d24f39bd6fba43b9ab11e443a7c16d45 Donor status: individual Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 7 2013-11-11-8f616a6e-11377-0
18c3642b57450fe0c488258325b230fc9432061b (Registered 19 July 2013) Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 8 2013-11-11-8f616a6e-11377-0
0882879e060bb10216f65978bd49ed423b12dc28 Name of donor: Philip Hulme Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 9 2013-11-11-8f616a6e-11377-0
e84fd3ecaf92fa13ff36aefe090756860953d354 Address of donor: private Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 10 2013-11-11-8f616a6e-11377-0
cc5c6107bde401be680c42c9814bb2786f27cd86 Amount of donation or nature and value if donation in kind: £10,000 Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 11 2013-11-11-8f616a6e-11377-0
a02b4e6d77f1f83ea1b9cde1aa18c35c8975119e Date of receipt: 18 January 2013 Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 12 2013-11-11-8f616a6e-11377-0
6061569fcf5ad6bb1f7e96ecbfc6a2564f63a086 Date of acceptance: 22 January 2013 Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 13 2013-11-11-8f616a6e-11377-0
8cb45b0e151fffb56bd543a451abc1f13e9a91d9 Donor status: individual Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 14 2013-11-11-8f616a6e-11377-0
b84d3538e320e129b786778cac596a3622023439 (Registered 23 January 2013) Sponsorships 8f616a6e 2013-11-11 uk.org.publicwhip/member/40047 Nick Herbert uk.org.publicwhip/person/11377 15 2013-11-11-8f616a6e-11377-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 72.186ms · Data source: mySociety Data