items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2011-04-18-1aeb07b2-24785-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0047fa0b1ca6b0e4cedb609b12aeaec4da7bca26 | Payment of £1,000. Hours: 22.5 hrs. (Registered 27 January 2011) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 9 | 2011-04-18-1aeb07b2-24785-0 |
196d3bc01f34707d4acc678a70eae424b1188185 | Payment of £1,000. Hours: 22.5 hrs. (Registered 22 September 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 4 | 2011-04-18-1aeb07b2-24785-0 |
753e4318f0c6d77c32f33a485a5cea459d8240a6 | Social Investment Business, 5th Floor, 6 St Andrew Street, London EC4A 3AE; investing in charities and social enterprises. Three days per month chairing Investment Committee for Futurebuilders Fund and as Vice Chair of the Board. | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 0 | 2011-04-18-1aeb07b2-24785-0 |
8774da8b83248d052d28b8216d5e9398132920f9 | Payment of £1,000. Hours: 22.5 hrs. (Registered 15 December 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 7 | 2011-04-18-1aeb07b2-24785-0 |
9aab55025d978fbeb25418d1c45dfcac136f11bf | Payment of £1,000. Hours: 22.5 hrs. Registered 8 October 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 5 | 2011-04-18-1aeb07b2-24785-0 |
b2b04e796aca253bfbf7e9fcffd4b0cd1ba2cd07 | Payment of £1,000. Hours: 22.5 hrs. (Registered 22 July 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 3 | 2011-04-18-1aeb07b2-24785-0 |
c041411ca59534a69498649bdee06b7af9e16ec1 | Payment of £1,000. Hours: 22.5 hrs. (Registered 11 January 2011) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 8 | 2011-04-18-1aeb07b2-24785-0 |
de97a1a3a2e05394846e76ab3a22cfe91c83590c | Payment of £1,000. Hours: 22.5 hrs. (Registered 28 June 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 2 | 2011-04-18-1aeb07b2-24785-0 |
e011f28119faf42cc3566d86d2e9771215bea77b | Payment of £1,000. Hours: 22.5 hrs. (Registered 6 April 2011) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 10 | 2011-04-18-1aeb07b2-24785-0 |
fd5a9de6627ad91983e4c6e19afe586e81d234ab | Payment of £1,000. Hours: 22.5 hrs. (Registered 19 May 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 1 | 2011-04-18-1aeb07b2-24785-0 |
ff9d95f34a61d0d16660240ba4524832403e8ad7 | Payment of £1,000. Hours: 22.5 hrs. Registered 28 October 2010) | Directorships 1aeb07b2 | 2011-04-18 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 6 | 2011-04-18-1aeb07b2-24785-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");