items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2011-01-24-8f616a6e-10259-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 |
---|---|---|---|---|---|---|---|
5adb5ba09cca17935bb07b8ce01ab3905e84f0f0 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-01-24-8f616a6e-10259-0 |
2d3c05054ed65a794080517a59235d8a3d2f62d4 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-01-24-8f616a6e-10259-0 |
49be7ebe3bebf7fd16d1fa7807a144006548ac86 | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-01-24-8f616a6e-10259-0 |
15d94ebcad8fad9fd2bf0a644f650aeb86e7ece4 | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-01-24-8f616a6e-10259-0 |
6891f6c303fa1d5a7e799c7ce630c25c804d93ca | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-01-24-8f616a6e-10259-0 |
443e845ea48f1f35d5844a05a94ad0f695d73b99 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-01-24-8f616a6e-10259-0 |
a072675eb6818cbbd688faf3afc875f47e14d7e2 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-01-24-8f616a6e-10259-0 |
c5584b4e4c48d3575fe2fa14fc1e5d1df69e29dd | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-01-24-8f616a6e-10259-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");