items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where person_id = "uk.org.publicwhip/person/10080" and sort_order = 15 sorted by member_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
569a03354bd0cbc9e840b742ae1f85ffaa4df31d | Remunerated employment, office, profession etc 1f359ece | 2014-05-12 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-05-12-1f359ece-10080-0 | |
8325c23da144a1a1470fa7ed0cf4d25b80c35325 | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-06-02-1f359ece-10080-0 | |
8f7d4c6329f9ed7d0c873b7bf21b99eff615837f | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-06-16-1f359ece-10080-0 |
9762c1a317d0fd8c8f3be01eed835a337855e241 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-06-30-1f359ece-10080-0 |
171d3408f04c77e0a75708c07cde8da76d8cbc3d | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-07-14-1f359ece-10080-0 |
2b5d9609bc20215a96fc79a163d5efbbc213271c | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-28 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-07-28-1f359ece-10080-0 |
0a96844f6db74816190766f2d6feefa61e8f9131 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-08-26 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-08-26-1f359ece-10080-0 |
add4bba8f301c8734d6da5ed21fc1fe90ac2bbf1 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-09-22-1f359ece-10080-0 |
87acda514c6e98bac410fc48266b8c241b9b7425 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-13 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-10-13-1f359ece-10080-0 |
9392042dd915a8336367865bd24c3523426fbc0b | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-10-27-1f359ece-10080-0 |
705397dd28f4e7ac7360b21dce7a2c57f5a1644f | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-10 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-11-10-1f359ece-10080-0 |
75684f31538a225c70c7ecedfd23d602de427df9 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-11-24-1f359ece-10080-0 |
253a557a33c8325133c2b09d2e8250851bed5f8f | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-12-08-1f359ece-10080-0 |
c76fba25a180efaa9e45d4487d7c56c0ac209476 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-01-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2015-01-06-1f359ece-10080-0 |
6c0bd1e04abb9b553f357831d90168234e17cd5d | (Registered 18 December 2014) | Sponsorships 8f616a6e | 2015-01-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2015-01-06-8f616a6e-10080-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");