home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

7 rows where record_id = "2023-07-10-64e8edeb-11545-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
09884d4df0317268e76c5b89cad0eb7bf8cacb7f Name of donor: Glastonbury Festival Events Ltd Address of donor: Worthy Farm, Pilton, Shepton Mallet, Somerset BA4 4BY Amount of donation or nature and value if donation in kind: Entry for myself, two family members and a staff member to Glastonbury festival as part of a speaking engagement, including a parking pass, total value £1,190 Date received: 24 June 2022 Date accepted: 24 June 2022 Donor status: company, registration 04348175 (Registered 05 July 2022) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 0 2023-07-10-64e8edeb-11545-0
587cdace285155ff878cd6d081e989e81cc0772b Name of donor: Josie Rourke Address of donor: private Amount of donation or nature and value if donation in kind: Ticket to the 30th anniversary Gala Fundraiser for Donmar Warehouse theatre, value £2,500 Date received: 6 November 2021 Date accepted: 6 November 2021 Donor status: individual (Registered 02 December 2022) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 1 2023-07-10-64e8edeb-11545-0
bf84f10f4b8fe8be3ab04a8031128b5349de0253 Name of donor: Young Presidents Organisation Pennine Address of donor: c/o 23 Park Lane, Hale WA15 9JS Amount of donation or nature and value if donation in kind: Travel, accommodation and dinner for me and a staff member, as part of a speaking engagement to North West business leaders, total value £507.34 Date received: 10-11 November 2022 Date accepted: 10 November 2022 Donor status: unincorporated association (Registered 07 December 2022) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 2 2023-07-10-64e8edeb-11545-0
e55e46b605ff6733fe52dca38644ce3cb9a9aa9a Name of donor: Josie Rourke Address of donor: private Amount of donation or nature and value if donation in kind: Two tickets and hospitality for the opening night of As You Like It at Soho Place Theatre, value £190 Date received: 14 December 2022 Date accepted: 14 December 2022 Donor status: individual (Registered 20 December 2022) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 3 2023-07-10-64e8edeb-11545-0
ab5228858ba4da88c9662310c738862ced98229b Name of donor: Royal Shakespeare Company Address of donor: Royal Shakespeare Theatre, Waterside, Stratford-Upon-Avon CV37 6BB Amount of donation or nature and value if donation in kind: Four tickets and hospitality for My Neighbour Totoro at Barbican Theatre, value £350 Date received: 10 January 2023 Date accepted: 10 January 2023 Donor status: other (charity, registration 212481) (Registered 26 January 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 4 2023-07-10-64e8edeb-11545-0
9e7db95feec55b0250937a5194639e9afae7199c Name of donor: Glastonbury Festival Events Ltd Address of donor: Worthy Farm, Pilton, Shepton Mallet, Somerset BA4 4BY Amount of donation or nature and value if donation in kind: Entry and a parking pass for myself and a family member, and access for a staff member to buy a full price ticket to Glastonbury festival, as part of a speaking engagement, total value £735 Date received: 23-26 June 2023 Date accepted: 23 June 2023 Donor status: company, registration 04348175 (Registered 07 July 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 5 2023-07-10-64e8edeb-11545-0
a16757ef15f214ffe87a71aa1aa88a89f7e47d45 Name of donor: PRS for Music Address of donor: 1st Floor, Goldings House, 2 Hays Lane, London SE1 2HB Amount of donation or nature and value if donation in kind: Accommodation, food and travel for myself and a family member during Glastonbury festival, total value £1,162 Date received: 23-26 June 2023 Date accepted: 23 June 2023 Donor status: company, registration 03444246 (Registered 07 July 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-07-10   Ed Miliband uk.org.publicwhip/person/11545 6 2023-07-10-64e8edeb-11545-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Queries took 42.667ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette