items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-80ef1083-11377-2" 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 |
---|---|---|---|---|---|---|---|
1e90d513ed4715337f81cc5f039b7b89ebeca193 | Name of donor: Results UK | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 0 | 2015-03-30-80ef1083-11377-2 |
7e3a456214934d390b0c43b1601e0cfd50d14b26 | Address of donor: 31-33 Bondway, London SW8 1SJ | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 1 | 2015-03-30-80ef1083-11377-2 |
ff5dacc70abf4f4c12363e9c99b74d69c0b968e7 | Amount of donation (or estimate of the probable value): travel, accommodation and subsistence with a value of £1,300 | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 2 | 2015-03-30-80ef1083-11377-2 |
238da6c56eb17d472d4ceb7e9efd6f778a643047 | Destination of visit: Barcelona, Spain | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 3 | 2015-03-30-80ef1083-11377-2 |
453d35ab11e9e05709668bcac5ea8638df124c12 | Date of visit: 26-30 October 2014 | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 4 | 2015-03-30-80ef1083-11377-2 |
db1cd2ecd3ba8cad5039d3fca1e3863693315331 | Purpose of visit: addressing and attending the World Lung Health Conference in my role as Co-Chairman of the APPG on Global TB | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 5 | 2015-03-30-80ef1083-11377-2 |
33fec0c31a0a098fa0bb6acc9f0a7204d25ba61a | (Registered 26 November 2014) | Overseas visits 80ef1083 | 2015-03-30 | Nick Herbert uk.org.publicwhip/member/40047 | Nick Herbert uk.org.publicwhip/person/11377 | 6 | 2015-03-30-80ef1083-11377-2 |
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");