items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-84642823-10659-1" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b4bb55cde226e53d1216054a91ae796ec789a45a | Name of donor: Mr Neal O’Kelly | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 0 | 2015-03-30-84642823-10659-1 |
5a67c0845312379ceea606d04442253afdbd00a3 | Address of donor: private | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 1 | 2015-03-30-84642823-10659-1 |
667092ee1ff4e1368c30c148e5a65330aa96e8b7 | Amount of donation or nature and value if donation in kind: £9,000 in sponsoring my golden wedding party on 19 July 2014, for which tickets were sold by the North West Hampshire Conservative Association. | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 2 | 2015-03-30-84642823-10659-1 |
9c15c8a7c24c2d242e5bd1ddea5fce305d54f95c | Date of receipt of donation: 13 July 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 3 | 2015-03-30-84642823-10659-1 |
ba736b42a158e31ef30882f059d9ccb4977d9d23 | Date of acceptance of donation: 19 July 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 4 | 2015-03-30-84642823-10659-1 |
c40f6cbaf07fa9b10138230987d6eb78c6a68d16 | Donor status: individual | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 5 | 2015-03-30-84642823-10659-1 |
c11a71be62a621d1fc7b9dab67bcc6c4d4f4a0c2 | (Registered 4 August 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | George Young uk.org.publicwhip/member/40452 | George Young uk.org.publicwhip/person/10659 | 6 | 2015-03-30-84642823-10659-1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");