items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2017-02-06-64e8edeb-24762-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 |
|---|---|---|---|---|---|---|---|
| 12d7f17549e7fdd62a7f427a221e51974970776b | Name of donor: The Football Association Premier League Ltd Address of donor: 30 Gloucester Place, London W1U 8PL Amount of donation or nature and value if donation in kind: three tickets and hospitality to watch Barnsley FC at Wembley in the JPT Final, total value £1,008 Date received: 3 April 2016 Date accepted: 3 April 2016 Donor status: company, registration 2719699 (Registered 15 April 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 0 | 2017-02-06-64e8edeb-24762-0 | |
| d78db28ae8d6382c892dfcb750941eb1a1414fa9 | Name of donor: UK Music Address of donor: 4th Floor, 49 Whitehall, London SW1A 2BX Amount of donation or nature and value if donation in kind: ticket and hospitality at the Ivor Novello Awards, value £444 Date received: 19 May 2016 Date accepted: 19 May 2016 Donor status: company, registration no 3245288 (Registered 27 May 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 1 | 2017-02-06-64e8edeb-24762-0 | |
| d02a80ccfc7daf676f4425913ceaa9a06094ff4b | Name of donor: The Yorkshire County Cricket Club Address of donor: Headingley Cricket Ground, Leeds LS6 3DP Amount of donation or nature and value if donation in kind: two tickets and hospitality at Yorkshire County Cricket Club to the value of £200, a total of £400 Date received: 21 May 2016 Date accepted: 21 May 2016 Donor status: company, registration IP28929R (Registered 07 June 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 2 | 2017-02-06-64e8edeb-24762-0 | |
| 4407f86e086592e28de7352428a343248421a5b1 | Name of donor: Football Association Premier League Address of donor: 30 Gloucester Place, London W1U 8PL Amount of donation or nature and value if donation in kind: Ticket and hospitality for a concert at Wembley Stadium, value £259 Date received: 5 June 2016 Date accepted: 5 June 2016 Donor status: company, registration no 2719699 (Registered 13 June 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 3 | 2017-02-06-64e8edeb-24762-0 | |
| e6c96532ea9a994c42f3e300815ffb400acc9728 | Name of donor: Hampshire Cricket Ltd Address of donor: Botley Road, West End, Southampton SO30 3XH Amount of donation or nature and value if donation in kind: two tickets, and accompanying hospitality, to watch cricket at the Ageas Bowl, value for each person £499 plus VAT; £1,197.60 in total Date received: 5 July 2016 Date accepted: 5 July 2016 Donor status: company, registration no 4343355 (Registered 08 July 2016; updated 13 July 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 4 | 2017-02-06-64e8edeb-24762-0 | |
| 89734ac6f5bb5bc1a33c8e0ed20f4173684ed4d5 | Name of donor: UK Music Address of donor: 4th Floor, 49 Whitehall, London SW1A 2BX Amount of donation or nature and value if donation in kind: four tickets to attend a music concert at Wembley Stadium, value £380 Date received: 10 September 2016 Date accepted: 10 September 2016 Donor status: company, registration 3245288 (Registered 20 September 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 5 | 2017-02-06-64e8edeb-24762-0 | |
| f70275e14fa909651acb2c7e13094211f5623498 | Name of donor: The Football Association Premier League Ltd Address of donor: 30 Gloucester Place, London W1U 8PL Amount of donation or nature and value if donation in kind: a ticket and hospitality to watch a football match at the Etihad Stadium, value £268 Date received: 6 December 2016 Date accepted: 6 December 2016 Donor status: company, registration 2719699 (Registered 19 December 2016) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 6 | 2017-02-06-64e8edeb-24762-0 | |
| 15233a502382a00256cb06342fb8fa45d4e6c92d | Name of donor: William Hill PLC Address of donor: Greenside House, 50 Station Road, Wood Green, London N22 7TP Amount of donation or nature and value if donation in kind: three tickets to attend the World Darts Final, total value £750 Date received: 2 January 2017 Date accepted: 2 January 2017 Donor status: company, registration 4212563 (Registered 26 January 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-02-06 | Michael Dugher uk.org.publicwhip/person/24762 | 7 | 2017-02-06-64e8edeb-24762-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");