items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2012-12-03-80ef1083-24715-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
fa316c42f933644c4c571f52e3a5931ef94202c8 | Name of donor: President, National Electoral Council Bolivarian Republic of Venezuela | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 0 | 2012-12-03-80ef1083-24715-0 |
fe47da70f9f2a398c2b959dc6fcd8536f5eca54c | Amount of donation (or estimate of the probable value): flights, hotel and transfers, total cost £2,466 | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 2 | 2012-12-03-80ef1083-24715-0 |
a0caf8d4362ebe1feff1d185ef0e839d12f43dff | Date of visit: 6-11 August 2012 | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 4 | 2012-12-03-80ef1083-24715-0 |
90acdb4e8e7375bda88b23df38767d2a57fd7edb | Purpose of visit: study and assessment of Venezuela’s electoral process and automated voting system | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 5 | 2012-12-03-80ef1083-24715-0 |
4ea02995210935bb61f3286e73e568442ad252c6 | (Registered 25 September 2012) | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 6 | 2012-12-03-80ef1083-24715-0 |
740efb758f183aff5892c8a533d30ccbc5b1054e | Name of donor: CNE, National Electoral Council, Bolivarian Republic of Venezuela (Venezuelan Electoral Commission) | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 7 | 2012-12-03-80ef1083-24715-0 |
03e0fe37b203bbdb98f4d7b844d84ea93d4d3b56 | Address of donor: c/o Embassy of the Bolivarian Republic of Venezuela, 1 Cromwell road, London SW7 2HW | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 8 | 2012-12-03-80ef1083-24715-0 |
a4fcb9acfb0c70493949391b1da875209f5e66ac | 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 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 9 | 2012-12-03-80ef1083-24715-0 |
8654f1c62f3fac4f38cfc98664795711dff131f5 | Destination of visit: Venezuela | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 10 | 2012-12-03-80ef1083-24715-0 |
6c033e254fd5ebed6b6230c1fa55c3e56530a518 | Date of visit: 4-10 October 2012 | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 11 | 2012-12-03-80ef1083-24715-0 |
33e281c273b5cf58d53fee0a71d9ef4285a64081 | Purpose of visit: As part of an international team of 200 parliamentarians, academics and journalists observing the Venezuelan Presidential Elections | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 12 | 2012-12-03-80ef1083-24715-0 |
9a5412eca9b4eae1dbd26fcf7bc17525595633f2 | (Registered 7 November 2012) | Overseas visits 80ef1083 | 2012-12-03 | Grahame Morris uk.org.publicwhip/member/40222 | Grahame Morris uk.org.publicwhip/person/24715 | 13 | 2012-12-03-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");