items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2000-11-10-84642823-10199-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 |
---|---|---|---|---|---|---|---|
fc2f2c70bbb925b049fe45f9b3700eb984e95e5b | 9 February 1998, I received two tickets for the Brit Awards from the British Phonographic Industry. (Registered 25 February 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Jim Fitzpatrick uk.org.publicwhip/member/199 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2000-11-10-84642823-10199-0 |
87e9a13945e8224d5aae927cbc256068800056f2 | 16 February 1999, I received one ticket to the Brit Awards from The London Arena. (Registered 25 February 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Jim Fitzpatrick uk.org.publicwhip/member/199 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2000-11-10-84642823-10199-0 |
720627700c6569d76ca893da85af57358b098f3a | 4 July 1999, two tickets for "Party in the Park", courtesy of Capital Radio. (Registered 5 July 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Jim Fitzpatrick uk.org.publicwhip/member/199 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2000-11-10-84642823-10199-0 |
03db159f86d1682c3f6125d117c42848807cba3a | I have received two season tickets to West Ham United's Director's Box for the 1999/2000 season. (Registered 11 August 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Jim Fitzpatrick uk.org.publicwhip/member/199 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2000-11-10-84642823-10199-0 |
e95acecc2f77c640badc1bf2d8fdd9f17c1604d3 | September 1999, during the visit of the Hungarian Parliamentary Football Team to the UK, I received hospitality sponsored by Powergen Ltd., Provident Finance and West Ham FC. (Registered 17 December 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Jim Fitzpatrick uk.org.publicwhip/member/199 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2000-11-10-84642823-10199-0 |
44491b552039068afccfb2a6d6189473c1378e29 | Two season tickets to West Ham United FC Director's Box for 2000/1. (Registered 11 October 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Jim Fitzpatrick uk.org.publicwhip/member/199 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2000-11-10-84642823-10199-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");