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 = 7 sorted by record_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 ▼ |
---|---|---|---|---|---|---|---|
5c7ec52ce8084f632c31a761177b57ead747208a | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2009-10-14-80ef1083-10098-0 |
abb1dd3af6b0886d6232bb2060f79926720c0ae7 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2009-10-28-80ef1083-10098-0 |
221e3bfc1ccece4e042572631362608badfaf535 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2009-11-11 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2009-11-11-80ef1083-10098-0 |
7405791168e33aeec85a677d8987921d39178c72 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2009-11-25-80ef1083-10098-0 |
bec9ad0cab1dcdec2196986b511fcf1ea298d6c4 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2009-12-10-80ef1083-10098-0 |
e883f6deb4ab5e700f4251c7cbc54a8b08079144 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-01-06-80ef1083-10098-0 |
4226136865946602793c43034cf91e74719d5dc6 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-02-03-80ef1083-10098-0 |
0a5a9f2a9401040d12d6a2aad69bc7e9b1234b0e | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-02-24-1f359ece-10098-0 |
b9beb723b910441062144fa4a0074d0450ca7dba | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-02-24-80ef1083-10098-0 |
e018cfaae3225f4873c70bb11bd2beae8dcb9396 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-03-10-1f359ece-10098-0 |
3b4a3172a7cb9a3293f6a41cc51c74660f06f4c2 | Destination of visit: Jiangsu Province and Shanghai | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-03-10-80ef1083-10098-0 |
22b9407be71f3b8187586d2716f04dd256ebedad | £75 for completing a survey. Hours: 30 mins. (Registered 24 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 | 7 | 2010-03-24-1f359ece-10098-0 |
40f6ffd9d872a9ec1bb9e0c84f4b849e31fd0828 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-03-24-80ef1083-10098-0 |
9a3734308dd6b56a64e12ea1eb54870d3cdf9187 | £75 for completing a survey. Hours: 30 mins. (Registered 24 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 | 7 | 2010-04-12-1f359ece-10098-0 |
5227b573f10973ec34f7729f466e9aabc7eb8915 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 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");