items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where "date" is on date 2010-03-24 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 |
---|---|---|---|---|---|---|---|
9c4a746eb95fb75a0ac42dd3fe4dee4737c8bfc5 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-03-24-8f616a6e-10069-0 |
8e5f773d4b7427f57bdaf267651370fc4cf7b030 | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-03-24-8f616a6e-10069-0 |
a5e1009639d5589f5fbc233e37ecd74441d7509b | 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-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-03-24-8f616a6e-10069-0 |
16da8f2909637834354630811356a3a4c7a156f5 | Donor status: Company | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-03-24-8f616a6e-10069-0 |
c687cef24d570d13983b5759b798409d61e76076 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-03-24-8f616a6e-10069-0 |
64cea4cac965b9c8394b1a5237917d65d5882d0d | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 6 | 2010-03-24-8f616a6e-10069-0 |
e47cc0c300e50d3e6c3e8d018d75155fa4f9e369 | 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-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-03-24-8f616a6e-10069-0 |
4922a939e3ed3bb8c7894f5e202a9feb9524637d | Donor status: Trade union | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-03-24-8f616a6e-10069-0 |
b0deabd9e1d42e2f7321f9c2166c57a84ebdedc7 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-03-24-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");