items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-06-24-80ef1083-11715-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 |
---|---|---|---|---|---|---|---|
5afe155283b01275e299723452bd418a6b278b0b | Name of donor: The Global Legislators Organisation (GLOBE) and World Summit of Legislators | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2013-06-24-80ef1083-11715-0 |
615fb38b00768dc5008952d815911aaaa914ed5b | Address of donor: 11 Dartmouth Street, London SW1H 9BN | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2013-06-24-80ef1083-11715-0 |
5407da227babd73303fab139a8e2958ed25e3cc0 | Amount of donation (or estimate of the probable value): cost of travel and accommodation; £3,900 | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2013-06-24-80ef1083-11715-0 |
21a7d8b44d4d6d0eccc154042292bd31478fa00f | Destination of visit: Rio de Janeiro, Brazil | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2013-06-24-80ef1083-11715-0 |
c4ca137998983f7964a2bb5f2528339dd488dd00 | Date of visit: 14-18 June 2012 | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2013-06-24-80ef1083-11715-0 |
33462af2e5528fd7d11382fbaff1ef9d6b9009c0 | Purpose of visit: to attend the first Summit of Legislators hosted by the Senate and Congress of Brazil and GLOBE International ahead of the Rio+20 conference. | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2013-06-24-80ef1083-11715-0 |
d14fe11dc0bd040985d7e2d1287a4a5193c17f8f | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2013-06-24-80ef1083-11715-0 |
9f41e890c98f7cf9b9c8fc127ecfecc3d2341918 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 7 | 2013-06-24-80ef1083-11715-0 |
026eb6124bf66efdd3c9fbff3342704510526a20 | Address of donor: The Secretariat, Falkland Islands Government, Stanley, Falkland Islands | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 8 | 2013-06-24-80ef1083-11715-0 |
927e0a0d668e321b61f70783978c87da87475413 | Amount of donation (or estimate of the probable value): Flights and accommodation with a value of £3,666.35 | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 9 | 2013-06-24-80ef1083-11715-0 |
9df8493310fed54fc22ae4336c84d90d02494434 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 10 | 2013-06-24-80ef1083-11715-0 |
9966838d7891e2878e4838d90043a73c33519cef | Date of visit: 7-14 November 2012 | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 11 | 2013-06-24-80ef1083-11715-0 |
f65ea264ad80a1ad73030f5618f608cf0825ab1e | Purpose of visit: visit at the invitation of the Falkland Islands Government to represent the Conservative Party at Remembrance Sunday. | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 12 | 2013-06-24-80ef1083-11715-0 |
8e31390ed7d167138fdc1c6d5281351b805ac7ba | (Registered 10 December 2012) | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 13 | 2013-06-24-80ef1083-11715-0 |
9f033157e5b05f0336a4526f081b2716a0ea8998 | Name of donor: Jamaica Tourist Board | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 14 | 2013-06-24-80ef1083-11715-0 |
9562daaa1e7b323a2342de5abd0ea7dbef3684dc | Address of donor: 1-2 Prince Consort road, London SW7 2BZ | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 15 | 2013-06-24-80ef1083-11715-0 |
e800455bac3304f1ceb718063fa87d784e51073f | Amount of donation (or estimate of the probable value): approximately £2,950 for air travel and accommodation | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 16 | 2013-06-24-80ef1083-11715-0 |
419d1d94a9c863da5831de014390dec3c139d0bd | Destination of visit: Kingston and St Elizabeth Parish, Jamaica | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 17 | 2013-06-24-80ef1083-11715-0 |
1863792b45c522e59db8048a2e656d2d0b9cf581 | Date of visit: 14-21 February 2013 | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 18 | 2013-06-24-80ef1083-11715-0 |
e51209a7d2e8fc19a01b77a570a88badfd2d425d | Purpose of visit: to officiate at the opening of the Lords and Commons Pavilion at the BREDS Foundation Community Project. Visit also included bilateral talks with the Jamaican Prime Minister and other ministers, school visits, cricket games and youth coaching. | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 19 | 2013-06-24-80ef1083-11715-0 |
a7afca6c43b7ec93a03b530cc3ab7f04fdf2fcc8 | (Registered 13 March 2013) | Overseas visits 80ef1083 | 2013-06-24 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 20 | 2013-06-24-80ef1083-11715-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");