items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2007-01-23-80ef1083-10884-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
665b7a840e6655dd2212f5226cb5c74f4e1e533d | 1-9 January 2006, to India with Conservative Friends of India, to discuss economic and industrial/commercial issues. Visits to Delhi, Mumbai, Bombay and Jaipur. Travel and accommodation expenses met by the Government of India and the Confederation of Indian Industry. (Registered 23 January 2006) | Overseas visits 80ef1083 | 2007-01-23 | Mark Field uk.org.publicwhip/member/1503 | Mark Field uk.org.publicwhip/person/10884 | 0 | 2007-01-23-80ef1083-10884-0 |
00e762609dadccf387a02f0bc4c254dc5ff042fb | 27 May-4 June 2006, to Dhaka in Bangladesh, and Kuala Lumpur and Penang in Malaysia, to inaugurate colleges being run by the London School of Commerce (LSC). All travel and hotel accommodation was paid for by the LSC. (Registered 7 June 2006) | Overseas visits 80ef1083 | 2007-01-23 | Mark Field uk.org.publicwhip/member/1503 | Mark Field uk.org.publicwhip/person/10884 | 1 | 2007-01-23-80ef1083-10884-0 |
e183cea8fcafe350e7be44c27611e4a90ed12993 | 1-2 July 2006, I attended the World Cup quarter final match in Gelsenkirchen, Germany, as guests of betfair, who met the costs of travel, hospitality, accommodation and match tickets. (Registered 10 July 2006) | Overseas visits 80ef1083 | 2007-01-23 | Mark Field uk.org.publicwhip/member/1503 | Mark Field uk.org.publicwhip/person/10884 | 2 | 2007-01-23-80ef1083-10884-0 |
8a649fb0ecd1ccff6ea43f6cdb56c83acebf8945 | 16-24 September 2006, to Hong Kong with the All-Party Parliamentary Group on China. Travel, accommodation and other sundry expenses paid for by the Chinese Government. (Registered 27 September 2006) | Overseas visits 80ef1083 | 2007-01-23 | Mark Field uk.org.publicwhip/member/1503 | Mark Field uk.org.publicwhip/person/10884 | 3 | 2007-01-23-80ef1083-10884-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");