home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

10 rows where record_id = "2023-10-16-64e8edeb-10505-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
3bdfd8d938e1e51e2eef6738cdd56a8e90d6733d Name of donor: Racecourse Association Ltd Address of donor: Winkfield Road, Ascot SL5 7HX Amount of donation or nature and value if donation in kind: a metal badge entitling the bearer to admittance to certain horse racing meetings in the UK during 2020. The badge is not available for purchase, but its estimated value is between £0 and £1,000 a year, depending on usage. On 23 November 2021, because new badges have not been issued due to the pandemic, I was notified that the current badge can be used throughout 2021 and 2022. Date received: 1 January 2020 - 31 December 2022 Date accepted: 1 January 2020 Donor status: company, registration 93447 (Registered 06 January 2020; updated 30 November 2021) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 0 2023-10-16-64e8edeb-10505-0
bcf1fc79b84cd7c60d99bcefd6096f41b0e7fbf2 Name of donor: Racecourse Association Ltd Address of donor: Winkfield Road, Ascot SL5 7HX Amount of donation or nature and value if donation in kind: a pass entitling the bearer to admittance to certain horse racing meetings in the UK during 2023. The pass is not available for purchase, but its estimated value is between £0 and £1,000 a year, depending on usage. Date received: 1 January 2023 - 31 December 2023 Date accepted: 1 January 2023 Donor status: company, registration 93447 (Registered 23 January 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 1 2023-10-16-64e8edeb-10505-0
402dd733bd1273a66b87aa6117d0d15d33021249 Name of donor: The Jockey Club Address of donor: 75 High Holborn, London WC1V 6LS Amount of donation or nature and value if donation in kind: Hospitality at Cheltenham Racecourse for my wife and me, and a friend, approx. total value £750 Date received: 14-16 March 2023 Date accepted: 14 March 2023 Donor status: company, registration 2909409 (Registered 12 April 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 2 2023-10-16-64e8edeb-10505-0
2f376af2e7195031f741db7b42cbaeb05730490a Name of donor: Hestview Limited Address of donor: 4 Wellington Place, Leeds LS1 4AP Amount of donation or nature and value if donation in kind: Hospitality at Cheltenham racecourse for my wife and me, approx. total value £700 Date received: 15 March 2023 Date accepted: 15 March 2023 Donor status: company, registration 01100741 (Registered 12 April 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 3 2023-10-16-64e8edeb-10505-0
fdca22f8aa4a1dc9e4952ec868008b16d3ac47ee Name of donor: Betting & Gaming Council Address of donor: 1st Floor, 90 Chancery Lane, London WC2A 1EU Amount of donation or nature and value if donation in kind: Hospitality at Cheltenham Racecourse for my wife and me, approx. total value £1,950 Date received: 17 March 2023 Date accepted: 17 March 2023 Donor status: company, registration 12213577 (Registered 12 April 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 4 2023-10-16-64e8edeb-10505-0
e084ca882aff603ebc7a8ef4d8ba4b2b0fd39c7d Name of donor: Racecourse Association Ltd Address of donor: Winkfield Road, Ascot SL5 7HX Amount of donation or nature and value if donation in kind: an entrance pass entitling the bearer to admittance to certain horse racing meetings in the UK during 2023. The pass is not available for purchase, but its estimated value is between £0 and £1,000 a year, depending on usage. Date received: 1 January 2023 - 31 December 2023 Date accepted: 1 January 2023 Donor status: company, registration 93447 (Registered 13 April 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 5 2023-10-16-64e8edeb-10505-0
5ee30726f8a905907f5e39b4ea16a1b36e21e8c8 Name of donor: The Betting and Gaming Council Address of donor: First Floor, 90 Chancery Lane, London WC2A 1EU Amount of donation or nature and value if donation in kind: A reception to mark my birthday at the Rialto, London, value £2,301.13 Date received: 29 March 2023 Date accepted: 29 March 2023 Donor status: company, registration 12213577 (Registered 26 April 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 6 2023-10-16-64e8edeb-10505-0
68f49b6081ea9091154df9e82e3f5d5e6e5ba880 Name of donor: The Jockey Club Address of donor: 75 High Holborn, London WC1V 6LS Amount of donation or nature and value if donation in kind: Hospitality at Aintree Racecourse for my wife and me, approximate total value £1,678 Date received: 15 April 2023 Date accepted: 15 April 2023 Donor status: company, registration 2909409 (Registered 03 May 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 7 2023-10-16-64e8edeb-10505-0
ebfafb97a52701dbabbd3a65b09f5a30d7713d18 Name of donor: Ascot Racecourse Address of donor: Ascot, Berkshire SL5 7JX Amount of donation or nature and value if donation in kind: Two tickets with hospitality to Royal Ascot, value £550 Date received: 22 June 2023 Date accepted: 22 June 2023 Donor status: company, registration 04320977 (Registered 17 July 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 8 2023-10-16-64e8edeb-10505-0
86923cc74e49b45c3ddc6e3ce7801675c16ed725 Name of donor: Sports Information Services Limited Address of donor: Whitehall Avenue, Kingston, Milton Keynes MK10 0AX Amount of donation or nature and value if donation in kind: Two tickets with hospitality to Royal Ascot, value £500 Date received: 23 June 2023 Date accepted: 23 June 2023 Donor status: company, registration 4243307 (Registered 17 July 2023) Gifts, benefits and hospitality from UK sources 64e8edeb 2023-10-16   Laurence Robertson uk.org.publicwhip/person/10505 9 2023-10-16-64e8edeb-10505-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 61.004ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette