items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2017-03-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 |
|---|---|---|---|---|---|---|---|
| f36773be59a1d4fbc6e6c2f9c91603aafdf0e070 | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 0 | 2017-03-20-64e8edeb-24762-0 | |
| 8bf5e62d0ddb3aa9f958cb81e5c02334361eb6a5 | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 1 | 2017-03-20-64e8edeb-24762-0 | |
| 949cb9e8a468a732767e1edc536b4ac4fb5b1426 | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 2 | 2017-03-20-64e8edeb-24762-0 | |
| 4acb59cff996be6a0ce1eab0bb812d1cfdc08654 | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 3 | 2017-03-20-64e8edeb-24762-0 | |
| 89ee87c82f3a953c03c1c119c978a20a919a130d | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 4 | 2017-03-20-64e8edeb-24762-0 | |
| babfabb4afc5384655946e7aa1d646ef7a7108ab | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 5 | 2017-03-20-64e8edeb-24762-0 | |
| cf4b2b6e26af3c7ab8801fe846e76b30e393ce3c | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 6 | 2017-03-20-64e8edeb-24762-0 | |
| ba710d62b6c62c9ab50cbdad20c9d8e6309ff0d4 | 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-03-20 | Michael Dugher uk.org.publicwhip/person/24762 | 7 | 2017-03-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");