items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2014-10-27-8f616a6e-24831-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
ccef96114b7eec51537172f737dea623d399ede8 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 0 | 2014-10-27-8f616a6e-24831-0 |
6c6f4a05bed75931a7e067a22187f1c33c6dc791 | Amount of donation or nature and value if donation in kind: £2,000 per year for 2 years, paid in monthly instalments of £166.67, to Wigan Constituency Labour Party, from 2 April 2012 to 2 April 2014 | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 3 | 2014-10-27-8f616a6e-24831-0 |
481be9ad4cfea3d0dfd93da5db342ba1a4e4b3fa | (Registered 23 January 2014) | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 5 | 2014-10-27-8f616a6e-24831-0 |
9d623366d1250ecb9b26acb56d3f7a7d7f89eb5d | Name of donor: Communication Workers Union | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 6 | 2014-10-27-8f616a6e-24831-0 |
fc50e9e1d0e5584c9b8cf275e263e51495e377e2 | Address of donor: 150 The Broadway, Wimbledon, London SW19 1RX | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 7 | 2014-10-27-8f616a6e-24831-0 |
faedd7f4d6880daed30eeb2a47bba1cb61ff2c07 | Amount of donation or nature and value if donation in kind: £2,000 per annum, paid in monthly instalments of £166.67, to Wigan Constituency Labour Party | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 8 | 2014-10-27-8f616a6e-24831-0 |
f510dc6ecf0b2b1fac9530837ffc320518e9a55d | (Registered 21 July 2014) | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 10 | 2014-10-27-8f616a6e-24831-0 |
95731ef18091262026919d59f76c9d9f683592b2 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 12 | 2014-10-27-8f616a6e-24831-0 |
61fb9191af17e5d809826e4755e8e40fb0a74f99 | Amount of donation or nature and value if donation in kind: £3,000 to Wigan Constituency Labour Party | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 13 | 2014-10-27-8f616a6e-24831-0 |
4cc36c3bdb3e97de3d89792974f8cdafad74682c | (Registered 21 July 2014, updated 30 July 2014) | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 15 | 2014-10-27-8f616a6e-24831-0 |
43f240d032169676bb4481b1fbc7431376ce6f56 | 5. Gifts, benefits and hospitality (UK) | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 16 | 2014-10-27-8f616a6e-24831-0 |
bae877b490ef460af27c3616f91f9347f4c3d607 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 17 | 2014-10-27-8f616a6e-24831-0 |
17ac4be0ccd120e68f5864cd3f7bd930b9744f3c | Address of donor: 128 Theobald’s Road, Holborn, London WC1X 8TN | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 18 | 2014-10-27-8f616a6e-24831-0 |
29780c7277390be393ec7a508e62390eb5591827 | Amount of donation or nature and value if donation in kind: 5 nights hotel accommodation during the Labour Party Conference, total £1,575 | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 19 | 2014-10-27-8f616a6e-24831-0 |
15a6ad269d44e0431a652dc84ae25c372a4c66dd | Date of receipt of donation: 20 September 2014 | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 20 | 2014-10-27-8f616a6e-24831-0 |
5d713219bd2def4ff813ffbea45613a98725c7bf | Date of acceptance of donation: 20 September 2014 | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 21 | 2014-10-27-8f616a6e-24831-0 |
578fff57d37e1f1d6626ef77ac0932145d48684b | Donor status: trade union | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 22 | 2014-10-27-8f616a6e-24831-0 |
e7c143601e48b5e4ef80e0b22983806beb3c2742 | (Registered 14 October 2014) | Sponsorships 8f616a6e | 2014-10-27 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 23 | 2014-10-27-8f616a6e-24831-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");