items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2019-11-05-10057ffd-10259-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 |
---|---|---|---|---|---|---|---|
9b1fd447c091ba598984ffb4588a7a10cb5e007f | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys: | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2019-11-05-10057ffd-10259-0 | |
0567c9d1a3e8d3054e3e38299e93b8eddfde417c | 26 November 2018, payment of £75 for September 2018 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to charity. (Registered 27 November 2018) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2019-11-05-10057ffd-10259-0 | |
62faaf9079b758c6be8c6a6d2d4bb5fde83d8e16 | 2 January 2019, payment of £75 for October 2018 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to charity. (Registered 30 May 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2019-11-05-10057ffd-10259-0 | |
f8bd9a2484e528ccdb0a2d3ec6569f6188ec84a1 | 25 January 2019, payment of £75 for November 2018 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to Delyn Constituency Labour Party. (Registered 30 May 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2019-11-05-10057ffd-10259-0 | |
a2a75ab328bc3084e8b8acad5c9ca241f3d33f81 | 5 April 2019, payment of £75 for January 2019 Parliamentary Panel Survey. Hours: 45 mins. (Registered 30 May 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2019-11-05-10057ffd-10259-0 | |
41a94ddd79c8a29951276e2ef7053ebb3d3bb11b | 20 May 2019, payment of £75 for March 2019 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to charity. (Registered 30 May 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2019-11-05-10057ffd-10259-0 | |
cd8b3610d262c490875f7d8670c6ca4f582ed609 | 20 May 2019, payment of £75 for another March 2019 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to charity. (Registered 30 May 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2019-11-05-10057ffd-10259-0 | |
cd6f1a6ad03a841c79d33fe0ed5b961155deaffc | 12 August 2019, payment of £75 for April 2019 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to charity. (Registered 12 August 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2019-11-05-10057ffd-10259-0 | |
d20049aee5e9be02b0d73584049d613188fe534d | 9 Sept 2019, payment of £150 for May and June 2019 parliamentary panel surveys. Hours: 45 mins. Fee donated to charity. (Registered 11 September 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 8 | 2019-11-05-10057ffd-10259-0 | |
ac74f1ea7eb0e14477c6390b227f7fa22126ef43 | 31 October 2019, payment of £75 for September 2019 Parliamentary Panel Survey. Hours: 45 mins. Fee donated to charity. (Registered 05 November 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 9 | 2019-11-05-10057ffd-10259-0 | |
12208a1cb232d45a7cff2484f1618d4c17c10cdf | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing surveys: | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 10 | 2019-11-05-10057ffd-10259-0 | |
aa9231eaf8e886f26eb09f2134be7d0e2b891411 | 2 August 2019, payment of £200. Hours: 45 mins. Fee donated to Delyn Constituency Labour Party. (Registered 02 August 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 11 | 2019-11-05-10057ffd-10259-0 | |
6a4bd4b3c86fe5461c2c08dff7a78d6c0b7c164a | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing surveys: | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 12 | 2019-11-05-10057ffd-10259-0 | |
4c561e9b39847a6a30ed2cae830b667e18d1767a | 26 November 2018, payment of £100. Hours: 45 mins. Fee donated to charity. (Registered 27 November 2018) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 13 | 2019-11-05-10057ffd-10259-0 | |
9f82dd370772dc735947ada73cde3038b629d190 | 12 December 2018, payment of £100. Hours: 45 mins. Fee donated to charity. (Registered 13 December 2018) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 14 | 2019-11-05-10057ffd-10259-0 | |
35e88fb751707bf93fe7d8985790f1f3758e0e5d | 2 January 2019, payment of £70. Hours: 45 mins. Fee donated to charity. (Registered 08 April 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 15 | 2019-11-05-10057ffd-10259-0 | |
c48ec3ce6119d380cd2662f446dbad085628099a | 22 January 2019, payment of £70. Hours: 45 mins. Fee donated to charity. (Registered 08 April 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 16 | 2019-11-05-10057ffd-10259-0 | |
f48a112b63b9daf4af6f7454f4528d612f5af14d | 25 January 2019, payment of £100. Hours: 45 mins. Fee donated to charity. (Registered 08 April 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 17 | 2019-11-05-10057ffd-10259-0 | |
6ac1cd3d2e1d4038e53a0f1f8d590a5781586944 | 26 February 2019, payment of £30. Hours: 45 mins. Fee donated to charity. (Registered 08 April 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 18 | 2019-11-05-10057ffd-10259-0 | |
0d89d3055fa8e42a9ba34c30b41d1d6282e12472 | 5 April 2019, payment of £50. Hours: 45 mins. Fee donated to charity. (Registered 08 April 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 19 | 2019-11-05-10057ffd-10259-0 | |
324084a5d99e529afa60c53f1d028820c2c585ec | 17 May 2019, payment of £60. Hours: 45 mins. Fee donated to charity. (Registered 17 May 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 20 | 2019-11-05-10057ffd-10259-0 | |
e70e37991353d33e65f961af2d78d479905c3a4a | 28 June 2019, payment of £80. Hours: 45 mins. Fee donated to charity. (Registered 01 July 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 21 | 2019-11-05-10057ffd-10259-0 | |
1e2beaad0233441440c1dd8f40eb4c0c333c214d | 25 July 2019, payment of £80. Hours: 45 mins. Fee donated to charity. (Registered 29 July 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 22 | 2019-11-05-10057ffd-10259-0 | |
f1ab07e758139968a62007c421faf8bf76f1d72b | 20 August 2019, payment of £40. Hours: 45 mins. Fee donated to charity. (Registered 20 August 2019) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 23 | 2019-11-05-10057ffd-10259-0 | |
f4c4c10855ba6f135514fa5335d9bce60618a7b2 | Payments from Populus, 10 Northburgh Street, London EC1V 0AT: | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 24 | 2019-11-05-10057ffd-10259-0 | |
fecc9cfb111babf65441c70113723fc29f69e7e1 | 10 December 2018, payment of £50 for October-November 2018 MP Panel Survey. Hours: 15 mins. Fee donated to charity. (Registered 12 December 2018) | Employment and earnings 10057ffd | 2019-11-05 | David Hanson uk.org.publicwhip/person/10259 | 25 | 2019-11-05-10057ffd-10259-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");