items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2014-01-20-1aeb07b2-24741-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 |
---|---|---|---|---|---|---|---|
bec87e6276a3c99fe41ac4651a689d52918839d1 | AB produce PLC (non-executive chairman); fresh vegetable processing and distribution. Address: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. I attend board meetings once a month and communicate with the managing director weekly. | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2014-01-20-1aeb07b2-24741-0 |
011eac869e44e0df0107e13873888dc527aad5ef | 15 February 2013, payment of £7,773. Hours: 12 hrs. (Registered 15 February 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2014-01-20-1aeb07b2-24741-0 |
f54c64226300bd3ab16a60229934bc6898762508 | 15 March 2013, payment of £7,773. Hours: 12 hrs. (Registered 15 March 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 2 | 2014-01-20-1aeb07b2-24741-0 |
b758890da4900abbe6da7b26d0e05c3cd534f148 | 12 April 2013, payment of £7,773. Hours: 12 hrs. (Registered 12 April 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2014-01-20-1aeb07b2-24741-0 |
06076de5988bcfd55f56156abc559d669c88a70c | 10 May 2013, payment of £7,773. Hours: 12 hrs. (Registered 13 May 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 4 | 2014-01-20-1aeb07b2-24741-0 |
f0d182d7485135694e0af16d4c3014ea6368a402 | 7 June 2013, payment of £7,773. Hours: 12 hrs. (Registered 10 June 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 5 | 2014-01-20-1aeb07b2-24741-0 |
f97636a3ed85d808196e22f829063ed41b0bf002 | 5 July 2013, payment of £7,773. Hours: 12 hrs. (Registered 5 July 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2014-01-20-1aeb07b2-24741-0 |
1e0d658b82fe3acef4a9aa6f01a086061d17eb7a | 2 August 2013, payment of £7,773. Hours: 12 hrs. (Registered 2 August 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2014-01-20-1aeb07b2-24741-0 |
29a2a812232b119dbdba3b31bfd75ce6b667d803 | 30 August 2013, payment of £7,773. Hours: 12 hrs. (Registered 30 August 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2014-01-20-1aeb07b2-24741-0 |
8fb94f26e8d2ad127c9e0b988a7682f469f1e837 | 27 September 2013, payment of £7,773. Hours: 12 hrs. (Registered 27 September 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 9 | 2014-01-20-1aeb07b2-24741-0 |
debd92abd7e6058c63143849ac2b8bbea27b6cf7 | 25 October 2013, payment of £7,773. Hours: 12 hrs. (Registered 25 October 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 10 | 2014-01-20-1aeb07b2-24741-0 |
4acc84eb5e44ef9728cdbf4f1c974a54fcf6eee9 | 22 November 2013, payment of £7,773. Hours: 12 hrs. (Registered 22 November 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 11 | 2014-01-20-1aeb07b2-24741-0 |
357fc74157faf1ba669af6c215749ae297ca7290 | 20 December 2013, payment of £7,773. Hours: 12 hrs. (Registered 20 December 2013) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 12 | 2014-01-20-1aeb07b2-24741-0 |
a072cc1cd294431de7fb92520ced13dad8247dc7 | 17 January 2014, payment of £7,773. Hours: 12 hrs. (Registered 17 January 2014) | Directorships 1aeb07b2 | 2014-01-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 13 | 2014-01-20-1aeb07b2-24741-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");