items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where person_id = "uk.org.publicwhip/person/10088" and sort_order = 15 sorted by category_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
451174da421b59c2399bf2569586cb4e3117257d | Payment of £400 received on 8 December 2010 for an article for The Times on 11 November 2010. Address of payer: News International Supply Company Ltd, PO Box 151, Peterborough PE7 8YT. Hours: 4 hrs. (Registered 10 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2010-12-20-1f359ece-10088-0 |
75db0b6c63e8b907e627d13f141e71e69df6122e | Payment of £400 received on 8 December 2010 for an article for The Times on 11 November 2010. Address of payer: News International Supply Company Ltd, PO Box 151, Peterborough PE7 8YT. Hours: 4 hrs. (Registered 10 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2011-01-10-1f359ece-10088-0 |
29fada33d8cb93f235db6080de3cfe8bcd960181 | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2011-03-28-1f359ece-10088-0 |
96ac8645d21a0e6eaf5c41268d8d5b06ab18c453 | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2011-04-18-1f359ece-10088-0 |
b33a3f7c92b2c03339310eaec8732afedf061bc9 | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2011-05-03-1f359ece-10088-0 |
acaf7616206535c6d6224f8d9ee81f5080f3a93c | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2011-05-16-1f359ece-10088-0 |
53dbd0b574f70ab644546f726e7738c929a8dd50 | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-05-12-9e46def6-10088-0 |
2ae393224f6dad6c06746518acb40383f5614ffb | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-06-21-9e46def6-10088-0 |
757ddeba348265b29d104eb4f69a74a2fbe6602f | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-07-25-9e46def6-10088-0 |
aecc7577fc625cb2af9db5ce0c2915e04af4b864 | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-09-19-9e46def6-10088-0 |
51f15f9afc812e0f0ba50819d460609cea9ebc06 | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-11-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-11-06-9e46def6-10088-0 |
dcecfb7ecfb803bbba504da2be669653a96f06bb | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-11-27 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-11-27-9e46def6-10088-0 |
5d70f14e1f972f994ed638edb7093837a4f5e60b | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-12-11 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2006-12-11-9e46def6-10088-0 |
99865bdef48da58320a5f9282e6774b086e560d4 | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-01-09 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2007-01-09-9e46def6-10088-0 |
0daf644aff01c344ad4e318672b86371f3b3a8af | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-01-23 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2007-01-23-9e46def6-10088-0 |
2f2627014fd03dbf7ac04639bd204e0203a3d989 | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-02-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2007-02-06-9e46def6-10088-0 |
5550a44dedff812ffed4ab6cf18c496e59385108 | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2007-02-27-9e46def6-10088-0 |
4a63cf557d05f670daa57c415569a3fa12e5987a | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-03-13 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2007-03-13-9e46def6-10088-0 |
e394ff25e99e89e3f3dea0dbcd72e8da53904afa | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-03-26 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2007-03-26-9e46def6-10088-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");