items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-02-28-8f616a6e-10069-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 |
---|---|---|---|---|---|---|---|
ad2f80e1dfcaeabbdcdec6d023de4abc24de0f31 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-02-28-8f616a6e-10069-0 |
1c01b332e2b9e301313e200ca592a00970d3f67a | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-02-28-8f616a6e-10069-0 | |
28e9b6b2fefd1c58d97cf84f4ff20ee72cc6c9c7 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-02-28-8f616a6e-10069-0 |
73a9c498191d7b2d3652aee3593473f7879274f2 | Address of donor: private | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-02-28-8f616a6e-10069-0 |
b04f84ba6633c446d59bfc523ab767a82d8bc143 | Amount of donation or nature and value if donation in kind: £7,500 donated to the Newcastle East Parliamentary Association, which will report it to the Electoral Commission. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-02-28-8f616a6e-10069-0 |
b696640f6a14015eeeff2188d21ab12a98d99974 | Donor status: individual | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-02-28-8f616a6e-10069-0 |
c3b20d26b35419c1e1251839d006e3ed99a8ed64 | Name of donor: GMB | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-02-28-8f616a6e-10069-0 |
2c9ebd9089c336b473525626e7318f133ae6556c | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-02-28-8f616a6e-10069-0 |
68e33db957a312640cc4f47a71ace9737e3e0ff5 | Amount of donation or nature and value if donation in kind: £3,500 donated to the Newcastle East Parliamentary Association, which will report it to the Electoral Commission. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-02-28-8f616a6e-10069-0 |
9d845fc971b01d9d3bafb8c7a680d08c814a210c | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-02-28-8f616a6e-10069-0 |
d5ca2a29ecf01f546e6f0b8cad48691217a3ac82 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-02-28-8f616a6e-10069-0 |
1d2163f993da020cf6065c28bcc3b90537b0cda1 | Donor status: company | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-02-28-8f616a6e-10069-0 |
bf04808d532e6b03a0dc64d84f69a7ce6f157182 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-02-28-8f616a6e-10069-0 |
a295a28429e3b40d0516aabfad22b4cb2c91eb4e | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-02-28-8f616a6e-10069-0 |
817bf1085435f02ba567041872e7ffa59c05d0a3 | Amount of donation or nature and value if donation in kind: £2,000 donated to the Newcastle East Parliamentary Association, which will report it to the Electoral Commission. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-02-28-8f616a6e-10069-0 |
4a61001b18b0034b02f402d840ff41325712cdfc | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-02-28-8f616a6e-10069-0 |
fbf508cc7f18e5a06e727a24c950741691f831e2 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-02-28-8f616a6e-10069-0 |
cd6e8af321097fc0ee446aab7ad8d1c80ac203e6 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-02-28-8f616a6e-10069-0 |
46cbdc30e8829601583f532e560b152d93f4c042 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-02-28-8f616a6e-10069-0 |
4ca21c3bd9ee0f1dd47a33b7ed55a1a33c78aed3 | Donor status: trade union | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-02-28-8f616a6e-10069-0 |
b1017760040cd9eeef726d0c3697f2d0bebdaa96 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-02-28-8f616a6e-10069-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");