items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where person_id = "uk.org.publicwhip/person/10065" and sort_order = 20 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item
date (date) 8 ✖
- 2013-06-10 1
- 2013-06-24 1
- 2013-07-08 1
- 2013-07-29 1
- 2013-10-28 1
- 2013-11-11 1
- 2013-11-25 1
- 2013-12-09 1
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0bf76726d0cdc168384a59f62932b08ec9bcb7f7 | June 2013, received £750 for two articles. Hours: 20 hrs each; 40 hrs in total (Registered 11 June 2013; updated 2 September 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-12-09-1f359ece-10065-0 |
41aff72a803672cf0f22da2041bc1ab423c02627 | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street, London, EC1V 0AT. Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-11-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-11-25-1f359ece-10065-0 |
85cd6de498aa1bcd1ecd107345b13bc61afc7b6e | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street, London, EC1V 0AT. Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-11-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-11-11-1f359ece-10065-0 |
4c34ad0af8a070ed8aebf75eaf84d9f4f959e4fd | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street, London, EC1V 0AT. Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-28 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-10-28-1f359ece-10065-0 |
0ac3d4d80d14bd1c9d527d8b2ce54e376d8135c5 | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street, London, EC1V 0AT. Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-29 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-07-29-1f359ece-10065-0 |
b8ff0a9644ff37fe52cfea200467e29179dee79b | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street , London , EC1V 0AT . Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-07-08-1f359ece-10065-0 |
eebb9c696b957ec10912671542e4c0cab8584e04 | June 2013, received £750 for two articles. Hours: 20 hrs. (Registered 11 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-06-24-1f359ece-10065-0 |
bec19f4a84f9ac6d0d8b2475e83a62a93b908f1c | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street, London, EC1V 0AT. Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-10 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 20 | 2013-06-10-1f359ece-10065-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");