items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where person_id = "uk.org.publicwhip/person/10583" and sort_order = 3 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
734aaac41733cb0ac1edf278901b051b42b4cdcd | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 17 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2014-10-27-1f359ece-10583-0 |
919afcdf1150116ece317c320eefded70bea2dc0 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 17 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-13 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2014-10-13-1f359ece-10583-0 |
d6d4b9a0ff2ce7629cb381a6df8c8a6a4d6685b0 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 17 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2014-09-22-1f359ece-10583-0 |
8870e750c06a4d75fa9bde96d28b138ed4f5a1ad | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 3 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-04-28 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2014-04-28-1f359ece-10583-0 |
d44d7ee1b0b72f3973779cec18c85d309e590255 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 3 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-04-07 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2014-04-07-1f359ece-10583-0 |
3191a8f9a0ae18201805981f125783ba1e4ebe49 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 8 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-28 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2013-10-28-1f359ece-10583-0 |
b8613321f1bdbc9a2ed708cd2936f69d08590132 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 8 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2013-10-14-1f359ece-10583-0 |
90fb6897e8addde771d2e25de9375f8895acb062 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 8 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2013-04-22-1f359ece-10583-0 |
7c14cd3b431d21a247d8c71468c375ea5c69a334 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 8 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2013-04-08-1f359ece-10583-0 |
e0a2f3b06392f605dd5cd7ad0559a5296d082a26 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 12 October 2012) | Remunerated employment, office, profession, etc. f3967f4d | 2012-10-22 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2012-10-22-f3967f4d-10583-0 |
75c79393d461110042bddc98e39e94d79faa68d1 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 18 April 2012) | Remunerated employment, office, profession, etc. f3967f4d | 2012-05-14 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2012-05-14-f3967f4d-10583-0 |
e914dbc4c22e9e9a35cc90dbd360e5750fec3f89 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 18 April 2012) | Remunerated employment, office, profession, etc. f3967f4d | 2012-04-30 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2012-04-30-f3967f4d-10583-0 |
abf01b092192fa67c4af723c62809e9b41f0e5a9 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 6 October 2011) | Remunerated employment, office, profession, etc. f3967f4d | 2012-01-13 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2012-01-13-f3967f4d-10583-0 |
ad3b42a0fea4cc4795d18c3eb657181590262a79 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 6 October 2011) | Remunerated employment, office, profession, etc. f3967f4d | 2011-12-13 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2011-12-13-f3967f4d-10583-0 |
f0b7a546769c151e0a6fe8d1e9a65c0c23e09592 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 6 October 2011) | Remunerated employment, office, profession, etc. f3967f4d | 2011-11-29 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2011-11-29-f3967f4d-10583-0 |
b38e5866050c61f4f0fbb8cfb026de0dcf05fb53 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 6 October 2011) | Remunerated employment, office, profession, etc. f3967f4d | 2011-11-16 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2011-11-16-f3967f4d-10583-0 |
fe3ddff51550346ab0dd255f49bde2be1faad037 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 6 October 2011) | Remunerated employment, office, profession, etc. f3967f4d | 2011-10-31 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2011-10-31-f3967f4d-10583-0 |
936e636acd48f4d4bbc984da1032c297cb4fced0 | Bi-annual fee payment of £15,000. Hours: 60 hrs over a six-month period. (Registered 6 October 2011) | Remunerated employment, office, profession, etc. f3967f4d | 2011-10-17 | Peter Tapsell uk.org.publicwhip/member/40377 | Peter Tapsell uk.org.publicwhip/person/10583 | 3 | 2011-10-17-f3967f4d-10583-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");