items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-05-03 and person_id = "uk.org.publicwhip/person/10069" sorted by category_id
This data as json, CSV (advanced)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
01eecb4a739bd0211bfaea427251221af276f987 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-05-03-8f616a6e-10069-0 |
49a9e173ff4951773768957623c7e1e6012be52b | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-05-03-8f616a6e-10069-0 | |
a1a33023f83a99bc89551f818855f8f191208698 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-05-03-8f616a6e-10069-0 |
5510236dde3c69c9f116dcc0ef0ddb9726aa9fef | Address of donor: private | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-05-03-8f616a6e-10069-0 |
f67a94263d6a9779fb63ef17341625779a278c6c | 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-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-05-03-8f616a6e-10069-0 |
6096dc12cfd18b53587a1bf5fd5641bb3163b9a6 | Donor status: individual | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-05-03-8f616a6e-10069-0 |
d51822b4666f3f28b538381fb8350127268b11c2 | Name of donor: GMB | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-05-03-8f616a6e-10069-0 |
9c33697ac7e0bb6c887cd0d28ce5f94c75c19a63 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-05-03-8f616a6e-10069-0 |
b091d59d96ff3d3add0fc9dddf0b74885011713b | 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-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-05-03-8f616a6e-10069-0 |
b96be5762fa9adae49f04bd1b323e42d32b233ed | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-05-03-8f616a6e-10069-0 |
6e83727387bb1a07c1634716388707ce28640603 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-05-03-8f616a6e-10069-0 |
de97dd1f68fa1d61467e835d2b7c1dcf46e966fb | Donor status: company | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-05-03-8f616a6e-10069-0 |
10a6fd533f758842ae321fd64e0f10e4b0b9d04c | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-05-03-8f616a6e-10069-0 |
873355f96431cf78e3be6d056a1c833576c544af | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-05-03-8f616a6e-10069-0 |
7cd0eae7aad2cf92a9564f56220cd827deb69b94 | 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-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-05-03-8f616a6e-10069-0 |
331f4689305f6716440e89850f6c435e3d783caf | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-05-03-8f616a6e-10069-0 |
1257c70a79efa7484e129d7bf80a184e46ea7df5 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-05-03-8f616a6e-10069-0 |
23608d3502db623e5047b93121a6bd3b97b1e9f1 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-05-03-8f616a6e-10069-0 |
bd36e892ce05c3a76ac5dc62556279041d9294af | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-05-03-8f616a6e-10069-0 |
9c7d52c2be5a41e17e450a378a15787dc7e2c865 | Donor status: trade union | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-05-03-8f616a6e-10069-0 |
3556ac507c9600ddb7496eaeba60598b79a95b23 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-05-03-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");