items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2014-03-24-84642823-10180-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 |
---|---|---|---|---|---|---|---|
b1c398d45ee449cd65fb3e5850219b6177c768e5 | I have accepted honorary life membership of Buck’s Club 1919, 18 Clifford Street, London W15 3RF. | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2014-03-24-84642823-10180-0 |
415cb431504ec063e2bf413d8d9626c1357c22cb | I have accepted honorary life membership of Pratt’s Club as a Special Member, 14 Park Place, London SW1A 1LP. | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2014-03-24-84642823-10180-0 |
a513d39e33b8365e8f7505f17ed3f65d36ef37d0 | Name of donor: Tottenham Hotspur Football and Athletic Co Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2014-03-24-84642823-10180-0 |
06fddedacfc3e126637b1354c4ae32de001e9e32 | Address of donor: Bill Nicholson Way, 748 High Road, London N17 0AP | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2014-03-24-84642823-10180-0 |
d9c598b54ee5ef6a0274d65fbfafd2ca8811a5bd | Amount of donation or nature and value if donation in kind: hospitality in Tottenham Hotspur’s directors’ box for me and my son; estimated value £2,400 | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2014-03-24-84642823-10180-0 |
9bf3646a7cd686ed1d5f918cc7e99a45d2735de6 | Date of receipt of donation: 3 March 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2014-03-24-84642823-10180-0 |
a470ae6058b6762cc2daff87c6763da4071066a8 | Date of acceptance of donation: 3 March 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2014-03-24-84642823-10180-0 |
849c47dc296ce465fc379a919d4d0691ca2e135b | Donor status: company, registration 57186 (Registered 17 April 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-03-24 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2014-03-24-84642823-10180-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");