items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2011-10-17-80ef1083-10062-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 |
---|---|---|---|---|---|---|---|
46923ae7084db8208e44cf59fc011bc60fe8147f | Name of donor: The European Azerbaijan society | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 0 | 2011-10-17-80ef1083-10062-0 |
b9a76e1e99ceca2eeced41e6022a8a1bf56263a7 | Address of donor: 2 Queen Anne’s Gate, London SW1H 9AA | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 1 | 2011-10-17-80ef1083-10062-0 |
0088349082ec66783c85e7071318c45d5b7ead7b | Amount of donation (or estimate of the probable value): travel and accommodation estimated at £3,600 | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 2 | 2011-10-17-80ef1083-10062-0 |
91c672b8f65fe71cf823ebc97316171909cc2b3c | Destination of visit: Azerbaijan | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 3 | 2011-10-17-80ef1083-10062-0 |
6cd46ed6d5f3d62a9c0824b22549f1c43fb6aa7b | Date of visit: 22 -27 July 2011 | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 4 | 2011-10-17-80ef1083-10062-0 |
9f59ff8f0dfae284a0790fefddf6ee60384d80ee | Purpose of visit: to meet senior Azerbaijani political and business figures and, British diplomats, and to visit some of the regions and IDP camp | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 5 | 2011-10-17-80ef1083-10062-0 |
c11f40b871d247ecc173af08afa26dedc74606d3 | (Registered 26 August 2011 ) | Overseas visits 80ef1083 | 2011-10-17 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 6 | 2011-10-17-80ef1083-10062-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");