home / regmem

items

Data source: mySociety Data

10 rows where record_id = "2010-11-22-8f616a6e-24901-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
d6fad8e216c8da5b9da439d4c09f3b7ac998cee9 Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 0 2010-11-22-8f616a6e-24901-0
13f1cc1f9dc158e4d6119c9e7718d94fd53f62eb Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 1 2010-11-22-8f616a6e-24901-0
98364f3169358ba77208947140654685401675d6 Name of donor: Mr W D Lyons Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 2 2010-11-22-8f616a6e-24901-0
0001b9d336f9b464cdc4960a735b86075090429c Name of donor: Mr W G Oldfield Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 7 2010-11-22-8f616a6e-24901-0
5c0dc2d9026546e5b0a43e0e84f060e451eb8f59 Amount of donation or nature and value if donation in kind: £5,000 donation (to my constituency party) Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 9 2010-11-22-8f616a6e-24901-0
b92facd873ff9a34b20bf0b055d9f9968b78442b Name of donor: Mr G R Williams Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 12 2010-11-22-8f616a6e-24901-0
40805de6eb8109528cfa28239853eb3a844ecfb4 Address of donor: private Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 13 2010-11-22-8f616a6e-24901-0
6d117de289dd45209dbbfa5bf07e54731ef69758 Amount of donation or nature and value if donation in kind: £3,000 donation (to my constituency party) Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 14 2010-11-22-8f616a6e-24901-0
6ebcd6c99e87e288ff2815bf1bb28b59559d7405 Donor status: individual Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 15 2010-11-22-8f616a6e-24901-0
38c83e90d26ce32b626d444c7a270bb56b742d79 (Registered 28 May 2010) Sponsorships 8f616a6e 2010-11-22 uk.org.publicwhip/member/40660 Steve Brine uk.org.publicwhip/person/24901 16 2010-11-22-8f616a6e-24901-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 24.093ms · Data source: mySociety Data