items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2010-01-06-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 |
---|---|---|---|---|---|---|---|
c6b4984ec827de8953af581bc33f14f7752faf76 | 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 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 0 | 2010-01-06-265f2269-10312-0 |
ae2554c67a6bdc2f0c46a7a28c5b854b2c81e662 | Finmeccanica UK Ltd | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 1 | 2010-01-06-265f2269-10312-0 |
5e4bc278d2aaba7fe6828b330a39ad4055123648 | Saladin Security | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 2 | 2010-01-06-265f2269-10312-0 |
0c5c50434d66be83f1d778889699094c0aee9ce6 | Tesco plc | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 3 | 2010-01-06-265f2269-10312-0 |
0cebc0aab114b16d87ea68848219678e2aae2437 | As a result of the event, identifiable donations of more than £1,000 were made to charity by: | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 4 | 2010-01-06-265f2269-10312-0 |
24948f409b8805941ce88c9df1ea4818cda137bb | Mr and Mrs N Hawkins of Cobham, Surrey | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 5 | 2010-01-06-265f2269-10312-0 |
8d89237b3ad6af79f9a869745672e1f720eb4bba | The Lisbet Rausing and Peter Baldwin Trust | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 6 | 2010-01-06-265f2269-10312-0 |
1968f932690596bc4eaa83f19a91c9212ee77945 | The CHEAR Foundation | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 7 | 2010-01-06-265f2269-10312-0 |
0c328158fec52cd3db65c3396c9fe849ca4cb578 | Mr C Vandrevala of London | Miscellaneous and unremunerated interests 265f2269 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 8 | 2010-01-06-265f2269-10312-0 |
c25ff907201886e77e4219b013ee76a748856dc5 | 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 | 2010-01-06 | Bernard Jenkin uk.org.publicwhip/member/1579 | Bernard Jenkin uk.org.publicwhip/person/10312 | 9 | 2010-01-06-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");