items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where member_id = "uk.org.publicwhip/member/1075" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
9242f8aa6688c36b4e89e56210e4952ccb85e478 | 27 May-2 June 2004, to Oman with All-Party Oman Group, as guests of the Oman Majlis to establish links between Parliament and Majlis. (Registered 9 June 2004) | Overseas visits 80ef1083 | 2005-04-11 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2005-04-11-80ef1083-10391-0 |
f7a85b2f80af4a869994cf00c1748f8fd8ee4a63 | 7-8 March 2005, to Seville, to attend launch of BMW '3' Series, as a guest of BMW (GB) Ltd., a leading employer in the constituency. (Registered 17 March 2005) | Overseas visits 80ef1083 | 2005-04-11 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2005-04-11-80ef1083-10391-0 |
c242d6178fa8d2715685dbc4e21653ebf19423d2 | 14-20 February 2004, to Egypt, at the invitation and expense of the Government of Egypt. (Registered 4 March 2004) | Overseas visits 80ef1083 | 2005-01-28 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2005-01-28-80ef1083-10391-0 |
27401bd31f8c0eaa15279788694cf402fd51f1ed | 27 May-2 June 2004, to Oman with All-Party Oman Group, as guests of the Oman Majlis to establish links between Parliament and Majlis. (Registered 9 June 2004) | Overseas visits 80ef1083 | 2005-01-28 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2005-01-28-80ef1083-10391-0 |
c689ac66ee78ecb6eabb506e74f99ff3b908fb1f | 22-28 November 2003, to Botswana, as a guest of the Government of Botswana. (Registered 15 December 2003) | Overseas visits 80ef1083 | 2004-12-03 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2004-12-03-80ef1083-10391-0 |
565b6291ad0b2eae712080097c342622905f0852 | 14-20 February 2004, to Egypt, at the invitation and expense of the Government of Egypt. (Registered 4 March 2004) | Overseas visits 80ef1083 | 2004-12-03 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2004-12-03-80ef1083-10391-0 |
a542ecd90ae14a5cea349e3e85fa7e35b596f839 | 27 May-2 June 2004, to Oman with All-Party Oman Group, as guests of the Oman Majlis to establish links between Parliament and Majlis. (Registered 9 June 2004) | Overseas visits 80ef1083 | 2004-12-03 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 2 | 2004-12-03-80ef1083-10391-0 |
25bea7a9d991e552186bbe256616afde6e4f0c54 | 12-16 October 2003, to Bahrain at the invitation and expense of the Bahrain Government. (Registered 28 October 2003) | Overseas visits 80ef1083 | 2004-10-22 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2004-10-22-80ef1083-10391-0 |
b674f4fa871e5628f190bf8c303af2547df3b2d1 | 22-28 November 2003, to Botswana, as a guest of the Government of Botswana. (Registered 15 December 2003) | Overseas visits 80ef1083 | 2004-10-22 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2004-10-22-80ef1083-10391-0 |
0019089d74d7de9f90798bc835f3634ee89493a6 | 14-20 February 2004, to Egypt, at the invitation and expense of the Government of Egypt. (Registered 4 March 2004) | Overseas visits 80ef1083 | 2004-10-22 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 2 | 2004-10-22-80ef1083-10391-0 |
5a8110a41359a6c9ec93bc49844d7c1a8b50726e | 27 May-2 June 2004, to Oman with All-Party Oman Group, as guests of the Oman Majlis to establish links between Parliament and Majlis. (Registered 9 June 2004) | Overseas visits 80ef1083 | 2004-10-22 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 3 | 2004-10-22-80ef1083-10391-0 |
96330ea4d4a1259dc110172f8948add827a3ce0a | 12-16 October 2003, to Bahrain at the invitation and expense of the Bahrain Government. (Registered 28 October 2003) | Overseas visits 80ef1083 | 2004-09-08 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2004-09-08-80ef1083-10391-0 |
5612af2c2377da9548d37814d315c48a506e713c | 22-28 November 2003, to Botswana, as a guest of the Government of Botswana. (Registered 15 December 2003) | Overseas visits 80ef1083 | 2004-09-08 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2004-09-08-80ef1083-10391-0 |
1c5bc2ae1264a0249512c33e2f5b1448971889d2 | 14-20 February 2004, to Egypt, at the invitation and expense of the Government of Egypt. (Registered 4 March 2004) | Overseas visits 80ef1083 | 2004-09-08 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 2 | 2004-09-08-80ef1083-10391-0 |
09536240988e96a365dbb0352a36750c282c0cd1 | 27 May-2 June 2004, to Oman with All-Party Oman Group, as guests of the Oman Majlis to establish links between Parliament and Majlis. (Registered 9 June 2004) | Overseas visits 80ef1083 | 2004-09-08 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 3 | 2004-09-08-80ef1083-10391-0 |
6e9965d07e9f32e0f847126fc1def0284509ab73 | 12-16 October 2003, to Bahrain at the invitation and expense of the Bahrain Government. (Registered 28 October 2003) | Overseas visits 80ef1083 | 2004-07-16 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2004-07-16-80ef1083-10391-0 |
1b9da47c380d5d8d88b2a1f395c89628555d788a | 22-28 November 2003, to Botswana, as a guest of the Government of Botswana. (Registered 15 December 2003) | Overseas visits 80ef1083 | 2004-07-16 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2004-07-16-80ef1083-10391-0 |
cdbcb13f8ab9b85e34852c1e021f6d52946733f9 | 14-20 February 2004, to Egypt, at the invitation and expense of the Government of Egypt. (Registered 4 March 2004) | Overseas visits 80ef1083 | 2004-07-16 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 2 | 2004-07-16-80ef1083-10391-0 |
d6f261a6db774f12056370fb84ead055da8e0287 | 27 May-2 June 2004, to Oman with All-Party Oman Group, as guests of the Oman Majlis to establish links between Parliament and Majlis. (Registered 9 June 2004) | Overseas visits 80ef1083 | 2004-07-16 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 3 | 2004-07-16-80ef1083-10391-0 |
2fbff267fa6265e2803c15ef3f1b402b3aa4969a | 2 and 3 July 2003, to Cannes for the launch of the new '5 Series'. Travel and accommodation expenses met by BMW (GB) Ltd, who are based in my constituency. (Registered 4 July 2003) | Overseas visits 80ef1083 | 2004-05-21 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2004-05-21-80ef1083-10391-0 |
c6caa1692ba4fa9ae46d02bde112e9ae43ded888 | 12-16 October 2003, to Bahrain at the invitation and expense of the Bahrain Government. (Registered 28 October 2003) | Overseas visits 80ef1083 | 2004-05-21 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2004-05-21-80ef1083-10391-0 |
c9c830ce80a706170b000cee4e3428889c7ef1cb | 22-28 November 2003, to Botswana, as a guest of the Government of Botswana. (Registered 15 December 2003) | Overseas visits 80ef1083 | 2004-05-21 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 2 | 2004-05-21-80ef1083-10391-0 |
53e99fdafcff5fcdba410ac2669296c5b1ca77eb | 14-20 February 2004, to Egypt, at the invitation and expense of the Government of Egypt. (Registered 4 March 2004) | Overseas visits 80ef1083 | 2004-05-21 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 3 | 2004-05-21-80ef1083-10391-0 |
58aa854beab998cb30b6a285708664c670ea8d77 | 2 and 3 July 2003, to Cannes for the launch of the new `5 Series'. Travel and accommodation expenses met by BMW (GB) Ltd, who are based in my constituency. (Registered 4 July 2003) | Overseas visits 80ef1083 | 2004-01-31 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2004-01-31-80ef1083-10391-0 |
85ed3c6e4e7c75b730bcff3fe4f3c45d9411d56d | 12-16 October 2003, to Bahrain at the invitation and expense of the Bahrain Government. (Registered 28 October 2003) | Overseas visits 80ef1083 | 2004-01-31 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2004-01-31-80ef1083-10391-0 |
742100538c4d248b9a94ce37936b47d825ee8d84 | 22-28 November 2003, to Botswana, as a guest of the Government of Botswana. (Registered 15 December 2003) | Overseas visits 80ef1083 | 2004-01-31 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 2 | 2004-01-31-80ef1083-10391-0 |
c780f4ce7c5bd40aff1725e6e250866ecaeaab13 | 2 and 3 July 2003, to Cannes for the launch of the new '5 Series'. Travel and accommodation expenses met by BMW (GB) Ltd, who are based in my constituency. (Registered 4 July 2003) | Overseas visits 80ef1083 | 2003-12-04 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2003-12-04-80ef1083-10391-0 |
767241c7e968901bad815f39dc2579f904ca98f4 | 12-16 October 2003, to Bahrain at the invitation and expense of the Bahrain Government. (Registered 28 October 2003) | Overseas visits 80ef1083 | 2003-12-04 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 1 | 2003-12-04-80ef1083-10391-0 |
ae429271856c10f2e44ac798fda67ea320b5a7f8 | 15-17 February 2002, to Spain, to attend launch of new BMW `7' series. Flight and accommodation paid for by BMW (GB), whose headquarters are in my constituency. (Registered 25 February 2002) | Overseas visits 80ef1083 | 2002-11-26 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2002-11-26-80ef1083-10391-0 |
256e014b02416c0e98109bc041f779e85e2c97fe | Member of Harris Parliamentary Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2002-05-14-1f359ece-10391-0 |
ff4d6647633d413701773ed57c717b274c2aeea4 | Gift of a Sky digital unit, including annual subscription, from BSkyB. (Registered 31 January 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2002-05-14-84642823-10391-0 |
8f0c90f75d8e4043b40ac2ad23f4c4008be4f809 | 15-17 February 2002, to Spain, to attend launch of new BMW '7' series. Flight and accommodation paid for by BMW (GB), whose headquarters are in my constituency. (Registered 25 February 2002) | Overseas visits 80ef1083 | 2002-05-14 | Andrew MacKay uk.org.publicwhip/member/1075 | Andrew MacKay uk.org.publicwhip/person/10391 | 0 | 2002-05-14-80ef1083-10391-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");