items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2010-04-12-8f616a6e-10069-0" sorted by record_id descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▲ |
---|---|---|---|---|---|---|---|
ba5a33845563d8b74563b62cdc736948895c3c0c | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-04-12-8f616a6e-10069-0 |
71e3dbe68bf607a403a07b193fc3105404851021 | Address of donor: Wellstream House, Wincomblee Road, Walker Riverside, Newcastle upon Tyne NE6 3PF | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2010-04-12-8f616a6e-10069-0 |
5807b97a1236e1b996b801286fdbf8db6c7c4c3f | 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-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2010-04-12-8f616a6e-10069-0 |
987ef1d8a278f61413c1b090c8806017076ce2f9 | Donor status: Company | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2010-04-12-8f616a6e-10069-0 |
9d13b9b4b05b895732c446d5884106dd62811544 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2010-04-12-8f616a6e-10069-0 |
df19c9a4e7c7d54c0c8039d9f2eda1a3a07c1177 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 6 | 2010-04-12-8f616a6e-10069-0 |
e4d3564a00936a69b15d2bd01deda32b09b32b4c | 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-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2010-04-12-8f616a6e-10069-0 |
600aea9ac588b4bf045fe589b8767c6aa53b891d | Donor status: Trade union | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2010-04-12-8f616a6e-10069-0 |
0e9b09aaf87c96aa10cadb873f0f0e9626b10e56 | (Registered 21 December 2009) | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2010-04-12-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");