items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2011-05-16-8f616a6e-10383-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 |
---|---|---|---|---|---|---|---|
dd5299d147b3fdeba6c6e6baa7f975666e387d7b | (a) Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2011-05-16-8f616a6e-10383-0 |
6a2c85ac1a0a8edcdf6d073de4f1b78b63d5859c | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-05-16-8f616a6e-10383-0 |
fdb0f1131f5789863ddf17c229ea770803e20f58 | Address of donor: 60-62 Clapham Road London SW9 0JJ | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2011-05-16-8f616a6e-10383-0 |
bd6fb893fce9a566988aecbd5637e11252d1e4e8 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-05-16-8f616a6e-10383-0 |
eb006562fa7c010bda7bdba73877b8e618522a01 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-05-16-8f616a6e-10383-0 |
e4eaf88a554abaffd5af46b1fa1785bc197ea982 | Amount of donation or nature and value if donation in kind: £5000 | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 8 | 2011-05-16-8f616a6e-10383-0 |
af0d601edc4774e97f2725c377f718888145e20f | Name of donor: National Union of Rail, Maritime and Transport Workers (one donation from national union, and one from Paddington branch and one from Feltham Branch) | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 11 | 2011-05-16-8f616a6e-10383-0 |
78eca022e2b68ae6d32245fdf9edb017a85da001 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-05-16-8f616a6e-10383-0 |
31c525e98e78ec6f24dcb7f9017b8dd2ef7dc033 | Amount of donation or nature and value if donation in kind: £5,000 in total | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 13 | 2011-05-16-8f616a6e-10383-0 |
1029066b928ce9d351ddcbd00d82c6f347896cc0 | Donor status: trade union | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 14 | 2011-05-16-8f616a6e-10383-0 |
3786a8c2668304efed2a8cf432dc270e6442a5b5 | Name of donor: Labour Representation Committee | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 16 | 2011-05-16-8f616a6e-10383-0 |
3897193b16d955aedf44c4a47c3d9553a347c4b2 | Address of donor: PO Box 2378 London E5 9QU | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 17 | 2011-05-16-8f616a6e-10383-0 |
4318eea3e7441dd92c1036975f4f2a552ed3751f | Amount of donation or nature and value if donation in kind: £2.250 | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 18 | 2011-05-16-8f616a6e-10383-0 |
76ef18018c86c910165922ffb970b7005e92d530 | Donor status: political organisation | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 19 | 2011-05-16-8f616a6e-10383-0 |
59d598bd626daa27930cb5b105b6a5c4e424812a | (Registered 16 June 2010) | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 20 | 2011-05-16-8f616a6e-10383-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");