items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2023-10-30-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 |
---|---|---|---|---|---|---|---|
4409b4ae66c7ea13e5a87941c57e2266a62bd989 | 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-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 0 | 2023-10-30-10057ffd-11132-0 | |
cc22c80eb469d4d3c3ecfee07e07d235762fd239 | 31 October 2022, received £632.27. Hours: 18 hrs. (Registered 07 November 2022) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 1 | 2023-10-30-10057ffd-11132-0 | |
30e1f6cf424d381f90612e1d72c39220dc0d0193 | 30 November 2022, received £2,669. Hours: 68 hrs. (Registered 05 December 2022) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 2 | 2023-10-30-10057ffd-11132-0 | |
1370337bcec6cbe9c36a10a90e437dcdd5be9b5f | 31 January 2023, received £70.25. Hours: 2 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 3 | 2023-10-30-10057ffd-11132-0 | |
7f1caa2121d3fd4b32286e12c42318d92c718adc | 28 February 2023, received £4,074.60. Hours: 108 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 4 | 2023-10-30-10057ffd-11132-0 | |
cbbfdc62398b350ae41e5f2d5835d83ef8914399 | 31 March 2023, received £1,967.03. Hours: 56 hrs. (Registered 31 March 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 5 | 2023-10-30-10057ffd-11132-0 | |
5d3b7ed429b5e4010f8ba30e6d8f955427519dbc | 31 May 2023, received £70.25. Hours: 2 hrs. (Registered 12 June 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 6 | 2023-10-30-10057ffd-11132-0 | |
9fe8ac21a3cfd898d6f525ad07b9ac94ba2ae75d | 30 June 2023, received £281. Hours: 8 hrs. (Registered 03 July 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 7 | 2023-10-30-10057ffd-11132-0 | |
c863957dc61e1a4613760cec915d7b1c3ba8177f | 31 July 2023, received £1,053.78. Hours: 32 hrs. (Registered 02 August 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 8 | 2023-10-30-10057ffd-11132-0 | |
2d8386242bb8af7780df9b99dd6b9f8fc79aed98 | 31 August 2023, received £1,287.54. Hours: 26 hrs. (Registered 04 September 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 9 | 2023-10-30-10057ffd-11132-0 | |
a658edd5318a51b7a1a21085cecba29f536b46b9 | 30 September 2023, received £530.66. Hours: 16 hrs. (Registered 06 October 2023) | Employment and earnings 10057ffd | 2023-10-30 | Andrew Murrison uk.org.publicwhip/person/11132 | 10 | 2023-10-30-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");