items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2011-08-30-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 |
---|---|---|---|---|---|---|---|
a7126d7aed02ceaf1c1f2ecb0954abb1ceb63978 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-08-30-a41b9847-10068-0 |
61565c671df460d1929717913f1f5c474223bdda | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-08-30-a41b9847-10068-0 |
feffe95a62ca1ecc3e33d68e2c183587dd4f05c3 | 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-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-08-30-a41b9847-10068-0 |
305112cd92c5770f1eb984d9cc1fb83a35816eaa | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-08-30-a41b9847-10068-0 |
035261d9a7adda47a43fc9e8c49d3e43b5a04d30 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-08-30-a41b9847-10068-0 |
95a18d90f3a11e4ae16916a676bd7dff053e6a16 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2011-08-30-a41b9847-10068-0 |
44f8d207526a13470fe86d6383795430c66771ad | 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-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-08-30-a41b9847-10068-0 |
186aff857eafec98fe696d19b7ab7ac6b3c72dea | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-08-30-a41b9847-10068-0 |
6684940c3de729d2f0a3d730212b49615778644b | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-08-30-a41b9847-10068-0 |
94751f40fa8d652cddd452b8926883546c9e70ff | 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-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-08-30-a41b9847-10068-0 |
93b9221d1f7905f988732a65d0f9b22791c78ab0 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-08-30-a41b9847-10068-0 |
2eccaf6554fbcf14582f109172bbd56b815255d0 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-08-30-a41b9847-10068-0 |
cd1ed33d34cdbe34935e5230c45faa561898b005 | 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-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2011-08-30-a41b9847-10068-0 |
7fc64edcaa6a9f0364ed37f1563100f00070f3e4 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-08-30-a41b9847-10068-0 |
1cc601cf0e78236d77009c9a6400e11036c2aebe | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-08-30-a41b9847-10068-0 |
7e0287199a84c1934b820815bbaf5e4cae329eb4 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-08-30-a41b9847-10068-0 |
ad7c4a7488599303be42071237eacf653ffa2e98 | 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-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-08-30-a41b9847-10068-0 |
f0ba82fc4d1cd8177eff496ad7269c9e6c8fbd47 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-08-30-a41b9847-10068-0 |
ef21892f7c0c9e66567cca2b050cb2cd08d1a8d6 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-08-30-a41b9847-10068-0 |
f72942cbd2db5fc668f6fe299059d28d596d322d | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-08-30-a41b9847-10068-0 |
370530734c50f634c0882f5b2e84452b0f336458 | 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-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-08-30-a41b9847-10068-0 |
b1c93e1777df7f956a38c5a7c60f84a1ad98f774 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-08-30-a41b9847-10068-0 |
8c98c5e6ef5eb349cb1d09ccde8028b6b78ecb1e | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-08-30-a41b9847-10068-0 |
d35b40e4c8c7f0600113915503c3c96a3247246b | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York, NY USA | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-08-30-a41b9847-10068-0 |
1e692caef4d745e416751e019d195837658ce5c1 | Amount of donation (or estimate of the probable value): airfare paid to travel to Geneva to give keynote address to the High-level segment of the UNECOSOC on 4 July 2011, £666.20. (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-08-30 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-08-30-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");