items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2023-07-10-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 |
---|---|---|---|---|---|---|---|
9c542131b04222d7bf1b619667abf653225e3e97 | 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-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 0 | 2023-07-10-10057ffd-11132-0 | |
d8ca00da90e5d33907aefbd96fd4903033105064 | 30 June 2022, received £677.22. Hours: 10 hrs. (Registered 04 July 2022) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 1 | 2023-07-10-10057ffd-11132-0 | |
55ba49783b0be4791c07d44a84c7de87b5fdf382 | 31 July 2022, received £1,015.68. Hours: 26 hrs. (Registered 09 August 2022) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 2 | 2023-07-10-10057ffd-11132-0 | |
2d8f487db0be3c5c2b4d5aa7aa55038b1d667ab2 | 31 August 2022, received £420.59. Hours: 8 hrs. (Registered 21 September 2022) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 3 | 2023-07-10-10057ffd-11132-0 | |
4cae113ace6642bc6cf27f9ba607948f102c561e | 31 October 2022, received £632.27. Hours: 18 hrs. (Registered 07 November 2022) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 4 | 2023-07-10-10057ffd-11132-0 | |
e38c977108760aab6d04911b7b2b19f516783cd5 | 30 November 2022, received £2,669. Hours: 68 hrs. (Registered 05 December 2022) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 5 | 2023-07-10-10057ffd-11132-0 | |
63e9cbf36c37be6739f76e6da0814ce62e429406 | 31 January 2023, received £70.25. Hours: 2 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 6 | 2023-07-10-10057ffd-11132-0 | |
cbe4b0f0295b525c055e60f1cf2b55910cb63836 | 28 February 2023, received £4,074.60. Hours: 108 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 7 | 2023-07-10-10057ffd-11132-0 | |
2da8daa8e7c5860a54cc6e99b3bf981094d8ed84 | 31 March 2023, received £1,967.03. Hours: 56 hrs. (Registered 31 March 2023) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 8 | 2023-07-10-10057ffd-11132-0 | |
622df44794853b38a6f8008642cddf7857a76f98 | 31 May 2023, received £70.25. Hours: 2 hrs. (Registered 12 June 2023) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 9 | 2023-07-10-10057ffd-11132-0 | |
a65644bd5968450e30bf0b2e6b689edd528c58fa | 30 June 2023, received £281. Hours: 8 hrs. (Registered 03 July 2023) | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 10 | 2023-07-10-10057ffd-11132-0 | |
8d21a90542c96e84c76b56050701ec2a6bb7a4de | Payments from Eden and Partners, 50 Broadway, London SW1H 0RG: | Employment and earnings 10057ffd | 2023-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 11 | 2023-07-10-10057ffd-11132-0 | |
f6015f5387d4fb350fcfe68ae26fb7d060916483 | 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-07-10 | Andrew Murrison uk.org.publicwhip/person/11132 | 12 | 2023-07-10-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");