items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where item = "Amount of donation or nature and value if donation in kind: £5,000" and person_id = "uk.org.publicwhip/person/10329" 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 |
---|---|---|---|---|---|---|---|
feb661b612442835f449c16099673f44da15a43c | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-06-20-8f616a6e-10329-0 |
1922572c631919b96d4c82ea438705b0d0cd03b0 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-06-06-8f616a6e-10329-0 |
367eae406db44c6f730b5e2bdc9dcc5894e9c49b | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-16 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-05-16-8f616a6e-10329-0 |
290fcd6f0c23cbf2f72b7875c617bf467514f50e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-05-03-8f616a6e-10329-0 |
01d665aa4cd84a257faa11ed8019f2019b22f6d0 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-04-18-8f616a6e-10329-0 |
9370cb8ec669493f281af5e481e7927c63d9f0dd | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-03-28-8f616a6e-10329-0 |
881a62ad48b00bdafd85c45718d058fccf331452 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-14 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-03-14-8f616a6e-10329-0 |
e234b5ce8571ca0e9a854a1bc7055f3775aa7686 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-02-28-8f616a6e-10329-0 |
b6441027248e268cc1da2da43a52a9bcdb7783a4 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-02-07-8f616a6e-10329-0 |
a70593602d3ffc207327255254a7ce9b0a65655e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-01-24-8f616a6e-10329-0 |
27c5642d3eca051a53410c92c5237427289283dc | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-01-10-8f616a6e-10329-0 |
04f8cdf745eddbde5383a31e3d24855e2cdbcadb | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-12-20-8f616a6e-10329-0 |
aeafd0322d280b53511e3a5230c18f5ac6b2c60e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-12-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-12-06-8f616a6e-10329-0 |
7e6193e8f2e0e5957709d19f11dd0e0f87b525e7 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-11-22 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-11-22-8f616a6e-10329-0 |
bc3678a89a5572060bb7919558a9e21d16145a28 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-11-08-8f616a6e-10329-0 |
eac96a3aed506b59841df5ba3fb1518a3366d193 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-10-25 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-10-25-8f616a6e-10329-0 |
ff34ec294ecdc36a196614a098cb0abcc4487f33 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-09-06-8f616a6e-10329-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");