items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where category_id = "4f1e6359" and member_id = "uk.org.publicwhip/member/1073" sorted by person_id descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date | member_id | person_id ▲ | sort_order | record_id |
---|---|---|---|---|---|---|---|
b811ad749b34367a88e9677ee7a9f77cb9e17161 | Half-share in smallholding in Teesdale, Co. Durham. The fields are let, but not the house. | Land and Property 4f1e6359 | 2002-05-14 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2002-05-14-4f1e6359-10389-0 |
e9f057640da353c411e7eb907674067996f6db78 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2002-11-26 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2002-11-26-4f1e6359-10389-0 |
eeeb4b8c100bd5a50799a17263d388ac4cb55768 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2003-12-04 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2003-12-04-4f1e6359-10389-0 |
1ed2e49ac56756dd59426108f291a01ca2e8f53a | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2004-01-31 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2004-01-31-4f1e6359-10389-0 |
904843ae835fb696c3fd797c669f8ff1563c1fb8 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2004-05-21 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2004-05-21-4f1e6359-10389-0 |
cbf178c0872f425d0bf842ad5aa73f36d1c8e875 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2004-07-16 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2004-07-16-4f1e6359-10389-0 |
d1753e7b750ac18060ad63ced365266aaddcc900 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2004-09-08 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2004-09-08-4f1e6359-10389-0 |
fc70a312420b052262825c3fb02ea6d359891600 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2004-10-22 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2004-10-22-4f1e6359-10389-0 |
11a0bf6cf7cf74d3f09b7d6878f2dfd15139a306 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2004-12-03 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2004-12-03-4f1e6359-10389-0 |
b7fa746976c9c70d031fab175949fa272b48a5c4 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2005-01-28 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2005-01-28-4f1e6359-10389-0 |
9f7046f60a603e3c9cb13dd5c952bef374369f98 | Half-share in smallholding in Teesdale, Co. Durham. | Land and Property 4f1e6359 | 2005-04-11 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 0 | 2005-04-11-4f1e6359-10389-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");