items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where person_id = "uk.org.publicwhip/person/10009" and sort_order = 16 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 ▼ |
---|---|---|---|---|---|---|---|
9c9a16db6410349abde2e2303c7b4a3fbcd66915 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-10-25-80ef1083-10009-0 |
93e5b6c37f6b30f34edee77adabb469ea3f46f69 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-11-08 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-11-08-80ef1083-10009-0 |
73ea996d5879d39a6d1ce84633288bec8045c0db | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-11-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-11-22-80ef1083-10009-0 |
b5db6ed41505d7e91e8e754b26df78f3e16b6c51 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-12-06-80ef1083-10009-0 |
bed3df70ca46b014067239a4212fe919ab9e65e7 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-12-20 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-12-20-80ef1083-10009-0 |
f3a80056561720a47fb6ffb9897684aad121a60a | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-01-10-80ef1083-10009-0 |
e295e57263a8520c4875744de59766803d1bc334 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-01-24 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-01-24-80ef1083-10009-0 |
e49b3f54929e4e853356662587523f43fa5a3475 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-02-07 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-02-07-80ef1083-10009-0 |
62d0b3cfb5028e1f6e675a44dedab4f4b8c74c8f | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-02-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-02-28-80ef1083-10009-0 |
44753fc3f4f87082bca4a59e2da736c28835de4c | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-03-14 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-03-14-80ef1083-10009-0 |
32bd3f2e75b6b476ed25627c3032915f19b85d3a | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-03-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-03-28-80ef1083-10009-0 |
49199488d8319f5cc4f616b8055c15ffaf61e15c | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-04-18-80ef1083-10009-0 |
3012ec8ff2743232305e87dac6d4876c63868d1f | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-05-03-80ef1083-10009-0 |
c575cfa60a5074a1b591e4247d2db5b77baf59ec | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-05-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-05-16-80ef1083-10009-0 |
404fc1d4472c778b10f5ccdf299957e2ca6e6fdb | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-06-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-06-06-80ef1083-10009-0 |
a56cede00ceb04c50122a0fe1e00f99fc761ebe2 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-06-20 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-06-20-80ef1083-10009-0 |
d7aba52daf21b1298fcea5efafc7d021384cb4ba | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-07-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-07-06-80ef1083-10009-0 |
b4ea4e7f4faa5dd07376da13bc54437863dad80c | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-07-19 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-07-19-80ef1083-10009-0 |
f40471ec9fd4bea398b0bd0f14a335923859eda9 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-08-30 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-08-30-80ef1083-10009-0 |
b1aa18a04a8c6532a0782e761e5f92602f6ad389 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-09-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-09-28-80ef1083-10009-0 |
2ff570192f02f7714f0d1fd74e56c9278f5eb8d5 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-10-17 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-10-17-80ef1083-10009-0 |
7edcf4a9f38bb92121ac8e0acb398d6e6afe0ba2 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-10-31 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-10-31-80ef1083-10009-0 |
bfd85224681c91b7b435ec4bd41b4a2ddab3c5fb | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-11-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-11-16-80ef1083-10009-0 |
6431d1cb9f2beeb91ada510c62c24e2d646cfd7a | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-11-29 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-11-29-80ef1083-10009-0 |
da0c1ea27a58bd6c9c035468788716f89249e220 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-12-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-12-13-80ef1083-10009-0 |
3982d2257d01b6ab5e1fb46a9e843dd2d089e5bf | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2012-01-13-80ef1083-10009-0 |
3ec9fbd7cd24dfbbf10b299f515942bd4bd4ce7c | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-07-14 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-07-14-80ef1083-10009-0 |
ffe1f3c39f66ee015d733021a01394a9e4883f26 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-07-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-07-28-80ef1083-10009-0 |
26e620a4ae8d2392cc46bd07363d01778d35c155 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-08-26 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-08-26-80ef1083-10009-0 |
eb6bf080c36883a03bbf554cc11ba56c8aa952ff | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-09-22-80ef1083-10009-0 |
6a13db8a2cefa0e6c7b3f2769a999216af2f6339 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-10-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-10-13-80ef1083-10009-0 |
db8f132d3492a42a0b9d888403f55aa578c9a8d5 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-10-27 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-10-27-80ef1083-10009-0 |
a56744fd1267be1b434461c67d8b0639f7cdacff | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-11-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-11-10-80ef1083-10009-0 |
ebae3e5fa4da8778b5dbfc99dc46a0897511045f | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-11-24 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-11-24-80ef1083-10009-0 |
54d7e76d34e6cc6c13b52b713b87f9dd1b8dc2c1 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-12-08 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-12-08-80ef1083-10009-0 |
6a9fa558df52543b46fcd108e95248953bd85031 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2015-01-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 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");