items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2013-09-30-9e46def6-10766-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 |
---|---|---|---|---|---|---|---|
b02b87c09bd7181ec21345ed76247b243a4691d9 | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 0 | 2013-09-30-9e46def6-10766-0 |
306dcd2d369995ba2419fdb88b36fb89da80d09a | Amount of donation or nature and value if donation in kind: Rent reduction of £2,584 for the year 2012-13 in recognition of my office’s advice giving function. | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 3 | 2013-09-30-9e46def6-10766-0 |
ec7cc4a39858ef6f7cb0a05f2aa39890fac0f516 | Date of receipt: 8 November 2011 and 10 April 2012 | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 4 | 2013-09-30-9e46def6-10766-0 |
e28d9b8c48b0aa737fc12c30a9b8b7a6bbfa2e1d | Date of acceptance: 8 November 2011 and 10 April 2012 | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 5 | 2013-09-30-9e46def6-10766-0 |
03db0fca85daed946bfe12bb0da929e65baa92ac | (Registered 16 December 2011; updated 23 January 2013) | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 7 | 2013-09-30-9e46def6-10766-0 |
4b94038a2f98b7a4effa71e1fe31485b576dcdc5 | Name of donor: Wigan MBC | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 8 | 2013-09-30-9e46def6-10766-0 |
3ef2a046acc6796aa0b32b5ba950b37591189c85 | Address of donor: Town Hall, Wigan | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 9 | 2013-09-30-9e46def6-10766-0 |
4326e6630eec72b1047206c3b729c203cd4aa069 | Amount of donation or nature and value if donation in kind: Rent reduction of £2,584 for the year 2013-14 in recognition of my office’s advice giving function; ongoing since 7 May 2010 | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 10 | 2013-09-30-9e46def6-10766-0 |
d970497c3bb768a3d4e60db5e73796275ced6674 | Date of receipt: 7 May 2013 | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 11 | 2013-09-30-9e46def6-10766-0 |
d7e7a198decc4edbd6ed8d834abdc5fee84494d0 | Date of acceptance: 7 May 2013 | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 12 | 2013-09-30-9e46def6-10766-0 |
cd7a1bfbb2a843a4caa2b92056136787f74203ff | Donor status: Metropolitan Borough Council | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 13 | 2013-09-30-9e46def6-10766-0 |
409ba494fd54587c3ca80315de4513bc81fe0487 | (Registered 15 May 2013) | Sponsorship or financial or material support 9e46def6 | 2013-09-30 | Andy Burnham uk.org.publicwhip/member/40361 | Andy Burnham uk.org.publicwhip/person/10766 | 14 | 2013-09-30-9e46def6-10766-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");