items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2011-10-31-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 |
---|---|---|---|---|---|---|---|
ef79fe822bdd385d019ea07adc7daf0229dbb160 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-10-31-a41b9847-10068-0 |
de6e5b7010bf61c658ec19b7aadac48840e6be2e | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-10-31-a41b9847-10068-0 |
c032cb7fe06f1619e509674957429ba30994bb38 | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-10-31-a41b9847-10068-0 |
71844827883e8c1a070fcbf94886196875ac8041 | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-10-31-a41b9847-10068-0 |
332228234cb9f4e0e85f72b2d77727e94026e98e | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-10-31-a41b9847-10068-0 |
71ae03ad49ddd8a6533b63e67d7184278e7729ff | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2011-10-31-a41b9847-10068-0 |
a865ec4d970ea9500c47fceee2fb877eaf38a635 | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-10-31-a41b9847-10068-0 |
414de35766cceb127f9ae11c963553fee7a8317c | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-10-31-a41b9847-10068-0 |
27d3d5a754b21bc5a90502da99003fce9e62785a | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-10-31-a41b9847-10068-0 |
ad118eb3f4aee584f4074ff69e4bf5f66e557cb8 | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-10-31-a41b9847-10068-0 |
5802953a3bc5d0961b0b89724ccf8e8bca3bcdc8 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-10-31-a41b9847-10068-0 |
be5c480238352b1f7c8dc0f67a2131f0a2112cfa | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-10-31-a41b9847-10068-0 |
6c1aed27144d58cbc6724960f96b5f258dc292fe | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2011-10-31-a41b9847-10068-0 |
c42350fd52aa44b770c6ddc3e4062306335c3ada | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-10-31-a41b9847-10068-0 |
8355ee9d21ac3e1c99a3c17040b36a35e0183791 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-10-31-a41b9847-10068-0 |
5ea18374c6c2058dbf76f1b75e942d4f030fbb2f | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-10-31-a41b9847-10068-0 |
b9a276df5ffebf6d0d629e9764f66d8e3917e7fd | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-10-31-a41b9847-10068-0 |
6c9587f9552152bc0234e7964a33d8786a6265d3 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-10-31-a41b9847-10068-0 |
f84c78bff525d598b2241e24c0b3e0b811084694 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-10-31-a41b9847-10068-0 |
3fd125cb73ff92cb6c55e16fd6f33443b63ea56f | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-10-31-a41b9847-10068-0 |
28eafadba3822f67dfe226bdacee5d26fc2da5f3 | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-10-31-a41b9847-10068-0 |
cd1a9c0165047a8f745c6e83c5c1140e6c084258 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-10-31-a41b9847-10068-0 |
391f0dc5c35ef467e913b202dda1fdf10d9815f9 | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-10-31-a41b9847-10068-0 |
81c104862a77b393708d206bfbe080eb3bfed7c8 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York , NY USA | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-10-31-a41b9847-10068-0 |
f22d0572c1531f5acad7340bcd21ff73ffa7911a | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-10-31-a41b9847-10068-0 |
fa74479dbce3c4b4b5801c710ae63cf3a44008b1 | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2011-10-31-a41b9847-10068-0 |
ab1428ebc680e6872b1db83fa7c5d6a49b36126c | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2011-10-31-a41b9847-10068-0 |
c02c6da45731df18f04daa00e605aaa42f616544 | Address of donor: 60B Orchard Rd , #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 28 | 2011-10-31-a41b9847-10068-0 |
3ef3b3307a39351bc6751e948be61d555587af6c | 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-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 29 | 2011-10-31-a41b9847-10068-0 |
8c22ff05cb60697fda3cffb553a9fd67ab081981 | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2011-10-31 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 30 | 2011-10-31-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");