items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-80ef1083-24775-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 |
---|---|---|---|---|---|---|---|
b8313eaa5b8e527b11d32da3de34030aa759f97d | Name of donor: Unitas Communications | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 0 | 2015-03-30-80ef1083-24775-0 |
8e461968436b69bdada9da851df34b50567cb70e | Address of donor: 11 Burford Road, London E15 2ST | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 1 | 2015-03-30-80ef1083-24775-0 |
95c53910acee15d76ba09ca466aa861b95ede5d7 | Amount of donation (or estimate of the probable value): travel and accommodation at a total of £1,210.98 | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 2 | 2015-03-30-80ef1083-24775-0 |
7a1197f0908465ff771f9f59578dd0fc687765de | Destination of visit: Amsterdam | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 3 | 2015-03-30-80ef1083-24775-0 |
a626fd9951b8a0c9036417d526cc20eff284aadf | Date of visit: 11-12 October 2014 | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 4 | 2015-03-30-80ef1083-24775-0 |
bab7f82ac9c3d789a81dbe1ad08e178941f167f1 | Purpose of visit: a leadership conference; to chair seminars, engage in dialogue to strengthen networks and promote greater Pan-European integration and greater social inclusion for minority groups within Europe. | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 5 | 2015-03-30-80ef1083-24775-0 |
d4b7fc4cc54b49d57e86014f98c4ea9795827588 | (Registered 17 November 2014) | Overseas visits 80ef1083 | 2015-03-30 | Yasmin Qureshi uk.org.publicwhip/member/40100 | Yasmin Qureshi uk.org.publicwhip/person/24775 | 6 | 2015-03-30-80ef1083-24775-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");