items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2018-06-18-10057ffd-11506-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0607218f8e0bd206b7e9c66e8ecfec030ea9a525 | Payments from ANMFS Ltd, Northcliffe House, 2 Derry Street, Kensington, London W8 5TT: | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 0 | 2018-06-18-10057ffd-11506-0 | |
0002260c66624e6b9c63f8cccd831179a17340bc | 10 August 2017, received £600 for article published in Mail on Sunday. Hours: 2 hrs. (Registered 14 August 2017) | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 1 | 2018-06-18-10057ffd-11506-0 | |
fc00b699d60347d70b437fdea723440f98182935 | 25 October 2017, received £200 for article published in Mail on Sunday. Hours: 2 hrs. (Registered 25 October 2017) | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 2 | 2018-06-18-10057ffd-11506-0 | |
98e23a6b9481db10dfa47e02ec2e009059bad876 | 15 November 2017, received £300 for article published in Mail on Sunday. Hours: 2 hrs. (Registered 16 November 2017) | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 3 | 2018-06-18-10057ffd-11506-0 | |
5105748eb6c7c28253dd9dc9292e4964f0f7bbd2 | 8 January 2018, received £600 for article published in Mail on Sunday. Hours: 3 hrs. (Registered 08 January 2018) | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 4 | 2018-06-18-10057ffd-11506-0 | |
e254bb56346fc8f20b2b5056aa6a13ce67f5b095 | 22 May 2018, received £600 for article published in Mail on Sunday. Hours: 3 hrs. (Registered 22 May 2018) | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 5 | 2018-06-18-10057ffd-11506-0 | |
e036d6050c89a0e50aaef253548082943ae7bff6 | 3 November 2017, received payment of £192 from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT, for article published in Sunday Telegraph. Hours: 2 hrs. (Registered 06 November 2017) | Employment and earnings 10057ffd | 2018-06-18 | David Jones uk.org.publicwhip/person/11506 | 6 | 2018-06-18-10057ffd-11506-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");