items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2011-02-07-80ef1083-10632-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 |
---|---|---|---|---|---|---|---|
2fec960e95754ceb94714a2bbfeae166f68d881d | Name of donor: British Ukrainian Society | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2011-02-07-80ef1083-10632-0 |
c8e1a57ba966c3cd535a2a17d52eb7800a8f5ccd | Address of donor: 1st Floor, 25 Knightsbridge, London SW1X 7RZ | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2011-02-07-80ef1083-10632-0 |
ddcb8580d90e9abc4a0b88fa9e58bbd00e03f919 | Amount of donation (or estimate of the probable value): £2,800 | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2011-02-07-80ef1083-10632-0 |
0141bde39a3741d901c2b2ab60c780e71d178706 | Destination of visit: Kiev, Ukraine | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2011-02-07-80ef1083-10632-0 |
2d9f58c5d6a064048b7c656d2e41ebfc45689edb | Date of visit: 15-18 September 2010 | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2011-02-07-80ef1083-10632-0 |
6c30619f358a5a25e5880ab56e9991af9ee80689 | Purpose of visit: to meet members of the Government of Ukraine and Opposition in my capacity as Chairman of the British Ukraine All-Party Parliamentary Group | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2011-02-07-80ef1083-10632-0 |
01f2a695af16772fd495e9eca9e192e005b4624f | (Registered 25 October 2010) | Overseas visits 80ef1083 | 2011-02-07 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2011-02-07-80ef1083-10632-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");