items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2011-10-17-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 |
---|---|---|---|---|---|---|---|
76188be5e04d50f4c8d90f71e6b7e710978527f0 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-10-17-a41b9847-10068-0 |
455aef661f11cc6d5e319d9229002a29d0b1afeb | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-10-17-a41b9847-10068-0 |
8e1118c1dd4a5040b662632609baab6b02e829e8 | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-10-17-a41b9847-10068-0 |
92c9839138bc137bea9a0776b349262b66ad8cec | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-10-17-a41b9847-10068-0 |
aa1b02a83b483796dd44e9412be908017e4a28c4 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-10-17-a41b9847-10068-0 |
51f9f7123d6fb49eeda96ff6561704776e128802 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2011-10-17-a41b9847-10068-0 |
94476fdbc69ac87e8bd220537bb245948354e8c1 | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-10-17-a41b9847-10068-0 |
76f22261d7f09e5e979ae0ce09b6976747592baa | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-10-17-a41b9847-10068-0 |
a0be303d7d62293617fe49f9ca8a3b400398b3e7 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-10-17-a41b9847-10068-0 |
e8d80f5088e418afff05f7cabbd7db02eaccb3a1 | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-10-17-a41b9847-10068-0 |
3b72c0eabc0017855dccefef6c11d94a6ace6816 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-10-17-a41b9847-10068-0 |
d43303f6843f0896c9a5143f1fa9dab7bb278194 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-10-17-a41b9847-10068-0 |
02dd304cf8415a6901ea5fa63838c79c23e26ad0 | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2011-10-17-a41b9847-10068-0 |
fedb4ddec4871048d4b888fe9b4a6ecc59f484b9 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-10-17-a41b9847-10068-0 |
4f60c2bbf1126c30f6d3c433a27123e959f71095 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-10-17-a41b9847-10068-0 |
5a25f077cc347774b8a0037802e3099cc8fd2073 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-10-17-a41b9847-10068-0 |
e546b61614d30c852206a3bab0ea5f04ddceb31d | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-10-17-a41b9847-10068-0 |
c0e26a63d264737d6202d5f662f06ca9ffeef927 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-10-17-a41b9847-10068-0 |
d1c675118133dd28b1290f4ee62e1d81d748fa93 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-10-17-a41b9847-10068-0 |
b1996bf1774cd0fb34fe2f4fa2bcc18ab58f658d | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-10-17-a41b9847-10068-0 |
ee3b7efa57b933e6ca7ce76568892be6d3f787af | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-10-17-a41b9847-10068-0 |
ba1893b170fff75726a3a2040a1ff1ad8f5f4230 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-10-17-a41b9847-10068-0 |
a04d0c21a59d0c762bb915e60c96737dcc86e4fb | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-10-17-a41b9847-10068-0 |
721e88d3329e1d247917789b72d0e56f9a618893 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York, NY USA | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-10-17-a41b9847-10068-0 |
7665d15e0482b0a8524bef09a6c2425c2f09acac | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-10-17-a41b9847-10068-0 |
0e6b66bc836c8d178fbbb3cd92a7c1aa55e0f975 | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2011-10-17-a41b9847-10068-0 |
e0df41e6dd3e2f0023c67e9a8a339d4d48852008 | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2011-10-17-a41b9847-10068-0 |
cb13412f06523fd1a65f7c161a71b1aa20391006 | Address of donor: 60B Orchard Rd, #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 28 | 2011-10-17-a41b9847-10068-0 |
5cb9033467a7412ce15f3df98eaeb9192f850678 | 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-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 29 | 2011-10-17-a41b9847-10068-0 |
fea3d57569553bcef0bd6b6f9044d131ff7c4f1b | (Registered 1 0 October 2011) | Overseas benefits and gifts a41b9847 | 2011-10-17 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 30 | 2011-10-17-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");