items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where person_id = "uk.org.publicwhip/person/10685" and sort_order = 7 sorted by hash
This data as json, CSV (advanced)
Suggested facets: item, category_id, date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0d5162ff3dd3d3c150afdcdbe26316054b72f618 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-06-16-1f359ece-10685-0 |
0d71f012566e47342f9765c1409eb029023112bf | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-03-24 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-03-24-1f359ece-10685-0 |
10cccfe0ea33436262a694eddf980ad1f9285977 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-03-21 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-03-21-1f359ece-10685-0 |
17d8126a6e72a800782805076397352edf686be4 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-02-24 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-02-24-1f359ece-10685-0 |
1d25245579949699710e15241d420edcd0440ced | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-03-10 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-03-10-1f359ece-10685-0 |
406bbf0ba586bdf820ddc616deb20d153d52d4a5 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-08-26 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-08-26-1f359ece-10685-0 |
443590920e494f55ca062f2426476c474fcfb4e0 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-07-28 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-07-28-1f359ece-10685-0 |
46d7127b8a845dee62adb5cf8fc481fcad0739ab | 6 | Overseas visits 80ef1083 | 2011-12-13 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2011-12-13-80ef1083-10685-0 |
47546b227f49bd4e54fdeb34cf1c6604665bed7a | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-01-06 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-01-06-1f359ece-10685-0 |
5f1d93b5c4d85660efc117e216e49b76d32c6b6c | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-12-08 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-12-08-1f359ece-10685-0 |
66c2ad1f4c16d738a617b1f7e356a746ba5cf9ce | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-09-22-1f359ece-10685-0 |
7023be9ed6befb686f28338e7e328c99b1b2b259 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-11-24-1f359ece-10685-0 |
8156ca29da8043380837896e83fc950bdc7a8f10 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-11-10 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-11-10-1f359ece-10685-0 |
8499f8ec5f470a33cb8c0c9b75b6e26247536c7f | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-05-12 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-05-12-1f359ece-10685-0 |
86c86e9cea8fa4f3e4f3d51a18b9bff69edec5f2 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-06-30-1f359ece-10685-0 |
96802dd8751f739c76c10bb0cb689fad3473b04a | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-04-28 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-04-28-1f359ece-10685-0 |
aa49b4158d9b1fa10d9122cd7f942fede0bd4daa | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-04-07 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-04-07-1f359ece-10685-0 |
b1ff4f863974681288a33d778383ce8cc4ce127d | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-10-27-1f359ece-10685-0 |
d83e783f56c2570362f36a7884dfa6a1eccc6032 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-07-14-1f359ece-10685-0 |
dbb9b7b9f97a6937c24edc1edb9762665b03f32f | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-01-20-1f359ece-10685-0 |
ef42431ce0ba8b789be965d1055e0e122703e23b | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-02-03 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-02-03-1f359ece-10685-0 |
f14062555df6283582baf7c6700787326f2ae487 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-06-02-1f359ece-10685-0 |
fcbd42d71caa92e59395374bc7e46813d4f84231 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All payments donated to local charity: | Remunerated employment, office, profession etc 1f359ece | 2014-10-13 | Eric Joyce uk.org.publicwhip/member/40255 | Eric Joyce uk.org.publicwhip/person/10685 | 7 | 2014-10-13-1f359ece-10685-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");