items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2015-02-09-1f359ece-24853-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 |
---|---|---|---|---|---|---|---|
a7c198ffd8be393c508444b4d7b36cab4366f69f | I am a partner in G E Sturdy & Son; a farming partnership. Address: Westgate Farm, North Deighton, Wetherby, LS22 4EN. I provide administrative support for the partnership, as well as doing some buying and selling at certain times. This amounts to no more than 4 hours a week. | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 0 | 2015-02-09-1f359ece-24853-0 |
941f523f2d43739556c9b26594650b3966fbc052 | January 2014, I received £500. (Registered 11 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 1 | 2015-02-09-1f359ece-24853-0 |
14eb8b50a50f35ef362afd9152892875bfefa191 | February 2014, I received £500. (Registered 11 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 2 | 2015-02-09-1f359ece-24853-0 |
476adb375a4ec34bfd5f1cdb9441b08671566308 | March 2014, I received £500. (Registered 19 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 3 | 2015-02-09-1f359ece-24853-0 |
75807f4793a69acbfa9cbfbcb0aaec75ebe14f91 | April 2014, I received £500. (Registered 19 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 4 | 2015-02-09-1f359ece-24853-0 |
c831959f178de6e487cd47b42b01c51a571e869b | May 2014, I received £500 . (Registered 17 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 5 | 2015-02-09-1f359ece-24853-0 |
0238285c2b9a7994aef1426d5b2d5f488a36861c | June 2014, I received £500 . (Registered 17 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 6 | 2015-02-09-1f359ece-24853-0 |
107cc83fb1efca99d26705e608d12e5557198a2f | July 2014, I received £500. (Registered 2 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 7 | 2015-02-09-1f359ece-24853-0 |
d9bd98beec4fe2e76df9ffdc963c84b792bfce6d | August 2014, I received £500. (Registered 2 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 8 | 2015-02-09-1f359ece-24853-0 |
47e76e35cbf411a2f915305c75c7741c78131c9a | October, I received £500. (Registered 8 January 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 9 | 2015-02-09-1f359ece-24853-0 |
e5d36659f38be95cf03ddbbecc39cdf361fbcd75 | November, I received £500. (Registered 8 January 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 10 | 2015-02-09-1f359ece-24853-0 |
d7a949c8ab6ca9a2166c8291fac14fe78c3b3a8f | December, I received £500. (Registered 8 January 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 11 | 2015-02-09-1f359ece-24853-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");