items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2015-01-06-8f616a6e-24831-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 |
---|---|---|---|---|---|---|---|
e28e4af09c3476efa9e023bab76608c1beaa5f6e | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 0 | 2015-01-06-8f616a6e-24831-0 |
d6d0d5b5732de0339ff6f700b59259c0428ef48b | 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 | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 3 | 2015-01-06-8f616a6e-24831-0 |
9c90ec5d7cbe4c60465d2330b0bdba164f6b8c0a | (Registered 23 January 2014) | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 5 | 2015-01-06-8f616a6e-24831-0 |
d1ed9f711223c72d1c7daca3e8e0513529397735 | Name of donor: Communication Workers Union | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 6 | 2015-01-06-8f616a6e-24831-0 |
f34a49cf69dd00f19d2ac0d00ce355da1cc2efd9 | Address of donor: 150 The Broadway, Wimbledon, London SW19 1RX | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 7 | 2015-01-06-8f616a6e-24831-0 |
1553b0cf85c2781544da65b8892158fcc43383f6 | 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 | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 8 | 2015-01-06-8f616a6e-24831-0 |
3f25cd176a3318be3625460dd68b5598f007fcff | (Registered 21 July 2014) | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 10 | 2015-01-06-8f616a6e-24831-0 |
00c3bbc7c757c4399f881e25949cfcf9b5798a70 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 12 | 2015-01-06-8f616a6e-24831-0 |
73b6081a13c05cd55ec2b2853a0c7a4840f8f679 | Amount of donation or nature and value if donation in kind: £3,000 to Wigan Constituency Labour Party | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 13 | 2015-01-06-8f616a6e-24831-0 |
dd8e467dd73de2150c60d74e368da4eb6a21e336 | (Registered 21 July 2014, updated 30 July 2014) | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 15 | 2015-01-06-8f616a6e-24831-0 |
d719ebca20eb76171fa742465194df1a1d413ab6 | 5. Gifts, benefits and hospitality (UK) | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 16 | 2015-01-06-8f616a6e-24831-0 |
4326074d15eab8ad600eaf9103560725bd0317e7 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 17 | 2015-01-06-8f616a6e-24831-0 |
07e444c326a5ac810f12c827d114190db86c648a | Address of donor: 128 Theobald’s Road, Holborn, London WC1X 8TN | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 18 | 2015-01-06-8f616a6e-24831-0 |
8dde7520d97e21ee13f91ba399cf146154c630d2 | 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 | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 19 | 2015-01-06-8f616a6e-24831-0 |
2fd57dd7a3142b9142ed1e0c1b23af49d3366f56 | Date of receipt of donation: 20 September 2014 | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 20 | 2015-01-06-8f616a6e-24831-0 |
4a7e3b9f25285f63a8a965051d119acea5e513e1 | Date of acceptance of donation: 20 September 2014 | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 21 | 2015-01-06-8f616a6e-24831-0 |
665d989df81c162cc8512195996bb5024019d14d | Donor status: trade union | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 22 | 2015-01-06-8f616a6e-24831-0 |
163611d5818eca3d758d0b38f644ac8076d42c70 | (Registered 14 October 2014) | Sponsorships 8f616a6e | 2015-01-06 | Lisa Nandy uk.org.publicwhip/member/40658 | Lisa Nandy uk.org.publicwhip/person/24831 | 23 | 2015-01-06-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");