items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2015-03-30-1aeb07b2-10470-1" 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 |
---|---|---|---|---|---|---|---|
17241e4e40da174a74cf3d6988427693b0b699e0 | Non-executive Director of Camgrain Ltd, from 1 November 2013. Address: London Road, Balsham, Cambridge CB21 4HH. Fee £5001-£10,000 a year. Commitment of 10 days a year. (Registered 5 November 2013) | Directorships 1aeb07b2 | 2015-03-30 | James Paice uk.org.publicwhip/member/40545 | James Paice uk.org.publicwhip/person/10470 | 0 | 2015-03-30-1aeb07b2-10470-1 |
8b8eb1dfd7accc9749506f6abd2ec22690421db2 | Received director’s fee of £1,000 for January 2014. Hours: 1 day. (Registered 7 May 2014) | Directorships 1aeb07b2 | 2015-03-30 | James Paice uk.org.publicwhip/member/40545 | James Paice uk.org.publicwhip/person/10470 | 1 | 2015-03-30-1aeb07b2-10470-1 |
b2abfce64be6b021788b6bb3aacebd197d7967db | Received director’s fee of £1,000 for February 2014. Hours: 1 day. (Registered 7 May 2014) | Directorships 1aeb07b2 | 2015-03-30 | James Paice uk.org.publicwhip/member/40545 | James Paice uk.org.publicwhip/person/10470 | 2 | 2015-03-30-1aeb07b2-10470-1 |
9145f0c03fac51c856a542810a08eaaf3f052185 | Received director’s fee of £1,000 for March 2014. Hours: 1 day. (Registered 7 May 2014) | Directorships 1aeb07b2 | 2015-03-30 | James Paice uk.org.publicwhip/member/40545 | James Paice uk.org.publicwhip/person/10470 | 3 | 2015-03-30-1aeb07b2-10470-1 |
1ca079ec40c10fb00c447ff81b4aeee0cc120d5c | Received director’s fee of £1,000 for April 2014. Hours: 1 day. (Registered 7 May 2014) | Directorships 1aeb07b2 | 2015-03-30 | James Paice uk.org.publicwhip/member/40545 | James Paice uk.org.publicwhip/person/10470 | 4 | 2015-03-30-1aeb07b2-10470-1 |
2ee03059c21512a8668032305eaff7960b9ad730 | Received director’s fee of £1,000 for May 2014. Hours: 1 day. (Registered 7 May 2014) | Directorships 1aeb07b2 | 2015-03-30 | James Paice uk.org.publicwhip/member/40545 | James Paice uk.org.publicwhip/person/10470 | 5 | 2015-03-30-1aeb07b2-10470-1 |
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");