items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where "date" is on date 2010-10-25 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 |
---|---|---|---|---|---|---|---|
010ad82f23d2528259d0a6471eb100536d9b8339 | Received mug from Churches Conservation Trust, 1 West Smithfield, London, EC1A 9EE, following visit to Lumley Chapel, Cheam. Value: £17. Hours: 40mins. (Registered 15 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2010-10-25-1f359ece-10080-0 |
750e12d96d85c80f8dae3cc005d64417016f6665 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2010-10-25-9e46def6-10080-0 |
84ca88e1007bfa5f1229fd3bed6350f946c9e710 | I own a 25% share of house in Sutton, lived in by my mother. | Land and Property 4f1e6359 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2010-10-25-4f1e6359-10080-0 |
e29a9d105e585c1561715ce1da9469f374f39732 | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2010-10-25-9e46def6-10080-0 | |
a53af680c1d07d658ee5fde778873ca56fa782c6 | Name of donor: Mrs S Burstow | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 2 | 2010-10-25-9e46def6-10080-0 |
6eaa6cf1f5b3fa3404c98126f5b2d5c6ae53bc5f | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 3 | 2010-10-25-9e46def6-10080-0 |
2ffcf9a24dd8648613c837fcb84b68228d1ece9c | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 5 | 2010-10-25-9e46def6-10080-0 |
c5f9f2e637fba9cc9797220f337a4f6e053d58c3 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-10-25-9e46def6-10080-0 |
c5f13499ffcaf925c4b68d8eb249309dc2b7c834 | Address of donor: 14 St Mary’s Street, Stamford, PE9 2DF | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 8 | 2010-10-25-9e46def6-10080-0 |
324c52f5edd2ce4011619ca0ddc316d7eeefb038 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-10-25-9e46def6-10080-0 |
ab3c96786e675b1f50389f14466c1a5625c08bc8 | Donor status: company | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 10 | 2010-10-25-9e46def6-10080-0 |
2fce6f416624c4411ee9bb4fc087218770fec056 | (Registered 26 May 2010) | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 11 | 2010-10-25-9e46def6-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");