items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where item = "I have an interest in certain trusts." and person_id = "uk.org.publicwhip/person/10078" 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 ▼ |
---|---|---|---|---|---|---|---|
5cc91487e8c99ef41d7ef12c4020e7d9fd540df5 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2003-12-04 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2003-12-04-3aff2389-10078-0 |
b9749c82156a3d19c5ce85d0ffe110f919186576 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2004-01-31 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-01-31-3aff2389-10078-0 |
dec965843469f88868b64c3710173c49cc02d69f | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2004-05-21 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-05-21-3aff2389-10078-0 |
359a27ec79d85ff72cd25350445f8eeb6bcc03e1 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2004-07-16 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-07-16-3aff2389-10078-0 |
a1278e2ed178c780235097061e8e65aea1cfbd18 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2004-09-08 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-09-08-3aff2389-10078-0 |
bf13743e5a6b10105bba679bb1deaef617a3fa15 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2004-10-22 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-10-22-3aff2389-10078-0 |
b4f55df670181f2a528b34d51d5444b2654e9c82 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2004-12-03 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-12-03-3aff2389-10078-0 |
0617d9d897f01e441ad15c89b67c3a16d388d090 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2005-01-28 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2005-01-28-3aff2389-10078-0 |
1a650dae8287a8b1a23b897f7a7b5ca4c99d3e65 | I have an interest in certain trusts. | Registrable shareholdings 3aff2389 | 2005-04-11 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2005-04-11-3aff2389-10078-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");