items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2012-04-30-9e46def6-11740-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0007c3c5de7526cc10f21de5d3646c12c666493c | Date of receipt: 4 January to 27 April 2012 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 11 | 2012-04-30-9e46def6-11740-0 |
0673b2dd1971dbcea444970ae044a672453fcb73 | (Registered 23 April 2012) | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 28 | 2012-04-30-9e46def6-11740-0 |
10c1233ceab75a11dbe7f15cdbc5375ea5ea8a13 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 27 | 2012-04-30-9e46def6-11740-0 |
19cd0dc4dd1e373476e13ea329ff6786e9d86b24 | Amount of donation or nature and value if donation in kind: Bloomberg terminal and pro licence at £15,000 each year (£7,000 July-December 2011) | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 3 | 2012-04-30-9e46def6-11740-0 |
24a6d67965a60ffacc5eb5ed08095cb994723960 | (Registered 14 January 2012) | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 14 | 2012-04-30-9e46def6-11740-0 |
259e117889c0446294a7cfdec1b1383df493f54c | Date of acceptance: 6 June 2011 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 5 | 2012-04-30-9e46def6-11740-0 |
2f002bc48898c3e8f7b9c59555ce0505fcc6c86d | Name of donor: Pricewaterhouse Coopers | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 8 | 2012-04-30-9e46def6-11740-0 |
3b3259d30c7f265c4bddab3aa29085e63a1f36d8 | Donor status: company, registration number 03556095 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 6 | 2012-04-30-9e46def6-11740-0 |
43709f7cdce59aed90a77dc5a8be8f6454afe8a7 | (Registered 27 July 2011) | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 7 | 2012-04-30-9e46def6-11740-0 |
44db90eebc0a7a5c4363a4067cb3d741f0deeaa6 | Address of donor: City Gate House, 39/45 Finsbury Square, London EC2A 1PQ | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 2 | 2012-04-30-9e46def6-11740-0 |
50c12675c2c6c3b3d069ebcef14bd1f70ddb1e48 | Amount of donation or nature and value if donation in kind: £50,000 received through the Labour Party to support the Shadow Chancellor’s office | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 17 | 2012-04-30-9e46def6-11740-0 |
61505af74449135c4f2150bb0ebf9a71053c366c | Date of acceptance: 4 January to 27 April 2012 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 12 | 2012-04-30-9e46def6-11740-0 |
770e2e5bf5b6c16dc4cf21ca7f2cfecb988a176c | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 0 | 2012-04-30-9e46def6-11740-0 |
7bb7c5ad5baa1e4f09dec658570ea719c849a837 | Date of receipt: 6 June 2011 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 4 | 2012-04-30-9e46def6-11740-0 |
7f5053c0609581727e86f42e9e871959a0d911d7 | Date of acceptance: 31 March 2012 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 19 | 2012-04-30-9e46def6-11740-0 |
93aea410e25ffcf132fe1d46374ca3ed9bce778f | Address of donor: 1 Embankment Place, London WC1N 6RM | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 9 | 2012-04-30-9e46def6-11740-0 |
96fa856910b0d6d8cc0d993885c58569287d4410 | Address of donor: New Century House, Corporation St, Manchester M60 4ES | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 16 | 2012-04-30-9e46def6-11740-0 |
9d17cf8d4743be598957809af99f024fa89acc30 | Amount of donation or nature and value if donation in kind: £10,000 received through the Labour Party to support the Shadow Chancellor’s office | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 24 | 2012-04-30-9e46def6-11740-0 |
a6223afd6956399bf9325bd3000c771c172cc3f4 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 23 | 2012-04-30-9e46def6-11740-0 |
ad1d1361ae53bc0d6d0959a0023938132f7bfed6 | Donor status: Limited Liability Partnership | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 13 | 2012-04-30-9e46def6-11740-0 |
af657aceddb97fcfbabf3ac74bb14a813d27473a | Date of receipt: 26 March 2012 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 25 | 2012-04-30-9e46def6-11740-0 |
b845c731b980da2656dfdd56939c81265ca6d937 | Name of donor: Lord Bhattacharyya | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 22 | 2012-04-30-9e46def6-11740-0 |
ba767176535e987b97cd59547b93d5cb241f0e3d | Date of acceptance: 26 March 2012 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 26 | 2012-04-30-9e46def6-11740-0 |
bdb179ba3fa0e565d74cc137b27adcb701ede1c3 | Donor status: company, IP525R | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 20 | 2012-04-30-9e46def6-11740-0 |
bf92c5817d48fbf0d61bf573b94b789a78300444 | Name of donor: The Co-operative Group Ltd | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 15 | 2012-04-30-9e46def6-11740-0 |
dbe9eeaca2017890f98b49ec030e723ee0c7dd34 | Name of donor: Bloomberg Tradebook Europe Limited | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 1 | 2012-04-30-9e46def6-11740-0 |
dcf770a649133332ace0b9aa8de06d1650851db2 | Date of receipt: 31 March 2012 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 18 | 2012-04-30-9e46def6-11740-0 |
ff15ebbb650a95462fbea9e32e00c32ecb6915cd | Amount of donation or nature and value if donation in kind: the services of a research assistant/analyst to support me in my opposition front bench role, for 4 days a week on a 17 week secondment from 4 January 2012 until 27 April 2012, value £59,976 | Sponsorship or financial or material support 9e46def6 | 2012-04-30 | Edward Balls uk.org.publicwhip/member/40411 | Edward Balls uk.org.publicwhip/person/11740 | 10 | 2012-04-30-9e46def6-11740-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");