items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2010-03-24-80ef1083-11199-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 |
---|---|---|---|---|---|---|---|
7df3991b80eee059623ba7b2f8e65545896742e4 | 9-13 September 2008, to the British Overseas Territory of Gibraltar to participate in the commemoration of Gibraltar's National Day. Flights, accommodation and meals provided by the Government of Gibraltar. (Registered 16 April 2009) | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 0 | 2010-03-24-80ef1083-11199-0 |
66c392bb41cf7700fe69b710494c170da4fd620b | 4-11 April 2009 to China as a guest of the Chinese Association of Friendship and Understanding. Accommodation and food paid for by the Association and flight sponsored by Mr Maurice Bennett; businessman, London. (Registered 13 April 2009) | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 1 | 2010-03-24-80ef1083-11199-0 |
ffa87e6288182668ae53fa8ebf2df3fccfb55d3c | 12-19 April 2009, to Syria, as a member of a parliamentary delegation to meet government ministers, parliamentarians and business leaders. The cost of flights and hospitality was met by the British Syrian Society and the Syrian Government. (Registered 29 April 2009) | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 2 | 2010-03-24-80ef1083-11199-0 |
f839d04d9345220d9fe3a53f9cc111e2cf73174c | Name of donor: Government of Guernsey | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 3 | 2010-03-24-80ef1083-11199-0 |
c9f05d5e36e36c3d0cc75f7105039d1bbbace3aa | Address of donor: Sir Charles Frossard House, La Charroterie, St Peter Port, Guernsey GY1 1FH | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 4 | 2010-03-24-80ef1083-11199-0 |
3d431c8edacc7d27a314b8c31acc0d6500a03f74 | Amount of donation (or estimate of the probable value): travel, accommodation, food and entertainment for my sister and me; value £1063 | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 5 | 2010-03-24-80ef1083-11199-0 |
bb4aada6c6bb3035998b2e83b2b13f587a0c3455 | Destination of visit: Guernsey and Sark | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 6 | 2010-03-24-80ef1083-11199-0 |
ada155b7bdf8f67a0d2ee90e26e014d3ed24441f | Date of visit: 5-7 June 2009 | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 7 | 2010-03-24-80ef1083-11199-0 |
17ac2f4b0fe66fff6ca2f3c3a63e820e26a12c3b | Purpose of visit: as Vice-Chair of All-Party Group on Channel Islands | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 8 | 2010-03-24-80ef1083-11199-0 |
141b53d9f008113adfcae95539b5fe2893ea01d1 | (Registered 24 March 2010) | Overseas visits 80ef1083 | 2010-03-24 | Andrew Rosindell uk.org.publicwhip/member/1786 | Andrew Rosindell uk.org.publicwhip/person/11199 | 9 | 2010-03-24-80ef1083-11199-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");