items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2010-03-24-1f359ece-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 |
---|---|---|---|---|---|---|---|
427ed6dfeee3cbe0d7b0103a46d9e2a36df78825 | Surgeon Commander Royal Naval Reserve. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 0 | 2010-03-24-1f359ece-11132-0 |
a477318a1cccb6bff4a3b2bd78ad18de6d7d2335 | Received £592.38 for September. Hours: 16 hrs. (Registered 5 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 1 | 2010-03-24-1f359ece-11132-0 |
09cdf5211ffcf536cc7ba03cd7cbfa4ce08fe93d | Received £888.54 for September. Hours: 24 hrs. (Registered 25 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 2 | 2010-03-24-1f359ece-11132-0 |
832f2a7f81f733471bb8407b16d62edc724f2fed | Parliamentary adviser to Wessex Pharmaceutical Group. Address: 4 Old Bath Road, Sonning, RG4 6TA. No honorarium drawn since 2008. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 3 | 2010-03-24-1f359ece-11132-0 |
b17ccb67a0e7acb9c737393be5edfe07e603037b | Received fee of £150 for completing a survey for Ipsos Mori, 79-81 Borough Road, London, SE1 1FY. Hours: 1hr. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 4 | 2010-03-24-1f359ece-11132-0 |
cfc9ccd0ee2f9b85037ecfe9d2a63caeaed3a7a3 | Received fee of £50 for completing a survey for PSA. Hours: 20mins. Fee donated to charity. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 5 | 2010-03-24-1f359ece-11132-0 |
56c33a4d88b644683a7591124d653984bdb3633f | BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 6 | 2010-03-24-1f359ece-11132-0 |
b4c17abcc68aa8949a97534a6708bb2361167a4b | Received fee of £75 for completing a survey Hours: 30mins. Fee donated to my local Party. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 7 | 2010-03-24-1f359ece-11132-0 |
115012d105ca25503f863e98a9030402a2b849db | Received fee of £75 for completion of a survey. Hours: 30 mins. (Registered 15 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 8 | 2010-03-24-1f359ece-11132-0 |
f887de6b3715c508aa3fdb05e5f8b825965f323d | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 9 | 2010-03-24-1f359ece-11132-0 |
8be4a5daedf78931163d480a1d72f47fb3619eee | Received fee of £75 for completing a survey. Hours: 30mins. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 10 | 2010-03-24-1f359ece-11132-0 |
e9ba8e3dc3bdf2e687bc1a4cb99a6f50b5677748 | Received fee of £75 for completing a survey. Hours: 30 mins. (Registered 27 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 11 | 2010-03-24-1f359ece-11132-0 |
39675f2c52e74561087e049b91e63cc49ee00d33 | Received fee of £75 for completing a survey. Hours: 25 mins. (Registered 27 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 12 | 2010-03-24-1f359ece-11132-0 |
6300a681dfc1c783ab794c73269934b2490081fa | Received fee of £75 for completion of survey. Hours: 30 mins. (Registered 15 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 14 | 2010-03-24-1f359ece-11132-0 |
6bfb7377ac64a5b7a3fc036fb0cbc7d2362fd6e0 | Received fee of £50 for completing a survey for Populus Ltd, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 20mins. Fee donated to charity. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 15 | 2010-03-24-1f359ece-11132-0 |
019c687b3463ffa8fcdc0188c192af81bd06c614 | Received fee of £50 for completing a survey for Opinion Leader, 4 th Floor, Holborn Gate, 26 Southampton Buildings, London, WC2A 1AH. Hours: 15mins. Fee donated to charity. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 16 | 2010-03-24-1f359ece-11132-0 |
0135336f60bde538f2c4aded65d079d6fdc8819b | Received fee of £75 for completing a survey for Populus Ltd, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 20mins. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 17 | 2010-03-24-1f359ece-11132-0 |
ba88b0e80854d0b07061f5109a62e578511cc5dd | Received fee of £30 for completing a survey for Opinion Leader, 4 th Floor, Holborn Gate, 26 Southampton Buildings, London, WC2A 1AH. Hours: 20mins. Fee donated to charity. (Registered 2 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Andrew Murrison uk.org.publicwhip/member/1922 | Andrew Murrison uk.org.publicwhip/person/11132 | 18 | 2010-03-24-1f359ece-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");