items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where person_id = "uk.org.publicwhip/person/10098" and sort_order = 2 sorted by category_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
44840e38608132bae4baca778507421b8e18f75d | £75 for completing a survey. Hours: 30 mins. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-11-25-1f359ece-10098-0 |
ab637e5da1e79c7791b940ebf02fd66af5ed91b6 | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-12-10-1f359ece-10098-0 |
822ec99e318bb82e0bd10b99cbc95e372a22969f | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-01-06-1f359ece-10098-0 |
e6477e551d168507c726128155d51be8ef1cd48b | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-02-03-1f359ece-10098-0 |
6d8eb8a9e8717f12f4cb45caa319133576310d9e | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-02-24-1f359ece-10098-0 |
16d39c3d952b48d8ec1a7b05739c398d878edd03 | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-03-10-1f359ece-10098-0 |
e50d324b5a4186bd86fe51a8ade30671c40ac327 | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-03-24-1f359ece-10098-0 |
7a59ca336c85394138b6814b0a49eb8a31af00ce | £75 for participating in an MP Survey Panel. Hours: 30 minutes. (Registered 30 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-04-12-1f359ece-10098-0 |
383fbe86c13f5a1b29373d8569608919e398739d | Commercial rented property in Manchester and London. | Land and Property 4f1e6359 | 2000-11-10 | Ben Chapman uk.org.publicwhip/member/98 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2000-11-10-4f1e6359-10098-0 |
3ca1e3545899a24aba654cf437872deb5f2ffb4c | Commercial rented property in Manchester and London. | Land and Property 4f1e6359 | 2001-05-14 | Ben Chapman uk.org.publicwhip/member/98 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2001-05-14-4f1e6359-10098-0 |
576d52559815880a7a665f2dd9763de06746a896 | Commercial rented property in the Wirral (owned by my wife). | Land and Property 4f1e6359 | 2002-05-14 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2002-05-14-4f1e6359-10098-0 |
bb1dcfd02f28eabade2570bf7a61cc54b2fe4e82 | 20-24 September 2003, to Singapore with the All-Party Singapore Group for discussions with ministers and officials. Flights paid for by Singapore Airlines and accommodation provided by the Government of Singapore. (Registered 14 October 2003) | Overseas visits 80ef1083 | 2003-12-04 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2003-12-04-80ef1083-10098-0 |
e0b0eb89aad0a242d63df35ffbca0e8b86949037 | 25-27 November 2003, to Romania with the All-Party Romania Group for discussions with Ministers and officials. Hospitality and accommodation provided by the Government of Romania. (Registered 3 December 2003) | Overseas visits 80ef1083 | 2004-01-31 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2004-01-31-80ef1083-10098-0 |
99ae799b37a672960c574b49ee953538207f6a57 | 25-27 November 2003, to Romania with the All-Party Romania Group for discussions with Ministers and officials. Hospitality and accommodation provided by the Government of Romania. (Registered 3 December 2003) | Overseas visits 80ef1083 | 2004-05-21 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2004-05-21-80ef1083-10098-0 |
4c7a663256a61348f0399fce08e6356bd8d52bf9 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-10-14-80ef1083-10098-0 |
0dcc9037a845ba94846bb3c11c8e6ce75237c107 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-10-28-80ef1083-10098-0 |
2b9753a26f457d004323864f74c407d16dfec699 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2009-11-11 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-11-11-80ef1083-10098-0 |
e3166accc1637bcfe45a3cc7757449657cef8770 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-11-25-80ef1083-10098-0 |
abe22be9d2a43eb4e6ad9bec8fc8cef8b17e4553 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-12-10-80ef1083-10098-0 |
3929e4a3d9f40a594ccfa8a3fbc5dbdba4214509 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-01-06-80ef1083-10098-0 |
515aa2b4ee053a4b92022d6335c1ac9c7b027809 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-02-03-80ef1083-10098-0 |
f8024836399d71a54d213214c66f70835dc743b7 | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-02-24-80ef1083-10098-0 |
b2bb0f9b5c24801d8e9ba851afa3f6cbac7c65f5 | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-03-10-80ef1083-10098-0 |
bdf73df8a0889900ea9b6ad909326240ac3001fc | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-03-24-80ef1083-10098-0 |
ef2264bbba4a560a1e2a938b16b37bd11b25302f | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-04-12-80ef1083-10098-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");