items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2010-12-20-1f359ece-13814-0" sorted by sort_order descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
67cdf8cba52b4565552516d623d2f1f499fa2900 | 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 | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 8 | 2010-12-20-1f359ece-13814-0 |
40695c66c84589b555bff509a4b8786b8960435e | Salary payment of £811.50 (gross) for July 2010. Hours: 35 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 7 | 2010-12-20-1f359ece-13814-0 |
34800e44dbf91ae19615db237b6d90d5cdbaddc1 | Salary payment of £.811.50 (gross) for June 2010. Hours: 60 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 6 | 2010-12-20-1f359ece-13814-0 |
dc91a6260eccf6ea4357d0faf0f9a98b4734dde7 | Salary payment of £811.50 (gross) for May 2010. Hours: 120 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 5 | 2010-12-20-1f359ece-13814-0 |
9c0d3d8b15af608fcf7af62bfa310130dc3c2817 | Elected member of Belfast City Council, City Hall, Belfast BT1 5GS until 25 August 2010. | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 4 | 2010-12-20-1f359ece-13814-0 |
65df4bc15ecf50e001dd7c27f2b8b63fbacfb1d1 | Salary payment of £110.30 (gross) for July 2010. Hours: 9 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 3 | 2010-12-20-1f359ece-13814-0 |
9508c3c155817dcabf27e50ef274a9adf6c77b7d | Salary payment of £1,169.50 (gross) for June 2010. Hours: 110 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 2 | 2010-12-20-1f359ece-13814-0 |
e54a64100fa682c53998b4f2856d6ed65567cf67 | Salary payment of £2,132.95 (gross) for May 2010. Hours: 140 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 1 | 2010-12-20-1f359ece-13814-0 |
0a5a34ce74f378140edcc62df36a7a709be2fcc9 | Member of Northern Ireland Assembly, Parliament Buildings, Stormont BT4 3XX until 5 July 2010. | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 0 | 2010-12-20-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");