home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

14 rows where record_id = "2012-10-22-80ef1083-10401-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
489afd1fc8c3f27cbadb0a08b2d42a766c96e8f3 Name of donor: (1) Europe House; (2) Government of Georgia Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 0 2012-10-22-80ef1083-10401-0
136c5497c3a84abca1e7a0dcacd6e6291be7a2b0 Address of donor: (1) 1, Freedom Square, Tbilisi, Georgia; (2) Embassy of Georgia, 4 Russell Gardens; London W14 8EZ Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 1 2012-10-22-80ef1083-10401-0
6ef59b7d7fcd1f3219690ad956d25760a9e67dae Amount of donation (or estimate of the probable value): (1) flights with a value of £1,058, and hotel accommodation with a value of £464; (2) Meals with an estimated value of £60 Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 2 2012-10-22-80ef1083-10401-0
327f8ce674d7699493fa1000794b9788dc64166f Destination of visit: Tbilisi, Georgia Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 3 2012-10-22-80ef1083-10401-0
c291a9c8ae3098bc0d48f221a45d58d8bd6b8090 Date of visit: 28-31 May 2012 Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 4 2012-10-22-80ef1083-10401-0
63bd2c2e69151689edb7d3ec3ced2eb0f2faac3b Purpose of visit: To attend the annual Europe Week in my capacity as Chair of the APPG on Georgia Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 5 2012-10-22-80ef1083-10401-0
5c24281f953fa88e576d2acdccb38a323753ff6f (Registered 4 July 2012) Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 6 2012-10-22-80ef1083-10401-0
2a64939e304f4fb650d20d36e3f7f2587d03eee4 Name of donor: South African Jewish Board of Deputies Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 7 2012-10-22-80ef1083-10401-0
c2da2a9bd4d30f43d0510c5e3b910dea021852ac Address of donor: PO Box 87557, Houghton 2041, Cape Town Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 8 2012-10-22-80ef1083-10401-0
91994d94f1d0422ed64f96e49676db8408153fe8 Amount of donation (or estimate of the probable value): Flights, accommodation, internal travel and sundries with a total value of approx £3,200   Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 9 2012-10-22-80ef1083-10401-0
1533c337d2fe0702593c5757cb09048966a0d873 Destination of visit: South Africa Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 10 2012-10-22-80ef1083-10401-0
142f4d7d29b0bdb8efd6f67eab7179bcb95920ac Date of visit: 29 August - 2 September 2012 Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 11 2012-10-22-80ef1083-10401-0
a3c01f85c68bb500e8892a2ae2a2b908b821961a Purpose of visit: to lecture at Witwatersrand University and to speak at two conferences on anti-semitism and the role of British MPs in combating anti-Semitism; to meet the ANC leadership and to renew contact with individuals in independent black trade unions. Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 12 2012-10-22-80ef1083-10401-0
04ce134a31074c4a0f8a17e5a4df98b94f7502f1 (Registered 20 September 2012) Overseas visits 80ef1083 2012-10-22 Denis MacShane uk.org.publicwhip/member/40509 Denis MacShane uk.org.publicwhip/person/10401 13 2012-10-22-80ef1083-10401-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 17.704ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette