items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2012-07-09-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 |
---|---|---|---|---|---|---|---|
595af6e86bf1ffa948953fa0cb3b5174b0c3f57b | See also my entries under Category 2. | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-07-09-a41b9847-10068-0 |
89de3d3115de4f64346f30a65c19a57386332172 | Name of donor: Institute of New Economic thinking | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-07-09-a41b9847-10068-0 |
40adc3684b407bb12988cdc74366d5582f256a0d | Address of donor: 570 Lexington Avenue, 39th Floor, New York, NY 1022 | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-07-09-a41b9847-10068-0 |
fc14cb8c956a4dcd573e48d0e11ba694bfde8d2a | 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-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-07-09-a41b9847-10068-0 |
9466659cce109a96d0ef5dcd87061b42486295ba | (Registered 26 April 2011; updated 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-07-09-a41b9847-10068-0 |
085a7171ee2bdec7df6a7512f361b861d91135cc | Name of donor: United Nations Economic and Social Council | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-07-09-a41b9847-10068-0 |
7b7ea859ddf0f38ac1d8a57b0a348ed7299dfb37 | Address of donor: ECOSOC Secretariat, 1 UN Plaza, New York , NY USA | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2012-07-09-a41b9847-10068-0 |
0e0f92aec19bf863be8ebb072362eaf3ed10fcc8 | 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-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2012-07-09-a41b9847-10068-0 |
094a6b9e3efd4f02fb5879f282880192d9559102 | (Registered 14 July 2011) | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-07-09-a41b9847-10068-0 |
70881a211f0addb3e4962944cbde3bc1a56f0cb5 | Name of donor: Temasek Holdings | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-07-09-a41b9847-10068-0 |
2c216a572b476d9b24094b0680b73c96d5f3823c | Address of donor: 60B Orchard Rd , #06-18 Tower 2, the Atrium@Orchard, Singapore 238891. | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2012-07-09-a41b9847-10068-0 |
0099ca0472887b0f59d7f10eb714ebce48f31b1e | 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-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-07-09-a41b9847-10068-0 |
3d7ee21dca2905040f42dc0b06644b7f42c0ffc0 | (Registered 10 October 2011) | Overseas benefits and gifts a41b9847 | 2012-07-09 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-07-09-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");