items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2009-10-14-80ef1083-10082-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 |
---|---|---|---|---|---|---|---|
08371dab099ea56e7a51b5c49b5a21af23d6338b | Name of donor: Faroese Government | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2009-10-14-80ef1083-10082-0 |
6ef4e101d81f0a9225b1b313abb9852f9a7cabe2 | Address of donor: Faroese Government | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2009-10-14-80ef1083-10082-0 |
51079df2978a05443724c353757d258e03973353 | Amount of donation (or estimate of the probable value): £900 | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 2 | 2009-10-14-80ef1083-10082-0 |
74f29c39f38bce65734c5a5489c6eb97f9f37ba7 | Destination of visit: Faroe Islands | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 3 | 2009-10-14-80ef1083-10082-0 |
719c2c72db4999c2d291f1c10aaa17cab10ceb87 | Date of visit:17 - 20 August 2009 | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 4 | 2009-10-14-80ef1083-10082-0 |
a9cb9dde0d20e1eb865cb97cc1c53b4e8b492026 | Purpose of visit: TBC | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 5 | 2009-10-14-80ef1083-10082-0 |
753c6259da4521d8ad80f194a1c3e3455091a623 | (Registered 14 September 2009) | Overseas visits 80ef1083 | 2009-10-14 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 6 | 2009-10-14-80ef1083-10082-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");