items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2012-03-05-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 |
---|---|---|---|---|---|---|---|
8a2f580197dbce5cd523c857dbd202702aad0952 | See also my entries under Category 2. | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-03-05-a41b9847-10068-0 |
dee47d5d66316a4f07948cd775ca3e2a6f0ad7c8 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-03-05-a41b9847-10068-0 |
4a4377a23d7fec52a7ddf09c7e7727b3ace52e6a | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-03-05-a41b9847-10068-0 |
01a04d2dd47da29d9fff94201f5f4add13de8183 | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-03-05-a41b9847-10068-0 |
102c1c9064a8d074ccf597bf89b0f6f91d76a8c2 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-03-05-a41b9847-10068-0 |
cc10f1662cff7d2412c472a04a4c8ba614a34431 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-03-05-a41b9847-10068-0 |
0480296a1da71893c46a3bede8e4c11e8c305805 | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2012-03-05-a41b9847-10068-0 |
980c10f26e53373b639942d9a29b895c72ed3d20 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-03-05-a41b9847-10068-0 |
1e464b200be655614487f648b6933ebe6d893b1b | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-03-05-a41b9847-10068-0 |
75708359af673fee2e108a027be34733ca60f68d | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2012-03-05-a41b9847-10068-0 |
262dedc12a23ad05876b4387ad13de7b821646e2 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-03-05-a41b9847-10068-0 |
841e9ebd3dabb91fea8ef0482a0b04a1c490c2c0 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-03-05-a41b9847-10068-0 |
406da85bfc8ea1228fee1e9b1fca02a623797239 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2012-03-05-a41b9847-10068-0 |
542c1672000e92fa644483f751b94a1d64b9fab3 | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2012-03-05-a41b9847-10068-0 |
e1dda65c742a2610cea9cde5d937ef2fd6296424 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2012-03-05-a41b9847-10068-0 |
b0de3023039cac4b06021e656dac97940cf8e83a | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2012-03-05-a41b9847-10068-0 |
6d019042ca5d98ee6991538f12a114ab84f8beaf | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2012-03-05-a41b9847-10068-0 |
d3168db25d92839222370f20477781eccd8fca5c | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2012-03-05-a41b9847-10068-0 |
4ac717276d89f2bb64e59c19c38bbbdcf98c59a3 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2012-03-05-a41b9847-10068-0 |
537d73fdd1c3723375ccc50d91b722431430d991 | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2012-03-05-a41b9847-10068-0 |
674130d34e89014f1f962558aac94ef0121dd03c | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York , NY USA | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2012-03-05-a41b9847-10068-0 |
7ab40f81b55adab816b20de87869d3634b8b80ff | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2012-03-05-a41b9847-10068-0 |
b157d357c3a85f1b186a1bdbc2afe3a9ee525f43 | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2012-03-05-a41b9847-10068-0 |
7788a78518149cb996e208cd73b4ae9793bc79df | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2012-03-05-a41b9847-10068-0 |
d1cc111a21683486b556ec0aee72f4b1ef61e844 | Address of donor: 60B Orchard Rd , #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2012-03-05-a41b9847-10068-0 |
8a9a612ce2e1ab488ccc5dee166f1f668697bb4d | 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-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2012-03-05-a41b9847-10068-0 |
3ab8d92ee13c830d303c5f5a8c90832fb89d1124 | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2012-03-05 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2012-03-05-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");