items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-1f359ece-10326-5" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 9a10d227397732680d22cedc0ad3aae0a12d6877 | Professor of Practice at London School of Economics with effect from 1 September 2014. The position will include teaching with LSE Cities programmes and with the Department of Government. Payment at 0.2FTE rate: £20 000 per annum. (Registered 1 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 0 | 2015-03-30-1f359ece-10326-5 |
| 993f895975cb60f43879851c07d1636859905e8b | Received £1,730.67. Hours: 7 hrs, including travel. (Registered 20 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 1 | 2015-03-30-1f359ece-10326-5 |
| 602d93030ec167d5a15e5299248721fed6225f62 | Received £1,730.67. Hours: 21 hrs. (Registered 17 November 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 2 | 2015-03-30-1f359ece-10326-5 |
| 3d469c37840f33771d08cafa765803cfec77e420 | Received £1,760.67. Hours: 30 hrs, including travel. (Registered 15 December 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 3 | 2015-03-30-1f359ece-10326-5 |
| c0d4e0f422ce47033668f99f1c1cde68d6522337 | Received £1,760. Hours: 30 hrs, including travel, in December 2014. (Registered 14 January 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 4 | 2015-03-30-1f359ece-10326-5 |
| 0dfb8ba1578ac8ff7a14a6dc2ae569fb5ead5461 | Received £1,760 in January 2015. Hours: 16 hrs, including travel and preparation. (Registered 16 February 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 5 | 2015-03-30-1f359ece-10326-5 |
| 6de09270cda35522f9050c989c0008749946199e | Received £1,760 for February 2015. Hours: 8 hrs, including travel and preparation. (Registered 23 March 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Tessa Jowell uk.org.publicwhip/member/40212 | Tessa Jowell uk.org.publicwhip/person/10326 | 6 | 2015-03-30-1f359ece-10326-5 |
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");