items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2007-11-06-9e46def6-10213-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 |
---|---|---|---|---|---|---|---|
f097a4c7a7d411fc90a00ba7e67bd9d147eab41f | Contributions to staffing and running of private office from: | Sponsorship or financial or material support 9e46def6 | 2007-11-06 | Liam Fox uk.org.publicwhip/member/1938 | Liam Fox uk.org.publicwhip/person/10213 | 0 | 2007-11-06-9e46def6-10213-0 |
94aaf56dc481e85c463c0ffb8870aec4fab22dae | Cllr Michael Batt of Amersham, who is also Principal of SMAE Institute, Maidenhead. | Sponsorship or financial or material support 9e46def6 | 2007-11-06 | Liam Fox uk.org.publicwhip/member/1938 | Liam Fox uk.org.publicwhip/person/10213 | 1 | 2007-11-06-9e46def6-10213-0 |
0047f195e7607d577105105322ccc3961165360b | Mr Stanley Fink, Chief Executive Office of ManGroup Plc, London. | Sponsorship or financial or material support 9e46def6 | 2007-11-06 | Liam Fox uk.org.publicwhip/member/1938 | Liam Fox uk.org.publicwhip/person/10213 | 2 | 2007-11-06-9e46def6-10213-0 |
aefab05383cf08bbf69d4ba97bf6dfd7ac6a9b56 | Mr Michael Hintze, Chief Executive of CQS Limited, London. | Sponsorship or financial or material support 9e46def6 | 2007-11-06 | Liam Fox uk.org.publicwhip/member/1938 | Liam Fox uk.org.publicwhip/person/10213 | 3 | 2007-11-06-9e46def6-10213-0 |
db3a76d191dea5bcef8772f5430030938477fb46 | Mr Alan Howard, Chief Executive Officer of Brevan Howard Asset Management LLP. | Sponsorship or financial or material support 9e46def6 | 2007-11-06 | Liam Fox uk.org.publicwhip/member/1938 | Liam Fox uk.org.publicwhip/person/10213 | 4 | 2007-11-06-9e46def6-10213-0 |
db21ef47f8b7d6d957008a1ff4b2f7e3cf492a09 | Mr Jon Moulton, Managing Partner of Alchemy Partners LLP. | Sponsorship or financial or material support 9e46def6 | 2007-11-06 | Liam Fox uk.org.publicwhip/member/1938 | Liam Fox uk.org.publicwhip/person/10213 | 5 | 2007-11-06-9e46def6-10213-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");