items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2014-11-24-84642823-11924-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
cac0d6c63a5819237570f05f9889748a01b02f49 | Amount of donation or nature and value if donation in kind: pass & hospitality at Aintree Racecourse on 5 April 2014, at a value of £580 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 2 | 2014-11-24-84642823-11924-0 |
5a95e703ba8e4212e71b35ab1455e3adf8199784 | Date of receipt of donation: 12 March 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 3 | 2014-11-24-84642823-11924-0 |
da48ebc8f935d80c030a2a6d9d37df2ac9edff77 | Date of acceptance of donation: 17 March 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 4 | 2014-11-24-84642823-11924-0 |
883c687781d447891e3dd92076280ab49212dac9 | (Registered 26 June 2014 together with hospitality received on 5 June 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 6 | 2014-11-24-84642823-11924-0 |
a6809bbffe4ca3e8ec1b524a48d5877746093c08 | Name of donor: The Jockey Club | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 7 | 2014-11-24-84642823-11924-0 |
36c5d496974010e83337e64ec6a0cdb355f52436 | Address of donor: 75 High Holborn, London WC1V 6LS | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 8 | 2014-11-24-84642823-11924-0 |
1d0b7ce96d19de0dc3882d830936a41933f700e4 | Amount of donation or nature and value if donation in kind: dinner on 5 June 2014, at a value of £155 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 9 | 2014-11-24-84642823-11924-0 |
2e36b7d1f1c683c14d3e640bf8e9b855a1c0cf00 | Date of receipt of donation: 22 May 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 10 | 2014-11-24-84642823-11924-0 |
ef49f41f5e3179dcaff94ab468ee4db3f13db36d | Date of acceptance of donation: 29 May 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 11 | 2014-11-24-84642823-11924-0 |
ac15c71b9be86521e672fc856c25e369635fd03c | Donor status: company, registration RC000287 | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 12 | 2014-11-24-84642823-11924-0 |
8887ac68f63171858bc01fc7726df0149db72a16 | (Registered 26 June 2014 together with hospitality received on 5 April 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 13 | 2014-11-24-84642823-11924-0 |
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");