items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where "date" is on date 2007-02-27 and record_id = "2007-02-27-9e46def6-10637-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
cb0bc6ee42aa29876d5075f908ee31b7f3dd3837 | Financial support paid to my Research Account has been received from: | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 0 | 2007-02-27-9e46def6-10637-0 |
2861a5c10fae95688318faf5539166d850344149 | Mr David Lloyd, of Lloyd's (Animal) Feeds Ltd, Shropshire | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 2 | 2007-02-27-9e46def6-10637-0 |
00086ba4a105410e2b9e44b4a76be38f82d1238b | (Registered 30 March 2006) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 3 | 2007-02-27-9e46def6-10637-0 |
06c09f058cc3c036e91f35e2e5d68dfcccdda903 | Mr Ian Armitage, businessman (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 4 | 2007-02-27-9e46def6-10637-0 |
7b1f3252ada38b8b8f64b82a30305db1c51a57c0 | (Registered 10 January 2007) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 5 | 2007-02-27-9e46def6-10637-0 |
c9e07ffc04d7ca38c7f337d76c1212838d91a026 | Lord Ashcroft provided research assistance through Media Intelligence Partners. | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 6 | 2007-02-27-9e46def6-10637-0 |
caae37bb9b5136ce27c819faa2d5ae88b3b22838 | (Registered 23 May 2006) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 7 | 2007-02-27-9e46def6-10637-0 |
e1c83d7818032a450e2ed65fda8b5924d040069b | Sir John Beckwith is providing, through Conservative Central Office, a donation to assist the employment of an education researcher. (Registered 23 May 2006) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | David Willetts uk.org.publicwhip/member/1623 | David Willetts uk.org.publicwhip/person/10637 | 8 | 2007-02-27-9e46def6-10637-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");