items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
703 rows where member_id = "uk.org.publicwhip/member/40275" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
17e2a4768e7b5956c172765bdc841b9b437e2a83 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-03-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-03-30-8f616a6e-10684-0 |
cfdb6c7db28ae293255f376862f554cc283f043f | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-03-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-03-30-8f616a6e-10684-1 |
30494a6f877afb5b7c6e3bf4cac63c904de924da | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-03-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2015-03-30-8f616a6e-10684-1 |
7de34c814a94074181c7dbb92d63983242b82766 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-03-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2015-03-30-8f616a6e-10684-1 |
073a24f5e5794c92cd79b57389d11bc495f0621d | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2015-03-30-8f616a6e-10684-1 |
6f46c9c0b7e5ed4b1854ceeb207815c385bb2a79 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2015-03-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2015-03-30-8f616a6e-10684-1 |
9bfc8998ed4744e071ef8e143a3b7caaf2429280 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-03-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-03-09-8f616a6e-10684-0 |
bbdd61d8af8522fe6ee2b07f34463a283795a34f | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-03-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-03-09-8f616a6e-10684-1 |
903ff836346877634db7a7dd896ec6bb90159177 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-03-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2015-03-09-8f616a6e-10684-1 |
b6d4736069ea809aa3500ee11373a30242b9e254 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-03-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2015-03-09-8f616a6e-10684-1 |
33956922144bb94bca62889a88efc3dea5e90774 | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2015-03-09-8f616a6e-10684-1 |
48d14261fdbf5d917baf188b882a27666ec7d2a6 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2015-03-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2015-03-09-8f616a6e-10684-1 |
80fc0b95a38799c0120733d085917ad00cabf011 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-02-23 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-02-23-8f616a6e-10684-0 |
a37c104136352758b8b74ab2a5b4d8686c00ba17 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-02-23 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-02-23-8f616a6e-10684-1 |
471af9b7c7c6c37611dc7f9691f6e7dce1de6827 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-02-23 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2015-02-23-8f616a6e-10684-1 |
3af0e14fd7c630cce97afed0c7afc15666265cee | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-02-23 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2015-02-23-8f616a6e-10684-1 |
5c09ff0fb7f28fd16abc2846bd31920746ec09a1 | Donor status: trade union | Sponsorships 8f616a6e | 2015-02-23 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2015-02-23-8f616a6e-10684-1 |
e0ae89bad602da65b496e5b59c40a1d5d4219685 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2015-02-23 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2015-02-23-8f616a6e-10684-1 |
da1dce23ef0185d429494214568a47cb0bb7db90 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-02-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-02-09-8f616a6e-10684-0 |
66863c936f8ca37782b26b8cfb41629f008b3bae | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-02-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-02-09-8f616a6e-10684-1 |
9709cbe8d12733074fae2464c2bf33f9536387f8 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-02-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2015-02-09-8f616a6e-10684-1 |
379da7c017e71a4ba35fc3a468bc6e49616a9c4f | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-02-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2015-02-09-8f616a6e-10684-1 |
78031afff776e897ac1a24054c8bd0ac78ae8261 | Donor status: trade union | Sponsorships 8f616a6e | 2015-02-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2015-02-09-8f616a6e-10684-1 |
3de00fec0619d210885f4f2eaecddea204fad17d | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2015-02-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2015-02-09-8f616a6e-10684-1 |
0e588fb72e964f0ee3d5e96f1d8338d789932e94 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-01-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-01-26-8f616a6e-10684-0 |
e6e0625bad1e57a98903aea4cc0788169eeebf72 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-01-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-01-26-8f616a6e-10684-1 |
cc057d75f014a51e27746c2e99233bb85ca9ceed | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-01-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2015-01-26-8f616a6e-10684-1 |
41360db0762631f606db6505535cb7fd4cdfbe18 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-01-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2015-01-26-8f616a6e-10684-1 |
581f6e818b7505a0b61e4ce6df8d00c895188346 | Donor status: trade union | Sponsorships 8f616a6e | 2015-01-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2015-01-26-8f616a6e-10684-1 |
e1d516e93c038b8e47eb7227149a080fde738714 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2015-01-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2015-01-26-8f616a6e-10684-1 |
3f60990c4a64d392cfbff3ddc81d408d59cdf4fe | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-01-06 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2015-01-06-8f616a6e-10684-0 |
30056c0b499149e41d5c389ad88bd1e2118014fb | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-01-06 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2015-01-06-8f616a6e-10684-0 |
f0c7da6a0d5b8fa08fc6978b673a077b5f569a4b | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-01-06 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2015-01-06-8f616a6e-10684-0 |
978d9fba0479b4a5d0b2e25bf6456af7aead148e | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-01-06 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2015-01-06-8f616a6e-10684-0 |
4fa2409f4a94c6105c0b4491a4e6666e1fe3cdfa | Donor status: trade union | Sponsorships 8f616a6e | 2015-01-06 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2015-01-06-8f616a6e-10684-0 |
f16f579b024e3612da7b3971e5e4db49cd8a240a | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2015-01-06 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2015-01-06-8f616a6e-10684-0 |
e6b4e6cdac70d21ecb92fa99d3241643c5402794 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-12-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-12-08-8f616a6e-10684-0 |
6ea735716225d989925daacc058c484d9a64ca9c | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-12-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-12-08-8f616a6e-10684-0 |
292e9f3c5b2deeb00f37f44dbca3178dfc4b664e | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-12-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-12-08-8f616a6e-10684-0 |
e06a2c9b8414e07c834ad256821c7ea1621e991f | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-12-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-12-08-8f616a6e-10684-0 |
de316f6e34aed2915ab32c48747cb7ebf41c4bd1 | Donor status: trade union | Sponsorships 8f616a6e | 2014-12-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-12-08-8f616a6e-10684-0 |
48727eb90ee6e476de3bb6ac012d234106724cce | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-12-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-12-08-8f616a6e-10684-0 |
b9e9a0162b2d80eebb6f58df9e56bef093c3131e | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-11-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-11-24-8f616a6e-10684-0 |
e301fd2959642e55f1c3b511bea0f281905f1bf9 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-11-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-11-24-8f616a6e-10684-0 |
146280a569a477280b7199a18d1870bebcafb689 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-11-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-11-24-8f616a6e-10684-0 |
af93c7fad1e8d5f8c8384a7afc9fb0a1a8f09436 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-11-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-11-24-8f616a6e-10684-0 |
6d74590a02b9bf1fa72eb35fdb9bb406fe3a91c2 | Donor status: trade union | Sponsorships 8f616a6e | 2014-11-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-11-24-8f616a6e-10684-0 |
c597272a0cebfc5a15f00904e152dbfee6db434a | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-11-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-11-24-8f616a6e-10684-0 |
60b2ca75376118dd7cca748bb7f6d419962fae79 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-11-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-11-10-8f616a6e-10684-0 |
1e4fa316d4085bcb697b3465027d6e9106ffb587 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-11-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-11-10-8f616a6e-10684-0 |
e42954b739c263f713e56321c67ba29aed6b307b | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-11-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-11-10-8f616a6e-10684-0 |
815f280b9c4f6ae06c3d8ee271694708f265ef82 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-11-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-11-10-8f616a6e-10684-0 |
40adbbe838a9626dade39c441dc4280646dd3366 | Donor status: trade union | Sponsorships 8f616a6e | 2014-11-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-11-10-8f616a6e-10684-0 |
9da545e16191833f06f2b7b9c2d9cc69528d4065 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-11-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-11-10-8f616a6e-10684-0 |
a1cd4d612221b10858a268b00517fccb118a77f0 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-10-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-10-27-8f616a6e-10684-0 |
e37be957309d69eb4aaf2eaf25ccb04bad207d8c | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-10-27-8f616a6e-10684-0 |
307d95df38d0b9954a92a437795a397cf07341d6 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-10-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-10-27-8f616a6e-10684-0 |
43a5b9fa0d67eeace05081cf20cf11c0982ec3fd | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-10-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-10-27-8f616a6e-10684-0 |
97fe5e3f7f851bb47d0522e574ae26234547b0d6 | Donor status: trade union | Sponsorships 8f616a6e | 2014-10-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-10-27-8f616a6e-10684-0 |
6e09bd677b3b8fea0d43b21a79386d5f071929ea | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-10-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-10-27-8f616a6e-10684-0 |
d5ef028458c38d485ddeaa3b90c7623554f994b1 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-10-13 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-10-13-8f616a6e-10684-0 |
da7ae01b8a9e98f8c0f94d9d0c921ebe2ff4e9e3 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-13 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-10-13-8f616a6e-10684-0 |
cca2631ba9073ad39e9795145b2ca7498c409059 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-10-13 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-10-13-8f616a6e-10684-0 |
061d7a1aec8461b202671898389742c5952929dc | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-10-13 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-10-13-8f616a6e-10684-0 |
d7f06adf8cdfba1a0d314b9ed8fb9b82a14063ae | Donor status: trade union | Sponsorships 8f616a6e | 2014-10-13 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-10-13-8f616a6e-10684-0 |
a0d8e9a0f5547213cf81db1d8fd9e724cefc1fa5 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-10-13 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-10-13-8f616a6e-10684-0 |
69de47358ce839d6286e985f67386d1cf6dc3de1 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-09-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-09-22-8f616a6e-10684-0 |
f0a86caf0ce63966320183ccbcb8508f99aaac27 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-09-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-09-22-8f616a6e-10684-0 |
12c4a0113ab3a57ac938be6d1aef97795f64b493 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-09-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-09-22-8f616a6e-10684-0 |
4b40e37235fd6a6065ca2fbde605eecd0a3224e6 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-09-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-09-22-8f616a6e-10684-0 |
634c42fefc6c30ca41712b09e5466cfc79c0fd60 | Donor status: trade union | Sponsorships 8f616a6e | 2014-09-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-09-22-8f616a6e-10684-0 |
f2fb6a65f68130be46a257841894a39a07410346 | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-09-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-09-22-8f616a6e-10684-0 |
cdaaac0ea2e984faf45adcac75ba47446e23dd76 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-08-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-08-26-8f616a6e-10684-0 |
afe9ef2440b1563c616f4256847a556ee442c982 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-08-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-08-26-8f616a6e-10684-0 |
4a09786bd0cac557e3700e0cbf6190e47c453234 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-08-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-08-26-8f616a6e-10684-0 |
aacffeecdc7c301d0e8fb07e9c25d1f02d4282f8 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-08-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-08-26-8f616a6e-10684-0 |
ba8768194815bee837f8780efb102a6739e44243 | Donor status: trade union | Sponsorships 8f616a6e | 2014-08-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-08-26-8f616a6e-10684-0 |
7304c623726576e37205a25076d9e0587c75145f | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-08-26 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-08-26-8f616a6e-10684-0 |
96ca2c4bfe486b5e528c377944ce158d1ff8a269 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-07-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-07-28-8f616a6e-10684-0 |
f7300ad54bf1c113456da68745e42b3fda10053b | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-07-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-07-28-8f616a6e-10684-0 |
2c8a8aaa102d4e51f558fba9c565ed4bd34df00b | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-07-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-07-28-8f616a6e-10684-0 |
d2bbe21f85602eac036ad96e25982f7f311087d0 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-07-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-07-28-8f616a6e-10684-0 |
852864a02b02da5d36e4b2ac238e0ae788343387 | Donor status: trade union | Sponsorships 8f616a6e | 2014-07-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-07-28-8f616a6e-10684-0 |
0eb7896bfa71fbe5c49a55b9bfd20d6719933f2d | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-07-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-07-28-8f616a6e-10684-0 |
44497ec0c7bacb10dbc9b5910213afbcfbee289a | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-07-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-07-14-8f616a6e-10684-0 |
9b55e304f277dce580ab92771b436bb469f808af | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-07-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-07-14-8f616a6e-10684-0 |
d7d9a9a1b43de5505f9da1af1cec7bcaa42c2346 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-07-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-07-14-8f616a6e-10684-0 |
0e1d653a8e2b674586d6d58da17bc0e306aed743 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-07-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-07-14-8f616a6e-10684-0 |
7d5adc6bacf3b943b3c8ce1e1ea1211d5c40c0fc | Donor status: trade union | Sponsorships 8f616a6e | 2014-07-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-07-14-8f616a6e-10684-0 |
251a494d0dcac752abd1d3e48b914b6e92cc94ca | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-07-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-07-14-8f616a6e-10684-0 |
28bfd2cff3f969a621f4efd852f273edd59f6461 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-06-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-06-30-8f616a6e-10684-0 |
c3c7abf74f267bd624ab4e55585cf5342796d274 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-06-30-8f616a6e-10684-0 |
582e18c68d0086e1e2e95f82266a6d962a16b75a | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-06-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-06-30-8f616a6e-10684-0 |
4fde77f486e50ed19c0d555d513ac0c3e3589b31 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-06-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-06-30-8f616a6e-10684-0 |
6f539e47c1d272e285951a446c3070483844bbd9 | Donor status: trade union | Sponsorships 8f616a6e | 2014-06-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2014-06-30-8f616a6e-10684-0 |
68cfabf4adfe0256a896b1d6ab029d3bcfafecae | (Registered 6 May 2014) | Sponsorships 8f616a6e | 2014-06-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2014-06-30-8f616a6e-10684-0 |
0fec920ef5eb48875d0d3e3240abe42b30bc25a6 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-06-16 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2014-06-16-8f616a6e-10684-0 |
1f9e6448fb5fb508adb3ade62f9ad214bf9459b3 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-16 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2014-06-16-8f616a6e-10684-0 |
9274c057a8570f6f48696fd88a6ebb29eb625c22 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-06-16 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2014-06-16-8f616a6e-10684-0 |
1104ccc96d9099469399830166ebd7e3f6a23005 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-06-16 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2014-06-16-8f616a6e-10684-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");