items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where "date" is on date 2011-02-28 and member_id = "uk.org.publicwhip/member/40222" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ab6c6a899b52d2094c96cf5d0ab90004027b70d4 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-02-28-1f359ece-24715-0 |
1d0c5d4936d9903e261517d9ee02722ba6058d69 | Received fee of £75 for completing a survey. Hours: 30mins. Donated to charity. (Registered 27 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-02-28-1f359ece-24715-0 |
788454d061a35d446a7aa1ed62fc39df08c26674 | Received fee of £75 for completing a survey. Hours: 30 mins. Donated to my local party. (Registered 27 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-02-28-1f359ece-24715-0 |
ac108d8731a46de744e4abc38614dc1860d6132a | Received fee of £75 for completing a survey. Hours: 25 mins. Donated to my local party. (Registered 15 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-02-28-1f359ece-24715-0 |
ede769b528a2cff094f755bf439785f96c3f5724 | Received fee of £75 for completing a survey. Hours: 30 mins. Donated to charity. (Registered 23 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-02-28-1f359ece-24715-0 |
1a34433943b263a096e0194a0d94b73dc5e972bc | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-02-28-8f616a6e-24715-0 |
40391212674ed77d6f48b53d3a05da1b4b70a36e | Name of donor: Dalton Construction UK Ltd | Sponsorships 8f616a6e | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-02-28-8f616a6e-24715-0 |
3cb545bf69a65ea012387f0d915b01c3625d56db | Address of donor: A1 Marquis Court Marquisway Team Valley Gateshead Tyne and Wear NE11 0RU | Sponsorships 8f616a6e | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-02-28-8f616a6e-24715-0 |
213b2beb5579d5a073045b761e80f4c62ceef20b | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-02-28-8f616a6e-24715-0 |
3bca0741c0005ae283268607c0dea8783a6e4205 | Donor status: company | Sponsorships 8f616a6e | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-02-28-8f616a6e-24715-0 |
d7c583873a935243100d114afbfd6b720971e416 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2011-02-28-8f616a6e-24715-0 |
16aee3404efc4b37e651d056881fafd4c1610796 | Name of donor: Grand Central Railway Company Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-02-28-84642823-24715-0 |
748d2319ab3b75e8633b615638c6614c085ae661 | Address of donor : River House, 17 Museum Street, York, Y01 7DJ | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-02-28-84642823-24715-0 |
78d02d64c298f5843d0f27e6cda1ca47b25d9291 | Amount of donation or nature and value if donation in kind: complimentary first class pass valid for travel on Grand Central services. On the basis of the usage I expect, the value of the pass is approximately £1,900. Without the pass, part of the travel costs would be met from parliamentary allowances. | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-02-28-84642823-24715-0 |
81892d2c98b1152d94e815e005931e850548bc65 | Date of receipt of donation: 25 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-02-28-84642823-24715-0 |
20a12abc4672670871a1c3530854fd78f30f4422 | Date of acceptance of donation: 1 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-02-28-84642823-24715-0 |
3a5c64f2e42889663c6ae1dc1048365f300b4190 | Donor status: company, registration number 03979826 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2011-02-28-84642823-24715-0 |
1f0a767be79124ceb8438549e088b8c3d196bd95 | (Registered 9 June 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 6 | 2011-02-28-84642823-24715-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");