items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2017-05-02-10057ffd-10045-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 |
---|---|---|---|---|---|---|---|
9a1c2b0cb7cc3915abe11dd62f0b96be256e2af2 | Payments from Ipsos MORI, 79-81 Borough Road, London SE1 1FY for opinion surveys. All fees are paid direct to my constituency party: | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 0 | 2017-05-02-10057ffd-10045-0 | |
3a567f3fc06239f71ad77cbe934e0e0df9f690cf | 18 November 2015, received £200. Hours: 45 mins. (Registered 01 August 2016) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 1 | 2017-05-02-10057ffd-10045-0 | |
a4514953f53d78680e645b1f641645b87ff3ca58 | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys. All fees are paid direct to my constituency party: | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 2 | 2017-05-02-10057ffd-10045-0 | |
a3b492567408e1dd255b77e80fed32656f7abfa4 | 20 September 2015, received £75. Hours 30 mins. (Registered 01 August 2016) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 3 | 2017-05-02-10057ffd-10045-0 | |
21d484a6041f004e20c2d2b5a115605cfd73b3ac | 22 October 2015, received £75. Hours 30 mins. (Registered 01 August 2016) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 4 | 2017-05-02-10057ffd-10045-0 | |
f3786acfe6118a6421109ae6ef06d596b04beee7 | 25 November 2015, received £75. Hours 30 mins. (Registered 01 August 2016) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 5 | 2017-05-02-10057ffd-10045-0 | |
5df6d6e81bb4426187a29d72298b6eb5bde2d1b6 | 8 March 2016, received £50. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 6 | 2017-05-02-10057ffd-10045-0 | |
fe74782ffe9e22a02fa93e75665a6ae73fccc116 | 8 April 2016, received £100. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 7 | 2017-05-02-10057ffd-10045-0 | |
4b70bb0b38ce7f9227accc31d4bd31dd4a48ff49 | 9 May 2016, received £75. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 8 | 2017-05-02-10057ffd-10045-0 | |
d2d0bd3227b53c563b20eed433ae3e0e779c3c14 | 30 June 2016, received £50. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 9 | 2017-05-02-10057ffd-10045-0 | |
0d722f7b8155851dcc1dab4450551a736e7d3748 | 22 July 2016, received £75. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 10 | 2017-05-02-10057ffd-10045-0 | |
0facc83c7381c915ae2d69f9dc2ad410249c6b79 | 12 October 2016, received £75. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 11 | 2017-05-02-10057ffd-10045-0 | |
9dfc6272a92bdf773a052cde0ddf33577acb2c2d | 9 December 2016, received £75. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 12 | 2017-05-02-10057ffd-10045-0 | |
ff2bdcb35c79172e85eccbe3b7ec612b4c118a19 | 21 December 2016, received £50. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 13 | 2017-05-02-10057ffd-10045-0 | |
d686a34080a4820133990adb3800da0c9ecb6031 | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for opinion surveys. All fees are paid direct to my constituency party: | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 14 | 2017-05-02-10057ffd-10045-0 | |
2a875db86c748763db1aaccb17428f3f4a588f29 | 7 January 2016, received £50. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 15 | 2017-05-02-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 | |
3188380cb8cb96e30b730c0ec955e35d48b8f263 | 6 May 2016, received £80. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 17 | 2017-05-02-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 | |
9e9e67629626a0867c301e5b5f42a253cd4f463b | 3 August 2016, received £80. Hours: approx. 30 mins. (Registered 19 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Clive Betts uk.org.publicwhip/person/10045 | 19 | 2017-05-02-10057ffd-10045-0 | |
f4a2b6d66a6c38d646c206eefef176cc1c2352aa | 25 November 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 | 20 | 2017-05-02-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 |
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");