items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2011-01-10 and person_id = "uk.org.publicwhip/person/10069" sorted by hash
This data as json, CSV (advanced)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
00e591e320defe76d5755626c936c715f7899878 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-01-10-8f616a6e-10069-0 |
04628932196809728e934ac0ca811cfee264c6e3 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-01-10-8f616a6e-10069-0 |
090139d430d093168c3758b3dac09481ce0c638d | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2011-01-10-8f616a6e-10069-0 |
0a236001e537bddb14dd1a71daf85c7533c5eb99 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2011-01-10-8f616a6e-10069-0 |
0d0d8ebdca08b812746b41f60c560361eb7d377d | Donor status: individual | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-01-10-8f616a6e-10069-0 |
24589c99ce03b8fb4c2179ddb3370a9967338b39 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-01-10-8f616a6e-10069-0 |
296a7bb9c4a73db01d9f4c15d71e611d74ceb09c | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2011-01-10-8f616a6e-10069-0 |
29dd557961c3c4f4d3deacd9da8efc9de4298240 | Donor status: Company | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-01-10-8f616a6e-10069-0 |
2a664af587aaeb507f8e606c1b47964dd4d5865b | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2011-01-10-8f616a6e-10069-0 |
2c006814fa46ec6d446a0a33618a6c6e97bf0496 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2011-01-10-8f616a6e-10069-0 |
2df14ff3c864c81d57d87354ef406e6052870fbd | Name of donor: GMB | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-01-10-8f616a6e-10069-0 |
367c9366c2d2ba9e2512576d2f471313df0f79d1 | 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 | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-01-10-8f616a6e-10069-0 |
37ac080faf7eb2f7eb2a5c164bf48c1009317af4 | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-01-10-8f616a6e-10069-0 | |
395edd573cb144af5f530043ca6d521654bc0068 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-01-10-8f616a6e-10069-0 |
3e6b89b86138f0f4208986776d309746c3edfec7 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2011-01-10-8f616a6e-10069-0 |
4d5de8e3d40daa8846215dd671e63a27e2717699 | 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-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2011-01-10-8f616a6e-10069-0 |
5ccdd8902af6a053b21766b6800523d89d882cfe | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-01-10-8f616a6e-10069-0 |
642a10ffbb730f1230c713174fdf8088731e72ad | 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-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-01-10-8f616a6e-10069-0 |
77001bcba6efe61403add8620f08bd07bb85397c | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2011-01-10-8f616a6e-10069-0 |
7c98e2ec5c8fa5d8e56ec808948c95bdc170121a | 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 | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-01-10-8f616a6e-10069-0 |
884c15cdd1ec161d20e770e187ebce4c47ea95f8 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-01-10-8f616a6e-10069-0 |
96ed144f3c9affd534b1e47c2ce5b50692d34f15 | 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-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2011-01-10-8f616a6e-10069-0 |
a671a497352a0a0dc1042fb52f87893c5e460bc5 | Donor status: company | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-01-10-8f616a6e-10069-0 |
c61c8b4c3aaafe8fa85366d530c429151154ae43 | Address of donor: private | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-01-10-8f616a6e-10069-0 |
e028d4bfd90959e069c64442c78de73f012e2f81 | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-01-10-8f616a6e-10069-0 |
e02e6e74f1928e50f7570ec92dcffad26d34b0fe | Donor status: trade union | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2011-01-10-8f616a6e-10069-0 |
e2cd0b4899046d29184b09d6f422f9c3d2736903 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2011-01-10-8f616a6e-10069-0 |
ee1a2e12e7f2a1d358b4716361d5e9db7268df6b | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-01-10-8f616a6e-10069-0 |
fc601f382ca81ee889d7b45d4820c865cd53cc11 | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-01-10-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");