items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2005-04-11-84642823-10290-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
64d0f22a39e40f90bd18d67edfe6883acdfb0dad | To facilitate my travel in my capacity as Leader of the Opposition, I have received helicopter travel from the following: | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 0 | 2005-04-11-84642823-10290-0 |
b6dca6b666ff3a16c73f9d7dcf3bb30784949e9b | JC Bamford Excavators Ltd., Rocester, Staffordshire. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 1 | 2005-04-11-84642823-10290-0 |
eece6465825d605e6dc6e5a47207172a43df94f2 | JCB Research Ltd. Rocester. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 2 | 2005-04-11-84642823-10290-0 |
704095ad05a1d012e6f5c5caeeaa2f047752a1e1 | Mr. John Scurr, of London. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 3 | 2005-04-11-84642823-10290-0 |
e4627b846fcb8708b8aa8a01093b48d3699c0c5e | Lord Haughey, Chairman, Norbrook Laboratories (GB) Ltd., County Down. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 4 | 2005-04-11-84642823-10290-0 |
a12947458603d3b632355e6d47d6ead32f376963 | Johann Eliasch, ECJ Investments, London (use of private plane). | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 5 | 2005-04-11-84642823-10290-0 |
808c77a9e99f28e4e415256f88c4b16e0c3d1130 | Lord Hesketh. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 6 | 2005-04-11-84642823-10290-0 |
87e0c6eddf5e561a68f8031cfe766dce565fcb5a | Marquess of Milford-Haven. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 7 | 2005-04-11-84642823-10290-0 |
6216e5ae226b7441d46380ac3a4d2b90f5ab606b | Viking Office Supplies Ltd., Staffordshire. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 8 | 2005-04-11-84642823-10290-0 |
531d58668de2a77a4dea6df79a544e11cfe60510 | Mr. D. Instance, Sellindge, Ashford (use of private plane). | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 9 | 2005-04-11-84642823-10290-0 |
a05eb08e48b7a31c4b604518ba56c7fa9d301814 | The details of the travel provided have been provided to the office of the Parliamentary Commissioner for Standards. | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 10 | 2005-04-11-84642823-10290-0 |
dd5018a0da973b5b624cc9f9bd0b840e5ad65a96 | Gift of a Christmas hamper from His Majesty the Sultan of Brunei. (Registered 20 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 11 | 2005-04-11-84642823-10290-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");