items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-06-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 |
---|---|---|---|---|---|---|---|
2607acebc9043be359c392bc829591eeb22eeb99 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-06-06-8f616a6e-10069-0 |
2f7754ae04627e5bd53c374d49805233dfa934d6 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-06-06-8f616a6e-10069-0 |
3ffe5e965c6a159fe0a691584f598ef8b1dc5baa | 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-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-06-06-8f616a6e-10069-0 |
46032f6f72f224c6f5bf709f739e5d5fa0fbc825 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-06-06-8f616a6e-10069-0 |
4ecd22a5c60b73ec7796064d8b1c5f02387c03ac | Address of donor: private | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-06-06-8f616a6e-10069-0 |
51f1642e677440f4462c4619942a2c0bb5881ded | Name of donor: GMB | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-06-06-8f616a6e-10069-0 |
5b3095da53e9770853681040de58d004ad08b5a4 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-06-06-8f616a6e-10069-0 |
692022a831c451662c86ab8b72fe798e835124d4 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-06-06-8f616a6e-10069-0 |
69f7f68d7c9c62bc9a089a22079c4330b1ceac84 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-06-06-8f616a6e-10069-0 |
6c06ef5d5960f3b3fbfc88d94ebd93f75cf7b3e8 | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-06-06-8f616a6e-10069-0 | |
83018ea3499c911042480087b39e438915517b23 | Donor status: individual | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-06-06-8f616a6e-10069-0 |
8b75a64af2573992b771bb2c0608b5b524d934bb | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-06-06-8f616a6e-10069-0 |
8eeb4c25f5b912a493beca2a0ce10e0417c545e3 | Donor status: trade union | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-06-06-8f616a6e-10069-0 |
942d11bfe8adbd764a7ef96afa797eccbbbb8000 | 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-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-06-06-8f616a6e-10069-0 |
a2091a0326ee0d234975420b2ed6747caf45913b | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-06-06-8f616a6e-10069-0 |
a2c20a3d7411f6121a2107b1613cf78622314979 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-06-06-8f616a6e-10069-0 |
a490c1e2be159660dbbfa957aefb079490e3e050 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-06-06-8f616a6e-10069-0 |
a91a1bb3d777ca2a99fec246b84e866c52073f74 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-06-06-8f616a6e-10069-0 |
c10ab644887f7a4b90df72c27335ef34af68756e | Donor status: company | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-06-06-8f616a6e-10069-0 |
c9671930771eeb3898fac98b0a2036c1f26dfb49 | 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-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-06-06-8f616a6e-10069-0 |
ed3eea8d826daaf8fbdade2a448ae19e07c69e48 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-06-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");