home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

6 rows where record_id = "2023-08-07-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
6ed78476ba7610fed453f89f1618962ca3b77021 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-08-07   Ed Miliband uk.org.publicwhip/person/11545 0 2023-08-07-64e8edeb-11545-0
a85c835a11317a146bcb3e324f2cd9abd0cd57ec 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-08-07   Ed Miliband uk.org.publicwhip/person/11545 1 2023-08-07-64e8edeb-11545-0
337edfc8fdb92b1bb620e4df6e5d8c17ca4a816c 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-08-07   Ed Miliband uk.org.publicwhip/person/11545 2 2023-08-07-64e8edeb-11545-0
1d7c42b37510c08f3d2282137a09f4bd990cf4f7 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-08-07   Ed Miliband uk.org.publicwhip/person/11545 3 2023-08-07-64e8edeb-11545-0
6594adf106a76dc1a5e51bfbdc05544aeda5a6e9 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-08-07   Ed Miliband uk.org.publicwhip/person/11545 4 2023-08-07-64e8edeb-11545-0
bdaba72f6b9ff59f7e6a74acc575f723f8b31da0 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-08-07   Ed Miliband uk.org.publicwhip/person/11545 5 2023-08-07-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 14.226ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette