items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2010-12-20 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 |
---|---|---|---|---|---|---|---|
f9513ab8c0c814d512c44ff347a225430a1acec2 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-12-20-8f616a6e-10069-0 |
73e6ff85a23371c052542978869eb000be1b6030 | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-12-20-8f616a6e-10069-0 | |
9e5e34ba4076fe5d24c2baad681bf6836a1422cb | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-12-20-8f616a6e-10069-0 |
ea914925110e850606c48827e7bb235964bd4e2f | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-12-20-8f616a6e-10069-0 |
162e1ccbcc2b83becc09f1a130d866cc725b4317 | 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-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2010-12-20-8f616a6e-10069-0 |
90137cf83e512e14266af5901515d89aa3413322 | Donor status: Company | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-12-20-8f616a6e-10069-0 |
567d29a9263869193874b2b50b59e4d8ef3f8775 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-12-20-8f616a6e-10069-0 |
af71d2e751aef67384d0188784e5518d7da0a253 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-12-20-8f616a6e-10069-0 |
d8e310b8431e8eb91e4e16c014f445cd159f996b | 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-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-12-20-8f616a6e-10069-0 |
e62d105b4039865c4459d57cd7c2ae73c8b73592 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2010-12-20-8f616a6e-10069-0 |
71496c03ccd6a883db35eb76eb31e12027330cda | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2010-12-20-8f616a6e-10069-0 |
93e9ff580562631e4d1c3b2b437f6ff3dca682d1 | Address of donor: private | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2010-12-20-8f616a6e-10069-0 |
db6c95c64687e6cc23099d26f83cd5b89fa776e1 | 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-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2010-12-20-8f616a6e-10069-0 |
465a00a8ce30cedd390f16f288c5d0d5493c36d3 | Donor status: individual | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2010-12-20-8f616a6e-10069-0 |
147e434a08a79bb02b66db91262f68855f392beb | Name of donor: GMB | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2010-12-20-8f616a6e-10069-0 |
4898ddb8b1487436da082e5a6c376b66f24dfc27 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2010-12-20-8f616a6e-10069-0 |
199388e7d75c8e498406e2d019b9835c18f75f0e | 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-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2010-12-20-8f616a6e-10069-0 |
788743a4915fc9b687d8a2a683915948fe32be1f | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2010-12-20-8f616a6e-10069-0 |
19d84fab074f3d42a7b3271fe55809fcdf6024fc | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2010-12-20-8f616a6e-10069-0 |
227bd82e71e65aea7dfa466594340cb782c89fe0 | Donor status: company | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2010-12-20-8f616a6e-10069-0 |
3ab18b53abd6ad0cff979c800ed0f0958d2a99bc | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2010-12-20-8f616a6e-10069-0 |
c004e0aadb23a5ac703673f2f0a276ecea228fd8 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2010-12-20-8f616a6e-10069-0 |
491e26d23c4036407e2fb0fa3598bfb0790df2d9 | 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-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2010-12-20-8f616a6e-10069-0 |
dbb02579fb70ef756a699f3b18b7f6d0c7565acc | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2010-12-20-8f616a6e-10069-0 |
e9e9805030b42ad8081c23e33e0daa32e67730aa | Name of donor: CWU | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2010-12-20-8f616a6e-10069-0 |
a8e6116ccefe990dcd9c1682bdd52f6c70ecf1cb | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2010-12-20-8f616a6e-10069-0 |
f3424f06fb3299e6d9ecb9c7e792aa3cf3e02487 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2010-12-20-8f616a6e-10069-0 |
757459684be044aed614219e0bb54d6cc0cf6cd2 | Donor status: trade union | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2010-12-20-8f616a6e-10069-0 |
5deac4b4dae628b1d052c2cf31d99b5beee8ad17 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2010-12-20-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");