items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-80ef1083-10964-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
daff8e2888d70df6ae503edae87698bf53b2b280 | Name of donor: CAFOD | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 0 | 2015-03-30-80ef1083-10964-0 |
f1e4c7674f6e3e6668022f5915c6b8a89192708c | Address of donor: Romero House, 55 Westminster Bridge Road, London SE1 7JB | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 1 | 2015-03-30-80ef1083-10964-0 |
22b833c7d1f4750f4ea3698117be22f55288e5ed | Amount of donation (or estimate of the probable value): £690 | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 2 | 2015-03-30-80ef1083-10964-0 |
5a3af422ea7a78ac0e5cf3109017deb3a629d0b9 | Destination of visit: Kenya | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 3 | 2015-03-30-80ef1083-10964-0 |
25517a004febc82f20b23b4c0546e408c2722806 | Date of visit: 13-17 April 2014 | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 4 | 2015-03-30-80ef1083-10964-0 |
4e60744f924f29e2558a470de18fda28610a5820 | Purpose of visit: fact finding | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 5 | 2015-03-30-80ef1083-10964-0 |
94f474c45e7faf8f71163949f40f6d1a546618f6 | (Registered 28 May 2014) | Overseas visits 80ef1083 | 2015-03-30 | Mark Hoban uk.org.publicwhip/member/40256 | Mark Hoban uk.org.publicwhip/person/10964 | 6 | 2015-03-30-80ef1083-10964-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");