items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
44 rows where category_id = "a41b9847" and "date" is on date 2013-05-07 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: member_id, person_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
87b6d3d4ba8666275f4c8d681652eba15392444d | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2013-05-07-a41b9847-10001-0 |
c3c5562a2c44c50a2fcb301430edd0a8fe9872dd | Name of donor: Cartan Tours Inc, | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2013-05-07-a41b9847-10001-0 |
9b26c458aca3352e461a180f5ce7e9129037b73c | Address of donor : 1334 Parkview Ave Suite 200, Manhattan Beach CA 90266. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2013-05-07-a41b9847-10001-0 |
1eac938d7a11b720b7aa3a5a7f2fb6c1ee4207dd | Amount of donation or nature and value if donation in kind: two tickets for Olympics athletics event on 5 August 2012; total value £840 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2013-05-07-a41b9847-10001-0 |
d87b710b3bbdc651b1c6c25243aca62780ee8ab2 | Date of receipt of donation: 28 July 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2013-05-07-a41b9847-10001-0 |
44f0e9d4780234fb2f761e19886b8fbd6e7c7d74 | Date of acceptance of donation: 28 July 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2013-05-07-a41b9847-10001-0 |
354c1c7d1cc3e090762450c71f474b981eb8f92f | Donor status: company registered in US | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2013-05-07-a41b9847-10001-0 |
aea21612141b875e7f302a52c7e37a38ac675f51 | (Registered 16 August; updated 10 September 2012) | Overseas benefits and gifts a41b9847 | 2013-05-07 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2013-05-07-a41b9847-10001-0 |
c487c4f5746f2be664c9ac0c36517c422831268c | Name of donor: Jan Henrik Jebsen | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 0 | 2013-05-07-a41b9847-24786-0 |
031bd772e6d8835ef8352ee05cb80654a55affcd | Address of donor: private | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 1 | 2013-05-07-a41b9847-24786-0 |
95afda3dacf62a47302d0444c30beb31e4f61758 | Amount of donation or nature and value if donation in kind: two tickets to attend the Royal British Legion Poppy Ball on 8 November 2012 at £500 each | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 2 | 2013-05-07-a41b9847-24786-0 |
a8922dd73bef5325d7114347fbf57d1a4be7ca04 | Date of receipt of donation: 8 November 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 3 | 2013-05-07-a41b9847-24786-0 |
e53a1cd78b8377926b80d7191d781c9700d6aa08 | Date of acceptance of donation: 8 November 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 4 | 2013-05-07-a41b9847-24786-0 |
c215fc1a8e2964fa5d83552c89b5023ade3bf8bc | Donor status: individual | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 5 | 2013-05-07-a41b9847-24786-0 |
821ddc16cebfad5ca3585180e35e900044d9a097 | (Registered 14 November 2012) | Overseas benefits and gifts a41b9847 | 2013-05-07 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 6 | 2013-05-07-a41b9847-24786-0 |
30595ba865ef553da954f995503f7a56e2bd9b1a | See also my entries under Category 2. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2013-05-07-a41b9847-10068-0 |
e24ef3951535fccd8feaa804a1d65775c5fa74fd | See my entry under Category 2 above. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Geoffrey Cox uk.org.publicwhip/member/40613 | Geoffrey Cox uk.org.publicwhip/person/11541 | 0 | 2013-05-07-a41b9847-11541-0 |
822b2c142bf75df2ff01dcdce0438ce7308373c5 | See my entry under Category 2 above. | Overseas benefits and gifts a41b9847 | 2013-05-07 | George Galloway uk.org.publicwhip/member/40690 | George Galloway uk.org.publicwhip/person/10218 | 0 | 2013-05-07-a41b9847-10218-0 |
a2c98cf7781d60f9cb2b5c244a26af7fe51137f7 | See Category 2 above. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 0 | 2013-05-07-a41b9847-11858-0 |
15c218f3a667f7a23243da8558ae6edc90f93778 | Name of donor: The Coca-Cola Company | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 0 | 2013-05-07-a41b9847-24841-0 |
c69977487e4bb44af36b8645d0fd909bdc9c4212 | Address of donor: One Coca-Cola Plaza NW, Atlanta, Georgia 30313, USA. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 1 | 2013-05-07-a41b9847-24841-0 |
c68a7ba8da136b55499cd8e2278e12ebe57d2beb | Amount of donation or nature and value if donation in kind: Tickets and hospitality for myself and three members of my family for the London Olympics, for four events and the Olympic Closing Ceremony value £11,750 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 2 | 2013-05-07-a41b9847-24841-0 |
7edeb99b12291472761359f414073b37c1940688 | Date of receipt of donation: 12 August 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 3 | 2013-05-07-a41b9847-24841-0 |
9df95ad9972920b94626d5ecf12e8a9de06700cd | Date of acceptance of donation: 12 August 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 4 | 2013-05-07-a41b9847-24841-0 |
d4aa62d9bea0e749066630ccc433eb98da974376 | Donor status: Company, registered in the USA | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 5 | 2013-05-07-a41b9847-24841-0 |
06562d31ab6d159c09d33ffa388ba6d852770147 | (Registered 22 August 2012) | Overseas benefits and gifts a41b9847 | 2013-05-07 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 6 | 2013-05-07-a41b9847-24841-0 |
7281266527d084de153bb70004fb1603e8ba4fe6 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Kwasi Kwarteng uk.org.publicwhip/member/40567 | Kwasi Kwarteng uk.org.publicwhip/person/24770 | 0 | 2013-05-07-a41b9847-24770-0 |
1512a9048376cfa7e7194dc3fb4f772c5b4dfe48 | Name of donor: Barcelona Football Club | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 0 | 2013-05-07-a41b9847-12004-0 |
41656a30549e2782851466f7d5f2081700f36024 | Address of donor : Camp Nou, Barcelona, Spain | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 1 | 2013-05-07-a41b9847-12004-0 |
41efacdee24bf86b0890e9036492aff1ad5ba9ea | Amount of donation or nature and value if donation in kind: tickets and hospitality for Barcelona v Celtic football match in Barcelona and Celtic v Barcelona football match in Glasgow; estimated value £700 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 2 | 2013-05-07-a41b9847-12004-0 |
a1c78bbc47c750bbc21e200a4043d29f0d03f091 | Date of receipt of donation: 23 October 2012 and 7 November 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 3 | 2013-05-07-a41b9847-12004-0 |
1a4130abe31900eb13993ed6eebe1be6db994fd5 | Date of acceptance of donation: 23 October 2012 and 7 November 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 4 | 2013-05-07-a41b9847-12004-0 |
ffa2992b629c414d4a96e074dab5596ef2209a1b | Donor status: unincorporated association | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 5 | 2013-05-07-a41b9847-12004-0 |
7720a89de952cc14967c4a437ce1881d5e522092 | (Registered 12 December 2012) | Overseas benefits and gifts a41b9847 | 2013-05-07 | Angus MacNeil uk.org.publicwhip/member/40413 | Angus MacNeil uk.org.publicwhip/person/12004 | 6 | 2013-05-07-a41b9847-12004-0 |
7b98e1ad92572e5b8119dac7c0ab30941c1835b3 | Name of donor: Sultan of Brunei | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 0 | 2013-05-07-a41b9847-11545-0 |
f67830ef2efa01abd003aba522536d8ec4d8d9e1 | Address of donor : c/o Brunei Darussalam High commission, 19-10 Belgrave Square, London SW1X 8PG | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 1 | 2013-05-07-a41b9847-11545-0 |
f47ff4bfe77e7c438f10bd75132f1ee769384c94 | Amount of donation or nature and value if donation in kind: Harrods Christmas hamper valued at over £660; donated to charity | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 2 | 2013-05-07-a41b9847-11545-0 |
44e88e4804f978e31a92e2971b10e4f290a60f43 | Date of receipt of donation: 20 December 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 3 | 2013-05-07-a41b9847-11545-0 |
d5b6a77f2a55ef6828460b51bacd5601fae4d735 | Date of acceptance of donation: 20 December 2012 | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 4 | 2013-05-07-a41b9847-11545-0 |
de6646a7f507bddb6cef7a42e6c7b3b2c464c977 | Donor status: individual | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 5 | 2013-05-07-a41b9847-11545-0 |
47c4bac239f22b6c5f3fe37875a0a2ec12e49691 | (Registered 29 January 2013) | Overseas benefits and gifts a41b9847 | 2013-05-07 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 6 | 2013-05-07-a41b9847-11545-0 |
e3a5e3e00a43d7d520c59d14916e69207667685f | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Jesse Norman uk.org.publicwhip/member/40312 | Jesse Norman uk.org.publicwhip/person/24827 | 0 | 2013-05-07-a41b9847-24827-0 |
9a1902c432ba0f270a17798ac47e0f4e3479d702 | See payment in Category 2 above. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Priti Patel uk.org.publicwhip/member/40664 | Priti Patel uk.org.publicwhip/person/24778 | 0 | 2013-05-07-a41b9847-24778-0 |
0e3d175f6279057cb9e4e971791d6d013c74c177 | See payments listed under Category 2. | Overseas benefits and gifts a41b9847 | 2013-05-07 | Stephen Phillips uk.org.publicwhip/member/40535 | Stephen Phillips uk.org.publicwhip/person/24836 | 0 | 2013-05-07-a41b9847-24836-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");