items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-02-03-80ef1083-24954-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
fcf4520def87c59645a6a529b618cbe16246eb32 | Name of donor: | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2014-02-03-80ef1083-24954-0 |
044b376a2a05f1909886e3c36628d249106b75f3 | 1) UK-China Forum (UKCF) Ltd, with sponsorship support from BP, Barclays and Rolls Royce. | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 1 | 2014-02-03-80ef1083-24954-0 |
1d4a2502cbc1946c979ed1183595e3b7b2b725b6 | 2) International Department of Central Committee of the Communist Party of China (IDCPC) | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 2 | 2014-02-03-80ef1083-24954-0 |
79924fa72920cabbd96813535aad863c11fbb9f1 | Address of donor: | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 3 | 2014-02-03-80ef1083-24954-0 |
b621c324d07637899d4b416e022e7dd6d7921954 | 1) UKCF, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 4 | 2014-02-03-80ef1083-24954-0 |
5c8ef944747cc29262d739e8fb39249b86efe3ab | 2) IDCPC, 4 Fuxing Lu, Beijing 100860, China | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 5 | 2014-02-03-80ef1083-24954-0 |
dfcd390fbedce9fb8e26ee0a538f35b8c556ed4f | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 6 | 2014-02-03-80ef1083-24954-0 |
7206e5c2126f6352643497510970d76be761bda1 | 1) Business class flights paid by UKCF; cost £3,196 | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 7 | 2014-02-03-80ef1083-24954-0 |
2fdf3b857c8dfa0a31c400e1ea232d4758e80623 | 2) Hotel and meals paid by IDCPC; estimated cost £376 | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 8 | 2014-02-03-80ef1083-24954-0 |
b875f6d2292a23c25fabfc3bfd19bee7d7231fb7 | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 9 | 2014-02-03-80ef1083-24954-0 |
3113168256b405ce4c092b97907bf75f9defb529 | Date of visit: 12-16 January 2013 | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 10 | 2014-02-03-80ef1083-24954-0 |
64bfeb35d48388dc7bb372d262ab0c7968f75082 | Purpose of visit: to attend the UK-China Leadership Forum, an annual event organised by the Great Britain-China Centre to further mutual understanding and strengthen UK-China relations. | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 11 | 2014-02-03-80ef1083-24954-0 |
c4daa494c0c7f976fcd55a1fa9584a69c3771b19 | (Registered 29 January 2013) | Overseas visits 80ef1083 | 2014-02-03 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 12 | 2014-02-03-80ef1083-24954-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");