items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2008-02-26-9e46def6-10251-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
004f6eee2625425d27d1bd3b3a39bb548550e8ff | The cost of a reception for Ambassadors which I hosted on 23 May 2007 at the Mandarin Oriental Hotel Hyde Park was met by CQS. (Registered 19 June 2007) | Sponsorship or financial or material support 9e46def6 | 2008-02-26 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 0 | 2008-02-26-9e46def6-10251-0 |
b32641764560cf3460720236cc845a8a23066926 | A donation made to Conservative Central Office by Mr Alan Morgan of London has helped to provide one member of staff in my office who supports me in my capacity as Shadow Foreign Secretary. (Registered 14 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-02-26 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 1 | 2008-02-26-9e46def6-10251-0 |
ff976a57b1bb8069964f57f1f8c784fc919f60ca | Funds have been provided by Merebis Capital Management LLP to cover the cost of research in my role as Shadow Foreign Secretary. (Registered 21 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-02-26 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 2 | 2008-02-26-9e46def6-10251-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");