items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2010-12-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 |
---|---|---|---|---|---|---|---|
7bdfda857a842a56a7ae2ff01bb6305c2db8a268 | 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-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-12-06-8f616a6e-10069-0 |
50fc6e0be1f12b76ed903657114ce05ea7e04c8a | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-12-06-8f616a6e-10069-0 | |
533885171fde20b329a2afe9c8eb2d3c0abd3486 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-12-06-8f616a6e-10069-0 |
7eee3459663a9e1cd68e29a8d4f8977ac1a6cf5b | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-12-06-8f616a6e-10069-0 |
ba486680c723469a128802b50628a075fc46e082 | 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-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2010-12-06-8f616a6e-10069-0 |
7503f3f51b2117bcf866212449b200fb264b0ea5 | Donor status: Company | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-12-06-8f616a6e-10069-0 |
00a660da7d6bf8165f8be31e23c92d961ebd4e6d | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-12-06-8f616a6e-10069-0 |
c4e69ac4879a52a834221f21944484a6ea76aed9 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-12-06-8f616a6e-10069-0 |
a862eedc2b77dd5a1178e2b8be008ee2e49a424b | 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-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-12-06-8f616a6e-10069-0 |
fdb07ea7821abae19f13dc840727b25534dafec3 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2010-12-06-8f616a6e-10069-0 |
bc43ccd46f9214c82a63591dfcb99de1338bb528 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2010-12-06-8f616a6e-10069-0 |
8c51ee70cc1ba857efddd63f19143178506aa891 | Address of donor: private | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2010-12-06-8f616a6e-10069-0 |
c0d4804faed93a2e73c1be4cbb360cd0a802555f | 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-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2010-12-06-8f616a6e-10069-0 |
301ee9db8ab278b282498dd647d5469feedfe198 | Donor status: individual | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2010-12-06-8f616a6e-10069-0 |
e1a5ef67c382b3a9b77f2ff620213ff5a7f41b05 | Name of donor: GMB | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2010-12-06-8f616a6e-10069-0 |
f171f8f67403b1c81427737143af7216205466a9 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2010-12-06-8f616a6e-10069-0 |
0a0c0998161d0ea5cb6b1107fc1d9f0b9eadae46 | 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-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2010-12-06-8f616a6e-10069-0 |
b54f6adb15a035011c869d1178ddc57bc3c24f1d | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2010-12-06-8f616a6e-10069-0 |
92d4f81ddb949c15e4f6d9245e6765107622779c | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2010-12-06-8f616a6e-10069-0 |
6f0384d6b0432f71dd4ae266a399a82b3dac9fa8 | Donor status: company | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2010-12-06-8f616a6e-10069-0 |
5749d027137eca8b2671d84fa3957840cc6b88a5 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2010-12-06-8f616a6e-10069-0 |
f13fc424fb0dc9d48afb4e5aa5cbba583c51aa7d | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2010-12-06-8f616a6e-10069-0 |
1f52424d3684a1c92f4839d8efce11ecc172300e | 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-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2010-12-06-8f616a6e-10069-0 |
6b6a944f3ef04e86d5a90e46b1806ef144472dde | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2010-12-06-8f616a6e-10069-0 |
6b6f0197f1f6e5d6a3faccca4b84ec206fae1afe | Name of donor: CWU | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2010-12-06-8f616a6e-10069-0 |
f9957dad91c6b96ae6e87c5c8ccf3e1f422876c9 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2010-12-06-8f616a6e-10069-0 |
4b92d9f2fcce966f4e802867ae8029c1ab7476af | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2010-12-06-8f616a6e-10069-0 |
6226777c826eedf3811d366f4c7395f06fd00995 | Donor status: trade union | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2010-12-06-8f616a6e-10069-0 |
73c65b98a1e9e455cb1a3238d0116074996744c5 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2010-12-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");