items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where person_id = "uk.org.publicwhip/person/10045" and sort_order = 21 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 |
---|---|---|---|---|---|---|---|
d9a5b42696df57018024109fb9c8f50fa70ef21e | 17 January 2019, payment of £200 from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for a survey. Hours: 45 mins. Fee paid direct to my constituency party. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-29 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-07-29-10057ffd-10045-0 | |
355654ae7cc3e8e5563c89f09ba1d1226b81585d | 17 January 2019, payment of £200 from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for a survey. Hours: 45 mins. Fee paid direct to my constituency party. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-07-15-10057ffd-10045-0 | |
214d4ef64db0828529d7ededf144b459054a41f8 | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-03-18 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-03-18-10057ffd-10045-0 | |
6eef126c4146046a25ad62ed3598efa8d6b7e913 | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-03-04 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-03-04-10057ffd-10045-0 | |
32fa1e9d7cf507fb465d3598e671ea41fced60ac | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-02-18 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-02-18-10057ffd-10045-0 | |
7b3c1f1d868a03c6690a5d5045f7589c54836344 | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-02-04 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-02-04-10057ffd-10045-0 | |
ac05fed198763a337f689c9a8a8840ac8dd55d1c | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-01-21 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2019-01-21-10057ffd-10045-0 | |
9dd4c038e4f72dc7bfaa1a65b458cf5fa86c8a4c | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2018-12-17-10057ffd-10045-0 | |
2a2e27c3787c1ecced9a4f4554a7e2828097bfd6 | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2018-12-03-10057ffd-10045-0 | |
de41cf7cb6a13a231b4556ff2c8d5605e370f585 | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2018-11-19 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2018-11-19-10057ffd-10045-0 | |
488aea206b859ce30ffa6f82aebd44356fb04b69 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2018-01-22 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2018-01-22-10057ffd-10045-0 | |
1d0df62454038c55c531cd5aac33badb16f437d7 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2018-01-08 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2018-01-08-10057ffd-10045-0 | |
ee442850a7628bd7b5a4fb0e9503c5af74586f80 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-12-11 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-12-11-10057ffd-10045-0 | |
a9600e0bca93258593e112d7283449902a809d13 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-11-27 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-11-27-10057ffd-10045-0 | |
36fe5cee94f1ebd5ac9cfd631f1d6b68acc01f3d | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-11-13 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-11-13-10057ffd-10045-0 | |
a0193eff397ad7744e096fa24726f77cd8dea893 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-08-29 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-08-29-10057ffd-10045-0 | |
62edb1c6cbcbe56fff75d263bf9b8e5b8e6ed4aa | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-07-31 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-07-31-10057ffd-10045-0 | |
07e042c173857431c7fc3bf17f48790c43b20fa0 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-07-07 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-07-07-10057ffd-10045-0 | |
e9d552f026ece272bcb95dbfde632fc44e69f1ee | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-05-02-10057ffd-10045-0 | |
b4a0f8a84b09ee0aa940ed1640e6ddc153522be6 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-04-10 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-04-10-10057ffd-10045-0 | |
9b716d7f6b9fc7c0d5cd224430c83415f6e6968a | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-03-20 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-03-20-10057ffd-10045-0 | |
cf35dddf3396b4e0efe70dabe26f6ab76cd0873a | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-03-06 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-03-06-10057ffd-10045-0 | |
b9859d971f7b3a61da560bd89685cef874442d17 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-02-20-10057ffd-10045-0 | |
101b9cadba8e42de37a92c6b33b21ce5cf23344b | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-02-06 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-02-06-10057ffd-10045-0 | |
924c2b42a6b85961216ec6690d50cb66e091a203 | 14 December 2016, received £60. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-01-23 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2017-01-23-10057ffd-10045-0 | |
123d8c0ac6bf0e50eb112efa062951600eaa8584 | 18 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2012-01-30-1f359ece-10045-0 |
048042a39a29393523c0e996150b713c9a9122d3 | 18 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 21 | 2012-01-13-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");