items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where person_id = "uk.org.publicwhip/person/10066" and sort_order = 6 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
929cc4b50fe0369fd64999ac97ff93f60f42b950 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2010-04-12-1f359ece-10066-0 |
6fadf215156c5250ebb276a39968306b7746f07d | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2010-03-24-1f359ece-10066-0 |
246fc5ee8ea085d62ff03c310c64d88cfed28b98 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2010-03-10-1f359ece-10066-0 |
930c2de741bfc8b405e868d6520ebc148fb5c26e | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2010-02-24-1f359ece-10066-0 |
02b462abf7a4b0ca068d00960a980a45047c1be0 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2010-02-03-1f359ece-10066-0 |
c398a2a8e94497ac2302c50284b6a36207d49949 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2010-01-06-1f359ece-10066-0 |
95f8742998124a9104466efacc94d555871bbbe2 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2009-12-10-1f359ece-10066-0 |
3bc3eef3371a6f3b4b71e5818d96b20355a44704 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2009-11-25-1f359ece-10066-0 |
e75c710e585b3efc09cc1bbfa0e174d531e2db7d | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2009-11-11-1f359ece-10066-0 |
10fd57a5c00add49c6356d00eaa387c1695f2626 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2009-10-28-1f359ece-10066-0 |
462b1cdb65283bea22550d846c2a64296d763826 | Received £310 on 24 September 2009. Hours: 8 hrs. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Colin Breed uk.org.publicwhip/member/1514 | Colin Breed uk.org.publicwhip/person/10066 | 6 | 2009-10-14-1f359ece-10066-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");