items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2010-04-12-1f359ece-10002-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
54bd592d996878b28fcfe26d11bbc08194fce31a | Author. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 0 | 2010-04-12-1f359ece-10002-0 |
e2074dac9f0ef27f014ec79ce8de4260c62db5b3 | Member of the Northern Ireland Assembly. The hours are difficult to calculate as the roles of MP and MLA are often combined. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 1 | 2010-04-12-1f359ece-10002-0 |
2a6941eb9ca195a9bd52eab0ec7799451fcb1e42 | 29 July 2009, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 2 | 2010-04-12-1f359ece-10002-0 |
2e03ddcff616ddc8a690816941a17812a2ed599b | 26 August 2009, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 3 | 2010-04-12-1f359ece-10002-0 |
3029e8247830068189166da546585df018128d9a | 28 September 2009, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 4 | 2010-04-12-1f359ece-10002-0 |
cb1473d52fd46d8c60bba862ab47f969e245515f | 28 October 2009, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 5 | 2010-04-12-1f359ece-10002-0 |
c63ea80c72cf84222311ccdc81f4d873d530610d | 26 November 2009, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 6 | 2010-04-12-1f359ece-10002-0 |
0425f604442663bd1a0bb1f540f4beb72dc72231 | 18 December 2009, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 7 | 2010-04-12-1f359ece-10002-0 |
5ca31503b525ede6648cc3780636762eb3686e2d | 27 January 2010, gross monthly salary of £3591.75 (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 8 | 2010-04-12-1f359ece-10002-0 |
99ff573bc752455a3c586a10b45e94c47f1b2c4c | Writer for Belfast Media Group, Teach Basil, 2 Hannaghstown Hill, Belfast, BT17 0LT.Write a weekly column for Andersontown News; a weekly blog; and, a monthly column for Irish Echo in New York. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 9 | 2010-04-12-1f359ece-10002-0 |
51bdbaadbd8c4fd5b4966cadec77fb5ebf3e0d5a | July 2009, received payment of £800. Payment relates to work carried out in June 2009. Hours: 18hrs. (Registered 31 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 10 | 2010-04-12-1f359ece-10002-0 |
a5035eb1a92b64d1c1ea5be6f3dc7c1926b6172a | 26 August 2009, received payment of £800. Payment relates to work carried out in July 2009. Hours: 18hrs. (Registered 23 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 11 | 2010-04-12-1f359ece-10002-0 |
990ebbfb91d6cfcd2eee4cb874a25b3fda618a69 | 6 October 2009. Received a payment of £800. Payment relates to work carried out in September 2009. Hours: 18 hrs. (27 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 12 | 2010-04-12-1f359ece-10002-0 |
3a0fb6c954c5aede7a8967de3c57dd3a063a1d4d | 4 November 2009 Received a payment of £800. Payment relates to work carried out in October 2009. Hours: 18 hrs. (27 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 13 | 2010-04-12-1f359ece-10002-0 |
5c8e630221bff35b99fd73ba4881d5166301d79b | 3 December 2009, received £817.39 for work done in November 2009. Hours: 18 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 14 | 2010-04-12-1f359ece-10002-0 |
9412769346ff315448bbdcefc5b2d474536049e5 | 5 January 2010, received £817.39 for work done in December 2009. Hours: 18 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 15 | 2010-04-12-1f359ece-10002-0 |
778b178c9ad440004c6579e32f0095a83a58bcab | 12 January 2010, received a payment of £5000 (with £5000 to follow) from Pioneer Productions, 32 Galena Road, London W6 OLT, for work on a television documentary. The work included a week spent in the Holy Land/Middle East and approximately 44 hours in Ireland. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Gerry Adams uk.org.publicwhip/member/1403 | Gerry Adams uk.org.publicwhip/person/10002 | 16 | 2010-04-12-1f359ece-10002-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");