items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2011-06-06-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 |
---|---|---|---|---|---|---|---|
3992abeac56d647c8980928f6770c5c46ff83984 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-06-06-a41b9847-10068-0 |
cc6ff480786a75ff7a8b59706055d5f84d91e4a5 | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-06-06-a41b9847-10068-0 |
aea05b11b75f1fb0ad82ca1ca3b16603bce4f4da | 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-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-06-06-a41b9847-10068-0 |
fd4d92172000f0b61e792d72e9b22eac5978f55e | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-06-06-a41b9847-10068-0 |
6751da55858bd5d67ce6777d3bd183c26decf503 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-06-06-a41b9847-10068-0 |
0ca85cb65463cb2b055475b6b50b8b498cc880de | Amount of donation (or estimate of the probable value): airfare and accommodation paid for me and a member of my staff, provided in my capacity as a Visiting Fellow at Harvard University; value £9,011.49 (Registered 4 November 2010; updated 20 January 2011) | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-06-06-a41b9847-10068-0 |
2452073702041e32a639859e6924f4fe798d72dd | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-06-06-a41b9847-10068-0 |
d9318c9275175399b472e2aa24dc1642b8868ce5 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-06-06-a41b9847-10068-0 |
069d774a132ab96551ac07a167108557a3ff9aa1 | 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-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-06-06-a41b9847-10068-0 |
ef1c8b8d3a23b1453d0189557f0740d6a8c7ede0 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2011-06-06-a41b9847-10068-0 |
0fd40ac6093a9da93292180e8b18cb59d893afa6 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-06-06-a41b9847-10068-0 |
991e18393590403ea6520dd550a90ebeb2f19cd6 | 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-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-06-06-a41b9847-10068-0 |
61289007d5a4d08cfed96d834b3e5f579846feba | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-06-06-a41b9847-10068-0 |
fc90e1b42aae3e5ff01ca8d8adef5a249e131b9b | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-06-06-a41b9847-10068-0 |
b08e13c0cdd65b3596498d4878aa4720a482b818 | 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-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-06-06-a41b9847-10068-0 |
4f7267072e9586eeeba442b511818dd2af09f323 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-06-06-a41b9847-10068-0 |
726991cdd179b7ffd96c1e6e15310080a5643822 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-06-06-a41b9847-10068-0 |
f3871ed0d99dead07d1a38be025a7b416cec8345 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-06-06-a41b9847-10068-0 |
dc43c0afd8cb821d0aa136653bb1fe3bc59db830 | 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 | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-06-06-a41b9847-10068-0 |
675677e34c7c3665dbf2c0ea1b99d1768665f3f9 | (Registered 26 April 2011) | Overseas benefits and gifts a41b9847 | 2011-06-06 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-06-06-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");