home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

7 rows where record_id = "2015-03-30-80ef1083-10213-2" 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
91528bbee8cf2d69784c9ef594dc7a1a1e78b09f Name of donor: AIPAC Group Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 0 2015-03-30-80ef1083-10213-2
c2955fa520f854bf2abfe2fde3a4cce209022102 Address of donor: 251 H Street NW Washington, DC 20001 Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 1 2015-03-30-80ef1083-10213-2
5897eb0249d0bb2c32a9cde0ba7fe553c613bca8 Amount of donation (or estimate of the probable value): flights and accommodation to an estimated value of £5,691.68 Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 2 2015-03-30-80ef1083-10213-2
eb2b2b7390a74f08303503b2b9729598dbce52b7 Destination of visit: Washington DC Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 3 2015-03-30-80ef1083-10213-2
2a08b9dc2c4517ee55c23d47ad25abff1b4cbe1a Date of visit: 28 February to 3 March 2015 Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 4 2015-03-30-80ef1083-10213-2
698a29e1ff4146119d66b4586ae0a5b3736f3569 Purpose of visit: to attend and speak in AIPAC conference in Washington. Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 5 2015-03-30-80ef1083-10213-2
983129702084114e14db7eaba1ca08b0e38ad2ee (Registered 5 March 2015) Overseas visits 80ef1083 2015-03-30 Liam Fox uk.org.publicwhip/member/40445 Liam Fox uk.org.publicwhip/person/10213 6 2015-03-30-80ef1083-10213-2

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 · Queries took 63.818ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette