home / regmem

items

Data source: mySociety Data

13 rows where record_id = "2011-05-16-8f616a6e-24749-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
2260c3e5ad8de6012ce2b3e4507bf530bc4dc57d Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 0 2011-05-16-8f616a6e-24749-0
940da37f17ad35992dad931faf3fae537558120f Name of donor: Austen Reid Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 1 2011-05-16-8f616a6e-24749-0
9409ba6e156493ff19491bae45655c8dfc654e34 Address of donor: private Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 2 2011-05-16-8f616a6e-24749-0
ffb909f104b885e2d41953ea54af085c90000e1e Donor status: individual Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 4 2011-05-16-8f616a6e-24749-0
851c8e458deb7945f706783091b62f4d54e2022f Name of donor: United and Cecil Club Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 6 2011-05-16-8f616a6e-24749-0
00032dfa1ab2a80879f6c9548339354aefe001a7 Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 7 2011-05-16-8f616a6e-24749-0
f680fe4c502c871c2d0bea8618a48941cbab2cbd Amount of donation or nature and value if donation in kind: £2,500. Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 8 2011-05-16-8f616a6e-24749-0
16185d7ce29085bd03cd86b3b9e31db1f7ced340 Donor status: club Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 9 2011-05-16-8f616a6e-24749-0
8ceb0299a7b83cc66af1b258a46c0ed35a0c425a Name of donor: Metloc Printers Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 11 2011-05-16-8f616a6e-24749-0
f787852ba310f507ef55c13bea038d608ea706c5 Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 12 2011-05-16-8f616a6e-24749-0
f8b9be02d56d807fbaf32b3696c1c418a565d090 Amount of donation or nature and value if donation in kind: £3,000. Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 13 2011-05-16-8f616a6e-24749-0
b7c39d04bc173d4e3f269ec2bc1e78d1bdd1d958 Donor status: company Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 14 2011-05-16-8f616a6e-24749-0
0c37a11f6f2be01850371895971f2d3ff6e640ba (Registered 4 June 2010) Sponsorships 8f616a6e 2011-05-16 uk.org.publicwhip/member/40540 Stephen Metcalfe uk.org.publicwhip/person/24749 15 2011-05-16-8f616a6e-24749-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 10.028ms · Data source: mySociety Data