items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
39 rows where person_id = "uk.org.publicwhip/person/10009" and sort_order = 9 sorted by record_id
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
a8169f1ca27d95fc9eae499df666df268aec4914 | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-09-06-80ef1083-10009-0 |
0a01d2daa3b1bd7717000c5001902c7284a5498e | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-10-25-80ef1083-10009-0 |
c5ef3a464e09b4e7f716677dcad184d17a1c3504 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-11-08 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-11-08-80ef1083-10009-0 |
81b39eb6a82fbefab3bd3ec2824c53a85215c2cd | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-11-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-11-22-80ef1083-10009-0 |
ced9a963724f98fbbf6fe12e65536791a50a1787 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-12-06-80ef1083-10009-0 |
cf8b85eb0266f2f2d08708ee292d802476142059 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-12-20 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-12-20-80ef1083-10009-0 |
8d7c23b3515fa39595e929a1c16a01097c506c6c | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-01-10-80ef1083-10009-0 |
779d9a36f372ed1d96f71bbd2469c0b89a787250 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-01-24 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-01-24-80ef1083-10009-0 |
82fd2bd2410ba0f5c5fd7bb578109b6892cb1ad5 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-02-07 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-02-07-80ef1083-10009-0 |
5aa89591a4e72af9fdd86ca8c7ec4a775ed8016f | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-02-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-02-28-80ef1083-10009-0 |
e78d43b857f152b595f1e4e70befb4340eed675e | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-03-14 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-03-14-80ef1083-10009-0 |
ea2a84f8b70f4a0e1198e280c9ff1477e000a967 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-03-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-03-28-80ef1083-10009-0 |
3e56861cacfb37b15101d262c04940ca8ae0ea73 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-04-18-80ef1083-10009-0 |
5475e9281b939fc7fb0776fa1f67bbee0b8eef90 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-05-03-80ef1083-10009-0 |
5133ba1f7f3662c3f0c29c9f80db11df90117c9c | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-05-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-05-16-80ef1083-10009-0 |
8a67d7b3d18b3357ea64bb9fc6628936c8697152 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-06-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-06-06-80ef1083-10009-0 |
67f8a2ae2b08d61c0c81c173e5ca8f3cfe3c5cc2 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-06-20 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-06-20-80ef1083-10009-0 |
3d566f36ee61d61cc5bc2a85414a07048a83415e | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-07-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-07-06-80ef1083-10009-0 |
1cf2f3e5b86ecef09b56b962c9c4f0ff5922acda | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-07-19 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-07-19-80ef1083-10009-0 |
dda8c402038e7ab299591f436f86205086d6fb5c | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-08-30 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-08-30-80ef1083-10009-0 |
45e7943c90eefe585fd61093a201e6bd49a5f8b5 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-09-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-09-28-80ef1083-10009-0 |
e618d80733fa5396fcf4ff66603c57bd0752bf56 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-10-17 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-10-17-80ef1083-10009-0 |
c0683f9c69cacf8c3bda1b0b86865904b2ef9ee7 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-10-31 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-10-31-80ef1083-10009-0 |
51cc4da0fafa2d38ed40ceb3c95ea523cabe9b63 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-11-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-11-16-80ef1083-10009-0 |
d79aa677e034e7bc90138ffb87035ba8f17c54ed | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-11-29 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-11-29-80ef1083-10009-0 |
6a86a3528a9e99da21a15d8e8ee1ca5fa56b304f | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2011-12-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-12-13-80ef1083-10009-0 |
2e7bdb4297ba9ec7cf911ded6ed4e52dd818527f | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2012-01-13-80ef1083-10009-0 |
8fee195a85a182ebc52e70e320e416e9250f0a7f | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-06-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-06-16-80ef1083-10009-0 |
e5c04a06fc31e335c2425107a6e8e906fdd74af3 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-06-30 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-06-30-80ef1083-10009-0 |
8767aea577771e032a6b4ad96574ce79c961719a | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-07-14 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-07-14-80ef1083-10009-0 |
1838dcddf1be893a3372ce2c6b1d16935654cc72 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-07-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-07-28-80ef1083-10009-0 |
9774c835309320f5a317ef71cfb0ceda78fd6320 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-08-26 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-08-26-80ef1083-10009-0 |
4397c7d6e09d32481049fa7b37e0f20822d8d196 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-09-22-80ef1083-10009-0 |
6cea24213005d4efd95ce8da7ebbbc2309ff1660 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-10-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-10-13-80ef1083-10009-0 |
356b41e888d72c2db54294d1f59afa45ce705ecf | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-10-27 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-10-27-80ef1083-10009-0 |
3e3363fbb0022c8f143aa032b446c103d78dcead | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-11-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-11-10-80ef1083-10009-0 |
85d9fc4e77b2150ea3b8aee3d610623a0d6a5d6a | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-11-24 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-11-24-80ef1083-10009-0 |
895d6ae75dd812e44b893abeec352aab05cc68c4 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-12-08 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-12-08-80ef1083-10009-0 |
87fe506eee667703483f0ff48d706b95c9eeb91a | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2015-01-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2015-01-06-80ef1083-10009-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");