items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2010-12-20-8f616a6e-10397-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
d1504a3a334fcff61eeef532d1dd6f6ce505208c | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 0 | 2010-12-20-8f616a6e-10397-0 |
69e1d99f7b9a73db3da6238ed8652f44419b03f9 | Name of donor: Andrew J Cook | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 1 | 2010-12-20-8f616a6e-10397-0 |
59858f4af36810126474958e1046c1acb5562d69 | Amount of donation or nature and value if donation in kind: £2,000. | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 3 | 2010-12-20-8f616a6e-10397-0 |
b19925d4045b3a5475ac01550ede3fa30b02aaf9 | Name of donor: Simon M Haslam | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 6 | 2010-12-20-8f616a6e-10397-0 |
16431fe79810f8497cec17ed8fd7e19415df941f | Address of donor: private | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 7 | 2010-12-20-8f616a6e-10397-0 |
1b375cc3b281d0d728995c1d4115ca69daf58045 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-12-20-8f616a6e-10397-0 |
1cde83435ea23e92c292a13af65e0847deb64c6b | Donor status: individual | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 9 | 2010-12-20-8f616a6e-10397-0 |
6ca7a3889a79c587e8a23aebfe9b52ea90e3bade | Name of donor: JCB Research | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 11 | 2010-12-20-8f616a6e-10397-0 |
57350f179762e31c818fa7168a4658665197d35a | Address of donor: Rocester, Staffordshire, ST4 5JP | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 12 | 2010-12-20-8f616a6e-10397-0 |
090becacd8369b128b89de555e053ef3fa9269fc | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-12-20-8f616a6e-10397-0 |
54cdde1412415a7d30bc6c7a66703bc9c3ca55b9 | Donor status: company | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 14 | 2010-12-20-8f616a6e-10397-0 |
547c6a61500f8cb94cec27f4eda9f562b785e92d | (Registered 16 June 2010) | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 15 | 2010-12-20-8f616a6e-10397-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");