items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2013-02-04-1f359ece-11715-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 |
---|---|---|---|---|---|---|---|
084260e36b1113bf0d0d7e88d9fd454481fe954b | Serving Officer, Royal Engineers Territorial Army. Payments received from the Army Pay Office, Kentigern House, 65 Brown Street, Glasgow G2 8EX: | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2013-02-04-1f359ece-11715-0 |
ee4cadd2012d2363125c5d604b8570e7a4289ac1 | 14 May 2012, received payment of £1,310.53 for 15 days military service between 1 January-30 April 2012. (Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2013-02-04-1f359ece-11715-0 |
6f227af8192860bf71fc904e9a288ce1a5bed42e | 10 December 2012, received payment of £907.83 for 8.25 days military service between 1 May-31 August 2012. (Registered 11 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2013-02-04-1f359ece-11715-0 |
ffd90179a13f15e9c63a73d4c17e5974719e5ec6 | Management consultant giving advice on strategy and business to Palmer Capital Partners Ltd (Palmer Capital), Time and Life Building, One Bruton Street, London W1 6TL; a privately owned venture capital and fund management business which specialises in property. (Resigned 4 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2013-02-04-1f359ece-11715-0 |
8967fc084c6a835b67526ac508db2fbbb1ba7d69 | Received quarterly payment (November 2011-January 2012) of £4,999.98. Hours: 33 hrs. (Registered 21 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2013-02-04-1f359ece-11715-0 |
1d794d3be36a28b5522d752dc5d8abf3dca378e5 | Received quarterly payment (February-April 2012) of £4,999.98. Hours: 33 hrs. (Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2013-02-04-1f359ece-11715-0 |
670d6f2531b0b34b1f25a689d4a87008cd7d1c10 | Received quarterly payment (May-August 2012) of £6,666.64. Hours: 44 hrs. (Registered 6 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2013-02-04-1f359ece-11715-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");