items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2015-06-08-10057ffd-11541-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 |
---|---|---|---|---|---|---|---|
bae83ef887234c18c631f30d676c40f3b16ad912 | Practice at the Bar of England and Wales | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 0 | 2015-06-08-10057ffd-11541-0 | |
baa6c3624580bde090173fb3b42b907a148a1c24 | Messrs. Janes, solicitors. Address: 17 Waterloo Place, London SW17 4AR: | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 1 | 2015-06-08-10057ffd-11541-0 | |
6037f97d607ce2af084e8127bcb0618b739e2db7 | Received £105,750 for legal services provided between 1 March 2014 and 30 June 2014. Hours: 160 hrs. (Registered 15 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 2 | 2015-06-08-10057ffd-11541-0 | |
86ac75486f875004b76776a81efb0f9654fd30e8 | Received £73,095 for legal services provided between 1 September 2013 and 30 January 2014. Hours: 450 hrs. (Registered 15 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 3 | 2015-06-08-10057ffd-11541-0 | |
d8637e442136404a651e0060a294523dbaf72f8f | Received £136,200 for legal services provided between 1 May 2014 and 31 August 2014. Hours: 200 hrs. (Registered 15 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 4 | 2015-06-08-10057ffd-11541-0 | |
89528cadc27c4a3e615894339682f6028bd04e69 | Messrs. Travers, Thorp, Alberga, Attorneys. Address: Harbour Place, 2nd Floor, 103 South Church Street, Grand Cayman. | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 5 | 2015-06-08-10057ffd-11541-0 | |
60619816418cc7e615b22d3129f3baeac5874484 | Received £20,000 for legal services provided between 1 July 2014 and 31 August 2014. Hours: 40 hrs. (Registered 15 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 6 | 2015-06-08-10057ffd-11541-0 | |
1065036069d82d7923bb74274a638192aee7456f | Received £77,500 for legal services provided between 1 July 2014 and 10 October 2014. Hours: 250 hrs. (Registered 15 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 7 | 2015-06-08-10057ffd-11541-0 | |
adc2769e36df1a3d74f75c4697ebd7d6a5d15ae4 | Received £40,000 from Messrs. Khakhar and Co. Solicitors, for legal services provided between 1 April 2014 and 31 July 2014. Address: 8 Cranbrook Road, Iford IG1 4DJ. Hours: 30 hrs. (Registered 15 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | Geoffrey Cox uk.org.publicwhip/person/11541 | 8 | 2015-06-08-10057ffd-11541-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");