items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2017-10-23-10057ffd-13934-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 |
---|---|---|---|---|---|---|---|
ca69a28428b2de0b8d5f0b80579cd47cf379fe29 | Payments from ComRes, Four Millbank, London SW1P 3JA. All payments paid direct to local community organisations. | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2017-10-23-10057ffd-13934-0 | |
00c4e6df3a7db88d10259431663f17323fd9c3c0 | 22 January 2016, payment of £75 for survey completed in November 2015: Hours: 30 mins. (Registered 06 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 1 | 2017-10-23-10057ffd-13934-0 | |
bced3356114c9d739f571fcc7e03695e43bf7c73 | 30 March 2016, payment of £75 for survey completed in January 2016: Hours: 30 mins. (Registered 06 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2017-10-23-10057ffd-13934-0 | |
9ac6b1087916b10747babea7c6f3f7f414ce80ae | 18 May 2016, received £100 for a survey completed in February 2016. Hours: 30 mins. (Registered 06 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2017-10-23-10057ffd-13934-0 | |
227c6ba4d6c37e5f2ae89f592717321f84596e5d | 19 July 2016, payment of £75 for survey completed in April 2016. Hours: 30 mins. (Registered 06 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2017-10-23-10057ffd-13934-0 | |
86df9943bc4445c8a0c6f3bd8bad904c012f880a | 14 October 2016, payment of £75 for survey completed in June 2016. Hours: 30 mins. (Registered 06 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2017-10-23-10057ffd-13934-0 | |
442244f424a8ebac26204a25512f3be65debad9e | 27 October 2016, payment of £75 for survey completed in August 2016. Hours: 30 mins. (Registered 06 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2017-10-23-10057ffd-13934-0 | |
9d1eab3dcb9f9d2e0886543da429cab78474521e | 22 September 2017, payment of £150 for completing February and June 2017 opinion surveys. Hours: 1 hr (30 mins each). Fee paid to local community organisation. (Registered 12 October 2017) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 7 | 2017-10-23-10057ffd-13934-0 | |
e0572a10a25cb8e6bc6e8ec813e947485f19a134 | 23 October 2017, received £75 for completing September 2017 opinion survey. Hours: 30 mins. Fee paid to local community organisation. (Registered 23 October 2017) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 8 | 2017-10-23-10057ffd-13934-0 | |
0f9ae50697b621b4ea09da0d2fbc8381d0fa4d63 | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing opinion surveys: | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 9 | 2017-10-23-10057ffd-13934-0 | |
e2d2e1c1128cde2dbbaf8a0d0432a9889959d0f5 | 7 February 2017, received £200. Hours: 30 mins. Fee paid to local community organisation. (Registered 22 February 2017) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 10 | 2017-10-23-10057ffd-13934-0 | |
a5338c1fce2deaed769fca3b08b58ee8b70e3eb8 | 8 March 2017, received £100. Hours: 30 mins. Fee paid to local community organisation. (Registered 10 March 2017) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 11 | 2017-10-23-10057ffd-13934-0 | |
56ea6020344eefc121b3e6769dd3bbefb7883007 | 5 September 2017, received £200. Hours: 30 mins. Fee paid to local community organisation. (Registered 05 September 2017) | Employment and earnings 10057ffd | 2017-10-23 | Virendra Sharma uk.org.publicwhip/person/13934 | 12 | 2017-10-23-10057ffd-13934-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");