items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2015-11-09-10057ffd-10045-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
68025410ab037b4d72e4aea22c95095b44045ce2 | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys. All fees are paid direct to my constituency party: | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 0 | 2015-11-09-10057ffd-10045-0 | |
8f4b1135ae2428695ee2d5b8a36b874a69fcf238 | March 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 1 | 2015-11-09-10057ffd-10045-0 | |
6d49a8dac177a71b3b18b0a2e80ed50c47e70a10 | April 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 2 | 2015-11-09-10057ffd-10045-0 | |
1431bc5a488f78e4b4bff57366b6659d963f97e5 | May 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 3 | 2015-11-09-10057ffd-10045-0 | |
09db77e02d90bb17e36a9501f37dc3425508a336 | June 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 4 | 2015-11-09-10057ffd-10045-0 | |
31dab8c196d146a26e79ac2c1c6c838e7307a8f6 | October 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 5 | 2015-11-09-10057ffd-10045-0 | |
5f6451ccdb42a493c27a888f6b0c9c225a74150c | November 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 6 | 2015-11-09-10057ffd-10045-0 | |
3ac8ea4e7e606511a735d60e3eb252e563eeafba | December 2014, received £75. Hours: 30 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 7 | 2015-11-09-10057ffd-10045-0 | |
5290f99090f76406e07838db70a88d05c5a60f0c | 9 February 2015, received £100. Hours 30 mins. (Registered 26 March 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 8 | 2015-11-09-10057ffd-10045-0 | |
f2a7a1f88b6b4bfed924f2a2b3431d2574f6d8aa | 24 February 2015, received £75. Hours 30 mins (Registered 26 March 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 9 | 2015-11-09-10057ffd-10045-0 | |
952b012d9ed8eeb9230bf8a217b91ca272d57a5f | April 2015, received £75. Hours 30 mins (Registered 13 May 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 10 | 2015-11-09-10057ffd-10045-0 | |
bb7546c21a9729743e15e757d0508ca8b229e989 | 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 | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 11 | 2015-11-09-10057ffd-10045-0 | |
eab8ddf5d22ad605e32eed9cbeada4b7ad372cbd | January 2015, received £200. Hours: 45 mins. (Registered 26 January 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 12 | 2015-11-09-10057ffd-10045-0 | |
bfe6d4f8aaea0ede039a4b45036272e0a37ea6b2 | Payment from YouGov, 50 Featherstone Street, London EC17 8RT: | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 13 | 2015-11-09-10057ffd-10045-0 | |
a85f5a6e6d7cf45767685dbd95b6a24db3c24215 | April 2015, received £100. Hours: 30 mins. (Registered 13 May 2015) | Employment and earnings 10057ffd | 2015-11-09 | Clive Betts uk.org.publicwhip/person/10045 | 14 | 2015-11-09-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");