items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2012-06-11-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 |
---|---|---|---|---|---|---|---|
01e841931de140fdb5217cd6d7100256420fe5de | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 0 | 2012-06-11-1f359ece-24798-0 |
09a8e8c073c37ac753e845fb84c51fee8134a777 | 24 June 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 1 | 2012-06-11-1f359ece-24798-0 |
4047a352862b828191c8af93d859caa2edf9ad8a | 28 July 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 2 | 2012-06-11-1f359ece-24798-0 |
46fb33aafe510b1eced847e8813efa4a55b906d4 | 28 April 2011, £75. Hours: 15 mins. Payment donated to local constituency party. (Registered 28 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 3 | 2012-06-11-1f359ece-24798-0 |
720f0b6cb632fedd648fbb327b5f2418678f63c6 | 1 June 2011, £75. Hours: 15 mins. Payment donated to local constituency party. (Registered 28 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 4 | 2012-06-11-1f359ece-24798-0 |
6d5b3b3f48708cf39122f1c9616fd01b3b3c1c4c | December 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 5 | 2012-06-11-1f359ece-24798-0 |
6f790e966cdc7746cc9a630e47826a42731bdb7a | January 2012, £75. Hours; 15 mins. Payment donated to my constituency party. (Registered 11 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 6 | 2012-06-11-1f359ece-24798-0 |
c0a720a3b6e186435424418d1de68cdefc5b9a01 | May 2011, £50. Hours; 15 mins. Payment donated to charity. (Registered 13 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 7 | 2012-06-11-1f359ece-24798-0 |
aabf728200c8d6c8575d1b64534969d95283a6e3 | July 2011, £50. Hours; 15 mins. Payment donated to charity. (Registered 13 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 8 | 2012-06-11-1f359ece-24798-0 |
2257624c2b9ac398390b609344e0597213c67ddf | October 2011, £50. Hours; 15 mins. Payment donated to charity. (Registered 13 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 9 | 2012-06-11-1f359ece-24798-0 |
68e91378ee87febbb4412bc2f2b17569db9ba3cf | February 2012, £75. Hours: 15 mins. (Registered 29 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 10 | 2012-06-11-1f359ece-24798-0 |
86730aceeaadb6de0a0cdde88ba340517c45c853 | April 2012, £75. Hours: 15 mins. Payment donated to charity. (Registered 31 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 11 | 2012-06-11-1f359ece-24798-0 |
860318c191eeeace9af2ca3c6b2ee4858c031ece | Payments from Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 12 | 2012-06-11-1f359ece-24798-0 |
9c2a0ee95df85618c5028ec7019089e4b649324b | 17 August 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 13 | 2012-06-11-1f359ece-24798-0 |
8404204d8dfafa6ca1bce0bd5efd681bf9e4a112 | Payment of £80 from Leftfield, 51 Clink Street Studios, Clink Street , London SE1 9DG for opinion survey. Hours: 15 mins. Payment donated to constituency party. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 14 | 2012-06-11-1f359ece-24798-0 |
9af822192012d409225db9d3bb6bac1a5791c771 | October 2011, payment of £150 from Arcadia University, 450 S. Easton Rd., Glenside, PA 19038, USA, as guest lecturer at City University, London. Hours: 2 hrs. Payment donated to constituency party. (Registered 18 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 15 | 2012-06-11-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");