items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where category_id = "4f1e6359" and member_id = "uk.org.publicwhip/member/40115" sorted by person_id
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
3aabc78d3bf340137a0b7dceb26ec04f72caeac4 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2010-09-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-09-06-4f1e6359-24913-0 |
c65d64c345e93cd9cecf50d00b7c62439c90e936 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2010-10-25 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-10-25-4f1e6359-24913-0 |
8e33cfd742fe4a718dace74ef4fd9bf7e2b96e8e | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-08-4f1e6359-24913-0 |
4f5a61e9f545f13dac29a60580983fd4959a14e0 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2010-11-22 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-22-4f1e6359-24913-0 |
27493718ce703937d8ae28080e326cb83aa344fb | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2010-12-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-12-06-4f1e6359-24913-0 |
db2ca4f7df0b488b6f9b7fcc4bb18f35157738f6 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2010-12-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-12-20-4f1e6359-24913-0 |
df11546c742fba944c90fcdf90904d1c8a203444 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-01-10 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-10-4f1e6359-24913-0 |
98365ac11270afdf075734e50dc670b55d8375ec | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-24-4f1e6359-24913-0 |
292067b7d871f77973cdcd9a7aca11b46f06ae2d | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-02-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-02-07-4f1e6359-24913-0 |
97f1864c4b2e48e9e27541e0f9bd252942cd9f6f | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-02-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-02-28-4f1e6359-24913-0 |
655b2039a0f51e5f4589368e674e07e076880f53 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-14-4f1e6359-24913-0 |
6ed569d54946ef761bb13dc5a1009ccd19d4300b | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-28-4f1e6359-24913-0 |
49003ee2bd62ac178d6c97540c2ea2b175d5ea02 | One residential property in London, from which I receive rental income. | Land and Property 4f1e6359 | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-04-18-4f1e6359-24913-0 |
10ff215d9a912642f2c0cd2ae7f5281d661e5849 | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-05-03 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-03-4f1e6359-24913-0 |
22086616fe8b69a7d6ade04d61fe7ab7bda372e2 | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-16-4f1e6359-24913-0 |
56b68b8fdae7aa2d98bec8f3f27fad93f4fbedbf | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-06-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-06-06-4f1e6359-24913-0 |
af4d4517883dac8dfdc5be8bad5a0b88ed02483b | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-06-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-06-20-4f1e6359-24913-0 |
308f7bd266fc657bdf3748d1d6affcef7f69b262 | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-07-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-07-06-4f1e6359-24913-0 |
986721861f2e21ebb66d813fffb3661899f8fe4d | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-07-19 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-07-19-4f1e6359-24913-0 |
c742913d8d6ddece7e1d5a1820771dc7b05dde51 | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-08-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-08-30-4f1e6359-24913-0 |
8d342e88ccfea02f2977c6694b4a4239b443e249 | One residential property in London, from which rental income was received until end March 2011. | Land and Property 4f1e6359 | 2011-09-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-09-28-4f1e6359-24913-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");