home / regmem

items

Data source: mySociety Data

9 rows where record_id = "2011-05-03-8f616a6e-10777-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
aee7f15c9bc93e36dc5fb03f32949689a43fffd7 3 July 2009, I attended my local Principal Patrons Club Dinner which raised money for the West Oxfordshire Conservative Association. The following donations of over £1000 were received by the Association; Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 0 2011-05-03-8f616a6e-10777-0
b3aa035612de05008a41463303b60792aab72040 Name of donor: The Marquess of Headfort Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 1 2011-05-03-8f616a6e-10777-0
bff88c01db257b2b08e52b3d490849ab1f6eb559 Amount of donation or nature and value if donation in kind: £1, 250 towards cost of dinner. £500 donation in kind for provision of venue. Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 3 2011-05-03-8f616a6e-10777-0
000332531ed5c309b565c01a42557cc4f90820af Donor status: Individual Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 4 2011-05-03-8f616a6e-10777-0
7477e56dec9659f6b25fa9113d91ee9e58a7432a Name of donor: Mr Nicholas Kaye Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 6 2011-05-03-8f616a6e-10777-0
9e6b76840a8e78c2e14c6b8da29b52eb9a6df170 Address of donor: Private Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 7 2011-05-03-8f616a6e-10777-0
a3c0fa274be154e49afa53c7294bbf2f8dc9d3e8 Amount of donation or nature and value if donation in kind: £1,500 donation towards cost of dinner. Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 8 2011-05-03-8f616a6e-10777-0
3e3311a68678d4f620b4e5d8baa367fd28dfee72 Donor status: Individual. Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 9 2011-05-03-8f616a6e-10777-0
61d3cdc783b9153e6fb05f01a4735a1f97ee17a4 (Registered 21 July 2009) Sponsorships 8f616a6e 2011-05-03 uk.org.publicwhip/member/40665 David Cameron uk.org.publicwhip/person/10777 10 2011-05-03-8f616a6e-10777-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 45.339ms · Data source: mySociety Data