items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where person_id = "uk.org.publicwhip/person/24741" and sort_order = 19 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2e58951c1b843b9744d6da1d89269b75fa77e14f | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for opinion surveys. All payments donated to North West Leicestershire Conservative Association. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-10-17 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-10-17-10057ffd-24741-0 | |
1936117a4ef0168f114522a9714c78700648b465 | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for opinion surveys. All payments donated to North West Leicestershire Conservative Association. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-10-03 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-10-03-10057ffd-24741-0 | |
8db358fd4464395ea2317771132d5ab3eac190c4 | 23 November 2015, received £50 for survey completed 27 October 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-07-11 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-07-11-10057ffd-24741-0 | |
971b8aa3e409d42b556b17f8a1bf3fd30da7d605 | 23 November 2015, received £50 for survey completed 27 October 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-06-27 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-06-27-10057ffd-24741-0 | |
b23159273b03efbaa4524b6e3dda83dc5fa18cd3 | 23 November 2015, received £50 for survey completed 27 October 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-06-06 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-06-06-10057ffd-24741-0 | |
df2d1e69f5b0f7a6f67d52a9ff6638dfbb1587a2 | 23 November 2015, received £50 for survey completed 27 October 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-02-22 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-02-22-10057ffd-24741-0 | |
b808d61abdbd7e91f3a0e35634b0267b1e8ad539 | 6 November 2015, received £50 for survey completed 4 November 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-02-08 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-02-08-10057ffd-24741-0 | |
0002c833d520e285ce4fad33801d7675f4fa59ef | 6 November 2015, received £50 for survey completed 4 November 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-01-25 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-01-25-10057ffd-24741-0 | |
e126b1d8cc18cc7367ea72cbfe24405d8a59521a | 23 November 2015, received £50 for survey completed 27 October 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2016-01-11 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2016-01-11-10057ffd-24741-0 | |
0eb02f1d1c22f841837ce99c40a50b48ac3b0166 | 6 November 2015, received £50 for survey completed 4 November 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2015-12-14 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2015-12-14-10057ffd-24741-0 | |
c0b319e4f767b75d62d031291df0b87e744b66db | 6 November 2015, received £50 for survey completed 4 November 2015. Hours: 30 mins. (Registered 26 November 2015) | Employment and earnings 10057ffd | 2015-11-30 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2015-11-30-10057ffd-24741-0 | |
0aa8f0153028bc68b55697f0d901f8fd49d9feb3 | 23 December 2011, payment of £7,773. Hours: 6hrs. (Registered 23 December 2011) | Directorships 1aeb07b2 | 2012-01-13 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 19 | 2012-01-13-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");