items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2019-07-15-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 |
---|---|---|---|---|---|---|---|
e64263ce5ffbbcc10e9f315a99109976ec02d4c1 | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys. All fees are paid direct to my constituency party: | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 0 | 2019-07-15-10057ffd-10045-0 | |
84fde0fc9553746a1bd0c6f4cd33cb1afd72be8e | 19 March 2018, payment of £75. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 1 | 2019-07-15-10057ffd-10045-0 | |
e9175eeda18efa37d17b7765621d7ef3e92171e6 | 2 April 2018, payment of £50. Hours: 20 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 2 | 2019-07-15-10057ffd-10045-0 | |
a93c9e231c6789ee37aa65f3eefaad5da9988d5a | 20 April 2018, payment of £75. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 3 | 2019-07-15-10057ffd-10045-0 | |
75d711555505773ed3505afb944f00049f98b268 | 28 May 2018, payment of £75. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 4 | 2019-07-15-10057ffd-10045-0 | |
9f6c01d233b599aae616182403c2cbc8ab3a8dc4 | 23 July 2018, payment of £75. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 5 | 2019-07-15-10057ffd-10045-0 | |
230272e067614aa5c336b1ca34d887f34fa5eb13 | 6 September 2018, payment of £75. Hours: 30 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 6 | 2019-07-15-10057ffd-10045-0 | |
a92846e5d357724dfdaa8253bab71648be989259 | 29 October 2018, payment of £75. Hours: 30 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 7 | 2019-07-15-10057ffd-10045-0 | |
69bd471761a7ba523624dc413f7032e428133bbf | 17 December 2018, payment of £75. Hours: 30 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 8 | 2019-07-15-10057ffd-10045-0 | |
cbf1de2dbb346692818c88fe7cd6b85b35261336 | 8 February 2019, payment of £150. Hours: 45 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 9 | 2019-07-15-10057ffd-10045-0 | |
efffcad81d3747c5bded234817853b1247731255 | 16 May 2019, payment of £150. Hours: 45 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 10 | 2019-07-15-10057ffd-10045-0 | |
e5fcedf4364f73ee07e9a0c96175236bfa075540 | 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 | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 11 | 2019-07-15-10057ffd-10045-0 | |
0013677b78524f4871247d06f78954ce648d797f | 15 February 2018, payment of £60. Hours: 20 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 12 | 2019-07-15-10057ffd-10045-0 | |
15b6166be14b1f95dea70dfc96197ad5f4161937 | 21 March 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 13 | 2019-07-15-10057ffd-10045-0 | |
f4b331f4a74693322902e22502ebb8de05e56f64 | 8 May 2018, payment of £80. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 14 | 2019-07-15-10057ffd-10045-0 | |
4636121187c3d7c132a5fd3e54e8298dfe6756b9 | 20 June 2018, payment of £20. Hours: 15 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 15 | 2019-07-15-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 | |
931e4e4bbae145bc3b131a7b46f8a8a7d5d5b35e | 25 July 2018, payment of £100. Hours: 30 mins. (Registered 12 July 2019) | Employment and earnings 10057ffd | 2019-07-15 | Clive Betts uk.org.publicwhip/person/10045 | 17 | 2019-07-15-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 | |
13601cfe5184e77cc93013a9cefd3f1ab9a82852 | 20 September 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 | 19 | 2019-07-15-10057ffd-10045-0 | |
46defbc2bb7d3286cd03fbeba031d2b9f896684d | 16 October 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 | 20 | 2019-07-15-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 |
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");