items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2023-08-07-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 |
---|---|---|---|---|---|---|---|
eff3132e1944c3ac5c94a3f623d4eae4b1bc57e5 | 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-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 0 | 2023-08-07-10057ffd-11132-0 | |
0b42a1315755baccb46e3a9eb373b26832234934 | 31 July 2022, received £1,015.68. Hours: 26 hrs. (Registered 09 August 2022) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 1 | 2023-08-07-10057ffd-11132-0 | |
c7cb193d159a91f0d9e97d5dbee7c7d5ba80ae28 | 31 August 2022, received £420.59. Hours: 8 hrs. (Registered 21 September 2022) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 2 | 2023-08-07-10057ffd-11132-0 | |
2b2eb1daa2f8cdcdc4f34ecbfaba6126742d5a60 | 31 October 2022, received £632.27. Hours: 18 hrs. (Registered 07 November 2022) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 3 | 2023-08-07-10057ffd-11132-0 | |
09aa5e4f4d3fdcaf2e75d2135fa25a53d34c7f37 | 30 November 2022, received £2,669. Hours: 68 hrs. (Registered 05 December 2022) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 4 | 2023-08-07-10057ffd-11132-0 | |
4900ecf942aa4d1ccc569d1dec7397aace0cec7c | 31 January 2023, received £70.25. Hours: 2 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 5 | 2023-08-07-10057ffd-11132-0 | |
82817f9c6a2c34851a8ecbb5d9ee1394e8a74e1e | 28 February 2023, received £4,074.60. Hours: 108 hrs. (Registered 03 March 2023) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 6 | 2023-08-07-10057ffd-11132-0 | |
6048beaca7110f568670c3a8f3b30b420867e2ae | 31 March 2023, received £1,967.03. Hours: 56 hrs. (Registered 31 March 2023) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 7 | 2023-08-07-10057ffd-11132-0 | |
48eee6ee6140456232daad1613b17c42fe1f9046 | 31 May 2023, received £70.25. Hours: 2 hrs. (Registered 12 June 2023) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 8 | 2023-08-07-10057ffd-11132-0 | |
2a968d3a1612cb1dc1fda489702b1e252aedea93 | 30 June 2023, received £281. Hours: 8 hrs. (Registered 03 July 2023) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 9 | 2023-08-07-10057ffd-11132-0 | |
1bc96aa81756344d351916dccbd71d0731d30985 | 31 July 2023, received £1,053.78. Hours: 32 hrs. (Registered 02 August 2023) | Employment and earnings 10057ffd | 2023-08-07 | Andrew Murrison uk.org.publicwhip/person/11132 | 10 | 2023-08-07-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");