items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2011-10-31-1f359ece-10034-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 |
---|---|---|---|---|---|---|---|
a1d76aec9fc99c2638323563def3b9c285e2009a | Payments from Wroxton College. Address: Wroxton College, Wroxton, nr. Banbury, Oxfordshire OX15 6PX.: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 0 | 2011-10-31-1f359ece-10034-0 |
e6de5ba8938f57a48f2af8a8633c044704fb18ab | Received £250 for a seminar with students. Hours: 2 hrs. (Registered 21 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 1 | 2011-10-31-1f359ece-10034-0 |
4247372f48f6c6a7b7a732805400f2a5523ba82f | Received £250 for a seminar with students. Hours: 2 hrs. (Registered 16 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 2 | 2011-10-31-1f359ece-10034-0 |
950ebedc3471746aac1561f38bbc8a52a60453eb | Occasional writing for John Wiley and Sons Ltd, The Atrium, Southern Gate, Chichester, PO19 8SQ. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 3 | 2011-10-31-1f359ece-10034-0 |
d43c40ff65990907c8ec85f0b1c61ae9e7ad1a74 | Payments from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 4 | 2011-10-31-1f359ece-10034-0 |
8a11813a6e4ff956d72f842b75e71fbacd58f375 | Payment of £50. Hours: 15 mins. Payment donated to my constituency party. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 5 | 2011-10-31-1f359ece-10034-0 |
3440bb365f79ca49e1a67e7450251b4907f8c963 | Payment of £75. Hours: 1.5 hrs. Payment donated to my constituency party. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 6 | 2011-10-31-1f359ece-10034-0 |
5b7236cf0af87069231338e5a45dc9fc69cccd2b | Payments from ComRes, 4 Millbank, London SW1P 3JA, for opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 7 | 2011-10-31-1f359ece-10034-0 |
f4ce076188255cf9e667c8f21829651f60739b94 | Payment of £75 Hours: 15 mins. Payment donated to my constituency party. (Registered 21 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 8 | 2011-10-31-1f359ece-10034-0 |
53e0c883e40c5fea4e82d8769089cfb2cb876872 | Payment of £75. Hours: 1.5 hrs. Payment donated to my constituency party. (Registered 16 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 9 | 2011-10-31-1f359ece-10034-0 |
01df562ecb4469b3b1ca584df064a494a1b33cbe | Payment of £75. Hours: 1.5 hrs. Payment donated to my constituency party. (Registered 9 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 10 | 2011-10-31-1f359ece-10034-0 |
7ae5b7449056a5e378ec94e5129be1dccf525f9e | Payment of £75. Hours: 1.5 hrs. Payment donated to my constituency party. (Registered 8 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 11 | 2011-10-31-1f359ece-10034-0 |
bc003b5cd902e17ebeaf90aabb95b459eed3a875 | Payment of £150 from Ipsos MORI, 79-81 Borough Road, London SE1 1FY, for opinion research. Hours: 1 hr. Payment donated to my constituency party. (Registered 7 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 12 | 2011-10-31-1f359ece-10034-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");