items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-05-16 and person_id = "uk.org.publicwhip/person/10069" sorted by hash
This data as json, CSV (advanced)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
03c1d9ef4f55851847e8b717b1168560ebeedc0b | Donor status: trade union | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-05-16-8f616a6e-10069-0 |
11bf0d1f1eccd01f858ab86453b8142bba17c495 | 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-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-05-16-8f616a6e-10069-0 |
3bab43d18df4fdaec2ed6eb3eb25448fa90a9231 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-05-16-8f616a6e-10069-0 |
41223af23b31e8939a9fa78232f544c1880f8805 | Address of donor: private | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-05-16-8f616a6e-10069-0 |
4a855c0ed5e1c2668afd094737d57f489e63730c | 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-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-05-16-8f616a6e-10069-0 |
4ccc0a331aaa004aaf9137548869d49ea2d3f892 | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-05-16-8f616a6e-10069-0 |
4cfb7f19368dba8474724c9494a8904bf0d1bc1b | Donor status: individual | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-05-16-8f616a6e-10069-0 |
6681ba7753c2a7a06ee6b079f00d91008639b07e | 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-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-05-16-8f616a6e-10069-0 |
701b8fc01b9b964cc1ea5782817b356d266a86fc | Name of donor: GMB | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-05-16-8f616a6e-10069-0 |
75d5ecafac8c810548eecf45d7b601e985a88be6 | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-05-16-8f616a6e-10069-0 |
87d47e7e39333e380b82947d168ce14e473f4dad | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-05-16-8f616a6e-10069-0 |
9ba5008a6739039c03ccf6d05b639d913e6d5ac1 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-05-16-8f616a6e-10069-0 |
a965a2cfebec12e936972b04df0441af8fb4a96a | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-05-16-8f616a6e-10069-0 |
b9eb13ab2f08f1b28a7339cb7d8a0018f6e62881 | 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-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-05-16-8f616a6e-10069-0 |
c0d9a28648bd44cd42998afab0225ac163a16f10 | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-05-16-8f616a6e-10069-0 | |
d19643e5370b1aded9b9d701539ea3bbf2f83aae | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-05-16-8f616a6e-10069-0 |
d593cd13519d83ec8e7c69dc7d276cf116fd5bdb | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-05-16-8f616a6e-10069-0 |
e2047af14850c043ffa050ece6b22ffa4b3cb7c6 | Donor status: company | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-05-16-8f616a6e-10069-0 |
f18536ad85169127ec85b2e8c4a67af65c8ea427 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-05-16-8f616a6e-10069-0 |
f587c3660cac3d3beb68b926bcec33cb03100f57 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-05-16-8f616a6e-10069-0 |
fd238aa17af8fb76a817ea4b2fb78241d8105904 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-05-16-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");