items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2011-11-16-a41b9847-10068-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 |
---|---|---|---|---|---|---|---|
c9922966a194f5f3fc22808e4a379ba24ba38f96 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-11-16-a41b9847-10068-0 |
7360037d61587a5f9f3f5a48bb053d5e34aa187e | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-11-16-a41b9847-10068-0 |
833bd72b994d562b27a12760546b958fb01d4012 | Amount of donation (or estimate of the probable value): upgrade on flight to Uganda for me and a member of my staff in respect of travel to Uganda for a speech to African leaders; value £4936.20. | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-11-16-a41b9847-10068-0 |
1a3203bf750cf2c8dea79a10e5405daa7968bb3d | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-11-16-a41b9847-10068-0 |
81a83945ceb157e456335daa3a19f334586aa2d4 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-11-16-a41b9847-10068-0 |
13dbd70b918db6ff090ae6926a2782c48a3953db | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2011-11-16-a41b9847-10068-0 |
0616b2811c32f99b4f5354479ba14fad288c8f8a | Amount of donation (or estimate of the probable value): airfare and accommodation paid in respect of travel to US to speak at the Harvard University Global Empowerment Meeting; value £4,562.57. (Registered 20 January 2011) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-11-16-a41b9847-10068-0 |
02e28727f7e832a90fc41a0432185e075c8ed589 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-11-16-a41b9847-10068-0 |
42465a10a6872f214c584a59c4deb98d7aa0edbf | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-11-16-a41b9847-10068-0 |
0ba0733e6f5df32d51c829dcd9b592e1ba355819 | Amount of donation (or estimate of the probable value): airfare paid for me and a member of my staff to travel to the World Economic Forum, Geneva; value £1,375.97 | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-11-16-a41b9847-10068-0 |
62a38dfbf87c207092b86cdc89613239c62f7694 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-11-16-a41b9847-10068-0 |
ea7bd330059fa74448676ed20c1b0308ab193e14 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-11-16-a41b9847-10068-0 |
f94299df6856d79da6cc2e51191ae6f753b94d4b | Amount of donation (or estimate of the probable value): travel and transport paid to the Brussels Forum 2011; value £1,248.61 | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2011-11-16-a41b9847-10068-0 |
eb231b38d401041bf75bb2b1001f83442c2b8578 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-11-16-a41b9847-10068-0 |
79496aa829d00d98702a339e7b56ec3b1670019b | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-11-16-a41b9847-10068-0 |
a0955150c694a5a690175b26d97cc5dfea028316 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-11-16-a41b9847-10068-0 |
04f55b4a1444b2b5730301a867f52a41a374f18f | Amount of donation (or estimate of the probable value): airfare paid for my travel to the INET Forum in Bretton Woods, New Hampshire, USA; value £475.59; donation of £278.70 made direct to charity. | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-11-16-a41b9847-10068-0 |
87fed7fc4aa90484963f27f331cba40431bc399d | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-11-16-a41b9847-10068-0 |
73f9c8db3b279e23c0cf0f99df508f1650cd08a2 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-11-16-a41b9847-10068-0 |
c84ab5c0180745cf60277a85e4d4cf66660bb83c | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-11-16-a41b9847-10068-0 |
7acc570a46c184a47f62c26b9ff35595242dd749 | Amount of donation (or estimate of the probable value): airfare and accommodation paid for me and a member of my staff to travel to Washington, DC for speech at Georgetown University; value £3,079.29 | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-11-16-a41b9847-10068-0 |
ebcdb81b2c2cf9a517a7bc907e4138ce550ea1cc | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-11-16-a41b9847-10068-0 |
bdbadec0f15b7ef863401852d131296e1d2182b9 | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-11-16-a41b9847-10068-0 |
b960067ad81c363238f9d136b28e314cc8047451 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York, NY USA | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-11-16-a41b9847-10068-0 |
84044feae9e9234eb33d84dd0084004f2ac42d52 | Amount of donation: airfare paid to travel to Geneva to give keynote address to the High level segment of the UNECOSOC, £666.20 | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-11-16-a41b9847-10068-0 |
3574b1c0b735f486b4d4e9ee61f2a4d73d45ac0e | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2011-11-16-a41b9847-10068-0 |
abda190c4dbb83d97e4107d15b16beea5ec935f5 | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2011-11-16-a41b9847-10068-0 |
7a01d92a8f024c94f3b849eed6d4a9a3767e81a1 | Address of donor: 60B Orchard Rd, #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 28 | 2011-11-16-a41b9847-10068-0 |
c52adaf26b1dc4482121bdf634430b0c015551f3 | Amount of donation (or estimate of probable value) Airfare, accommodation and other travel paid to travel to Singapore on 26 September to address the Temasek International Panel, value £12,752.17. | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 29 | 2011-11-16-a41b9847-10068-0 |
9fe7fbe116ea5243ef9bd94df46344b8114a58ce | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2011-11-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 30 | 2011-11-16-a41b9847-10068-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");