items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2012-02-20-1aeb07b2-24741-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 |
---|---|---|---|---|---|---|---|
326c55afee020114b98e42dde5985b81f63ed8de | 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 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2012-02-20-1aeb07b2-24741-0 |
ebdcfbf019d0e8cad6ef0034e4ffde505bd1bb75 | 18 February 2011, payment of £7,773. Hours: 6 hrs. (Registered 18 March 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2012-02-20-1aeb07b2-24741-0 |
e7644823ab0536e5d1fdd181f48d9ce5283dbf9f | 18 March 2011, payment of £7,773. Hours: 6 hrs. (Registered 18 March 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 2 | 2012-02-20-1aeb07b2-24741-0 |
29df1dc47267c5e3da1c56f49c061f05e69b9147 | 15 April 2011, payment of £7,773. Hours: 6 hrs. (Registered 19 April 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2012-02-20-1aeb07b2-24741-0 |
9aee504060768f7dca234251c601503cc6fc1cdc | 13 May 2011, payment of £7,773. Hours: 6 hrs. (Registered 23 May 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 4 | 2012-02-20-1aeb07b2-24741-0 |
c4d883122cbb8bd291ed07ea626550346c24a54e | 10 June 2011, payment of £7,773. Hours: 6 hrs. (Registered 13 June 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 5 | 2012-02-20-1aeb07b2-24741-0 |
9c4f5f534533eb048417c042c8e4f6952396fbc2 | 18 July 2011, payment of £7,773. Hours: 6 hrs . (Registered 5 August 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2012-02-20-1aeb07b2-24741-0 |
1abe9a917a6934cea8b158fb7261591c68acde1f | 5 August 2011, payment of £7,773. Hours: 6 hrs . (Registered 5 August 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2012-02-20-1aeb07b2-24741-0 |
20d4e2dce129df0a0abe7c9770a1eb3cdc270fbd | 2 September 2011, payment of £7,773. Hours: 6 hrs. (Registered 2 September 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2012-02-20-1aeb07b2-24741-0 |
c6f24af9f3f78997ebaa49bf580d7d7cd977132a | 30 September 2011, payment of £7,773. Hours: 6 hrs. (Registered 30 September 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 9 | 2012-02-20-1aeb07b2-24741-0 |
cf6f2535d8e3dfae6ddcc635a1ca171f9b10ccd8 | 28 October 2011, payment of £7,773. Hours: 6 hrs. (Registered 3 November 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 10 | 2012-02-20-1aeb07b2-24741-0 |
b0970feb959b2432594cc641863e8d3ddaff2b39 | 25 November 2011, payment of £7,773. Hours: 6 hrs. (Registered 28 November 2011) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 11 | 2012-02-20-1aeb07b2-24741-0 |
009065997e9c2b602d824a64857a487db0788750 | 23 December 2011, payment of £7,773. Hours: 6 hrs. (Registered 23 December 2011 | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 12 | 2012-02-20-1aeb07b2-24741-0 |
071b5df4627207284ff8deed5050a6176beb0d26 | 20 January 2012, payment of £7,773. Hours: 6 hrs. (Registered 20 January 2012) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 13 | 2012-02-20-1aeb07b2-24741-0 |
d5fe4ab19a7872d75d84775a5032ab797047cb57 | 17 February 2012, Payment of £7,773. Hours: 6 hrs. (Registered 20 February 2012) | Directorships 1aeb07b2 | 2012-02-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 14 | 2012-02-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");