items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where item = "A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation." and person_id = "uk.org.publicwhip/person/10097" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: member_id, date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
455c82bc49fa077485aeb9ceea07982bd8c91ec0 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2005-11-01-9e46def6-10097-0 |
30cc2a3998ef9bb4a60f321bd0fee70369f67834 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2005-12-14-9e46def6-10097-0 |
94d2aa5c267c47839f603f8b469128031a18d457 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-02-13-9e46def6-10097-0 |
1e1eda09994704255031c40726c1c340682284d5 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-02-14-9e46def6-10097-0 |
58c67abd38fbaf32edf86612933b563d9e4b1900 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-03-24-9e46def6-10097-0 |
9431fe16dabc7d6bfca86412b0badf92eaab0b5f | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-05-12-9e46def6-10097-0 |
91f3bce7dc782165b0866915ad0b69b5a996800d | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-06-21-9e46def6-10097-0 |
912975751583759746b0ad73bd1db91b5711947d | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-07-25-9e46def6-10097-0 |
03f256b0aae5579c576940f3ab0227678ae24281 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-09-19-9e46def6-10097-0 |
78ff34c726c5742bd827509f450cb5f011dedab5 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-11-06 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-11-06-9e46def6-10097-0 |
09a138f11ca7d6e908c783ae71a3e2b3617cfedf | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-11-27 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-11-27-9e46def6-10097-0 |
ffc38c0f12ddbba65ca748894fdb0ac328fff76a | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2006-12-11 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2006-12-11-9e46def6-10097-0 |
487e9d3c6c952f9bca05815952677a9e07d78f26 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2007-01-09 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-01-09-9e46def6-10097-0 |
fa8d4fa68bcab78155998fe06459de1c1359c0b4 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2007-01-23 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-01-23-9e46def6-10097-0 |
d6ed3cba27f173960bea94d63a1e98f753bdb8c4 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2007-02-06 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-02-06-9e46def6-10097-0 |
7b2196d5436d251b0ac08647d4e223ed8950e6e8 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-02-27-9e46def6-10097-0 |
ac0f453e19f512c060532c77c9943101e0081733 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2002-05-14-9e46def6-10097-0 |
3c4638c86da15fa098d2f713af8a808f879f538b | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2003-12-04 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2003-12-04-9e46def6-10097-0 |
e29e81911fb09a787f4743da88c925053101d4c9 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2004-01-31 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2004-01-31-9e46def6-10097-0 |
23cc48bd90c301ddd2a0016074baade553cb19c5 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2004-05-21 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2004-05-21-9e46def6-10097-0 |
5ca3afb6223ca2c79a2623dc3d6a598668db68c2 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2004-07-16 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2004-07-16-9e46def6-10097-0 |
e586ecee1ba640a53ee9e04e987cb6890e21cc55 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2004-09-08 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2004-09-08-9e46def6-10097-0 |
6669d15f2cbff2b554dc8bb280d804976f4f63a1 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2004-10-22 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2004-10-22-9e46def6-10097-0 |
8542eeebda928594d511e85eac54c0b12289b9c1 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2004-12-03 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2004-12-03-9e46def6-10097-0 |
76ba52375c4f1fd8ab1c2ffa671d0d38e90f1563 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2005-01-28 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2005-01-28-9e46def6-10097-0 |
adb1858c1437ef6ea2d6f4dc09c0b1df43be7e24 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Ian Cawsey uk.org.publicwhip/member/789 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2005-04-11-9e46def6-10097-0 |
94c4cb2b8ca6ac2842762ab55911df634059e4ad | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2000-11-10 | Ian Cawsey uk.org.publicwhip/member/97 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2000-11-10-9e46def6-10097-0 |
f673380ea0d6c124ee2550cfd54059f5fbafb484 | A lease from North Lincolnshire Council of two rooms in an office block in Brigg on terms appropriate to a not-for-profit organisation. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Ian Cawsey uk.org.publicwhip/member/97 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2001-05-14-9e46def6-10097-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");