items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where item = "Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute." and member_id = "uk.org.publicwhip/member/1039" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
date 10 ✖
- 2002-05-14 1
- 2003-12-04 1
- 2004-01-31 1
- 2004-05-21 1
- 2004-07-16 1
- 2004-09-08 1
- 2004-10-22 1
- 2004-12-03 1
- 2005-01-28 1
- 2005-04-11 1
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
a8ff04948f242015753eb4270c17a8cb6819b564 | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2002-05-14-9e46def6-10352-0 |
f0e8ea59f76abb190775a7f48a23b68838e0c328 | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2003-12-04 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2003-12-04-9e46def6-10352-0 |
eec0cd1f323cbbc6292c3885b3e72ee048ea6f5a | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2004-01-31 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2004-01-31-9e46def6-10352-0 |
01ea8ad26c65f81ca49dd6591ce6915ff72fb1ba | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2004-05-21 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2004-05-21-9e46def6-10352-0 |
4374af9232577e84e699e78bdac42bd4aa69bd12 | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2004-07-16 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2004-07-16-9e46def6-10352-0 |
f18bed7b9712aa6d6e56e3cda81c3e0d2719ba93 | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2004-09-08 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2004-09-08-9e46def6-10352-0 |
11ec81d766def8ea9b415d5c3d7def8e0194b8ed | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2004-10-22 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2004-10-22-9e46def6-10352-0 |
fac6d682d80233157a9572889bfeb35fd1248467 | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2004-12-03 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2004-12-03-9e46def6-10352-0 |
0f42abd1de48c8b5d78fab81bdb342313505398c | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2005-01-28 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2005-01-28-9e46def6-10352-0 |
6e33039173e2be49b1f0c2c6d5f54070b7a0afa5 | Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 0 | 2005-04-11-9e46def6-10352-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");