items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where "date" is on date 2018-12-17 and person_id = "uk.org.publicwhip/person/25360" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
7aef7b56600ed0950405b5f668d7b2cbaf34cb0b | Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing opinion surveys: | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 0 | 2018-12-17-10057ffd-25360-0 | |
dbe8df1c4001ffe9019fef486dbb4799288063b3 | 17 November 2017, received £75. Hours: 30 mins. (Registered 04 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 1 | 2018-12-17-10057ffd-25360-0 | |
82f823fb6e5069f097933e9877e57ef004fe2cbd | 2 February 2018, received £100. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 2 | 2018-12-17-10057ffd-25360-0 | |
47e17f89f3b429e2515424170ac9ddb5c9226afa | 14 March 2018, received £75. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 3 | 2018-12-17-10057ffd-25360-0 | |
53680c1ae50a7f64ec53fa5bb03a705517766613 | 16 March 2018, received £75. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 4 | 2018-12-17-10057ffd-25360-0 | |
6d5c1c5adda30d12477a6148b118d8015ef1a6f6 | 22 May 2018, received £75. Hours: 1 hr. (Registered 25 May 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 5 | 2018-12-17-10057ffd-25360-0 | |
37e761235266187c6ab37df3cc06637250740b8d | 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-17 | William Wragg uk.org.publicwhip/person/25360 | 6 | 2018-12-17-10057ffd-25360-0 | |
e45bff4633009b80462382661e8547f0a58693b5 | 23 July 2018, received £75. Hours: 30 mins. (Registered 13 August 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 7 | 2018-12-17-10057ffd-25360-0 | |
f305ef5d7f8857507f8e78c3369d1c907fe0ace6 | 13 September 2018, received £100. Hours: 1 hr. (Registered 15 October 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 8 | 2018-12-17-10057ffd-25360-0 | |
625f6f499036b95a6479c11ee80b27e1d59b62f4 | 25 October 2018, received £75. Hours: 30 mins. (Registered 05 November 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 9 | 2018-12-17-10057ffd-25360-0 | |
158bd478f626df13301c821a7c7d0f8c7b1d91f6 | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing surveys: | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 10 | 2018-12-17-10057ffd-25360-0 | |
d61c254733ba574a48994ea54e0505bdf2d910b8 | 4 December 2017, received £200 for Winter 2017 Survey. Hours: 1 hr. (Registered 13 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 11 | 2018-12-17-10057ffd-25360-0 | |
dfd1a0c8aab270e11b720c6a8dc9ca80d79d8a4b | 25 July 2018, received £200 for Summer 2018 Survey. Hours: 1.5 hrs. (Registered 31 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 12 | 2018-12-17-10057ffd-25360-0 | |
fe390c3e2f9c65f7be30e9b191112cce72650c98 | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing opinion surveys: | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 0 | 2018-12-17-10057ffd-25360-1 | |
38441cd978a67a7804de968cf5a93034b4c06387 | 31 March 2017, payment of £25. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 1 | 2018-12-17-10057ffd-25360-1 | |
c6a9791ab2f3c898f71fcc149526317a76e4344f | 19 April 2017, payment of £20. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 2 | 2018-12-17-10057ffd-25360-1 | |
f615b0915ca049cce28346ee51937fc32151cd02 | 25 April 2017, received £20. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 3 | 2018-12-17-10057ffd-25360-1 | |
6a9ce57e69f9cc98fff14ccb83f6b9074f21a841 | 28 May 2017, payment of £60. Hours: 30 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 4 | 2018-12-17-10057ffd-25360-1 | |
43224095dabca19492bfcba0017e372b49d77f36 | 26 July 2017, payment of £30. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 5 | 2018-12-17-10057ffd-25360-1 | |
069e90dfef9b9bd4450f40a1ecbd3d452f91c169 | 1 September 2017, payment of £40. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 6 | 2018-12-17-10057ffd-25360-1 | |
9f18bf37d8eea69ca323dd6fd24b3b79af74803f | 30 October 2017, received £100. Hours: 1 hr. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 7 | 2018-12-17-10057ffd-25360-1 | |
d6b0c18d8cd4a11d218e3e71d896195d748fcfe1 | 7 November 2017, received £40. Hours: 15 mins. (Registered 01 December 2017) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 8 | 2018-12-17-10057ffd-25360-1 | |
3525aa1b5321b3c81e48e15296dff0fdbbcb70f5 | 20 December 2017, received £60. Hours: 30 mins. (Registered 09 January 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 9 | 2018-12-17-10057ffd-25360-1 | |
3d014d7d670c0dcd057066553e4448e4c24a735e | 10 January 2018, received £30. Hours: 15 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 10 | 2018-12-17-10057ffd-25360-1 | |
e3caf9cc6cf718e5a616516ab3f87a66eb43142f | 22 January 2018, received £100. Hours: 1 hr. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 11 | 2018-12-17-10057ffd-25360-1 | |
eb05a24cc72219838d59dbed2e97b99a0624322c | 9 March 2018, received £60. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 12 | 2018-12-17-10057ffd-25360-1 | |
15990e989dbabc7d27a15740bf87942b94e53ecd | 9 May 2018, received £70. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 13 | 2018-12-17-10057ffd-25360-1 | |
b20339dc55d7a2445a07688c052ba62414cef505 | 13 June 2018, received £80. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 14 | 2018-12-17-10057ffd-25360-1 | |
e9ce5a6e52e819b1af5b3130ab799fbb9fa5ea03 | 9 July 2018, received £70. Hours: 30 mins. (Registered 10 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 15 | 2018-12-17-10057ffd-25360-1 | |
9d96f3e86e7a8a2f73ebad664f33e59dfc6c02ea | 30 July 2018, received £100. Hours: 1 hr. (Registered 13 August 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 16 | 2018-12-17-10057ffd-25360-1 | |
e38b5d5b867a609a0c63b73808244d70b8d11436 | 1 October 2018, received £60. Hours: 30 mins. (Registered 15 October 2018) | Employment and earnings 10057ffd | 2018-12-17 | William Wragg uk.org.publicwhip/person/25360 | 17 | 2018-12-17-10057ffd-25360-1 |
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");