items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-80ef1083-10172-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 |
---|---|---|---|---|---|---|---|
7c33b03449e055aad0b513f2ded83343902de5d0 | Name of donor: British University in Egypt | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 0 | 2015-03-30-80ef1083-10172-0 |
e048c6afd0fbc88e1db0d5aba5ab94bbb1da0607 | Address of donor: El Sherouk City, Suez Desert Road, Cairo 11837; PO Box 43 | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 1 | 2015-03-30-80ef1083-10172-0 |
f4c6ed60dfb106e029b7803e74092fb07caf2992 | Amount of donation (or estimate of the probable value): £3,300 to cover flights, accommodation, meals and transport in Egypt. | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 2 | 2015-03-30-80ef1083-10172-0 |
42558b9e5f87d34d8e1c50ed183f2c1142d6dff2 | Destination of visit: Cairo, Egypt | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 3 | 2015-03-30-80ef1083-10172-0 |
34a212b0ec8918b5d6238be964b89b638fedad95 | Date of visit: 13-16 June 2014 | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 4 | 2015-03-30-80ef1083-10172-0 |
06573beeabc40cba60694a694ce4c8b364dc7362 | Purpose of visit: to meet the new President, meet government ministers, religious leaders, British Council, IPU and representatives of civil society in Egypt and discuss developments taking place in the run up to parliamentary elections. | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 5 | 2015-03-30-80ef1083-10172-0 |
de1c7c4a775dc54be59c465e059d98b1bdaa87e7 | (Registered 7 July 2014) | Overseas visits 80ef1083 | 2015-03-30 | Jeffrey M Donaldson uk.org.publicwhip/member/40350 | Jeffrey M. Donaldson uk.org.publicwhip/person/10172 | 6 | 2015-03-30-80ef1083-10172-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");