items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2012-10-01-1f359ece-10171-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 |
---|---|---|---|---|---|---|---|
ef4f2ec4f850a810cf8c8074be754c72de93da87 | Payment of £600 plus £68.45 travel costs from Cumberlege Connections, Snells Cottage, The Green, Newick, Lewes, East Sussex BN8 4LA, for a talk to NHS staff in Preston in September 2011. Hours: 4 hrs, including delivery, preparation and some travelling time. (Registered 21 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 0 | 2012-10-01-1f359ece-10171-0 |
826aa933a44d75bcc28809f0c0f914a5121a1867 | Payments from Ipsos Mori, 79-81 Borough Road, London SE1 1FY, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 1 | 2012-10-01-1f359ece-10171-0 |
f68b070218507799113d80f2c42a8a15cbdf7f77 | 2009, payment of £150. Hours: 1 hr 15 mins. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 2 | 2012-10-01-1f359ece-10171-0 |
ee454e2ae118c45654f56f7cb007269646adc29e | 2010, payment of £150. Hours: 1 hr 15 mins. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 3 | 2012-10-01-1f359ece-10171-0 |
df6dd9b5e92edf4c19b6014c77b1c693417abaa9 | July 2011, payment of £150. Hours: 1 hr 15 mins. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 4 | 2012-10-01-1f359ece-10171-0 |
8e84e6f2ca2c53c851e9bb89ca1be00efa2a2a01 | December 2011, payment of £150. Hours: 1 hr 15 mins. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 5 | 2012-10-01-1f359ece-10171-0 |
ad49ade72db02d56210b509aad16eadcb85eeb53 | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 6 | 2012-10-01-1f359ece-10171-0 |
aa779f1fff47d81b142afe45cfd3920da0b4a1f3 | July 2011, payment of £75. Hours: under 1 hr. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 7 | 2012-10-01-1f359ece-10171-0 |
171c26a2c620914e343a4f367062cd01c74ba628 | November 2011, payment of £75. Hours: under 1 hr. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 8 | 2012-10-01-1f359ece-10171-0 |
6cf36e8f133c3362c01058092166ea66c18e6c1c | January 2012, payment of £75. Hours: under 1 hr. Payment made direct to local charity. (Registered 28 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Frank Dobson uk.org.publicwhip/member/40319 | Frank Dobson uk.org.publicwhip/person/10171 | 9 | 2012-10-01-1f359ece-10171-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");