items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-8f616a6e-24850-6" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
978025012f365b199973887d113c047c6614c357 | Name of donor: PriceWaterhouse Coopers LLP | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2015-03-30-8f616a6e-24850-6 |
f1f5e2a410063c4b944fd8c9366f06b8a89389c0 | Address of donor: 1 Embankment Place, London WC2N 6RH | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2015-03-30-8f616a6e-24850-6 |
68b659f536dc4e8cf91972661fe1d049ba14e23d | Amount of donation or nature and value if donation in kind: Services of a research assistant 19 January 2015 to 27 March 2015, total value £26,250 | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2015-03-30-8f616a6e-24850-6 |
6194b306795e58a30b53e3485dbac2cf5276c7fc | Date of receipt: 13 January 2015 | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2015-03-30-8f616a6e-24850-6 |
af0d7c8bff5f661bccd002f710803c6db7453bda | Date of acceptance: 13 January 2015 | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2015-03-30-8f616a6e-24850-6 |
c5304f579408bbb355bdc4fc510ee8a11cbecec3 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2015-03-30-8f616a6e-24850-6 |
25fc44199bdc1ea69ed066099acf5307b9e7fa7e | ( Registered 29 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2015-03-30-8f616a6e-24850-6 |
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");