items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2009-10-28-265f2269-10312-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 |
---|---|---|---|---|---|---|---|
5070a0a08f7783fca10d5138eb4f4a47b64fe174 | I arranged and hosted an event at St Paul's Cathedral in aid of charity on 19 March 2009, for which I obtained sponsorship of more than £1,000 from the following: | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 0 | 2009-10-28-265f2269-10312-0 |
77ca57cbe1e3368ecf5bcb86e039f1e92321ff63 | Finmeccanica UK Ltd | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 1 | 2009-10-28-265f2269-10312-0 |
ece1a9808681937cae48aecef4889b0ae496953e | Saladin Security | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 2 | 2009-10-28-265f2269-10312-0 |
8cc2fb346d55ef251fdd1eefe77351b296db938d | Tesco plc | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 3 | 2009-10-28-265f2269-10312-0 |
fe3317905153aa1385dc8c1a1b9e11bb0af4a978 | As a result of the event, identifiable donations of more than £1,000 were made to charity by: | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 4 | 2009-10-28-265f2269-10312-0 |
3341e6315c1c18686a94347508094e2e7b7abf0c | Mr and Mrs N Hawkins of Cobham, Surrey | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 5 | 2009-10-28-265f2269-10312-0 |
6fc633b3f46363b2eb9c74b55fb092096c7833c4 | The Lisbet Rausing and Peter Baldwin Trust | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 6 | 2009-10-28-265f2269-10312-0 |
2d1a1b75afd47f1ad2c5da6f55f0f9caa0ee2eb6 | The CHEAR Foundation | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 7 | 2009-10-28-265f2269-10312-0 |
eeea7de42c9292a660e100255800a9ac2ce9421e | Mr C Vandrevala of London | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 8 | 2009-10-28-265f2269-10312-0 |
f280c290e66613325143da677f4359809906f5af | In addition, St Paul's Cathedral charged a concessionary rate, to reflect their support for the charity. (I am a member of the Council of St Paul's Cathedral.) (Registered 7 April 2009) | Miscellaneous and unremunerated interests 265f2269 | 2009-10-28 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 9 | 2009-10-28-265f2269-10312-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");