items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2012-03-19-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 |
---|---|---|---|---|---|---|---|
95f54dd14f585f98b61845f453daed0f81eede10 | See also my entries under Category 2. | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-03-19-a41b9847-10068-0 |
5704d14e53fbd7fafaf80e8d17a6f58df6062bc7 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-03-19-a41b9847-10068-0 |
9b7815441a6debfcea2b2b725175921509650c81 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-03-19-a41b9847-10068-0 |
d4a8fb17ee19a860da795bc9a401065ac3c68de1 | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-03-19-a41b9847-10068-0 |
a0f9c99b4725a9084bfb36dc3bbba9d81184091a | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-03-19-a41b9847-10068-0 |
2a5445e475799cc59235fbdb551e35b07aa2ef0b | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-03-19-a41b9847-10068-0 |
a1bebd5e77b5075101323c758379d76a835783f0 | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2012-03-19-a41b9847-10068-0 |
810cafd5a63270b2e340a22c1665d93311d507d9 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-03-19-a41b9847-10068-0 |
a3a4635b38969dbec00a28998ab70ddaff6d4a5d | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-03-19-a41b9847-10068-0 |
acf25cdb88db2997ab3a303c350e6a75363a608b | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2012-03-19-a41b9847-10068-0 |
668e49de77a122d331053b7965e4223523ea16be | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-03-19-a41b9847-10068-0 |
eb67a1025bc5919e9464bdeea11343064d14f78e | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-03-19-a41b9847-10068-0 |
108a0521f7968993eb843f04c6ab543dc39ece03 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2012-03-19-a41b9847-10068-0 |
2937f1a310bf6b15d1247dfae47fe232e335e4d9 | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2012-03-19-a41b9847-10068-0 |
b722ad6cd4c12bccf5bf85f723d7155133fb5109 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2012-03-19-a41b9847-10068-0 |
a099c0e02984784b3e25ef3b0f1e913b9dbea339 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2012-03-19-a41b9847-10068-0 |
35d08f0ec87151eff36d06c5df263a4b57eb1430 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2012-03-19-a41b9847-10068-0 |
0a75ae0f3c53f3c1b4dbcee1f5aff7b14d2b00ae | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2012-03-19-a41b9847-10068-0 |
df34c37237e9bfbd730ed0d01e46d0cfa0fe2cbd | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2012-03-19-a41b9847-10068-0 |
82b4e30d59a393979ba1c40cd92e2392b5eeb144 | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2012-03-19-a41b9847-10068-0 |
0490529918eee10e894fb1449fc0defc22804356 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York , NY USA | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2012-03-19-a41b9847-10068-0 |
5ea4aa5fe67da86ef91d6f43edf2f02bb1a35f63 | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2012-03-19-a41b9847-10068-0 |
cb36c759ee696f32dc8e25eeb0507d7ebba2303e | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2012-03-19-a41b9847-10068-0 |
1f1963d8ac629794b6c9e563bc69b349daa67985 | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2012-03-19-a41b9847-10068-0 |
02587f3cc71526318aa8b8ebf88175c09fb683b6 | Address of donor: 60B Orchard Rd , #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2012-03-19-a41b9847-10068-0 |
c14d3fe76d6f537f5fbc5ea89e357c15e8c4fd67 | 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-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2012-03-19-a41b9847-10068-0 |
9d11c4721e1bff11b5b37f2b2d6931cacf6d40ca | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2012-03-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2012-03-19-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");