items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2012-04-16-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 |
---|---|---|---|---|---|---|---|
c0980d7104d18eb99d6cab1402735bc326e4bb78 | See also my entries under Category 2. | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-04-16-a41b9847-10068-0 |
fef9510ef3349b26077fc9ee5ab2055b670c2318 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-04-16-a41b9847-10068-0 |
b1af4c3757b8736855ef0ec57a7c2eac23d721c0 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-04-16-a41b9847-10068-0 |
04e100209c9ffd12d0d89cf6e32d14a95b291294 | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-04-16-a41b9847-10068-0 |
8bcdd13156acea7922b9ce6c6eaa3f6075866655 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-04-16-a41b9847-10068-0 |
17db693dda74d995dd80b880082bde6de3d633fb | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-04-16-a41b9847-10068-0 |
96cc3f730e44ac0b8644bebef22ece6989e002c6 | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2012-04-16-a41b9847-10068-0 |
574130df2f7506d1487fb32d3741044914177f4d | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-04-16-a41b9847-10068-0 |
a0883431b56bdfbfb6ab61dd91b6350796139cb7 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-04-16-a41b9847-10068-0 |
58751823b81bd88cdcb917c09cd1764710bbaa82 | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2012-04-16-a41b9847-10068-0 |
c80510a56f680213bd9046bc2ec67a7604e7e64b | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-04-16-a41b9847-10068-0 |
bbfab395d94c886ca148a5602b24dd18245c2f13 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-04-16-a41b9847-10068-0 |
62e99de85dc54c8b9d40dbf79daaacfb3c36095d | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2012-04-16-a41b9847-10068-0 |
5180314036c109481808571070f17b9d778c8cc6 | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2012-04-16-a41b9847-10068-0 |
26e68d8522e98e9fcd79a926ed170f7dbdd20d7a | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2012-04-16-a41b9847-10068-0 |
340de431964738a04d3c04df960e4bd7e8388a7d | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2012-04-16-a41b9847-10068-0 |
08b0a81450747a0bb2372508dbe511285c86e506 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2012-04-16-a41b9847-10068-0 |
39e915d2cd12bfaa371a86ad5c7bced727dc47e6 | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2012-04-16-a41b9847-10068-0 |
28cf6b29153905f1a455d13f63b6040261d40f91 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2012-04-16-a41b9847-10068-0 |
46e4e3fce19003107615fcfdce48f650096bb6bb | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2012-04-16-a41b9847-10068-0 |
ee45cb061aa84f11e6898a5ad86587016085a8c7 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York , NY USA | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2012-04-16-a41b9847-10068-0 |
5eba19e556be0cf89edc4cd62f1afee0c703cb4a | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2012-04-16-a41b9847-10068-0 |
eeb561efb82b06582c7534e563d165adedfeeebe | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2012-04-16-a41b9847-10068-0 |
5631e85fa1c2b80f241bf35bac8e5a3deb4a9d4e | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2012-04-16-a41b9847-10068-0 |
3b404717ed49253a3255aaa305b6d3d8a294d4b9 | Address of donor: 60B Orchard Rd , #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2012-04-16-a41b9847-10068-0 |
80d272d179aa289a95a9befebbd51a3a32d32585 | 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 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2012-04-16-a41b9847-10068-0 |
55f4a8dc5ee8c5ed10b19f77fe1fe43ed4a2ec6c | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2012-04-16 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2012-04-16-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");