items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

7 rows where record_id = "2014-10-13-84642823-10648-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
203b8f42cdcf8986b7799569ed1e9e72ba9ea0fa Name of donor: Grand Central Railway Company Ltd Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 0 2014-10-13-84642823-10648-0
54a741f7fa2fabdb824006cff73b1091064e90a0 Address of donor: River House, 17 Museum Street, York YO1 7DJ Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 1 2014-10-13-84642823-10648-0
c56e164dbfc9448aee4033cbcbb180d2affcb5e7 Amount of donation or nature and value if donation in kind: Complimentary first class pass valid for travel on Grand Central services, expired 31 December 2011. The estimated value of the pass was £1,000. I used the card on two occasions in December 2011 to the value of £160. Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 2 2014-10-13-84642823-10648-0
de0f644881c5c9a263f27aeb9da2af7cc57ec929 Date of receipt of donation: June 2010 Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 3 2014-10-13-84642823-10648-0
073e223d561dd834d6b3f11512f44a594c642b96 Date of acceptance of donation: June 2010 Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 4 2014-10-13-84642823-10648-0
1d40c749b22c444271d8bfc15c35e09ee4cc9d16 Donor status: company, registration 03979826 Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 5 2014-10-13-84642823-10648-0
1398235a59b890d4c9f7e7a323be4fbe0bfd3943 (Registered 28 February 2011) Gifts, benefits and hospitality (UK) 84642823 2014-10-13 Rosie Winterton uk.org.publicwhip/member/40207 Rosie Winterton uk.org.publicwhip/person/10648 6 2014-10-13-84642823-10648-0

Advanced export

JSON shape: default, array, newline-delimited, 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)
    );
CREATE INDEX items_date ON items("date");
CREATE INDEX items_category_id ON items("category_id");
CREATE INDEX items_member_id ON items("member_id");
CREATE INDEX items_person_id ON items("person_id");
CREATE INDEX items_record_id ON items("record_id");