items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where "date" is on date 2013-09-30 and member_id = "uk.org.publicwhip/member/40660" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f7cf6dc461ce5ed42878d21f5a2e8a17cf59f79e | Payments from Ipsos Mori , 79-81 Borough Road, London SE1 1FY, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 0 | 2013-09-30-1f359ece-24901-0 |
d34a90a001dedcbbbe2ae9bd5296281a9d3c6283 | Received £150 on 8 October 2012for survey on 1 August 2012. Hours: 1 hr. (Registered 8 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 1 | 2013-09-30-1f359ece-24901-0 |
cc3214048026e81cb7dda7efd47a882733a4e5e0 | Received £150 on 31 December 2012 for survey on 12 November 2012. Hours: 1 hr. (Registered 9 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 2 | 2013-09-30-1f359ece-24901-0 |
8248746f6640a5d25450d3a707ad77239abe678a | Received £200 on 9 September 2013 for survey on 25 June 2013. Hours: 1 hr. (Registered 25 September 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 3 | 2013-09-30-1f359ece-24901-0 |
b1924d9a83b6a3f42fdc44a49b39b07b7520e404 | Name of donor: PRS for Music Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 0 | 2013-09-30-84642823-24901-0 |
8265dfe4178c0486634de6be89b204aa3bbb53ce | Address of donor : 29-33 Berners St, London W1T 3AB | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 1 | 2013-09-30-84642823-24901-0 |
2034800d44901c03f4e89f54897bea924eead1a4 | Amount of donation or nature and value if donation in kind: two tickets to Glastonbury Festival; value £1,340 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 2 | 2013-09-30-84642823-24901-0 |
c973f0f9e8a71b0bd459da188a96a397c37f6040 | Date of receipt of donation: 26 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 3 | 2013-09-30-84642823-24901-0 |
59d99845c5eba64c7fa026abf92a1f02cd2b3c17 | Date of acceptance of donation: 29 and 30 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 4 | 2013-09-30-84642823-24901-0 |
8394afbef9492fc6108481a798bad113dbadf090 | Donor status: company, registration 3444246 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 5 | 2013-09-30-84642823-24901-0 |
5e62f92cb74110e4500715a397075577e33b86f2 | (Registered 26 July 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 6 | 2013-09-30-84642823-24901-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");