items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2014-06-02-5f2cbd10-10040-0" sorted by record_id
This data as json, CSV (advanced)
date (date) 1 ✖
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
e46755b780a69127783bb7905d329c694537abe4 | On Monday 11 November 2013 I attended the ATP world tour finals as the guest of Barclays Premier, Barclays Bank PLC, 1 Churchill Place, London E14 5HP. The value of the complimentary ticket was about £200. (Registered 3 December 2013) | Miscellaneous 5f2cbd10 | 2014-06-02 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2014-06-02-5f2cbd10-10040-0 |
8c93db367826b4217bd7d740926e559178236999 | On 26 December 2013 I received two tickets and hospitality at a football match (approx value £300) from West Ham United FC, Green St, Upton Park, London E13 9AZ. (Registered 15 January 2014) | Miscellaneous 5f2cbd10 | 2014-06-02 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2014-06-02-5f2cbd10-10040-0 |
02fd281c14c88fc236621a834d7f58143be319b1 | On 1 January 2014 I received two tickets and hospitality at a football match (approx value £500) from Mr Ken Friar (private individual). (Registered 15 January 2014) | Miscellaneous 5f2cbd10 | 2014-06-02 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2014-06-02-5f2cbd10-10040-0 |
9d03c1175769453ca4a00db2fb212bd843929fd5 | On Sunday 6 April I received two tickets to attend a football match (total value under £200) from Everton Football Club, Goodison Road, Liverpool L4 4EL . (Registered 24 April 2014) | Miscellaneous 5f2cbd10 | 2014-06-02 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2014-06-02-5f2cbd10-10040-0 |
f3530e72c2e9104c088cd561f76ef98165eed802 | On Saturday 12 April I received two tickets to attend a football match (total value under £200) from the Football Association, Wembley Stadium, PO Box 1966, London SW1P 9EQ . (Registered 24 April 2014) | Miscellaneous 5f2cbd10 | 2014-06-02 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2014-06-02-5f2cbd10-10040-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");