items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2012-01-13-a41b9847-10068-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 |
---|---|---|---|---|---|---|---|
223be278347d013503503e0cdfb6f8b4b0620782 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-01-13-a41b9847-10068-0 |
46497e2ce5a00dd0f305569634ce663155d8df9f | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-01-13-a41b9847-10068-0 |
e5bf5068078b9645c02341898a1d8a7a0cf512f6 | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-01-13-a41b9847-10068-0 |
6b9739efbc49c53b9e3f8c7d39c99e75e06101c7 | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-01-13-a41b9847-10068-0 |
18a9e0a311a35094c2b83c4b4fec98715c8604e0 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-01-13-a41b9847-10068-0 |
d8febe137256dd4c9741295bb0ecdbe4f7d8633e | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-01-13-a41b9847-10068-0 |
85ce90b19d0a06b9ad3897d6b0f274ab78b70a0a | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2012-01-13-a41b9847-10068-0 |
5bfc36fdda23b3f0f2d3028fa0bd7a4950fbd014 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2012-01-13-a41b9847-10068-0 |
1f40b950435a6b74e363e64698b967c0c35f4069 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-01-13-a41b9847-10068-0 |
515b8b97bf3004c3b45d6260b92832c84a6b792b | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-01-13-a41b9847-10068-0 |
4dc5cb30085cea1abffd6e25251cce1a1d03b392 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-01-13-a41b9847-10068-0 |
f083be7a940ecf8bbbe11328d706c5242def9048 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-01-13-a41b9847-10068-0 |
25d364e57400516d67749d8b66b3d693a67e0164 | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2012-01-13-a41b9847-10068-0 |
37622b23c63b78ee8aa6aea5419bec11e71e28b6 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2012-01-13-a41b9847-10068-0 |
a550825aad1d9743939c6c3214a91d7724204544 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2012-01-13-a41b9847-10068-0 |
49d550ab1059388dd1ee8292fbe44ac67f07cd9a | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2012-01-13-a41b9847-10068-0 |
51acff862e003a947565a0f5ac4e8de255c718df | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2012-01-13-a41b9847-10068-0 |
11e35dfe1c367aa819a71099d3f28ddc3bf5b0e1 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2012-01-13-a41b9847-10068-0 |
73f69fd002beffaf234cd02b73c673e36297d434 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2012-01-13-a41b9847-10068-0 |
908d376bbf3be85fbbd65fac0ca2b726b18a5a89 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2012-01-13-a41b9847-10068-0 |
9064946ef532d5a4b0ece4042425dfb10e5b9a76 | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2012-01-13-a41b9847-10068-0 |
0f31276103e10e100b2dcc1f98a1b11b0721d840 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2012-01-13-a41b9847-10068-0 |
6c68b35edd582b11533c0018cb4ff377b19f8c13 | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2012-01-13-a41b9847-10068-0 |
3e41a8303b9e0d45ba76b334bc2880532c777308 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York , NY USA | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2012-01-13-a41b9847-10068-0 |
91681831d86915139ccf6b6a647f62b071d4a361 | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2012-01-13-a41b9847-10068-0 |
11203085c14ae2a5e6fa8c459b11023686d84bdb | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2012-01-13-a41b9847-10068-0 |
7ba9f386ba069d1fc29bd22b1471cd3ebbec20f5 | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2012-01-13-a41b9847-10068-0 |
6931a8767df7b9b73f0044907197a9f7c592229f | Address of donor: 60B Orchard Rd , #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 28 | 2012-01-13-a41b9847-10068-0 |
6f465dc7e66fd18be22f67b4c92758702d225572 | 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 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 29 | 2012-01-13-a41b9847-10068-0 |
8b6a64181e15274b9473318a41ec3b5ecf4a9894 | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2012-01-13 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 30 | 2012-01-13-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");