items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where record_id = "2011-06-20-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 |
---|---|---|---|---|---|---|---|
2e7553af748f215e847cf4acd38950396611cfd3 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-06-20-a41b9847-10068-0 |
0d9350b12b10cfbf05125a08b30b6f2d218225c7 | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-06-20-a41b9847-10068-0 |
118c8f20039c527ca7bf7868d363af93d0c3edac | 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-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-06-20-a41b9847-10068-0 |
de5637f60103a60aec90d922a438ce999c5f67ac | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-06-20-a41b9847-10068-0 |
5e690b4e17dc3c1d33fd80c1f190a266307e3eaa | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-06-20-a41b9847-10068-0 |
f7c06eb7f0549e63a62fd445df2c1f6ec578e6b4 | 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-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-06-20-a41b9847-10068-0 |
a290d9890816fbaa64e00cc885b5cb8567f8e8a4 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-06-20-a41b9847-10068-0 |
40b9cfd644aa068e9eaa2881eb8a8d25ee90b562 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-06-20-a41b9847-10068-0 |
4c69f1d37cb9aeecb0e6c2d63b37d682ee02afc3 | 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-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-06-20-a41b9847-10068-0 |
70ed7f97dbe2608af63ecd6ab43280a7b37cbf23 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2011-06-20-a41b9847-10068-0 |
938fbd737ab9023532fba3a69436c11b62dd7f21 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-06-20-a41b9847-10068-0 |
0271efd204ed436d15dd64e0cf078010cf84288a | 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-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-06-20-a41b9847-10068-0 |
44f407670a95dbd5218e408a6dfd76be0045bc9b | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-06-20-a41b9847-10068-0 |
2f933eada6488e56ec78357f260893a7cbc11bf7 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-06-20-a41b9847-10068-0 |
be119b27f641f1624dcd41d7892b39232545cb75 | 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-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-06-20-a41b9847-10068-0 |
ac872ee2560a26e71f380af61702551763cb253a | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-06-20-a41b9847-10068-0 |
b31169ec6116331ecaeb10099077492a17d1de8c | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-06-20-a41b9847-10068-0 |
f97d09bc945b9a441f177113edf7ca077c014759 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-06-20-a41b9847-10068-0 |
abdbe012db224b64e76b85e43e2e2d629a654bc2 | 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-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-06-20-a41b9847-10068-0 |
ed031612d538b7450ce2cda8a9d46cdd21072535 | (Registered 26 April 2011) | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-06-20-a41b9847-10068-0 |
ff1d146da376f02010dcc0ff461a5185bc15ef3d | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-06-20-a41b9847-10068-0 |
513ab40a731759372deb991f72a50ddc8052b672 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-06-20-a41b9847-10068-0 |
b2c77f1fb46ad7c6fcc35a12abf618d6961baa4a | 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-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-06-20-a41b9847-10068-0 |
f92d776108116e22e55fb9db1ff8efa97990b07a | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-06-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-06-20-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");