items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2014-01-06-84642823-10040-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 |
---|---|---|---|---|---|---|---|
679ee0e804e5a3679fb30cfe0dab8fc26a9ca121 | Name of donor: Lawn Tennis Association | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2014-01-06-84642823-10040-0 |
7c6d211231d76f9b21d72b79a16f65a3e049f94d | Address of donor : National Tennis Centre, 100 Priory Lane, London SW15 5JQ | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2014-01-06-84642823-10040-0 |
31e7d521925b713a3ae4847a73f8f90c127428b2 | Amount of donation or nature and value if donation in kind: Seat in Royal Box at Aegon Championship on 16 June 2013,estimated value £1,070, and two tickets for Centre Court on 29 June 2013,estimated value £148; total value £1,218 | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2014-01-06-84642823-10040-0 |
fa7e9b2f5c813b0e24be829726699aeaa0d959e8 | Date of receipt of donation: 16 and 29 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2014-01-06-84642823-10040-0 |
2dfc25c6a2884c1dc71ad690b2559839aa396f20 | Date of acceptance of donation: 16 and 29 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2014-01-06-84642823-10040-0 |
ccee61ee27d8fc8db468be5dbc7ac3c01ba7322c | Donor status: company, registration 07459469 | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 5 | 2014-01-06-84642823-10040-0 |
515c532487504f9c05b08e6666032ae2bfc3a745 | (Registered 8 July 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2014-01-06-84642823-10040-0 |
2dc76f451a7faacd8109a3fdfa724540e94a581f | Name of donor: Aisam Qureshi | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 7 | 2014-01-06-84642823-10040-0 |
ac73e85b1665a9638989d463092380976cd9cb21 | Address of donor : private | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2014-01-06-84642823-10040-0 |
0e3a3b147d97113c0905028928cd96bed6b2c168 | Amount of donation or nature and value if donation in kind: A week’s pass to the ATP World Tour finals with an estimated value of £1,000 (no commercial equivalent) | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 9 | 2014-01-06-84642823-10040-0 |
82e321e447fd4ef2d8eae410bd1f7c5a37e30f9e | Date of receipt of donation: 4 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 10 | 2014-01-06-84642823-10040-0 |
104a685336254c25284e9e03a348ac942f9d4f5b | Date of acceptance of donation: 4 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2014-01-06-84642823-10040-0 |
09893b45280e905d216492dd3dda581e754188f2 | Donor status: individual | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 12 | 2014-01-06-84642823-10040-0 |
5421dc4d704cd6489271890cc99118e930b8ea02 | (Registered 3 December 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 13 | 2014-01-06-84642823-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");