items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2009-03-11-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 |
---|---|---|---|---|---|---|---|
76ae909c55e11b1dc725237af40a99b75f5582f5 | Funds have been provided by the following to cover the cost of research in my role as Shadow Foreign Secretary: | Sponsorship or financial or material support 9e46def6 | 2009-03-11 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 0 | 2009-03-11-9e46def6-10251-0 |
85cbc951f602c5b40b4c40eb0095415196db3b17 | Merebis Capital Management LLP | Sponsorship or financial or material support 9e46def6 | 2009-03-11 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 1 | 2009-03-11-9e46def6-10251-0 |
001b729a17e684440e3cb8f66d54cb50253ef618 | Bruce Macfarlane, London (personal donation) (Registered 9 July 2008) | Sponsorship or financial or material support 9e46def6 | 2009-03-11 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 2 | 2009-03-11-9e46def6-10251-0 |
448cfd5303ad8afcf00f74190a45f2bf70bc7c42 | Alan Morgan , London (personal donation) (Registered 9 July 2008) | Sponsorship or financial or material support 9e46def6 | 2009-03-11 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 3 | 2009-03-11-9e46def6-10251-0 |
ca26cf5425d9f0a14e24289aaa769d4a6e5485a5 | The cost of a reception for Ambassadors which I hosted on 4 June 2008 at the Mandarin Oriental Hotel Hyde Park was met by CQS. (Registered 9 July 2008) | Sponsorship or financial or material support 9e46def6 | 2009-03-11 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 4 | 2009-03-11-9e46def6-10251-0 |
e42ecae966922afa71cd0d0a90e1349f27c40edb | The cost of a reception for Ambassadors which I hosted on 30 September 2008 at the International Conference Centre in Birmingham during the Conservative Party Conference was met by CQS. (Registered 24 October 2008) | Sponsorship or financial or material support 9e46def6 | 2009-03-11 | William Hague uk.org.publicwhip/member/1782 | William Hague uk.org.publicwhip/person/10251 | 5 | 2009-03-11-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");