items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where search matches "hamper" and sort_order = 11 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, member_id, person_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
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 |
caa592d8a9496d5ceec728a5aa64088eaded7bfd | Gift of a Christmas hamper from His Majesty the Sultan of Brunei. (Registered 20 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-01-28 | Michael Howard uk.org.publicwhip/member/974 | Michael Howard uk.org.publicwhip/person/10290 | 11 | 2005-01-28-84642823-10290-0 |
7be132a5985b7e234a696356332cfb09b5839769 | December 1999, I received a gift of a Christmas hamper from Lord Harris of Peckham. (Registered 2 March 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | William Hague uk.org.publicwhip/member/251 | William Hague uk.org.publicwhip/person/10251 | 11 | 2000-11-10-84642823-10251-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");