items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where person_id = "uk.org.publicwhip/person/10196" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c39be6ca13d76653019c5c1644baa64a17acaa1d | Councillor, Sefton Metropolitan Borough Council. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 0 | 2001-05-14-1f359ece-10196-0 |
e841f9190d6a7d7d887ef6344b08c0ee5cea7874 | 3-6 November 2000, to Rome to attend the Jubilee Celebrations for Parliamentarians, at the invitation of the Organising Committee of the All-Party Parliamentary Group on Parliamentarians for the Jubilee Year in the Italian Senate, who paid for my hotel accommodation. I met my own travel costs to Rome. (Registered 13 December 2000) | Overseas visits 80ef1083 | 2001-05-14 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 0 | 2001-05-14-80ef1083-10196-0 |
c17331b0d32eb774ec84b5eee0afad7513eddf27 | Councillor, Sefton Metropolitan Borough Council. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 0 | 2000-11-10-1f359ece-10196-0 |
6f18a9cdfc4a387b7046c9af3b6bf6a5798fa4ff | 30 September 1999, I attended the Scottish and Newcastle (Pontins) 250 years celebration in Edinburgh, including one night's hotel accommodation for myself and my wife following the Celebration Dinner, costs met by the Scottish and Newcastle Brewery. (Registered 19 October 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 0 | 2000-11-10-84642823-10196-0 |
3503a087bde365a896e7ae8c43b1ad2d41f44b68 | 31 December 1999, four tickets for the Millennium Dome opening celebration provided by the New Millennium Experience Company. (Registered 10 January 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 1 | 2000-11-10-84642823-10196-0 |
835de44e3f6e7455f036e6023892dfcccb9e567b | 17-18 May 1999, to Geneva, in my capacity as Liberal Democrat Tourism spokesperson, to attend the EIBTM (European Incentive and Business Travel and Meetings Exhibition)/EMILG (European Meeting and Incentive Industry Liaison Group) working dinner and visit to exhibition on the Opening Day. Return flight and one night's accommodation sponsored by EIBTM. (Registered 19 May 1999) | Overseas visits 80ef1083 | 2000-11-10 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 0 | 2000-11-10-80ef1083-10196-0 |
dadefaec0bf9f8cf7d8d1ed3825618494df6812a | 1-3 July 1999, to Amsterdam, to visit the British Tourist Association office in my capacity as Liberal Democrat Tourism spokesperson. All expenses met by the British Tourist Association. (Registered 5 July 1999) | Overseas visits 80ef1083 | 2000-11-10 | Ronnie Fearn uk.org.publicwhip/member/196 | Ronnie Fearn uk.org.publicwhip/person/10196 | 1 | 2000-11-10-80ef1083-10196-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");