items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-03-14 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 |
---|---|---|---|---|---|---|---|
de95e422f95d857e479a84f6de87ecb39c575def | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-03-14-8f616a6e-10069-0 |
7120179d11dcaf20eb6c2918f0b897639be4af5e | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-03-14-8f616a6e-10069-0 | |
c2b7b4303cb4ba57a954dea26874a53fe3ef53ca | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-03-14-8f616a6e-10069-0 |
136ffffd0c19b630cfa56b1f27c7a31e86bb1b47 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-03-14-8f616a6e-10069-0 |
312db87fb9becd0a5a5be17023f6e269e4277626 | 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-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-03-14-8f616a6e-10069-0 |
819a75e5ef068781ebe97d011699ba12bf5ff922 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-03-14-8f616a6e-10069-0 |
3b7b85f0da1902ab0a3ffdf77b8a34fb1f4a17e4 | Name of donor: GMB | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-03-14-8f616a6e-10069-0 |
504255b2a0f92ee3a5b1c6b2d0f2d60639d5de7b | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-03-14-8f616a6e-10069-0 |
c4420152e8a1ad9e4c0c1f57fef41759914a1c3d | 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-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-03-14-8f616a6e-10069-0 |
696d3dfcce37d5950256afb5e4fd3b921cf829cd | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-03-14-8f616a6e-10069-0 |
919614cd4ac18c64d16d87189646cfc07baaa381 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-03-14-8f616a6e-10069-0 |
c3d353b77a6093d3ec2466d4b791ca7be41b696f | Donor status: company | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-03-14-8f616a6e-10069-0 |
52cd348cf827e43aec80d4591b5c67fa1d30001d | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-03-14-8f616a6e-10069-0 |
b5eea567bc197c8bd02b655a7aa28e74a1a5375c | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-03-14-8f616a6e-10069-0 |
643002c9eea88e4a96a99a37697be25b69206f1d | 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-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-03-14-8f616a6e-10069-0 |
d900813a7c279505e0685db0cc0151e6b85000e6 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-03-14-8f616a6e-10069-0 |
55b74bc57cc05804891523b65b88da97f03f00d1 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-03-14-8f616a6e-10069-0 |
871a2dfcb505aad03c792999d074c89af696c61f | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-03-14-8f616a6e-10069-0 |
f4b032d6a988929a8b2861d5953c6928991e6dea | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-03-14-8f616a6e-10069-0 |
88c6ebfb0418617dc76a1cbea7714ba4e9a48e4f | Donor status: trade union | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-03-14-8f616a6e-10069-0 |
c5e29190bcb2b79047a396650c4bed6cd9a71ba1 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-03-14-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");