items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2012-03-19-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 |
---|---|---|---|---|---|---|---|
21f847d8315441e7ea44d5c45ca9953345546a1e | 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-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2012-03-19-1f359ece-11715-0 |
89c334d3b9eeac0b12bf0eb8389ce867d0332851 | 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-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2012-03-19-1f359ece-11715-0 |
2bf5e6dd9f7d192d49ec8bd31b11939c62671380 | 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-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2012-03-19-1f359ece-11715-0 |
d6e4d29a28a7ac8b9e6121315b8e34aedb39a6df | 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-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2012-03-19-1f359ece-11715-0 |
dbaa34eb77a57738c47a2f906eef4f1b7e7f6d96 | Received quarterly payment (February-April 2011) of £4,999.98. Hours: 33 hrs. (Registered 26 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2012-03-19-1f359ece-11715-0 |
504290c74a8c18222b39b9e6f011bdc9671d26d1 | Received quarterly payment (May-July 2011) of £4,999.98. Hours: 33 hrs. (Registered 24 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2012-03-19-1f359ece-11715-0 |
c2d45b5aebb6e15b1322d86782ca6ca0c6b8dba7 | Received quarterly payment (August-October 2011) of £4,999.98. Hours: 33 hrs. (Registered 16 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2012-03-19-1f359ece-11715-0 |
00a2ea2c33ee70569412fa3333f79276e1a0ac07 | Received quarterly payment (November 2011-January 2012) of £4,999.98. Hours: 33 hrs. (Registered 21 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 7 | 2012-03-19-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");