items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2011-04-18-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 |
---|---|---|---|---|---|---|---|
1fb49e897a4deb1d7aba095c467d78c7ecb205c0 | Principal of John Leggott College, West Common Lane Scunthorpe until 31 August 2010 | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 0 | 2011-04-18-1f359ece-24798-0 |
449652c640468ad07b814e7b909d0c8503904ab7 | Received £8057 for May 2010. Hours 120 (Registered 30 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 1 | 2011-04-18-1f359ece-24798-0 |
799b3151560f5cbd971c3b9cc07f5bf0da4a4c8c | Received £5796.21 for June 2010. Hours 120 ( Registered 30 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 2 | 2011-04-18-1f359ece-24798-0 |
878b6dcfdf605cfc4efafba3f613ef935eca2110 | Received £5796.21 for July 2010. Hours 120. (Registered 30 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 3 | 2011-04-18-1f359ece-24798-0 |
b7dedd24680fd72b5d64ba4cc059f35d0a748531 | Received £5796.21 for August 2010. Hours 120 (Registered 31 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 4 | 2011-04-18-1f359ece-24798-0 |
d519e947f2e517531401057c549360d2127973d5 | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 5 | 2011-04-18-1f359ece-24798-0 |
291a7753468e22c204bdcccb247ac77ba7f5c50c | May 2010, £75. Hours: 15 mins. Payment donated to charity. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 6 | 2011-04-18-1f359ece-24798-0 |
acbf502bc7cda7e3af112d5c8457b7f10c114b76 | June 2010, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 7 | 2011-04-18-1f359ece-24798-0 |
27dd1a3208ccbfb7356162701ef7881d85c6bdb1 | September 2010, £75. Hours: 15 mins. Payment donated to charity. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 8 | 2011-04-18-1f359ece-24798-0 |
cb79ebce1a18972d2b45f79a1e93a1d74413a6d0 | October 2010, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 9 | 2011-04-18-1f359ece-24798-0 |
eefb449071f793566270495d55697c74cff3b639 | November 2010, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 10 | 2011-04-18-1f359ece-24798-0 |
f6196eddb4ae209ac98a916b4fd2e182ab9152ae | January 2011, £75. Hours: 15 mins. Payment donated to my constituency party. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 11 | 2011-04-18-1f359ece-24798-0 |
bfebb02b6fc1d238e09988b50081431a06ac0038 | February 2011, £75. Hours: 15 mins. Payment donated to local organisation. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 12 | 2011-04-18-1f359ece-24798-0 |
32ff49335c9c5773182b500f7d8137e5165b20c8 | Payments from Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 13 | 2011-04-18-1f359ece-24798-0 |
3eecf75fb0eae91f4f54229908cd91b88bd3a461 | September 2010, £50. Hours: 5 mins. Payment donated to local organisation. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 14 | 2011-04-18-1f359ece-24798-0 |
d7f4660260b331ef77a43aa237f452a59836857a | December 2010, £75. Hours: 5 mins. Payment donated to local organisation. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 15 | 2011-04-18-1f359ece-24798-0 |
baf23689daae02ef083990780196cc8f72ae161d | 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-04-18 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 16 | 2011-04-18-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");