items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2000-11-10-84642823-10484-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 |
|---|---|---|---|---|---|---|---|
| ff39c22037c1f70a932471dfaa15eb29a9cd4c9d | 4 July 1999, tickets for myself, my wife and two children to the Party in the Park, supplied by Capital Radio. (Registered 5 July 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Stephen Pound uk.org.publicwhip/member/484 | Steve Pound uk.org.publicwhip/person/10484 | 0 | 2000-11-10-84642823-10484-0 |
| 1c4ac4544f7607d4eddea1d3a45235d2b487afbd | September 1999, gift of a Harrods hamper from Mr Mohamed Al Fayed, which was auctioned for charity with no benefit to me. (Registered 24 December 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Stephen Pound uk.org.publicwhip/member/484 | Steve Pound uk.org.publicwhip/person/10484 | 1 | 2000-11-10-84642823-10484-0 |
| dbe05f391dccd8c495906dd13e6114510afdf915 | December 1999, gift of a Harrods hamper from Mr Mohamed Al Fayed. Contents donated to pensioners in Ealing North constituency. (Registered 24 December 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Stephen Pound uk.org.publicwhip/member/484 | Steve Pound uk.org.publicwhip/person/10484 | 2 | 2000-11-10-84642823-10484-0 |
| 2d905b0497904af74354e3e7eb6ebed778a49349 | 25-27 April 2000, to Poland with the All-Party Building Societies Group visit to the Polish Housing Minister and the Housing and Building Commission of the Parliament. Hotels paid by Polish Parliament. Fares paid by Building Societies Association. (Registered 2 May 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Stephen Pound uk.org.publicwhip/member/484 | Steve Pound uk.org.publicwhip/person/10484 | 3 | 2000-11-10-84642823-10484-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");