items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where "date" is on date 2011-09-28 and member_id = "uk.org.publicwhip/member/40222" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3ba2ce61977be05a9c70190efa72d40728486dc9 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-09-28-1f359ece-24715-0 |
4d4586b9bf7eea23a95143eec773527985ae9f75 | Received fee of £75 for completing a survey. Hours: 25 mins. Payment donated to my local party. (Registered 15 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-09-28-1f359ece-24715-0 |
8bfe817cd2d13c57c665292d88f92a0203c1e170 | Received fee of £75 for completing a survey. Hours: 30 mins. Payment donated to charity. (Registered 23 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-09-28-1f359ece-24715-0 |
8ba6896934a05a0edc319d6649aa8d58e8755661 | Populus, 10 Northburgh Street, London EC1V 0AT | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-09-28-1f359ece-24715-0 |
c10778951ea45a78af6357b146f1e678310c9ad0 | Received £75 for participation in opinion research on 24 June 2011. Hours: 25 mins. Payment donated to charity. (Registered 13 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-09-28-1f359ece-24715-0 |
59649ab8a288c8547f7f3f751dbe7cf95b8e9761 | Name of donor: Grand Central Railway Company Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-09-28-84642823-24715-0 |
3feab8c48b17449b66b8a98f328046dc2a858c66 | Address of donor : River House, 17 Museum Street, York, Y01 7DJ | Gifts, benefits and hospitality (UK) 84642823 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-09-28-84642823-24715-0 |
11a08af9ec0fe778f3001601c8c170fe97eb1bb5 | 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-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-09-28-84642823-24715-0 |
318cf0f297013aa37452891ae94a97481ec7d492 | Date of receipt of donation: 25 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-09-28-84642823-24715-0 |
909a6bb43f6f2d6724d5007f1959e95cd156b3c5 | Date of acceptance of donation: 1 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-09-28-84642823-24715-0 |
22990cb6b341fd9cf6cee08232a4375f9732113d | Donor status: company, registration number 03979826 | Gifts, benefits and hospitality (UK) 84642823 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2011-09-28-84642823-24715-0 |
9451d9e6987b4469b576bc6cd57cfe9dda3cbe8f | (Registered 9 June 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 6 | 2011-09-28-84642823-24715-0 |
631f207ca750edd5134ea9c936ccc5a437ac2061 | Name of donor: Sir Joseph Hotung | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-09-28-80ef1083-24715-0 |
07f2b6b58c564e032193481648af5814e72eab4c | Address of donor: Sir Joseph Hotung Programme for Law, Human Rights and Peace Building in the Middle East, School of Oriental and African Studies, Thornhaugh Street, Russell Square, London WC1H 0XG | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-09-28-80ef1083-24715-0 |
2f2b4e877c9ddbdaf71298c00aa4e375be1227e9 | Amount of donation (or estimate of the probable value): £1,000 | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-09-28-80ef1083-24715-0 |
c60fec1182846af36f697695247be1da8e21cf96 | Destination of visit: West Bank, Palestine/Israel | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-09-28-80ef1083-24715-0 |
e8d591198056d353a6436122b995f764a6bbec1b | Date of visit: 25-29 November 2010 | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-09-28-80ef1083-24715-0 |
68ab9513dab15795f85a7de8373f5737dbbdb681 | Purpose of visit: to further understanding of issues associated with the Israeli occupation of the West Bank. Meetings with various NGOs and representatives of the Palestinian Authority and Israeli officials. | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2011-09-28-80ef1083-24715-0 |
28ebb64a145eab15017413a6ddbbba4a1725d9d7 | (Registered 3 March 2011) | Overseas visits 80ef1083 | 2011-09-28 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 6 | 2011-09-28-80ef1083-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");