items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2013-12-09-80ef1083-13934-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 |
---|---|---|---|---|---|---|---|
2a48f3d4bee78ec5df65e426dc01d413d8bcdf28 | Name of donor: Universal Peace Federation | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2013-12-09-80ef1083-13934-0 |
32358ecbaa076b516ef1549d60ab05113eb7769d | Address of donor: 43 Lancaster Gate, London W2 3NA | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 1 | 2013-12-09-80ef1083-13934-0 |
b55803f96190babacb6d38ef8f1e6347afa6cab2 | Amount of donation (or estimate of the probable value): £3,318 | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2013-12-09-80ef1083-13934-0 |
01af37666c89c2e5776242f988fdd86e0d6430ec | Destination of visit: Seoul, Republic of Korea | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2013-12-09-80ef1083-13934-0 |
ceac7e555d64ad5543f44dd7ca4654c649dab503 | Date of visit: 20-24 February 2013 | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2013-12-09-80ef1083-13934-0 |
e1e0c9facadde3c9f3eceaeff57dc5096ac87084 | Purpose of visit: Universal Peace Federation World Summit | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2013-12-09-80ef1083-13934-0 |
7d38a4d987c2ca696a9f1e95be611405487068c1 | (Registered 7 March 2013) | Overseas visits 80ef1083 | 2013-12-09 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2013-12-09-80ef1083-13934-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");