home / regmem

items

Data source: mySociety Data

23 rows where record_id = "2010-12-20-9e46def6-10920-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
4a6db169d4bab10b317e373b8fc0326614204d03 Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 0 2010-12-20-9e46def6-10920-0
d2da7c7465d4bc63c36c22f862ac69678d10ffb7 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 1 2010-12-20-9e46def6-10920-0
4838b511cd1f2874af5b53decfab005826e8bae2 Name of donor: Steve and Shirley Boyden Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 2 2010-12-20-9e46def6-10920-0
00043e71d7be539f677b940eaa8278a884e10775 Amount of donation or nature and value if donation in kind: £2,000 as the winning bid in an auction. Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 4 2010-12-20-9e46def6-10920-0
4ddaedd84c65a20705fc9ee1dce73947adcade00 Support in the capacity as an MP: Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 7 2010-12-20-9e46def6-10920-0
9e994b13bad15d997e267e4060027a82d90df7f3 Name of donor: Midland Chilled Foods Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 8 2010-12-20-9e46def6-10920-0
7ca2ec45147b4b24d85dda75cb188cd37358e15b Address of donor: Stringes Lane, Willenhall, WV13 1LX Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 9 2010-12-20-9e46def6-10920-0
3f34e05deb5916c1666b797675540e439f8905f5 Amount of donation or nature and value if donation in kind: £10,000 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 10 2010-12-20-9e46def6-10920-0
8fd9a6890aa54789d6cfb5dc423b20d6a19210b0 Donor status: company, registration number 01104045 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 13 2010-12-20-9e46def6-10920-0
e3d55666033491bfbaf94c48ebd1e524ee2a70be Name of donor: Dev Dadral Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 15 2010-12-20-9e46def6-10920-0
433996fd82cae8db8d075bfe43b76271aed2901c Address of donor: private Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 16 2010-12-20-9e46def6-10920-0
d8dd59790694d87b8a54f9c0d64a6954b576f0a3 Amount of donation or nature and value if donation in kind: £25,000 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 17 2010-12-20-9e46def6-10920-0
24c2ab2fab5e0c7fbb99658b4b3e991c56ce1fb7 Date of receipt: 12 March 2010 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 18 2010-12-20-9e46def6-10920-0
23bd4771357856aa0b3bcca65a4e4f9d6ccdaf1b Date of acceptance: 12 March 2010 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 19 2010-12-20-9e46def6-10920-0
88fbe4e4749e47cf58fea3134c93cf5cd8a6d36a Donor status: individual Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 20 2010-12-20-9e46def6-10920-0
a2cfbc2ccada8f4d763452b3d5bf53ef0efb6d79 (Registered 23 March 2010) Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 21 2010-12-20-9e46def6-10920-0
1dc494c78d37c4abf08a518bf47998d0fe0ffa76 Name of donor: Toyota GB plc Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 22 2010-12-20-9e46def6-10920-0
c8a784d16a5cf6d952668f22d3e2773a7e2e87ee Address of donor: Great Burgh, Burgh Heath, Epsom, Surrey KT18 5QX Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 23 2010-12-20-9e46def6-10920-0
f6b7e792b2f1b25e726448a927d44a13d1bf89f2 Amount of donation or nature and value if donation in kind: sponsorship of constituency reception; value £5,000 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 24 2010-12-20-9e46def6-10920-0
9b77aa95da66d03ad2d6ed794085e9cf95541e08 Date of receipt: 14 July 2010 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 25 2010-12-20-9e46def6-10920-0
b540052a666a2c3de8e80401a39b38317bd31c76 Date of acceptance: 14 July 2010 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 26 2010-12-20-9e46def6-10920-0
34e932dcc930f7c808f8173d3c8b9051bf2fb0f6 Donor status: company, registration number OO916634 Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 27 2010-12-20-9e46def6-10920-0
1464de4c13ac22d4220dfda6950e0e2fdbffd835 (Registered 6 September 2010) Sponsorship or financial or material support 9e46def6 2010-12-20 uk.org.publicwhip/member/40250 Chris Grayling uk.org.publicwhip/person/10920 28 2010-12-20-9e46def6-10920-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 61.234ms · Data source: mySociety Data