items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2008-04-23-80ef1083-11115-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 |
---|---|---|---|---|---|---|---|
c9ea3b3c01b3f9ac4bc59984f2fd5c2ac156de5c | 12-16 April 2007, to the Democratic Republic of Congo in my role as Shadow Secretary of State for International Development. The cost of my flight was met by Flying Lion Limited. In-country costs were met by previous donations as shown in Category 4 above. (Registered 25 April 2007) | Overseas visits 80ef1083 | 2008-04-23 | Andrew Mitchell uk.org.publicwhip/member/1862 | Andrew Mitchell uk.org.publicwhip/person/11115 | 0 | 2008-04-23-80ef1083-11115-0 |
4e746e6d6da4733bd3a7dd0502f4a47b287c61ca | 2-6 September 2007, to Tanzania, Madagascar and Tunisia in my role as Shadow Secretary of State for International Development. The cost of my flights were met by Flying Lion Ltd. In-country costs were met by previous donations as shown in Category 4 above. (Registered 11 September 2007) | Overseas visits 80ef1083 | 2008-04-23 | Andrew Mitchell uk.org.publicwhip/member/1862 | Andrew Mitchell uk.org.publicwhip/person/11115 | 1 | 2008-04-23-80ef1083-11115-0 |
1070d8af9c294695252d682defa81d13476e6955 | 18-22 November 2007, to Turks and Caicos Islands, Bolivia and Guyana in my role as Shadow Secretary of State for International Development. The cost of my flights was met by Flying Lion Ltd. In-country costs were met by previous donations as shown in Category 4 above. (Registered 28 November 2007) | Overseas visits 80ef1083 | 2008-04-23 | Andrew Mitchell uk.org.publicwhip/member/1862 | Andrew Mitchell uk.org.publicwhip/person/11115 | 2 | 2008-04-23-80ef1083-11115-0 |
633d4db7d233c4b2499c31e9eaeb5b37e5ca7ea2 | 10-14 February 2008, to Sierra Leone and Ghana in my role as Shadow Secretary of State for International Development. The cost of my flights and airport transfers were met by Flying Lion Ltd. (Accommodation was provided by the British High Commissions in both Sierra Leone and Ghana.) (Registered 14 February 2008) | Overseas visits 80ef1083 | 2008-04-23 | Andrew Mitchell uk.org.publicwhip/member/1862 | Andrew Mitchell uk.org.publicwhip/person/11115 | 3 | 2008-04-23-80ef1083-11115-0 |
0040501b63e208fb677bd24c55aeb9928b8230d0 | 6-10 April 2008, to Cambodia and Laos, in my role as Shadow Secretary of State for International Development. The cost of my flights was met my Flying Lion Ltd. Accommodation costs were met by previous donations shown in Category 4 above. (Registered 10 April 2008) | Overseas visits 80ef1083 | 2008-04-23 | Andrew Mitchell uk.org.publicwhip/member/1862 | Andrew Mitchell uk.org.publicwhip/person/11115 | 4 | 2008-04-23-80ef1083-11115-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");