items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2010-11-22 and person_id = "uk.org.publicwhip/person/10069" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
6e8fc09b8dc8c54ab0f681656d43bfba922a5a66 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-11-22-8f616a6e-10069-0 |
e2c0d5dc4e797e4bd77f1a600eb4e8344a2ccfcc | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-11-22-8f616a6e-10069-0 | |
59d0b41eb731ef109eb544d19275d6d78b9b9625 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-11-22-8f616a6e-10069-0 |
3c80ef454c612376e818f01a1f6561625dcb4035 | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-11-22-8f616a6e-10069-0 |
30bb3ba625c573f3806ada65d56b1f265a4a55f9 | Amount of donation or nature and value if donation in kind: Sponsorship of the Newcastle East Parliamentary Labour Party Christmas Dinner to the value of £5104.35 | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2010-11-22-8f616a6e-10069-0 |
efdfdca4fce2c496ec7c67b10018585ce3312adf | Donor status: Company | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-11-22-8f616a6e-10069-0 |
2331f5b3f2d8764839207b8b1d6afe2c0ab27d68 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-11-22-8f616a6e-10069-0 |
56c4e5340e9f342a4f8dd4d491b02182d3d87352 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-11-22-8f616a6e-10069-0 |
75686555414f94f3c5402dbd3846b61e449ea288 | Amount of donation or nature and value if donation in kind: Bought two tables at the Newcastle East Parliamentary Labour Party Christmas Dinner at the cost of £2000. | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-11-22-8f616a6e-10069-0 |
92252fbd72ddfc76c2aaf26d3d5692bae754ebf9 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2010-11-22-8f616a6e-10069-0 |
8a4f93d7b5de09c3666851ff336b677a6bb50556 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2010-11-22-8f616a6e-10069-0 |
c1e383bb7577538814278f1f0795e07a0b68ee36 | Address of donor: private | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2010-11-22-8f616a6e-10069-0 |
1a2b3ddaffe608f4c3019d5890053e59365b84a2 | 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 | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2010-11-22-8f616a6e-10069-0 |
d3b6a79d369971b0bfb7bca08f40395e90986261 | Donor status: individual | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2010-11-22-8f616a6e-10069-0 |
a32caebf169e6c1602044a9d8cbec9b186167de6 | Name of donor: GMB | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2010-11-22-8f616a6e-10069-0 |
0bce717f6d6e1180e6dca3d98e8a81c41312176a | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2010-11-22-8f616a6e-10069-0 |
b59ff4e69677f33d1826dde452c4f8ebec26eafc | 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 | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2010-11-22-8f616a6e-10069-0 |
d3254f071fa7fe74c3d9a2cf5cb2cf8baba2f7b1 | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2010-11-22-8f616a6e-10069-0 |
ee0869d4fcd8f9eb7ba9abbdab8bd6b2cc9d0e82 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2010-11-22-8f616a6e-10069-0 |
ceedaa9377a4729e0274c6b4d9d371e6812e4c40 | Donor status: company | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2010-11-22-8f616a6e-10069-0 |
7138bd48be151564af928da9efdeb32ed87c4f4c | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2010-11-22-8f616a6e-10069-0 |
4c514e10895edde276cc69fff0cfe34c3f23bfa1 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2010-11-22-8f616a6e-10069-0 |
d0e8edca587f904d3bb72f8ed136cb3cb6092afd | 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 | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2010-11-22-8f616a6e-10069-0 |
d10ef355720064d33a9ca1ded04d86a07e8cf864 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2010-11-22-8f616a6e-10069-0 |
6f1b94c1b0faa16bca98e48fa4060d23a3bfbf62 | Name of donor: CWU | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2010-11-22-8f616a6e-10069-0 |
d5e9c3dab602605f435abec82ec16bff31e01796 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2010-11-22-8f616a6e-10069-0 |
6b8d579152de772d6d3a58ca39b7c9f24220e04a | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2010-11-22-8f616a6e-10069-0 |
9d2ce2afb0c36b352ad16b8816733052824d7ffe | Donor status: trade union | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2010-11-22-8f616a6e-10069-0 |
b07b9935afe773bc098f9cbc573ff263abc57a00 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2010-11-22-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");