items

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

18 rows where record_id = "2020-09-01-10057ffd-25386-0" sorted by sort_order

View and edit SQL

Suggested facets: date (date)

hash item category_id date member_id person_id sort_order ▼ record_id
f3fc4d505772c6c49f554a0a12c3aa7d829177b3 Payments from Savanta ComRes, 4 Millbank, Westminster, London SW1P 3JA, for completing parliamentary panel surveys: Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 0 2020-09-01-10057ffd-25386-0
e6c96c4fab4e72da0569a6c8c3a1299600970476 18 January 2019, received £75 for November 2018 Parliamentary Panel Survey. Hours: 30 mins. (Registered 25 September 2019) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 1 2020-09-01-10057ffd-25386-0
ee6712932d9d09e982be7eb8801d23c7668edcdf 16 May 2019, received £75 for March 2019 Parliamentary Panel Survey. Hours: 30 mins. (Registered 25 September 2019) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 2 2020-09-01-10057ffd-25386-0
02fd8888b939330ce14800288db8b788513a6fda 26 July 2019, received £75 for April 2019 Parliamentary Panel Survey. Hours: 30 mins. (Registered 25 September 2019) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 3 2020-09-01-10057ffd-25386-0
733922c832e51460465c48d27f54f484eca298eb 30 August 2019, received £150 for May & June 2019 Parliamentary Panel Survey. Hours: 1 hr. (Registered 25 September 2019) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 4 2020-09-01-10057ffd-25386-0
cfe62822b24e3f649895202130f627928e34e585 9 December 2019, payment of £75 for a survey. Hours: 30 mins. (Registered 02 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 5 2020-09-01-10057ffd-25386-0
6ea2113e09d14c2e17259473fa2aab6cfcd9beb1 Payments from Ipsos MORI, 3 Thomas More Square, London, E1W 1YW, for completing opinion surveys: Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 6 2020-09-01-10057ffd-25386-0
23968628e8e6ff08bb6a346afda2b6062ee3dded 12 August 2019, received £200 for summer 2019 survey. Hours: 1 hr. (Registered 05 September 2019) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 7 2020-09-01-10057ffd-25386-0
7dfee23943546c4b4f0ac9669b467cf774e09436 16 March 2020, received £200. Hours: 1 hr. (Registered 14 April 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 8 2020-09-01-10057ffd-25386-0
fd6e90a94ed9d94c1d7329778d626b97cdf3caf2 Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing surveys: Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 9 2020-09-01-10057ffd-25386-0
a834c9b108d07d30a98b65dbb0324e21d99f2e98 15 January 2019, received £70 for December online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 10 2020-09-01-10057ffd-25386-0
e4b13b651fa4de25982c7758928aa37de889389e 6 February 2019, received £30 for January online survey. Hours: 15 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 11 2020-09-01-10057ffd-25386-0
363865145cec806c5f1f56ed067d18c3f51d5f78 27 March 2019, received £50 for March online survey. Hours: 15 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 12 2020-09-01-10057ffd-25386-0
229d33806068b316112b10a746934657b5b80acf 19 June 2019, received £80 for May online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 13 2020-09-01-10057ffd-25386-0
57cd770cf97bdb659f4f9b2343864448e3c30962 16 August 2019, received £40 for July online survey. Hours: 15 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 14 2020-09-01-10057ffd-25386-0
60a472cae774a2b4ca2703ac01a412f9c5f02d68 9 December 2019, received £60 for October online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 15 2020-09-01-10057ffd-25386-0
3e05eaef4ff709ddf1f0220c0c46c0bec3e5f22a 9 December 2019, received £100 for October online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 16 2020-09-01-10057ffd-25386-0
27d78dcd859518efdfd02bbf7de1c5a9c124a86a 12 February 2020, received £110 for January online survey. Hours: 1 hr. (Registered 11 March 2020) Employment and earnings 10057ffd 2020-09-01   Daniel Zeichner uk.org.publicwhip/person/25386 17 2020-09-01-10057ffd-25386-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");
Powered by Datasette · Query took 17.756ms · Data source: mySociety Data · About: simonw/register-of-members-interests