items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2004-12-03-265f2269-10506-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 |
---|---|---|---|---|---|---|---|
5446a49f06f9612290c6c4fae24d541a627c13df | Close members of my family (all over 18 years old) have an interest in the Robinson Family No. 2 Trust (administered in Guernsey). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 0 | 2004-12-03-265f2269-10506-0 |
9693b858960f325293c79e6283ae71c02d1bb206 | Unremunerated consultant to Marketing Artistic Management, based in Madrid and engaged in musical promotions, to which I have made a modest loan. | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 1 | 2004-12-03-265f2269-10506-0 |
d4e672bc9ee353ac31420823ff14a54f4b62ce91 | Smart Technology Group Limited (non-executive); company specialising in high technologies involving materials and control processes and in traditional machine tool activities. | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 2 | 2004-12-03-265f2269-10506-0 |
d850856d8948320288fae99e288a1537d909e96f | Coventry City Football Club (Holdings) Ltd. (non-executive). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 3 | 2004-12-03-265f2269-10506-0 |
0c5f470812851c1e54004ed89346b026173296cc | Football Investors Ltd (a wholly owned subsidiary of Coventry Football Club Holdings Ltd (resigned 19 December 2003). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 4 | 2004-12-03-265f2269-10506-0 |
fe39fe5fb133a640e02cf3ed548eee9eed562778 | Coventry City Football Club Ltd. (non-executive). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 5 | 2004-12-03-265f2269-10506-0 |
b06260e548c0d66171f6391729ce402836ebed8b | Arena 2001 Ltd. (non-executive); 100% owned subsidiary of Coventry City Football Club (Holdings) Ltd., set up to establish a stadium and arena in conjunction with Coventry City Council as part of the regeneration of the North East of Coventry (resigned 30 December 2003). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Geoffrey Robinson uk.org.publicwhip/member/1193 | Geoffrey Robinson uk.org.publicwhip/person/10506 | 6 | 2004-12-03-265f2269-10506-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");