items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2010-11-22-9e46def6-11592-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 |
---|---|---|---|---|---|---|---|
d1c7929f81dae3100c6a0cd7444139e9c473837f | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 0 | 2010-11-22-9e46def6-11592-0 |
e8c6d613acceed1295af785bad6c32542f7fe132 | Name of donor: Communication Workers’ Union | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 1 | 2010-11-22-9e46def6-11592-0 |
7b99462ea0193f4a2e4c913938fc3b592823089b | Address of donor: 150 The Broadway, Wimbledon, London SW19 1RX. | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 2 | 2010-11-22-9e46def6-11592-0 |
eca045edca824eabe51bab72c38f471ecde77418 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 3 | 2010-11-22-9e46def6-11592-0 |
413e4a9d691187e2c5b7558b8f7c99e5c8e4c9eb | Donor status: trade union | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 4 | 2010-11-22-9e46def6-11592-0 |
b9cc32bacecf6dbf88cece33f4b3589c31a34568 | (Registered 11 June 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 5 | 2010-11-22-9e46def6-11592-0 |
b37decd1ee8fcd08740b18722f492b10b0eb582a | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 6 | 2010-11-22-9e46def6-11592-0 |
44472aafbd34694f400a5f2c0746a7a012c505d2 | Name of donor: Christian Action Research and Education (CARE) | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 7 | 2010-11-22-9e46def6-11592-0 |
0a0c8ed25f580a5763599ec926b59cb9cc228814 | Address of donor: 53 Romney Street, London SW1P 3RF. | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 8 | 2010-11-22-9e46def6-11592-0 |
3e6d03ba1f05fd05e7050e9b00f6516f083e95cf | Amount of donation or nature and value if donation in kind: provision of an intern to work four days a week in my parliamentary office. He receives a bursary of £5,000. | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 9 | 2010-11-22-9e46def6-11592-0 |
1f05ecdb03062ff3b94b70ee18cce7dc930599a5 | Date of receipt: 9 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 10 | 2010-11-22-9e46def6-11592-0 |
00518648fd87c68a274bb0572c175707d87c79cf | Date of acceptance: 9 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 11 | 2010-11-22-9e46def6-11592-0 |
31755aad2e32d8cb40539d82a6a762bb19824a09 | Donor status: charity. | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 12 | 2010-11-22-9e46def6-11592-0 |
79397a00f434fb01eaab092ff3433b9354bfbbe3 | (Registered 4 February 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Sharon Hodgson uk.org.publicwhip/member/40636 | Sharon Hodgson uk.org.publicwhip/person/11592 | 13 | 2010-11-22-9e46def6-11592-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");