items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2012-04-16-8f616a6e-24829-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 |
---|---|---|---|---|---|---|---|
5d40e89dd83e7a941767d6fbb90bbba444d4284c | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2012-04-16-8f616a6e-24829-0 |
495abc0470147bad4228c1a4e12e7d52237b6317 | Amount of donation or nature and value if donation in kind: donation of £18,500 to employ a member of staff in my Westminster office | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2012-04-16-8f616a6e-24829-0 |
558c28cff8d5e21a48bf0e323cc69f431fbc8499 | Date of receipt: 14 April 2011 | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2012-04-16-8f616a6e-24829-0 |
b622bce363a50a54121847679758fef80c6160f3 | Date of acceptance: 14 April 2011 | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 5 | 2012-04-16-8f616a6e-24829-0 |
113ed63071784d32bf27c1efe0106990fb08a555 | (Registered 5 May 2011) | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 7 | 2012-04-16-8f616a6e-24829-0 |
384867a86af5abd71f12971ca6e73138ce882f41 | Name of donor: Gloucester Research Ltd | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2012-04-16-8f616a6e-24829-0 |
2125f2ca64f2362e69a12e56151431d9900e50b9 | Address of donor: Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 9 | 2012-04-16-8f616a6e-24829-0 |
61ccbeb7bba7ffe399b888d1ede04bdfc0ead31e | Amount of donation or nature and value if donation in kind: donation of £25,500 to employ a member of staff in my Westminster office | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 10 | 2012-04-16-8f616a6e-24829-0 |
473b5c521919464c500227746a85ad535af72662 | Date of receipt: 24 November 2011 | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2012-04-16-8f616a6e-24829-0 |
6099bd6c6fb19169c986c51b2aca1fd49e739ff7 | Date of acceptance: 24 November 2011 | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2012-04-16-8f616a6e-24829-0 |
c44a6036e72c2f4860b4b87e1a411edfa51e59e0 | Donor status: company, registration 04267560 | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 13 | 2012-04-16-8f616a6e-24829-0 |
8a2eca02dfdd1afabbd513888ff5427a47395990 | (Registered 14 December 2011) | Sponsorships 8f616a6e | 2012-04-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 14 | 2012-04-16-8f616a6e-24829-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");