items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2018-10-29-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 |
---|---|---|---|---|---|---|---|
0f79a12553d2210883ebe345f6a1fe6ff1aa3b6c | Payments from ComRes, Four Millbank, London SW1P 3JA: | Employment and earnings 10057ffd | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2018-10-29-10057ffd-13934-0 | |
256e389292904761bac013b5bc07cb74cc71c81c | 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 | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 1 | 2018-10-29-10057ffd-13934-0 | |
8a704aa7dd424d0a3f8949f9356b98dc928be51e | 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 | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2018-10-29-10057ffd-13934-0 | |
99105166b8b74af5ba53edf50636f10258d0d27d | 11 January 2018, received £100 for completing November 2017 opinion survey. Hours: 30 mins. Fee paid to local community organisation. (Registered 19 April 2018) | Employment and earnings 10057ffd | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2018-10-29-10057ffd-13934-0 | |
28f269692e7dcd71f1af4ccc7f79fa6bdfa26b2a | 5 February 2018, received £100 for completing January 2018 opinion survey. Hours: 30 mins. Fee paid to local community organisation. (Registered 19 April 2018) | Employment and earnings 10057ffd | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2018-10-29-10057ffd-13934-0 | |
f79a526ed6a6fb66ab62ae2f399b2cb284c1bda9 | 19 March 2018, received £75 for completing February 2018 opinion survey. Hours: 30 mins. Fee paid to local community organisation. (Registered 19 April 2018) | Employment and earnings 10057ffd | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2018-10-29-10057ffd-13934-0 | |
0808943037f70222649b555869cbb8658aac83ca | 19 April 2018, received £75 for completing March 2018 opinion survey. Hours: 30 mins. Fee paid to local community organisation. (Registered 19 April 2018) | Employment and earnings 10057ffd | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2018-10-29-10057ffd-13934-0 | |
5c721dad9237712b3227be3af9d625c54438d17b | 8 June 2018, received £75 for completing an opinion survey. Hours: 30 mins. Fee paid to local community organisation. (Registered 20 June 2018) | Employment and earnings 10057ffd | 2018-10-29 | Virendra Sharma uk.org.publicwhip/person/13934 | 7 | 2018-10-29-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");