items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2013-04-08-80ef1083-24715-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 |
---|---|---|---|---|---|---|---|
b9c036de530c8f10e3cf669579fc056cfe1602b7 | Name of donor: President, National Electoral Council Bolivarian Republic of Venezuela | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2013-04-08-80ef1083-24715-0 |
ac3a27bd4ed88352732b9f4e4015518f23a74c56 | Amount of donation (or estimate of the probable value): flights, hotel and transfers, total cost £2,466 | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2013-04-08-80ef1083-24715-0 |
946b8b9903a4a6378d1a6d6349f01624230778f4 | Date of visit: 6-11 August 2012 | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2013-04-08-80ef1083-24715-0 |
7f0b33ec8996af9f36fdc7565721f9a98962ee34 | Purpose of visit: study and assessment of Venezuela’s electoral process and automated voting system | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2013-04-08-80ef1083-24715-0 |
7f5472ba6404b3ad750afa1b6c9da8a19330d1a0 | (Registered 25 September 2012) | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 6 | 2013-04-08-80ef1083-24715-0 |
001759037980aec1dce3c81acdbd1b26df12ca48 | Name of donor: CNE, National Electoral Council, Bolivarian Republic of Venezuela (Venezuelan Electoral Commission) | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 7 | 2013-04-08-80ef1083-24715-0 |
0000b819fb41c787595479b04fd2b687dd984d44 | Address of donor: c/o Embassy of the Bolivarian Republic of Venezuela, 1 Cromwell road, London SW7 2HW | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 8 | 2013-04-08-80ef1083-24715-0 |
aeaa2ead652d986179a5cb9fd8fccc706faeab64 | Amount of donation (or estimate of the probable value): flights and hotel with a value of £3,233.11, plus other transport provided by the CNE. | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 9 | 2013-04-08-80ef1083-24715-0 |
a57626a90509a8bc034ecb1999810fe9b5a2e3a0 | Destination of visit: Venezuela | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 10 | 2013-04-08-80ef1083-24715-0 |
15c8afc961b155d61a22fe2d34e6edc4168f5139 | Date of visit: 4-10 October 2012 | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 11 | 2013-04-08-80ef1083-24715-0 |
50714802f2ffdffb52a2f7b3c6fe3b96eeade6f1 | Purpose of visit: As part of an international team of 200 parliamentarians, academics and journalists observing the Venezuelan Presidential Elections | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 12 | 2013-04-08-80ef1083-24715-0 |
4e4b03d72c956ebae5c4bc9263d16731593b1468 | (Registered 7 November 2012) | Overseas visits 80ef1083 | 2013-04-08 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 13 | 2013-04-08-80ef1083-24715-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");