items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2008-12-17-80ef1083-10440-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 |
|---|---|---|---|---|---|---|---|
| 2c32e44c258c64564730b78135cc9fc1b811a024 | 11-15 November 2007, to Rio de Janeiro, to attend the Internet Governance Forum, an event facilitated by the United Nations as a multi-stakeholder event, to represent interest of All-Party Groups including Pitcom (Parliamentary Information Technology Committee) and the interest of Eurim (European Information Society Group). Travel and hotel costs funded by Eurim with the support of Nominet. (Registered 4 March 2008) | Overseas visits 80ef1083 | 2008-12-17 | Margaret Moran uk.org.publicwhip/member/1698 | Margaret Moran uk.org.publicwhip/person/10440 | 0 | 2008-12-17-80ef1083-10440-0 |
| c587a10c3221474985791c11bbbc459f066f98c4 | 29 November-7 December 2008, to Hyderabad, India, with the Internet Governance Forum to participate in workshops and deliver speeches on child protection issues and the internet. Flights, hotel and internal travel paid for by Nominet. (Registered 5 December 2008) | Overseas visits 80ef1083 | 2008-12-17 | Margaret Moran uk.org.publicwhip/member/1698 | Margaret Moran uk.org.publicwhip/person/10440 | 1 | 2008-12-17-80ef1083-10440-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");