items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2010-11-08-80ef1083-24913-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 |
---|---|---|---|---|---|---|---|
13898479b67b075ae8cee281b665c25bfea27655 | Name of donor: Great Britain China Centre | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-08-80ef1083-24913-0 |
f1b42058284458218d215c676678842538031ee8 | Address of donor: 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-11-08-80ef1083-24913-0 |
617c91235051ada1ae6c3712f4fd97246909de76 | Amount of donation (or estimate of the probable value): £4,623 | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2010-11-08-80ef1083-24913-0 |
2906e200f5f2259b0f5771a463fe3de2c00aa7b9 | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2010-11-08-80ef1083-24913-0 |
e33d5b69bcac397b021f1829d7584eaff8031200 | Date of visit: 13-17 September 2010 | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2010-11-08-80ef1083-24913-0 |
04d758f7b0e84cbffad89d7a6a5e413c8c79e3ce | Purpose of visit: to attend annual Leadership Forum with the Chinese Communist Party for political leaders in China and UK and associated activities | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2010-11-08-80ef1083-24913-0 |
49c7d687d62e4d34fa3d4545073435c4b1bc8965 | (Registered 1 November 2010) | Overseas visits 80ef1083 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2010-11-08-80ef1083-24913-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");