items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where category_id = "1f359ece" and person_id = "uk.org.publicwhip/person/10032" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: item, date, member_id, sort_order, record_id, date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
500fffac515b50fb47fb7f1a6c31ac2f9f6c17bd | Occasional journalism and media appearances. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Anne Begg uk.org.publicwhip/member/32 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2000-11-10-1f359ece-10032-0 |
344fb8efeae1c0e6ebb0647f7803a76f4d416143 | Occasional lectures at the Civil Service College. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Anne Begg uk.org.publicwhip/member/32 | Anne Begg uk.org.publicwhip/person/10032 | 1 | 2000-11-10-1f359ece-10032-0 |
7147018ee58e0811c02373b8ea5e78caf7a13ed5 | Occasional journalism and media appearances. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Anne Begg uk.org.publicwhip/member/32 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2001-05-14-1f359ece-10032-0 |
d0ab6aa992e454526f90c6c8f1fa1a93e28e5ca9 | Occasional journalism and media appearances. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Anne Begg uk.org.publicwhip/member/722 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2002-05-14-1f359ece-10032-0 |
090bc4956630bc87361b09a35056bf182eef5c2c | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2009-10-14-1f359ece-10032-0 |
a15b4f5313388ae2fc8a4d4525eed26459920408 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2009-10-28-1f359ece-10032-0 |
aca81a6b14a1054054be1b3d4629a0de25652c3b | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2009-11-11-1f359ece-10032-0 |
9cf0e79219f47fa32edd88445a1e6847d3d7bb35 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2009-11-25-1f359ece-10032-0 |
654aadeb817d4cda9dd273e4b74323d116bb4393 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2009-12-10-1f359ece-10032-0 |
5e4c6878f1ca6fc9d20b6c0a4bde69f175da96be | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-01-06-1f359ece-10032-0 |
a2ce62b3ebacc4af3fd792a034b596d57bb2b373 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-02-03-1f359ece-10032-0 |
be2055fb319b56f606576ae8fac424a82bf764c2 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-02-24-1f359ece-10032-0 |
c5faeb4b8fc340ad41d2a070896c2efd52b5fd8e | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-03-10-1f359ece-10032-0 |
2f3cda6cfdfbf533dc9fcf9e3ebbf96d76e202c7 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-03-24-1f359ece-10032-0 |
8ef882c9b2df33b63b859b1311282362f8941d3c | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Anne Begg uk.org.publicwhip/member/1956 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-04-12-1f359ece-10032-0 |
94c6e6f7ec3d63379285206d39f8de4f64e82dc0 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Anne Begg uk.org.publicwhip/member/40037 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-09-06-1f359ece-10032-0 |
be26efd870713cb2c98454f270fdb9e88b023869 | Fee of £75 received from Ipsos MORI for completion of survey. Hours: 1 hr. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. (Registered 4 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-10-25 | Anne Begg uk.org.publicwhip/member/40037 | Anne Begg uk.org.publicwhip/person/10032 | 0 | 2010-10-25-1f359ece-10032-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");