items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2011-10-31-1f359ece-13814-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 |
---|---|---|---|---|---|---|---|
e1f3e3181badb8c314fa7253ace599877d4bfde6 | Elected member of Belfast City Council, City Hall, Belfast BT1 5GS until 25 August 2010. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 0 | 2011-10-31-1f359ece-13814-0 |
fad983fa2c9330def8126ef88dfc407926ebae4a | Salary payment of £811.50 gross for August 2010 (£77.10 returned to council in respect of period 25 August to 31 August 2010). Hours: 20 hours. (Registered 26 September 2010). | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 1 | 2011-10-31-1f359ece-13814-0 |
343d902ed546a29c5294b7e79bcdd3278acb7790 | Payments from ComRes, 4 Millbank, London, SW1P 3JA, for completing Parliamentary Panel Surveys: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 2 | 2011-10-31-1f359ece-13814-0 |
1f5d77b56b33bdf9821b8ed9535bfb525e1ae5fa | Payment of £75 for June 2010 survey. Hours: 15 mins. Payment donated to the Alliance Party. (Registered 17 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 3 | 2011-10-31-1f359ece-13814-0 |
b1eec69a0ab9a014e9f6ab0561ec23aebd1e38a7 | Payment of £75 for October 2010 survey. Hours: 15 mins. Payment donated to the Alliance Party. (Registered 17 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 4 | 2011-10-31-1f359ece-13814-0 |
7d716a2bb809e1f4a27c90581d3024bcc61b910d | Payment of £75 for November 2010 survey. Hours: 15 mins. Payment donated to the Alliance Party (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 5 | 2011-10-31-1f359ece-13814-0 |
d4dd22e244297a438b4b837b3296fa5110cbd7d8 | Payment of £75 for January 2011 survey. Hours: 15 mins. Payment donated to the Alliance Party. (Registered 1 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 6 | 2011-10-31-1f359ece-13814-0 |
0803c1ffc249d3c69cbb5271183fc464b7d12540 | Payment of £75 for March 2011 survey. Hours: 15 mins. Payment donated to the Alliance Party. (Registered 25 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 7 | 2011-10-31-1f359ece-13814-0 |
6ae4949f7f28bc898f3874de22a14335c5eff63d | Payment of £75 for May 2011 survey. Hours: 15 mins. Payment donated to the Alliance Party. (Registered 1 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 8 | 2011-10-31-1f359ece-13814-0 |
8c7854773b5b1819444d364a69748f324e61c430 | Payment of £50 from Populus, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research. Hours: 15 mins. Payment donated to the Alliance Party. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 9 | 2011-10-31-1f359ece-13814-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");