items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2010-09-06 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 |
---|---|---|---|---|---|---|---|
3f795d6327bdd51cec677f2e812d3a53442bda51 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-09-06-8f616a6e-10069-0 |
5ee92da766c96769d92472bf7e0d4c1e01b65e16 | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-09-06-8f616a6e-10069-0 | |
2ec034a0634ed9c8ad1a74ccbf335c88c5280e07 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-09-06-8f616a6e-10069-0 |
474ce9f3b33835e7ee6f9e0ee52f59f83f8009a4 | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-09-06-8f616a6e-10069-0 |
cdc4560dc6c673f677ba3ca7df103fe05280e1fd | 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-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2010-09-06-8f616a6e-10069-0 |
7c11dd4ec67041385fb67ecd9885dd9d07126309 | Donor status: Company | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-09-06-8f616a6e-10069-0 |
c24c1c4e4384f8c54f0c1ad0f3dc39b396073f12 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-09-06-8f616a6e-10069-0 |
231c6b9385712e1315bdc0e84ab5e6756f9f80e3 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-09-06-8f616a6e-10069-0 |
98ca8542b5f42aafd839fac9dce3763c370188d2 | 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-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-09-06-8f616a6e-10069-0 |
328cef8660fcd820f2d057095140a4b7b51ec19e | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2010-09-06-8f616a6e-10069-0 |
4c866e8b79f9e923247a7b57e361afa5a72f03be | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2010-09-06-8f616a6e-10069-0 |
1a14d61573e5ac61c44469524c82df11f346ca98 | Address of donor: private | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2010-09-06-8f616a6e-10069-0 |
1b195a760b6c778c83ad2edc78cdd595f2cbcefe | 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-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2010-09-06-8f616a6e-10069-0 |
9dece8e4bfacee26e69354011c7ffdb238612c0f | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2010-09-06-8f616a6e-10069-0 |
204a98fd537d260c8a81edf16dddeaa49863e847 | Name of donor: GMB | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2010-09-06-8f616a6e-10069-0 |
b2e8c7b7df8ca3d0ed412fe666637d0842ab69fd | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2010-09-06-8f616a6e-10069-0 |
f1346dfd279437f86998f818b50d11c0f5367fe2 | 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-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2010-09-06-8f616a6e-10069-0 |
e49f9a122568fc72e2cbf8dc1245db307565a45d | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2010-09-06-8f616a6e-10069-0 |
2163ff0d22a1350d383446446ce0b1dc09723e8d | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2010-09-06-8f616a6e-10069-0 |
17b5c289f78ac2da5db89d22e55e21bd2aa4057f | Donor status: company | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2010-09-06-8f616a6e-10069-0 |
8c2e3ee3bac199b81d242fc32b09df5a7c79ca68 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2010-09-06-8f616a6e-10069-0 |
7b3f0144f5127f8f1045a211b36d56f2ba841ce5 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2010-09-06-8f616a6e-10069-0 |
114f17645fe06da07f66f83388b21afaaf8f7c31 | 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-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2010-09-06-8f616a6e-10069-0 |
bfa5163e614808cf58a568448d221e7b50dbf4b9 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2010-09-06-8f616a6e-10069-0 |
368a4f15ca24ba226790a8d43f7ee92fb5c68c98 | Name of donor: CWU | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2010-09-06-8f616a6e-10069-0 |
3f2602a65d6f9823a1e4dba2686f59747fec4a5d | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2010-09-06-8f616a6e-10069-0 |
ff97f476d956a49fa2735a04d3e2765b5f1263ab | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2010-09-06-8f616a6e-10069-0 |
7086f276e9840586706dac577a7c601be478d549 | Donor status: trade union | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2010-09-06-8f616a6e-10069-0 |
8a4866eb1971f62dd5f0acf7f63263008df0f1e8 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2010-09-06-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");