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 = "2010-03-24-80ef1083-10884-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
f416e6cb54605bc375c40cee9820e1bb4657df20 Name of donor: Canary Wharf Group plc Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 0 2010-03-24-80ef1083-10884-0
2fecae0e845a78d78fdac895ec73fc7b340eee52 Address of donor: Canary Wharf, London E14 5AB. Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 1 2010-03-24-80ef1083-10884-0
b44726f50e73ceb99336cf587a304fbccc97c35a Amount of donation (or estimate of the probable value): c. £2500 Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 2 2010-03-24-80ef1083-10884-0
af406a2020fd90d980736c2a148fa4c2f6c9f07f Destination of visit: Bangladesh Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 3 2010-03-24-80ef1083-10884-0
6d0553d0578bff15a62f17ee80f5eb647fa07bac Date of visit: 3-10 January 2010 Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 4 2010-03-24-80ef1083-10884-0
40e8f489a77f3fa38c3c81dbddd4b7983436ef28 Purpose of visit: to meet political and business figures in Dhaka and Sylhet Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 5 2010-03-24-80ef1083-10884-0
1c75904e3c16810c60f556a0792b31b9c59bae27 (Registered 13 January 2010) Overseas visits 80ef1083 2010-03-24 Mark Field uk.org.publicwhip/member/1503 Mark Field uk.org.publicwhip/person/10884 6 2010-03-24-80ef1083-10884-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 72.56ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette