items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2008-07-22-a41b9847-10777-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 |
---|---|---|---|---|---|---|---|
dcc27fa7633b842d851b8b7566f40d4da987832f | Following my visit to Afghanistan, I was given a rug by Hamid Karzai, President of the Islamic Republic of Afghanistan. (Registered 30 August 2007) | Overseas benefits and gifts a41b9847 | 2008-07-22 | David Cameron uk.org.publicwhip/member/1932 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2008-07-22-a41b9847-10777-0 |
2a40b50bcd5bba8429cce6cecffd3f4c824374c5 | In connection with a visit to California, USA, 10-12 October 2007, to make a speech at Google Zeitgeist Conference, the cost of commercial flights from London to San Francisco; Sacramento to Los Angeles; and Los Angeles to London for me and three accompanying members of my staff, was met by Google, USA. Google also provided one night's accommodation for me and three accompanying members of my staff and transport by car within California. (Other costs associated with the visit were met by the Conservative Party.) (Registered 19 November 2007) | Overseas benefits and gifts a41b9847 | 2008-07-22 | David Cameron uk.org.publicwhip/member/1932 | David Cameron uk.org.publicwhip/person/10777 | 1 | 2008-07-22-a41b9847-10777-0 |
0f426f8e837bcb628fa4383aa714dbdd4c57e680 | Gift of a Harrods hamper from the Sultan of Brunei. (Registered 10 January 2008) | Overseas benefits and gifts a41b9847 | 2008-07-22 | David Cameron uk.org.publicwhip/member/1932 | David Cameron uk.org.publicwhip/person/10777 | 2 | 2008-07-22-a41b9847-10777-0 |
78a659925afec5a36d8f78db20d987e7de77f971 | 18-20 December 2007, during an official visit to China, the International Liaison Department of the Chinese Communist Party provided me and my Chief of Staff with the following: an internal flight from Beijing to Chongqing, one night of hotel accommodation (the second night provided by the British Embassy in Beijing), some internal transport and a translator. Similar benefits but including two nights' hotel accommodation were provided to three members of Conservative Campaign Headquarters. (Registered 15 January 2008) | Overseas benefits and gifts a41b9847 | 2008-07-22 | David Cameron uk.org.publicwhip/member/1932 | David Cameron uk.org.publicwhip/person/10777 | 3 | 2008-07-22-a41b9847-10777-0 |
4ea20abf0dad65fb61ec8831ec0c1a240eacd340 | Gift of a sterling silver tray from President George W Bush, President of the United States, (Registered 16 June 2008) | Overseas benefits and gifts a41b9847 | 2008-07-22 | David Cameron uk.org.publicwhip/member/1932 | David Cameron uk.org.publicwhip/person/10777 | 4 | 2008-07-22-a41b9847-10777-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");