items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2011-06-20-1f359ece-24798-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f8a51f091429ce3b78653c4f32e74ff5c76471fd | Principal of John Leggott College, West Common Lane Scunthorpe until 31 August 2010 | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 0 | 2011-06-20-1f359ece-24798-0 |
596385178d1b6da284c3453b7147cb397496b0f9 | Received £8057 for May 2010. Hours 120 (Registered 30 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 1 | 2011-06-20-1f359ece-24798-0 |
cd4024c70fd7999f6edff975e2c24ca0b9c848ae | Received £5796.21 for June 2010. Hours 120 ( Registered 30 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 2 | 2011-06-20-1f359ece-24798-0 |
ead22376d786ea6318a21e6b66adde029b8edce0 | Received £5796.21 for July 2010. Hours 120. (Registered 30 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 3 | 2011-06-20-1f359ece-24798-0 |
76430dd96e609ddbfeffc76ce642dedb9ab46981 | Received £5796.21 for August 2010. Hours 120 (Registered 31 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 4 | 2011-06-20-1f359ece-24798-0 |
70ec9e6866eae890e22f3bdf3bf4f86bf3511d3f | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 5 | 2011-06-20-1f359ece-24798-0 |
a54131e61c3fdabf414e391f479590a3a8c78f69 | May 2010, £75. Hours: 15 mins. Payment donated to charity. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 6 | 2011-06-20-1f359ece-24798-0 |
b0e9f03909728c489ab78fbac89250e0fd7a0519 | June 2010, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 7 | 2011-06-20-1f359ece-24798-0 |
74ad8047878e131ad54347fd77f7dc7cc7b43c0b | September 2010, £75. Hours: 15 mins. Payment donated to charity. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 8 | 2011-06-20-1f359ece-24798-0 |
fcb625b159c5010728d4db03652a9ac4bc0f0653 | October 2010, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 9 | 2011-06-20-1f359ece-24798-0 |
078d54a4e1474136db183b31def7a720399b8389 | November 2010, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 10 | 2011-06-20-1f359ece-24798-0 |
7e45b713221368ba0f72fecddc3f57214384eab5 | January 2011, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 11 | 2011-06-20-1f359ece-24798-0 |
1a63d4efa34e12bb7028aaee7f1243ae77764b31 | February 2011, £75. Hours: 15 mins. Payment donated to local organisation. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 12 | 2011-06-20-1f359ece-24798-0 |
b5099fa571444b155808ddf0fcec7c3afb95cbd7 | Payments from Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 13 | 2011-06-20-1f359ece-24798-0 |
2a278718855c232ad5d34b0660d77709bff124d9 | September 2010, £50. Hours: 5 mins. Payment donated to local organisation. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 14 | 2011-06-20-1f359ece-24798-0 |
776bb27d50eb281bb7abf8d27b3f3522066a085c | December 2010, £75. Hours: 5 mins. Payment donated to local organisation. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 15 | 2011-06-20-1f359ece-24798-0 |
e99151890f98a79b9b4f0e048de2604ed1a52361 | Payment of £80 from YouGov, 50 Featherstone St, London EC1Y 8RT, for opinion survey. Hours: 15 mins. Payment donated to charity. (Registered 31 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 16 | 2011-06-20-1f359ece-24798-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");