items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where "date" is on date 2010-01-06 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 |
---|---|---|---|---|---|---|---|
1db9a26af80d0cc036000cbbdd6e4ea2cd9658f5 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-01-06-8f616a6e-10069-0 |
1e86554c3bd05df1472500abfccb89c90c9427b0 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 6 | 2010-01-06-8f616a6e-10069-0 |
5d5ef9fd53654c37d0523a9c3a51141abf754fd2 | Donor status: Trade union | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-01-06-8f616a6e-10069-0 |
6a3e754599c44486a9d9a446c3ee6402992fa0f9 | 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-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-01-06-8f616a6e-10069-0 |
b71e5f961242197b77aaf53a00d80f9b530e735c | Donor status: Company | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-01-06-8f616a6e-10069-0 |
e731de0df5f3e028bd09c8f5a4905936ef9c4dc0 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-01-06-8f616a6e-10069-0 |
ea8872a242d28dcf95e1fa2d576b0949a3ace41e | 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-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-01-06-8f616a6e-10069-0 |
f9413b880450816179010a4eefac8cd41f27d6b6 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-01-06-8f616a6e-10069-0 |
fe8e05223cd611a5a0acc4d22466c38026db8497 | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-01-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");