items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2011-07-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 |
---|---|---|---|---|---|---|---|
568142382174cc8d93c18b5ccfc890f1b19d6267 | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-07-19-a41b9847-10068-0 |
4121fb46d313b62df64e94bdf200408fc06bc409 | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-07-19-a41b9847-10068-0 |
b6f7765d040988d0dfc8a1b733338b800875e4d4 | 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-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-07-19-a41b9847-10068-0 |
8b5664c23d4a14cd985f94ef79834e6fc0f22c50 | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-07-19-a41b9847-10068-0 |
98f1d674cb37e5cb1c2e960203a9ff9a9b0cb8a5 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-07-19-a41b9847-10068-0 |
577567430c0d4f2938629704ea87d874d2eea882 | 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-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-07-19-a41b9847-10068-0 |
eeb7442ec8e06735b798f6fae4dc51338631caef | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-07-19-a41b9847-10068-0 |
c21cd51fc81544f9a97daae8ce9cac1f338995ce | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-07-19-a41b9847-10068-0 |
75a86b0580321ced9b20115a003446d3f5cb03f8 | 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-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-07-19-a41b9847-10068-0 |
37896a7f5128f730ad13b3ddab363a1af59b5875 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2011-07-19-a41b9847-10068-0 |
5cec68fc33173a0235850b66ab90429112a159f5 | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-07-19-a41b9847-10068-0 |
9fb7015603589b807b9611015fcdce7cf62efd35 | 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-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-07-19-a41b9847-10068-0 |
bc54d4b480db44e18c5dcd49d16cf818b44ecda3 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-07-19-a41b9847-10068-0 |
bde369fa3c0ff5f0e250d705a07559ca72d15922 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-07-19-a41b9847-10068-0 |
afa37faa42ac89b89b573b46eaec88f93198e1e1 | 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-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-07-19-a41b9847-10068-0 |
22aad866fd65e6ec9002e92b12f7ebcefad4d476 | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-07-19-a41b9847-10068-0 |
6ffd1518c93d0c8f469547e2cce3cc444d2105c7 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-07-19-a41b9847-10068-0 |
ba06f887fbdd3acee68cdae15d8e17840dcc4fdb | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-07-19-a41b9847-10068-0 |
de102426953daec39a38ada7734b4b51cdab07d0 | 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 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-07-19-a41b9847-10068-0 |
76a7174996284aeaba0992c8fd82f835c97b4bf2 | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-07-19-a41b9847-10068-0 |
d5b9e4fccdbfaec9c7b9f33878b0516c19d32f07 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-07-19-a41b9847-10068-0 |
c053455091cdf5e9e7a0f7354192a98237a03388 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-07-19-a41b9847-10068-0 |
18e6bd450288ff0bc0f1bc21b09cdd63ae604c54 | 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-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-07-19-a41b9847-10068-0 |
6cd6727e5e4d4561842cd562216d07d6073b9cee | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-07-19-a41b9847-10068-0 |
362839753e28b24998819c26ef4c5a30b86c87ea | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2011-07-19-a41b9847-10068-0 |
dd2ea4a23a76b0ca3009c0f4d3f5f6d4f9fd339d | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York, NY USA | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 27 | 2011-07-19-a41b9847-10068-0 |
b5ecadabe0fa42afc560ca43e40505e348f381b3 | Amount of donation (or estimate of the probable value): airfare paid to travel to Geneva to give keynote address to the High-level segment of the UNECOSOC on 4 July 2011, £666.20. (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-07-19 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 28 | 2011-07-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");