items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

7 rows where record_id = "2014-10-27-1f359ece-10041-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
ea331f0b92f45f84dc11c6bb72cc422dc196a212 Employed as part-time dental surgeon for Beresford Dental Practice Limited, 207 Upper Richmond Road, SW15 6SQ: Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 0 2014-10-27-1f359ece-10041-0
c7ad865c64337cc11c9c91b104cc87799fa2b038 Fees paid to Beresford Dental Practice for 2012-13, giving net profits of £14,151. I made no drawings from the company during the year. Hours: 400 hrs approx . (Registered 10 October 2013; updated 3 February 2014) Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 1 2014-10-27-1f359ece-10041-0
b6a037c40b129ff12d613b7e2bfc530946301829 Costs of £700 to attend the FMC dental conference on 13 and 14 June 2014 were met by FMC, Hertford House, Farm Close, Shenley, Herts WD7 9AB, in lieu of payment for advice and editorial advice. Hours: 12 hrs . (Registered 24 June 2014) Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 2 2014-10-27-1f359ece-10041-0
7ba5d16c21f8d4fecc90dd92e859a020e43d88c2 Retained as consultant on Professional Indemnity for Lockton Insurance, The St Botolph Bldg, 138 Houndsditch, London EC3A 7AG. Remuneration of £1,000 a month for between 6 and 24 hours each month . Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 3 2014-10-27-1f359ece-10041-0
d8d864cd3a81fa7bdf374ec116b35816f6408d4b January 2014, payment of £6,000 for the six months from April to September 2013. Hours: 48 hrs approx. ( Registered 3 February 2014) Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 4 2014-10-27-1f359ece-10041-0
42f10a91928fa39605cac0a1043cff45020b9a41 March 2014, payment of £4,000 for the four months from October 2013 to January 2014. Hours: 54 hrs approx. ( Registered 9 April 2014) Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 5 2014-10-27-1f359ece-10041-0
15cfdc766b979dbfd06133ea2b7ed8728bd4a77e June 2014, payment of £4,000 for the four months from February 2014 to May 2014. Hours: 54 hrs approx. ( Registered 24 June 2014) Remunerated employment, office, profession etc 1f359ece 2014-10-27 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 6 2014-10-27-1f359ece-10041-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");