items

Table actions

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

3 rows where record_id = "2017-05-02-10057ffd-11621-1" 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
c632a2d2b8764afd75e1feaaea5de32ebd219aec Payments from Head of Zeus, Clerkenwell House, 45-47 Clerkenwell Green, London EC1R 0HT, via Ed Victor ltd, 6 Bayley Street, London, WC1B 3HE: Employment and earnings 10057ffd 2017-05-02   Douglas Carswell uk.org.publicwhip/person/11621 0 2017-05-02-10057ffd-11621-1
adcaac6fd0d5d5d765d8583105d1969da2053857 15 November 2016, received £2,733 as an advance on signature for a book. Hours: several hundred over past six months. (Registered 22 November 2016) Employment and earnings 10057ffd 2017-05-02   Douglas Carswell uk.org.publicwhip/person/11621 1 2017-05-02-10057ffd-11621-1
83afc299951794ab927083a0848e5be242f91757 27 January 2017, received £2,733 as an on delivery advance for a book. Hours: no additional hours. (Registered 06 February 2017) Employment and earnings 10057ffd 2017-05-02   Douglas Carswell uk.org.publicwhip/person/11621 2 2017-05-02-10057ffd-11621-1

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