items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where person_id = "uk.org.publicwhip/person/10098" and sort_order = 8 sorted by category_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a2f2a52ed079bd215f620bd9753f597967fc3a64 | Received £150 on 27 January 2010 for participating in a survey. Hours: 30 mins. (Registered 8 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-02-24-1f359ece-10098-0 |
d2fa822265dea693ff8c8fe1a50b18f650bd7590 | Received £150 on 27 January 2010 for participating in a survey. Hours: 30 mins. (Registered 8 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-03-10-1f359ece-10098-0 |
ceefe16d4a4c3df0889f4e2e74eb854dbbe3570e | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-03-24-1f359ece-10098-0 |
68c05f09d4aca32c8e89b6d24331a6d372a23507 | £75 for completing a survey. Hours: 30 mins. (Registered 31 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-04-12-1f359ece-10098-0 |
fb38d1f8ee745d10044288e88ce6185d2bee45b0 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-10-14-80ef1083-10098-0 |
5cb0e70c71ea2dcd735602c7d746607b5c393cee | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-10-28-80ef1083-10098-0 |
e5bb5bf51726ace73eac127cbf47f42487bd3431 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-11-11 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-11-11-80ef1083-10098-0 |
ffae704f6c174468eb78a74b87e751c02d241b3a | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-11-25-80ef1083-10098-0 |
e4715e5919d46f367ae62552745659ea1cbf743e | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-12-10-80ef1083-10098-0 |
e4363c80a6f9add6aada04ebd219cfc2075219fd | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-01-06-80ef1083-10098-0 |
2ef21122cd436be977620864bcfb1397b3335ce8 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-02-03-80ef1083-10098-0 |
33babe5a49faef0772f2245bcf3315ed422e3bf4 | Destination of visit: Jiangsu Province and Shanghai | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-02-24-80ef1083-10098-0 |
780683a33e7aed0b26dd6791b8b95bde13532a38 | Date of visit: 19-26 September 2009 | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-03-10-80ef1083-10098-0 |
378515f85f2eb62e625cc371951fc5d2f90a821c | Destination of visit: Jiangsu Province and Shanghai | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-03-24-80ef1083-10098-0 |
a0542aa53c69dc107e24557d5ccf13d278de62f9 | Destination of visit: Jiangsu Province and Shanghai | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 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");