items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-09-80ef1083-10596-1" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
0007389a06d2679a1792f07a4ec5e23145d20307 | Name of donor: Friedrich-Ebert-Stiftung | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 0 | 2015-03-09-80ef1083-10596-1 |
9fb95b6c23938f1b1d9cef84ebf7a24f2d9a3c94 | Address of donor: 44 Charlotte Street, London W1T 2NR | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 1 | 2015-03-09-80ef1083-10596-1 |
87c3a7638fc8a0ce7191369e6cbd62c66b279348 | Amount of donation (or estimate of the probable value): £720 | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 2 | 2015-03-09-80ef1083-10596-1 |
8409619c95f7b89741e352999f7a9d9d942f3671 | Destination of visit: Berlin | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 3 | 2015-03-09-80ef1083-10596-1 |
428f4a166a15ee4f663e5b3ed08fe6066deaee7c | Date of visit: 23-24 June 2014 | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 4 | 2015-03-09-80ef1083-10596-1 |
0b7fad58bd7799abc471f961d99d9cc0a51483dd | Purpose of visit: to find out about publicly funded research and innovation institutions in Germany. | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 5 | 2015-03-09-80ef1083-10596-1 |
f034f2dbf9066c615bb87b1e8dd833fdd807f45a | (Registered 23 July 2014) | Overseas visits 80ef1083 | 2015-03-09 | Stephen Timms uk.org.publicwhip/member/40226 | Stephen Timms uk.org.publicwhip/person/10596 | 6 | 2015-03-09-80ef1083-10596-1 |
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");