items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2011-01-10-8f616a6e-10383-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 |
---|---|---|---|---|---|---|---|
2144ef9ca2d30ec3349dd41fe2671af75cc4ca17 | (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-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2011-01-10-8f616a6e-10383-0 |
a9101f8fbdb21d90aaa83e8fd7e6ed50c16f96e5 | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-01-10-8f616a6e-10383-0 |
e22b7dfcd5ee1a60ac6b50580de489ee2c9c26bc | Address of donor: 60-62 Clapham Road London SW9 0JJ | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2011-01-10-8f616a6e-10383-0 |
54ce220254c57d1afe83be61138aa2039185f672 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-01-10-8f616a6e-10383-0 |
30860b6d3733b6c31900463341cc368b347a7c74 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-01-10-8f616a6e-10383-0 |
983d68eb1f9b42ceef860ac8ba7eaf4551e92470 | Amount of donation or nature and value if donation in kind: £5000 | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 8 | 2011-01-10-8f616a6e-10383-0 |
6b0d504d26534cc10772759fb3177ad78c786d79 | 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-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 11 | 2011-01-10-8f616a6e-10383-0 |
034691bbf4c10a4da86c821f3be81a9cd465a0d8 | 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-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-01-10-8f616a6e-10383-0 |
9594021be293c1d4010a07b19c8783559f905f09 | Amount of donation or nature and value if donation in kind: £5,000 in total | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 13 | 2011-01-10-8f616a6e-10383-0 |
27a5d38271c189e84b9e6244d699239335b5033d | Donor status: trade union | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 14 | 2011-01-10-8f616a6e-10383-0 |
9ab2cb7ece293b9a3623828381331e05e00b5387 | Name of donor: Labour Representation Committee | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 16 | 2011-01-10-8f616a6e-10383-0 |
d9c78cb5e7efbe26c2ca7dd9d77e1feea5034fa5 | Address of donor: PO Box 2378 London E5 9QU | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 17 | 2011-01-10-8f616a6e-10383-0 |
5bba6fddb510c6972c03eaa45d45000d79f055f9 | Amount of donation or nature and value if donation in kind: £2.250 | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 18 | 2011-01-10-8f616a6e-10383-0 |
a58c62c6535783a7200557a99aca409fb10d8f93 | Donor status: political organisation | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 19 | 2011-01-10-8f616a6e-10383-0 |
aa29514ef5ac66a9f5ceeb56b1fee8c5dfea5192 | (Registered 16 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 20 | 2011-01-10-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");