items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where person_id = "uk.org.publicwhip/person/10383" and sort_order = 6 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
6bba58fe4df8b7803c994ae84d14ba09abb3d170 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-31 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2017-07-31-2fa6c1a9-10383-0 | |
64c75e6b84d45d522177cff6f5f399d14dc62b05 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-06-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-06-06-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 |
c8d22830c7d105aac039124267b3a2f981ac2bfd | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-05-03 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-05-03-8f616a6e-10383-0 |
3c71cabd2bebe0dc2ca04bad145c99ce6fbf6ec3 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-04-18 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-04-18-8f616a6e-10383-0 |
0d6f3c47b3733e2b893c083c33753d97ea395366 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-03-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-03-28-8f616a6e-10383-0 |
14a6352bef1fce085d7a89f0bfc92d2b78a543a6 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-03-14 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-03-14-8f616a6e-10383-0 |
1ca99d92fdc7383e2483c09075c410fe6a182044 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-02-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-02-28-8f616a6e-10383-0 |
cba4be7d82558333fdd11f274d88e3bea24cf92c | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-02-07 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-02-07-8f616a6e-10383-0 |
4b45c8b354b0f45c001b109d9a29bb4fbc0c21cd | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2011-01-24 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2011-01-24-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 |
d52f380c4f1efcf694e8f165047684da98bf2b3e | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2010-12-20 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2010-12-20-8f616a6e-10383-0 |
da48cfcb0fc57e2ee1170e72cbf4acf68790efee | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2010-12-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2010-12-06-8f616a6e-10383-0 |
da1773ab1b34038e6f8243f015edf7dfdd3ad838 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2010-11-22 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2010-11-22-8f616a6e-10383-0 |
9e4f53c0762d3384e0d962e4d16b52d9a66a8c67 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2010-11-08 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2010-11-08-8f616a6e-10383-0 |
8bf63a380e8db880004e5f1bc215e625e1af4aa8 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2010-10-25 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2010-10-25-8f616a6e-10383-0 |
e0071427a3bb1c941fed1e390411c3a2b74bde51 | Name of donor: Fire Brigades Union | Sponsorships 8f616a6e | 2010-09-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 6 | 2010-09-06-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");