items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2012-01-13-1f359ece-11715-0" sorted by hash descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▲ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
cd1c892bbca85b139d3fa85de39d02261bffc741 | 30 June 2011, received payment of £750.53 for 10 days military service between 1 May-30 June 2011. (Registered 25 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2012-01-13-1f359ece-11715-0 |
c23531c2cd53972cbc2e60128435589d8bd611bd | 30 April 2011, received payment of £383.12 for 4 days military service between 1 November 2010-30 April 2011. (Registered 22 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2012-01-13-1f359ece-11715-0 |
8d62df57f27b37a93f3db308c4f5c3abf7c3ec71 | Received quarterly payment (February-April 2011) of £4,999.98. Hours: 33 hrs. (Registered 26 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2012-01-13-1f359ece-11715-0 |
610c99880ac9fce42a12dc1cc8053851e1d9cdeb | 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 | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2012-01-13-1f359ece-11715-0 |
44b4629e25aba345287ecbafcb1b1cb993f63dba | 31 October 2010, received payment of £1256.80 for 17 days military service between 1 August-31 October 2010. (Registered 1 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2012-01-13-1f359ece-11715-0 |
3104135ba6598d09d59358050ec08e145637c0e7 | 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. | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2012-01-13-1f359ece-11715-0 |
20ca5c242af145667150a48757e390c2a8bfe99b | Received quarterly payment (May-July 2011) of £4,999.98. Hours: 33 hrs. (Registered 24 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2012-01-13-1f359ece-11715-0 |
07b111084862b4582e91954c6fa668713441741a | Received quarterly payment (August-October 2011) of £4,999.98. Hours: 33 hrs. (Registered 16 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 7 | 2012-01-13-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");