items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2012-05-14-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 |
---|---|---|---|---|---|---|---|
4d0bc219d232d718bb848e2d641a3db59ac4c83e | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 0 | 2012-05-14-1f359ece-24798-0 |
5f96c924f64c2e6c56330f68fda3784431bf2e70 | 24 June 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 1 | 2012-05-14-1f359ece-24798-0 |
c1343c2e1cf64739a325f1272df6c0fdd0339283 | 28 July 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 2 | 2012-05-14-1f359ece-24798-0 |
1698d44f8a55909e525932057a3b7fcf91ca9a46 | 28 April 2011, £75. Hours: 15 mins. Payment donated to local constituency party. (Registered 28 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 3 | 2012-05-14-1f359ece-24798-0 |
b604474a7d2787bd606bef561048a925b671993b | 1 June 2011, £75. Hours: 15 mins. Payment donated to local constituency party. (Registered 28 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 4 | 2012-05-14-1f359ece-24798-0 |
3361f90c86e8e54cd3505880a53d8e1e6fc4d596 | December 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 5 | 2012-05-14-1f359ece-24798-0 |
395f11892ee143fe802ebdef6a8ac0a65897da32 | January 2012, £75. Hours; 15 mins. Payment donated to my constituency party. (Registered 11 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 6 | 2012-05-14-1f359ece-24798-0 |
14a857215e6f5bf01dfc556bc9f04b01dc4bb09f | May 2011, £50. Hours; 15 mins. Payment donated to charity. (Registered 13 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 7 | 2012-05-14-1f359ece-24798-0 |
2ef65802966d36f8e1b1966b778b5742f12815b4 | July 2011, £50. Hours; 15 mins. Payment donated to charity. (Registered 13 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 8 | 2012-05-14-1f359ece-24798-0 |
bcefed931956da21543d6272c28d5f076d607614 | October 2011, £50. Hours; 15 mins. Payment donated to charity. (Registered 13 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 9 | 2012-05-14-1f359ece-24798-0 |
4425d5b03f3e185602c2117455868f7c93d52724 | February 2012, £75. Hours: 15 mins. Payment donated to charity. (Registered 29 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 10 | 2012-05-14-1f359ece-24798-0 |
c43b4648fc41bf80373db048d6272f640df9790f | Payments from Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 11 | 2012-05-14-1f359ece-24798-0 |
b08241effef28df03ed1511719a7db441d8f2028 | 17 August 2011, £75. Hours: 15 mins. Payment donated to charity. (Registered 27 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 12 | 2012-05-14-1f359ece-24798-0 |
48081554f040d4378394e2868b49ea85ba598c4b | 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-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 13 | 2012-05-14-1f359ece-24798-0 |
b89bc6acaab5fcc38a4fd8aa83a6a65b8a357038 | 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-05-14 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 14 | 2012-05-14-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");