items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2020-10-12-10057ffd-25360-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
3da638a87ea12ebbe1c236c68074fadd2d2da5a9 | Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing opinion surveys: | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 0 | 2020-10-12-10057ffd-25360-0 | |
aa56da3fbaee1e7ae161df3fb790b3cdd90a872c | 29 March 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 1 | 2020-10-12-10057ffd-25360-0 | |
325492c26e0b50e88c1d21b1f80fccdf84d435c4 | 29 July 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 2 | 2020-10-12-10057ffd-25360-0 | |
e3921833ae2dbf410e57a4ce2223d83df132b91c | 24 October 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 3 | 2020-10-12-10057ffd-25360-0 | |
f02793b7368839bfe12f138e83b9a020528fe31f | 25 October 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 4 | 2020-10-12-10057ffd-25360-0 | |
19599ffbcc931279f4a2977ced65bfd83ece2ae2 | 15 November 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 5 | 2020-10-12-10057ffd-25360-0 | |
b8087f8a7a558bb0c102e2f16fa3ac67bf74a1f4 | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing surveys: | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 6 | 2020-10-12-10057ffd-25360-0 | |
b9c789f5d719bd54db1db55264357012c4f7d97c | 17 February 2020, received £200. Hours: 1 hr. (Registered 24 February 2020) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 7 | 2020-10-12-10057ffd-25360-0 | |
0848eb6eca42235ce24f0eb376dc8e3b1de242d3 | 5 August 2020, received £250. Hours: 2 hrs. (Registered 17 August 2020) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 8 | 2020-10-12-10057ffd-25360-0 | |
97947e8b15ce6a6ebd0ac5eded91ce4db2918354 | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing opinion surveys: | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 9 | 2020-10-12-10057ffd-25360-0 | |
0afc72ed3d54b1d326e7be3f64ceb2ed4b678bb0 | 23 October 2019, received £60. Hours: 30 mins. (Registered 28 October 2019) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 10 | 2020-10-12-10057ffd-25360-0 | |
6d7c0a6a288aaf7216b76998d5f16ac215dcd95d | 9 December 2019, received £60. Hours: 30 mins. (Registered 07 January 2020) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 11 | 2020-10-12-10057ffd-25360-0 | |
70ca0dbbba4980f6d96fe1b3ba0a71abffd8f284 | 09 December 2019, received £100. Hours: 1 hr. (Registered 07 January 2020) | Employment and earnings 10057ffd | 2020-10-12 | William Wragg uk.org.publicwhip/person/25360 | 12 | 2020-10-12-10057ffd-25360-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");