items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
331 rows where person_id = "uk.org.publicwhip/person/10098" sorted by category_id
This data as json, CSV (advanced)
category_id 1 ✖
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c1e86395126bcb032e5323ec97511588679c904d | Date of visit: 19-26 September 2009 | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 9 | 2010-04-12-80ef1083-10098-0 |
c27ee05eaf7569561519c7f07b70d0a407fbed0e | (Registered 7 October 2009) | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 11 | 2010-02-24-80ef1083-10098-0 |
c2de31cec0b1f71f54102c1ac4b52ab55525630f | 25 October-1 November 2008, to China as Chairman of the All-Party Parliamentary China Group, at the invitation of the Jiangsu Provincial People's congress to consolidate links between the UK and China. Transport to and from China was paid for by the All-Party Parliamentary China Group from donations previously registered. All internal costs including accommodation, meals and travel were met by the Jiangsu Provincial People's Congress. (Registered 5 November 2008) | Overseas visits 80ef1083 | 2009-07-21 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2009-07-21-80ef1083-10098-0 |
c39890011b413def89e4baa07b6a490546d82ac6 | Purpose of visit: as Chairman of the All-Party Parliamentary China Group, to consolidate links between the UK and Jiangsu Province. | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 9 | 2010-03-10-80ef1083-10098-0 |
c66960e60b4489177386de5c13e0457bd3749b35 | Purpose of visit: as Chairman of the All-Party Parliamentary China Group, to consolidate links between the UK and Jiangsu Province. | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 11 | 2009-10-14-80ef1083-10098-0 |
c71f1dc6376a2d02d7715102a45015d96e7d525b | 24-31 May 2009, to Vietnam as Chair of the All-Party Parliamentary Group for Vietnam, to further co-operation with our counterpart parliamentary group. The cost of external and internal flights and accommodation was paid by the Group's registered sponsors, Premier Oil and the University of Central Lancashire. The National Assembly of Vietnam paid for ground travel costs and some hospitality. (Registered 3 June 2009) | Overseas visits 80ef1083 | 2009-06-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2009-06-10-80ef1083-10098-0 |
c91edb293de177caf1c7ab5820e95f1593750e0c | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 6 | 2009-10-28-80ef1083-10098-0 |
c9917699ab68bf3942e50794e07ec4cfbcc013c7 | 16-19 November 2004, to the Turkish Republic of Northern Cyprus. Air fares and a substantial part of the internal costs were met by the Government of the Turkish Republic of Northern Cyprus. (Registered 22 November 2004) | Overseas visits 80ef1083 | 2005-04-11 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2005-04-11-80ef1083-10098-0 |
c997005d99b4556c9370216bf89a4d930fb34611 | Address of donor: 1) House of Commons | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-03-10-80ef1083-10098-0 |
cb32dc8e5b7004c21b667f47c467d3ed6ac96683 | Purpose of visit: as Chairman of the All-Party Parliamentary China Group, to consolidate links between the UK and Jiangsu Province. | Overseas visits 80ef1083 | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 11 | 2009-12-10-80ef1083-10098-0 |
cbdc688f8f0b8483ce424469a360f9d20dbc80c1 | 5-8 October 2006, to Moldova with the All-Party Parliamentary Group on Moldova. Accommodation, transport and some meals were provided by the Moldovan Parliament. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-07-30 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2007-07-30-80ef1083-10098-0 |
d18740aa50389b64813c452e9ab2886d6a004c12 | (Registered 7 October 2009) | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 12 | 2009-10-14-80ef1083-10098-0 |
d2bc7004385b14cdfe67d121fd4902f92336ed3c | 27 May-1 June 2007, to Hong Kong at the invitation of the Hong Kong Government. Transport, accommodation and some meals were provided by the Hong Kong authorities. (Registered 6 June 2007) | Overseas visits 80ef1083 | 2007-07-17 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2007-07-17-80ef1083-10098-0 |
d2f701a0e1e7830b6452f869e0aaa0d3b927d7e9 | 2) 32 Zhong Shan Beilu, Nanjing 210008, People's Republic of China | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 5 | 2010-01-06-80ef1083-10098-0 |
d3806e07b05adfbd8cac20df9ede54f625ceb95e | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2010-03-24-80ef1083-10098-0 |
d553784e9a21a09afc3d74408e54b4eaa3f222fc | 27 May-1 June 2007, to Hong Kong at the invitation of the Hong Kong Government. Transport, accommodation and some meals were provided by the Hong Kong authorities. (Registered 6 June 2007) | Overseas visits 80ef1083 | 2008-01-09 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2008-01-09-80ef1083-10098-0 |
d737e4dd00c9a8b459753abb958056aa019605d4 | 25 October-1 November 2008, to China as Chairman of the All-Party Parliamentary China Group, at the invitation of the Jiangsu Provincial People's congress to consolidate links between the UK and China. Transport to and from China was paid for by the All-Party Parliamentary China Group from donations previously registered. All internal costs including accommodation, meals and travel were met by the Jiangsu Provincial People's Congress. (Registered 5 November 2008) | Overseas visits 80ef1083 | 2009-05-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2009-05-06-80ef1083-10098-0 |
da884d37179f3ac158753dcb0279589b34804900 | 5-8 October 2006, to Moldova with the All-Party Parliamentary Group on Moldova. Accommodation, transport and some meals were provided by the Moldovan Parliament. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-02-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2007-02-06-80ef1083-10098-0 |
db2e7bb6696006af0b6ecaaacacb9306257ba9c2 | 25 October-1 November 2008, to China as Chairman of the All-Party Parliamentary China Group, at the invitation of the Jiangsu Provincial People's congress to consolidate links between the UK and China. Transport to and from China was paid for by the All-Party Parliamentary China Group from donations previously registered. All internal costs including accommodation, meals and travel were met by the Jiangsu Provincial People's Congress. (Registered 5 November 2008) | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2010-01-06-80ef1083-10098-0 |
dcc48767ac5c697584860f1134649416620fdddc | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 5 | 2010-02-24-80ef1083-10098-0 |
dd048b4a51a40d316ec1a2fa1a7d2482c7121605 | 6-16 September 2007, to China as Chairman of the All-Party Parliamentary China Group, to discuss bilateral relations and human rights and the impact of China's economic growth on the UK. All internal travel and some food costs in China were met by the National People's Congress. The cost of the return flights from London to Beijing and accommodation costs were met from the funds provided by the registered sponsors of the All-Party Group. (Registered 18 October 2007) | Overseas visits 80ef1083 | 2008-01-09 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2008-01-09-80ef1083-10098-0 |
dfe8f642abaa539ea1b3e68edc33ae8bcd842ea0 | 5-8 October 2006, to Moldova with the All-Party Parliamentary Group on Moldova. Accommodation, transport and some meals were provided by the Moldovan Parliament. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-06-05 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2007-06-05-80ef1083-10098-0 |
e009c90da3688ddc6f9adb030179490c22db656b | 13-21 August 2001, travel to Washington as a guest of British Midland on their inaugural transatlantic flight. The flight only has been provided. (Registered 22 August 2001) | Overseas visits 80ef1083 | 2002-05-14 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2002-05-14-80ef1083-10098-0 |
e0996295606fb0926154243b180ca8df71b648f0 | Address of donor: 1) House of Commons | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 4 | 2009-10-14-80ef1083-10098-0 |
e0acf75bda79821545d2d72fdf118b3318cf2c24 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 6 | 2010-03-24-80ef1083-10098-0 |
e0b0eb89aad0a242d63df35ffbca0e8b86949037 | 25-27 November 2003, to Romania with the All-Party Romania Group for discussions with Ministers and officials. Hospitality and accommodation provided by the Government of Romania. (Registered 3 December 2003) | Overseas visits 80ef1083 | 2004-01-31 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2004-01-31-80ef1083-10098-0 |
e17a079b3ec25450c20b03d44e0ad7722f0592ef | 2) 32 Zhong Shan Beilu, Nanjing 210008, People's Republic of China | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 4 | 2010-03-24-80ef1083-10098-0 |
e1ac875037de6e2f6491b098acbbcab50a49b66c | 2) 32 Zhong Shan Beilu, Nanjing 210008, People's Republic of China | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 5 | 2009-11-25-80ef1083-10098-0 |
e3166accc1637bcfe45a3cc7757449657cef8770 | Name of donor: 1) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2009-11-25-80ef1083-10098-0 |
e3e8c81aa7919987b8305239a33241f468674f70 | Purpose of visit: as Chairman of the All-Party Parliamentary China Group, to consolidate links between the UK and Jiangsu Province. | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 11 | 2009-10-28-80ef1083-10098-0 |
e4363c80a6f9add6aada04ebd219cfc2075219fd | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2010-01-06-80ef1083-10098-0 |
e4715e5919d46f367ae62552745659ea1cbf743e | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-12-10-80ef1083-10098-0 |
e48db9c938997c43acb27e39eaa413763c234532 | 2) 32 Zhong Shan Beilu, Nanjing 210008, People's Republic of China | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 5 | 2009-10-28-80ef1083-10098-0 |
e5bb5bf51726ace73eac127cbf47f42487bd3431 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-11-11 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-11-11-80ef1083-10098-0 |
e67485e71b2477d873ed8f09dbfe1a0a940ad077 | Date of visit: 19-26 September 2009 | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 9 | 2010-02-24-80ef1083-10098-0 |
e81549feea47c048d25be52586935fe38c6d62de | 24-31 May 2009, to Vietnam as Chair of the All-Party Parliamentary Group for Vietnam, to further co-operation with our counterpart parliamentary group. The cost of external and internal flights and accommodation was paid by the Group's registered sponsors, Premier Oil and the University of Central Lancashire. The National Assembly of Vietnam paid for ground travel costs and some hospitality. (Registered 3 June 2009) | Overseas visits 80ef1083 | 2009-09-02 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2009-09-02-80ef1083-10098-0 |
e883f6deb4ab5e700f4251c7cbc54a8b08079144 | 1) £713 (return flights to Shanghai) (from donations previously registered) | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 7 | 2010-01-06-80ef1083-10098-0 |
eb10ab69e5a553593e8df90313918bbdadb41c21 | 25 October-1 November 2008, to China as Chairman of the All-Party Parliamentary China Group, at the invitation of the Jiangsu Provincial People's congress to consolidate links between the UK and China. Transport to and from China was paid for by the All-Party Parliamentary China Group from donations previously registered. All internal costs including accommodation, meals and travel were met by the Jiangsu Provincial People's Congress. (Registered 5 November 2008) | Overseas visits 80ef1083 | 2008-12-17 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2008-12-17-80ef1083-10098-0 |
ebba30b780c2e593bd6ddf24723404417943379e | 5-8 October 2006, to Moldova with the All-Party Parliamentary Group on Moldova. Accommodation, transport and some meals were provided by the Moldovan Parliament. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-01-23 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2007-01-23-80ef1083-10098-0 |
ed6f6bce47ad670f9263088543ef085a9fc630a0 | Purpose of visit: as Chairman of the All-Party Parliamentary China Group, to consolidate links between the UK and Jiangsu Province. | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 11 | 2009-11-25-80ef1083-10098-0 |
edf9505847785f15a2094b0c004eeed34fb2de8a | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-02-03-80ef1083-10098-0 |
eecb28ff87a1d2370b048bd752c233cca8b6220e | 25 October-1 November 2008, to China as Chairman of the All-Party Parliamentary China Group, at the invitation of the Jiangsu Provincial People's congress to consolidate links between the UK and China. Transport to and from China was paid for by the All-Party Parliamentary China Group from donations previously registered. All internal costs including accommodation, meals and travel were met by the Jiangsu Provincial People's Congress. (Registered 5 November 2008) | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2009-10-14-80ef1083-10098-0 |
ef2264bbba4a560a1e2a938b16b37bd11b25302f | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-04-12-80ef1083-10098-0 |
f205920bf4a0c709b772bb4f3f4e5bae62226a22 | 27 May-1 June 2007, to Hong Kong at the invitation of the Hong Kong Government. Transport, accommodation and some meals were provided by the Hong Kong authorities. (Registered 6 June 2007) | Overseas visits 80ef1083 | 2008-03-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2008-03-25-80ef1083-10098-0 |
f36266851ceb1d0849e2685b7cdad3ef7d731447 | 24-31 May 2009, to Vietnam as Chair of the All-Party Parliamentary Group for Vietnam, to further co-operation with our counterpart parliamentary group. The cost of external and internal flights and accommodation was paid by the Group's registered sponsors, Premier Oil and the University of Central Lancashire. The National Assembly of Vietnam paid for ground travel costs and some hospitality. (Registered 3 June 2009) | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2010-03-10-80ef1083-10098-0 |
f49efb7a5c678d1e05a15fefdbf7858eda72032e | 23 May-1June 2003, to Syria. Travel paid for by British Syrian Society, hospitality provided by Government of Syria. (Registered 4 June 2003) | Overseas visits 80ef1083 | 2004-01-31 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2004-01-31-80ef1083-10098-0 |
f695b6b5b8fefe3a4f915b71145c59208a1c7d91 | Date of visit: 19-26 September 2009 | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 10 | 2009-11-25-80ef1083-10098-0 |
f787e7c0dacfa72aea1483ef937b6e4b35667eb4 | 9-18 May 2002, to China as leader of delegation from the All-Party China Group. Cost of hotels, hospitality and transport in China were met by the Chinese Government. (Registered 8 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | Ben Chapman uk.org.publicwhip/member/791 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2002-11-26-80ef1083-10098-0 |
f8024836399d71a54d213214c66f70835dc743b7 | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 2 | 2010-02-24-80ef1083-10098-0 |
f8f618721589ad5ae2b25bfc1e005a22f1c41a68 | Purpose of visit: as Chairman of the All-Party Parliamentary China Group, to consolidate links between the UK and Jiangsu Province. | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 10 | 2010-04-12-80ef1083-10098-0 |
fb38d1f8ee745d10044288e88ce6185d2bee45b0 | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-10-14-80ef1083-10098-0 |
fca435a1cf10e1a5c76f9242eb2f4ca8aec4bbef | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-10-28-80ef1083-10098-0 |
fd80e0df319e5e336c32ab6a88fb80fb2f83af34 | 6-16 September 2007, to China as Chairman of the All-Party Parliamentary China Group, to discuss bilateral relations and human rights and the impact of China's economic growth on the UK. All internal travel and some food costs in China were met by the National People's Congress. The cost of the return flights from London to Beijing and accommodation costs were met from the funds provided by the registered sponsors of the All-Party Group. (Registered 18 October 2007) | Overseas visits 80ef1083 | 2008-10-08 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 0 | 2008-10-08-80ef1083-10098-0 |
ff70462ec5c079d1e5ba48ade142a1cdba203684 | 6-16 September 2007, to China as Chairman of the All-Party Parliamentary China Group, to discuss bilateral relations and human rights and the impact of China's economic growth on the UK. All internal travel and some food costs in China were met by the National People's Congress. The cost of the return flights from London to Beijing and accommodation costs were met from the funds provided by the registered sponsors of the All-Party Group. (Registered 18 October 2007) | Overseas visits 80ef1083 | 2007-11-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 1 | 2007-11-06-80ef1083-10098-0 |
ffae704f6c174468eb78a74b87e751c02d241b3a | 2) £700 (includes hotels for 6 nights, meals and coach travel for 6 days.) | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 8 | 2009-11-25-80ef1083-10098-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");