items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2017-02-20-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 |
|---|---|---|---|---|---|---|---|
| 0293fbb0f725d29d525fb19e6ae403ee06492612 | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 0 | 2017-02-20-64e8edeb-24762-0 | |
| 60d175111c6b410c422da6db8365059f7c9062da | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 1 | 2017-02-20-64e8edeb-24762-0 | |
| a20ebbf35d77c6ba8c3a59d30bd77f350040c6cf | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 2 | 2017-02-20-64e8edeb-24762-0 | |
| eb3c1a1487bc5227ce8bdba157964bd131f2c4ef | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 3 | 2017-02-20-64e8edeb-24762-0 | |
| 172a8a551d5fcf614c883a71c0059f60b5365a83 | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 4 | 2017-02-20-64e8edeb-24762-0 | |
| 42bee0f515f0a1b6fac6a4b23fae703ef84aa4f1 | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 5 | 2017-02-20-64e8edeb-24762-0 | |
| 359ad87bea79aff25854b650227a48f427170a36 | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 6 | 2017-02-20-64e8edeb-24762-0 | |
| 35f77699b8af4d764a8e94d285e4152ac7a3f3ec | 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-20 | Michael Dugher uk.org.publicwhip/person/24762 | 7 | 2017-02-20-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");