home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2015-03-30-8f616a6e-24847-1" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
000379965af828d8ba25088784b6f81d203c450e Name of donor: CARE (Christian Action Research and Education) Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 0 2015-03-30-8f616a6e-24847-1
15572fd22d88a023136b18dddd55fd6867276c9b Address of donor: 53 Romney St, London SW1P 3RF Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 1 2015-03-30-8f616a6e-24847-1
299291d22941869c84ec90f68a1b8090dd860643 Amount of donation or nature and value if donation in kind: Four days a week voluntary service from October 2013 to July 2014 provided by a volunteer intern who is self funding except for a bursary of £7,150 as a member of the educational leadership programme at the charity CARE. Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 2 2015-03-30-8f616a6e-24847-1
ec8c030663d397ca3da9b0fcb2fd6eb1f4a685a0 Date of receipt: 22 October 2013 Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 3 2015-03-30-8f616a6e-24847-1
c1b66d2475c488e578d4ed83b26560d86287ea45 Date of acceptance: 22 October 2013 Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 4 2015-03-30-8f616a6e-24847-1
816d1e0d7626ab5b74279a361f7e03a4117d3343 Donor status: company, registration 3481417 Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 5 2015-03-30-8f616a6e-24847-1
36db1ed45f0f1b8b8ca8dad4fb5da22bc8b5103b (Registered 30 October 2013) Sponsorships 8f616a6e 2015-03-30 uk.org.publicwhip/member/40380 Gavin Shuker uk.org.publicwhip/person/24847 6 2015-03-30-8f616a6e-24847-1

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 28.805ms · Data source: mySociety Data