items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2009-11-11-9e46def6-14128-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
371ced7ca78fc1f112765a4be217f5aac9116966 | Timpson Ltd has paid for the fitting out of my constituency office. (Registered 14 August 2008) | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 0 | 2009-11-11-9e46def6-14128-0 |
4a51d7d77b0726ae78883ca51d4c8435812b39f7 | The salaries of two members of my staff are funded by Timpson Ltd. (Registered 30 April 2009) | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 1 | 2009-11-11-9e46def6-14128-0 |
08656b065273b03ce8d4748062f9ae088602ed85 | Donation to my campaign fighting fund from Mr Johan Christofferson, of London. (Registered 30 April 2009) | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 2 | 2009-11-11-9e46def6-14128-0 |
994858fa3cae173f9b645d0c358712d5c1860f51 | Name of donor: Timpson Ltd | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 3 | 2009-11-11-9e46def6-14128-0 |
f1f6e0752e7306c0dbaf6a7efe6a4fa550bfd7be | Address of donor: Timpson House, Claverton Road, Wythenshawe, Manchester, M23 9TT. | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 4 | 2009-11-11-9e46def6-14128-0 |
7b21ccd935849dd3b914c855adfc3d9034e00330 | Amount of donation or nature and value if donation in kind: £11,417 for rent and rates for non-political constituency office. | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 5 | 2009-11-11-9e46def6-14128-0 |
13a17f9ca6733b3102d16abb1b93e9f0350952d1 | Date of receipt: 30 August 2009 | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 6 | 2009-11-11-9e46def6-14128-0 |
3c7b99a88b6368b2cd830ec5dcba49df59b8d9ae | Date of acceptance: 30 August 2009 | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 7 | 2009-11-11-9e46def6-14128-0 |
005a0fcb98e7bc146575931699532e46a0354ab2 | Donor status: Company, registration number 06871733 | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 8 | 2009-11-11-9e46def6-14128-0 |
46c20bef2823e3e1c5c37ea80e866f85a74813d0 | (Registered 22 September 2009) | Sponsorship or financial or material support 9e46def6 | 2009-11-11 | Edward Timpson uk.org.publicwhip/member/2032 | Edward Timpson uk.org.publicwhip/person/14128 | 9 | 2009-11-11-9e46def6-14128-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");