items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2023-06-26-10057ffd-11132-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
443cbf2b3046cea70999b0f82c4e95cd21278615 | Surgeon Commander Royal Naval Reserve, HMS President, St Katherineâs Dock, London. (Updated 15 January 2014 and 2 October 2015) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 0 | 2023-06-26-10057ffd-11132-0 | |
17373f6ed5ea71d027afa4241d8eaee2d31b3c0a | 31 May 2022, received £203.13. Hours: 6 hrs. (Registered 13 June 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 1 | 2023-06-26-10057ffd-11132-0 | |
0348ac0f0e3f6bce0cb67d75e58f10eaf36af218 | 30 June 2022, received £677.22. Hours: 10 hrs. (Registered 04 July 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 2 | 2023-06-26-10057ffd-11132-0 | |
d71f60100664e0bd3d1f5773cbe6e9fa95d96512 | 31 July 2022, received £1,015.68. Hours: 26 hrs. (Registered 09 August 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 3 | 2023-06-26-10057ffd-11132-0 | |
b4695fedabeab7af1120401622ce179a97112253 | 31 August 2022, received £420.59. Hours: 8 hrs. (Registered 21 September 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 4 | 2023-06-26-10057ffd-11132-0 | |
c183dc617067a4acdc13d2aad1f0190c3621b297 | 31 October 2022, received £632.27. Hours: 18 hrs. (Registered 07 November 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 5 | 2023-06-26-10057ffd-11132-0 | |
dccae8b3f0fc029ba62956c7b604f06cf5bb1f80 | 30 November 2022, received £2,669. Hours: 68 hrs. (Registered 05 December 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 6 | 2023-06-26-10057ffd-11132-0 | |
85b79df197b43e6325443301b4af86826ab2c8f9 | 31 January 2023, received £70.25. Hours: 2 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 7 | 2023-06-26-10057ffd-11132-0 | |
230db2c1fdb77a65145735c5836b711ddf1bc065 | 28 February 2023, received £4,074.60. Hours: 108 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 8 | 2023-06-26-10057ffd-11132-0 | |
f84ee5df2dad2c02efa1c6d3090630691ca0a182 | 31 March 2023, received £1,967.03. Hours: 56 hrs. (Registered 31 March 2023) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 9 | 2023-06-26-10057ffd-11132-0 | |
7e3dd921353fe28625d59e775bcd20a02d275f09 | 31 May 2023, received £70.25. Hours: 2 hrs. (Registered 12 June 2023) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 10 | 2023-06-26-10057ffd-11132-0 | |
6e2d64e964d37bfe67010b468a043815277a82d1 | Payments from Eden and Partners, 50 Broadway, London SW1H 0RG: | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 11 | 2023-06-26-10057ffd-11132-0 | |
180bcd9d227b9744e840c9f4fd7fc31768bd5786 | Payment of £200 expected for participation in a symposium on 10 May 2022. Hours: 1.5 hrs. Fee will be paid direct to charity. (Registered 18 July 2022) | Employment and earnings 10057ffd | 2023-06-26 | Andrew Murrison uk.org.publicwhip/person/11132 | 12 | 2023-06-26-10057ffd-11132-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");