items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2019-10-21-64e8edeb-10040-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 | 
|---|---|---|---|---|---|---|---|
| 6bab1e67cb8251f5186f1b8e8871678608679aad | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 20 September 2018, with associated hospitality; total value £340 Date received: 20 September 2018 Date accepted: 20 September 2018 Donor status: individual (Registered 04 October 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2019-10-21-64e8edeb-10040-0 | |
| 316cc10ad9a9d77c78196ba8fed2c07d8cb5faf1 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 22 October 2018, with associated hospitality; total value £340 Date received: 22 October 2018 Date accepted: 22 October 2018 Donor status: individual (Registered 24 October 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2019-10-21-64e8edeb-10040-0 | |
| 2acdb8f08635d42fa5b7826ddd4b6e2d51186b70 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 3 November 2018, with associated hospitality; total value £340 Date received: 3 November 2018 Date accepted: 3 November 2018 Donor status: individual (Registered 06 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2019-10-21-64e8edeb-10040-0 | |
| e155da8260d7d1c0ad89e1890454321258854e0c | Name of donor: Chelsea Football Club Ltd Address of donor: Stamford Bridge, Fulham Road, London SW6 1HS Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 4 November 2018, with associated hospitality; total value £440 Date received: 4 November 2018 Date accepted: 4 November 2018 Donor status: company, registration 01965149 (Registered 06 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2019-10-21-64e8edeb-10040-0 | |
| 69b9bfd1596ec00322d36ce0145ec65f3ac1a557 | Name of donor: National Football League Ltd Address of donor: 8th Floor, 30 Panton St, London SW1Y 4AJ Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 14 October 2018, estimated value £800 Date received: 14 October 2018 Date accepted: 14 October 2018 Donor status: company, registration 02777555 (Registered 07 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2019-10-21-64e8edeb-10040-0 | |
| d1f1417158bfcead8f892f90d09fbf48415a54dc | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 8 November 2018, with associated hospitality; total value £340 Date received: 8 November 2018 Date accepted: 8 November 2018 Donor status: individual (Registered 13 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 5 | 2019-10-21-64e8edeb-10040-0 | |
| b1de60146a069191df211982381f2312ebbe00c0 | Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Sunday 11 November 2018, total value £144 Date received: 11 November 2018 Date accepted: 11 November 2018 Donor status: unincorporated association (Registered 22 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2019-10-21-64e8edeb-10040-0 | |
| b6051b57f76bbc78d994b6a525cacffc97811b5f | Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Tuesday 13 November 2018, total value £144 Date received: 13 November 2018 Date accepted: 13 November 2018 Donor status: unincorporated association (Registered 22 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 7 | 2019-10-21-64e8edeb-10040-0 | |
| e60163733c915f9bae6903227d032ba6cefb3e6c | Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Wednesday 14 November 2018, and associated hospitality, estimated total value £244 Date received: 14 November 2018 Date accepted: 14 November 2018 Donor status: unincorporated association (Registered 22 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2019-10-21-64e8edeb-10040-0 | |
| de1978e583cd2e23a2162a08a11db6d4a39d56fc | Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Thursday 15 November 2018, and associated hospitality; estimated total value £244 Date received: 15 November 2018 Date accepted: 15 November 2018 Donor status: unincorporated association (Registered 22 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 9 | 2019-10-21-64e8edeb-10040-0 | |
| b951272a81bc488b575c518e3107ff18320728fc | Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Saturday 17 November 2018, and associated hospitality; estimated total value £360 Date received: 17 November 2018 Date accepted: 17 November 2018 Donor status: unincorporated association (Registered 22 November 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 10 | 2019-10-21-64e8edeb-10040-0 | |
| e974cc3010086f2a7b03e7afb72b474d760abd94 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 2 December 2018, with associated hospitality; total value £340 Date received: 2 December 2018 Date accepted: 2 December 2018 Donor status: individual (Registered 10 December 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2019-10-21-64e8edeb-10040-0 | |
| 3ff19b3a0b8c8b9a4efa3b651b5a4d4caa855c98 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 19 December 2018, with associated hospitality; total value £340 Date received: 19 December 2018 Date accepted: 19 December 2018 Donor status: individual (Registered 24 December 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 12 | 2019-10-21-64e8edeb-10040-0 | |
| 21cf9856f3f6fdb2f2593465f6677210a521bed1 | Name of donor: Arsenal Football Club Address of donor: Highbury House, 75 Drayton Park, London N5 1BU Amount of donation or nature and value if donation in kind: Two tickets to attend a football match on 1 January 2019, and associated hospitality; total estimated value £500 Date received: 1 January 2019 Date accepted: 1 January 2019 Donor status: company, registration 00109244 (Registered 04 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 13 | 2019-10-21-64e8edeb-10040-0 | |
| ef2e0b20833fdbac701e8fdf1dcd4c08c1220069 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 19 January 2019, with associated hospitality; total value £340 Date received: 19 January 2019 Date accepted: 19 January 2019 Donor status: individual (Registered 22 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 14 | 2019-10-21-64e8edeb-10040-0 | |
| 62467a48a494aab3520597a5411aed174008966a | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 25 January 2019, with associated hospitality; total value £340 Date received: 25 January 2019 Date accepted: 25 January 2019 Donor status: individual (Registered 29 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 15 | 2019-10-21-64e8edeb-10040-0 | |
| d95e5271ae1a8043fc4e447d9eb0960d8b27c0b4 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 24 February 2019, with associated hospitality; total value £340 Date received: 24 February 2019 Date accepted: 24 February 2019 Donor status: individual (Registered 06 March 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 16 | 2019-10-21-64e8edeb-10040-0 | |
| d8e4616ad641c9f896ba85756a593fa9009dee8e | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 10 March 2019, with associated hospitality; total value £340 Date received: 10 March 2019 Date accepted: 10 March 2019 Donor status: individual (Registered 12 March 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 17 | 2019-10-21-64e8edeb-10040-0 | |
| 0e59f9ed13116aa691b72d59f41cc2811f83b6db | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 11 April 2019, with associated hospitality; total value £340 Date received: 11 April 2019 Date accepted: 11 April 2019 Donor status: individual (Registered 17 April 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 18 | 2019-10-21-64e8edeb-10040-0 | |
| f90ac8b7c47608b99a78b77be4d37530b3461d02 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 21 April 2019, with associated hospitality; total value £340 Date received: 21 April 2019 Date accepted: 21 April 2019 Donor status: individual (Registered 24 April 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 19 | 2019-10-21-64e8edeb-10040-0 | |
| df725d12827689de8cfedf102aab382f14e28400 | Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 2 May 2019, with associated hospitality; total value £340 Date received: 2 May 2019 Date accepted: 2 May 2019 Donor status: individual (Registered 08 May 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 20 | 2019-10-21-64e8edeb-10040-0 | |
| 394f0c17b6c1c541790cfc0d03ca67e6df73d707 | Name of donor: The Queens Club Address of donor: Palliser Road, London W14 9EQ Amount of donation or nature and value if donation in kind: two tickets to attend the Queens' Club Championships, with associated hospitality on 19 and 23 June 2019, combined value £640 Date received: 19 and 23 June 2019 Date accepted: 19 and 23 June 2019 Donor status: company, registration 23072 (Registered 28 June 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 21 | 2019-10-21-64e8edeb-10040-0 | |
| 2a1e2843029a93e2068b9fa64680153b94e87836 | Name of donor: Queens University, Belfast Address of donor: University Road, Belfast BT7 1NN Amount of donation, or nature and value if donation in kind: accommodation, travel and hospitality to a value of £499, associated with giving a talk at Queens University Belfast Date received: 6 - 7 June 2019 Date accepted: 6 June 2019 Donor status: other (Registered 02 July 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 22 | 2019-10-21-64e8edeb-10040-0 | |
| e17cf71795754c26239dc980dc3fb15d0a617e1a | Name of donor: Barry Cowan Address of donor: private Amount of donation or nature and value if donation in kind: two tickets to attend the Championships at Wimbledon, estimated value £450 Date received: 14 July 2019 Date accepted: 14 July 2019 Donor status: individual (Registered 16 July 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 23 | 2019-10-21-64e8edeb-10040-0 | |
| 18348e917c3828eab8b8585e2ce57771fb5cfa5d | Name of donor: Salt'n'Sauce Promotions Address of donor: 5 York Place, Edinburgh EH1 3EB Amount of donation or nature and value if donation in kind: hotel accommodation, travel and hospitality associated with two appearances to speak about Parliament at the Edinburgh Fringe, total value £1,170.73 Date received: 13-14 August 2019 Date accepted: 13 August 2019 Donor status: company, registration SC174688 (Registered 05 September 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 24 | 2019-10-21-64e8edeb-10040-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");