items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2012-06-25-1aeb07b2-24954-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 |
---|---|---|---|---|---|---|---|
047032f98237074c1bd2c3b5027a34f7056e0ece | Eden Group Ltd 155 Moorgate London EC2M 6XB | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2012-06-25-1aeb07b2-24954-0 |
551c9e4a6add08a1b1b1c3a000f1c61642262ee1 | Received £1,666 for the month of December 2010. Hours: 4. (Registered 15 August 2011) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 1 | 2012-06-25-1aeb07b2-24954-0 |
bc98fd993579a3317e23c32cd785d6df586c5192 | Received £1,666.66 for the month of January 2011. Hours: 4 hrs. (Registered 15 August 2011) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 2 | 2012-06-25-1aeb07b2-24954-0 |
837b0bf8a55761caa9625f262822c3b51a768aab | Received £3,333.33 for months of February and March 2011. Hours: 8 hrs. (Registered 15 August 2011) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 3 | 2012-06-25-1aeb07b2-24954-0 |
e7cd6202fb647612942fc4db55406de2a513c519 | Received £1,666.66 for the month of June 2011. Hours: 4 hrs. (Registered 15 August 2011) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 4 | 2012-06-25-1aeb07b2-24954-0 |
d517ff43d869118964106dbff4fe0f4a60c2b4fb | Received £3,333.33 for the month of July 2011. Hours: 8 hrs. (Registered 15 August 2011) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 5 | 2012-06-25-1aeb07b2-24954-0 |
76ca009825c56a6860e0b1cfa0bbb7f08f211b24 | Received £2,617 on 30 September 2011 for months of August and September 2011. Hours: 6 hrs. (Registered 25 October 2011) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 6 | 2012-06-25-1aeb07b2-24954-0 |
1873136fc9dfc3893db532df8c69ccc958cc35c6 | Received £1,900 on 30 December 2011 for months of October, November and December 2011. Hours: 12 hrs. (Registered 11 January 2012) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 7 | 2012-06-25-1aeb07b2-24954-0 |
ce20ae8357dc196fa3497a0a75b9541f216c58ca | Received £1,900 on 30 March 2012 for months of January, February and March 2012. Hours: 12 hrs. (Registered 12 April 2012) | Directorships 1aeb07b2 | 2012-06-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 8 | 2012-06-25-1aeb07b2-24954-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");