items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2010-10-25 and record_id = "2010-10-25-8f616a6e-10069-0" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
79434093c196909133fc6958b3f3ec739ba1c5ac | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-10-25-8f616a6e-10069-0 |
796276cf0551b5efec8f2a68eb8ff12f8230ffc4 | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-10-25-8f616a6e-10069-0 | |
c5423f7fc01242151b559e603fee1618204b0fa8 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-10-25-8f616a6e-10069-0 |
3fa7047221f64d67570d128b4a71e5fc9dfff58c | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-10-25-8f616a6e-10069-0 |
d6576bba20c947496e23aa9e52cd27638028e3b8 | 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-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2010-10-25-8f616a6e-10069-0 |
e67faaf2c4ab13de9f4fbea3ef3a595e52918068 | Donor status: Company | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-10-25-8f616a6e-10069-0 |
6dd7e1f1bb6aa158317c87a7538b4a25308bfbe4 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-10-25-8f616a6e-10069-0 |
24291fbe0167e5132d4abdbcf6465d2e99efaf47 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-10-25-8f616a6e-10069-0 |
30e452d791c82b35c5dd0bf7e062409344f24fb6 | 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-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-10-25-8f616a6e-10069-0 |
1439deea7461aab207aa98f81b960a5cb290dad8 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 11 | 2010-10-25-8f616a6e-10069-0 |
6c0195d0e1b7801915ae98e81516594f743f6e65 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2010-10-25-8f616a6e-10069-0 |
769cfc138a57df5ef4c1a0a59f4edf4a1dcc14a0 | Address of donor: private | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2010-10-25-8f616a6e-10069-0 |
007c39f91deb4752018ab7c8132008e83571a070 | 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-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 14 | 2010-10-25-8f616a6e-10069-0 |
81b93c31a7e25fd6e9134cd71ae44cfe7610fd34 | Donor status: individual | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2010-10-25-8f616a6e-10069-0 |
c204c5243105973c7e908af504a50452a93b1207 | Name of donor: GMB | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2010-10-25-8f616a6e-10069-0 |
2e06db1fc23ebbf5e2b5cd7fb50b3146a80ff247 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2010-10-25-8f616a6e-10069-0 |
f891a9b588d3f1d2fe3cd4554afa12ee0381aa1b | 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-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2010-10-25-8f616a6e-10069-0 |
1d6d30229da1df6b90bb519f30af0aeb7f731b60 | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2010-10-25-8f616a6e-10069-0 |
749a85e11a44d754516ef5eee7159847a347b869 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2010-10-25-8f616a6e-10069-0 |
cdac5bcebf824c70df9b349dba9f1586a85211c9 | Donor status: company | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2010-10-25-8f616a6e-10069-0 |
7810683f2af682a7368709e19878819ed9cea713 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 27 | 2010-10-25-8f616a6e-10069-0 |
c30ae38602ed123412f89a676a6cba815f4329aa | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 28 | 2010-10-25-8f616a6e-10069-0 |
b666df8939af740657ca4081af6132dec31d198d | 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-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 29 | 2010-10-25-8f616a6e-10069-0 |
cd91542d37b95d1895b5720063aef1513bc37fba | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 31 | 2010-10-25-8f616a6e-10069-0 |
c3eb3e08d36095efbae2109b4e80ce5acdd89fab | Name of donor: CWU | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 32 | 2010-10-25-8f616a6e-10069-0 |
7a051dfa7577e57747bd8b4fe92fcba34f17f4bf | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 33 | 2010-10-25-8f616a6e-10069-0 |
e74d895680b34974b429096caa6a8838d9222610 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 34 | 2010-10-25-8f616a6e-10069-0 |
bcd01cd792d2164904472f0db7025d687c2e4f98 | Donor status: trade union | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 35 | 2010-10-25-8f616a6e-10069-0 |
5813664ae7b44359f3899f067de1b527c0f8291f | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 36 | 2010-10-25-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");