home / regmem

items

Data source: mySociety Data

4 rows where record_id = "2011-03-28-3aff2389-10023-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0001ae9fab6a4966e9a5915ff76beef25a2a8680 Petroquest Ltd (owns shares in Westminster Oil Limited) Registrable shareholdings 3aff2389 2011-03-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 0 2011-03-28-3aff2389-10023-0
f7a4002542a516bc41955bae86a66597121a2318 Mastermailer plc; supplier of secure stationery Registrable shareholdings 3aff2389 2011-03-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 1 2011-03-28-3aff2389-10023-0
f66398e8f238a1acadfdf1cf39b7778010c20ab7 Woburn Energy plc. Registrable shareholdings 3aff2389 2011-03-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 2 2011-03-28-3aff2389-10023-0
55239e8668c7a4810c221525894d85b2ea5403cf Target Resources plc; gold and diamond mining in Sierra Leone Registrable shareholdings 3aff2389 2011-03-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 3 2011-03-28-3aff2389-10023-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 93.607ms · Data source: mySociety Data