items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2015-01-06-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 |
---|---|---|---|---|---|---|---|
7e5825b2ff816336ba6ba554ba90ec729eb206f3 | 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 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 2 | 2015-01-06-84642823-11924-0 |
e24b09e1a99acb02a60a6d46d89278d7873920dc | Date of receipt of donation: 12 March 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 3 | 2015-01-06-84642823-11924-0 |
44dbbf5da92e6a70ba84e1db866e6ad64802a8da | Date of acceptance of donation: 17 March 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 4 | 2015-01-06-84642823-11924-0 |
b6046e4ed7b28301c38667eb73cb345deb788428 | (Registered 26 June 2014 together with hospitality received on 5 June 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 6 | 2015-01-06-84642823-11924-0 |
f71bdcab7316738f49df03d5d4a245eb471ae50e | Name of donor: The Jockey Club | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 7 | 2015-01-06-84642823-11924-0 |
3dd2a8a062b72a769155eb530852d6243ee47a0c | Address of donor: 75 High Holborn, London WC1V 6LS | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 8 | 2015-01-06-84642823-11924-0 |
8d3222a8d009b870fbb03477ec1523f5824b7e6d | 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 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 9 | 2015-01-06-84642823-11924-0 |
5c82b00ff8dc61785f1a0d58a3e2bb1b7cae40a1 | Date of receipt of donation: 22 May 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 10 | 2015-01-06-84642823-11924-0 |
4fc57f7d55dcce55268735c1c553fd068a5c7626 | Date of acceptance of donation: 29 May 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 11 | 2015-01-06-84642823-11924-0 |
889320d898168cc3d719b63b48fffdd1585477fc | Donor status: company, registration RC000287 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 12 | 2015-01-06-84642823-11924-0 |
1484cb5ff8b0555fd2764eed7a66a0caad47abae | (Registered 26 June 2014 together with hospitality received on 5 April 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 13 | 2015-01-06-84642823-11924-0 |
4ea8f6e43d99f2242b749a0deff14dc72d64c289 | Amount of donation or nature and value if donation in kind: 2 tickets for a Six Nations rugby game in March 2014, preceded by reception and lunch; total value £600 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 16 | 2015-01-06-84642823-11924-0 |
c97c35e36209435465ebc014352132f6f48b4801 | Date of receipt of donation: 30 January 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 17 | 2015-01-06-84642823-11924-0 |
7cb42c2ee36f0c25bea1c036ea09e2dbe65474aa | Date of acceptance of donation: 2 February 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 18 | 2015-01-06-84642823-11924-0 |
d6657432bad6bc7b30167807185e6d6aa70861bf | (Registered 18 December 2014 together with invitation received on 23 September 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 20 | 2015-01-06-84642823-11924-0 |
1465a713ba7d6703d4fd7f3b1068b5c1b3c2fbd0 | Name of donor: Merlin Entertainments Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 21 | 2015-01-06-84642823-11924-0 |
cc11830ad64e50af69ba380a3851b37cc1430d7b | Address of donor: 3 Market Close, Poole BH15 1NQ | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 22 | 2015-01-06-84642823-11924-0 |
3e56b4f26615d10419c7b3ea54ec62fd12ec82c0 | Amount of donation or nature and value if donation in kind: 2 tickets for a Six Nations rugby game in November 2014, preceded by reception and lunch; total value £600 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 23 | 2015-01-06-84642823-11924-0 |
a4b1d8cacfcaae8b61501a310587b064943d7f1c | Date of receipt of donation: 23 September 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 24 | 2015-01-06-84642823-11924-0 |
5d2953b26fa42da0890fb9c8312af691887b6645 | Date of acceptance of donation: 28 September 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 25 | 2015-01-06-84642823-11924-0 |
cd8e8bd252e08a20f8e8eaa9b72df4dd7ab1eaf8 | Donor status: company, registration 03663168 | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 26 | 2015-01-06-84642823-11924-0 |
33dacf258f2a9d953d99b242ccf55fe21270a42f | (Registered 18 December 2014 together with invitation received on 30 January 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-01-06 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 27 | 2015-01-06-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");