items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2010-11-22-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 |
---|---|---|---|---|---|---|---|
d1284ec21d8d0b64bee12dfa74e4105f70b677c8 | 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-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 8 | 2010-11-22-1f359ece-13814-0 |
0a2c6ffacae2f5d14625e9ae033bf23d1191cb6a | Salary payment of £811.50 (gross) for July 2010. Hours: 35 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 7 | 2010-11-22-1f359ece-13814-0 |
b0b90944c2063c82e907bedeb8c171d5ee8dedc5 | Salary payment of £.811.50 (gross) for June 2010. Hours: 60 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 6 | 2010-11-22-1f359ece-13814-0 |
b7a17adc84b48051776d6f87af19afe0b983ea22 | Salary payment of £811.50 (gross) for May 2010. Hours: 120 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 5 | 2010-11-22-1f359ece-13814-0 |
8a2bc14c5a8edaa7866404b124e0955b4c9c0b34 | Elected member of Belfast City Council, City Hall, Belfast BT1 5GS until 25 August 2010. | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 4 | 2010-11-22-1f359ece-13814-0 |
b23e3b4db737e93a7b4159a9a9e2c234d2c4673b | Salary payment of £110.30 (gross) for July 2010. Hours: 9 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 3 | 2010-11-22-1f359ece-13814-0 |
f3fd2cfb53a181a5feded4f9f4f7a64560efe02b | Salary payment of £1,169.50 (gross) for June 2010. Hours: 110 hrs. (Registered 31 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 2 | 2010-11-22-1f359ece-13814-0 |
1bca7ca8463bf3ce7b6a5ab6bf73598ae7ab92a6 | Salary payment of £2,132.95 (gross) for May 2010. Hours: 140 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 1 | 2010-11-22-1f359ece-13814-0 |
4193bff98dec1eba727697946f2bc9f9b19f8c77 | Member of Northern Ireland Assembly, Parliament Buildings, Stormont BT4 3XX until 5 July 2010. | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Naomi Long uk.org.publicwhip/member/40068 | Naomi Long uk.org.publicwhip/person/13814 | 0 | 2010-11-22-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");