items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2013-02-25-1f359ece-24739-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
00121f0e7b5347f5d445d21eb8b1d95f7fc8c911 | Payments for interviews for BBC News 24. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 1 | 2013-02-25-1f359ece-24739-0 |
32a2d0e7805ac7c85a9efbc08f5848de85db650e | Payment of £100 received on 27 June 2012 from Dods Parliamentary Service, 21 Dartmouth Street, London SW1H 9BP, for completing a survey. Hours: 30 mins. Payment made direct to charity. (Registered 27 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 13 | 2013-02-25-1f359ece-24739-0 |
3d35ec16d6672d87c31fb57f4a19d95ca1d3e988 | Received £70, paid direct to charity. Hours: 45 mins. (Registered 1 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 15 | 2013-02-25-1f359ece-24739-0 |
5263aa0dd56c6ecfc5d3ab27c9caed7bf80887f8 | 21 September 2012, received £150 for interview on 5 September 2012. Hours: 1 hr 45 mins. (Registered 31 October 2012 ) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 8 | 2013-02-25-1f359ece-24739-0 |
61d34051c22276a74c3da12d5d18c3bdd8ebd1e5 | 17 December 2012, received £300 for two interviews, on 13 and 28 November 2012. Hours: 1 hr 45 minutes for each interview (3.5 hrs in total). (Registered 17 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 10 | 2013-02-25-1f359ece-24739-0 |
688f773fb2e99a01bacee49c942ccfd2d94c3aae | 5 March 2012, received £150 for interview on 11 January 2012. Hours: 1 hr 45 mins. (Registered 19 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 3 | 2013-02-25-1f359ece-24739-0 |
70064b9158af9c947dd91f64d68659c100dfe830 | Received £300 for two newspaper reviews, on 9 and 23 May 2012. Hours: 1 hr 45 mins each . (Registered 22 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 7 | 2013-02-25-1f359ece-24739-0 |
76e45f704feacf7dd88f861363593f9189d37c96 | 5 March 2012, received £150 for interview on 14 December 2011. Hours: 1 hr 45 mins. (Registered 19 April 2012 ) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 2 | 2013-02-25-1f359ece-24739-0 |
a80471bcdde07d6526ff0bbcfe8d0c502798723a | Received £300 for two newspaper reviews, on 7 March and 28 March 2012. Hours: 1 hr 45 mins each . (Registered 21 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 5 | 2013-02-25-1f359ece-24739-0 |
bb3bdf891e30f37e40dd97dc4dfa4d20c1c743f0 | 9 November 2012, received £150 for interview on 17 October 2012. Hours: 1 hr 45 mins. (Registered 10 December 2012 ) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 9 | 2013-02-25-1f359ece-24739-0 |
c69d9e8f0d952d4d9c8a7924621a553e5fd07914 | Self-employed farmer. | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 0 | 2013-02-25-1f359ece-24739-0 |
cf71c8e9524a35f2ceb7f4a6bc8700cb5e59cf87 | Payment of £500 from ComRes for seven opinion surveys undertaken in May 2011, June 2011, July 2011, September 2011, November 2011, January 2012 and February 2012. Address: Four Millbank, London SW1P 3JA. Hours: 30-45 minutes for each survey. Payment made direct to charity. (Registered 23 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 12 | 2013-02-25-1f359ece-24739-0 |
d2c2498f57a617c1fd10ced63e3c3b0b50d92b9b | Received £300 for two newspaper reviews, on 18 and 25 April 2012. Hours: 1 hr 45 mins each . (Registered 21 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 6 | 2013-02-25-1f359ece-24739-0 |
d4411cd95a78e49f480c673845bde10526c0e1dc | 4 April 2012, received £150 for interview on 8 February 2012. Hours: 1 hr 45 mins. (Registered 19 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 4 | 2013-02-25-1f359ece-24739-0 |
de0ad69f9898a8ab109417d64d0fb01b0c6508f0 | Payments from YouGov, 50 Featherstone St, London EC1Y 8RT, for opinion survey. | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 14 | 2013-02-25-1f359ece-24739-0 |
f3ec3a79048d82b778992bb7cc229398da8acdf5 | 27 March 2012, received £150 plus travel expenses for interview for BBC Welsh Language programme ‘Pawb a’i Farn’ on 15 March 2012. Address: BBC Wales, Llandaff, Cardiff, CF5 2YQ. Hours: 1 hr (Registered 19 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Glyn Davies uk.org.publicwhip/member/40408 | Glyn Davies uk.org.publicwhip/person/24739 | 11 | 2013-02-25-1f359ece-24739-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");