home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2011-03-28-84642823-24935-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
2de6a9d4787fdc582fbbe516dfb83c3cca79289a Name of donor: Marina Dalglish Breast Cancer Charity Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 0 2011-03-28-84642823-24935-0
2adcc8894b988ef9b46549628da47051a2565c95 Address of donor : 78 Seal Street, Liverpool L1 4BH Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 1 2011-03-28-84642823-24935-0
810ea09c5431057eb927b3d2350be6080a2fe756 Amount of donation or nature and value if donation in kind: 2 tickets for a charity ball; total value £700 Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 2 2011-03-28-84642823-24935-0
a3fdacef02541ada532a1e5c81f0b4afb3a54b3b Date of receipt of donation: 5 February 2011 Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 3 2011-03-28-84642823-24935-0
0f9dd831fe5036dcd5c345e1c116afb79776afa5 Date of acceptance of donation: 5 February 2011 Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 4 2011-03-28-84642823-24935-0
71c432d09a7c901c215205ede797b519bce4311d Donor status: charity Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 5 2011-03-28-84642823-24935-0
0004a0382e9d762eeab1ce6d3af43e3ec4ea180d (Registered 11 February 2011) Gifts, benefits and hospitality (UK) 84642823 2011-03-28 uk.org.publicwhip/member/40371 Steve Rotheram uk.org.publicwhip/person/24935 6 2011-03-28-84642823-24935-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 4.836ms · Data source: mySociety Data