items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2011-02-28-8f616a6e-11036-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 |
---|---|---|---|---|---|---|---|
27413f7a05a51ad8c98efb920e5d16804edfb335 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2011-02-28-8f616a6e-11036-0 |
0d82a22894870da57d9ac7de5e84e1ed68d65613 | Name of donor: Paul Marshall | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2011-02-28-8f616a6e-11036-0 |
d9e22d44473a5ef15fca6da5c3906667a3d6ae28 | Address of donor: private | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2011-02-28-8f616a6e-11036-0 |
c80eb52d1de763ca3f542de21234bd1126b88258 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2011-02-28-8f616a6e-11036-0 |
a9184a43080ed5e237ab6257e028c08ecaa188b8 | Donor status: individual | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2011-02-28-8f616a6e-11036-0 |
b8de80d94e1a489454f2ddea28824a9748af6f62 | Name of donor: Group Silverline | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2011-02-28-8f616a6e-11036-0 |
05c42667cc3de0d94436bd89bc7717f86f8eeb51 | Address of donor: Boundary Way, Lufton Trading Estate, Yeovil Somerset BA22 8HZ | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2011-02-28-8f616a6e-11036-0 |
a2020dec5cb79c105e98b0f2a22c8f67be6ccc62 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 8 | 2011-02-28-8f616a6e-11036-0 |
713411118bb5b850b8f8747e6e405b107b23c843 | Donor status: company | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2011-02-28-8f616a6e-11036-0 |
c2d8c3d46177a68741eb5f43b453cf0ac8ac65b1 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 10 | 2011-02-28-8f616a6e-11036-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");