items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2017-03-20-10057ffd-24877-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
9c5948f53eee505c0ad791f0d1fdfbb294eb5993 | Payments from Ipsos Mori, 79-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 0 | 2017-03-20-10057ffd-24877-0 | |
a12bfc6a7d38569d258f6995c10abbe807a925e2 | 12 August 2016, payment of £200 for survey completed on 5 July 2016. Hours: 90 mins. Fee paid direct to local charity. (Registered 06 September 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 1 | 2017-03-20-10057ffd-24877-0 | |
0f36a20572d0789886c949dde872964121cc9b2f | Payments from ComRes, Four Millbank, London SW1P 3JA, for completing surveys. All fees are paid direct to charity. (Registered 27 July 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 2 | 2017-03-20-10057ffd-24877-0 | |
051ed8432dc45f1e42f5791d9bf4e989d6acedb7 | 14 January 2016, payment of £75 for November/December 2015 Survey. Hours: 1 hr. (Registered 27 July 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 3 | 2017-03-20-10057ffd-24877-0 | |
45cdc0574d19a8d60292625d1b26e5ac5fac6a93 | 8 April 2016, payment of £100 for January 2016 Survey. Hours: 1 hr. (Registered 27 July 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 4 | 2017-03-20-10057ffd-24877-0 | |
4bd5222a8e92b4e41c6f9cc82fc33d6cba627864 | 9 May 2016, payment of £75 for February 2016 Survey. Hours: 30 mins. (Registered 27 July 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 5 | 2017-03-20-10057ffd-24877-0 | |
e247e8d98ba0fd5612becba61edef6d6f63b7e00 | 22 July 2016, payment of £75 for April/Mary 2016 Survey. Hours: 1 hr. (Registered 27 July 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 6 | 2017-03-20-10057ffd-24877-0 | |
7ee1fbf5b4dd170badbd872828dd53b3017fa7e9 | Payment of £75 expected for a survey completed on 22 September 2016. Hours: 45 mins. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 7 | 2017-03-20-10057ffd-24877-0 | |
a0f660a0702e705f8eb6375db8e82e61d64b02b4 | Payment of £50 expected for a survey completed on 27 October 2016. Hours: 20 mins. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-03-20 | David Nuttall uk.org.publicwhip/person/24877 | 8 | 2017-03-20-10057ffd-24877-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");