items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

5 rows where record_id = "2004-05-21-1f359ece-10226-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
160fc107631267ddfeeb65ca7d3118e5d90706e4 Regular articles on science policy in the British Association for Advancement of Science Journal. (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 0 2004-05-21-1f359ece-10226-0
fb4479d8584151bad93403af169c8b5453cc3078 11 April 2003, fee, travel and one night's accommodation in Athens for speaking at a meeting on the need for a European Disease Control Agency. (Up to £5,000) (Registered 3 July 2003) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 1 2004-05-21-1f359ece-10226-0
7a47df27975f90fd015695f56996a3e3efc7b596 September 2003, fee from Ruder Finn (PR Group) for participating in a training day. (Up to £5,000) (Registered 24 November 2003) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 2 2004-05-21-1f359ece-10226-0
ab423aae12696124dc097b4e4a2ce21115be048a 24 October 2003, fee for talk at Improving Cancer Journey Conference. (Up to £5,000) . (Registered 24 November 2003) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 3 2004-05-21-1f359ece-10226-0
ea7197742a74c8dcb2f5e80da9eb98fa5559f9a5 16-21 February 2004, five day visit to Cuba with All-Party Parliamentary Group on Cuba, to visit hospitals, schools and scientific establishments. Cost of airfare met by IPU and cost of accommodation met by the Cuban National Assembly. (Registered 16 March 2004) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 4 2004-05-21-1f359ece-10226-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");