items

Table actions

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

7 rows where record_id = "2014-11-10-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
38eaa212201e864eb7e10151a6f77f5fcbb822a5 Employed as part-time dental surgeon for Beresford Dental Practice Limited, 207 Upper Richmond Road, SW15 6SQ: Remunerated employment, office, profession etc 1f359ece 2014-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 0 2014-11-10-1f359ece-10041-0
18d6add9fc9d7a41ca5d97437dd969ac079023a0 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-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 1 2014-11-10-1f359ece-10041-0
529b62653cd72335eb3ec80b479af7b13b6d9260 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-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 2 2014-11-10-1f359ece-10041-0
9ae2149602a3c7c8d876770747c9339fc023f494 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-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 3 2014-11-10-1f359ece-10041-0
f269c3a719f93585fcf339bab3997540af1a20ae 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-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 4 2014-11-10-1f359ece-10041-0
f88c6e8804fb16040dca87452a6bdd05d743035d 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-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 5 2014-11-10-1f359ece-10041-0
893161b89e28ea9271cae4e4313a7f1b0625e143 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-11-10 Paul Beresford uk.org.publicwhip/member/40406 Paul Beresford uk.org.publicwhip/person/10041 6 2014-11-10-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");