items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2011-09-28-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 |
---|---|---|---|---|---|---|---|
dabe539f032dc7626a087b27443999c04de0cf4c | Name of donor: Kenya Airways | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2011-09-28-a41b9847-10068-0 |
81c1b78e26746e94f93c9dfc443407bacb98eccf | Address of donor: Airport Road, Embakasi, PO Box 19002-00501, Nairobi, Kenya | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2011-09-28-a41b9847-10068-0 |
a62cad84521fbc88eea0f33fed4ecbe6ffeae1af | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2011-09-28-a41b9847-10068-0 |
298a8917251944c1a92c8492f142d1b752b6d7dd | (Registered 1 September 2010) | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2011-09-28-a41b9847-10068-0 |
355d6c38c42ce91abd90c81b8cd39237cd617432 | Name of donor: Harvard University | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2011-09-28-a41b9847-10068-0 |
1c52567fcaa12a761a96c9f51731b1981f7388d6 | Address of donor: Massachusetts Hall, Cambridge, MA 02138, USA | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2011-09-28-a41b9847-10068-0 |
84c8d3514421a3808f2c45feb129a469ad3145b0 | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2011-09-28-a41b9847-10068-0 |
b65c1f17fb1d1cba6ffd78ed4b2d6e20be3805c9 | Name of donor: World Economic Forum | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2011-09-28-a41b9847-10068-0 |
1bdb14bf34e5edf5f4d394899c16b9f154f8451f | Address of donor: Route de la Capite 91-93, 1223 Cologny/Geneva | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2011-09-28-a41b9847-10068-0 |
47f01535da77f58bc99d214db74701fc63731bd7 | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2011-09-28-a41b9847-10068-0 |
28bce119510c68030c78e1f32fd298262cf13963 | Name of donor: German Marshall Fund | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2011-09-28-a41b9847-10068-0 |
3a3c3c66237de526b3222f4d62c018920818ef17 | Address of donor: Rue de la Loi, 155 Wetstraat, 1040 Brussels, Belgium | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2011-09-28-a41b9847-10068-0 |
22448c224b99cf796a41dce6d3bff0615ed3c30f | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2011-09-28-a41b9847-10068-0 |
92d1549eb637ae5811fe5a8c942c63b0e761ab1c | (Registered 5 April 2011) | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2011-09-28-a41b9847-10068-0 |
f0f69e36938cace8f84d77e8e619138ca16c6243 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2011-09-28-a41b9847-10068-0 |
eecde73bedff50ae9f9b9ac5cba81df121e99a4c | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2011-09-28-a41b9847-10068-0 |
507e98d63957320623ff1694a119aa53925d8ca2 | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2011-09-28-a41b9847-10068-0 |
2a3e14d87148397d28f81d66b8ac99dca48e208c | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2011-09-28-a41b9847-10068-0 |
d60e390c13860654817bc9d9368484c9d3af07f0 | Name of donor: Georgetown University | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2011-09-28-a41b9847-10068-0 |
e7a50aade02ca0115314ea191559115e8f6cdb14 | Address of donor: 37th and O Streets, N.W., Washington DC 20057 | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 20 | 2011-09-28-a41b9847-10068-0 |
837162dfae96c12d010503dac9d8d17bda9eb4a4 | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2011-09-28-a41b9847-10068-0 |
1e9fd248191048389c1f1faba5b1759adc056394 | (Registered 14 June 2011) | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2011-09-28-a41b9847-10068-0 |
3cc84bd8b20e107da9c4a92559bd8d01e82c58c8 | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2011-09-28-a41b9847-10068-0 |
ebaee0545f1dd66066d4b98a7cfe4d013d3b552d | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York, NY USA | Overseas benefits and gifts a41b9847 | 2011-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2011-09-28-a41b9847-10068-0 |
95bec387f79ac4e0a232d3e2819234242cd626d2 | 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-09-28 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 25 | 2011-09-28-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");