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 = "2015-01-26-80ef1083-24918-1" 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
4485e883b46fead2a36501d4c81a5c8bd41c9099 Name of donor: Government of the United Arab Emirates (UAE) Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 0 2015-01-26-80ef1083-24918-1
6fe168ca5e536dd6c753203f9201386aa92d9fca Address of donor: PO Box 31966, Abu Dhabi, UAE Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 1 2015-01-26-80ef1083-24918-1
8af9f965a7908fabbd6150c5b5732c5ba76388f2 Amount of donation (or estimate of the probable value): flights, accommodation, food and drink, total £3,500 Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 2 2015-01-26-80ef1083-24918-1
cd4ac96cb78fdc410d416e2ae6b02e7577644b0d Destination of visit: Abu Dhabi and Dubai, UAE Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 3 2015-01-26-80ef1083-24918-1
f17c35392748b90c067544a60a739467828644ca Date of visit: 16-19 November 2013 Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 4 2015-01-26-80ef1083-24918-1
7520dcae6ca9add31805b37e07e88ebbc7d83f90 Purpose of visit: to meet with government ministers, members of the Federal National Council, senior business figures and NGOs, together with British diplomats to further relations between the UK and UAE. Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 5 2015-01-26-80ef1083-24918-1
a94c84853d5df5be7f6dd8ed22337465e2cc5d72 (Registered 14 April 2014) Overseas visits 80ef1083 2015-01-26 Gemma Doyle uk.org.publicwhip/member/40649 Gemma Doyle uk.org.publicwhip/person/24918 6 2015-01-26-80ef1083-24918-1

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 73.956ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette