items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
43 rows where person_id = "uk.org.publicwhip/person/10045" and sort_order = 16 sorted by member_id
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 |
---|---|---|---|---|---|---|---|
5cdbbb446858a7b2fff850ff0773c621c3c2c6b1 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-01-23 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-01-23-10057ffd-10045-0 | |
bf076d57109f9d3cf7900879ae3210a3e6422086 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-02-06 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-02-06-10057ffd-10045-0 | |
7fb20a08c9c495996948bbe1019252859934b744 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-02-20-10057ffd-10045-0 | |
7ff724277e929dbe36e82e87cf56f76b52f09a1d | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-03-06 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-03-06-10057ffd-10045-0 | |
16e7e2dcaae803e3a5d362e23947e4bf63a9043b | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-03-20 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-03-20-10057ffd-10045-0 | |
f4a7626d1fbf05e52174fdf348b7af5805db2dac | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-04-10 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-04-10-10057ffd-10045-0 | |
64f777126ae74c9dff1bb980620078aa03c801fe | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-05-02-10057ffd-10045-0 | |
39638de0af0556c76b382ceec4df814b80c66355 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-07-07 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-07-07-10057ffd-10045-0 | |
ac847861da933e1c3fc8c60e0382ef43faf52e55 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-07-31 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-07-31-10057ffd-10045-0 | |
26cd96408cb009b44c7f143f182f0a56f9251f30 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-08-29 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-08-29-10057ffd-10045-0 | |
e7c79bd3d97ac9edab36e0107d8fc817a7725835 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-09-11 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-09-11-10057ffd-10045-0 | |
df0f869132e55e251e401aef797721ac895c208e | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-10-09 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-10-09-10057ffd-10045-0 | |
109b5d219e313cffc5c92162822496c6557104b6 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-10-23 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-10-23-10057ffd-10045-0 | |
fb0c708d54db2bb87388961e93a01b3089e8a832 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-11-13 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-11-13-10057ffd-10045-0 | |
8a2d83af5ddfb1aa510ba6fbcd66ca682ee63e72 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-11-27 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-11-27-10057ffd-10045-0 | |
28fa20e08627fb9fa06c998f82deb39ed1944ae3 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-12-11 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2017-12-11-10057ffd-10045-0 | |
c11ac6f0dd79ee8c3b08115878bd7e86cc1ddc43 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2018-01-08 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-01-08-10057ffd-10045-0 | |
0ae6384467f288ccde9eb5203c6389270dfa5f16 | 23 March 2016, received £20. Hours: 15 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2018-01-22 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-01-22-10057ffd-10045-0 | |
7b5e6706524bad1fbebbbfb6b51bdc990356659c | 21 March 2017, payment of £80. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-08-13 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-08-13-10057ffd-10045-0 | |
0def2faebcd224281fe448c99dd0f2cf3cd0cce3 | 21 March 2017, payment of £80. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-09-10 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-09-10-10057ffd-10045-0 | |
ceb0b6761f10f27cb3953b2d1d004d24fb4af1c0 | 21 March 2017, payment of £80. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-10-01 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-10-01-10057ffd-10045-0 | |
59b017efa5a50e450f1097f928f0f4bd2cead3b7 | 21 March 2017, payment of £80. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-10-15 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-10-15-10057ffd-10045-0 | |
0c7515a5b0dfa1d2cf321e2ed5eb7ce851ae796a | 21 March 2017, payment of £80. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-10-29 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-10-29-10057ffd-10045-0 | |
04e75a32c0eb37bb4b97895febbf5a4199d38fee | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-11-19 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-11-19-10057ffd-10045-0 | |
a12d058aec0d451eb582da053c8c2262df269ef4 | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-12-03 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-12-03-10057ffd-10045-0 | |
0c8e080901956abcd51b8f2ac80533c4c9e5baef | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-12-17 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2018-12-17-10057ffd-10045-0 | |
7d22c941265af74f589201dafb30e2b7146f8eec | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-01-21 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-01-21-10057ffd-10045-0 | |
9eb52d5494749363df6e146ffd12637dc8de8b53 | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-02-04 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-02-04-10057ffd-10045-0 | |
bd176dd6dcda0722a3d70cf568e63a158a80a843 | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-02-18 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-02-18-10057ffd-10045-0 | |
4e1fb24d04d1674cd7cd16343a00d07f55b2e29a | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-03-04 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-03-04-10057ffd-10045-0 | |
5530261f3b1307f2d0cde82443882d6929dcd5ee | 14 November 2017, payment of £100. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-03-18 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-03-18-10057ffd-10045-0 | |
ec7ee841f1de54573b1dba73d39edbe0ab7a362b | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-07-15-10057ffd-10045-0 | |
e1b80562f768837dc5cd39a45358cf0be0ffbe13 | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-29 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2019-07-29-10057ffd-10045-0 | |
1c4c9c75406c4cd1c8ece717393fc1b61407041e | Payments from Populus Ltd, 10 Northburgh Street, London EC1V 0AT, for completing surveys. All payments are donated directly to my constituency party: | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-01-13-1f359ece-10045-0 |
74ad91faeba45ea84cd83201bb351a0f705c7d3f | Payments from Populus Ltd, 10 Northburgh Street, London EC1V 0AT, for completing surveys. All payments are donated directly to my constituency party: | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-01-30-1f359ece-10045-0 |
6059f0a473ac547d74e5a6b6cd4a8a8782f271b1 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-09-03-1f359ece-10045-0 |
83511b66e5561bc2e18317f9edb502f815a93f01 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-10-01-1f359ece-10045-0 |
a3119c7da7e9efb29952f9f55bf6bc9273bcb093 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-10-22-1f359ece-10045-0 |
9dd86f3c310246fed96b15c9b552e9f900e8e23d | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-11-05-1f359ece-10045-0 |
511ee1c3cbf3f27a5de7b2aefbdd8947095caf9c | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-19 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-11-19-1f359ece-10045-0 |
bc0694345113be886dd42ab1408b4380ee318253 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-12-03-1f359ece-10045-0 |
94cd2237da2f794047ced334f9cb137ddcb9be02 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-12-19-1f359ece-10045-0 |
6823690e6c1cbb8ff47f219347a33369840c02a7 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2013-01-18-1f359ece-10045-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");