items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-06-02-84642823-10103-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 |
---|---|---|---|---|---|---|---|
5b1b8aee8c030636d432426f0490e735a62bab14 | Name of donor: JTI | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 0 | 2014-06-02-84642823-10103-0 |
ff667b1223a7fc4d901906b4c77313b99e2292e1 | Amount of donation or nature and value if donation in kind: two tickets and associated hospitality at Glyndebourne at an approximate value of £1,534 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 2 | 2014-06-02-84642823-10103-0 |
501a6ac16db72a97116877d41ce08e27e740c83c | Date of receipt of donation: 13 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 3 | 2014-06-02-84642823-10103-0 |
91760610b3be6997d5117e6f69573acdebe00661 | Date of acceptance of donation: 13 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 4 | 2014-06-02-84642823-10103-0 |
7c52096852c103a2439a1599212b440e21662ed2 | Donor status: company, registration 01501573 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 5 | 2014-06-02-84642823-10103-0 |
8b5f0b303d4a550a79c378802b3423b23041c479 | (Registered 3 July 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 6 | 2014-06-02-84642823-10103-0 |
7e9d81a735bc99756e558ac61a7dc4ccb289969e | Name of donor : JTI | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 7 | 2014-06-02-84642823-10103-0 |
83a70dc4bf18d1a06f7bba68e00836510f630a5a | Address of donor : Members Hill, Brooklands Road, Weybridge, KT13 0QU | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 8 | 2014-06-02-84642823-10103-0 |
7011e80687b2073d1211895f0e20fe4355609953 | Amount of donation or nature and value if donation in kind : two tickets and associated hospitality at Twickenham at an approximate value of £400 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 9 | 2014-06-02-84642823-10103-0 |
8e98b939eb3c03919dca1fdded14d209c3b52782 | Date of receipt of donation: 16 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 10 | 2014-06-02-84642823-10103-0 |
8d6f7811bc110839766befad5ef86728d5ddb93f | Date of acceptance of donation: 16 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 11 | 2014-06-02-84642823-10103-0 |
b044e1c2cee6cee0c5bf56b0e56f87930758bb39 | Donor status : company, registration 01501573 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 12 | 2014-06-02-84642823-10103-0 |
2ce6a02d2e5921169dc0c2d9b97f9295f6317ca7 | (Registered 4 December 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-02 | Christopher Chope uk.org.publicwhip/member/40171 | Christopher Chope uk.org.publicwhip/person/10103 | 13 | 2014-06-02-84642823-10103-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");