items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
48 rows where person_id = "uk.org.publicwhip/person/10045" and sort_order = 18 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 |
---|---|---|---|---|---|---|---|
344e1ab4d25a8fb28c71380e3f6764c6a7403b30 | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-01-23 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-01-23-10057ffd-10045-0 | |
6796c39355087796dfcfb714257f6b7bef047452 | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-02-06 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-02-06-10057ffd-10045-0 | |
69ec6746b40ce7a618e6038e1eb7c04d413b34f2 | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-02-20-10057ffd-10045-0 | |
38f26bda6d63801117e6867cd8a68a204b985aee | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-03-06 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-03-06-10057ffd-10045-0 | |
4c576f4c9391c0dbe035a3282447ddf6d8507f9c | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-03-20 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-03-20-10057ffd-10045-0 | |
869186a209e23d301e6904402bb53bb5bff5729a | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-04-10 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-04-10-10057ffd-10045-0 | |
af0aa0fc928db1ba794fe18e15f763f7927a877d | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-05-02-10057ffd-10045-0 | |
182d4bd33de8d6c85fd1184423d402769341a86b | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-07-07 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-07-07-10057ffd-10045-0 | |
9b942c9b49a9b5ba758cc9c14afd11bc99d3099a | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-07-31 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-07-31-10057ffd-10045-0 | |
15a90f88109bdefc07f7b6b7fa1f77f7054fca2b | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-08-29 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-08-29-10057ffd-10045-0 | |
a29835f082a65def5dd199d95a5bbda3f41039fa | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-11-13 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-11-13-10057ffd-10045-0 | |
0650a53481d705e5db65b26acaa3b1451d452d31 | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-11-27 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-11-27-10057ffd-10045-0 | |
8237db92923a0fe0d215c564c736656166af00f0 | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-12-11 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2017-12-11-10057ffd-10045-0 | |
6d5cdab6401b47abe15ebdb37aa1a73cb0bb52fa | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2018-01-08 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-01-08-10057ffd-10045-0 | |
b2b5a67fb814461053a1a61e553d74673851a6f7 | 17 June 2016, received £40. Hours: 20 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2018-01-22 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-01-22-10057ffd-10045-0 | |
9d55153d852d61dc4d1e476704460845d41f5ce3 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-03-05 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-03-05-10057ffd-10045-0 | |
bb88e2832a2214f30a2c11567a0b85e761010cdd | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-03-19 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-03-19-10057ffd-10045-0 | |
68aa5d2c7aa736da0d48342384deded6a60ef422 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-04-16 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-04-16-10057ffd-10045-0 | |
c6a4c87f82159a8074f600f9de3cf076e8f96936 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-04-30 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-04-30-10057ffd-10045-0 | |
103c2a3cd4ad0713a504bb65ef59f2ee23129d93 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-05-14 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-05-14-10057ffd-10045-0 | |
3774ef70acbc6da59cf7ced56f076248e1f65cfe | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-06-04 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-06-04-10057ffd-10045-0 | |
e7b214f9528a75dc0156635ca0e8862b6bc967e4 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-06-18 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-06-18-10057ffd-10045-0 | |
327a500920dfc8af6567c717acc85ace4f108403 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-07-16 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-07-16-10057ffd-10045-0 | |
fea36789448e32d8083df36f5e3a0374d824d189 | 26 July 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 | 18 | 2018-08-13-10057ffd-10045-0 | |
6cb2d3fdfb4a2c3d6bdc09d5c100882b1b7e6856 | 26 July 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 | 18 | 2018-09-10-10057ffd-10045-0 | |
b79414e17a6b0b52a5c33213a324118ebf601e3f | 26 July 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 | 18 | 2018-10-01-10057ffd-10045-0 | |
7536cee35f35c32138a1f2d1751b51e57bcf9708 | 26 July 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 | 18 | 2018-10-15-10057ffd-10045-0 | |
e7b6922c266fc0dd8b31f425a539cafa50088f87 | 26 July 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 | 18 | 2018-10-29-10057ffd-10045-0 | |
b1b5ddecbf9f5ffed6718a5384e6dd5ee38811b6 | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-11-19 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-11-19-10057ffd-10045-0 | |
9b3f8528046349e73d6463d6e7213a3ca88d74c4 | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-12-03 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-12-03-10057ffd-10045-0 | |
9209ad3fef0c60dfa6499b2a0289751724b9e167 | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-12-17 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2018-12-17-10057ffd-10045-0 | |
ba6eff6f0cf65a7f1b664c6075a019c740645fab | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-01-21 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-01-21-10057ffd-10045-0 | |
d3c5ae39a198aeb014d8682557a2b3124f938090 | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-02-04 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-02-04-10057ffd-10045-0 | |
cf0cb53a1498c9a7862dab221f325050ac165582 | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-02-18 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-02-18-10057ffd-10045-0 | |
acd1f44de6692f466a6f1666174114c4ddf12337 | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-03-04 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-03-04-10057ffd-10045-0 | |
506eda111f3fa3d411b23bf3d292356ba1f1fdfb | 20 December 2017, payment of £30. Hours: 15 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2019-03-18 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-03-18-10057ffd-10045-0 | |
5cbd9b642c4cddbb45904a7839759f9eb0af723d | 22 August 2018, payment of £60. Hours: 20 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-07-15-10057ffd-10045-0 | |
8b25255205019793c6c8a79e3e8aeb522d9c7e95 | 22 August 2018, payment of £60. Hours: 20 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-29 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2019-07-29-10057ffd-10045-0 | |
affe514cbccf47c43df24bb0f1f54481126f2b8a | £50 for September 2010 survey. Hours: 15 mins | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-01-13-1f359ece-10045-0 |
89ef40b16341ee0974efd65e31aa5adf3a4312e8 | £50 for September 2010 survey. Hours: 15 mins | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-01-30-1f359ece-10045-0 |
d89aff9890c356ade922a54c3ef7d1cb14feb79d | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-09-03-1f359ece-10045-0 |
ce2b2589513afc66adb55e57d719722ebe3b0af3 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-10-01-1f359ece-10045-0 |
17dcd43ab0bee1a0fd26b9d79f9417c36edf3485 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-10-22-1f359ece-10045-0 |
55d9e5031cdb188c69a14031dab9e679e263810a | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-11-05-1f359ece-10045-0 |
0591eb82629e24da509d9224a4ef038b33441ace | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-11-19 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-11-19-1f359ece-10045-0 |
1cc3575bd41aebacb9ac604e34f57458c16b9eb9 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-12-03-1f359ece-10045-0 |
60f33cdb9a3466f4d4ca950043657cd057b79623 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-12-19-1f359ece-10045-0 |
1b3322c094f3b0977c6cf46b38dcaefb89a38643 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 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");