items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
46 rows where category_id = "4f1e6359" and person_id = "uk.org.publicwhip/person/11026" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
8f22bdcd18dfbf7d4ece3686aaa4c1aab3274d0d | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2015-03-30 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2015-03-30-4f1e6359-11026-0 |
77829f7f0eb6d00ff4f9d0542bc74e7017e83b2d | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2015-03-09 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2015-03-09-4f1e6359-11026-0 |
5878304f64fbfc9a0a7d2a463635a1c46cc7e968 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2015-02-23 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2015-02-23-4f1e6359-11026-0 |
f33e491253bf70091c7a2a2cf73ec9a0f9f870e0 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2015-02-09 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2015-02-09-4f1e6359-11026-0 |
cd1d6477f22bb4f94aed8e4fe1cd45f2bf61902f | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2015-01-26 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2015-01-26-4f1e6359-11026-0 |
897b68c5fd3428f5c92aa6abe7779ec6799df146 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2015-01-06 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2015-01-06-4f1e6359-11026-0 |
7eb1b0ee42c83751be7c49bea0882a57aa0774d2 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-12-08 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-12-08-4f1e6359-11026-0 |
2744d760ce39803d50520f61691ce28ce4b1af05 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-11-24 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-11-24-4f1e6359-11026-0 |
8786761092f062b96142f2d64eb1718a1f6200c7 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-11-10 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-11-10-4f1e6359-11026-0 |
92ccdcba38a42c82becba8a2ba05c586359135d5 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-10-27 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-10-27-4f1e6359-11026-0 |
0eaa2623087cbaf28010d825b43018777346b307 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-10-13 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-10-13-4f1e6359-11026-0 |
997f5bdaf5df0681a1f960f5a5efc3e7e0a4bbe6 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-09-22 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-09-22-4f1e6359-11026-0 |
6a745ac9da844355d9f8a966ba1beea614457e39 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-08-26 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-08-26-4f1e6359-11026-0 |
9100b8bd903fb798547793d2b7313036fabbd9c3 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-07-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-07-28-4f1e6359-11026-0 |
74a56264ad73e3d0a108176ede1c2d4971da60ac | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-07-14 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-07-14-4f1e6359-11026-0 |
85afb2bf2564a665167e022120aad6170a9dbb51 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-06-30 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-06-30-4f1e6359-11026-0 |
c8a4b29b8e97d33db533295bfa89069e386f4d75 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-06-16 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-06-16-4f1e6359-11026-0 |
bdd5bb8025b97e58681bd416ff18b2529038f4fb | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-06-02 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-06-02-4f1e6359-11026-0 |
955d804f168e2db2c9cf231f961ff52061eba1f1 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-05-12 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-05-12-4f1e6359-11026-0 |
483b5939917cab99d172598f02512d97b1b5d02e | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-04-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-04-28-4f1e6359-11026-0 |
be8b114e0af01cec3a09cecb77c63a2cb2dcfe0b | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-04-07 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-04-07-4f1e6359-11026-0 |
c794256d21fe514000c8c5803c62e1399400fd56 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-03-24 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-03-24-4f1e6359-11026-0 |
386daff609275efeec32a11e8c66dd2582a2ea47 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-03-21 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-03-21-4f1e6359-11026-0 |
1c9748bcc597ebadc66512b4da01597572ffefb3 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-03-10 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-03-10-4f1e6359-11026-0 |
945c14ba06a41ef77083f6ad3824b54e4bf3fb4a | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-02-24 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-02-24-4f1e6359-11026-0 |
b2f2ff1c52ccc3ad4287169e7a28b06117dbe3d1 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-02-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-02-03-4f1e6359-11026-0 |
c500d8c46d28dbbc4773b97f86f6e655f950e56b | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-01-20 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-01-20-4f1e6359-11026-0 |
bb9c4c554d1c576af160f15cabd5042415bbdef7 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2014-01-06 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2014-01-06-4f1e6359-11026-0 |
55a0c627803d7a534dd4327e8e24bcb8f0581278 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-12-09 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-12-09-4f1e6359-11026-0 |
ea10eb38ce58a989571026f6fde02a7d6f2e9be1 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-11-25 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-11-25-4f1e6359-11026-0 |
22d8d83d4c99ce104cfa6157ea5dd93ec4c84b81 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-11-11 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-11-11-4f1e6359-11026-0 |
2f3ef58829310ac2100a2a1af3342f96bcb8b1bf | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-10-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-10-28-4f1e6359-11026-0 |
68a2a6806e360c5259fa1f191e0c8e24510725d4 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-10-14 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-10-14-4f1e6359-11026-0 |
b4ca578e475f8b16d61e8bdcf407cbdc18fb9670 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-09-30 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-09-30-4f1e6359-11026-0 |
b7021c75e73b90026df399b5859df94eb6efc63c | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-09-09 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-09-09-4f1e6359-11026-0 |
25a1ed5725d7b81df67c7c59c5ab2c9d92222fb4 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-08-27 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-08-27-4f1e6359-11026-0 |
e8e8a4b78af7ec3753e6c68b53ece31aa97315d5 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-07-29 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-07-29-4f1e6359-11026-0 |
08bc583cddf2afd80650780639b6e7cea738688e | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-07-08 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-07-08-4f1e6359-11026-0 |
812b01d64d8c9cae61f4834077006b6b25f5f39c | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-06-24 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-06-24-4f1e6359-11026-0 |
2b59835aa95b20d3f504cf1d605bdb3ae90a7194 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-06-10 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-06-10-4f1e6359-11026-0 |
32e43f7c4a29118e299250b5fce96334fb79cad3 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-05-20 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-05-20-4f1e6359-11026-0 |
b440c3272edd638069d3a80e259692bf071de12c | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-05-07 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-05-07-4f1e6359-11026-0 |
59cab3f0d5466e13bc02e39c369ac7e7722db064 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-04-22 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-04-22-4f1e6359-11026-0 |
55b08e7d5aadfbcde269b18a59f83236eea6f18f | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-04-08 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-04-08-4f1e6359-11026-0 |
5e73e5261decd74318860572b67808a1539dc0d3 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-03-11 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-03-11-4f1e6359-11026-0 |
e2340db46aa6f087e362e91d377b71c42b89c6c4 | Residential property in London from which rental income is derived. (Registered 13 February 2013) | Land and Property 4f1e6359 | 2013-02-25 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2013-02-25-4f1e6359-11026-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");