items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2013-01-18-1f359ece-11672-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
6ebb590f672cf919b04d67773c89128165609d7c | Payments from ComRes for participation in parliamentary panel surveys. Address: Four Millbank, London SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 0 | 2013-01-18-1f359ece-11672-0 |
2c8add17fee5011507a19cda917abcd757281b02 | £75 for December 2011 survey. Hours: 30 mins. (Registered 10 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 1 | 2013-01-18-1f359ece-11672-0 |
98426f4a901abf47c4f93d34f77790a88cda7b9f | £75 for January-February survey. Hours: 1 hr. (Registered 8 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 2 | 2013-01-18-1f359ece-11672-0 |
b463547d1b4a1dbc5470160ac0dfa32d7c39e5e8 | 29 June, received £75 for participation in April-May survey. Hours: 30 mins. (Registered 29 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 3 | 2013-01-18-1f359ece-11672-0 |
82986b71a58c816ede5b89fb33657f25032eb301 | 17 September, received £75 for participation in July survey. Hours: 30 mins. (Registered 12 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 4 | 2013-01-18-1f359ece-11672-0 |
9ffe0c4dcc27476f191034c4244a7e9774ee71cd | 30 November 2012, received £75 for participation in October-November survey. Hours: 30 mins. (Registered 19 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 5 | 2013-01-18-1f359ece-11672-0 |
cb27741f3ab05f19a91ffacffbdf21e355b4e9ec | Payments from Ipsos MORI, 79-81 Borough Road, London SE1 1FY for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 6 | 2013-01-18-1f359ece-11672-0 |
55a9014b2ed7a121ba2fdb76d41de87e51083ff0 | £150 received on 3 February 2012. Hours: 45 mins. (Registered 13 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 7 | 2013-01-18-1f359ece-11672-0 |
42d590a9947a2505ef75349515638652b6ba9ca0 | £150 received on 1 October 2012. Hours: 45 mins. (Registered 12 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 8 | 2013-01-18-1f359ece-11672-0 |
111aa767e776f0e9061cd34245eaded1f9021c4c | £150 received on 19 November 2012. Hours: 45 mins. (Registered 19 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 9 | 2013-01-18-1f359ece-11672-0 |
bcd5e28aaa4f04f0d5f8f22d6e9edf3439302795 | £150 received on 11 January 2013. Hours: 45 mins. (Registered 11 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 10 | 2013-01-18-1f359ece-11672-0 |
7046bdb0847c6566a9ad8d1c544e94a72a8e06cb | Payments from William Reed Business Media Limited for regular column in the Morning Advertiser. Address: Broadfield Park, Crawley, RH11 9RT. | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 11 | 2013-01-18-1f359ece-11672-0 |
754333672f0f65587081bc2cc01ccb6fdadbe805 | £250 for article in December 2011, received 16 January 2012. Hours: 2 hrs. (Registered 13 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 12 | 2013-01-18-1f359ece-11672-0 |
45d300b381925fdafc5e8835be168b28263757ab | £250 for article in February 2012, received 21 March 2012. Hours: 2 hrs. (Registered 21 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 13 | 2013-01-18-1f359ece-11672-0 |
00068e111b7051642dba3701a5936173db9c4e02 | £250 for article in March 2012, received 20 April 2012. Hours: 2 hrs. (Registered 20 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 14 | 2013-01-18-1f359ece-11672-0 |
a82a8bb372361f75eda50de92197f5ee337a0fca | £250 for article in May 2012, received June 2012. Hours: 2 hrs. (Registered 13 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 15 | 2013-01-18-1f359ece-11672-0 |
7c1abc61de479555c154558427aa85339c4f0e12 | £250 for article in June 2012, received 13 July 2012. Hours: 2 hrs. (Registered 16 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 16 | 2013-01-18-1f359ece-11672-0 |
591c8e503c205e5e0b1bc9694a72dba769047f50 | £250 for article in July 2012, received 25 August 2012. Hours: 2 hrs. (Registered 12 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Greg Mulholland uk.org.publicwhip/member/40356 | Greg Mulholland uk.org.publicwhip/person/11672 | 17 | 2013-01-18-1f359ece-11672-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");