items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2012-02-20-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 |
---|---|---|---|---|---|---|---|
d252e4af1708f50a9734a1b3961714c7435fdf66 | 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 | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 0 | 2012-02-20-1f359ece-24853-0 |
dbdf866af44c9a2a10318f1896262e85889454d6 | January 2011, I received £200 | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 1 | 2012-02-20-1f359ece-24853-0 |
60163bb1c28b7732de3369d34c75b044333af599 | February 2011, I received £200 | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 2 | 2012-02-20-1f359ece-24853-0 |
5957968f21426abd90aa3953d23bd71a75104373 | (Registered 2 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 3 | 2012-02-20-1f359ece-24853-0 |
45809572c9e01f709798025b88579006f99b0abd | March 2011, I received £200. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 4 | 2012-02-20-1f359ece-24853-0 |
0cab2a16f15bebe84e245f1bbee400b05251b698 | April 2011, I received £200. (Registered 17 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 5 | 2012-02-20-1f359ece-24853-0 |
8b037556eff6d47276c4bec6ea7742f87b1aede8 | May 2011, I received £200. | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 6 | 2012-02-20-1f359ece-24853-0 |
478952a66e4c77d0b21451f39710c6e13b19f46a | June 2011, I received £200. | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 7 | 2012-02-20-1f359ece-24853-0 |
4b128d276c742bdac659894dfaf001381a298d22 | (Registered 4 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 8 | 2012-02-20-1f359ece-24853-0 |
bf2f516f11126401292517c6ed2bcea4b09fb0c4 | July 2011, I received £500 | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 9 | 2012-02-20-1f359ece-24853-0 |
c9eb9ef5da05146bf8a40d864a8a0756175861f2 | August 2011, I received £500 | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 10 | 2012-02-20-1f359ece-24853-0 |
283b436e64536b690e6c80565626547de4d5b7bb | (Registered 5 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 11 | 2012-02-20-1f359ece-24853-0 |
98f266036bd254d37b442fbc0deee50a293c618d | September 2011, I received £500 (Registered 25 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 12 | 2012-02-20-1f359ece-24853-0 |
dc07b0741cdb129a5e656b36b6b7fc6e749f07ef | October 2011, I received £500 (Registered 13 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 13 | 2012-02-20-1f359ece-24853-0 |
2f51ce265293b158891ae41ebc4a3f1c5d14e87b | November 2011, I received £500 (Registered 13 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 14 | 2012-02-20-1f359ece-24853-0 |
8d7f96f45772870f387f196928479087d522e437 | December 2011, I received £500 (Registered 19 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Julian Sturdy uk.org.publicwhip/member/40683 | Julian Sturdy uk.org.publicwhip/person/24853 | 15 | 2012-02-20-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");