items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2016-06-27-10057ffd-10075-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 |
---|---|---|---|---|---|---|---|
f81977677afde7c42c6d8e72c290a1aef7384712 | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA. All payments made to Westminster North Labour Party: | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 0 | 2016-06-27-10057ffd-10075-0 | |
2492ff237e952a1a19785075a1fcb7aa1bdd1207 | June 2014, received £75 for a Parliamentary Panel Survey. Hours: 1 hr. (Registered 08 June 2015) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 1 | 2016-06-27-10057ffd-10075-0 | |
d44b79f2e57ed07947ee048e57372e25c627cf24 | July 2014, received £75 for a Parliamentary Panel Survey. Hours: 1 hr. (Registered 08 June 2015) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 2 | 2016-06-27-10057ffd-10075-0 | |
b3634d66c64ccb5c61d25e3853df518f392dffbe | August 2014, received £75 for a Parliamentary Panel Survey. Hours: 1 hr. (Registered 08 June 2015) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 3 | 2016-06-27-10057ffd-10075-0 | |
d5badc4f4068c4cd98c1ab319c4d1e929e17827e | October 2014, received £75 for a Parliamentary Panel Survey. Hours: 1 hr. (Registered 08 June 2015) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 4 | 2016-06-27-10057ffd-10075-0 | |
542f4dee06d1234b0a9b671e2873521e184a7efe | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing surveys: | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 5 | 2016-06-27-10057ffd-10075-0 | |
caeeef805208a1a8e455dcb7b50130f2539e877c | 2 June 2014, received £75 for an online survey. Hours: 1 hr. (Registered 08 June 2015) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 6 | 2016-06-27-10057ffd-10075-0 | |
d3814822c86b80a4cb4eb2e76acd0482fe08753f | Payments from Ipsos MORI, 79-81 Borough Road, London SE1 1FY, for opinion surveys. All payments made to Westminster North Labour Party: | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 7 | 2016-06-27-10057ffd-10075-0 | |
b0340879de3da8fc9acc11590cd888b915259b80 | 16 January 2015, received £200 for an online survey. Hours: 1 hr. (Registered 08 June 2015) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 8 | 2016-06-27-10057ffd-10075-0 | |
1cb000f7f8fad9f22a31f33ac8505b385c46531c | 5 February 2016, received £200 for an opinion survey. Hours: 1 hr. (Registered 19 February 2016) | Employment and earnings 10057ffd | 2016-06-27 | Karen Buck uk.org.publicwhip/person/10075 | 9 | 2016-06-27-10057ffd-10075-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");