items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2010-11-08 and person_id = "uk.org.publicwhip/person/10069" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
f33ab14ae45d9a3beac516ae9a894d988eac511e | 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-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-11-08-8f616a6e-10069-0 |
98913d8afea176bde2a19eb60802b061c2b713ce | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-11-08-8f616a6e-10069-0 | |
ae36bf6a0cc669a87f5cdbc3e9e1bb14d3848046 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-11-08-8f616a6e-10069-0 |
25e0a599d0a73fcd24f42f6116f0fae19ebe9e4c | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-11-08-8f616a6e-10069-0 |
4d120cdc4650046b11d186accd15978875c99b79 | 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-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2010-11-08-8f616a6e-10069-0 |
2836cc1e1cfdc12911b6aa0c64de31d7cb22be6d | Donor status: Company | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-11-08-8f616a6e-10069-0 |
ba3da191c7def4b40cf91075ebf6347e06b37822 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-11-08-8f616a6e-10069-0 |
a587a0b543d0221972c3bc2122c938ee98c4f5dd | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-11-08-8f616a6e-10069-0 |
b478224e326399d017d862fb48023885dcca6db3 | 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-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-11-08-8f616a6e-10069-0 |
c781deb45804589a99ae6c04608b6cc03b1d19b4 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2010-11-08-8f616a6e-10069-0 |
a1416ad1bbc22829b4cf36592360a94bf3ae7f32 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2010-11-08-8f616a6e-10069-0 |
e636c3bb1e0645b2a1d419b9a726df9802152bd8 | Address of donor: private | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2010-11-08-8f616a6e-10069-0 |
3e3d75282e951cbe69869bbf189c06db4f670d86 | 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-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2010-11-08-8f616a6e-10069-0 |
0e1d6fe9ec18a131c5839a26d4a033575d4a8528 | Donor status: individual | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2010-11-08-8f616a6e-10069-0 |
10ee9369c905925fd89a9881205e53859a557a59 | Name of donor: GMB | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2010-11-08-8f616a6e-10069-0 |
f66646cc6b384de39708522542adc1b9b4e06780 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2010-11-08-8f616a6e-10069-0 |
70bbc2b455de6555dcb30e9e8615ce6ac90f9619 | 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-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2010-11-08-8f616a6e-10069-0 |
b6256f0886e37d134c4a2e0a25bf60c4f317d81a | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2010-11-08-8f616a6e-10069-0 |
17915c0aa19574cf4775f88c15f43e5f3fb74dc4 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2010-11-08-8f616a6e-10069-0 |
112d01300a2678bd4ca8bd1b3a067fb7f20a0cdc | Donor status: company | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2010-11-08-8f616a6e-10069-0 |
47734d769f3c421bdc35d7de455baf1adb674628 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2010-11-08-8f616a6e-10069-0 |
4da94b024dd24c6030daa2c348b984d4500c014c | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2010-11-08-8f616a6e-10069-0 |
7dd5fac1cd4b4ad82d75ac0bca09f2096027df0a | 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-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2010-11-08-8f616a6e-10069-0 |
b88ca7d42f1ff502f7c3d5cd2d72397ab5009dfb | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2010-11-08-8f616a6e-10069-0 |
b3660431aedf393c4b79f2f1fddc63c75d885bce | Name of donor: CWU | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2010-11-08-8f616a6e-10069-0 |
fb16b52aa1eb2c1dceaaeb7c3308cf5a94dff04b | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2010-11-08-8f616a6e-10069-0 |
391c23dbad2d187d8b184d77beebf6c4bc38f70f | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2010-11-08-8f616a6e-10069-0 |
027d85db424a737c7b734019049c1290b2ec149b | Donor status: trade union | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2010-11-08-8f616a6e-10069-0 |
e0ec85bf8b52cfd7d7af7c31f0c2adc0e463a338 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2010-11-08-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");