items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2009-06-10-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 |
---|---|---|---|---|---|---|---|
35970b3d0127f1d73b968acd2a023a291c040472 | I arranged and hosted an event at St Paul's Cathedral in aid of Combat Stress and the St Paul's Cathedral Foundation on 19 March 2009, for which I obtained sponsorship of more than £1,000 from the following: | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 0 | 2009-06-10-265f2269-10312-0 |
e5233f55b92552ccbe996ac44e40d679cca8c006 | Finmeccanica UK Ltd | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 1 | 2009-06-10-265f2269-10312-0 |
17e913f47d15b9a6ad79a217b7723fa4ceedcacb | Saladin Security | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 2 | 2009-06-10-265f2269-10312-0 |
5e2ebbf3a19ffc16042461453e6c1cb7ad29d0e9 | Tesco plc | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 3 | 2009-06-10-265f2269-10312-0 |
9247c611f38972b5e64b7aadcefa069c1400afde | As a result of the event, identifiable donations of more than £1,000 were made to Combat Stress by: | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 4 | 2009-06-10-265f2269-10312-0 |
0592ad4449336583fdaadb67964e9dae5b00e15c | Mr and Mrs N Hawkins of Cobham, Surrey | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 5 | 2009-06-10-265f2269-10312-0 |
2f4fbe08838a24cfef7774a39160a828f8f3412c | The Lisbet Rausing and Peter Baldwin Trust | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 6 | 2009-06-10-265f2269-10312-0 |
d73f2f51521227815a6f61b3f1c76d346c3083d5 | The CHEAR Foundation | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 7 | 2009-06-10-265f2269-10312-0 |
c509ec022b2ef2dc8eabaaa53b4fe7c7d9593eee | Mr C Vandrevala of London | Miscellaneous and unremunerated interests 265f2269 | 2009-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 8 | 2009-06-10-265f2269-10312-0 |
d53daf8fdadaa1cbe46dbfa9a888ac3aee30f3f2 | 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-06-10 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 9 | 2009-06-10-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");