items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where "date" is on date 2002-05-14 and person_id = "uk.org.publicwhip/person/10080" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
7451ba807debbb43beaee788a0de207900e16493 | Elected member of London Borough of Sutton Council. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2002-05-14-1f359ece-10080-0 |
ed896f0305d15be4d8c7ffd100229667ad87689d | Provision of a website by Mr Jeffrey Richards, Managing Director of ABS Training, Sutton, Surrey. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2002-05-14-9e46def6-10080-0 |
bab404ad910c238f8e29a547db11629cf4fc95d9 | Presentation of a wicker basket containing an assortment of washable nappies and other real nappy products and a nappy basket from the Real Nappy Association. (Registered 25 April 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2002-05-14-84642823-10080-0 |
3ccc484bf3575c3f8cd8f928d446156789396437 | I receive rental payment from my constituency party for the use of office space by a party worker in my constituency office, for which I pay the rent. | Land and Property 4f1e6359 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2002-05-14-4f1e6359-10080-0 |
a3fe301809c5f82fe991503c4f8e5b0bbe761608 | Governor of Westbourne Primary School, Sutton. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2002-05-14-265f2269-10080-0 |
8191fe33b64014367b170c5f69137279dc5e8a68 | Occasional payment received for magazine articles and radio appearances. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2002-05-14-1f359ece-10080-0 |
79dec8dbdd5077a777dfb30cdcae13ea34d098f3 | Two desktop computers and one printer for use in my Westminster and constituency offices provided by Mr D Ellison, a local party member. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2002-05-14-9e46def6-10080-0 |
1e3d41e0d1f36b1db4c6cb5834af2a9822581c44 | Hon. President of Sutton Branch of MS Society. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2002-05-14-265f2269-10080-0 |
e46137ce8ddc19f523422ce833290555f64eb319 | Member of MORI research panel. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 2 | 2002-05-14-1f359ece-10080-0 |
fc8545a2867d9834193448dd666f135a6e8bfe2a | Non-executive director of Business Ecologic Limited (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 2 | 2002-05-14-265f2269-10080-0 |
17b002b81bd7eccdc2335ea2c66a011e4b7c26fb | Member of Gallup research panel. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Paul Burstow uk.org.publicwhip/member/769 | Paul Burstow uk.org.publicwhip/person/10080 | 3 | 2002-05-14-1f359ece-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");