home / regmem

items

Data source: mySociety Data

3 rows where record_id = "2018-01-22-64e8edeb-25330-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0002986840bb08e2b6a8581586e712d48b48f383 Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: ticket to the National Television Awards, including food and drink, value £1,028 Date received: 25 January 2017 Date accepted: 25 January 2017 Donor status: company, registration 4967001 (Registered 30 January 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-01-22 Mims Davies uk.org.publicwhip/person/25330 0 2018-01-22-64e8edeb-25330-0
60cad277a04dc4091246a8496648a131041ffb3b Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation, or nature and value if donation in kind: Two tickets to the Six Nations Rugby, and accompanying hospitality, value £2,012 Date received: 11 March 2017 Date accepted: 11 March 2017 Donor status: company, registration 4967001 (Registered 28 March 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-01-22 Mims Davies uk.org.publicwhip/person/25330 1 2018-01-22-64e8edeb-25330-0
84c9711ca0a802ec9e35518ba8dd10cb53887519 Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-01-22 Mims Davies uk.org.publicwhip/person/25330 2 2018-01-22-64e8edeb-25330-0

Advanced export

JSON shape: default, array, 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)
    )
Powered by Datasette · Query took 69.016ms · Data source: mySociety Data