items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-02-07 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 |
---|---|---|---|---|---|---|---|
049f5c8b8c9cfead073f14c14a3dd59d6717c0c1 | Donor status: trade union | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-02-07-8f616a6e-10069-0 |
13a3ae02e6b5a40eee4f3a321df36365fc12ac58 | Donor status: individual | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-02-07-8f616a6e-10069-0 |
258ab731bac0bde9aa8ffe774cf8e23a5d653cc2 | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-02-07-8f616a6e-10069-0 |
3e923d0555aa16517f3d9812643eb676c6bc7910 | Address of donor: private | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-02-07-8f616a6e-10069-0 |
48eb1425e3bc52ffeb269bb6a75b59f55cfbc200 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-02-07-8f616a6e-10069-0 |
4974bd501421123f8b02f23b9d71bfc304f43a23 | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-02-07-8f616a6e-10069-0 | |
705225987761541b25b1d69a941f6a4cdf3d1942 | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-02-07-8f616a6e-10069-0 |
78af941f6351d3f75e26f936d4860af0d11b6077 | 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-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-02-07-8f616a6e-10069-0 |
7f916b6dde9e72bcf04f837e24b29c1932097179 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-02-07-8f616a6e-10069-0 |
8046104468f5816dc0a0bba988cc6b9cf5d69652 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-02-07-8f616a6e-10069-0 |
81c65403c0793e48d974df3dd1e4881f6501e674 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-02-07-8f616a6e-10069-0 |
97d967bd8a3d885965af6f44ca5e969de29d56f2 | 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-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-02-07-8f616a6e-10069-0 |
9823870aaa8a9e7e4699f420e4c7c8addaa6eea3 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-02-07-8f616a6e-10069-0 |
ab4d967325eacfe7662fc7d59c12e6cbde27d672 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-02-07-8f616a6e-10069-0 |
c0b688eb9ac20d35a6bd879012e00673ae5778ff | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-02-07-8f616a6e-10069-0 |
c861c3a12346f043a53e5af6559e4350907925fd | 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-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-02-07-8f616a6e-10069-0 |
cd919ccfe0822abe71e61e981857fe86c59e179e | Name of donor: GMB | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-02-07-8f616a6e-10069-0 |
d06ebf734391586ed7b219628618d6924ddf566c | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-02-07-8f616a6e-10069-0 |
e141716b82a98a11b4f5645e3d332b63885ef3ac | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-02-07-8f616a6e-10069-0 |
ebac3d52d727f4dade342ec22f4963913c898e97 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-02-07-8f616a6e-10069-0 |
f11b3919a012a0b82e61b5f910466d77d8f57a89 | Donor status: company | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-02-07-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");