items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where member_id = "uk.org.publicwhip/member/119" 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 |
---|---|---|---|---|---|---|---|
9f536abcbda1bc11ee198fe950c296c6f5ce3bd5 | Arable farming in the UK | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2001-05-14-1f359ece-10119-0 |
15fba6ee078fb2d67e0b2793421874bb075d31a4 | Associate of the Royal Institute of Chartered Surveyors. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 1 | 2001-05-14-1f359ece-10119-0 |
4dac561dd25dd8c79d37e4b01ed707efc0a2c3b2 | Agricultural holdings in Norfolk and Gloucestershire. | Land and Property 4f1e6359 | 2001-05-14 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2001-05-14-4f1e6359-10119-0 |
b71c04a8bd76cb0c021becf2e8970e2e81e26394 | Small amount of forestry in Scotland. | Land and Property 4f1e6359 | 2001-05-14 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 1 | 2001-05-14-4f1e6359-10119-0 |
94485135ab1ab9abbe3c6682039d1e2ed8f6afc6 | December 2000, I received a pair of silver cuff links from Tiffany & Co., as a Christmas gift from His Excellency G.A. Algosaibi, Ambassador of Saudi Arabia. (Registered 11 January 2001) | Overseas benefits and gifts a41b9847 | 2001-05-14 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2001-05-14-a41b9847-10119-0 |
9c8a6c7421993422a6dffa0d5b5c8e939e9cd933 | Alder Investment Ltd; investment management. | Registrable shareholdings 3aff2389 | 2001-05-14 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2001-05-14-3aff2389-10119-0 |
d3664af952a332613b282995227b256a7670feec | Farming in the U.K. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2000-11-10-1f359ece-10119-0 |
16e9b75debb3b0d9055126bbb72b1be46c57e754 | Associate of the Royal Institute of Chartered Surveyors. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 1 | 2000-11-10-1f359ece-10119-0 |
4db2248b196f47682da25d957b58e6b4bc1e0ae6 | 13 October 1999, I attended a shoot as a guest of Mr John Carlisle, Executive Director of Public Affairs at the Tobacco Manufacturers Association. (Registered 17 December 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2000-11-10-84642823-10119-0 |
b9b77c6ed27b2d2da55e33c23b494fa318ac75ea | 27 February-5 March 1999, to Hong Kong, at the invitation of the Hong Kong Government Information Service, who paid for my flights and hospitality. (Registered 19 March 1999) | Overseas visits 80ef1083 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2000-11-10-80ef1083-10119-0 |
b85dd8f1dcea1197801fa5a6ef8d771e4c88b159 | 16-23 January 2000, to Israel and the Palestinian territory as guests of the Israeli Government and Conservative Friends of Israel. (Registered 31 January 2000) | Overseas visits 80ef1083 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 1 | 2000-11-10-80ef1083-10119-0 |
2874bd160934b55291c1237f24c8461de80a3473 | I received a silver key ring from Tiffany & Co., as a Christmas gift from Mr G A Algosaibi, Ambassador of Saudi Arabia. (Registered 13 January 2000) | Overseas benefits and gifts a41b9847 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2000-11-10-a41b9847-10119-0 |
a731c2c6e0de499e9429624467fe7b95b99094ad | Agricultural holdings in Norfolk and Gloucestershire. | Land and Property 4f1e6359 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2000-11-10-4f1e6359-10119-0 |
224bfcf06cd92d544e5baf1842d40eb3ca7578ff | Small amount of forestry in Scotland. | Land and Property 4f1e6359 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 1 | 2000-11-10-4f1e6359-10119-0 |
812eaf34094c9d553a63735b126a2b9e1ee98bf8 | Alder Investment Ltd; investment management. | Registrable shareholdings 3aff2389 | 2000-11-10 | Geoffrey Clifton-Brown uk.org.publicwhip/member/119 | Geoffrey Clifton-Brown uk.org.publicwhip/person/10119 | 0 | 2000-11-10-3aff2389-10119-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");