items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where item = "Shared ownership of a flat in London." and person_id = "uk.org.publicwhip/person/10100" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
7fc25bebeb8c3335c60b9bc95dff1ce8d16bda3a | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-06-10 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-06-10-4f1e6359-10100-0 |
d7f7abd35543b064eb7c42f003b2a1380d2d5d25 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-06-24 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-06-24-4f1e6359-10100-0 |
e00c2785d9d8a74f5f769cc14d18f690c3bed788 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-07-08 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-07-08-4f1e6359-10100-0 |
b201259a5d8c34de94626178023178e2488ce1ed | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-07-21 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-07-21-4f1e6359-10100-0 |
6c27d2154392e620f79e90f8d8f9725e3a07a7f1 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-09-02 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-09-02-4f1e6359-10100-0 |
ce5831ec13a8e3da1871091c7f2eeda3f9e2582a | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-10-14 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-10-14-4f1e6359-10100-0 |
3e3838c147271ebe50985b441231cdde38f496f8 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-10-28 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-10-28-4f1e6359-10100-0 |
4df95f853cf43adf4cae43ca776f3dffa99cd654 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-11-11 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-11-11-4f1e6359-10100-0 |
7c7766d78f63e6831ff1d915f4477a601cb7cc33 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-11-25 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-11-25-4f1e6359-10100-0 |
4673ee465d3621b4510c5a5c2b01a58f262b99ba | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2009-12-10 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2009-12-10-4f1e6359-10100-0 |
d514e3246642a2aba4d8f75e2fd4a794f4d6ffe1 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2010-01-06 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2010-01-06-4f1e6359-10100-0 |
d33d42143e90af336256189e78d05837d58af873 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2010-02-03 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2010-02-03-4f1e6359-10100-0 |
beccee55fe7b263ab0ef840850858b10b11e5918 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2010-02-24 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2010-02-24-4f1e6359-10100-0 |
5f25148912f99d8c4fe44baeea7714b15659c0c2 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2010-03-10 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2010-03-10-4f1e6359-10100-0 |
c57212baf5168b2afd2db7c085ade70201112641 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2010-03-24 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2010-03-24-4f1e6359-10100-0 |
37a1e2f4c20fd157d604f3699b9cb324a3251439 | Shared ownership of a flat in London. | Land and Property 4f1e6359 | 2010-04-12 | David Chaytor uk.org.publicwhip/member/1466 | David Chaytor uk.org.publicwhip/person/10100 | 0 | 2010-04-12-4f1e6359-10100-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");