items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where "date" is on date 2023-09-04 and person_id = "uk.org.publicwhip/person/10057" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ac031edc0286b507b82d5e104725cb59cdf57418 | Flat in Worthing: (i). (Registered 04 June 2015) | Land and property portfolio: (i) value over £100,000 and/or (ii) giving rental income of over £10,000 a year 3841fe0e | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2023-09-04-3841fe0e-10057-0 | |
a9ca3f79c27bd8770f6d1856cf350e9eb20ed7cb | Cottage in Waverley: (i). (Registered 04 June 2015) | Land and property portfolio: (i) value over £100,000 and/or (ii) giving rental income of over £10,000 a year 3841fe0e | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 1 | 2023-09-04-3841fe0e-10057-0 | |
bc39d488dc2b0b0c4f564bfa0f517c5d5bb14f81 | House in London: (i). (Registered 04 June 2015) | Land and property portfolio: (i) value over £100,000 and/or (ii) giving rental income of over £10,000 a year 3841fe0e | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 2 | 2023-09-04-3841fe0e-10057-0 | |
4f86930899b6ccf1a60ed88550db59c694a07c31 | From 29 July 2022, a residential property in London: (i) and, from 1 October 2022, (ii). (Registered 12 September 2022; updated 06 October 2022) | Land and property portfolio: (i) value over £100,000 and/or (ii) giving rental income of over £10,000 a year 3841fe0e | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 3 | 2023-09-04-3841fe0e-10057-0 | |
a82cbd1bf5508b0533579bedb6f704afa614b237 | Grosvenor House (Worthing) Ltd, management of residential property. The company holds the freehold of six flats. (Registered 03 December 2018) | (i) Shareholdings: over 15% of issued share capital ead2f460 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2023-09-04-ead2f460-10057-0 | |
dde5ec74f1e860e434be943d9c803e27c6dab31e | Streetbook Ltd; an internet community communications company. (Updated 4 June 2015) | (ii) Other shareholdings, valued at more than £70,000 68d8a589 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2023-09-04-68d8a589-10057-0 | |
faa7b369189378303c8cb8dd7b4a0fb60492cbab | From 6 December 2022, HIRO Capital; a company investing in games development. (Registered 09 January 2023) | (ii) Other shareholdings, valued at more than £70,000 68d8a589 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 1 | 2023-09-04-68d8a589-10057-0 | |
1dae6e58f0f0a3093e08a60be31d48cd6c90589b | Unpaid director of Grosvenor House (Worthing) Ltd, a company which holds the freehold of six flats. (Registered 06 November 2018) | Miscellaneous 5f2cbd10 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2023-09-04-5f2cbd10-10057-0 | |
5e883c4cd8fef81f6e6d4dae5d38b12a1263b8b7 | Chairman of Trustees for the Revd Dr Busbyâs Trustees (Willen) Main Charity Ltd, which supports clergy and their families in two dioceses. (Registered 03 December 2018) | Miscellaneous 5f2cbd10 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 1 | 2023-09-04-5f2cbd10-10057-0 | |
dd681f1834fb306b94d24cde3c8affeafc4d922b | From 31 July 2019, Emeritus Assistant of the Drapers Company. Trustee for its staff pension scheme. (Registered 03 December 2018; updated 22 September 2022) | Miscellaneous 5f2cbd10 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 2 | 2023-09-04-5f2cbd10-10057-0 | |
f947c6468a2f9705c0772493eb604f5b6830f729 | Unpaid director of PbandvbLtd; no activity since incorporation on 11 January 2012. (Registered 03 December 2018) | Miscellaneous 5f2cbd10 | 2023-09-04 | Peter Bottomley uk.org.publicwhip/person/10057 | 3 | 2023-09-04-5f2cbd10-10057-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");