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 = 14 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 |
---|---|---|---|---|---|---|---|
2c96d9c5f0c4fbd14fb5128250ba8cb5f4ccc515 | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-05-12 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 14 | 2014-05-12-1f359ece-10080-0 |
e0b88258deff3552222e785e0e1e846fcb88793e | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 14 | 2014-06-02-1f359ece-10080-0 |
9fc5c40661a0907b8e129ba0a6d34e2d31fa24eb | September 2013, 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 | 14 | 2014-06-16-1f359ece-10080-0 |
51b3b88ff18a6d68b90dee60be0c654e49029196 | September 2013, 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 | 14 | 2014-06-30-1f359ece-10080-0 |
869b49b6b8c563520d94d59f60c46c1fff986c44 | September 2013, 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 | 14 | 2014-07-14-1f359ece-10080-0 |
f8ea53b7721b12e7a3e9343725aca6776e5c92f0 | September 2013, 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 | 14 | 2014-07-28-1f359ece-10080-0 |
9d210c735d8feb979e4536db9eb14b7a5356f73d | September 2013, 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 | 14 | 2014-08-26-1f359ece-10080-0 |
21546e91bc4cb704921bbdf2d2cab8992252c602 | September 2013, 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 | 14 | 2014-09-22-1f359ece-10080-0 |
7a90b030a545474c36cc0cf7fb4199c4ddc68359 | September 2013, 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 | 14 | 2014-10-13-1f359ece-10080-0 |
dd78f1495c512a4c47e8d48e8fa5bd91bcd126cf | September 2013, 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 | 14 | 2014-10-27-1f359ece-10080-0 |
a83ab84b958db65dcf3ae6cd419e0eb4b5521db8 | September 2013, 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 | 14 | 2014-11-10-1f359ece-10080-0 |
dcb5a67321c917d95b23e8c761ce1f15167cc909 | September 2013, 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 | 14 | 2014-11-24-1f359ece-10080-0 |
5b89e724d130424670505d2e1843a684bfcd4ec6 | September 2013, 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 | 14 | 2014-12-08-1f359ece-10080-0 |
38c0d60b53d0778a8b020ea10281f996128c4d76 | September 2013, 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 | 14 | 2015-01-06-1f359ece-10080-0 |
c4eb8ab4c476bcb8bcef3a67766881ef4d30703b | Donor status: company, registration 0976511 | Sponsorships 8f616a6e | 2015-01-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 14 | 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");