items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2012-02-20-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 |
---|---|---|---|---|---|---|---|
73df00aaba8486027f0cd9357e03dc1ae7c207e2 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-02-20-a41b9847-10068-0 |
a6bda5fc35b60c2a2c549951084c902f2ba2cbea | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-02-20-a41b9847-10068-0 |
9fb426cdab3dbd05106eafa6eb3000caf7ffb363 | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-02-20-a41b9847-10068-0 |
636ccee0fdd826f07aace70b7ca72793206b0485 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-02-20-a41b9847-10068-0 |
2a4c631c2d12bdd50bdda7a065e32a7ff4196054 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-02-20-a41b9847-10068-0 |
6b70fba576589c602606503963ba8226ef32ad38 | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-02-20-a41b9847-10068-0 |
e1ff5e2c88843b892c83711debb5e1492d7b625f | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2012-02-20-a41b9847-10068-0 |
77df6bf9eef3ca7c08df3836f8ae88bb7f0da51e | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-02-20-a41b9847-10068-0 |
779bf768d7df15367cc84571eb4f4c9cfa8e15e3 | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-02-20-a41b9847-10068-0 |
4a7dce92d1fb2cc8b4218f5c6c6d97600c7fd30c | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2012-02-20-a41b9847-10068-0 |
b14a25e03c1b93e2d57c2519d76674f5f5690f95 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-02-20-a41b9847-10068-0 |
6cd4a1478943ff47ab96a034684d20e462b95462 | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-02-20-a41b9847-10068-0 |
caf9d8eb882e6531becb4dc3483f200914cb5ff6 | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2012-02-20-a41b9847-10068-0 |
35e18f8f99d9c95f70ec1a7d0bbb975112d50fd9 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2012-02-20-a41b9847-10068-0 |
30b68261d9ebe0bb871581b126c303790c15d279 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2012-02-20-a41b9847-10068-0 |
a0a81537951c215f917c7bc5aafa4369320245f2 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2012-02-20-a41b9847-10068-0 |
717732473df46ced583247ab80b5359a59c450dc | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2012-02-20-a41b9847-10068-0 |
f8291acf1e6121eb2569c5b84dce650eaf3ab4dc | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2012-02-20-a41b9847-10068-0 |
549f9d6d976998c24097ee3c783016cacab9b80f | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2012-02-20-a41b9847-10068-0 |
729e203732c2397686af955b189186d484ee391e | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York, NY USA | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2012-02-20-a41b9847-10068-0 |
3c963e65f6080908bbe7c9eef44f33ec629a2771 | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2012-02-20-a41b9847-10068-0 |
cd31f8e38a4516f5939edfd415935d372efdc0b4 | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2012-02-20-a41b9847-10068-0 |
9e824b0cb37ca144a7f2981e61b5b6735ef403d1 | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2012-02-20-a41b9847-10068-0 |
602ac1cf196592d406cb9df14d03ddc175a4ea3d | Address of donor: 60B Orchard Rd, #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2012-02-20-a41b9847-10068-0 |
4472ba83370e9c8e4212fb97c959daa72282ab02 | 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-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2012-02-20-a41b9847-10068-0 |
efcb8e16c3a8c5ce355332c9ff65d1cb68b06c00 | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2012-02-20 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2012-02-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");