items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where "date" is on date 2018-12-03 and person_id = "uk.org.publicwhip/person/25360" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
611d83ceee6eaf70bda0915813ee71e6a36b8cdc | Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing opinion surveys: | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 0 | 2018-12-03-10057ffd-25360-0 | |
7470404cda481a94c55eabcc3dcc138d17f87edf | 17 November 2017, received £75. Hours: 30 mins. (Registered 04 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 1 | 2018-12-03-10057ffd-25360-0 | |
b3ae805b5d16b7f0dcbca49e7d5682e6b134d125 | 2 February 2018, received £100. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 2 | 2018-12-03-10057ffd-25360-0 | |
ef2ccaa0953f11b57bdaa79d693919463e379c6b | 14 March 2018, received £75. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 3 | 2018-12-03-10057ffd-25360-0 | |
28746332665ce9521d13e33e9efad9921dd80bcc | 16 March 2018, received £75. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 4 | 2018-12-03-10057ffd-25360-0 | |
13c87b1faaf52c80747110afba82183593f0c785 | 22 May 2018, received £75. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 5 | 2018-12-03-10057ffd-25360-0 | |
bc75fd488ee96a3f314a6af280fd980b93f6f6fe | 25 June 2018, received £75 for a survey completed on 30 May 2018. Hours: 30 mins. (Registered 03 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 6 | 2018-12-03-10057ffd-25360-0 | |
1ac01d1a5ff5306fc4c3e0cd0d61f0e14b620a83 | 23 July 2018, received £75. Hours: 30 mins. (Registered 13 August 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 7 | 2018-12-03-10057ffd-25360-0 | |
4443aa80da4d451166bc73e479ba94d48f214e5f | 13 September 2018, received £100. Hours: 1 hr. (Registered 15 October 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 8 | 2018-12-03-10057ffd-25360-0 | |
e47e83c852c7015f9ff7dad31002d2ff105287fd | 25 October 2018, received £75. Hours: 30 mins. (Registered 05 November 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 9 | 2018-12-03-10057ffd-25360-0 | |
aa742e6af7114e592dfe872160c1138918dc7518 | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing surveys: | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 10 | 2018-12-03-10057ffd-25360-0 | |
f5aa7d4d4ba50028a2f20a4f6038b89e37cd71e3 | 4 December 2017, received £200 for Winter 2017 Survey. Hours: 1 hr. (Registered 13 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 11 | 2018-12-03-10057ffd-25360-0 | |
e64e2e7c7655da132e7b30c58e268cbbd21885d5 | 25 July 2018, received £200 for Summer 2018 Survey. Hours: 1.5 hrs. (Registered 31 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 12 | 2018-12-03-10057ffd-25360-0 | |
18487c12cb57a6f3898faad99c31ee0f5f9a446a | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing opinion surveys: | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 13 | 2018-12-03-10057ffd-25360-0 | |
13e6dcfe428a6f8ec1fa5af3d26101d14c59ddcd | 31 March 2017, payment of £25. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 14 | 2018-12-03-10057ffd-25360-0 | |
1707757186e6693810d26947f12779a92a9b6651 | 19 April 2017, payment of £20. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 15 | 2018-12-03-10057ffd-25360-0 | |
4e9edddf7b146ce6c041cf3c904223f7880d8045 | 25 April 2017, received £20. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 16 | 2018-12-03-10057ffd-25360-0 | |
8d05b1b23fe1040c185313a7ff041041f58069e6 | 28 May 2017, payment of £60. Hours: 30 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 17 | 2018-12-03-10057ffd-25360-0 | |
098d28d72d7c2f619941906d17e4029f2b56a6fc | 26 July 2017, payment of £30. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 18 | 2018-12-03-10057ffd-25360-0 | |
00dceeb06f5e2afece649a768d2595f8cc8f8cfc | 1 September 2017, payment of £40. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 19 | 2018-12-03-10057ffd-25360-0 | |
4326a804103123cd31bf2f19a892c01cabc10b3e | 30 October 2017, received £100. Hours: 1 hr. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 20 | 2018-12-03-10057ffd-25360-0 | |
09522d97a651c78cfe4da797d8e42307953a1ee8 | 7 November 2017, received £40. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 21 | 2018-12-03-10057ffd-25360-0 | |
d56ae2e4498f300f6979c5894d81a480da642085 | 20 December 2017, received £60. Hours: 30 mins. (Registered 09 January 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 22 | 2018-12-03-10057ffd-25360-0 | |
5759bba9daba0a4f00164d840e5c0cd05d3de051 | 10 January 2018, received £30. Hours: 15 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 23 | 2018-12-03-10057ffd-25360-0 | |
21fc5a5e4d443eb5e16f52d58dba18253a8485c1 | 22 January 2018, received £100. Hours: 1 hr. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 24 | 2018-12-03-10057ffd-25360-0 | |
9236bdccfe3cd3dc34145b307a27998218efd75b | 9 March 2018, received £60. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 25 | 2018-12-03-10057ffd-25360-0 | |
baa79b6df85372a85214a7be2b0cb368fdaf7b74 | 9 May 2018, received £70. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 26 | 2018-12-03-10057ffd-25360-0 | |
975815077f5d1024cc0741b9af17dc1e595b20bb | 13 June 2018, received £80. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 27 | 2018-12-03-10057ffd-25360-0 | |
55cd759a838b59173d29216f26ebdf9548487e57 | 9 July 2018, received £70. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 28 | 2018-12-03-10057ffd-25360-0 | |
5bcc32aad51543c2dd3accc5c1705efc351974db | 30 July 2018, received £100. Hours: 1 hr. (Registered 13 August 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 29 | 2018-12-03-10057ffd-25360-0 | |
f59d1cedc276ba8ccf1b0eb8d363a8edcbd1ee4c | 1 October 2018, received £60. Hours: 30 mins. (Registered 15 October 2018) | Employment and earnings 10057ffd | 2018-12-03 | William Wragg uk.org.publicwhip/person/25360 | 30 | 2018-12-03-10057ffd-25360-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");