items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2011-02-07-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 |
---|---|---|---|---|---|---|---|
7d40b705470b2a43e6bb2c2e4a6e272cb90bd6cf | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-02-07-8f616a6e-10259-0 |
52323859689e39d1d3f685d53d3c3293e638f0f4 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-02-07-8f616a6e-10259-0 |
203913e7ef93cfc71a54520bbbdd418e8fd4bf5a | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-02-07-8f616a6e-10259-0 |
c4b065294332fe82af8da45210f256b4af16b25a | 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-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-02-07-8f616a6e-10259-0 |
534fb1a6a298ef148f33ab7228e7905311e444f5 | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-02-07-8f616a6e-10259-0 |
dbee1db28daf8d53e18abbc64270d4afe6406292 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-02-07-8f616a6e-10259-0 |
910e67ab050811ec9e410ce6b8b5773572056d98 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-02-07-8f616a6e-10259-0 |
c64ab6501ea2dc2323a2200cc411ae00aaf28393 | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-02-07-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");