items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-01-24 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 |
---|---|---|---|---|---|---|---|
ef9b88a2920935ff6a253be29342b5e040141db6 | 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-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-01-24-8f616a6e-10069-0 |
75a3772a6a5cc6fb3679c2cc67b731867c642ce5 | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-01-24-8f616a6e-10069-0 | |
f580e7b3c781323212cced5d4193eafac306a917 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-01-24-8f616a6e-10069-0 |
27a8cebac19e9db77e85c4ce6128d47de8c511ee | Address of donor: private | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-01-24-8f616a6e-10069-0 |
9c0d0a1c5483295055eb7144c05bd37fc7d8a0e5 | 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-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-01-24-8f616a6e-10069-0 |
68b4bf2d8d9e70acaac14a9af59c90019f129706 | Donor status: individual | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-01-24-8f616a6e-10069-0 |
8cec5349c51b884e2ea168c55f9162d1086202aa | Name of donor: GMB | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-01-24-8f616a6e-10069-0 |
c9a63db029a7426866ec5bfe26b947aa82b2650c | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-01-24-8f616a6e-10069-0 |
62d77e343d5d11d77fddadd4a5d293850afb3ff0 | 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-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-01-24-8f616a6e-10069-0 |
4188dea749f426d428db1c3b125a0298ff3308e1 | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-01-24-8f616a6e-10069-0 |
25865f20a65234df5ef3250c379d1f4294122887 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-01-24-8f616a6e-10069-0 |
40b563896223db3e13a941839844b02af04e2cfc | Donor status: company | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-01-24-8f616a6e-10069-0 |
49912a9964341858bd6b6fccb554c009f74043a5 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-01-24-8f616a6e-10069-0 |
e666003e3c82b66c9679e0e1494848d4ddd2feab | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-01-24-8f616a6e-10069-0 |
881606a815ac75a98acbf9d6caab23828a65a882 | 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-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-01-24-8f616a6e-10069-0 |
c747f599f47339cd7df691fe066d129764800d31 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-01-24-8f616a6e-10069-0 |
5bc0dc3062a5c91e7546510cd005befa6f55401f | Name of donor: CWU | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-01-24-8f616a6e-10069-0 |
eb288086b762d63085d02a58e32543c6b553480e | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-01-24-8f616a6e-10069-0 |
957a998f698bbd0fcc0f7cd035f1f9af9b27b45b | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-01-24-8f616a6e-10069-0 |
f6c36912651b01dc04199d637d55acc3a4cf27e3 | Donor status: trade union | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-01-24-8f616a6e-10069-0 |
c3720ea9535d7b55b3e7d8af52e31c0d413773ef | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-01-24-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");