items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where "date" is on date 2011-01-10 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 |
---|---|---|---|---|---|---|---|
ff04842d1452e048176a6c07cd4345ba8bd4ebdc | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-01-10-1f359ece-24715-0 |
4cd086ebff9749a830a6ad5a1b9946c731bfe862 | Received fee of £75 for completing a survey. Hours: 30mins. Donated to charity. (Registered 27 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-01-10-1f359ece-24715-0 |
0dfe4a3949103e11d4fbebd2732306e4421c198e | 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-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-01-10-1f359ece-24715-0 |
daa7d0d5ac791aec1124cde3044af5bb7aa7bad5 | 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-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-01-10-1f359ece-24715-0 |
de0d5e83fe0a83c1e370e386f6db2f85929c0d23 | 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-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-01-10-1f359ece-24715-0 |
7f7021f8f64b7f4e13f44cbb9a98ed733cb0ef79 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-01-10-8f616a6e-24715-0 |
01fbb491b0e2f09c19ff429072fc8d886f60ae8f | Name of donor: Dalton Construction UK Ltd | Sponsorships 8f616a6e | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-01-10-8f616a6e-24715-0 |
7000496fb1a30e956dd3b0625f73ffacc0110d61 | Address of donor: A1 Marquis Court Marquisway Team Valley Gateshead Tyne and Wear NE11 0RU | Sponsorships 8f616a6e | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-01-10-8f616a6e-24715-0 |
582e12b6c7f962a17b1d0e2e37e6775ea5b94e01 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-01-10-8f616a6e-24715-0 |
0fddf031f4e2d8f4b784dca1f3ef33feacbd1c0b | Donor status: company | Sponsorships 8f616a6e | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-01-10-8f616a6e-24715-0 |
6bcdb6d2e6191e1959bd2d1d285b6d055082e42e | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2011-01-10-8f616a6e-24715-0 |
b2c350c9b9ec8b80f728b7047b8cd9c839c751c6 | Name of donor: Grand Central Railway Company Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2011-01-10-84642823-24715-0 |
00f7933eac3f1fbcff2ec51e8a38c007580f4f9f | Address of donor : River House, 17 Museum Street, York, Y01 7DJ | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 1 | 2011-01-10-84642823-24715-0 |
2f9691e1dd03a3321586925e4b4cdf8db95f072a | 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-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2011-01-10-84642823-24715-0 |
7fe8c931dec21b0b5bdd1625f38ee00a6eaa9fee | Date of receipt of donation: 25 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 3 | 2011-01-10-84642823-24715-0 |
a9e86b097b2766d581fad5822873cd1d5b04f73c | Date of acceptance of donation: 1 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2011-01-10-84642823-24715-0 |
b5e8a489a3715e532a2b5f6e290d68a647ec5b92 | Donor status: company, registration number 03979826 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2011-01-10-84642823-24715-0 |
50816d59a6884a36f20dde3650593bcdaa4515f6 | (Registered 9 June 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-10 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 6 | 2011-01-10-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");